读取nagios数据库至mysql数据中

admin

1，首先需要安装ndoutils以将nagios的数据能导入到mysql数据库中。
# a7 Y2 m1 e9 }        
- l9 U% g: z$ u/ e% C3 E* C         兼容问题：ndo2 1.4b9 换成了 1.4b7就解决没数据问题了。

7 c# Z3 V8 ?7 I* V- H' Z! n( w% b确认DBD-mysql包安 装，如没有安装，请先安装。
2 D1 _: f6 J3 p$ S! J/ S如果DBI包没安装DBD-mysql前需要先安装DBI包
8 J% @+ P2 w# ~/ ?& A" L! Ntar xzvf DBI-1.607.tar.gz
cd DBI-1.607
perl Makefile.PL
2 b) k* T! f4 _. ]: K. smake
make install
, t# d0 S* _0 A( Z
tar xzvf DBD-mysql-3.0008.tar.gz
! E. Q  \+ F  r& }4 j, x' Icd DBD-mysql-3.0008
) W5 B# N) n* Q3 J/ v5 v; z0 L# ~unset LANG
perl Makefile.PL --testhost=127.0.0.1 --testuser=root --testpassword=123456
9 }; V9 z' n3 Y  q$ K  A5 I3 Qmake
make install

安装mysql
1 y; G( O( S# M9 C7 }5 c& Napt-get install mysql-server mysql-client
* p- X9 r0 Y& N9 m( h( m4 E
/ W3 w" z0 ]/ E) K& bwget http://sourceforge.net/projects/ ... 4b7.tar.gz/download
tar zxvf ndoutils‐1.4b7.tar.gz
#cd ndoutils
& Z& K6 {6 G3 |) m4 u./configure  --enable-mysql  --disable-pgsql  --with-mysql-lib=/usr/lib/mysql
  k) _& v- M( e; D' C8 {3 Emake
. Y, j) U3 B9 k6 l" ^' Z  E
建立Nagios数据库
8 x: I: f& i! X7 w. fMysql –u root –p   连接数据库
Create database nagios;  创建Nagios用户
Grant all on nagios.* to nagios@localhost identified by ‘nagios’   授权nagios用户，密码为 Nagios
2 j) F+ ?" m8 Y& \
初始化数据库
$ @# w5 L) x3 F+ Gcd ndoutils‐1.4b7
cd db
9 j4 S6 G/ }& B./installdb -u root -p 123456 -d nagios

3 [2 t4 M, T3 N  F3 ], P6 Qcp config/ndomod.cfg /usr/local/nagios/etc
0 `+ G/ b7 @+ v. Q4 r; V
* ~5 @1 s) P; I1 z# }* B
/ G" W4 W6 W' A0 }. K9 O; ^) F+ O) Q
修改nagios主配置文件 #vi /usr/local/nagios/etc/nagios.cfg 添加以下内容
2 A7 j# k1 {; b: w  pcheck_external_commands=1
command_check_interval=‐1
event_broker_options=‐1
broker_module=/usr/local/nagios/bin/ndomod.o config_file=/usr/local/nagios/etc/ndomod.cfg
6 v/ q4 `$ p  ~) w0 R& ?process_performance_data=1        
添加的内容至此结束
cd src
, K1 P$ e! v9 S" p! ycp ndomod‐3x.o nod2db‐3x log2ndo file2sock /usr/local/nagios/bin
cp src/ndo2db‐3x /usr/local/nagios/bin/ndo2db
: {- Q. G; `& }! Fcp config/ndo2db.cfg /usr/local/nagios/etc
cp config/ndomod.cfg /usr/local/nagios/etc
chmod 774 /usr/local/nagios/bin/ndo*
chown nagios:nagios /usr/local/nagios/bin/ndo*
. j9 n+ c7 o  C
1 G/ D# {& @& M. L% C2 K
5 N7 P' |' ?  k  n1 @7 H2 k修改配置文件ndocmd.cfg和ndo2db.cfg，这里我的配置文件内容为：
. n) L% c8 l& N% G
% J4 S8 [8 r9 f1 T[root@localhost downloads]# cat /usr/local/nagios/etc/ndomod.cfg |grep ‐v '^#'|sed /^$/d
instance_name=default
8 x( X- G- [9 ]: s+ e. c; Routput_type=tcpsocket
2 x" Y( \" X  ]output=127.0.0.1
0 A0 S6 o9 k' M5 d3 J$ htcp_port=5668
output_buffer_items=5000
buffer_file=/usr/local/nagios/var/ndomod.tmp
file_rotation_interval=14400
8 y/ Q9 w9 k0 W0 ~  _( i0 t' bfile_rotation_timeout=60
reconnect_interval=15
reconnect_warning_interval=15
data_processing_options=‐1
8 m- |$ K. |( E! b. x' f2 nconfig_output_options=2


$ a0 s. g7 v7 p5 K$ d[root@localhost downloads]# cat /usr/local/nagios/etc/ndo2db.cfg |grep ‐v '^#'|sed /^$/d
; u' J* J% B; Indo2db_user=nagios
$ Z! }' W3 y' L" V) c1 Ondo2db_group=nagios
# R6 ]; Y! P  ~2 u5 R  N/ m, Vsocket_type=tcp
& |0 j5 B! h" k# V- H% Q4 |socket_name=/usr/local/nagios/var/ndo.sock
tcp_port=5668
$ N, t  m, L' S! ddb_servertype=mysql
db_host=127.0.0.1
db_port=3306
) c' v% A4 T7 e0 d1 v' y5 Gdb_name=nagios
! s3 D2 {0 i) U9 Xdb_prefix=nagios_
db_user=nagios
db_pass=nagios
4 d. k7 P' O" Z9 x$ X7 [; d: ]! ]& Gmax_timedevents_age=1440
max_systemcommands_age=10080
1 V) b7 ]* C2 v' \max_servicechecks_age=10080
max_hostchecks_age=10080
max_eventhandlers_age=44640
debug_level=1
9 R. j: C1 k( z- l4 r0 Wdebug_verbosity=1
debug_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
配置完成

查看系统日志看是否有错误信息。
- o" ]" e! y8 C) A" G1 {% ftail -30 /var/log/messages

5 R! o% Q% E- C- c& H+ i7 `若有mysql_query() 不能插入的错误，即Id问题。
解决问题：mysql> ALTER TABLE ‘nagios_configfilevariables’ DROP INDEX ‘instance_id’ ,
              -> ADD INDEX ‘instance_id’ ( ‘instance_id’ , ‘configfile_id’ );
( q; T, q5 r4 j

admin

一、NDOUtils安装需求：

nagios：安装方法：http://www.cnblogs.com/Richardzhu/p/3340638.html

8 X, Q" i) K+ w& D: z0 emysql：源码安装方法：http://www.cnblogs.com/Richardzhu/p/3220883.html

! l: v, r) l+ u; {$ {6 A# RDBI和DBD-mysql安装方法如下：

) k* `8 a5 D9 l! w( Sshell> perl -MCPAN -e shell
$ M9 i- I4 o( {cpan> install DBI
cpan> install DBD::mysql
/ j+ @6 p% n* r3 y+ r8 ?, V! X 二、关联mysql头文件和库：

: ]2 x; @6 D% N不做关联可能在config或make时出错
6 F9 X; E( t- R7 A% [. l
ln -s /app/mysql/include/* /usr/include/
5 ~+ K& C1 n5 ~. L/ W* Y7 M8 xln -s /app/mysql/lib/* /usr/lib/

5 I, ?  O* F$ p% vecho '/usr/lib' >> /etc/ld.so.conf
ldconfig -v
  Z( c/ }/ b1 d7 U2 _0 M2 X5 H三、安装nodutils：
8 _) P- L* Y$ h+ P1 b" ]7 q6 i
tar zxvf ndoutils-1.4b7.tar.gz
% ?, ?5 y* ?# Q; Ucd ndoutils-1.4b7
0 Z* d! J$ ]; H: P& x6 ~./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
四、拷贝文件：

cp ./src/ndomod-3x.o /usr/local/nagios/bin
cp ./src/ndo2db-3x /usr/local/nagios/bin
/ i' @' B0 {# fcp ./src/log2ndo /usr/local/nagios/bin
cp ./src/file2sock /usr/local/nagios/bin
chown nagios:nagios /usr/local/nagios/bin/*
五、拷贝配置文件：
) T9 Q0 i/ e! _$ s" ]7 C9 m7 k
cp ./config/ndo* /usr/local/nagios/etc/
chown nagios:nagios /usr/local/nagios/etc/*
六、创建ndo的mysql数据库及用户

% v$ C  K" E0 y" w* y- e7 FCREATE DATABASE `nagios` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
2 _0 B% y( I+ V6 l9 i$ Z# _/ y2 iGRANT select,insert,update,delete ON nagios.* TO nagios@localhost identified by 'nagios';
( V' ?( b! W0 _( XFLUSH PRIVILEGES ;
' }# F; ~( A9 b% f; U七、导入数据库结构

1 L1 p+ @4 F, Acd ./db/
./installdb -u root -p 123456 -h localhost -d nagios
$ r, D( f6 [' V' t/ I如果这里root没有密码的话需要进行修改。
4 V# `" S5 v) e( s' ~" |. q1 }八、修改配置文件

复制代码
7 Y5 C/ p4 ~8 t' |vim /usr/local/nagios/etc/ndo2db.cfg
* n7 [2 u" `" f
8 F- |8 I( [5 p0 qdb_user=nagios
& U0 o( `1 h; }) J  R# _db_pass=nagios
socket_type=tcp

/ l8 ]1 g1 h) O$ n- Gvim /usr/local/nagios/etc/nagios.cfg
8 X4 L: }4 O" U- Tbroker_module=/usr/local/nagios/bin/ndomod-3x.o config_file=/usr/local/nagios/etc/ndomod.cfg
: \, b  X5 x! I! u7 K
vim /usr/local/nagios/etc/ndomod.cfg
# c- e! H' c9 o/ Y' ~3 xoutput_type=file
output=/usr/local/nagios/var/ndo.dat
复制代码
8 q) m3 m0 c0 M# @# I) S+ T0 [九、启动ndo2db

+ P+ T( n+ T  F  u4 e$ Q/usr/local/nagios/bin/ndo2db-3x -c /usr/local/nagios/etc/ndo2db.cfg
十、重启nagios
6 K( J+ w) ]0 I. J. x0 F* I/ T7 W3 ^
/usr/local/nagios/bin/nagios -v /usr/local/nagios/etc/nagios.cfg
service nagios restart
十一、检查安装是否正确

0 H9 ]+ i! e; z9 y. y2 ltail -f /usr/local/nagios/var/nagios.log

涉及的错误：

* \& ~7 p( e: D4 R2 {; `启动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 "
alter table nagios.nagios_configfilevariables drop key instance_id;
alter table nagios.nagios_configfilevariables add index (instance_id, configfile_id, varname);
, l1 E. r0 r# y! Q8 R6 C
9 Z) h. \7 h1 h: P5 u% T( Q/ t需要修改表结构。
2 w0 M% N1 z1 X0 ~) ]+ Malter table nagios.nagios_configfilevariables drop key instance_id;
( G' ~2 J# d* K' x* talter table nagios.nagios_configfilevariables add index (instance_id, configfile_id, varname);
# y$ J  Q6 C5 `, s( K
tcp连接Mysql /usr/local/nagios/bin/file2sock -s /usr/local/nagios/var/ndo.dat -d localhost -t tcp -p 5668