Re: trouble with connection - Mailing list pgsql-novice

From A. Kretschmer
Subject Re: trouble with connection
Date
Msg-id 20090729105318.GC28314@a-kretschmer.de
Whole thread Raw
In response to Re: trouble with connection  (Didier Gasser-Morlay <didiergm@gmail.com>)
Responses Re: trouble with connection  (Andreas Wenk <a.wenk@netzmeister-st-pauli.de>)
List pgsql-novice
In response to Didier Gasser-Morlay :
> Where I am confused it that I created in pg_hba.conf an entry
> specifically for  the user webstar
>
>  local   all         webstar                            md5
>
> and placed it before
>
>  local   all         all                                ident sameuser
>
> This works from the command line to use psql. so, to me it seems to
> say that this works.
>
> It is only when connecting from php (using pg_connect) that it fails badly.

PHP don't use the local-Method (socket), it connects via tcp/ip. So you
need a host-entry:

host  all  all       x.y.z.y/mask   md5

Replace the x.y.z.y/mask with your CIDR.


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

pgsql-novice by date:

Previous
From: Didier Gasser-Morlay
Date:
Subject: Re: trouble with connection
Next
From: Andreas Wenk
Date:
Subject: Re: trouble with connection