安装NDOUtils保存Nagios数据到mysql数据库

admin

1.DBI的安装
. X. e2 Y* ?1 x; Z$ r2 x, _% X8 Y# wget http://www.cpan.org/modules/by-module/DBI/DBI-1.625.tar.gz
# tar zxvf DBI-1.625.tar.gz
# cd DBI-1.625
5 M! W0 {, T* d% v# perl Makefile.PL
# make
# make test
# make install

- i2 H. h2 s" j& o* I3 m4 L2 G2.DBD的安装
# wget http://www.cpan.org/modules/by-module/DBD/DBD-mysql-4.023.tar.gz
# tar -zxvf DBD-mysql-4.023.tar.gz
# cd DBD-mysql-4.023
# perl Makefile.PL --mysql_config=/usr/local/mysql/bin/mysql_config --libs=-L/usr/local/mysql/lib-static -lmysqlclient
# B3 e( c! A, N9 o* Z+ ~# B" V& R# make
: A% Y2 e0 Y3 ?3 ?+ i5 ?# make install
- X0 C, i% c' r: `9 f' w
3.编译安装NDOUtils
# tar zxf ndoutils-1.5.2.tar.gz
9 i; ~9 Y" I' Q0 h. u- A2 S+ S+ s) M# cd ndoutils-1.5.2
# ./configure --prefix=/usr/local/nagios --enable-mysql --disable-pgsql
. Q' i) _5 P/ y# cp ./src/ndomod-3x.o /usr/local/nagios/bin
# cp ./src/ndo2db-3x /usr/local/nagios/bin
# cp ./src/log2ndo /usr/local/nagios/bin
# cp ./src/file2sock /usr/local/nagios/bin
0 l! \) D# R) [7 F, D+ O4 B1 _# chown nagios:nagios /usr/local/nagios/bin/*
  v3 o' h  E( O/ {$ {# V/ G* A# cp ./config/ndo* /usr/local/nagios/etc/
7 L' _& b! p$ d  A" k# ~; \7 X# chown nagios:nagios /usr/local/nagios/etc/*
9 g8 N4 k! W  E: k, P& N9 q
4.为NDOUtils创建数据库
, Z+ C$ X$ [/ @+ }' F" M/ D8 R# mysql -uroot -p
, a2 R  V/ k& T9 E0 f! s1 C: Smysql> create database nagios;
% D8 J5 h8 Q, H  i) Z9 vmysql> GRANT SELECT,INSERT,UPDATE,DELETE ON nagios.* TO nagios@localhost IDENTIFIED BY '123456';
$ Q% f: e/ w* p* omysql> flush privileges;
* S7 r+ p4 U. n' q' Z; w; ?4 wmysql> \q
+ q* {6 c6 s6 U  E& p生成ndoutils所需要的数据库
5 m, J* `8 E$ ?1 P# cd db
# ./installdb -u n root -p 123456 -h localhost -d nagios
也可这样：# /opt/mysql/bin/mysql -u root -p -D nagios -h localhost < ./db/mysql.sql
$ V9 t; y; H; w8 _
( q9 h6 [1 B0 R- ]* G! `5.编辑配置文件
# vi /usr/local/nagios/etc/ndo2db.cfg
db_user=nagios
db_pass=123456
# n) s3 H; ?1 D/ u: Y) p# vi /usr/local/nagios/etc/nagios.cfg
7 r! x+ Y3 C# @  }# 复制下面内容粘贴到#broker_module＝...下面。
broker_module=/usr/local/nagios/bin/ndomod-3x.o config_file=/usr/local/nagios/etc/ndomod.cfg
! v* e% ^$ [8 ^1 A5 W3 ~) b此外，请确保您的/usr/local/nagios/etc/nagios.cfg中有如下行出现，否则，请自行添加：
event_broker_options=-1 //为Nagios开启event broker
+ r% m8 o% S. `" J
6.启动ndo2db
# /usr/local/nagios/bin/ndo2db-3x -c /usr/local/nagios/etc/ndo2db.cfg
# echo '/usr/local/nagios/bin/ndo2db-3x -c /usr/local/nagios/etc/ndo2db.cfg' >> /etc/rc.local
4 g0 H0 U) T6 c) q  G1 [  D2 s( g
) f- ]8 e. O* M2 e7.重启动nagios
. d9 H# z# k" }+ L, D# /usr/local/nagios/bin/nagios -v /usr/local/nagios/etc/nagios.cfg
# service nagios restart
. q# E: g% |4 ?
检查安装

1 O5 m- ?9 @% I2 _9 ]# tail -20 /usr/local/nagios/var/nagios.log

8、遇到问题：
1.执行 # /usr/local/nagios/bin/ndo2db-3x -c /usr/local/nagios/etc/ndo2db.cfg
. C- `: x$ h+ ~提示错误：Could not bind socket: Address already in use
解决：ps aux|grep ndo2db #没有
0 T: L1 d3 ]+ n查看套接字文件是否存在,删除之

% q1 I3 r) s6 W* X7 K4 k4 wll /usr/local/nagios/var/ndo.sock
5 C4 g% W. E" S( U5 Z6 N4 Hrm /usr/local/nagios/var/ndo.sock

2.#ndo2db数据不能导入到数据库
原因:编译时没有LDFLAGS=-L/opt/mysql/lib
, ~3 |# D$ u, H; i0 E( ?解决:重新编译ndoutils并加上 LDFLAGS=-L/opt/mysql/lib
8 _! e4 @/ Q0 V" K5 {# q) e# Q7 i! W" Q
# ./configure --prefix=/usr/local/nagios --enable-mysql --disable-pgsql LDFLAGS=-L/usr/local/mysql/lib --with-mysql-inc=/usr/local/mysql/include/mysql --with-mysql-lib=/usr/local/mysql/lib/mysql
# make
#再执行一下安装过程后，通过