读取nagios数据库至mysql数据中

admin

1，首先需要安装ndoutils以将nagios的数据能导入到mysql数据库中。
3 D% Q% ]4 M, Z+ R, P) y: P, [. V        
         兼容问题：ndo2 1.4b9 换成了 1.4b7就解决没数据问题了。

确认DBD-mysql包安 装，如没有安装，请先安装。
如果DBI包没安装DBD-mysql前需要先安装DBI包
tar xzvf DBI-1.607.tar.gz
# H5 Q3 H' k) @9 L7 p, w- W4 Wcd DBI-1.607
perl Makefile.PL
make
make install

tar xzvf DBD-mysql-3.0008.tar.gz
cd DBD-mysql-3.0008
/ p3 W" [/ k; ?9 iunset LANG
4 t! q9 b0 S) V- H9 m" {perl Makefile.PL --testhost=127.0.0.1 --testuser=root --testpassword=123456
make
make install

安装mysql
apt-get install mysql-server mysql-client

wget http://sourceforge.net/projects/ ... 4b7.tar.gz/download
tar zxvf ndoutils‐1.4b7.tar.gz
4 E1 F0 X" \1 _3 n8 ~#cd ndoutils
./configure  --enable-mysql  --disable-pgsql  --with-mysql-lib=/usr/lib/mysql
make

建立Nagios数据库
Mysql –u root –p   连接数据库
Create database nagios;  创建Nagios用户
; {- ~% N0 W$ [. u' e  eGrant all on nagios.* to nagios@localhost identified by ‘nagios’   授权nagios用户，密码为 Nagios
  T' g) h4 b. {& T% {
# n. L: C7 B- i7 e- D6 \9 @0 c初始化数据库
cd ndoutils‐1.4b7
. ]6 Y  c) k. M8 S4 l1 t7 N* }cd db
1 J- }! P* E3 u. m7 d5 r8 ^./installdb -u root -p 123456 -d nagios

cp config/ndomod.cfg /usr/local/nagios/etc


$ d0 `: V: |6 P4 w
! m6 F3 |2 v) k6 x修改nagios主配置文件 #vi /usr/local/nagios/etc/nagios.cfg 添加以下内容
check_external_commands=1
2 Q' C4 S# x2 u# s6 ncommand_check_interval=‐1
event_broker_options=‐1
8 |# g( _7 k3 g4 I- I/ F! tbroker_module=/usr/local/nagios/bin/ndomod.o config_file=/usr/local/nagios/etc/ndomod.cfg
process_performance_data=1        
添加的内容至此结束
% x; ?$ o/ L8 d& L, F4 ycd src
cp ndomod‐3x.o nod2db‐3x log2ndo file2sock /usr/local/nagios/bin
+ G1 B% |9 g$ |" d* fcp src/ndo2db‐3x /usr/local/nagios/bin/ndo2db
cp config/ndo2db.cfg /usr/local/nagios/etc
cp config/ndomod.cfg /usr/local/nagios/etc
2 k( [) `# W1 Z9 Q2 n  vchmod 774 /usr/local/nagios/bin/ndo*
chown nagios:nagios /usr/local/nagios/bin/ndo*
: l/ ?" T. a- j3 s3 n: h8 |- l' O  H

修改配置文件ndocmd.cfg和ndo2db.cfg，这里我的配置文件内容为：
  }2 S7 H5 k8 u& F3 G! U+ m
