Skip site navigation (1) Skip section navigation (2)

Re: pg_hba.conf and ssl problem has me stumped

From: Cath Lawrence <Cath(dot)Lawrence(at)anu(dot)edu(dot)au>
To: olly(at)lfix(dot)co(dot)uk
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: pg_hba.conf and ssl problem has me stumped
Date: 2005-10-12 23:28:45
Message-ID: 66ED5B74-E3AE-4486-A49E-3D92AFFD6E03@anu.edu.au (view raw or flat)
Thread:
Lists: pgsql-novice
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


In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2005-10-13 00:16:12
Subject: Re: pg_hba.conf and ssl problem has me stumped
Previous:From: Oliver ElphickDate: 2005-10-12 08:16:29
Subject: Re: pg_hba.conf and ssl problem has me stumped

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group