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
>> cath(at)webserver:~$ psql -h dbserver -U testuser -d casemgr
>> psql: FATAL: no pg_hba.conf entry for host "220.127.116.11", user
>> "testuser", database "casemgr", SSL off
>> cath(at)webserver:~$ psql -h dbserver -U cath -d casemgr
>> 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
# IPv4 local connections:
host all all 127.0.0.1/32 @authmethod@
# webserver password access
host all all 18.104.22.168/32 md5
# IPv6 local connections:
#host all all ::1/128 @authmethod@
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
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2005-10-13 00:16:12|
|Subject: Re: pg_hba.conf and ssl problem has me stumped |
|Previous:||From: Oliver Elphick||Date: 2005-10-12 08:16:29|
|Subject: Re: pg_hba.conf and ssl problem has me stumped|