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