Mapserver and Postgis

[Frans Knibbe]

Hello Ezequias,

Did you edit pg_hba.conf to allow non-local connections to your database?

Regards,

Frans

Ezequias Rodrigues da Rocha wrote:

> Hi list,
>
> I am starting with mapserver, but have a very important error and I 
> have no idea how to put it to work. I doesn't even know if I did it 
> before but here is the problem:
>
> I am trying to access a postgis layer with the mapserver 4.4.2 and via 
> browser the return of server was:
>
> msDrawMap(): Image handling error. Failed to draw layer named 'bairros'.
> msPOSTGISLayerOpen(): Query error. couldnt make connection to DB with 
> connect string 'user=postgres password=post dbname=dbpotgis 
> host=192.168.0.15 port=5432'.
> Error reported was 'could not create socket: Permission denied '.
> This error occured when trying to make a connection to the specified 
> postgresql server.
> Most commonly this is caused by
> (1) incorrect connection string
> (2) you didnt specify a 'user=...' in your connection string
> (3) the postmaster (postgresql server) isnt running
> (4) you are not allowing TCP/IP connection to the postmaster
> (5) your postmaster is not running on the correct port - if its not on 
> 5432 you must specify a 'port=...'
> (6) the security on your system does not allow the webserver (usually 
> user 'nobody') to make socket connections to the postmaster
> (7) you forgot to specify a 'host=...' if the postmaster is on a 
> different machine
> (8) you made a typo
>
>
> I hope someone could help me. Nobody did before.
>
> Sincerely
> Ezequias
>
>