Hello,
I'm looking for a solution to run mysl queries with check_mk.
Is there any existing script for that?
thank you very much & regards,
Willi
You are looking for check_mysql_query:
check_mysql_query v1.4.16 (nagios-plugins 1.4.16)
Copyright (c) 1999-2007 Nagios Plugin Development Team
<nagiosplug-devel@lists.sourceforge.net>
This program checks a query result against threshold levels
Usage:
check_mysql_query -q SQL_query [-w warn] [-c crit] [-H host] [-P port] [-s socket]
[-d database] [-u user] [-p password]
Options:
-h, --help
Print detailed help screen
-V, --version
Print version information
-q, --query=STRING
SQL query to run. Only first column in first row will be read
-w, --warning=RANGE
Warning range (format: start:end). Alert if outside this range
-c, --critical=RANGE
Critical range
-H, --hostname=ADDRESS
Host name, IP Address, or unix socket (must be an absolute path)
-P, --port=INTEGER
Port number (default: 3306)
-s, --socket=STRING
Use the specified socket (has no effect if -H is used)
-d, --database=STRING
Database to check
-u, --username=STRING
Username to login with
-p, --password=STRING
Password to login with
==> IMPORTANT: THIS FORM OF AUTHENTICATION IS NOT SECURE!!! <==
Your clear-text password could be visible as a process table entry
A query is required. The result from the query should be numeric.
For extra security, create a user with minimal access.
Notes:
You must specify -p with an empty string to force an empty password,
overriding any my.cnf settings.
Send email to nagios-users@lists.sourceforge.net if you have questions
regarding use of this software. To submit patches or suggest improvements,
send email to nagiosplug-devel@lists.sourceforge.net
Regards
···
On 14.10.2013 13:27, Willi Fehler wrote:
Hello,
I'm looking for a solution to run mysl queries with check_mk.
--
Robert Sander
Heinlein Support GmbH
Schwedter Str. 8/9b, 10119 Berlin
Tel: 030 / 405051-43
Fax: 030 / 405051-19
Zwangsangaben lt. §35a GmbHG:
HRB 93818 B / Amtsgericht Berlin-Charlottenburg,
Geschäftsführer: Peer Heinlein -- Sitz: Berlin
Maybe check_mysql_query via mrpe is a solution for your needs...
best regards,
Marcel
···
Am Mon, 14 Oct 2013 13:27:14 +0200 schrieb Willi Fehler <willi.fehler@home24.de>:
I'm looking for a solution to run mysl queries with check_mk.
Is there any existing script for that?
Hi Marcel,
I know this plugin and mrpe. Is there also a solution for check_mk? I know that some MySQL parameters can be monitored with check_mk. But I didn't found a solution for MySQL queries.
Regards - Willi
···
Am 14.10.2013 13:40, schrieb Marcel Pennewi�:
Am Mon, 14 Oct 2013 13:27:14 +0200 > schrieb Willi Fehler <willi.fehler@home24.de>:
I'm looking for a solution to run mysl queries with check_mk.
Is there any existing script for that?Maybe check_mysql_query via mrpe is a solution for your needs...
Nagios check_mysql_query Plugin
best regards,
Marcel
_______________________________________________
checkmk-en mailing list
checkmk-en@lists.mathias-kettner.de
http://lists.mathias-kettner.de/mailman/listinfo/checkmk-en
--
Willi Fehler
Engineering
Home24 GmbH | Greifswalderstra�e 212-213 | 10405 Berlin | Deutschland
mail: willi.fehler@home24.de
Gesch�ftsf�hrer: Felix Jahn, Dr. Philipp Kreibohm
Eingetragen beim Amtsgericht Berlin, HRB 119267
At the moment not.
Andreas
···
2013/10/14 Willi Fehler willi.fehler@home24.de
Hi Marcel,
I know this plugin and mrpe. Is there also a solution for check_mk? I know that some MySQL parameters can be monitored with check_mk. But I didn’t found a solution for MySQL queries.
Regards - Willi
Am 14.10.2013 13:40, schrieb Marcel Pennewiß:
Am Mon, 14 Oct 2013 13:27:14 +0200
schrieb Willi Fehler willi.fehler@home24.de:
I’m looking for a solution to run mysl queries with check_mk.
Is there any existing script for that?
Maybe check_mysql_query via mrpe is a solution for your needs…https://www.nagios-plugins.org/doc/man/check_mysql_query.html
best regards,
Marcel
checkmk-en mailing list
–
Willi Fehler
Engineering
Home24 GmbH | Greifswalderstraße 212-213 | 10405 Berlin | Deutschland
mail: willi.fehler@home24.de
Geschäftsführer: Felix Jahn, Dr. Philipp Kreibohm
Eingetragen beim Amtsgericht Berlin, HRB 119267
checkmk-en mailing list