Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-19898

Fixed an issue which unable to determine PostgreSQL server version correctly

XMLWordPrintable

    • Icon: Patch request Patch request
    • Resolution: Fixed
    • Icon: Trivial Trivial
    • 5.4.6rc1, 6.0 (plan)
    • 5.4.3
    • Server (S)
    • CentOS 8
    • Team B
    • Sprint 80 (Sep 2021)
    • 0.125

      Steps to reproduce:

      1. Install Zabbix Server + PostgreSQL 10.17
      2. Start Zabbix Server service

      Result:

      zabbix_server.log

       

      3945:20210831:102109.440 Starting Zabbix Server. Zabbix 5.4.3 (revision 68dc2b05cb).
       3945:20210831:102109.440 ****** Enabled features ******
       3945:20210831:102109.440 SNMP monitoring: YES
       3945:20210831:102109.440 IPMI monitoring: YES
       3945:20210831:102109.440 Web monitoring: YES
       3945:20210831:102109.440 VMware monitoring: YES
       3945:20210831:102109.440 SMTP authentication: YES
       3945:20210831:102109.440 ODBC: YES
       3945:20210831:102109.440 SSH support: YES
       3945:20210831:102109.440 IPv6 support: YES
       3945:20210831:102109.440 TLS support: YES
       3945:20210831:102109.440 ******************************
       3945:20210831:102109.440 using configuration file: /etc/zabbix/zabbix_server.conf
       3945:20210831:102109.819 Unsupported DB! PostgreSQL version is 100017 which is smaller than minimum of 100900

      dbversion_status

       

      # sudo -u postgres psql --username=postgres zabbix -c 'select dbversion_status from config'
      dbversion_status
      ------------------------------------------------------------------------------------------------------------ [{"database":"PostgreSQL","current_version":"10.0.17","min_version":"10.9","max_version":"13.x","flag":1}] (1 row)

       

      Expected:

      No output "Unsupported DB! PostgreSQL..." in zabbix_server.log when use PostgreSQL which is supported version by Zabbix.

      "current_version" is "10.17" when use PostgreSQL Server 10.17.

            yurii Jurijs Klopovskis
            yuji_kamada Yuji Kamada
            Team B
            Votes:
            2 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: