SSL Provider: [error:1425F102:SSL routines:ssl_choose_client_version:unsupp]

[PatxiAndueza]

Hello,

I'm monitoring MSSQL with Zabbix. Already monitored a MSSQL Server 2019 and works nice. But now I'm having trouble with a MSSQL Server 2012.


Cannot connect to ODBC DSN: [SQL_ERROR]:[08001][-1][[unixODBC][Microsoft][ODBC Driver 17 for SQL Server]SSL Provider: [error:1425F102:SSL routines:ssl_choose_client_version:unsupp]|[08001][-1][[unixODBC][Microsoft][ODBC Driver 17 for SQL Server]Client unable to establish connection]

• ODBC is set in the server's ODBC Data Source Administrator (64-bits)
• /etc/odbc.ini is configured.
• isql -v <DSN> <user> <password> works.
• Macros are well defined in the host.

I saw that it can be a OpenSSL version thing, so I also tried to configurfe /etc/ssl/openssl.cnf

[system_default_sect]
MinProtocol = TLSv1.0
CipherString = DEFAULT@SECLEVEL=1

I'm running out of ideas. Any direction is wellcome.

Thanks.

[PatxiAndueza]

Fixed! If someone have the same problem follow steps explained here:

https://github.com/microsoft/msphpsql/issues/1112#issuecomment-643522139

[spodumen]

In Zabbix Appliance (AlmaLinux) needs to lower the minimum TLS version

https://github.com/microsoft/msphpsql/issues/1112#issuecomment-636620414