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

admin

1.DBI的安装
- s, `2 B9 M7 f: I8 l4 H4 D1 k% v# wget http://www.cpan.org/modules/by-module/DBI/DBI-1.625.tar.gz
+ m3 ]4 g/ b1 a8 C# tar zxvf DBI-1.625.tar.gz
# cd DBI-1.625
# perl Makefile.PL
2 T! j7 E/ r% ]6 d0 v: x8 Y# make
# make test
/ \" R9 d6 p& H# make install

2.DBD的安装
( N4 y% N7 \# l5 \1 d* h  \3 H; w# wget http://www.cpan.org/modules/by-module/DBD/DBD-mysql-4.023.tar.gz
# j: v6 [% J) C& Q' L# 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
( y9 g8 }. k8 x) s6 z# make
" ^) {" q3 p; }# make install
- \3 M3 ?) r6 w
3.编译安装NDOUtils
' L* g, l: L! _# v. i- h/ r# tar zxf ndoutils-1.5.2.tar.gz
) K2 i4 x2 H' p" D# cd ndoutils-1.5.2
# ./configure --prefix=/usr/local/nagios --enable-mysql --disable-pgsql
# cp ./src/ndomod-3x.o /usr/local/nagios/bin
. R  r& Y6 E* B5 w# cp ./src/ndo2db-3x /usr/local/nagios/bin
2 q; @! o8 L7 M% x; z# cp ./src/log2ndo /usr/local/nagios/bin
# cp ./src/file2sock /usr/local/nagios/bin
# chown nagios:nagios /usr/local/nagios/bin/*
# cp ./config/ndo* /usr/local/nagios/etc/
' j1 _, @  ?( W) e  {7 q# chown nagios:nagios /usr/local/nagios/etc/*

4.为NDOUtils创建数据库
5 X, [& f  L: M6 S' c2 X" A* f# mysql -uroot -p
, v% R6 O8 z2 b, t* [' mmysql> create database nagios;
8 d6 I3 B# z$ Umysql> GRANT SELECT,INSERT,UPDATE,DELETE ON nagios.* TO nagios@localhost IDENTIFIED BY '123456';
; y; B( a% W5 s8 i0 R' Q. k, {' K/ mmysql> flush privileges;
mysql> \q
生成ndoutils所需要的数据库
# cd db
* L8 {" j. |/ U5 m0 d. f8 b) s6 K# ./installdb -u n root -p 123456 -h localhost -d nagios
也可这样：# /opt/mysql/bin/mysql -u root -p -D nagios -h localhost < ./db/mysql.sql
9 f6 B, |4 t; g0 T
. [* ]0 M4 A$ k$ B2 J4 A# s- E5.编辑配置文件
% V+ H+ ^) m! n1 ~: [. ]6 C& H% P# vi /usr/local/nagios/etc/ndo2db.cfg
db_user=nagios
0 |$ ?$ r, W. y+ l6 H6 ldb_pass=123456
; D7 J( d' z) M% n8 B! T; R# vi /usr/local/nagios/etc/nagios.cfg
# 复制下面内容粘贴到#broker_module＝...下面。
* [, d3 k7 A4 i/ }2 w3 ?9 bbroker_module=/usr/local/nagios/bin/ndomod-3x.o config_file=/usr/local/nagios/etc/ndomod.cfg
此外，请确保您的/usr/local/nagios/etc/nagios.cfg中有如下行出现，否则，请自行添加：
event_broker_options=-1 //为Nagios开启event broker

# S; @$ L, K9 u0 W+ C6.启动ndo2db
# /usr/local/nagios/bin/ndo2db-3x -c /usr/local/nagios/etc/ndo2db.cfg
3 b0 [' x4 {6 F; u( L2 U# echo '/usr/local/nagios/bin/ndo2db-3x -c /usr/local/nagios/etc/ndo2db.cfg' >> /etc/rc.local

: y% `; I8 B) h: _1 L4 y% K2 b7.重启动nagios
# /usr/local/nagios/bin/nagios -v /usr/local/nagios/etc/nagios.cfg
# service nagios restart

1 M. A& A0 R+ t7 t2 G检查安装
5 I* F, f7 x4 d
( h4 ~" ]1 O* r' m( A* a- x1 x3 l# tail -20 /usr/local/nagios/var/nagios.log

8、遇到问题：
. d) C% K  g# b" x& m1.执行 # /usr/local/nagios/bin/ndo2db-3x -c /usr/local/nagios/etc/ndo2db.cfg
4 Q4 R5 E' k( W* Y, v) o提示错误：Could not bind socket: Address already in use
解决：ps aux|grep ndo2db #没有
查看套接字文件是否存在,删除之
3 n; a1 ]5 P* X6 I0 G
* A8 {8 l/ T7 q% t7 p+ d7 C. {. bll /usr/local/nagios/var/ndo.sock
* Q& A0 ?0 D1 Y) _5 X0 @rm /usr/local/nagios/var/ndo.sock

' t6 t- w5 {) o4 D9 F# Q2.#ndo2db数据不能导入到数据库
) e: A2 ~; t# t* J6 i- r原因:编译时没有LDFLAGS=-L/opt/mysql/lib
% L1 ]+ ]# w. A% R9 v/ n; d解决:重新编译ndoutils并加上 LDFLAGS=-L/opt/mysql/lib
1 v2 T, `+ b; f
# ./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
3 \2 Y" d$ Z% o3 t% I0 r+ l# make
#再执行一下安装过程后，通过