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

zabbix-agent2-plugin-postgresql error not using default database any more

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Cannot Reproduce
    • Icon: Trivial Trivial
    • None
    • 6.0.18
    • Agent (G)
    • None

      Hi

       

      upgraded to zabbix-agent2-plugin-postgresql.x86_64 6.0.18-release1.el8 i started to get errors

      from the postgres template I have used this as a test

       

      This used to work

      zabbix_get -s pgsql  -k'pgsql.archive["tcp://localhost:5432","zabbix","<password>"]'

      I get this error

      ZBX_NOTSUPPORTED: Connection failed: failed to connect to `host=localhost user=zabbix database=user=zabbix`: server error (FATAL: database "user=zabbix" does not exist (SQLSTATE 3D000)).

      notice database = user=zabbix, looks to me like the default database is not being used !

       

      If i change to this it works now

      zabbix_get -s pgsql  -k'pgsql.archive["tcp://localhost:5432","zabbix","<password>","postgres"]'

       

      thanks

            drasikhov Denis Rasikhov
            alex.samad@yieldbroker.com Alex Samad
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: