将Nagios监控信息存入Mysql
一、NDOUtils安装需求:
nagios:安装方法:http://www.cnblogs.com/Richardzhu/p/3340638.html
mysql:源码安装方法:http://www.cnblogs.com/Richardzhu/p/3220883.html
DBI和DBD-mysql安装方法如下:
shell> perl -MCPAN -e shell
cpan> install DBI
cpan> install DBD::mysql
二、关联mysql头文件和库:
不做关联可能在config或make时出错
ln -s /app/mysql/include/* /usr/include/
ln -s /app/mysql/lib/* /usr/lib/ echo '/usr/lib' >> /etc/ld.so.conf
ldconfig -v
三、安装nodutils:
tar 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
四、拷贝文件:
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/*
五、拷贝配置文件:
cp ./config/ndo* /usr/local/nagios/etc/
chown nagios:nagios /usr/local/nagios/etc/*
六、创建ndo的mysql数据库及用户
CREATE DATABASE `nagios` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
GRANT select,insert,update,delete ON nagios.* TO nagios@localhost identified by 'nagios';
FLUSH PRIVILEGES ;
七、导入数据库结构
cd ./db/
./installdb -u root -p 123456 -h localhost -d nagios
如果这里root没有密码的话需要进行修改。
八、修改配置文件
vim /usr/local/nagios/etc/ndo2db.cfg db_user=nagios
db_pass=nagios
socket_type=tcp vim /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
output_type=file
output=/usr/local/nagios/var/ndo.dat
九、启动ndo2db
/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
service nagios restart
十一、检查安装是否正确
tail -f /usr/local/nagios/var/nagios.log
涉及的错误:
启动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); 需要修改表结构。 alter table nagios.nagios_configfilevariables drop key instance_id; alter 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
最新文章
- java多线程--几个多线程面试题小结
- SQLSERVER不带JOIN的语句与带JOIN语句的区别
- angular2 递归导航菜单实现方式
- 对MySql查询缓存及SQL Server过程缓存的理解及总结
- Oracle表与索引的分析及索引重建
- Eclipse+Axis自动生成Web Service WSDL文件
- HDOJ-ACM1097(JAVA) A hard puzzle
- C#迭代语句
- LeetCode算法题-Majority Element(Java实现)
- BSGS&;扩展BSGS
- springboot2.x版本整合redis(单机/集群)(使用lettuce)
- @property括号内属性讲解
- JS 判断IE(转)
- MYSQL启用日志,和查看日志
- 61. oracle给用户解锁
- jquery源码解析:jQuery数据缓存机制详解1
- day6 RHCE
- GCD的基本概念
- 利用索引与不用索引区别(profiles)
- [原创]Heroku简单部署指南
热门文章
- linux 入门
- Apache kafka原理与特性(0.8V)
- 做SSH练习的时候,JUunit运行遇到报错信息
- Swift vs. Objective-C:未来看好 Swift 的十个理由
- 第六篇 SQL Server代理深入作业步骤工作流
- ios理解 -- Pro Mutlithreading and Memory Management for iOS and OS X with ARC, Grand Central Dispatch, and Blocks
- redmine一键安装
- Emacs 列编辑
- Tomcat学习 HttpConnector和HttpProcessor启动流程和线程交互
- java 笔记(1)-—— JVM基础,内存数据,内存释放,垃圾回收,即时编译技术JIT,高精度类型