check_mysql_all

[rquaresma]

Hello!

i had downloaded this pluguin and i am using this by this way :

./check_mysql_all -K mysql_query -H 187.1.133.25 -u webmr -p webMR123Branc0 -d webmr -a'query=SELECT * FROM pf_carga WHERE status IN ("falha")'
CRITICAL: 0 records returned


anyone knows how can i use by the way bellow:

./check_mysql_all -K mysql_query -H 187.1.133.25 -u webmr -p webMR123Branc0 -d webmr -a 'SELECT * ,IF(TIMESTAMPDIFF(SECOND, dt_alteracao, NOW()) <'25200', '0', '1') FROM ve_carga_status WHERE ds_tabela = 'SZO010''
CRITICAL: No Query Provided

thanks

[Box293]

It looks like you are missing query=

[rquaresma]

It looks like you are missing query=

Hi Box293,

Do you know anyway to correct it?

[tmcdonald]

You just forgot to type it when typing out the command:

Code: Select all

./check_mysql_all -K mysql_query -H 187.1.133.25 -u webmr -p webMR123Branc0 -d webmr -a 'query=SELECT * ,IF(TIMESTAMPDIFF(SECOND, dt_alteracao, NOW()) <'25200', '0', '1') FROM ve_carga_status WHERE ds_tabela = 'SZO010''