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(at)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(at)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(at)# "local" is for Unix domain socket
connections only
@remove-line-for-nolocal(at)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(dot)Lawrence(at)anu(dot)edu(dot)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