pg_hba.conf and ssl problem has me stumped
От | Cath Lawrence |
---|---|
Тема | pg_hba.conf and ssl problem has me stumped |
Дата | |
Msg-id | 5FD37058-5701-4061-B93D-992410C1CB84@anu.edu.au обсуждение исходный текст |
Ответы |
Re: pg_hba.conf and ssl problem has me stumped
|
Список | 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@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
В списке pgsql-novice по дате отправления: