To improve my Zabbix performance I upgraded my standard CentOS 6.6 installation with default PostgresQL 8.4 to the new PostgresQL 9.4.
Performance is now better but moving to the new version broke pg_monz functionality.
new location of psql file:
/usr/pgsql-9.4/bin/psql
In the results of the monitoring I see error messages that pg_monz cannot find psql.
eg: Received value [/usr/local/bin/pgsql_server_funcs.sh: line 56: psql: command not found] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]
Can anybody help me to get pg_monz functionality back to zabbix?
Also the logrt functionality doesn't work although I adjusted to the new path:
/var/lib/pgsql/9.4/data/pg_log
filename example: postgresql-Thu.log
error message in zabbix_agentd.log:
active check "logrt["/var/lib/pgsql/9.4/data/pg_log/postgresql-*\.log","PANIC|FATAL|ERROR|[Ee]rror"]" is not supported: Cannot obtain directory information: [13] Permission denied
I already changed permissions for that directory to 755.
The only item that is receiving a value is:
Number of postgres process
PostgreSQL service is running
Both values are incorrect as they state that no processes are running and that the postgresql server is down.
Running from root with zabbix_get works fine:
[root@zabbix etc]# zabbix_get -s127.0.0.1 -p10050 -kproc.num
423
Bottom line, it seems zabbix cannot call psql nor postgres binaries as it's not in it's path?
Thanks in advance for your suggestions / help.
Kevin
Performance is now better but moving to the new version broke pg_monz functionality.
new location of psql file:
/usr/pgsql-9.4/bin/psql
In the results of the monitoring I see error messages that pg_monz cannot find psql.
eg: Received value [/usr/local/bin/pgsql_server_funcs.sh: line 56: psql: command not found] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]
Can anybody help me to get pg_monz functionality back to zabbix?
Also the logrt functionality doesn't work although I adjusted to the new path:
/var/lib/pgsql/9.4/data/pg_log
filename example: postgresql-Thu.log
error message in zabbix_agentd.log:
active check "logrt["/var/lib/pgsql/9.4/data/pg_log/postgresql-*\.log","PANIC|FATAL|ERROR|[Ee]rror"]" is not supported: Cannot obtain directory information: [13] Permission denied
I already changed permissions for that directory to 755.
The only item that is receiving a value is:
Number of postgres process
PostgreSQL service is running
Both values are incorrect as they state that no processes are running and that the postgresql server is down.
Running from root with zabbix_get works fine:
[root@zabbix etc]# zabbix_get -s127.0.0.1 -p10050 -kproc.num
423
Bottom line, it seems zabbix cannot call psql nor postgres binaries as it's not in it's path?
Thanks in advance for your suggestions / help.
Kevin
Comment