installation nagios ql

Nagios ql is a management tool for nagios this will make configuation very easy.
base knowledge : know to handle the centos filesystem, installation of php mysql and apache.

you need to have the following installed:

Nagios,PHP,httpd and MYSQL

Verify php version
check if your php version is at least 5.4
php -v

Update php

yum install https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
yum install http://rpms.remirepo.net/enterprise/remi-release-7.rpm
yum install yum-utils

yum-config-manager --enable remi-php70

yum install php php-mcrypt php-cli php-gd php-curl php-mysql php-ldap php-zip php-fileinfoyum install php-pear gcc curl-devel pcre-devel php-devel php zlib-devel libssh2 libssh2-devel mariadb-server php-mysql

pecl install ssh2
pear install HTML_Template_IT

get nagiosql

since the orignal repo is taken offline we will clone a repo from gitlab for this action is git required (yum install git or yum group install "Development Tools")

git clone https://gitlab.com/wizonet/nagiosql.git
add ssh2.so to php and edit time zone
nano /etc/php.ini
extension=ssh2.so
date.timezone = Europe/Brussels

Copy nagiosqlcp -vprf nagiosql /usr/local/nagios/share

Acces rights and create directorys
cd /etc/nagiosql
chown -R nagios.apache /etc/nagiosql 
mkdir -p /usr/local/nagios/etc/import 
systemctl restart mariadb 
systemctl enable mariadb 
systemctl restart httpd 
systemctl enable httpd

Configure MYSQL
mysql -u root -p
CREATE DATABASE nagios;
exit;

Web install
go to http://YOUR_IP/nagios/nagiosql

Set post install rights
 apache.nagios /etc/nagiosql;chown apache.nagios /etc/nagiosql/hosts;chown apache.nagios /etc/nagiosql/services;chown apache.nagios /etc/nagiosql/backup;chown apache.nagios /etc/nagiosql/backup/hosts;chown apache.nagios /etc/nagiosql/backup/services;chown nagios.apache /usr/local/nagios/var/rw/nagios.cmd;chown nagios.apache /usr/local/nagios/etc/nagios.cfg;chown nagios.apache /usr/local/nagios/etc/cgi.cfg; 
chown nagios.apache /usr/local/nagios/etc/resource.cfg;chown nagios.apache /usr/local/nagios/var/spool/checkresults;chown nagios:apache /usr/local/nagios/bin/nagios;chmod 6755 /etc/nagiosql;chmod 6755 /etc/nagiosql/hosts;chmod 6755 /etc/nagiosql/services;chmod 6755 /etc/nagiosql/backup;chmod 6755 /etc/nagiosql/backup/hosts;chmod 6755 /etc/nagiosql/backup/services;chmod 660 /usr/local/nagios/var/rw/nagios.cmd; 
chmod 775 /usr/local/nagios/etc/;chmod 664 /usr/local/nagios/etc/nagios.cfg;chmod 664 /usr/local/nagios/etc/cgi.cfg;chmod 750 /usr/local/nagios/bin/nagios;chmod g+x /usr/local/nagios/var/rw/;chown nagios.apache /usr/local/nagios/bin/nagios;chgrp apache /usr/local/nagios/etc/;chgrp apache /usr/local/nagios/etc/nagios.cfg;chgrp apache /usr/local/nagios/etc/cgi.cfg;chmod 775 /usr/local/nagios/etc/ 
touch /usr/local/nagios/var/nagios.lock 
chmod 664 /usr/local/nagios/var/nagios.lock 
chown nagios:nagios /usr/local/nagios/var/nagios.lock

NAGIOSQL config:

goto Administratorion -> Config targets -> modify --> config targets

adjust:
base directory = /usr/local/nagios/etc
import dir = /usr/local/nagios/etc/import
cmd file = /usr/local/nagios/var/rw/nagios.cmd
bin file = /usr/local/nagios/bin/nagios
nagios process file = /usr/local/nagios/var/nagios.local
config file = /usr/local/nagios/etc/nagios.cfg

now go to Tools--> nagios config

uncomment previous settins like (commands.cfg,contacts.cfg...)
add one line : cfg_dir=/etc/nagiosql

restart the services:

Tools-->Nagios config and click all the buttons. Restarting the service by ssh is faster (systemctl restart nagios)

Tools--> Data import --> and import your command like contacts,commands and other config files.

Note if you have exisiting host config files do not import them recreate them.