NDOUtils将Nagios监控信息存入MySQL

admin

使用NDOUtils将Nagios监控信息存入MySQL
' O2 d# t; r6 g% n. Z8 }1.NDOUtils安装需求
$ @6 \, w* o% t$ G3 T) C. y, [8 [' I3 wnagios
2 B+ l! y3 w) p  r3 Mmysql
7 k1 ?- N* ^, q3 Kcpan DBI #非必需
/ E. ?+ g" o: p2 ?cpan DBD::mysql #非必需
2.关联mysql头文件和库
0 [! o0 q9 ^' d' m" H) H5 o5 }不做关联可能在config或make时出错
6 r" g" e. r; o" `- M5 O+ [ln -s /opt/mysql/include/* /usr/include/
ln -s /opt/mysql/lib/* /usr/lib/
) o1 A0 H/ D' necho ‘/usr/lib’ >> /etc/ld.so.conf
ldconfig -v
3.安装ndoutils
0 c# b6 ?; c% H4 r9 a2 i1 h3 _http://sourceforge.net/project/showfiles.php?group_id=26589
wget -c http://nchc.dl.sourceforge.net/s ... outils-1.4b7.tar.gz
tar zxvf ndoutils-1.4b7.tar.gz
cd ndoutils-1.4b7
- J% e: N- L* v* H/ L./configure –prefix=/usr/local/nagios –enable-mysql –disable-pgsql LDFLAGS=-L/opt/mysql/lib –with-mysql-inc=/opt/mysql/include/mysql –with-mysql-lib=/opt/mysql/lib/mysql
6 Z( W3 q3 o: l$ C1 C! v, z*config时使用以下mysql参数
–with-mysql-inc=/opt/mysql/include –with-mysql-lib=/opt/mysql/lib
% @* r& M$ K/ F, D+ q8 W#config成功
#make出错
*config时使用以下mysql参数
–with-mysql-inc=/opt/mysql/include/mysql –with-mysql-lib=/opt/mysql/lib/mysql
#config出错
5 M+ m! c& U& @9 m3 T8 f6 s0 }% @#make成功并生成文件
  y; ?; z7 E: @' S#启动ndo2db会出错
" G$ ?$ U+ c6 ?7 N*没有LDFLAGS=-L/opt/mysql/lib
<del datetime="2009-05-27T06:58:24+00:00">LDFLAGS=-L/opt/mysql/lib </del>
' s* B+ t% A0 j: |#ndo2db不能导入到数据库
相关错误
8 p1 j% ]- E5 n. T4 o0 ?4 zIn file included from io.c:10:
; [- |0 w8 a5 e! X7 \- a; w+ q: |../include/config.h:261:25: mysql/mysql.h: 没有那个文件或目录
../include/config.h:262:26: mysql/errmsg.h: 没有那个文件或目录
1 t0 z; k0 F. w' cmake[1]: *** [io.o] 错误 1
checking for mysql/mysql.h… no
$ }( v  P5 B! f! J9 ^. z
3 B7 q/ [; v# \! S* p& @* |*** MySQL include file could not be located… **********************

4 K3 c3 ^0 y; F+ R6 HYou chose to compile NDBXT with MySQL support, but I was unable to
6 I4 Q7 x1 H% I0 _locate on your system. If the include file is
installed, use the –with-mysql-inc argument to specify the location
- Z6 f6 w. l- C7 x8 S4 C9 i7 zof the MySQL include file.
! o- w  M8 M/ [9 Bmake
ll ./src
看看是否有以下文件
ndo2db-2x
ndo2db-3x
9 n  X7 d/ K+ A! `3 m3 m  K6 undomod-2x.o
7 Z5 e& {. K- g7 Qndomod-3x.o
; i/ ?- T+ p( {/ O4.拷贝文件
8 r- }/ D  ^: ~2 Z9 c# A6 e. I! ]& G# 我的Nagios是3.0.6,所以拷贝的是ndomod-3x.o、ndo2db-3x,如果你的是2.X.x请拷贝ndomod-2x.o、ndo2db-2x
; Z. X! o" d) k- Y) c: \cp ./src/ndomod-3x.o /usr/local/nagios/bin
cp ./src/ndo2db-3x /usr/local/nagios/bin
cp ./src/log2ndo /usr/local/nagios/bin
cp ./src/file2sock /usr/local/nagios/bin
chown nagios:nagios /usr/local/nagios/bin/*
5.拷贝配置文件
cp ./config/ndo* /usr/local/nagios/etc/
chown nagios:nagios /usr/local/nagios/etc/*
4 H$ A- W1 ?" K6.创建ndo的mysql 数据库及用户
CREATEDATABASE`nagios`DEFAULTCHARACTERSETutf8COLLATEutf8_general_ci;
1 y. w+ [4 j# t9 y2 L" Z# HGRANT select,insert,update,deleteONnagios.*TOnagiosndo@localhostidentifiedby’password123′;
FLUSH PRIVILEGES;
7.导入数据库结构
$ ], `5 K& {# b& o% ?# s, e! l. r使用db/installdb脚本
+ i2 ]( D8 g6 F$ X2 a需要以下支持
cpan DBIcpan DBD::mysql
1 i2 a  _" x  p; wcd ./db/
: R( `2 f! n' m./installdb -u root -p 123456 -h localhost -d nagios
用命令导入(其实和用脚本是一回事,也可以用phpmyadmin来导入)
/opt/mysql/bin/mysql -u root -p -D nagios -h localhost < ./db/mysql.sql
3 E  R$ R: k! b; F5 Q; h输入密码
成功导入59张表
8.修改配置文件
& }) W: ^0 U+ ~! b9 G$ Tvi /usr/local/nagios/etc/ndo2db.cfg
db_user=nagiosndo
db_pass=password123
! z' a, l" V" `6 Bvi /usr/local/nagios/etc/nagios.cfg
; i3 M$ {! l' o* M# 修改下面参数的值为-1(一般默认如此)。
7 ?+ ?+ b8 l3 e, W, O$ y# fevent_broker_options=-1
# 复制下面内容粘贴到#broker_module=…下面。
  A: h: G( l0 p9 k# 注意broker_module= 和config_file是在一行上
# Uncomment the line below if you’re running Nagios 3.x
broker_module=/usr/local/nagios/bin/ndomod-3x.o config_file=/usr/local/nagios/etc/ndomod.cfg
9.启动ndo2db
/usr/local/nagios/bin/ndo2db-3x -c /usr/local/nagios/etc/ndo2db.cfg
* S, [+ g! L- D9 R
% z/ M, R: A# p" i% Gecho ‘rm -f /usr/local/nagios/var/ndo.sock’ >> /etc/rc.local
echo ‘/usr/local/nagios/bin/ndo2db-3x -c /usr/local/nagios/etc/ndo2db.cfg’ >> /etc/rc.local
#开机启动
Support for the specified database server is either not yet supported, or was not found on your system.
/usr/local/nagios/bin/ndo2db-3x: error while loading shared libraries: libmysqlclient.so.16: cannot open shared object file: No such file or directory
4 s/ X8 f; w2 ]! b$ \& n出现以上错误请执行第2步
10.重启动nagios
/usr/local/nagios/bin/nagios -v /usr/local/nagios/etc/nagios.cfg
service nagios restart
一般情况下到此已完成安装,可以去数据库里看下记录有无增加
11.检查安装是否正确
tail -20 /usr/local/nagios/var/nagios.log
3 y7 F1 S2 \3 c# I; c; X% ?4 x% `[1242971625] ndomod: Successfully flushed 80 queued items to data sink.[1242971625] ndomod: Error writing to data sink! Some output may get lost…
* J$ W* y% d9 l貌似有点问题
) b/ _1 J( U% Y先改成输出成文件#vi ndomod.cfg
instance_name=default
#output_type=tcpsocket
/ Z' D5 F+ f: i' R. ~#output=127.0.0.1
, ]: ^( b* H; f8 H, l  T3 n
( z; ^- V7 N9 woutput_type=file
output=/usr/local/nagios/var/ndo.dat
. |( q: e, ?$ T$ Qservice nagios restart
0 R: X. T; r( F8 `看看有没有/usr/local/nagios/var/ndo.dat文件,ok,发现文件,说明第一步可以生成文件查看文件内容
' d" I0 q. G& P: Dcd /usr/local/nagios/var/
; s& X8 N4 m. M; |/ Jhead -30 ndo.dat
- R* {. E$ C& z5 q/ T
HELLO
PROTOCOL: 2
AGENT: NDOMOD
4 H; f5 M3 v- ~% w5 `AGENTVERSION: 1.4b7
+ Y$ V4 v& @  p# ~$ RSTARTTIME: 1243393299
DISPOSITION: REALTIME
CONNECTION: FILE
; x1 }% ^% h7 F% ]4 XCONNECTTYPE: INITIAL
INSTANCENAME: default
) H* L5 S( z6 _8 T* h: }% NSTARTDATADUMP
% D" f  b% z# v
$ d4 ]3 s: U4 }5 @
202:
1=300
2=0
3=0
& \/ \# h+ w% ?0 E4=1243393292.450675
9 P% k" W- L& N73=1243393292
* U; G8 J! m( ^; L# N; C2 H74=262144
  f* O" |' G: e0 b3 _& `72=ndomod: Error writing to data sink!  Some output may get lost…
' l; D% M5 o& B5 Y999



  @+ P0 t! h7 r% s201:
( q5 p! E% O8 h1=205
( _0 t0 M/ f' E" X: C9 X& w2 j3 N2=0
使用file2sock尝试socket方式
../bin/file2sock -s /usr/local/nagios/var/ndo.dat -d /usr/local/nagios/var/ndo.sock -t unix -p 5668
Error while writing to destination socket: Connection reset by peer
- X5 F8 R0 {- s' P尝试tcp方式
vi ndo2db.cfg
6 a5 x7 e  R5 d$ B' j' {0 H#socket_type=unix
socket_type=tcp
重新载入ndo2db
0 W. |2 b* I& W! v: aps aux|grep ndo2db
kill $pid
/usr/local/nagios/bin/ndo2db-3x -c /usr/local/nagios/etc/ndo2db.cfg

../bin/file2sock -s ndo.dat -d localhost -t tcp -p 5668
Error while writing to destination socket: Connection reset by peer
' |0 u. E+ H/ g; |# ^$ _依然不行,重新编译ndoutils并加上 LDFLAGS=-L/opt/mysql/lib
; t5 W  k* c. y./configure –prefix=/usr/local/nagios –enable-mysql –disable-pgsql LDFLAGS=-L/opt/mysql/lib –with-mysql-inc=/opt/mysql/include/mysql –with-mysql-lib=/opt/mysql/lib/mysql
; G" g0 e$ M/ J  emake
+ Q6 e5 x  V. f1 t#再执行一下安装过程后,通过
6 q- y" e, R, C) A=================200912-07 更新
tail /var/log/messages
Dec  7 14:09:13 localhost nagios: ndomod: Still unable to connect to data sink.  10547 items lost, 5000 queued items to flush.
2 I1 e( V1 Y/ p3 I4 EDec  7 14:09:29 localhost nagios: ndomod: Still unable to connect to data sink.  10746 items lost, 5000 queued items to flush.
连接不到mysql,重启一下
/usr/local/nagios/bin/ndo2db-3x -c /usr/local/nagios/etc/ndo2db.cfg
Could not bind socket: Address already in use
ps aux|grep ndo2db没有
0 }: @8 B) n; j' U% t查看套接字文件是否存在,删除之
ll /usr/local/nagios/var/ndo.sock
rm /usr/local/nagios/var/ndo.sock
重启/usr/local/nagios/bin/ndo2db-3x -c /usr/local/nagios/etc/ndo2db.cfg
tail /var/log/messages
+ m9 {4 }7 p3 Y* I/ Z: KDec  7 14:09:45 localhost nagios: ndomod: Successfully connected to data sink.  10861 items lost, 5000 queued items to flush.
Dec  7 14:09:45 localhost nagios: ndomod: Successfully flushed 5000 queued items to data sink.
Dec  7 14:09:45 localhost ndo2db-3x: Successfully connected to MySQL database

admin

1.DBI的安装
# wget http://www.cpan.org/modules/by-module/DBI/DBI-1.608.tar.gz
) U) _: q% W( b3 z3 a) a# tar zxvf DBI-1.608.tar.gz
# cd DBI-1.608
6 s) B4 M$ a( M! @# perl Makefile.PL
# make
# make test
# make install
' W: p6 |: A0 r( b& L2.DBD的安装
) F8 t# k2 Z! i1 p# wget http://www.cpan.org/modules/by-module/DBD/DBD-mysql-4.011.tar.gz
( S8 N+ ^3 H& P" S3 |7 x4 i5 v, Q7 V# tar -zxvf DBD-mysql-4.011.tar.gz
# cd DBD-mysql-4.011
# perl Makefile.PL --mysql_config=/usr/local/mysql/bin/mysql_config --libs=-L/usr/local/mysql/lib-static -lmysqlclient
# make
" ~3 q' p+ w) ~) h2 M( ^4 {# make install
" T; w2 F, N9 K6 A( W
, ^+ D0 b& D# [" M& C
3.关联mysql头文件和库
# ln -s /usr/local/mysql/lib/mysql/* /usr/lib
4 Y9 [. ?  a! T. S1 O6 b0 B0 i# ln -s /usr/local/mysql/include/mysql/* /usr/include
# ldconfig -v
  b# i: H" n! p, D: C& L7 V8 T" U
2 s! {8 t  d# G4.编译安装NDOUtils
# tar zxf ndoutils-1.4b9.tar.gz
% w3 \) J0 e7 A# \/ ^' I3 @# cd ndoutils-1.4b9
; S! r3 j7 p3 H* k9 b# ./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

# cp ./src/ndomod-3x.o /usr/local/nagios/bin
# cp ./src/ndo2db-3x /usr/local/nagios/bin
# cp ./src/log2ndo /usr/local/nagios/bin
# cp ./src/file2sock /usr/local/nagios/bin
# chown nagios:nagios /usr/local/nagios/bin/*
( |' l, _6 |- B& h
# cp ./config/ndo* /usr/local/nagios/etc/
, a% u1 I3 O9 H4 }- i# chown nagios:nagios /usr/local/nagios/etc/*

2 \5 b3 i# o& G. n+ q5.为NDOUtils创建数据库
# mysql -uroot -p
" a1 z1 o+ _3 X- N/ A; O, h2 pmysql> create database ndodb;
5 ?! [8 v0 x3 `5 R6 C/ `mysql>grant all on ndodb.* to 'ndouser'@'%' identified by '123456';
mysql> flush privileges;
mysql> /q
生成ndoutils所需要的数据库
# cd db
# ./installdb -u n root -p 123456 -h localhost -d ndodb
也可这样：# /opt/mysql/bin/mysql -u root -p -D nagios -h localhost < ./db/mysql.sql
! N/ }" ^- n, u' s0 A1 {0 J- X3 W
( M2 Y& l5 w8 x$ ]. f9 Q  H; C6.编辑配置文件
# vi /usr/local/nagios/etc/ndo2db.cfg
, j. b8 F: L9 ddb_user=nagios
. O2 x) n* E0 p" J8 |db_pass=123456
$ W7 v; V: r8 J# vi /usr/local/nagios/etc/nagios.cfg
% r. B& ~1 h$ }) \) \. _4 t8 Q# 复制下面内容粘贴到#broker_module＝...下面。
, s* G. S% |$ j* K7 K* Dbroker_module=/usr/local/nagios/bin/ndomod-3x.o config_file=/usr/local/nagios/etc/ndomod.cfg
- I0 n! v7 t$ G2 J3 H此外，请确保您的/usr/local/nagios/etc/nagios.cfg中有如下行出现，否则，请自行添加：
$ N! c/ V  t0 q9 u% E: V4 Cevent_broker_options=-1 //为Nagios开启event broker
3 M9 K! }0 `; p2 ]& P
. x, b* l3 a  }! |( w7启动ndo2db
3 K; Q4 n( y- `( E" U; C5 v  p# /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

# l% \5 B/ f9 t. |8.重启动nagios
0 q1 k2 ?( m4 c# /usr/local/nagios/bin/nagios -v /usr/local/nagios/etc/nagios.cfg
: N6 v* o" k. z3 f( K2 S- t# service nagios restart
: X5 {1 x& x; m0 N# ~( [检查安装
  ~4 P7 ]8 h$ ]# o2 ?% ^# P$ a( mtail -20 /usr/local/nagios/var/nagios.log
8 p- I" i5 c" \- L$ B# _" W8 V+ V

遇到问题：
1.执行 # /usr/local/nagios/bin/ndo2db-3x -c /usr/local/nagios/etc/ndo2db.cfg
! P0 R4 Z0 {5 J提示错误：Could not bind socket: Address already in use
: j! b  t2 V' l: Q! Q! k( f0 Z" d* c解决：ps aux|grep ndo2db #没有
查看套接字文件是否存在,删除之
+ h3 d  Q( \. e$ _ll /usr/local/nagios/var/ndo.sock
rm /usr/local/nagios/var/ndo.sock
2.#ndo2db数据不能导入到数据库
3 i( v6 l7 J. g原因:编译时没有LDFLAGS=-L/opt/mysql/lib
解决:重新编译ndoutils并加上 LDFLAGS=-L/opt/mysql/lib
# ./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
#再执行一下安装过程后，通过

admin

1.NDOUtils安装需求：
+ f* F# f' H5 J/ ]Nagios正确安装运行，版本>=2.0安装目录：/usr/local/nagios
$ V- k5 L$ U4 V* FMySQL正确安装并运行，我用的是二进制安装包，安装目录：/usr/local/mysql
2.安装
6 j% c$ I( g/ I- |6 D下载安装包：http://www.nagios.org/download/
#　确认DBD-mysql包安装，如没有安装，请先安装。
# 如果DBI包没安装DBD-mysql前需要先安装DBI包
8 O4 K; f! }3 J+ J. g6 \9 Vtar xzvf DBI-1.605.tar.gz
* ]( R0 z% e2 M/ G0 k+ L7 ^, Hcd DBI-1.605
perl Makefile.PL
make
make install
7 m0 X# f% @8 o! V# itar xzvf DBD-mysql-3.0008.tar.gz
cd DBD-mysql-3.0008
1 T0 i& P9 {8 c3 P/ Yunset LANG
perl Makefile.PL --libs="-L/usr/local/mysql/lib/mysql -lmysqlclient -L/usr/lib -lz " --cflags=-
4 D: M+ P1 X4 _I/usr/local/mysql/include/mysql --mysql_config=/usr/local/mysql/bin/mysql_config --testhost=127.0.0.1 --
testsocket=/usr/local/mysql/tmp/mysql.sock --testdb=nagios --testuser=root --testpassword=123456
+ x( u( M$ k4 W* f# f- l0 k8 v2 Y3 Omake
make install
" I$ `$ `0 A' u6 @#　做好MySQL库文件lib和include文件的连接（这点很重要）。
ln -s /usr/local/mysql/include/* /usr/include/
mkdir /usr/include/mysql
ln -s /usr/local/mysql/include/* /usr/include/mysql/
( H4 B0 [! \. hln -s /usr/local/mysql/lib/* /usr/lib/
5 k+ F' L: S% Lmkdir /usr/lib/mysql
+ r- T$ _+ ^+ y' |5 nln -s /usr/local/mysql/lib/* /usr/lib/mysql
% y$ B/ p0 U8 Y- p" T* V  Ctar xzvf ndoutils-1.4b7.tar.gz
cd ndoutils-1.4b7
: k' p& k: R. K8 Y1 y./configure --enable-mysql --disable-pgsql --with-mysql-lib=/usr/local/mysql/lib --with-mysql-inc=/usr/local/mysql/include

#　执行完成后，注意向上看看打印出的信息，看看是否找到了MySQL的库文件和include文件。
make
cd src/
0 Z" G. p5 S/ |+ ?+ @/ M#　我的Nagios是3.0.5，所以拷贝的是ndomod-3x.o、ndo2db-3x，如果你的是2.X.x请拷贝ndomod-2x.o、ndo2db-2x
& h7 x2 I& _: T6 K9 Pcp ndomod-3x.o ndo2db-3x log2ndo file2sock /usr/local/nagios/bin
) R/ h" h/ Y* \8 g9 P/ Bcd ../db
% i) q, q7 o  [: M7 x#　创建数据库，使用root用户，密码是123456
/usr/local/mysql/mysqldadmin -u root -p
1 W9 I* C. T' G& P' M/ A- L' nmysql> CREATE DATABASE nagios;
2 a% [" |: @. R/ S) F9 L./installdb -u root -p 123456 -d nagios(这需要改下installdb脚本,指定mysql的可执行程序在哪,否则报不能发现mysql命令在哪
.)
#　拷贝配置文件
cd ../config
cp ndo* /usr/local/nagios/etc/
#　修改/usr/local/nagios/etc/ndo2db.cfg文件的数据库信息。
vi /usr/local/nagios/etc/ndo2db.cfg
* s, _" r  R4 v2 h3 [$ Q7 e) ]- k* Evi nagios.cfg
#　复制下面内容粘贴到/usr/local/nagios/etc/nagios.cfg配置文件的#broker_module＝...下面。
# Uncomment the line below if you're running Nagios 3.x
broker_module=/usr/local/nagios/bin/ndomod-3x.o config_file=/usr/local/nagios/etc/ndomod.cfg
$ Q6 N& Z6 y3 |' z, A! G, ?#　修改/usr/local/nagios/etc/nagios.cfg配置文件下面参数的值为-1（一般默认如此）。
event_broker_options=-1
# 启动ndo2db
- U7 S( q- Y+ Q0 Z" ?' x3 K% R1 y/usr/local/nagios/bin/ndo2db-3x -c /usr/local/nagios/etc/ndo2db.cfg
# 查看系统日志是否有错误信息：
6 e& E2 M; P( x0 m4 j& m. ]tail -30 /var/log/messages
Nov 27 14:09:26 tech nagios: ndomod: NDOMOD 1.4b7 (10-31-2007) Copyright (c) 2005-2007 Ethan Galstad
(nagios@nagios.org)
" d  `% [" E. K" s% k1 p* O1 x# ^Nov 27 14:09:26 tech nagios: ndomod: Successfully connected to data sink. 0 queued items to flush.
Nov 27 14:09:26 tech nagios: Event broker module '/usr/local/nagios/bin/ndomod-3x.o' initialized successfully.
! R! I7 f, a) E# p4 p4 G- w% M# J! vNov 27 14:09:26 tech nagios: Finished daemonizing... (New PID=18848)
: N" e1 ^' O$ }7 S, f# 重启Nagios
service nagios restart
# 查看Nagios日志，看是否正常启动。
tail -20 /usr/local/nagios/var/nagios.log
4 j9 `/ N! \0 }: F# H) w[1227766166] ndomod: NDOMOD 1.4b7 (10-31-2007) Copyright (c) 2005-2007 Ethan Galstad (nagios@nagios.org)
[1227766166] ndomod: Successfully connected to data sink. 0 queued items to flush.
[1227766166] Event broker module '/usr/local/nagios/bin/ndomod-3x.o' initialized successfully.
. T7 {$ Q; e3 n, j% y[1227766166] Finished daemonizing... (New PID=18848)
##############这里要说明下启动ndo2db那步骤我没做,修改了ndo2db.cfg,ndomod.cfg里面的相关socket type选项及数据库相关项,
0 @. \" f5 P/ z) p$ \$ Z) |" Y6 D之后直接service nagios restart,如果做的话出现错误提示请看下面解决办法###########
, ?" l" D6 c6 t. H2 h关于启动ndo出现错误提示：
* ?* F# v2 o1 @1. 如果启动后出现错误：Could not bind socket: Address already in use
解决解决办法是将/usr/local/nagios/var/ndo.sock删除，停止ndo的时候这个文件不会被删除，可以自己写个启动脚本将这个文件删
除后在启动ndo。
2. 启动ndo后在日志中出现：nagios ndo2db-3x: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables
$ z7 a3 H& ?- LSET 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);
需要修改表结构。
" J$ i7 W# a3 i6 i关于出现mysql相关(DBD,perl)错误提示:
1. 如在make 阶段出错
   (1)类、、、、make: *** [dbdimp.o] 错误 1
多半是库文件的问题，（--cflags=-I/usr/local/mysql/include/mysq 细查，少个“y"
   （2）类 LD_RUN_PATH="/usr/lib/mysql:/lib:/usr/lib" gcc
    -o blib/arch/auto/DBD/mysql/mysql.so -shared
    -L/usr/local/lib dbdimp.o mysql.o -L/usr/lib/mysql
    -lmysqlclient -lm -L/usr/lib/gcc-lib/i386-redhat-linux/2.96
! z1 w8 c  K: O# _5 [( n    -lgcc -lz
) k9 `, S1 b; H: m4 E: i/usr/bin/ld: cannot find -lz
collect2: ld returned 1 exit status
% P; M, Z2 N# L& Ymake: *** [blib/arch/auto/DBD/mysql/mysql.so] Error 1
1 t4 H7 F$ u/ v" R( a与压缩包有关。可用 ldconfig -p | grep libz
                     ldconfig -p | grep libgz
   查找，如有并指定路径！否则安装 libz-devel／ibgz-devel／zlib-devel／    gzlib-devel
2. 在make test 阶段出错:
/ a1 {6 R4 ^- Z2 t(1)类: install_driver(mysql) failed: Can't load
' h# e3 i2 `; `'/usr/lib/perl5/site_perl/i586-linux/auto/DBD/mysql/mysql.so'
9 T" k2 E  A6 T' ?1 L8 [' Jfor module DBD::mysql: File not found at
+ H4 |! A0 r( k2 T6 \7 w) ?& S2 q: y/usr/lib/perl5/i586-linux/5.00404/DynaLoader.pm line 166
与 /usr/lib/mysql/libmysqlclient.a有关 （cp libmysqlclient.a /us/lib)
- b1 B, r9 e  N1 G7 K(2)类： t/00base............install_driver(mysql) failed: Can't load
# \$ C% L) d* P' `'../blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql:
../blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: _umoddi3
at /usr/local/perl-5.005/lib/5.005/i586-linux-thread/DynaLoader.pm
line 168.
与libgcc.a 有关 (cp /usr/lib/gcc/i386-redhat-linux/4.1.1/libgcc.a /usr/local/lib/
8 U$ c! V6 h# S- N, E(3) 类：Can't load libmysqlclient.so.15 、、、、
$ V( @& B, [4 l     （cp libmysqlclient.so.15 /us/lib)