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@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@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
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
