读取nagios数据库至mysql数据中

admin · 发表于 2018-6-22 21:10:54

1，首先需要安装ndoutils以将nagios的数据能导入到mysql数据库中。

      兼容问题：ndo2 1.4b9 换成了 1.4b7就解决没数据问题了。

确认DBD-mysql包安装，如没有安装，请先安装。
如果DBI包没安装DBD-mysql前需要先安装DBI包
tar xzvf DBI-1.607.tar.gz
cd DBI-1.607
perl Makefile.PL
make
make install

tar xzvf DBD-mysql-3.0008.tar.gz
cd DBD-mysql-3.0008
unset LANG
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
#cd ndoutils
./configure  --enable-mysql  --disable-pgsql  --with-mysql-lib=/usr/lib/mysql
make

建立Nagios数据库
Mysql –u root –p 连接数据库
Create database nagios;  创建Nagios用户
Grant all on nagios.* to nagios@localhost identified by ‘nagios’ 授权nagios用户，密码为 Nagios

初始化数据库
cd ndoutils‐1.4b7
cd db
./installdb -u root -p 123456 -d nagios

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

修改nagios主配置文件 #vi /usr/local/nagios/etc/nagios.cfg 添加以下内容
check_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
process_performance_data=1
添加的内容至此结束
cd src
cp ndomod‐3x.o nod2db‐3x log2ndo file2sock /usr/local/nagios/bin
cp src/ndo2db‐3x /usr/local/nagios/bin/ndo2db
cp 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*

修改配置文件ndocmd.cfg和ndo2db.cfg，这里我的配置文件内容为：

[root@localhost downloads]# cat /usr/local/nagios/etc/ndomod.cfg |grep ‐v '^#'|sed /^$/d
instance_name=default
output_type=tcpsocket
output=127.0.0.1
tcp_port=5668
output_buffer_items=5000
buffer_file=/usr/local/nagios/var/ndomod.tmp
file_rotation_interval=14400
file_rotation_timeout=60
reconnect_interval=15
reconnect_warning_interval=15
data_processing_options=‐1
config_output_options=2

[root@localhost downloads]# cat /usr/local/nagios/etc/ndo2db.cfg |grep ‐v '^#'|sed /^$/d
ndo2db_user=nagios
ndo2db_group=nagios
socket_type=tcp
socket_name=/usr/local/nagios/var/ndo.sock
tcp_port=5668
db_servertype=mysql
db_host=127.0.0.1
db_port=3306
db_name=nagios
db_prefix=nagios_
db_user=nagios
db_pass=nagios
max_timedevents_age=1440
max_systemcommands_age=10080
max_servicechecks_age=10080
max_hostchecks_age=10080
max_eventhandlers_age=44640
debug_level=1
debug_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
配置完成

查看系统日志看是否有错误信息。
tail -30 /var/log/messages

若有mysql_query() 不能插入的错误，即Id问题。
解决问题：mysql> ALTER TABLE ‘nagios_configfilevariables’ DROP INDEX ‘instance_id’ ,
            -> ADD INDEX ‘instance_id’ ( ‘instance_id’ , ‘configfile_id’ );

admin · 发表于 2018-6-24 13:14:46

一、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

		自动登录	找回密码
密码			注册

读取nagios数据库至mysql数据中

浏览过的版块