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

[zh.kerimkulov at gharysh.kz]

Hi Astrid
Thanks for your support!!!
I checked all path in DB and YML files, looks the same.
I tried clear cache, but still got problems. In app_dev mode it works fine.

What I noticed in browser console that is error 500 on localhost/mapbender3/application/Portal/element/107/select?

Thank you
Zhandos

From: Mapbender_users [mailto:mapbender_users-bounces at lists.osgeo.org] On Behalf Of Astrid Emde
Sent: Monday, May 2, 2016 12:28 PM
To: mapbender_users at lists.osgeo.org
Subject: Re: [Mapbender-users] Connection error with geometry server, internal error 500

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



Astrid Emde

GIS-Consultant



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

Aufwind durch Wissen!

Qualifizierte OpenSource-Schulungen

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

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



 Astrid Emde

 WhereGroup GmbH & Co.KG

 Eifelstraße 7

 53119 Bonn

 Germany



 Fon: +49(0)228 90 90 38 - 19

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



 astrid.emde at wheregroup.com<mailto:astrid.emde at wheregroup.com>

 www.wheregroup.com<http://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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapbender_users/attachments/20160503/0168ae3d/attachment-0001.html>