Postgis Plugin: Bad connection Connection string: 'host=192.168.1.7 port=5431 dbname=mimuVI user=postgres connect_timeout=4'

[thanwin]

Hi,

1. PostGIS server is up and running, can test from both pgadmin and qgis on the same IP:PORT.
2. TileMill server is up and running, can see the default projects from web interface.
3. when I add PostGIS layer, the error message shown as "Postgis Plugin: Bad connection Connection string: 'host=192.168.1.7 port=5431 dbname=mimuVI user=postgres connect_timeout=4'"
4. I am runnin on Ubuntu 14.04 64 bit server

[springmeyer]

try adding host=localhost to your TileMill connection string?

[thanwin]

Thanks for the response. PostGIS server is on separate box, it's not on TileMill server I am testing. As I said (from the same client laptop), I can reach to PostGIS server (192.168.1.7:5341) from QGIS desktop application and I can reach to TileMill server (192.168.1.196:20009) from Firefox browser. But I cannot add PostGIS layer into a project I tested on TileMill server web interface.

Any ideas?

[pnorman]

On the server TileMill is running, does psql "host=192.168.1.7 port=5431 dbname=mimuVI user=postgres connect_timeout=4" connect?

[kozyr]

I'm getting the same error while running tirex with mapnik 2.2 - and the DB is also on a different host than tirex. Seems like mapnik is not closing its connection pool and eventually runs out of connection.

I can't connect with psql either after running tirex for a while.