<div dir="ltr"><div><div><div><div><div><div><div><div>Hello again!<br><br></div>I an trying to set up a search function in my application with the search router element.<br></div>For this i had setup an additional database connection following teh desctioption in the documentation with the following parameters:<br><br>parameters.yml:<br><br><span style="font-family:monospace,monospace">parameters:<br>    # Default-Datenbank<br>    database_driver:   pdo_pgsql<br>    database_host:     192.168.1.3<br>    database_port:     5432<br>    database_name:     mapbender3<br>    database_path:     ~<br>    database_user:     mapbender<br>    database_password: xxxx<br><br>    # Rhein-Datenbank<br>    database1_driver:   pdo_pgsql<br>    database1_host:     192.168.1.3<br>    database1_port:     5432<br>    database1_name:     rhein<br>    database1_path:     ~<br>    database1_user:     gdi_user<br>    database1_password: xxxx</span><br><br></div>config.yml:<br><br><span style="font-family:monospace,monospace">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>                charset:  UTF8<br>                logging: %kernel.debug%<br>                profiling: %kernel.debug%<br>            rhein:<br>                driver:   %database1_driver%<br>                host:     %database1_host%<br>                port:     %database1_port%<br>                dbname:   %database1_name%<br>                path:     %database1_path%<br>                user:     %database1_user%<br>                password: %database1_password%<br>                charset:  UTF8<br>                logging: %kernel.debug%<br>                profiling: %kernel.debug%<br>    orm:<br>        auto_generate_proxy_classes: %kernel.debug%<br>        auto_mapping: true</span><br><br></div>The search-dialog parameters look like this:<br><br><span style="font-family:monospace,monospace">class: Mapbender\CoreBundle\Component\SQLSearchEngine<br>class_options:<br>    connection: rhein<br>    relation: mrh_1509.engstellen<br>    attributes:<br>        - objectid<br>        - name<br>    geometry_attribute: geom<br>form:<br>    name:<br>        type: choice<br>        options:<br>            empty_value: 'Bitte wählen'<br>            required: true<br>            choices:<br>                1: 'Reg.Bereich 1'<br>                2: 'Reg.Bereich 2'<br>                3: 'Reg.Bereich 3'<br>                4: 'Reg.Bereich 3'<br>                5: 'Reg.Bereich 5'<br>                6: 'Reg.Bereich 6'<br>                7: '</span><span style="font-family:monospace,monospace"><span style="font-family:monospace,monospace">Reg.Bereich 6'<br></span>results:<br>    view: table<br>    count: true<br>    headers:<br>        objectid: ID<br>        name: Name<br>    callback:<br>        event: click<br>        options:<br>            buffer: 10<br>            minScale: null<br>            maxScale: null</span><br><br></div>The dialog itself works fine, but no results are found. In the logfile i found this entry:<br><span style="font-family:monospace,monospace"><br>[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)"} []</span><br><br></div>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.<br><br></div>Thanks in advance<br><br></div>Uwe Seher<br></div>