Postgres is running with the postmaster. When I try to connect access the database independent of mapserver there is the following error message:
"Error connecting to the server: no se pudo conectar con el servidor: Connection refused (0x0000274D/10061) ¿Está el servidor en ejecución en el servidor <<***.***.**.*>> y aceptando conexiones TCP /IP en el puerto 5432?" The server is runing so I suppose that the problem is with TCP/IP connections but I´m not sure of this settings. How do i check the TCP/IP connection of 5432 port? Thanks On Jan 17, 2008 11:47 AM, Steven De Vriendt <[EMAIL PROTECTED]> wrote: > 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. < > [EMAIL PROTECTED]> 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 > > > >
