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@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.
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.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