Wildcard Certificate Issue

[nbonavia]

I have an ssl clickhouse server that is running on a wildcard certificate.

Unfortunately when I connect to the database using ssl with ssl mode 'strict', I get the below error message: -

Host name 'name.example.com' does not match the certificate subject provided by the peer (CN=*.example.com, OU=Domain Control Validated)

It seems that part of the verification process is checking if the host name is equal to the CN name, without taking into consideration the wildcard within the certificate.

[nbonavia]

This seems to be similar to https://github.com/yandex/clickhouse-jdbc/issues/336. I managed to get it to work by downgrading the version to 0.1.50