Ad Widget

Collapse

Template DB PostgreSQL - error connections

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • maxxus
    Junior Member
    • Nov 2020
    • 17

    #1

    Template DB PostgreSQL - error connections

    Hi guys!
    I have a problem setting up a template Template DB PostgreSQL.

    For setting it I used manual:



    but, I received error:
    error reason for "Zabbix server pgsql.ping.time["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.D B}"]" changed: Preprocessing failed for: 1.Time: 0.573 ms


    At the same time, the command from the console is executed successfully:

    zabbix_get -s 127.0.0.1 -k 'pgsql.transactions["127.0.0.1","5432","zbx_monitor","postgres"]'
    {"idle":0,"active":0,"waiting":86407.439003,"pr epa red":0}

    zabbix_get -s 127.0.0.1 -k 'pgsql.ping["127.0.0.1","5432","zbx_monitor","postgres"]'
    127.0.0.1:5432 - принимает подключения (accept connections)


    Click image for larger version

Name:	image_18700.png
Views:	139
Size:	56.8 KB
ID:	422126



    Click image for larger version

Name:	image_18701.png
Views:	116
Size:	32.3 KB
ID:	422127



    pg_hba.conf

    host all zbx_monitor 127.0.0.1/32 trust
    host all zbx_monitor 0.0.0.0/0 md5
    host all zbx_monitor ::0/0 md5


    System:
    zabbix_server (Zabbix) 5.0.5
    Debian 10.6 x64


    Perhaps someone knows where to look for the error?
    I'm already stumped
Working...