ssl database connection problems...

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

Предыдущее
От: ries van Twisk
Дата:
Сообщение: Re: Postgres 8.3.x upgrade
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: [GENERAL] bytea size limit?