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

connection ODBC MSSQL kerberos

    XMLWordPrintable

Details

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

    Description

      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?

      Attachments

        Activity

          People

            vjaceslavs Vjaceslavs Bogdanovs
            fadas david
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: