[pgpool-general: 8479] Re: How to find out if TLS connection is used

[Tatsuo Ishii]

> Hi there,
> I'm curious if there is any way to check if the frontend connection is
> using TLS or not. Sofar I've found out that "ssl_key" is used in the log
> message:

I have no idea where "ssl_key" comes from. Can you share your setting
of log_line_prefix in pgpool.conf, and what version of pgpool?

> 2022-11-04 11:21:25.954: ssl_key pid 159: LOG:  new connection received
> 2022-11-04 11:21:25.954: ssl_key pid 159: DETAIL:  connecting host=[local]
> 2022-11-04 11:21:35.123: ssl_key pid 150: LOG:  new connection received
> 2022-11-04 11:21:35.123: ssl_key pid 150: DETAIL:  connecting host=[local]
> 2022-11-04 11:21:45.151: ssl_key pid 156: LOG:  new connection received
> 2022-11-04 11:21:45.151: ssl_key pid 156: DETAIL:  connecting host=[local]
> 2022-11-04 11:21:57.399: psql pid 155: LOG:  pool_ssl: "SSL_read": "no SSL
> error reported"
> 2022-11-04 11:22:45.257: ssl_key pid 154: LOG:  new connection received
> 2022-11-04 11:22:45.257: ssl_key pid 154: DETAIL:  connecting host=[local]
> 
> Is there a better way to check if the connection is secured by TLS or not?

Unfortunately no except setting log_min_messages = debug1 in
pgpool.conf but this will produce lots of other debug messages.

Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp