读取nagios数据库至mysql数据中

admin

1，首先需要安装ndoutils以将nagios的数据能导入到mysql数据库中。
        
         兼容问题：ndo2 1.4b9 换成了 1.4b7就解决没数据问题了。

' @$ p) `; ^  X! N  B确认DBD-mysql包安 装，如没有安装，请先安装。
如果DBI包没安装DBD-mysql前需要先安装DBI包
& Q, n% p$ Z; a8 [, y8 C1 Rtar xzvf DBI-1.607.tar.gz
, i9 d% H  c/ W& jcd DBI-1.607
9 \! K% {) c( T) s$ m; n/ Eperl Makefile.PL
make
$ [* M6 F% J( L6 qmake install
1 ]8 N3 R% J4 u( w& h
tar xzvf DBD-mysql-3.0008.tar.gz
cd DBD-mysql-3.0008
6 N* F, A/ ~+ T2 _' Hunset LANG
perl Makefile.PL --testhost=127.0.0.1 --testuser=root --testpassword=123456
/ A8 u4 g2 f7 f5 p( M* imake
2 D' |: y; M9 ?2 U/ p" M: P9 omake install

安装mysql
# k% m* s3 }$ G5 `* F4 a1 eapt-get install mysql-server mysql-client
8 U5 w# H1 ~' _( u+ [
wget http://sourceforge.net/projects/ ... 4b7.tar.gz/download
tar zxvf ndoutils‐1.4b7.tar.gz
5 `. a8 f  W+ `" S* W#cd ndoutils
./configure  --enable-mysql  --disable-pgsql  --with-mysql-lib=/usr/lib/mysql
- q2 {+ u" q9 i8 O+ H* g& D7 Nmake

建立Nagios数据库
Mysql –u root –p   连接数据库
Create database nagios;  创建Nagios用户
Grant all on nagios.* to nagios@localhost identified by ‘nagios’   授权nagios用户，密码为 Nagios

初始化数据库
1 W6 `2 }9 x9 @5 G3 @! J& C3 I0 D. Hcd ndoutils‐1.4b7
cd db
./installdb -u root -p 123456 -d nagios

4 P2 r( X- r1 G  R: F  c  |cp config/ndomod.cfg /usr/local/nagios/etc


0 t- a+ p& E! ^( u7 }) f1 p  {- d. p
; ^& v/ s6 }. ?# f5 P) y0 R修改nagios主配置文件 #vi /usr/local/nagios/etc/nagios.cfg 添加以下内容
check_external_commands=1
  e% N( T( Y2 h9 E$ o7 X" i) m; Acommand_check_interval=‐1
event_broker_options=‐1
( X, w6 r/ s$ y4 w7 abroker_module=/usr/local/nagios/bin/ndomod.o config_file=/usr/local/nagios/etc/ndomod.cfg
) M) W. N, b% E/ t5 R, I9 A% I6 Rprocess_performance_data=1        
添加的内容至此结束
- ^# H" I2 k' k5 Fcd src
, T2 S+ |2 s' pcp ndomod‐3x.o nod2db‐3x log2ndo file2sock /usr/local/nagios/bin
cp src/ndo2db‐3x /usr/local/nagios/bin/ndo2db
cp config/ndo2db.cfg /usr/local/nagios/etc
: H  A$ g* Q! ]; S! hcp config/ndomod.cfg /usr/local/nagios/etc
chmod 774 /usr/local/nagios/bin/ndo*
chown nagios:nagios /usr/local/nagios/bin/ndo*

$ y4 c4 v5 h# v0 V$ V
修改配置文件ndocmd.cfg和ndo2db.cfg，这里我的配置文件内容为：

# T; Y3 p/ Q8 i1 D, P: n1 B, X[root@localhost downloads]# cat /usr/local/nagios/etc/ndomod.cfg |grep ‐v '^#'|sed /^$/d
( A9 e& k2 c5 b! X# qinstance_name=default
4 P& `) H' k! g9 ~7 ?  c. Loutput_type=tcpsocket
: D6 _6 n0 [9 J4 `) w" ?output=127.0.0.1
tcp_port=5668
output_buffer_items=5000
buffer_file=/usr/local/nagios/var/ndomod.tmp
; e- f  }3 f# |file_rotation_interval=14400
file_rotation_timeout=60
9 X/ C. w& M% j* c3 q$ M1 R" ireconnect_interval=15
reconnect_warning_interval=15
+ U2 j2 {6 \: R. U- Gdata_processing_options=‐1
config_output_options=2
" ]) E4 b; B% V. Z
- ^9 j* S, O6 X/ k) T
( {& `# ~  H1 j4 g/ W  u5 E' F[root@localhost downloads]# cat /usr/local/nagios/etc/ndo2db.cfg |grep ‐v '^#'|sed /^$/d
! j. M, d; h2 D8 Gndo2db_user=nagios
9 k) R5 f2 W* |8 j( b3 z  @. A2 endo2db_group=nagios
0 g7 ^) y- }  t& usocket_type=tcp
socket_name=/usr/local/nagios/var/ndo.sock
; N) y. p- P' o3 n& jtcp_port=5668
/ p. Z7 Y' E3 O- r1 Z: p2 C3 r# u4 jdb_servertype=mysql
# H# a4 k- v6 E1 `, _3 w* Tdb_host=127.0.0.1
8 b: j7 \: [6 V1 ?6 \2 Ndb_port=3306
db_name=nagios
db_prefix=nagios_
db_user=nagios
db_pass=nagios
max_timedevents_age=1440
  p0 B+ _- p# U2 r* nmax_systemcommands_age=10080
max_servicechecks_age=10080
max_hostchecks_age=10080
- C, s  |2 J( N# Hmax_eventhandlers_age=44640
# X7 w! {* d( T9 tdebug_level=1
debug_verbosity=1
3 r8 D# C1 z# H2 B, Cdebug_file=/usr/local/nagios/var/ndo2db.debug
max_debug_file_size=1000000
   #/usr/local/nagios/bin/ndo2db ‐c /usr/local/nagios/etc/ndo2db.cfg ---------启动ndo2db
! }# L" ~; S; S7 p8 R1 c  {配置完成

/ z* Q4 W: Q4 V9 k' X& }查看系统日志看是否有错误信息。
2 x7 d% ^7 O! x& c! A2 rtail -30 /var/log/messages
$ Q0 D2 }6 k6 p, g7 T' F- f8 D
0 V6 ]5 x) E+ S若有mysql_query() 不能插入的错误，即Id问题。
解决问题：mysql> ALTER TABLE ‘nagios_configfilevariables’ DROP INDEX ‘instance_id’ ,
              -> ADD INDEX ‘instance_id’ ( ‘instance_id’ , ‘configfile_id’ );

