Nagios - NagiosQL Install

Jump to navigation Jump to search

You installed according to the Centos - Minimal Install and Post config right?

pecl install -f ssh2
touch /etc/php.d/ssh2.ini
echo > /etc/php.d/ssh2.ini
/etc/init.d/httpd graceful

Install Mysql-server if you're not using a separate server for SQL

yum install mysql-server

You will need mysql though.

yum install mysql php-mysql

Create database, user and grant permissions.

mysql> create database nagiosql1;
mysql> create user 'nagiosql1uzr'@'localhost' identified by 'rzullqsoigan';
mysql> grant all privileges on nagiosql1.* to 'nagiosql1uzr'@'localhost' identified by 'rzullqsoigan';
mysql> flush privileges;

Save the account information. You will need it later. Edit php.ini and set Timezone to America/Chicago

Unpack the archive into a folder on your webserver and visit the install page. Check and satisfy requirements. Here's a few things you will need. You should know how to do this...

Create nagiosql user, and include that user in the nagios group, include nagios in the nagiosql group as well. You should know how to do this too.

make /etc/nagiosql folder - Set owner, and perms 0777

Nagios base folder:


In NagiosQL Define Config Targets as follows. Some of these may need work.

Base directory /etc/nagiosql/	
Host directory /usr/local/nagios/etc/hosts/		
Service directory /usr/local/nagios/etc/services/		
Backup directory /usr/local/nagios/etc/backup/		
Host backup directory /usr/local/nagios/etc/backup/hosts/	
Service backup directory /usr/local/nagios/etc/backup/services/		
Nagios base directory /usr/local/nagios/etc/	
Import directory /usr/local/nagios/etc/objects/		
Picture base directory	/usr/local/nagios/share/images/logos/	

Nagios command file /usr/local/nagios/var/rw/nagios.cmd	
Nagios binary file /usr/local/nagios/bin/nagios
Nagios process file /usr/local/nagios/var/nagios.lock	
Nagios config file /usr/local/nagios/etc/nagios.cfg		


chmod 775 /usr/local/nagios/etc/nagios
chmod 664 /usr/local/nagios/etc/nagios.cfg
chmod 664 /usr/local/nagios/etc/cgi.cfg
chown apache.nagios /usr/local/nagios/etc/* -R

NagiosQL Configuration

chmod 6755 /etc/nagiosql
chmod 6755 /usr/local/nagios/etc/hosts -R
chmod 6755 /usr/local/nagios/etc/services -R
chown apache.nagios /etc/nagiosql -R

NagiosQL Backup Configuration

chmod 6755 /usr/local/nagios/etc/backup -R
chown apache.nagios /etc/nagiosql/backup -R

Amend already existing files

chmod 644 /usr/local/nagios/etc/*.cfg
chown nagios.apache /usr/local/nagios/var/rw/nagios.cmd 

The Nagios binary must be executable by the Apache user:

chown nagios.apache /usr/local/nagios/bin/nagios
chmod 750 /usr/local/nagios/bin/nagios


NagiosQL has the ability to import functional configuration files. Pay attention to the command import folder. This makes a transition to NagiosQl very easy to do. I keep backups of my config files for these cases. Things like Alerting periods, basic commands etc.