<div dir="ltr">Search router configuration<div><br></div><div>Hello people. I need your help. I am new to mapbender. First of all i am not a programmer so feel free to treat me like i dont know anything about servers and databases. </div><div><br></div><div><br></div><div>2-3 months ago i started taking aerial images of small county in Croatia. It took me two weeks  (6 batteries a day) with phantom 4 advanced to take all photos (about 25000). I made ortomosaics using AGISOFT and processed 25 TIFFs with ybcbr pyramids. Made my own apache geoserver and published it online using NOIP virtual static address.</div><div><br></div><div>So i heard about mapbender and  started using it almost a month ago and i followed all tutorials.<br></div><div>That being said i managed to visualize all my raster and vector (geoserver WMS) data. </div><div>In my vector data in qgis i used concat function to insert into "source" field:</div><div><img src="xxxxxxxx" width="100" height="auto"></div><div>so mapbender getfeatureinfo now displays images when getting feature info. </div><div>(Please include that in the documentation as an option i had to figure that one on my own)</div><div><br></div><div>On the next step i got stuck:</div><div><br></div><div>So next was getting SearchRouter and Digitizer to work. This is where i got stuck.</div><div>my config.yml file:</div><div><br></div><div><font size="1" color="#ff0000">imports:<br>    - { resource: parameters.yml }<br>    - { resource: security.yml }<br>#Uncomment then next line if you have problems using an oracle database with mapbender.<br>#   - { resource: oracle.yml }<br><br>framework:<br>    #esi:             ~<br>    translator:      { fallback: %fallback_locale% }<br>    secret:          %secret%<br>    router:<br>        resource: "%kernel.root_dir%/config/routing.yml"<br>        strict_requirements: %kernel.debug%<br>    form:            true<br>    csrf_protection: true<br>    validation:      { enable_annotations: true }<br>    templating:      { engines: ['twig'] } #assets_version: SomeVersionScheme<br>    default_locale:  %locale%<br>    session:<br>        cookie_httponly: true<br>        cookie_secure: %cookie_secure%<br>        cookie_lifetime: %cookie_lifetime%<br><br><br># Twig Configuration<br>twig:<br>    strict_variables: %kernel.debug%<br>    form_themes:<br>       - MapbenderCoreBundle:form:fields.html.twig<br><br># Doctrine Configuration<br>doctrine:<br>    dbal:<br>        default_connection: default<br>        connections:<br>            default:<br>                driver:   %database_driver%<br>                host:     %database_host%<br>                port:     %database_port%<br>                dbname:   %database_name%<br>                path:     %database_path%<br>                user:     %database_user%<br>                password: %database_password%<br>                persistent: true<br>                charset:  UTF8<br>                logging: %kernel.debug%<br>                profiling: %kernel.debug% <br>                driver:   kernel.debug%<br>            PrimostenGIS:<br>                driver:   %database2_driver%<br>                host:     %database2_host%<br>                port:     %database2_port%<br>                dbname:   %database2_name%<br>                path:     %database2_path%<br>                user:     %database2_user%<br>                password: %database2_password%<br>                persistent: true<br>                charset:  UTF8<br>                logging: %kernel.debug%<br>                profiling: %kernel.debug%   <br>                driver:   kernel.debug%                <br>    orm:<br>        auto_generate_proxy_classes: %kernel.debug%<br>        auto_mapping: true<br><br># Swiftmailer Configuration<br>swiftmailer:<br>    transport: %mailer_transport%<br>    host:      %mailer_host%<br>    username:  %mailer_user%<br>    password:  %mailer_password%<br>    spool:     { type: memory }<br><br># FOM Manager Configuration<br>fom_manager:<br>    route_prefix: /manager<br><br># see <a href="https://github.com/mapbender/fom/blob/master/src/FOM/UserBundle/CONFIGURATION.md#extension-configuration">https://github.com/mapbender/fom/blob/master/src/FOM/UserBundle/CONFIGURATION.md#extension-configuration</a><br>fom_user:<br>    selfregister: false<br>    reset_password: true<br>    max_reset_time: 1<br><br># see <a href="https://github.com/mapbender/owsproxy3/blob/master/CONFIGURATION.md#extension-configuration">https://github.com/mapbender/owsproxy3/blob/master/CONFIGURATION.md#extension-configuration</a><br>ows_proxy3_core:<br>    logging: %ows_proxy3_logging%<br>    obfuscate_client_ip: %ows_proxy3_obfuscate_client_ip%<br>    proxy:<br>        host: %ows_proxy3_host%<br>        port: %ows_proxy3_port%<br>        connecttimeout: %ows_proxy3_connecttimeout%<br>        timeout: %ows_proxy3_timeout%<br>        user: %ows_proxy3_user%<br>        password: %ows_proxy3_password%<br>        checkssl: true<br>        noproxy: %ows_proxy3_noproxy%<br><br></font></div><div>my parameters.yml file:</div><div><br></div><div><font color="#ff00ff">parameters:<br>### todo: switch to using dsn urls, see <a href="https://www.doctrine-project.org/projects/doctrine-dbal/en/2.9/reference/configuration.html#connecting-using-a-url">https://www.doctrine-project.org/projects/doctrine-dbal/en/2.9/reference/configuration.html#connecting-using-a-url</a><br>###       To avoid suprises, a DSN can be constructed here from parts, at least for the shipping default parameters<br>###       Connection definition in config.yml should only use url: %database_dsn% though<br><br>    database_driver:   pdo_sqlite<br>    database_host:     ~<br>    database_port:     ~<br>    database_name:     ~<br>    database_path:     %kernel.root_dir%/db/demo.sqlite<br>    database_user:     ~<br>    database_password: ~<br>#database connection PrimostenGIS<br>    database2_driver:   pdo_pgsql<br>    database2_host:     xxxx<br>    database2_port:     5432<br>    database2_name:     PrimostenGIS<br>    database2_path:     ~<br>    database2_user:     postgres<br>    database2_password: xxxx<br><br>    mailer_transport:  smtp<br>    mailer_host:       localhost<br>    mailer_user:       ~<br>    mailer_password:   ~<br><br>    # locale en, de, it, es, ru, nl, pt are available<br>    fallback_locale:   en<br>    locale:            en<br>    secret:            ThisTokenIsNotSoSecretChangeIt<br><br>    ## Legacy branding / versioning params.<br>    ## This is no longer used for versioning Mapbender and will never be updated<br>    ## again for a Mapbender release.<br>    ## For BC / continuity, you may still use these variables to brand / version your project.<br>    ## For summary information / discussion see <a href="https://github.com/mapbender/mapbender/pull/1012">https://github.com/mapbender/mapbender/pull/1012</a><br>    ## For full project branding / versioning options, see code comment:<br>    ## <a href="https://github.com/mapbender/mapbender/blob/42e0f8b9a8031118719fc4881a92f0adab4ebacf/src/Mapbender/CoreBundle/DependencyInjection/Compiler/ProvideBrandingPass.php#L17">https://github.com/mapbender/mapbender/blob/42e0f8b9a8031118719fc4881a92f0adab4ebacf/src/Mapbender/CoreBundle/DependencyInjection/Compiler/ProvideBrandingPass.php#L17</a><br>    fom: ~<br><br>    # framework : <a href="http://symfony.com/doc/2.8/reference/configuration/framework.html#cookie-lifetime">http://symfony.com/doc/2.8/reference/configuration/framework.html#cookie-lifetime</a><br>    cookie_secure: false<br>    cookie_lifetime: 3600<br><br># OWSProxy Configuration<br># see <a href="https://github.com/mapbender/owsproxy3/blob/master/CONFIGURATION.md#extension-configuration">https://github.com/mapbender/owsproxy3/blob/master/CONFIGURATION.md#extension-configuration</a><br>    ows_proxy3_logging: false<br>    ows_proxy3_obfuscate_client_ip: true<br>    ows_proxy3_host: ~<br>    ows_proxy3_port: ~<br>    ows_proxy3_connecttimeout: 60<br>    ows_proxy3_timeout: 90<br>    ows_proxy3_user: ~<br>    ows_proxy3_password: ~<br>    ows_proxy3_noproxy: ~<br><br>    # default layer order when creating *new* WMS layerset instances<br>    # allowed values are either<br>    # * "standard": Traditional Mapbender behaviour: top-down rendering in GetCapabilities order;<br>    #               also the default if this parameter is not defined<br>    # * "reverse": bottom-up, for QGIS server, ArcGIS etc<br>#     wms.default_layer_order: standard</font><br></div><div><font color="#ff00ff"><br></font></div><div><a href="http://localhost/mapbender/app_dev.php/_profiler/0cb26e?panel=exception">http://localhost/mapbender/app_dev.php/_profiler/0cb26e?panel=exception</a><font color="#ff00ff"><br></font></div><div>gives me and error:</div><div><br></div><div><h1 style="margin:0px 0px 12px;font-size:21px;font-weight:normal;font-family:Helvetica,Arial,sans-serif">An exception occurred while executing 'SELECT t."id", t."fid", t."source", ST_AsGeoJSON(ST_Transform(t."geom", ?::int)) as geom FROM Grobovi t WHERE (LOWER(<a href="http://t.id">t.id</a>) LIKE LOWER(?)) AND (ST_Transform(ST_SetSRID(ST_MakeBox2D(ST_Point(?, ?), ST_Point(?, ?)), ?), ST_Srid(t."geom")) && t."geom")' with params [3765, "%1%", 453116, 4826755, 463251, 4828604, 3765]:<br><br>SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "grobovi" does not exist<br>LINE 1: ...SON(ST_Transform(t."geom", $1::int)) as geom FROM Grobovi t ...<br>^</h1><div style="font-size:14px;font-family:Helvetica,Arial,sans-serif"><span style="font-weight:700">500</span> Internal Server Error - <abbr title="Doctrine\DBAL\Exception\TableNotFoundException" style="border-bottom:1px dotted">TableNotFoundException</abbr></div><div class="gmail-linked" style="font-size:14px;margin-top:1em;font-family:Helvetica,Arial,sans-serif"><span style="font-weight:700">2</span> linked Exceptions:<ul><li style="margin-bottom:10px"><abbr title="Doctrine\DBAL\Driver\PDOException" style="border-bottom:1px dotted">PDOException</abbr> <a href="http://localhost/mapbender/app_dev.php/_profiler/0cb26e?panel=exception#traces-link-1" style="background-color:transparent;color:rgb(33,139,195);text-decoration-line:none">»</a></li><li style="margin-bottom:10px"><abbr title="PDOException" style="border-bottom:1px dotted">PDOException</abbr> <a href="http://localhost/mapbender/app_dev.php/_profiler/0cb26e?panel=exception#traces-link-2" style="background-color:transparent;color:rgb(33,139,195);text-decoration-line:none">»</a></li></ul><div><br></div><div><br></div><div><br></div><div>Please help me.</div><div><br></div><div>Best regards</div><div>Petar Sapunar <a href="http://mag.ing.geod.et">mag.ing.geod.et</a> geoinf.</div></div></div></div><div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br>
<table style="border-top:1px solid #d3d4de">
        <tr>
        <td style="width:55px;padding-top:13px"><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif" alt="" width="46" height="29" style="width: 46px; height: 29px;"></a></td>
                <td style="width:470px;padding-top:12px;color:#41424e;font-size:13px;font-family:Arial,Helvetica,sans-serif;line-height:18px">Virus-free. <a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link" target="_blank" style="color:#4453ea">www.avast.com</a>
                </td>
        </tr>
</table><a href="#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"></a></div>