Ad Widget

Collapse

MSSQL ODBC connection issue

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • nitrosails
    Junior Member
    • Feb 2023
    • 1

    #1

    MSSQL ODBC connection issue

    Hi,

    i have an old SQL server that i want to monitor with the template MSSQL by ODBC.
    I have zabbix 6.2 on ubuntu 20.04
    installed odbc driver sql 18
    configure odbc.ini
    test connection with isql : success
    configure macro in the template (instance, login, password, DSN)
    the template work great and get lot's of info on the sql server, but quand get some item, like : mssql: get job status, mssql: get las backup
    unfortunately that' the info i need.
    the error on this item is an SSL routine error

    i have reboot the zabbix server, but no change.

    I suspect it's a TLS 1.0 problem, i have another sql server that is under a newer TLS and it's working fine.
    i have made modification in the openssl.cnf file : minprotocol = TLSv1 et cipherString = DEFAULT@SECLEVEL=0

    Thanks for your help !
Working...