[postgis-users] Problem with mapserver-postgis
Paul Scott
pscott at uwc.ac.za
Sun Oct 16 20:44:36 PDT 2005
Change the bit that says md5 to trust and restart the server. That
should allow all ipv4 connections to the server from localhost.
--Paul
On Sun, 2005-10-16 at 19:57 +0000, Juan Barón wrote:
> I have in the file pg_hba.conf the following one it lines:
>
> host all all 127.0.0.1/32 md5
>
> and I have proven to not putting the password in the connection string
> but the result is the same one, that is to say, it doesn't work and it
> shows the same message:
>
> msDrawMap(): Image handling error. Failed to draw layer named
> 'callejero'.
> msPOSTGISLayerOpen(): Query error. couldnt make connection to DB with
> connect string 'user=postgres dbname=pruebapostgis'.
> Error reported was 'could not translate host name "localhost" to
> address: Unknown host '.
> 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
>
>
>
>
>
> ______________________________________________________________
> From: Paul Scott <pscott at uwc.ac.za>
> Reply-To: PostGIS Users Discussion
> <postgis-users at postgis.refractions.net>
> To: PostGIS Users Discussion
> <postgis-users at postgis.refractions.net>
> Subject: Re: [postgis-users] Problem with mapserver-postgis
> Date: Sun, 16 Oct 2005 21:11:49 +0200
> >Have you checked your pg_hba.conf that the localhost or
> 127.0.0.1 entry
> >is a trusted user? If not try setting the ident part to trust
> and
> >restart the server.
> >
> >--Paul
> >
> >On Sun, 2005-10-16 at 18:55 +0000, Juan Barón wrote:
> > > I have pulled up postmaster with - i and it continues
> without working
> > >
> > >
> > >
> > >
> > >
> > >
> ______________________________________________________________
> > > From: Armin Burger <armin.burger at gmx.net>
> > > Reply-To: PostGIS Users Discussion
> > > <postgis-users at postgis.refractions.net>
> > > To: PostGIS Users Discussion
> > > <postgis-users at postgis.refractions.net>
> > > Subject: Re: [postgis-users] Problem with
> mapserver-postgis
> > > Date: Sun, 16 Oct 2005 12:57:56 +0200
> > > >Is postmaster started with the -i option (enable
> TCP/IP
> > > >connections)?
> > > >
> > > >Armin
> > > >
> > > >Juan Barón wrote:
> > > >>Hi:
> > > >>
> > > >>I have changed the connection string writing the
> password:
> > > >>
> > > >>CONNECTION "user=postgres password=postgres
> > > dbname=pruebapostgis
> > > >>host=localhost port=5432"
> > > >>
> > > >>and I obtain the same result:
> > > >>
> > > >>msDrawMap(): Image handling error. Failed to
> draw layer
> > > named
> > > >>'callejero'.
> > > >>msPOSTGISLayerOpen(): Query error. couldnt make
> connection
> > > to DB
> > > >>with connect string 'user=postgres
> password=postgres
> > > >>dbname=pruebapostgis host=localhost port=5432'.
> > > >>Error reported was 'could not translate host
> name
> > > "localhost" to
> > > >>address: Unknown host '.
> > > >>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 have also proven to connect me to the db from
> the command
> > > prompt
> > > >>with the login information and I connect myself
> well:
> > > >>
> > > >>psql pruebapostgis -U postgres
> > > >>
> > > >>somebody knows which is the problem, it seems
> that it
> > > doesn't
> > > >>transfer localhost to an address, I have also
> proven with
> > > 127.0.0.1
> > > >>and neither it works
> > > >>
> > > >>
> > > >>
> > > >>
> > > >>
> > >
> >>------------------------------------------------------------------------
> > > >>
> > > >> From: /Prashanth Ram <pram123 at gmail.com>/
> > > >> Reply-To: /pram at pramcentral.com,PostGIS
> Users
> > > Discussion
> > > >> <postgis-users at postgis.refractions.net>/
> > > >> To: /PostGIS Users Discussion
> > > >><postgis-users at postgis.refractions.net>/
> > > >> Subject: /Re: [postgis-users] Problem with
> > > mapserver-postgis/
> > > >> Date: /Sat, 15 Oct 2005 17:47:06 -0400/
> > > >>
> > > >> Juan:
> > > >> Have you tried connecting to the db from
> the command
> > > prompt
> > > >>with
> > > >> the login information?
> > > >> Also, the connection string is missing
> the password
> > > >>
> > > >> -Prashanth
> > > >>
> > > >>
> > > >> -- HTMLX.com
> > > >> Mapserver Hosting, Mapscript Hosting, PHP
> Hosting
> > > >> PostgreSQL w/PostGIS extension enabled
> Hosting
> > > >>
> > > >> On 10/15/05, *Juan Barón*
> <jbarong at hotmail.com
> > > >> <mailto:jbarong at hotmail.com>> wrote:
> > > >>
> > > >>Hello list,
> > > >>
> > > >>I am using mapserver 4.4.1 and postgresql 8.0
> with postgis.
> > > >>
> > > >>
> > > >>
> > > >> I have a layer in the map file:
> > > >>
> > > >> LAYER
> > > >> CONNECTIONTYPE postgis
> > > >> NAME callejero
> > > >> CONNECTION "user=postgres
> dbname=pruebapostgis
> > > >>host=localhost
> > > >> port=5432"
> > > >> DATA "the_geom from tablacallejero"
> > > >>
> > > >> STATUS DEFAULT
> > > >> TYPE LINE
> > > >> CLASS
> > > >> COLOR 255 0 0
> > > >> END
> > > >> END
> > > >>
> > > >> and when I execute the application, the
> layer
> > > doesn't
> > > >>appear me and the
> > > >> result is a message for screen:
> > > >>
> > > >> msDrawMap(): Image handling error.
> Failed to draw
> > > layer
> > > >>named
> > > >> 'callejero'.
> > > >>
> > > >> msPOSTGISLayerOpen(): Query error.
> couldnt make
> > > connection
> > > >>to DB
> > > >> with
> > > >> connect string 'user=postgres
> dbname=pruebapostgis
> > > >>host=localhost
> > > >> port=5432'.
> > > >> Error reported was 'could not translate
> host name
> > > >>"localhost" to
> > > >> address:
> > > >>
> > > >> Unknown host '.
> > > >> 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 have proven to change localhost for
> 127.0.0.1
> > > >> <http://127.0.0.1/>, but the result is
> the
> > > >> same one.
> > > >>
> > > >> postgresql this being executed, because
> if I put
> > > netstat -
> > > >>na
> > > >> appears:
> > > >>
> > > >> TCP 127.0.0.1:5432
> > > <http://127.0.0.1:5432/> LISTENING
> > > >>
> > > >> I don't know which is the problem.
> > > >>
> > > >> Thank's
> > > >>
> > > >>
> > > >>
> > > >>
> > > >>
> _______________________________________________
> > > >> postgis-users mailing list
> > > >> postgis-users at postgis.refractions.net
> > > >>
> <mailto:postgis-users at postgis.refractions.net>
> > > >>
> > >
> >>http://postgis.refractions.net/mailman/listinfo/postgis-users
> > > >>
> > > >>
> > > >>
> > > >>
> > > >>
> > > >>
> > > >> -- HTMLX.com
> > > >> Mapserver Hosting, Mapscript Hosting, PHP
> Hosting
> > > >> PostgreSQL w/PostGIS extension enabled
> Hosting
> > > >>
> > >
> >> >_______________________________________________
> > > >> >postgis-users mailing list
> > > >> >postgis-users at postgis.refractions.net
> > > >>
> > > >>
> > >
> >http://postgis.refractions.net/mailman/listinfo/postgis-users
> > > >>
> > > >>
> > >
> >>------------------------------------------------------------------------
> > > >>
> > > >>_______________________________________________
> > > >>postgis-users mailing list
> > > >>postgis-users at postgis.refractions.net
> > >
> >>http://postgis.refractions.net/mailman/listinfo/postgis-users
> > > >_______________________________________________
> > > >postgis-users mailing list
> > > >postgis-users at postgis.refractions.net
> > >
> >http://postgis.refractions.net/mailman/listinfo/postgis-users
> > > _______________________________________________
> > > postgis-users mailing list
> > > postgis-users at postgis.refractions.net
> > >
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >_______________________________________________
> >postgis-users mailing list
> >postgis-users at postgis.refractions.net
> >http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
More information about the postgis-users
mailing list