ssl database connection problems...
От | Carol Walter |
---|---|
Тема | ssl database connection problems... |
Дата | |
Msg-id | F55F82FF-D064-42FE-99DC-80A447B4BE56@indiana.edu обсуждение исходный текст |
Ответы |
Re: ssl database connection problems...
|
Список | 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@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
В списке pgsql-admin по дате отправления: