[Mapbender-users] WG: Mapbender3 - Konfiguration Search Router

[Geodaten WiplferPlan]

Hallo zusammen,

 

ich habe in unserem Mapbender Projekt versucht Search Router zu integrieren,
bekomme aber immer die Meldung „No results found“.

Die config.yml sieht so aus:

 

"doctrine:

     dbal:

         default_connections: 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%

                                 postgres:

                                                driver:   

%database2_driver%

                                                host:     

%database2_host%

                                                port:     

%database2_port%

                                                dbname:   

%database2_name%

                                                path:     

%database2_path%

                                                user:     

%database2_user%

                                                password: 

%database2_password%

                                                charset:  UTF8

                                                logging: %kernel.debug%

                                                profiling: 

%kernel.debug%

 

     orm:

         auto_generate_proxy_classes: %kernel.debug%

         auto_mapping: true"

 

Die parameters.yml so:

 

"parameters:

     database_driver:   pdo_pgsql

     database_host:     *****

     database_port:     5432

     database_name:     mapbender3

     database_path:     ~

     database_user:     postgres

     database_password: *****

 

     database2_driver:   pdo_pgsql

     database2_host:     *****

     database2_port:     5432

     database2_name:     postgres

     database2_path:     ~

     database2_user:     postgres

     database2_password: *****

 

     mailer_transport:  smtp

     mailer_host:       localhost

     mailer_user:       ~

     mailer_password:   ~

 

     # locale en, de, it, es, ru, nl, pt are available

     fallback_locale:   en

     locale:            en

     secret:            ThisTokenIsNotSoSecretChangeIt

 

     fom:

         server_name:   Mapbender3

         server_version: 3.0.5.3

         server_logo:   bundles/mapbendercore/image/logo_mb3.png

 

     # framework : 

 
<http://symfony.com/doc/2.1/reference/configuration/framework.html#cookie-li
fetime>
http://symfony.com/doc/2.1/reference/configuration/framework.html#cookie-lif
etime

     cookie_secure: false

     cookie_lifetime: 3600

 

# OWSProxy Configuration

     ows_proxy3_logging: false

     ows_proxy3_obfuscate_client_ip: true

     ows_proxy3_host: ~

     ows_proxy3_port: ~

     ows_proxy3_connecttimeout: 60

     ows_proxy3_timeout: 90

     ows_proxy3_user: ~

     ows_proxy3_password: ~

     ows_proxy3_noproxy: ~

"

 

und die Konfiguration der Suche in Mapbender wie folgt:

 

"class: Mapbender\CoreBundle\Component\SQLSearchEngine

class_options:

     connection: postgres

     relation: public.Kundenstamm

     attributes:

         - id

         - bez_gem

     geometry_attribute: geom

form:

     Gemeinde:

         type: text

         options:

             required: true

         compare: exact

results:

     view: table

     count: true

     headers:

         id: ID

         bez_gem: Name

     callback:

         event: click

         options:

             buffer: 10

             minScale: null

             maxScale: null"

 

In der prod.log steht folgende Fehlermeldung:

 

[2017-04-03 10:38:12] request.CRITICAL: Uncaught PHP Exception

Symfony\Component\DependencyInjection\Exception\ServiceNotFoundException: 

"You have requested a non-existent service
"doctrine.dbal.postgres_connection". Did you mean this: 

"doctrine.dbal.default_connection"?" at
/var/www/mapbender3/app/bootstrap.php.cache line 2048 {"exception":"[object]

(Symfony\\Component\\DependencyInjection\\Exception\\ServiceNotFoundExceptio
n(code: 

0): You have requested a non-existent service
\"doctrine.dbal.postgres_connection\". Did you mean this: 

\"doctrine.dbal.default_connection\"? at
/var/www/mapbender3/app/bootstrap.php.cache:2048)"} []

 

Ich habe ähnliche Probleme

(http://osgeo-org.1560.x6.nabble.com/connecting-a-database-td5254910.html,

http://osgeo-org.1560.x6.nabble.com/Mapbender3-Searchrouter-additional-datab
ase-connection-td5303306.html

) bereits im Forum gefunden, die dort vorgeschlagenen Lösungen haben aber
nichts geändert soweit ich sie umsetzen konnte.

 

Über Lösungsansätze würde ich mich sehr freuen.

 

Freundliche Grüße

 

Markus Lütke Brintrup

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapbender_users/attachments/20170403/6d05c57c/attachment-0001.html>