[Mapbender-users] Connection error with geometry server, internal error 500

[Patrick Meis]

Oh, well….

Thank you Jens, my problem is solved   ;-)


Von: Mapbender_users [mailto:mapbender_users-bounces at lists.osgeo.org] Im Auftrag von Jens Schaefermeyer - WhereGroup
Gesendet: Montag, 2. Mai 2016 11:46
An: Mapbender User List
Betreff: Re: [Mapbender-users] Connection error with geometry server, internal error 500

Hi Patrick,

I assume, that you didn't clear your cache after you edited your parameters.yml and config.yml. When you use the app_dev.php you don't have to clear the cache, in order to see your changes.

With kind regards,

Jens
Am 02.05.2016 um 11:15 schrieb Patrick Meis:
Hello everybody,

as I’m still having trouble to get a connection to my search_db too, I just tried to start Mapbender 3 with app_dev, as
Astrid suggested, to read the errors.
Now I discovered that with app_dev my connection sems to be working, and I finally got results in my search router.

Whereas when I am starting Mapbender normally (without app_dev) the search router keeps on saying “no results”
and the prod.log says:

request.CRITICAL: Uncaught PHP Exception Symfony\Component\DepenencyInjection\Exception\ServiceNotFoundException:
“You have requested a non-existent service “doctrine.dbal.geo_osm_connection”. Did you mean this: “doctrine.dbal.default.connection”?
at /var/www/mapbender3/app/bootstrap.php.cache line 2027

My database is not on localhost.
The configuration is as:

parameters:
    # database-connection "default"
    database_driver:   pdo_sqlite
    database_host:     ~
    database_port:     ~
    database_name:     ~
    database_path:     %kernel.root_dir%/db/demo.sqlite
    database_user:     ~
    database_password: ~

    # database-connection "geo_osm"
    database2_driver:   pdo_pgsql
    database2_host:     172.30.212.142
    database2_port:     5432
    database2_name:     geo_osm
    database2_path:     ~
    database2_user:     geo_osm
    database2_password: ********

Now the question is:
what is different when I try the search router request with app_dev???


Greets
Patrick



Am 02.05.2016 09:09, schrieb astrid.emde at wheregroup.com<mailto:astrid.emde at wheregroup.com>:

Hi Zhandos,

please check the real name of your Database in PostgreSQL. Is it named seach_db as you wrote in parameter.yml (database2_name:     search_db)?

Are you allowed to access the database?
Clear the cache
Call Mapbender with app_dev.php to get the errors. Something like http://localhost/mapbender3/app_dev.php

The rest looks fine.

Best regards

Astrid

Am 30.04.2016 09:09, schrieb zh.kerimkulov at gharysh.kz<mailto:zh.kerimkulov at gharysh.kz>:
Hello Mapbender Users!!!

I tried to use Digitizer element, but faced connection error with geometry server.

Step by step:

1/ I changed config.yml file:

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

2/ and parameters.yml file.

parameters:
    # database-connection "default"
    database_driver:   pdo_pgsql
    database_host:     localhost
    database_port:     5432
    database_name:     mapbender3
    database_path:     ~
    database_user:     postgres
    database_password: postgres

    # database-connection "search_db"
    database2_driver:   pdo_pgsql
    database2_host:     localhost
    database2_port:     5432
    database2_name:     search_db
    database2_path:     ~
    database2_user:     postgres
    database2_password: postgres

3/ then I tried to create DB by console utility like this: app/console doctrine:database:create
But this utility create only default DB, search_db did not created by script. I create it manually and added extension Postgis. After that I added tables with SQL query for tables table public.poi, public.polygons, public.lines, then I added Digitizer element to the side panel of application and put YAML-Definition to the textarea schemes but it did not solve the problem, I still have  "Connection error with geometry server, internal error 500".

Thank you,
Zhandos




_______________________________________________

Mapbender_users mailing list

Mapbender_users at lists.osgeo.org<mailto:Mapbender_users at lists.osgeo.org>

http://lists.osgeo.org/mailman/listinfo/mapbender_users



--

Mit freundlichen Grüßen



Jens Schaefermeyer

Projektleiter



-----------------------------------

Aufwind durch Wissen!

Qualifizierte OpenSource-Schulungen

bei der www.foss-academy.eu<http://www.foss-academy.eu>

-----------------------------------



WhereGroup GmbH & Co. KG

Eifelstraße 7

53119 Bonn

Germany



Fon: +49 (0)228 / 90 90 38 - 31

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



jens.schaefermeyer at wheregroup.com<mailto:jens.schaefermeyer at wheregroup.com>

www.wheregroup.com<http://www.wheregroup.com>

Amtsgericht Bonn, HRA 6788

-----------------------------------

Komplementärin:

WhereGroup Verwaltungs GmbH

vertreten durch:

Olaf Knopp, Peter Stamm

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