MSSQL and PGSQL cannot be monitored via ODBC with the special characters in the password field

XMLWordPrintable

    • S24-W34/35, S24-W36/37
    • 2

      Steps to reproduce:

      1. Setup ODBC check with the special characters in the password field

      Result:
      Query failed:

      [[FreeTDS][SQL Server]Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication.]|[08001][0][[FreeTDS][SQL Server]Unable to connect to data source]

      But it's working with the password specified in the item key itself.

      Example of password used:

      {*fXGeUlJ0<$Tce5%83n;0}

      Zabbix version is 6.4.12

      Expected:
      Working monitoring

        1. image-2024-09-04-13-13-52-118.png
          image-2024-09-04-13-13-52-118.png
          28 kB
        2. image-2024-09-04-16-26-00-072.png
          image-2024-09-04-16-26-00-072.png
          19 kB
        3. image-2024-09-05-14-23-35-815.png
          image-2024-09-05-14-23-35-815.png
          80 kB

            Assignee:
            Sergejs Boidenko
            Reporter:
            Maksym Buz
            Team A
            Votes:
            1 Vote for this issue
            Watchers:
            11 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 5h
                5h