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

SQLSTATE 42501 when requesting the Zabbix Agent2 Postgresql plugin pgsql.archive key (PG12)

XMLWordPrintable

    • Sprint 65 (Jun 2020), Sprint 66 (Jul 2020)
    • 0.125

      Steps to reproduce:

      1. Install PostgreSQL 12
      2. Install zabbix agent2 5.0.1
      3. Configure zbx_monitor account according to the instruction
      4. Run from zabbix account: zabbix_agent2 -t "pgsql.archive[postgresql://127.0.0.1:5432,zbx_monitor,password,postgres]" -v

      Result:
      String in the output - ERROR: permission denied for function pg_ls_dir (SQLSTATE 42501).

      Expected:
      Instruction lacks necessary parameters (GRANTS) for zbx_monitor account.

            afayantsev Anton Fayantsev (Inactive)
            nwhisper Roman
            Team INT
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: