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

    Details

    • Team:
      Team INT
    • Sprint:
      Sprint 65 (Jun 2020), Sprint 66 (Jul 2020)
    • Story Points:
      0.125

      Description

      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.

        Attachments

          Activity

            People

            Assignee:
            afayantsev Anton Fayantsev
            Reporter:
            nwhisper Roman
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: