cacti与nagios整合

一、安装

#!/bin/bash
# 整合Cacti和Nagios软件安装

#安装ndoutisl的依赖包
# 安装DBI
tar -zxvf DBI-1.616.tar.gz
cd DBI-1.616
perl Makefile.PL
make && make install
# 安装DBD-mysl
wget http://search.cpan.org/CPAN/authors/id/C/CA/CAPTTOFU/DBD-mysql-4.018.tar.gz
tar xvf DBD-mysql-4.018.tar.gz -C /usr/local/soft
cd DBD-mysql-4.018
perl Makefile.PL  --with-mysql=/usr/local/mysql --mysql_config=/usr/local/mysql/bin/mysql_config
make && make install

#安装ndoutils:
wget http://nchc.dl.sourceforge.net/sourceforge/nagios/ndoutils-1.4b7.tar.gz
tar zxvf ndoutils-1.4b7.tar.gz
cd ndoutils
./configure --prefix=/usr/local/nagios  LDFLAGS=-L/usr/local/mysqllib --with-mysql-inc=/usr/local/mysql/include --with-mysql-lib=/usr/lib/mysql --enable-mysql --disable-pgsql  --with-ndo2db-user=nagios --with-ndo2db-group=nagios
make
./dbinstalldb -u cacti -pcacti123 -h localhost -d cacti 
# 或
#  mysql -u cacti -p -D cacti < db/mysql.sql
#  mysql -u cacti -p -D cacti < db/mysql-upgrade-2.0.0.sql
cp -f config/ndo2db.cfg-sample /usr/local/nagios/etc/ndo2db.cfg
cp -f config/ndomod.cfg-sample /usr/local/nagios/etc/ndomod.cfg
cp -f src/ndomod-4x.o nod2db-4x log2ndo file2sock /usr/local/nagios/bin/
cp -f daemon-init /etc/inti.d/ndo2db
chmod 744 /usr/local/nagios/bin/*
chmod +x /etc/init.d/ndo3db
chown -R nagios:nagios /usr/local/nagios

#安装php-json:
wget http://www.aurore.net/projects/php-json/php-json-ext-1.2.0.tar.bz2
tar xvjf  php-json-ext-1.2.0.tar.bz2
cd php-json-ext-1.2.0
/usr/local/php/bin/phpize            #编译前初始化php环境
./configure --with-php-config=/usr/local/php/bin/php-config
make
make install

# 安装PDO-mysql
wget http://pecl.php.net/get/PDO_MYSQL-1.0.2.tgz
tar -zxvf PDO_MYSQL-1.0.2.tgz
cd PDO_MYSQL-1.0.2
ln -s /usr/local/mysql/include/* /usr/local/include/
./configure --with-php-config=/usr/local/php/bin/php-config  --with-pdo-mysql=/usr/local/mysql
make && make install

#安装npc
wget http://dlwt.csdn.net/fd.php?i=659714146741849&s=796b68562511c6534bfc15d7b04711f4/npc-2.0.3.tar.gz
tar -zxvf npc-2.0.3.tar.gz
cp -r npc-2.0.3 /usr/local/apache/htdocs/cacti/plugins/npc

二、配置

配置ndoutils:
1.打开ndo2db.cfg，设置以下内容：
  socket_type=tcp
  db_name=cacti
  db_prefix=npc_
  db_user=cacti
  db_pass=cacti123
  debug_level=1


2.打开ndomod.cfg，设置以下内容：
  output_type=tcpsocket
  output=127.0.0.1
3.打开ndo2db，设置以下内容：
  Ndo2dbBin=/usr/local/nagios/bin/ndo2db-4x
4.设置自启动：chkconfig ndo2db on
5.启动：service ndo2db start

配置PHP：
1.打开php.ini，设置以下内容：
  extension=json.so;
  extension=pdo_mysql.so;

配置Cacti插件npc
1.启用cacti的插件功能，以admin用户登陆cacti，在console中的user management里对admin的用户权限进行编辑
，勾选上Plugin Management，然后到插件管理中心安装并启用NPC

2.在右侧栏目中选择settings,点选npc的标签钩选Remote Commands
Nagios Command File Path：     /usr/local/nagios/var/rw/nagios.cmd<这个文件启动nagios后会产生，根据实际的位置写>
Nagios URL：      http://192.168.4.60/nagios/

配置Nagios：
1.打开nagios.cfg，设置以下内容：
  broker_module=/usr/local/nagios/bin/ndomod-4x.o config_file=/usr/local/nagios/etc/ndomod.cfg
  检查以下内容：
  check_external_commands = 1
  command_check_interval = -1
  event_broker_options = -1
  process_performance_data=1

2.重启Nagios：service nagios restart

三、整合错误

1.In file included from /data1/PDO_MYSQL-1.0.2/pdo_mysql.c:31
/data1/PDO_MYSQL-1.0.2/php_pdo_mysql_int.h:25:19: error: mysql.h: No such file or directory
In file included from /data1/PDO_MYSQL-1.0.2/pdo_mysql.c:31:
/data1/PDO_MYSQL-1.0.2/php_pdo_mysql_int.h:36: error: expected specifier-qualifier-list before ‘MYSQL’
/data1/PDO_MYSQL-1.0.2/php_pdo_mysql_int.h:48: error: expected specifier-qualifier-list before ‘MYSQL_FIELD’
/data1/PDO_MYSQL-1.0.2/php_pdo_mysql_int.h:53: error: expected specifier-qualifier-list before ‘MYSQL_RES’
原因：在编译时需要mysql的头的文件,而它按默认搜索找不到头文件的位置,所以才出现这个问题
解决：将 /usr/local/mysql/include/ 目录下的mysql头文件链接到 /usr/local/include/ 的目录下:
ln -s /usr/local/mysql/include/* /usr/local/include/


2. ndo2db: Error: queue recv error. 
   ndo2db: Error: queue init error. 
   ndo2db: Error: queue recv error. 
 解决：
 vim /etc/sysctl.conf
 kernel.msgmax = 131072000  
 kernel.msgmnb = 131072000
 kernel.msgmni = 65536000 


3.ndo2db: mysql_error: 'Unknown column 'importance' in 'field list''
 解决：执行mysql-upgrade-2.0.0.sql
4.npc_commands SET ndo2db-4x: mysql_error: 'Data too long for column 'command_line' at row 1' 
 解决：扩大npc_commands表中command_line的字段长度
5.localhost ndo2db-4x: mysql_error: 'Unknown column 'long_output' in 'field list'' 
解决：
alter table nagios_eventhandlers add long_output TEXT NOT NULL after output;
alter table nagios_hostchecks add long_output TEXT NOT NULL after output;
alter table nagios_hoststatus add long_output TEXT NOT NULL after output;
alter table nagios_notifications add long_output TEXT NOT NULL after output;
alter table nagios_servicechecks add long_output TEXT NOT NULL after output;
alter table nagios_servicestatus add long_output TEXT NOT NULL after output;
alter table nagios_statehistory add long_output TEXT NOT NULL after output;
alter table nagios_systemcommands add long_output TEXT NOT NULL after output;