pg_hba.conf and ssl problem has me stumped

From: Cath Lawrence <Cath(dot)Lawrence(at)anu(dot)edu(dot)au>
To: pgsql-novice(at)postgresql(dot)org
Subject: pg_hba.conf and ssl problem has me stumped
Date: 2005-10-12 08:11:36
Message-ID: 5FD37058-5701-4061-B93D-992410C1CB84@anu.edu.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi folks,
I've been searching archives and helpfiles, and I am still very
confused.

My problem: newly created users cannot connect to a database. Older
users can connect.
The scenario: run pqsl 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.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
================================================

Now this is odd. It's from the SAME account on the SAME machine. Old
accounts work, automatically connect with ssl, new accounts don't.

Did I do something weird when making my account way back when, that I
forgot for the new user?
I just used createuser as normal... And the test user can connect
successfully from the database server.

Anyone have any ideas?
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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Oliver Elphick 2005-10-12 08:16:29 Re: pg_hba.conf and ssl problem has me stumped
Previous Message Martin Foster 2005-10-12 02:38:03 Re: Forcing a specific order