ssl database connection problems...

From: Carol Walter <walterc(at)indiana(dot)edu>
To: Ray Stell <stellr(at)cns(dot)vt(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: ssl database connection problems...
Date: 2009-01-22 15:35:22
Message-ID: F55F82FF-D064-42FE-99DC-80A447B4BE56@indiana.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I'm still having problems with ssl. My ssl_ciphers line in
postgresql.conf looks as the following:

ssl_ciphers 'ALL:!ADH:!LOW:@STRENGTH'

When I try to connect to the database from another system I get this
error...

walterc(at)cat:~$ psql -p 5433 -U walterc -d walterc -h db
psql: SSL SYSCALL error: EOF detected

When I try to connect to the database from another host, I get this
error...

walterc(at)cat:~$ psql -p 5433 -U walterc -d walterc -h db
psql: SSL SYSCALL error: EOF detected

The entries in the data834.log file are as follows;
[[unknown]:[unknown]:2009-01-22 10:12:02 EST]LOG: could not accept
SSL connection: cipher or hash unavailable
[::2009-01-22 10:19:48 EST]LOG: received smart shutdown request
[::2009-01-22 10:19:48 EST]LOG: autovacuum launcher shutting down
[::2009-01-22 10:19:48 EST]LOG: shutting down
[::2009-01-22 10:19:48 EST]LOG: database system is shut down
[::2009-01-22 10:20:02 EST]LOG: could not load root certificate file
"root.crt": No such file or directory
[::2009-01-22 10:20:02 EST]DETAIL: Will not verify client certificates.
[::2009-01-22 10:20:02 EST]LOG: database system was shut down at
2009-01-22 10:19:48 EST
[::2009-01-22 10:20:02 EST]LOG: database system is ready to accept
connections
[::2009-01-22 10:20:02 EST]LOG: autovacuum launcher started
[[unknown]:[unknown]:2009-01-22 10:24:00 EST]LOG: connection
received: host=129.79.36.77 port=64671
[walterc:walterc:2009-01-22 10:24:00 EST]LOG: could not receive data
from client: Connection reset by peer
[[unknown]:[unknown]:2009-01-22 10:24:11 EST]LOG: connection
received: host=129.79.36.77 port=64673
[walterc:walterc:2009-01-22 10:24:11 EST]FATAL: password
authentication failed for user "walterc"
[[unknown]:[unknown]:2009-01-22 10:24:11 EST]LOG: connection
received: host=129.79.36.77 port=64674
[walterc:walterc:2009-01-22 10:24:11 EST]FATAL: password
authentication failed for user "walterc"
[[unknown]:[unknown]:2009-01-22 10:24:20 EST]LOG: connection
received: host=129.79.36.77 port=64675
[walterc:walterc:2009-01-22 10:24:20 EST]LOG: could not receive data
from client: Connection reset by peer
[[unknown]:[unknown]:2009-01-22 10:24:29 EST]LOG: connection
received: host=129.79.36.77 port=64676
[walterc:walterc:2009-01-22 10:24:29 EST]FATAL: password
authentication failed for user "walterc"
[[unknown]:[unknown]:2009-01-22 10:24:29 EST]LOG: connection
received: host=129.79.36.77 port=64677
[walterc:walterc:2009-01-22 10:24:29 EST]FATAL: password
authentication failed for user "walterc"
[[unknown]:[unknown]:2009-01-22 10:24:33 EST]LOG: connection
received: host=129.79.36.77 port=64679
[walterc:walterc:2009-01-22 10:24:33 EST]LOG: could not receive data
from client: Connection reset by peer
[[unknown]:[unknown]:2009-01-22 10:24:48 EST]LOG: connection
received: host=129.79.36.77 port=64680
[walterc:walterc:2009-01-22 10:24:48 EST]FATAL: password
authentication failed for user "walterc"
[[unknown]:[unknown]:2009-01-22 10:24:48 EST]LOG: connection
received: host=129.79.36.77 port=64681
[walterc:walterc:2009-01-22 10:24:48 EST]FATAL: password
authentication failed for user "walterc"
-bash-3.00$

Do you have any ideas for me to try to solve this problem?

Thanks,
Carol

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Albe Laurenz 2009-01-22 16:08:32 Re: [GENERAL] bytea size limit?
Previous Message ries van Twisk 2009-01-22 14:57:46 Re: Postgres 8.3.x upgrade