Use Nagios to monitor MySQL database in Ossim

There are a lot of ways to monitor MySQL under Ossim, and today the instructions are monitored under the command line. Usually you run under OSSIM5 to monitor the problem files that are missing libmysqlclient.so.15, but you do not have such problems in Ossim 2.3 and Ossim 3.0 systems.

virtualusmallinone:~#/usr/lib/nagios/plugins/check_mysql-s/var/run/mysqld/mysqld.sock-p PZyAHooqzy

/usr/lib/nagios/plugins/check_mysql:error while loading shared libraries:libmysqlclient.so.15:cannot open shared Object File:no such file or directory

Copy this file and you can use it directly, and let me tell you where to download it.

virtualusmallinone:~# Wget-o/usr/lib/libmysqlclient.so.15 http://files.directadmin.com/services/es_5.0_64/ libmysqlclient.so.15

--2015-09-08 10:14:00--http://files.directadmin.com/services/es_5.0_64/libmysqlclient.so.15

Resolving files.directadmin.com ... 216.144.254.90, 208.167.226.3, 69.162.69.58

Connecting to files.directadmin.com|216.144.254.90|:80 ... Connected.

HTTP request sent, awaiting response ... OK

length:1474856 (1.4M) [Application/octet-stream]

Saving to: '/usr/lib/libmysqlclient.so.15 '

100%[===============================================================>] 1,474,856 195K/s in 9.2s

2015-09-08 10:14:10 (157 kb/s)-'/usr/lib/libmysqlclient.so.15 ' saved [1474856/1474856]

Once the download is complete, execute the command again to see the effect.

virtualusmallinone:~#/usr/lib/nagios/plugins/check_mysql-s/var/run/mysqld/mysqld.sock-p PZyAHooqzy

uptime:253321 threads:16 questions:2688108 Slow queries:6 opens:2551 Flush tables:1 Open tables:549 queries Per second avg:10.611

virtualusmallinone:~#

Okay, now you can write to the CFG configuration file, see the upcoming new book for more examples.

Use Nagios to monitor MySQL database in Ossim