06_ndoutils

其實不好用，使用mk-live 比較好但這邊還是貼一下步驟

#  01 安裝需要的軟體

yum install -y mariadb mariadb-server mariadb-devel

#  啟動 mysql

systemctl start mariadb.service
systemctl enable mariadb.service

# set password
/usr/bin/mysqladmin -u root password 'mypassword'


# login mysql
mysql -u root -p'mypassword'

--# Create User
CREATE DATABASE nagios DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE USER 'ndoutils'@'localhost' IDENTIFIED BY 'ndoutils_password';
GRANT USAGE ON *.* TO 'ndoutils'@'localhost' IDENTIFIED BY 'ndoutils_password' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
GRANT ALL PRIVILEGES ON nagios.* TO 'ndoutils'@'localhost' WITH GRANT OPTION ;
\q

# test

echo 'show databases;' | mysql -u ndoutils -p'ndoutils_password' -h localhost

## 02 下載


cd /tmp
wget https://sourceforge.net/projects/nagios/files/ndoutils-2.x/ndoutils-2.1.3/ndoutils-2.1.3.tar.gz/download \
-O ndoutils.tar.gz
tar -zxvf ndoutils.tar.gz

cd /tmp/ndoutils-2.1.3/
./configure
make all
make install

## Initialize Database

cd db/
./installdb -u 'ndoutils' -p 'ndoutils_password' -h 'localhost' -d nagios
cd ..

make install-config


mv /usr/local/nagios/etc/ndo2db.cfg-sample /usr/local/nagios/etc/ndo2db.cfg
sed -i 's/^db_user=.*/db_user=ndoutils/g' /usr/local/nagios/etc/ndo2db.cfg
sed -i 's/^db_pass=.*/db_pass=ndoutils_password/g' /usr/local/nagios/etc/ndo2db.cfg
mv /usr/local/nagios/etc/ndomod.cfg-sample /usr/local/nagios/etc/ndomod.cfg

## Install Service

make install-init
systemctl enable ndo2db.service
systemctl start ndo2db.service


## Update Nagios Broker

printf "\n\n# NDOUtils Broker Module\n" >> /usr/local/nagios/etc/nagios.cfg
printf "broker_module=/usr/local/nagios/bin/ndomod.o config_file=/usr/local/nagios/etc/ndomod.cfg\n" >> /usr/local/nagios/etc/nagios.cfg

## restart Nagios
systemctl restart nagios.service
systemctl status nagios.service





##

echo 'select * from nagios.nagios_logentries;' | mysql -u ndoutils -p'ndoutils_password'


## debug
grep -v '#\|^$' /usr/local/nagios/etc/ndo2db.cfg
grep -v '#\|^$' /usr/local/nagios/etc/ndomod.cfg
grep -v '#\|^$' /usr/local/nagios/etc/nagios.cfg