Check the pg_hba.conf file and check if your login credentials allow you to connect !
All the best, Steven On Jan 17, 2008 1:57 PM, Begoña Gonzalez <[EMAIL PROTECTED]> wrote: > 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 > > > > > > > >
