Re: Question on SSL certificate expiry

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Question on SSL certificate expiry
Дата
Msg-id CAMkU=1zPdv7y1Exy2CZu9fFVGxHKCJQyDxUO0PDbEKtTwDN6Ww@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Question on SSL certificate expiry  (Nikhil Shetty <nikhil.dba04@gmail.com>)
Ответы Re: Question on SSL certificate expiry  (Nikhil Shetty <nikhil.dba04@gmail.com>)
Список pgsql-admin
On Sun, Jun 4, 2023 at 8:38 AM Nikhil Shetty <nikhil.dba04@gmail.com> wrote:
Hi Jeff

I am not getting this error when I tried using psql

What is your OS and version, your version of PostgreSQL (client, if not the same installation as the server), your version of SSL support, and how did you install the client?
 
 

I think PostgreSQL doesn't check it, but the ssl library does

Do you mean the psql client(libpq) will not be able to check?

It means the code which does the checking is not in the PostgreSQL source code, but rather in your ssl library, presumably openssl.
 

It is weird that that message ends up in the server's log file, as it is the client which is doing the rejecting, not the server.  So you would think the client would get the details and the server would get the vague conclusion.  But it is certainly not the only ssl error reporting oddity I've seen.
 
Are you saying the client will be able to login but the error will be reported only in the server log?

No, the client fails with the vague 'psql: error: connection to server at "192.168.0.14", port 5432 failed: SSL error: certificate verify failed'.  The server log is where the more detailed reason for the failure goes.

Cheers,

Jeff

В списке pgsql-admin по дате отправления:

Предыдущее
От: Nikhil Shetty
Дата:
Сообщение: Re: Question on SSL certificate expiry
Следующее
От: Nikhil Shetty
Дата:
Сообщение: Re: Question on SSL certificate expiry