getting postgres service down in zabbix

shashank — Wed, 22 May 2024 14:53:46 +0000

i am attaching PostgreSQL by Zabbix agent template to postgres server.
i have done following steps:
created postgres user with password
created /var/lib zabbix with zabbix ownership and copied postgresql folder in /var/lib/zabbix/ location

copied template_db_postgresql.conf file to /etc/zabbix/zabbix_agentd.d/ location
all the data is showing on zabbix dashboard like replication status lag in second all data is showing but the PostgreSQL: Service is down alert showing on dashboard and ping status is 0.
service and port is up and running on server.

how this can be resolved? is there any other thing pending to do.
in macros
pg host is 127.0.0.1
port is 5440
pg db is postgres
and also provided zabbix user name in macros

not coming data in zabbix for mysql

shashank — Mon, 18 Sep 2023 05:41:43 +0000

Trying to add mysql server in zabbix monitoring. data not coming in zabbix by using MySQL by Zabbix agent template.
i have done below steps:

step 1:
zabbix agent installation done. agent version 6.0.13

step 2: Copy template_db_mysql.conf into the folder with Zabbix agent configuration (/etc/zabbix/zabbix_agentd.d/ by default) done. and restart Zabbix agent done.

step 3: Create a MySQL user for monitoring ( at your discretion) done

step 4: Create .my.cnf in the home directory of Zabbix agent for Linux (/var/lib/zabbix by default ) done

step 5: mapped MySQL by Zabbix agent template to host on zabbix dashbord.

getting this error for mysql on zabbix dashboard. only mysql status and mysql version is showing. remaining items not showing data.

Preprocessing failed for: mysql: [Warning] World-writable config file '/var/lib/zabbix/.my.cnf' is ignored..<?xml version="...

Failed: cannot extract XML value with xpath "/resultset/row[field/text()='Aborted_clients']/field[@name='Value']/text()": cannot parse xml value: Start tag expected, '<' not found

Debug School: shashank

getting postgres service down in zabbix

not coming data in zabbix for mysql