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

admin

1.DBI的安装
8 {/ z# x- _5 n9 r$ {, N# wget http://www.cpan.org/modules/by-module/DBI/DBI-1.625.tar.gz
7 u& U8 v8 j! @3 l# tar zxvf DBI-1.625.tar.gz
# cd DBI-1.625
# perl Makefile.PL
" O' @3 V! A' K5 O! u# make
! h% v4 w; g$ A4 n# make test
# make install

2.DBD的安装
0 F3 ^4 e- P( G# 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
3 W: D" [- ]( z& n0 Z( x# make
# make install

: I% a$ e' ~; Z3 p( M2 S5 i: L3 z3.编译安装NDOUtils
, G0 Y" e! S& ^. Y. n* t# 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
* V+ j: M. ]" P  f. q1 Q( q# 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/
# chown nagios:nagios /usr/local/nagios/etc/*
; a; n7 x- ]) g# I
4.为NDOUtils创建数据库
, h/ e; i2 Q4 p* C! o  g7 ?# mysql -uroot -p
8 z. ]# Z* Z( Z9 Z: _4 Cmysql> create database nagios;
mysql> GRANT SELECT,INSERT,UPDATE,DELETE ON nagios.* TO nagios@localhost IDENTIFIED BY '123456';
/ ^7 y/ U1 y) K/ M/ e( lmysql> flush privileges;
mysql> \q
生成ndoutils所需要的数据库
, m5 e+ y- H# h; E. |9 O8 X# 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

  W% @, Y- @0 r5 u! {! j4 u. i5.编辑配置文件
/ A' X: T! s: f; X. e# vi /usr/local/nagios/etc/ndo2db.cfg
% g. w) T3 P2 ?) p) w8 C/ v$ q$ zdb_user=nagios
7 x) W; e8 o; ~( G% Odb_pass=123456
# vi /usr/local/nagios/etc/nagios.cfg
' l0 B7 _: k/ E; p8 Z8 q# 复制下面内容粘贴到#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
- m, ~) p9 H+ f
6.启动ndo2db
# /usr/local/nagios/bin/ndo2db-3x -c /usr/local/nagios/etc/ndo2db.cfg
) e* o# Q4 Z% V# echo '/usr/local/nagios/bin/ndo2db-3x -c /usr/local/nagios/etc/ndo2db.cfg' >> /etc/rc.local
# X9 M! s/ B; R1 {. H8 U  v% }* B! C
7.重启动nagios
' s% \7 J% N9 y6 l$ f# /usr/local/nagios/bin/nagios -v /usr/local/nagios/etc/nagios.cfg
, h; p) {1 K" b" p# service nagios restart

2 Y/ P8 e1 {( H检查安装

! n. ]" U8 t: Q2 l3 l# tail -20 /usr/local/nagios/var/nagios.log

8、遇到问题：
1.执行 # /usr/local/nagios/bin/ndo2db-3x -c /usr/local/nagios/etc/ndo2db.cfg
提示错误：Could not bind socket: Address already in use
" j' p, y# a& O3 {0 G7 t解决：ps aux|grep ndo2db #没有
$ j3 S3 g8 `, B( k# L查看套接字文件是否存在,删除之
  c9 [2 c! k: n
ll /usr/local/nagios/var/ndo.sock
rm /usr/local/nagios/var/ndo.sock

* X; \" `: n1 x2.#ndo2db数据不能导入到数据库
! f( o( r# P1 F原因:编译时没有LDFLAGS=-L/opt/mysql/lib
解决:重新编译ndoutils并加上 LDFLAGS=-L/opt/mysql/lib
& C# T5 p1 m- a2 v4 M) j+ v
# ./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
' x7 u5 N& P! w3 b* v# make
6 F  Y$ T; @$ C( a% @; T#再执行一下安装过程后，通过