Postgis Plugin: Bad connection #91
Comments
What happens if you try connecting as the user you renderd is running as? |
|
I can connect with that user (mapnik). |
|
I note you're forcing a prompt for a password with |
|
Works similarly: ubuntu@/usr/local/share/maps/style/OSMBright$ psql -d gis -U mapnik
Password for user mapnik:
psql (9.3.5)
Type "help" for help.
gis=> \q
ubuntu@/usr/local/share/maps/style/OSMBright$ psql -d gis -U mapnik -W
Password for user mapnik:
psql (9.3.5)
Type "help" for help.
gis=> \q |
|
When I set PostgreSQL login method to "trust" at /etc/postgresql/9.3/main/pg_hba.conf file, it started to work without error... |
|
|
Thanks! |
|
I get the same error but i change login method to trust but it is still geeting that error and when i stop PostgreSQL nothing changes , i mean that the error is a bad connection even the PostgreSQL server is down. Have you any idea? Thanks |
|
Probably the same issue - how you're trying to connect with PostgreSQL doesn't match what the server is allowing. |
|
i correct that issue but still 404 error and no tiles in tile folder and no error in syslog plz help it is becoming a nightmare for me. thanks in advance |
|
Did you try this request? |
|
it works finally ... when i reload apache no error terminal , but in apache log i see uri "/osm/" not "/osm_tiles/" |
|
I changed method in file pg_hda.conf to trust, made renderd.conf file correctly. Thanks! PROBLEM: An error occurred while loading the map layer 'default': Postgis Plugin: Bad connection |
|
would you plz test that with another style , i recommend openstreetmap-carto , i had problems with osmbright. |
|
I am trying to access remote systems postgis. I have configured the datasource-settings.xml like below postgis 192.168.1.3 gis false -20037508,-19929239,20037508,19929239 but while rendering renderd -f -c /usr/local/etc/renderd.conf I am getting the following error- I also have changed the pg_hba.conf to trust for the client ip. But nothing works. Please help me with this. thanks in advance |
|
This issue tracker is for tracking bugs in the software, not for asking questions about how to run it! An appropriate place to discuss would be this mailing list: https://lists.openstreetmap.org/listinfo/tile-serving. Having said that, make sure you have actually created a PostgreSQL user (createuser) with the same name as given in datasource-settings.xml or, if no user name is given there, the unix user name under which renderd runs. Also make sure you're setting "trust" also for the non-IP access line in pg_hba.conf. |
|
@avirupd-egnaroinc this may happen because of two reason first setting trust in pg_hba.conf and permissions, check them. |
|
I am getting the same error I have also tried changing pg_hba.conf but nothing worked. Also according to the tutorial I created a user named abhishek but when I try to connect using
I get this error I don't know what should I do next. Please help. |
|
@ephilosophy check your postgresql server is running or not. |
I got the same error. My postgresql server is running and it's possible to connect it from other host, but not from renderd |
|
@alejandrogalera this is not a mod_tile issue. The error clearly states that you can not access your database using a socket connection. The tool |
Hello,
I would like create a tile server on a EC2 Ubuntu server. I followed this documentation:
http://switch2osm.org/serving-tiles/manually-building-a-tile-server-14-04/
After I successfully import data into the database from pbf file, I execute this command:
But I got the next error message:
I check all config file, but I can not find any mistake. And I can connect to "gis" db with this user:
Have you any idea, what is the problem?
Thanks in advance!
The text was updated successfully, but these errors were encountered: