| From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: trouble with connection |
| Date: | 2009-07-29 10:53:18 |
| Message-ID: | 20090729105318.GC28314@a-kretschmer.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Wenk | 2009-07-29 11:22:15 | Re: trouble with connection |
| Previous Message | Didier Gasser-Morlay | 2009-07-29 10:43:59 | Re: trouble with connection |