Connection error with geometry server, internal error 500

classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|

Connection error with geometry server, internal error 500

zh.kerimkulov@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
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapbender_users
Reply | Threaded
Open this post in threaded view
|

Re: Connection error with geometry server, internal error 500

Astrid Emde (WhereGroup)
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 [hidden email]:

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
[hidden email]
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
-----------------------------------

 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

 [hidden email]
 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

_______________________________________________
Mapbender_users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapbender_users
Reply | Threaded
Open this post in threaded view
|

Re: Connection error with geometry server, internal error 500

pmeis
In reply to this post by zh.kerimkulov@gharysh.kz

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 [hidden email]:

 

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 [hidden email]:

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
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapbender_users
Reply | Threaded
Open this post in threaded view
|

Re: 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 [hidden email]:

 

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 [hidden email]:

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
[hidden email]
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

[hidden email]
www.wheregroup.com
Amtsgericht Bonn, HRA 6788
-----------------------------------
Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Olaf Knopp, Peter Stamm
-----------------------------------

_______________________________________________
Mapbender_users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapbender_users
Reply | Threaded
Open this post in threaded view
|

Re: Connection error with geometry server, internal error 500

pmeis

Oh, well….

 

Thank you Jens, my problem is solved   ;-)

 

 

Von: Mapbender_users [mailto:[hidden email]] 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 [hidden email]:

 

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 [hidden email]:

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
[hidden email]
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
 
[hidden email]
www.wheregroup.com
Amtsgericht Bonn, HRA 6788
-----------------------------------
Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Olaf Knopp, Peter Stamm
-----------------------------------

_______________________________________________
Mapbender_users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapbender_users
Reply | Threaded
Open this post in threaded view
|

Re: Connection error with geometry server, internal error 500

zh.kerimkulov@gharysh.kz
In reply to this post by Astrid Emde (WhereGroup)

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:[hidden email]] On Behalf Of Astrid Emde
Sent: Monday,
May 2, 2016 12:28 PM
To: [hidden email]
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 [hidden email]:

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
[hidden email]
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
-----------------------------------
 
 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
 
 [hidden email]
 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

_______________________________________________
Mapbender_users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapbender_users
Reply | Threaded
Open this post in threaded view
|

Re: Connection error with geometry server, internal error 500

Astrid Emde (WhereGroup)
Hello Zhandos,

as you wrote everything works fine with ap_dev.php. That looks good.

So please run

app/console assets:install web (see installation of Mapbender
http://doc.mapbender3.org/en/book/installation.html)
and clear your cache.

Then you should be able to use app.php too.

Best regards Astrid

Am 2016-05-03 05:12, schrieb [hidden email]:

> 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:[hidden email]]
> ON BEHALF OF Astrid Emde
> SENT: Monday, May 2, 2016 12:28 PM
> TO: [hidden email]
> 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 [6]
>
> The rest looks fine.
>
> Best regards
>
> Astrid
>
> Am 30.04.2016 09:09, schrieb [hidden email]:
>
>> 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
>>
>> [hidden email]
>>
>> http://lists.osgeo.org/mailman/listinfo/mapbender_users [1]
>
> --
>
> Mit freundlichen Grüßen
>
> Astrid Emde
>
> GIS-Consultant
>
> -----------------------------------
>
> Aufwind durch Wissen!
>
> Qualifizierte OpenSource-Schulungen
>
> bei der www.foss-academy.eu [2]
>
> -----------------------------------
>
>  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
>
>  [hidden email]
>
>  www.wheregroup.com [3]
>
>  Folgen Sie der WhereGroup auf twitter:
> http://twitter.com/WhereGroup_com [4]
>
> 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 [5]
>
>   Signierte und/oder verschlüsselte Nachrichten sind sehr willkommen
>
>   Signed and/or encrypted mail is highly appreciated
>
>
> Links:
> ------
> [1] http://lists.osgeo.org/mailman/listinfo/mapbender_users
> [2] http://www.foss-academy.eu
> [3] http://www.wheregroup.com
> [4] http://twitter.com/WhereGroup_com
> [5] http://pgp.mit.edu:11371/pks/lookup?search=0x06DA52D72D515284
> [6] http://localhost/mapbender3/app_dev.php
>
> _______________________________________________
> Mapbender_users mailing list
> [hidden email]
> 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
-----------------------------------

  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

  [hidden email]
  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
_______________________________________________
Mapbender_users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapbender_users
Reply | Threaded
Open this post in threaded view
|

Re: Connection error with geometry server, internal error 500

zh.kerimkulov@gharysh.kz
Thank you

It works now!

-----Original Message-----
From: Astrid Emde [mailto:[hidden email]]
Sent: Tuesday, May 3, 2016 12:18 PM
To: Mapbender User List
Cc: Керимкулов Жандос Сеитович
Subject: Re: [Mapbender-users] Connection error with geometry server, internal error 500

Hello Zhandos,

as you wrote everything works fine with ap_dev.php. That looks good.

So please run

app/console assets:install web (see installation of Mapbender
http://doc.mapbender3.org/en/book/installation.html)
and clear your cache.

Then you should be able to use app.php too.

Best regards Astrid

Am 2016-05-03 05:12, schrieb [hidden email]:

> 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:[hidden email]]
> ON BEHALF OF Astrid Emde
> SENT: Monday, May 2, 2016 12:28 PM
> TO: [hidden email]
> 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 [6]
>
> The rest looks fine.
>
> Best regards
>
> Astrid
>
> Am 30.04.2016 09:09, schrieb [hidden email]:
>
>> 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
>>
>> [hidden email]
>>
>> http://lists.osgeo.org/mailman/listinfo/mapbender_users [1]
>
> --
>
> Mit freundlichen Grüßen
>
> Astrid Emde
>
> GIS-Consultant
>
> -----------------------------------
>
> Aufwind durch Wissen!
>
> Qualifizierte OpenSource-Schulungen
>
> bei der www.foss-academy.eu [2]
>
> -----------------------------------
>
>  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
>
>  [hidden email]
>
>  www.wheregroup.com [3]
>
>  Folgen Sie der WhereGroup auf twitter:
> http://twitter.com/WhereGroup_com [4]
>
> 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 [5]
>
>   Signierte und/oder verschlüsselte Nachrichten sind sehr willkommen
>
>   Signed and/or encrypted mail is highly appreciated
>
>
> Links:
> ------
> [1] http://lists.osgeo.org/mailman/listinfo/mapbender_users
> [2] http://www.foss-academy.eu
> [3] http://www.wheregroup.com
> [4] http://twitter.com/WhereGroup_com
> [5] http://pgp.mit.edu:11371/pks/lookup?search=0x06DA52D72D515284
> [6] http://localhost/mapbender3/app_dev.php
>
> _______________________________________________
> Mapbender_users mailing list
> [hidden email]
> 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
-----------------------------------

  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

  [hidden email]
  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
_______________________________________________
Mapbender_users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapbender_users