[Mapbender-users] Mapbender3: Searchrouter/additional database connection

Astrid Emde astrid.emde at wheregroup.com
Wed Jan 18 02:24:50 PST 2017


Hello Uwe and thanks for the suggestion.

I added a note about the projection of the geom

"Note: projection of geom has to be the same as map-Element projection"

Have a look at:
http://doc.mapbender3.org/en/bundles/Mapbender/CoreBundle/elements/search_router.html#yaml-definition

Astrid

Am 2017-01-18 09:53, schrieb Uwe Seher:
> Hello!
> 
> The projection didn't match. The layer is a UTM layer from a view with
> a special projection from GK. In the search router i had referenced
> the original layer. Now it works great. Maybe this topic could be
> mentioned in the documentation or in a comment in the config.
> Thank you all for your help and your work!
> 
> Best regards
> 
> Uwe
> 
> 2017-01-18 8:58 GMT+01:00 Astrid Emde <astrid.emde at wheregroup.com>:
> 
>> Hello,
>> 
>> here is another link to the documentation.
>> 
>> 
> http://doc.mapbender3.org/en/bundles/Mapbender/CoreBundle/elements/search_router.html#yaml-definition
>> [1]
>> 
>> geometry_attribute: geom
>> Make sure that your geometry_attribute is in the same projection as
>> your map. This is an error that often is made.
>> 
>> What is your EPSG-code? What are the units of your search?
>> 
>> buffer: 1000
>> Keep in mind that buffer is calutated in the units of your
>> projection.
>> 
>> Astrid
>> 
>> Am 2017-01-17 16:15, schrieb Uwe Seher:
>> 
>> Hello!
>> 
>> Cleaning the cache made the trick, nor the result is shown. Thank
>> you.
>> But now the next problem:
>> I interpret the documentation of the search router eleet, that the
>> results are shown and you can click on it, then the map zooms to the
>> element and shows the found geometry/element in the configurated
>> colors.
>> If i click now on my found result it zooms sometimes to an more or
>> less erratic place (or does nothing) and no selected elements are
>> shown. Clearing the cache after changing something didn't help here.
>> The configuration is the same as above. I just post the results
>> area:
>> 
>> results:
>> view: table
>> count: true
>> headers:
>> objectid: ID
>> name: Name
>> callback:
>> event: click
>> options:
>> buffer: 1000
>> minScale: null
>> maxScale: null
>> styleMap:
>> default:
>> strokeColor: '#00ff00'
>> strokeOpacity: 1
>> fillOpacity: 1
>> select:
>> strokeColor: '#ff0000'
>> fillColor: '#ff0000'
>> fillOpacity: 0.8
>> 
>> Any hint on the config or if i make some errors here would be great.
>> 
>> Thank you
>> 
>> Uwe
>> 
>> 2017-01-16 18:01 GMT+01:00 Axel Schaefer
>> <axel.schaefer at wheregroup.com>:
>> 
>> Hi Uwe.
>> 
>> After changes in parameters.yml and config.yml you have to clear the
>> Mapbender cache directory.
>> 
>> The contents in: <mapbender>/(application)/app/cache.
>> Not the cache-directory itself, but the contents of the directory.
>> 
>> Maybe that's the missing point. Your configuration looks ok.
>> 
>> Axel
>> 
>> Uwe Seher writes:
>> 
>> Hello again!
>> 
>> I an trying to set up a search function in my application with the
>> search
>> router element.
>> For this i had setup an additional database connection following
>> teh
>> desctioption in the documentation with the following parameters:
>> 
>> parameters.yml:
>> 
>> parameters:
>> # Default-Datenbank
>> database_driver:   pdo_pgsql
>> database_host:     192.168.1.3
>> database_port:     5432
>> database_name:     mapbender3
>> database_path:     ~
>> database_user:     mapbender
>> database_password: xxxx
>> 
>> # Rhein-Datenbank
>> database1_driver:   pdo_pgsql
>> database1_host:     192.168.1.3
>> database1_port:     5432
>> database1_name:     rhein
>> database1_path:     ~
>> database1_user:     gdi_user
>> database1_password: xxxx
>> 
>> config.yml:
>> 
>> doctrine:
>> dbal:
>> default_connection: default
>> connections:
>> default:
>> driver:   %database_driver%
>> host:     %database_host%
>> port:     %database_port%
>> dbname:   %database_name%
>> path:     %database_path%
>> user:     %database_user%
>> password: %database_password%
>> charset:  UTF8
>> logging: %kernel.debug%
>> profiling: %kernel.debug%
>> rhein:
>> driver:   %database1_driver%
>> host:     %database1_host%
>> port:     %database1_port%
>> dbname:   %database1_name%
>> path:     %database1_path%
>> user:     %database1_user%
>> password: %database1_password%
>> charset:  UTF8
>> logging: %kernel.debug%
>> profiling: %kernel.debug%
>> orm:
>> auto_generate_proxy_classes: %kernel.debug%
>> auto_mapping: true
>> 
>> The search-dialog parameters look like this:
>> 
>> class: Mapbender\CoreBundle\Component\SQLSearchEngine
>> class_options:
>> connection: rhein
>> relation: mrh_1509.engstellen
>> attributes:
>> - objectid
>> - name
>> geometry_attribute: geom
>> form:
>> name:
>> type: choice
>> options:
>> empty_value: 'Bitte wählen'
>> required: true
>> choices:
>> 1: 'Reg.Bereich 1'
>> 2: 'Reg.Bereich 2'
>> 3: 'Reg.Bereich 3'
>> 4: 'Reg.Bereich 3'
>> 5: 'Reg.Bereich 5'
>> 6: 'Reg.Bereich 6'
>> 7: 'Reg.Bereich 6'
>> results:
>> view: table
>> count: true
>> headers:
>> objectid: ID
>> name: Name
>> callback:
>> event: click
>> options:
>> buffer: 10
>> minScale: null
>> maxScale: null
>> 
>> The dialog itself works fine, but no results are found. In the
>> logfile i
>> found this entry:
>> 
>> [2017-01-13 08:45:04] request.CRITICAL: Uncaught PHP Exception
>  
> Symfony\Component\DependencyInjection\Exception\ServiceNotFoundException:
> 
>>> "You have requested a non-existent service
>>> "doctrine.dbal.rhein_connection". Did you mean this:
>>> "doctrine.dbal.default_connection"?" at
>>> /srv/www/htdocs/mapbender3-3.0.5.3/app/bootstrap.php.cache line
>> 2063
>> 
>>> {"exception":"[object]
> 
> (Symfony\\Component\\DependencyInjection\\Exception\\ServiceNotFoundException(code:
> 
>>> 0): You have requested a non-existent service
>>> \"doctrine.dbal.rhein_connection\". Did you mean this:
>>> \"doctrine.dbal.default_connection\"? at
>>> /srv/www/htdocs/mapbender3-3.0.5.3/app/bootstrap.php.cache:2063)"}
>> []
>> 
>>> So i think, the second database connection is not etablished. If i
>> use the
>> 
>>> parameters with other applications or psql everything works.
>> Restarting
>> 
>>> apache has no effect. It would be great if someone has a hint what
>> i missed
>> 
>>> here.
>>> 
>>> Thanks in advance
>>> 
>>> Uwe Seher
>>> _______________________________________________
>>> Mapbender_users mailing list
>>> Mapbender_users at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/mapbender_users [2] [1]
>> 
>> --
>> Axel Schaefer
>> WhereGroup GmbH & Co. KG
>> Eifelstraße 7
>> 53119 Bonn
>> Germany
>> 
>> Fon: +49 (0)228 / 90 90 38 [3] - 23 [2] (neue Durchwahl!)
>> Fax: +49 (0)228 / 90 90 38 [3] - 11 [3]
>> 
>> axel.schaefer at wheregroup.com
>> www.meldemax.com [4] [4]
>> www.wheregroup.com [5] [5]
>> Amtsgericht Bonn, HRA 6788
>> -------------------------------
>> Komplementärin:
>> WhereGroup Verwaltungs GmbH
>> vertreten durch:
>> Olaf Knopp, Peter Stamm
>> -------------------------------
>> _______________________________________________
>> Mapbender_users mailing list
>> Mapbender_users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/mapbender_users [6] [6]
> 
> Links:
> ------
> [1] http://lists.osgeo.org/mailman/listinfo/mapbender_users [2]
> [2] tel:%2B49%20%280%29228%20%2F%2090%2090%2038%20-%2023
> [3] tel:%2B49%20%280%29228%20%2F%2090%2090%2038%20-%2011
> [4] http://www.meldemax.com
> [5] http://www.wheregroup.com
> [6] https://lists.osgeo.org/mailman/listinfo/mapbender_users [6]
> _______________________________________________
> Mapbender_users mailing list
> Mapbender_users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapbender_users [6]
> 
> --
> Mit freundlichen Grüßen
> 
> Astrid Emde
> GIS-Consultant
> 
> *********************************************************
> FOSS Academy Winterschule 2017
> 20.-24.03.2017 [7] in Bonn
> Alles Wichtige zur Erstellung einer GDI in nur 5 Tagen!
> *********************************************************
> 
>  Astrid Emde
>  WhereGroup GmbH & Co.KG
>  Eifelstraße 7
>  53119 Bonn
>  Germany
> 
>   Fon: +49(0)228 90 90 38 - 22 [8]
>  Fax: +49(0)228 90 90 38 - 11 [9]
> 
>  astrid.emde at wheregroup.com
>  www.wheregroup.com [5]
> 
>  Folgen Sie der WhereGroup auf twitter:
> http://twitter.com/WhereGroup_com [10]
> 
> Amtsgericht Bonn, HRA 6788
> -------------------------------
> Komplementärin:
> WhereGroup Verwaltungs GmbH
> vertreten durch:
> Olaf Knopp, Peter Stamm
> -------------------------------
>   pgp-public key:
>  http://pgp.mit.edu:11371/pks/lookup?search=0x06DA52D72D515284 [11]
>  Signierte und/oder verschlüsselte Nachrichten sind sehr willkommen
>  Signed and/or encrypted mail is highly appreciated
> 
> 
> 
> Links:
> ------
> [1]
> http://doc.mapbender3.org/en/bundles/Mapbender/CoreBundle/elements/search_router.html#yaml-definition
> [2] http://lists.osgeo.org/mailman/listinfo/mapbender_users
> [3] tel:%2B49%20%280%29228%20%2F%2090%2090%2038
> [4] http://www.meldemax.com
> [5] http://www.wheregroup.com
> [6] https://lists.osgeo.org/mailman/listinfo/mapbender_users
> [7] tel:20.-24.03.2017
> [8] tel:%2B49%280%29228%2090%2090%2038%20-%2022
> [9] tel:%2B49%280%29228%2090%2090%2038%20-%2011
> [10] http://twitter.com/WhereGroup_com
> [11] http://pgp.mit.edu:11371/pks/lookup?search=0x06DA52D72D515284

-- 
Mit freundlichen Grüßen

Astrid Emde
GIS-Consultant

*********************************************************
FOSS Academy Winterschule 2017
20.-24.03.2017 in Bonn
Alles Wichtige zur Erstellung einer GDI in nur 5 Tagen!
*********************************************************

  Astrid Emde
  WhereGroup GmbH & Co.KG
  Eifelstraße 7
  53119 Bonn
  Germany

  Fon: +49(0)228 90 90 38 - 22
  Fax: +49(0)228 90 90 38 - 11

  astrid.emde at wheregroup.com
  www.wheregroup.com

  Folgen Sie der WhereGroup auf twitter: 
http://twitter.com/WhereGroup_com

Amtsgericht Bonn, HRA 6788
-------------------------------
Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Olaf Knopp, Peter Stamm
-------------------------------
  pgp-public key:
  http://pgp.mit.edu:11371/pks/lookup?search=0x06DA52D72D515284
  Signierte und/oder verschlüsselte Nachrichten sind sehr willkommen
  Signed and/or encrypted mail is highly appreciated


More information about the Mapbender_users mailing list