Re: iso-8859-1 postgres ssl error "could not accept SSL connection: Success" and timeout
От
Holger Jakobs
Тема
Re: iso-8859-1 postgres ssl error "could not accept SSL connection: Success" and timeout
Дата
Msg-id
9c9337f9-4e4b-fcf4-fd34-98461b686888@jakobs.com
Ответ на
Re: iso-8859-1 postgres ssl error "could not accept SSL connection: Success" and timeout (Barjesh Vashist)
Список
Дерево обсуждения
iso-8859-1 postgres ssl error "could not accept SSL connection: Success" and timeout Sergey Cherevko <scherevko@scorewarrior.com>
Re: iso-8859-1 postgres ssl error "could not accept SSL connection: Success" and timeout Barjesh Vashist <barjeshvashist@gmail.com>
Re: iso-8859-1 postgres ssl error "could not accept SSL connection: Success" and timeout Holger Jakobs <holger@jakobs.com>
Re: iso-8859-1 postgres ssl error "could not accept SSL connection: Success" and timeout Holger Jakobs <holger@jakobs.com>
Re: iso-8859-1 postgres ssl error "could not accept SSL connection: Success" and timeout Rui DeSousa <rui@crazybean.net>
Re: iso-8859-1 postgres ssl error "could not accept SSL connection: Success" and timeout Rui DeSousa <rui@crazybean.net>
Am 08.05.23 um 12:17 schrieb Barjesh Vashist:
Hi Sergey,Please ensure the pg_hba.conf has enabled the SSL.
Eg.
hostssl all all 0.0.0.0/0 md5
It's not necessary to use hostssl records, host records will do as well. In an SSL environment, hostssl makes sense, though. But it doesn't help in tracking down the problem.
But - if your version supports it - use scram-sha-256 and not md5.
And don't allow access to all databases by all users from any IP address.
For testing purposes this may ok, but not in real life.
If pg_hba settings were the problem, they would show up clearly as such in the log, but that's obivously not the case.
Regards,
Holger
-- Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
В списке pgsql-admin по дате отправления
От: Barjesh Vashist
Дата: