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

admin

1.DBI的安装
. i$ U  L' v' S  y4 T% i9 i# 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 w# W4 o8 j2 P. E- z' U# p# perl Makefile.PL
# make
) r: i+ \+ ~9 [# make test
% C+ Z9 w; Y' _2 u9 W. @! Q8 {" Y& ]# make install

# A+ I( j8 p& R# o2.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
# make
# make install

3.编译安装NDOUtils
# n  W: ?6 F! P# b# tar zxf ndoutils-1.5.2.tar.gz
# cd ndoutils-1.5.2
# ./configure --prefix=/usr/local/nagios --enable-mysql --disable-pgsql
# cp ./src/ndomod-3x.o /usr/local/nagios/bin
# cp ./src/ndo2db-3x /usr/local/nagios/bin
9 s0 F$ c7 O3 g2 }; e0 O8 _# cp ./src/log2ndo /usr/local/nagios/bin
4 y( N3 A. B, r: {$ Z# cp ./src/file2sock /usr/local/nagios/bin
# chown nagios:nagios /usr/local/nagios/bin/*
$ V" q* X, U( {! r( _) x. @# cp ./config/ndo* /usr/local/nagios/etc/
# chown nagios:nagios /usr/local/nagios/etc/*
, Q6 n* k0 R# j
4.为NDOUtils创建数据库
# mysql -uroot -p
mysql> create database nagios;
! I& k% ?) u! {$ |1 v6 f5 s, U, Q! R: Xmysql> GRANT SELECT,INSERT,UPDATE,DELETE ON nagios.* TO nagios@localhost IDENTIFIED BY '123456';
( x( n8 W$ `0 E7 p1 wmysql> flush privileges;
mysql> \q
生成ndoutils所需要的数据库
" @4 n( U2 j; W7 E# cd db
0 a3 B% J! ?& J# ./installdb -u n root -p 123456 -h localhost -d nagios
也可这样：# /opt/mysql/bin/mysql -u root -p -D nagios -h localhost < ./db/mysql.sql
$ \$ _. j8 R; l' |
5.编辑配置文件
# vi /usr/local/nagios/etc/ndo2db.cfg
db_user=nagios
db_pass=123456
# vi /usr/local/nagios/etc/nagios.cfg
# 复制下面内容粘贴到#broker_module＝...下面。
broker_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
* w2 ?+ e! U5 T1 |
) o5 F, c: U7 `; X6.启动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

3 u5 v) Z0 |/ V5 t7.重启动nagios
# /usr/local/nagios/bin/nagios -v /usr/local/nagios/etc/nagios.cfg
6 [( W# F# M  x9 ]# service nagios restart
# V! r( _- v' W0 z0 N4 Q4 z
5 o- H  J6 A# @. |3 F检查安装
% L- E, B! U0 D" A, F) _
( H/ X# Z* M% {3 X5 X$ A3 R3 U# tail -20 /usr/local/nagios/var/nagios.log
" w; d, `5 A: ^( ~, `1 w& |/ e! b
8、遇到问题：
4 X) m* s9 G+ @  L1.执行 # /usr/local/nagios/bin/ndo2db-3x -c /usr/local/nagios/etc/ndo2db.cfg
提示错误：Could not bind socket: Address already in use
$ x2 \5 g3 X8 b% I- X解决：ps aux|grep ndo2db #没有
, m9 v8 j/ F9 S, q0 Q查看套接字文件是否存在,删除之
8 f9 v' k: F0 {" j/ l
ll /usr/local/nagios/var/ndo.sock
6 q4 [* h  F! a5 erm /usr/local/nagios/var/ndo.sock
- P& J! D2 ^) E* f/ `% v& n* a$ Y+ ~
; `: S; U" ?" B2.#ndo2db数据不能导入到数据库
原因:编译时没有LDFLAGS=-L/opt/mysql/lib
4 o3 w& P( r. o: I; Z. U2 C解决:重新编译ndoutils并加上 LDFLAGS=-L/opt/mysql/lib
9 @9 V  d% o& B) e! ~
# ./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
. F% G9 A6 d3 ~8 S4 s#再执行一下安装过程后，通过