; @  q3 o6 |/ x7 l[root@localhost downloads]# cat /usr/local/nagios/etc/ndomod.cfg |grep ‐v '^#'|sed /^$/d
instance_name=default
3 o3 c' A! X8 q' {/ ^output_type=tcpsocket
% D1 ^9 j3 a7 j8 @& O, G3 Ioutput=127.0.0.1
tcp_port=5668
output_buffer_items=5000
buffer_file=/usr/local/nagios/var/ndomod.tmp
file_rotation_interval=14400
8 k- u% y' F4 Y0 N5 k3 [  b% M& A" kfile_rotation_timeout=60
+ X4 p5 f; D: Z3 |/ j" kreconnect_interval=15
reconnect_warning_interval=15
& ]! v/ v  ?- q4 f1 M$ g9 ndata_processing_options=‐1
config_output_options=2
) b- @  e% x5 l- F* G
( U7 E- V8 u' h% V4 y% J
[root@localhost downloads]# cat /usr/local/nagios/etc/ndo2db.cfg |grep ‐v '^#'|sed /^$/d
ndo2db_user=nagios
ndo2db_group=nagios
socket_type=tcp
: T4 B9 \/ y: n  s# }. Vsocket_name=/usr/local/nagios/var/ndo.sock
: b) B9 }" }- Q: ktcp_port=5668
( T2 K2 \# u& z8 U0 o0 Jdb_servertype=mysql
db_host=127.0.0.1
db_port=3306
3 E2 `& k! e/ ~( b# T5 pdb_name=nagios
db_prefix=nagios_
3 v: \7 O" U3 D9 g# V9 pdb_user=nagios
db_pass=nagios
max_timedevents_age=1440
max_systemcommands_age=10080
0 ?. }+ G# q+ ~' p' Q& ?. e. Y# W8 hmax_servicechecks_age=10080
max_hostchecks_age=10080
max_eventhandlers_age=44640
  a0 M8 O# f4 R2 u3 X% wdebug_level=1
debug_verbosity=1
6 n: n1 z2 p. z. U* E  p: V. {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
. j4 K0 ^4 D1 j: m+ U' t配置完成
* g+ D5 o" C" d$ J) V5 B
查看系统日志看是否有错误信息。
tail -30 /var/log/messages

0 u# B: R. H) B* \7 O" ^9 u若有mysql_query() 不能插入的错误，即Id问题。
解决问题：mysql> ALTER TABLE ‘nagios_configfilevariables’ DROP INDEX ‘instance_id’ ,
              -> ADD INDEX ‘instance_id’ ( ‘instance_id’ , ‘configfile_id’ );
+ [, N1 v( k' H" \; `( t5 U* N  r
) I2 h7 U8 V; h9 [

admin

一、NDOUtils安装需求：
3 x% w7 T- ]9 S: c
nagios：安装方法：http://www.cnblogs.com/Richardzhu/p/3340638.html
0 n3 ?, c4 Z: S
mysql：源码安装方法：http://www.cnblogs.com/Richardzhu/p/3220883.html
/ n6 N0 x  |9 X2 |% Y+ \) l
4 O& U9 `+ p8 S2 `DBI和DBD-mysql安装方法如下：

2 G8 g' g* f1 S+ ~: Cshell> perl -MCPAN -e shell
7 K: E. ^2 l- ucpan> install DBI
/ {9 [/ |) L) ]5 K. x4 ?: E2 }cpan> install DBD::mysql
8 |. f. |$ w2 k" `1 r 二、关联mysql头文件和库：
7 A$ B8 G) I$ \2 W2 [. ?! ]
) \  A) R, w; E: K3 h. w8 p不做关联可能在config或make时出错

