search

pg-monz / pg_monz

This is the Zabbix monitoring template for PostgreSQL Database.
Apache License 2.0
163 stars 80 forks source link

'Server' parameter requiredSending failed #22

Open OSidorenkov opened 8 years ago

OSidorenkov commented 8 years ago

error reason for "Zabbix server:pgsql.get.pg.slow_query[{$PGSCRIPTDIR},{$PGSCRIPT_CONFDIR},{HOST.HOST},{$ZABBIX_AGENTD_CONF},{$PGSLOWQUERY_TIME_THRESHOLD}]" changed: Received value [zabbix_sender [30852]: Warning: 'Server' parameter requiredSending failed. Use option -vv for more detailed output] is not suitable for value type [Numeric (unsigned)] and data type [Decimal] Please help me to solve this problem!!! I have this with any keys

PandaRoux8 commented 8 years ago

Hello, I can't help you for now I'm at school. I can help you more tomorow.

I can tell you that your problem come from the zabbix sender. Check the IP of your config file, it has to be the IP of your zabbix server. Le 11 févr. 2016 12:53, "Oleg" notifications@github.com a écrit :

error reason for "Zabbix server:pgsql.get.pg.slow_query[{$PGSCRIPTDIR},{$PGSCRIPT_CONFDIR},{HOST.HOST},{$ZABBIX_AGENTD_CONF},{$PGSLOWQUERY_TIME_THRESHOLD}]" changed: Received value [zabbix_sender [30852]: Warning: 'Server' parameter requiredSending failed. Use option -vv for more detailed output] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]

Please help me to solve this problem!!! I have this with any keys

— Reply to this email directly or view it on GitHub https://github.com/pg-monz/pg_monz/issues/22.

OSidorenkov commented 8 years ago

ServerActive=127.0.0.1:10071 Server=127.0.0.1 I am trying to tune it on zabbix server

PandaRoux8 commented 8 years ago

Is your pgsql_funcs.conf file ok ?

OSidorenkov commented 8 years ago

PGHOST=127.0.0.1 PGPORT=5432 PGROLE=xxx PGDATABASE=xxx PGPASSFILE=/usr/local/etc/pgpass

mhorne484 commented 8 years ago

add another line to pgsql_functions.conf DBNAME=xxx and match your PGDATABASE. There are inconsistencies in the files and it's referenced in a few as $DBNAME