安装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
8 r, k; a& A1 I# o+ u' M# v# cd DBI-1.625
# perl Makefile.PL
1 p  u2 u$ j4 ~" T0 S# make
# make test
# make install

# l9 W; v: G8 _9 Y4 v) K2.DBD的安装
. x, {# ^) @& F# wget http://www.cpan.org/modules/by-module/DBD/DBD-mysql-4.023.tar.gz
# tar -zxvf DBD-mysql-4.023.tar.gz
1 w7 g- [( k! @7 B2 {# cd DBD-mysql-4.023
# perl Makefile.PL --mysql_config=/usr/local/mysql/bin/mysql_config --libs=-L/usr/local/mysql/lib-static -lmysqlclient
  l0 C! t! T5 ~. s! w# make
# make install

& l1 t6 s% Y, _1 s6 R7 o3.编译安装NDOUtils
# tar zxf ndoutils-1.5.2.tar.gz
# cd ndoutils-1.5.2
) |4 E5 v" M8 [# ./configure --prefix=/usr/local/nagios --enable-mysql --disable-pgsql
1 T  I8 g' l* k) {2 B1 y9 @# cp ./src/ndomod-3x.o /usr/local/nagios/bin
3 }% H2 |* q$ R* t9 ^" v  o$ l" x# cp ./src/ndo2db-3x /usr/local/nagios/bin
# cp ./src/log2ndo /usr/local/nagios/bin
# cp ./src/file2sock /usr/local/nagios/bin
9 ]. |/ R3 j3 {* u0 r4 f- s# chown nagios:nagios /usr/local/nagios/bin/*
# cp ./config/ndo* /usr/local/nagios/etc/
- S4 L( ]7 Q! k1 S4 j# e* a# chown nagios:nagios /usr/local/nagios/etc/*
& g) |0 N- ?3 z9 K/ ^# P9 {8 Z3 W
) a9 _& U$ H0 M, R' D4.为NDOUtils创建数据库
9 |5 }7 q& A4 u( F& z# mysql -uroot -p
mysql> create database nagios;
  i/ ^7 S" T, a: ~3 xmysql> GRANT SELECT,INSERT,UPDATE,DELETE ON nagios.* TO nagios@localhost IDENTIFIED BY '123456';
2 |/ h$ V/ Y% n3 d% D5 Mmysql> flush privileges;
: [- h+ m7 R& Amysql> \q
生成ndoutils所需要的数据库
# cd db
% B% M7 f3 ?2 g8 J7 D, H. e# ./installdb -u n root -p 123456 -h localhost -d nagios
; `" f) A, U" I0 r. ]$ F! ]也可这样：# /opt/mysql/bin/mysql -u root -p -D nagios -h localhost < ./db/mysql.sql

5.编辑配置文件
/ j/ A/ y0 E+ W8 k$ n# vi /usr/local/nagios/etc/ndo2db.cfg
db_user=nagios
db_pass=123456
# vi /usr/local/nagios/etc/nagios.cfg
# 复制下面内容粘贴到#broker_module＝...下面。
% j: C* B$ S$ i0 ~' e9 \1 wbroker_module=/usr/local/nagios/bin/ndomod-3x.o config_file=/usr/local/nagios/etc/ndomod.cfg
9 v' d" f- l, x7 d8 U5 q# f此外，请确保您的/usr/local/nagios/etc/nagios.cfg中有如下行出现，否则，请自行添加：
" O1 P0 e$ O" K& ]+ zevent_broker_options=-1 //为Nagios开启event broker

* M8 q, b; @! Q- C4 L, Q9 j6.启动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
8 m) R/ A# F9 R1 {/ E. \
7.重启动nagios
# /usr/local/nagios/bin/nagios -v /usr/local/nagios/etc/nagios.cfg
# service nagios restart
% H& [$ E! h5 ^. t! T
& B1 X: U( c8 S: q! v/ y4 [检查安装
# z6 U. ?/ _8 {& K; t. g: ~/ V
# tail -20 /usr/local/nagios/var/nagios.log
+ A- [. g+ t+ U! [
8、遇到问题：
1.执行 # /usr/local/nagios/bin/ndo2db-3x -c /usr/local/nagios/etc/ndo2db.cfg
提示错误：Could not bind socket: Address already in use
5 R; k8 I: Z1 t$ [解决：ps aux|grep ndo2db #没有
查看套接字文件是否存在,删除之
( B% z( ^0 W' w' G4 y5 ~% J3 N# s
4 `0 \& u! }! Q  g5 p! vll /usr/local/nagios/var/ndo.sock
9 [, g$ G  ]1 p* e9 q( e  nrm /usr/local/nagios/var/ndo.sock
1 h: g/ }1 a  |1 p# o
2.#ndo2db数据不能导入到数据库
原因:编译时没有LDFLAGS=-L/opt/mysql/lib
. `, i2 Q3 ^$ v  @3 i解决:重新编译ndoutils并加上 LDFLAGS=-L/opt/mysql/lib
: b7 k# b+ m. U3 Z
3 ?" \- h5 d; J9 I$ l# ./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
$ R; @. T$ q, V. c#再执行一下安装过程后，通过