Uploaded image for project: 'ZABBIX FEATURE REQUESTS'
  1. ZABBIX FEATURE REQUESTS
  2. ZBXNEXT-7483

connection ODBC MSSQL kerberos

XMLWordPrintable

    • Icon: Change Request Change Request
    • Resolution: Unresolved
    • Icon: High High
    • None
    • 5.4.9
    • Templates (T)
    • None
    • Virtual machin on Debian10

      We want to monitor our mssql database via the official zabbix template here
      To do this we have therefore configured the ODBC connection from our server

      odbc.ini :
      Code:
      [SQLSI]
      Driver = ODBC Driver 17 for SQL Server
      Description = ODBC connection via ODBC Driver 17 for SQL Server
      Trace = Yes
      TraceFile = /tmp/odbc.ini.log
      Server = serv-sqlsi
      Port = 1433
      Trusted_Connection=yes
      As you can see we use Kerberos authentication

      odbcinst.ini:
      Code:
      [ODBC Driver 17 for SQL Server]
      Description=Microsoft ODBC Driver 17 for SQL Server
      Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.8.so.1.1
      UsageCount=1

      So we tried to connect from the server
      Code:
      #isql SQLSI -v $USER $PASSWORD
      ---------------------------------------

      Connected!
       
      sql-statement
      help [tablename]
      quit
       

      ---------------------------------------
      SQL>
      No problem!!

      now when we apply the model on a mssql host
      here is what I get:

       Cannot connect to ODBC DSN: [SQL_ERROR]:[HY000][851968][[unixODBC][Microsoft][ODBC Driver 17 for SQL Server]SSPI Provider: No Kerberos credentials available (default cache: FILE:/tmp/]|[HY000][851968][[unixODBC][Microsoft][ODBC Driver 17 for SQL Server]Cannot generate SSPI context]
      As if the he didn't want to connect via kerberos but only from zabbix because from RAS server.

      Could you help me?

            zit Zabbix Integration Team
            fadas david
            Votes:
            10 Vote for this issue
            Watchers:
            9 Start watching this issue

              Created:
              Updated: