PostGIS connection

[Steven De Vriendt]

So, is postgres up and running with the postmaster ?
Check if you can access the database independent of mapserver...

Steven

On Jan 17, 2008 11:04 AM, SUBSCRIBE MAPSERVER-USERS Bego D. <
begodom at gmail.com> wrote:

> Hello
>
> We are new in Mapserver.
>
> I have installed MapServer 4 Windows version 2.2.6 on my computer and in
> another computer of my office we have installed Postgis 1.3.2. for 8.2
> PostgreSQL.
>
> Both works fine, we can work with Mapserver-Oracle Spatial or with .shp
> or .tab, but now we want to connect MapServer with PostGis and we get this
> error:
>
> msDrawMap(): Image handling error. Failed to draw layer named 'INFVIA'.
> msPOSTGISLayerOpen(): Query error. couldnt make connection to DB with
> connect string 'host=****** dbname=****  user=postgres
> password=****** port=5432'. Error reported was 'could not connect to
> server: Connection refused (0x0000274D/10061) Is the server running on
> host "192.168.0.3" and accepting TCP/IP connections on port 5432? '. 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
>
> My .map is:
>
>
> CONNECTIONTYPE POSTGIS
> CONNECTION "host=***.***.**.* dbname=**user=postgres password=***
> port=5432"
> DATA "the_geom geometry from INFVIA2"
>
> Any help will be appreciate.
>
> Bego
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20080117/20dbd764/attachment.html