{"id":1348,"date":"2010-11-18T10:42:52","date_gmt":"2010-11-18T10:42:52","guid":{"rendered":"http:\/\/kedar.nitty-witty.com\/?p=1348"},"modified":"2016-08-22T15:32:51","modified_gmt":"2016-08-22T15:32:51","slug":"10-steps-mysql-monitoring-nagios-installation-configuration","status":"publish","type":"post","link":"https:\/\/kedar.nitty-witty.com\/blog\/10-steps-mysql-monitoring-nagios-installation-configuration","title":{"rendered":"10 Steps: MySQL Monitoring through Nagios: Install & Configure"},"content":{"rendered":"

Nagios is a powerful monitoring system and here we will learn how to monitor MySQL through Nagios. We will be installing Nagios, required plugins and configuring it to monitor MySQL Database Server.<\/p>\n

Let’s unleash the power step by step:<\/p>\n

Installing and configuring Nagios<\/h2>\n

Step-1 : Install required stuff:<\/strong>
\nyum install httpd
\nyum install gcc
\nyum install glibc*
\nyum install gd*<\/code><\/p>\n

Step-2 :Create Nagios user account and group<\/strong>
\nuseradd nagios
\npasswd nagios
\ngroupadd nagcmd
\nusermod -G nagcmd nagios
\nusermod -G nagcmd apache<\/code><\/p>\n

Step-3: Downloads:<\/strong>
\nCreate directory:
\nmkdir NagiosSetup
\ncd NagiosSetup<\/code><\/p>\n

Download nagios
\nwget -X Get \"http:\/\/sourceforge.net\/projects\/nagios\/files\/nagios-3.x\/nagios-3.2.1\/nagios-3.2.1.tar.gz\/download\"<\/code><\/p>\n

Download Nagios Plugins:
\nwget -X Get \"http:\/\/sourceforge.net\/projects\/nagiosplug\/files\/nagiosplug\/1.4.15\/nagios-plugins-1.4.15.tar.gz\/download\"<\/code><\/p>\n

Follow up articles:<\/b>
\n 1<\/strong><\/span>: Installing Percona Monitoring Tools for MySQL Nagios<\/a>.
\n 2<\/strong><\/span>: Adding remote MySQL Host to Nagios Setup<\/a>.<\/small>\n<\/p><\/blockquote>\n

Step-4: Install Nagios<\/strong><\/p>\n

tar -xzvf nagios-3.2.1.tar.gz
\ncd nagios-3.2.1
\n.\/configure --with-command-group=nagcmd
\nmake all
\nmake install
\nmake install-config
\nmake install-commandmode
\nmake install-init
\nchkconfig --add nagios<\/code><\/p>\n

[If you miss step “make install-init” you may get:: error reading information on service nagios: No such file or directory ]<\/p>\n

Configure Nagios Web Interface:<\/span>
\nmake install-webconf
\nhtpasswd -c \/usr\/local\/nagios\/etc\/htpasswd.users nagiosadmin<\/code>
\n[specify password for nagios admin]<\/p>\n

Step-5: Install plugins<\/strong>
\ntar xvf nagios-plugins-1.4.11.tar.gz
\ncd nagios-plugins-1.4.11
\n.\/configure --with-nagios-user=nagios --with-nagios-group=nagios
\nmake
\nmake install<\/code><\/p>\n

Step-6: Verify Installation, Starting nagios for the first time<\/strong><\/p>\n

service nagios start<\/code>
\nBrowse: http:\/\/localhost\/nagios<\/p>\n

Here if you get Error:<\/em> <\/strong>
\n“You don’t have permission to access \/nagios\/ on this server.”<\/span><\/p>\n

Check \/etc\/httpd\/conf\/httpd.conf for DirectoryIndex.
\nIf it’s not having index.php add it as follows:<\/p>\n

vi \/etc\/httpd\/conf\/httpd.conf
\nDirectoryIndex index.php index.html index.html.var<\/code><\/p>\n

Make sure you do restart apache(httpd) and nagios every time you change the config file. You must have php installed.<\/p>\n

Monitoring MySQL:<\/h2>\n

Step-7: Download, Extract and install the MySQL Plugin:<\/strong><\/p>\n

wget http:\/\/labs.consol.de\/wp-content\/uploads\/2010\/10\/check_mysql_health-2.1.3.tar.gz<\/code><\/p>\n

tar -zxvf check_mysql_health-2.1.3.tar.gz
\ncd check_mysql_health-2.1.3
\n.\/configure --prefix=\/usr\/local\/nagios --with-nagios-user=nagios --with-nagios-group=nagios --with-perl=\/usr\/bin\/perl
\nmake
\nmake install<\/code><\/p>\n

Step-8: Create database user:<\/strong>
\ngrant usage, replication client on *.* to 'nagios'@'localhost' identified by 'nagios';<\/code><\/p>\n

Step-9: Provide email address for nagiosadmin:<\/strong>
\n[Change contacts.cfg file accordingly.]
\nvi \/usr\/local\/nagios\/etc\/objects\/contacts.cfg<\/code>
\n
\ndefine contact{
\ncontact_name nagiosadmin ; Short name of user
\nuse generic-contact ; Inherit default values from generic-contact template (defined above)
\nalias Kedar ; Full name of user
\nemail kedar@nitty-witty.com ; <<***** CHANGE THIS TO YOUR EMAIL ADDRESS ******
\n}<\/code><\/p>\n

Step-10: Configuring Nagios to Monitor MySQL Server<\/strong><\/p>\n

vi \/usr\/local\/nagios\/etc\/nagios.cfg <\/code>
\nadd following line:
\ncfg_file=\/usr\/local\/nagios\/etc\/objects\/mysqlmonitoring.cfg<\/code><\/p>\n

Define check_mysql_health command as follows:<\/p>\n

vi \/usr\/local\/nagios\/etc\/objects\/commands.cfg<\/code><\/p>\n

define command{
\ncommand_name check_mysql_health
\ncommand_line $USER1$\/check_mysql_health -H $ARG4$ --username $ARG1$ --password $ARG2$ --port $ARG5$ --mode $ARG3$
\n}<\/code><\/p>\n

Enter services to be monitored in mysqlmonitoring.cfg:<\/p>\n

vi \/usr\/local\/nagios\/etc\/objects\/mysqlmonitoring.cfg<\/code>
\nAdd:<\/p>\n

define service{
\nuse local-service
\nhost_name localhost
\nservice_description MySQL connection-time
\ncheck_command check_mysql_health!nagios!nagios!connection-time!127.0.0.1!3306!
\n}<\/code>
\n
\ndefine service{
\nuse local-service
\nhost_name localhost
\nservice_description MySQL slave-io-running
\ncheck_command check_mysql_health!nagios!nagios!slave-io-running!127.0.0.1!3306!
\n}<\/code>
\n
\ndefine service{
\nuse local-service
\nhost_name localhost
\nservice_description MySQL slave-sql-running
\ncheck_command check_mysql_health!nagios!nagios!slave-sql-running!127.0.0.1!3306!
\n}<\/code><\/p>\n

Here we’ve monitored 3 services: Connection-time, io thread and sql thread (replication) status. You can monitor more parameters described here: http:\/\/labs.consol.de\/nagios\/check_mysql_health\/<\/p>\n

Note: Every time you change configuration file, verify before starting nagios using command:
\n\/usr\/local\/nagios\/bin\/nagios -v \/usr\/local\/nagios\/etc\/nagios.cfg<\/code><\/p>\n

Finally start nagios service and you’re done with nagios installation and configuration for monitoring MySQL.<\/p>\n

Download PDF<\/a><\/h3>\n

I hope you’ve found this useful.<\/p>\n","protected":false},"excerpt":{"rendered":"Nagios is a powerful monitoring system and here we will learn how to monitor MySQL through Nagios. We will be installing Nagios, required plugins and configuring it to monitor MySQL…\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[8,377,6],"tags":[147,224,142,427,146],"class_list":["post-1348","post","type-post","status-publish","format-standard","category-mysql","category-mysql-articles","category-technical","tag-database-monitoring","tag-install-nagio-step-by-step","tag-installation","tag-mysql","tag-nagios"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t