<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>