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

admin

1.DBI的安装
# wget http://www.cpan.org/modules/by-module/DBI/DBI-1.625.tar.gz
# tar zxvf DBI-1.625.tar.gz
6 m6 o5 ]) E" E2 d% C# cd DBI-1.625
# perl Makefile.PL
9 [5 J1 E7 X: M# make
# make test
. k4 E' m" s! L5 x% y, s, T! D# make install
( ]# z9 |  V) P" x" v3 s8 y/ b
2.DBD的安装
# wget http://www.cpan.org/modules/by-module/DBD/DBD-mysql-4.023.tar.gz
# tar -zxvf DBD-mysql-4.023.tar.gz
0 p. v) o, q& l3 U# cd DBD-mysql-4.023
# perl Makefile.PL --mysql_config=/usr/local/mysql/bin/mysql_config --libs=-L/usr/local/mysql/lib-static -lmysqlclient
# make
: P0 r! b, X. S! h7 b+ }3 W) X# make install

3.编译安装NDOUtils
5 w* D* }6 G' \+ c# p# tar zxf ndoutils-1.5.2.tar.gz
# cd ndoutils-1.5.2
5 C3 w& X# d0 U) U$ Q0 t# ./configure --prefix=/usr/local/nagios --enable-mysql --disable-pgsql
2 j  t0 l& B. E2 C; e9 P$ P# cp ./src/ndomod-3x.o /usr/local/nagios/bin
# cp ./src/ndo2db-3x /usr/local/nagios/bin
# cp ./src/log2ndo /usr/local/nagios/bin
$ r- h( D' n* I# @1 t# cp ./src/file2sock /usr/local/nagios/bin
3 M  n% K8 ?6 J( a4 G2 |# chown nagios:nagios /usr/local/nagios/bin/*
% z: `: t4 Q: d4 B1 I9 t; L# cp ./config/ndo* /usr/local/nagios/etc/
; T1 R. S7 C4 C7 W! ]4 O1 y6 I3 R# chown nagios:nagios /usr/local/nagios/etc/*

4.为NDOUtils创建数据库
# mysql -uroot -p
mysql> create database nagios;
mysql> GRANT SELECT,INSERT,UPDATE,DELETE ON nagios.* TO nagios@localhost IDENTIFIED BY '123456';
mysql> flush privileges;
$ B; e+ |8 ~: Q( E1 B' E# Qmysql> \q
生成ndoutils所需要的数据库
) R6 [9 [+ |8 p9 F. z8 Z9 E# cd db
0 L& n0 }' J' d, |4 b3 S9 C# ./installdb -u n root -p 123456 -h localhost -d nagios
: E8 a" A1 |& }0 H也可这样：# /opt/mysql/bin/mysql -u root -p -D nagios -h localhost < ./db/mysql.sql
. I$ t& I1 v0 x/ @0 I
  L4 h4 K9 l2 ~. N" J5.编辑配置文件
- V  R: G+ ?" f( `( R$ z, S9 p( j: ]# vi /usr/local/nagios/etc/ndo2db.cfg
2 m4 g7 O1 I8 w1 n6 tdb_user=nagios
* x. ?3 D$ c: |, O6 q; q' @; z9 Tdb_pass=123456
+ Z5 _5 i8 ^+ S. t2 J  o# vi /usr/local/nagios/etc/nagios.cfg
# 复制下面内容粘贴到#broker_module＝...下面。
6 q) v1 L: P1 @$ Fbroker_module=/usr/local/nagios/bin/ndomod-3x.o config_file=/usr/local/nagios/etc/ndomod.cfg
& h$ o6 D% P6 b7 g; {2 Q, l- N此外，请确保您的/usr/local/nagios/etc/nagios.cfg中有如下行出现，否则，请自行添加：
3 D" P1 |' E3 G: B, c% z6 ~event_broker_options=-1 //为Nagios开启event broker
$ C; Z, G% e: h2 _/ O
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
0 m4 n( m1 ~9 d' s( _$ L
8 L# N; ^6 R9 N# L$ M7.重启动nagios
% c* n3 S6 ^) e3 b6 R! g# /usr/local/nagios/bin/nagios -v /usr/local/nagios/etc/nagios.cfg
  q  Z; M% {# p* J  `4 W# service nagios restart
" R7 U+ x  \+ t2 j0 S# E9 u
检查安装
9 N5 [% l3 z. Z
; X4 G* _2 t9 J3 Q# tail -20 /usr/local/nagios/var/nagios.log
; o5 N5 i3 X2 V" Q
2 j6 x4 L) E4 _& {/ G, D8、遇到问题：
1.执行 # /usr/local/nagios/bin/ndo2db-3x -c /usr/local/nagios/etc/ndo2db.cfg
1 w/ }, g- K7 ]+ H% y) \提示错误：Could not bind socket: Address already in use
解决：ps aux|grep ndo2db #没有
' F# i7 K/ E+ \3 y' Y查看套接字文件是否存在,删除之

) T- `  _, Y. g) ^% P( Dll /usr/local/nagios/var/ndo.sock
rm /usr/local/nagios/var/ndo.sock

, o' T; S! x( I7 e& B2 X2.#ndo2db数据不能导入到数据库
  c/ G+ S. j2 l8 t" Y* ~原因:编译时没有LDFLAGS=-L/opt/mysql/lib
/ {% k6 B5 O; A3 L0 v解决:重新编译ndoutils并加上 LDFLAGS=-L/opt/mysql/lib

# ./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
#再执行一下安装过程后，通过