. d8 T* T* ]: s/ R  ?1 j3 ]

admin

一、NDOUtils安装需求：
# Z, _& G9 [. ]$ i$ `
, U# L3 Y) l; Anagios：安装方法：http://www.cnblogs.com/Richardzhu/p/3340638.html

mysql：源码安装方法：http://www.cnblogs.com/Richardzhu/p/3220883.html
3 j6 u) f5 d) h7 o, n
DBI和DBD-mysql安装方法如下：

shell> perl -MCPAN -e shell
cpan> install DBI
cpan> install DBD::mysql
$ Q# `- D3 p! v 二、关联mysql头文件和库：

. P+ {" \% }. A3 t$ w% u0 R: b不做关联可能在config或make时出错

3 S0 r+ S0 m: vln -s /app/mysql/include/* /usr/include/
* x, K3 Q; |$ {# @ln -s /app/mysql/lib/* /usr/lib/
+ r; L( x# ^" n  C2 R" v0 [/ [1 A; \
echo '/usr/lib' >> /etc/ld.so.conf
, F* u/ h9 k6 wldconfig -v
三、安装nodutils：
6 ?6 B1 J5 ^* z; y. ^
8 A$ f9 o9 [) U8 Q. H* S5 Ftar zxvf ndoutils-1.4b7.tar.gz
cd ndoutils-1.4b7
./configure --prefix=/usr/local/nagios --enable-mysql --disable-pgsql LDFLAGS=-L/app/mysql/lib --with-mysql-inc=/app/mysql/include/mysql --with-mysql-lib=/app/mysql/lib/mysql
make
四、拷贝文件：

% ?: p" ]9 z5 C9 Vcp ./src/ndomod-3x.o /usr/local/nagios/bin
cp ./src/ndo2db-3x /usr/local/nagios/bin
cp ./src/log2ndo /usr/local/nagios/bin
3 u- L1 k- N3 d' M% `0 Qcp ./src/file2sock /usr/local/nagios/bin
  a/ Q) w. @/ Qchown nagios:nagios /usr/local/nagios/bin/*
五、拷贝配置文件：
0 g/ \# m8 Z4 L. w" c
cp ./config/ndo* /usr/local/nagios/etc/
% G' @# }, O- V0 ?chown nagios:nagios /usr/local/nagios/etc/*
六、创建ndo的mysql数据库及用户

) [; ^2 i6 a" \' `CREATE DATABASE `nagios` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
GRANT select,insert,update,delete ON nagios.* TO nagios@localhost identified by 'nagios';
8 i5 }- i) W. M/ G4 A7 A& HFLUSH PRIVILEGES ;
七、导入数据库结构
5 M; M& m2 m, L
cd ./db/
./installdb -u root -p 123456 -h localhost -d nagios
如果这里root没有密码的话需要进行修改。
八、修改配置文件
* c! \/ n% i1 [2 j6 r3 m8 ~
复制代码
8 A3 a& g# y) S1 y4 W4 E. svim /usr/local/nagios/etc/ndo2db.cfg
) }, \* g' e( c1 q+ m
. P- N6 K9 a+ Z% q1 t! v' {; `db_user=nagios
. r) r* @( \  Y/ Ddb_pass=nagios
socket_type=tcp
) C8 U7 ]; z# k6 Y2 w  j
  ?3 ]1 _1 D- |0 W* u$ E+ yvim /usr/local/nagios/etc/nagios.cfg
broker_module=/usr/local/nagios/bin/ndomod-3x.o config_file=/usr/local/nagios/etc/ndomod.cfg

: R6 Z$ N# y6 J6 e4 n( mvim /usr/local/nagios/etc/ndomod.cfg
0 j$ g$ s% }! a5 G3 xoutput_type=file
output=/usr/local/nagios/var/ndo.dat
1 R6 ^' S9 W' l5 L: @复制代码
九、启动ndo2db

4 C  n* J8 N- I1 b1 `. O+ x/ X3 v/usr/local/nagios/bin/ndo2db-3x -c /usr/local/nagios/etc/ndo2db.cfg
十、重启nagios

/usr/local/nagios/bin/nagios -v /usr/local/nagios/etc/nagios.cfg
) V$ ?- t% D. {, V& E# zservice nagios restart
: M3 A7 E1 ]. I- t+ y" D十一、检查安装是否正确

tail -f /usr/local/nagios/var/nagios.log
1 M  c; k/ A2 `6 r" V, j
. h) c4 ^) m) A9 ~/ c涉及的错误：

启动ndo后在日志中出现：  nagios ndo2db-3x: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='3', varname='cfg_file', varvalue='/usr/local/nagios//etc/objects/localhost\.cfg
解决办法是使用：mysql -uroot --password="canada" -h192.168.1.97 -e "
( s" j8 {' l* P2 f% [% g! Talter table nagios.nagios_configfilevariables drop key instance_id;
alter table nagios.nagios_configfilevariables add index (instance_id, configfile_id, varname);

需要修改表结构。
( E" B3 X/ t6 c9 p4 Q0 R7 o4 }alter table nagios.nagios_configfilevariables drop key instance_id;
' N) r( j/ k0 H) D/ R8 f% salter table nagios.nagios_configfilevariables add index (instance_id, configfile_id, varname);

tcp连接Mysql /usr/local/nagios/bin/file2sock -s /usr/local/nagios/var/ndo.dat -d localhost -t tcp -p 5668