From: | "Graham Vickrage" <graham(at)digitalplanit(dot)com> |
---|---|
To: | "Postgres Admin" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Authentication Problems |
Date: | 2001-03-14 12:42:33 |
Message-ID: | NDBBJABDILOPAOOMFJHOIEGECIAA.graham@digitalplanit.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi all,
I have a problem that may not be directly to do with postgres but I can't
seem to figure it out. I have a linux redhat server with apache and postgres
7.0 runing on the same machine.
I am trying to sort out authentication so that local clients can connect to
the databases using 'ident sameuser' and internet users connect using
'password'. My pg_hba.conf file looks as follows: -
host all 127.0.0.1 255.255.255.0 ident
sameuser
host all 0.0.0.0 0.0.0.0
password
I assumed that the above would solve my problem, which it only half manages.
The local client connections are working correctly after putting
PGHOST=localhost as an environment variable.
HOWEVER when I connect via an internet site it will not allow a connection
(password auth.), the error I get is: -
DBI->connect failed: No pg_hba.conf entry for host localhost, user usr,
database db
Is this because connections from the internet are currently being made as
unix domain sockets instead of tcp/ip loopback via apache? If so how do I
distinguish between internet and local connections. Does anyone know if I
should be looking at apache for the solution or is it somethin subtle in
postgres that I am missing?
Thanks
Graham
Attachment | Content-Type | Size |
---|---|---|
winmail.dat | application/ms-tnef | 2.2 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | J.H.M. Dassen Ray | 2001-03-14 14:37:41 | Re: Authentication Problems |
Previous Message | John W Cunningham | 2001-03-14 08:48:23 | Crash |