Ad Widget

Collapse

adjust pg_monz psql binary location

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • xanadu
    Member
    • Sep 2014
    • 62

    #1

    adjust pg_monz psql binary location

    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
    Last edited by xanadu; 20-10-2015, 20:59.
  • xanadu
    Member
    • Sep 2014
    • 62

    #2
    Resolved by editing the script files and changing psql to /usr/pgsql-9.4/bin/psql

    It could be cleaner if the script would include path for psql binary

    Comment

    Working...