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

[Jens Schaefermeyer - WhereGroup]

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

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
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/2ac5d79a/attachment.html>