nagios监控mysql详细配置.docVIP

Nagios监控mysql 工作原理 利用特定的用户定期访问指定的mysql数据库。当不能访问或连不通时则报警。 配置过程如下 在生产库上安装nagios插件， 以nagios-plugins-1.4.15为例来讲述整个配置过程 进入nagios-plugins-1.4.15 目录 ./configure 编译 然后是 编译完显示一定要有mysql支持，不然没有check_mysql这个插件 config.status: creating po/Makefile --with-apt-get-command: --with-ping6-command: /bin/ping6 -n -U -w %d -c %d %s --with-ping-command: /bin/ping -n -U -w %d -c %d %s --with-ipv6: yes --with-mysql: /usr/bin/mysql_config --with-openssl: yes --with-gnutls: no --enable-extra-opts: no --with-perl: /usr/bin/perl --enable-perl-modules: no --with-cgiurl: /nagios/cgi-bin --with-trusted-path: /bin:/sbin:/usr/bin:/usr/sbin --enable-libtap: no Make allmake install 插件安装完毕 再安装nrpe 安装过程略 同时是编译安装三步曲：./configure make make install 配置mysql mysql create database nagios; //建立nagios专用数据 Query OK, 1 row affected (0.00 sec) mysql grant select on nagios.* to nagios@% identified by ######; //建立nagios专用用户权限只给select就OK，给多了不安全。###是密码 Query OK, 0 rows affected (0.00 sec) mysql flush privileges; //刷新权限让数据库接受新的配置 Query OK, 0 rows affected (0.00 sec) mysql select User,Password,Host from user;//查询一下 +--------+-----------------------------------------------------------------------+------------------------------------+ | User | Password | Host | +--------+-----------------------------------------------------------------------+------------------------------------+ | root | *FD571203974BA9AFE270FE62151AE967ECA5E0AA | localhost | | root | | localhost.localdomain | | root | | 127.0.0.1 | | | | localhost | | |