0 H& H3 k: t- }$ p  t  bln -s /app/mysql/include/* /usr/include/
ln -s /app/mysql/lib/* /usr/lib/

echo '/usr/lib' >> /etc/ld.so.conf
! Q! H8 B3 q& G4 nldconfig -v
5 Y3 \( M9 i# A+ y' r7 e( I: V三、安装nodutils：
# ^5 R) C4 p0 R5 u
tar zxvf ndoutils-1.4b7.tar.gz
/ a" O( W8 L# p5 [+ hcd 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
四、拷贝文件：
, R  r* c: I6 y% ~# W5 D. x
cp ./src/ndomod-3x.o /usr/local/nagios/bin
  L, v0 \! O# K6 P; c! c/ Icp ./src/ndo2db-3x /usr/local/nagios/bin
2 H$ u5 {  ], j5 j% A3 x, V4 z0 F2 gcp ./src/log2ndo /usr/local/nagios/bin
cp ./src/file2sock /usr/local/nagios/bin
chown nagios:nagios /usr/local/nagios/bin/*
2 _8 K; S0 H; A% E' O) B0 o五、拷贝配置文件：
8 @4 }( b, Q5 i0 W# o2 G5 q0 [1 G5 ]
  R; L: h( H/ ~/ B9 mcp ./config/ndo* /usr/local/nagios/etc/
chown nagios:nagios /usr/local/nagios/etc/*
六、创建ndo的mysql数据库及用户
3 Z. m6 a: J8 _* }6 ]$ i  R7 r
4 |: M. {- X3 I7 u4 n+ \8 _4 ^CREATE DATABASE `nagios` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
# d3 l7 [) D! LGRANT select,insert,update,delete ON nagios.* TO nagios@localhost identified by 'nagios';
. u' t, R" }% o+ V: c. mFLUSH PRIVILEGES ;
* r. J# n/ {# I$ s七、导入数据库结构
" g1 }' m2 t; p8 S; j2 `2 u( O8 Q, T
cd ./db/
8 u# B4 i' W2 R; n./installdb -u root -p 123456 -h localhost -d nagios
如果这里root没有密码的话需要进行修改。
; N) [/ U$ P+ z: _八、修改配置文件

% M: ~# @0 S# s8 `( e复制代码
" s1 x. ~5 w- U+ M; v' S& {vim /usr/local/nagios/etc/ndo2db.cfg

! T; X: t8 U% d6 Kdb_user=nagios
' p! }. U: l% A& p5 ]( o, @& Zdb_pass=nagios
" h/ V- z4 O* H5 s: nsocket_type=tcp

. \1 p. |) P1 @. `2 ], z* Z: svim /usr/local/nagios/etc/nagios.cfg
broker_module=/usr/local/nagios/bin/ndomod-3x.o config_file=/usr/local/nagios/etc/ndomod.cfg

vim /usr/local/nagios/etc/ndomod.cfg
6 v6 ~2 `& w# `: R7 R# B; @output_type=file
' u) n5 D$ s* |: E' |output=/usr/local/nagios/var/ndo.dat
: h: _+ j) }, ]+ H复制代码
九、启动ndo2db
, l, |, @2 A  T9 f- l* v4 n9 j
2 M' T; v# S$ }  E$ |/usr/local/nagios/bin/ndo2db-3x -c /usr/local/nagios/etc/ndo2db.cfg
十、重启nagios
  z% H, M, d' P2 Y' [9 a
/usr/local/nagios/bin/nagios -v /usr/local/nagios/etc/nagios.cfg
service nagios restart
十一、检查安装是否正确

tail -f /usr/local/nagios/var/nagios.log

涉及的错误：

& \/ T4 [9 a3 V. L启动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
+ `+ l1 k) o$ L, M4 c( t解决办法是使用：mysql -uroot --password="canada" -h192.168.1.97 -e "
alter table nagios.nagios_configfilevariables drop key instance_id;
9 K: w) ]2 W3 F" d& @, r% Zalter table nagios.nagios_configfilevariables add index (instance_id, configfile_id, varname);

需要修改表结构。
% @9 C7 d8 w% M% G5 v1 Nalter table nagios.nagios_configfilevariables drop key instance_id;
) Q9 V7 ~, B) X& i7 G- m# D# Talter table nagios.nagios_configfilevariables add index (instance_id, configfile_id, varname);
& D0 O1 |. W  U7 y% y4 o
* r: k( c0 p# z1 Z& R0 v, ctcp连接Mysql /usr/local/nagios/bin/file2sock -s /usr/local/nagios/var/ndo.dat -d localhost -t tcp -p 5668