Re: pg_hba.conf and ssl problem has me stumped

On 12/10/2005, at 6:16 PM, Oliver Elphick wrote:
> On Wed, 2005-10-12 at 18:11 +1000, Cath Lawrence wrote:
>> My problem: newly created users cannot connect to a database. Older
>> users can connect.
>> The scenario: run psql from the webserver to connect to the database
>> server.
>> Example:
>> ================================================
>> cath@webserver:~$ psql -h dbserver -U testuser -d casemgr
>> psql: FATAL:  no pg_hba.conf entry for host "150.203.157.27", user
>> "testuser", database "casemgr", SSL off
>>
>> cath@webserver:~$ psql -h dbserver -U cath -d casemgr
>> Password:
>> Welcome to psql 7.4.8, the PostgreSQL interactive terminal.
> Please show us what you have in pg_hba.conf.

Sure, though as I said it's the same machine connection...

Not an awful lot,  as you see:

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

@remove-line-for-nolocal@# "local" is for Unix domain socket
connections only
@remove-line-for-nolocal@local   all
all                               @authmethod@
# IPv4 local connections:
host    all         all         127.0.0.1/32          @authmethod@
# webserver password access
host    all         all         150.203.157.27/32       md5
# IPv6 local connections:
#host    all         all         ::1/128               @authmethod@




thanks
Cath
Cath Lawrence,                       Cath.Lawrence@anu.edu.au
Senior Scientific Programmer,  Centre for Bioinformation Science,
John Curtin School of Medical Research (room 4087)
& Mathematical Sciences Institute, John Dedman bldg (room 1189)
Australian National University,  Canberra ACT 0200
ph: JCSMR 02-61257963  MSI: 02-61254628 mobile: 0421-902694