Firstly, make sure you have installed Nagios core service. Else use our previous articles for installation steps of Nagios core service on Redhat based systems or Debian based system. Now read this article to install NagiosQL3 web interface for Administration of Nagios server using web interface. If you have installed Nagios core service with some other type. Please be careful with directories and files path and configuration files.
We have successfully configured and integrated NagiosQL with Nagios using below steps. But we can not sure that it will 100% work for you. You may get few errors during setup. Feel free to ask related to any issues on comments for our question/answers section.
Step 1 – Install Required Packages
First, we need to install required packages, Use the following commands to install them.
RedHat Based Systems:
yum install libssh2 libssh2-devel mysql mysql-server php-mysql php-pear php-devel pecl install ssh2 ##if above command not worked use below else skip it pecl install channel://pecl.php.net/ssh2-0.12
Debian Based Systems:
sudo apt-get install libssh2-1 libssh2-1-dev mysql mysql-server sudo apt-get install php-mysql php-pear php-devel php-ssh2 php-gettxt
Step 2 – Download NagiosQL3 Archive
Download the latest available nagiosql3 archive and extract in Nagios document root using commands.
cd /usr/local/nagios/share wget http://sourceforge.net/projects/nagiosql/files/nagiosql/NagiosQL%203.2.0/nagiosql_320.tar.gz tar xzf nagiosql_320.tar.gz mv nagiosql32 webadmin chown -R apache:apache . chmod -R 775 .
Step 3 – Setup PHP Timezone
Edit php.ini file and update following variable with required timezone. Click here to get list of available timezone
1 2 3 4 5 | [Date] ; Defines the default timezone used by the date functions ; http://www.php.net/manual/en/datetime.configuration.php#ini.date.timezone date.timezone = 'Asia/Kolkata' |
Restart Apache web server after editing PHP configuration.
service httpd restart
Step 4 – Start NagiosQL3 Web Installer
NagiosQL3 provides web installer to install package. Open below URL to start web installer for nagiosql. follow steps as shown in URL. Web installer will help you about for any changes required.
http://svr1.tecadmin.net /nagios/webadmin/install/index.php
4.1: Start Installation Wizzard
Open the above url and click the button
4.2: Verify Requirements
At this screen, installer will check the required packages are installed or not. If you see any error on this screen, fix that manually and click
4.3: NagiosQL Setup
In this step installer will input the database details to be used for nagiosql. Also update the nagiosql path values as per given screenshots. Click
If you have installed Nagios at some other place, only then change the values of the path.
4.4: Finishing Setup
This screen showing that all the steps has successfully completed. You just need to click
4.5: NagiosQL Login
After completing installation, you will be redirected to NagiosQL login screen.
Step 5 – Access NagiosQL3 Web UI
After completing web installer, it will automatically redirect you to the nagiosql3 admin panel. To open it later using URL.
http://svr1.tecadmin.net /nagios/webadmin
Step 6 – Integrate NagiosQL3 with Nagios
This is the most important part of NagiosQL setup, It may be your setup is different than me, so be careful with below step. I am trying my best to write to complete integration.
6.1 – Edit NagiosQL Configuration
Login to NagiosQL administrator section and navigate to Administration -> Administration -> Config targets and click on Modify button for Local installation.
At the below screen, you will find configuration file path, make sure all folder exists in the first section and check the file’s path with Nagios core configuration file.
6.2 – Edit Nagios Core Configuration File
Now edit nagios configuration file /usr/local/nagios/etc/nagios.cfg and commend all earlier cfg_file and cfg_dir configuration settings and add new cfg_dir with /usr/local/nagios/nagiosql only.
cfg_file=/usr/local/nagios/nagiosql/commands.cfg cfg_file=/usr/local/nagios/nagiosql/contactgroups.cfg cfg_file=/usr/local/nagios/nagiosql/contacts.cfg cfg_file=/usr/local/nagios/nagiosql/contacttemplates.cfg cfg_file=/usr/local/nagios/nagiosql/hostdependencies.cfg cfg_file=/usr/local/nagios/nagiosql/hostescalations.cfg cfg_file=/usr/local/nagios/nagiosql/hostextinfo.cfg cfg_file=/usr/local/nagios/nagiosql/hostgroups.cfg cfg_file=/usr/local/nagios/nagiosql/hosttemplates.cfg cfg_file=/usr/local/nagios/nagiosql/servicedependencies.cfg cfg_file=/usr/local/nagios/nagiosql/serviceescalations.cfg cfg_file=/usr/local/nagios/nagiosql/serviceextinfo.cfg cfg_file=/usr/local/nagios/nagiosql/servicegroups.cfg cfg_file=/usr/local/nagios/nagiosql/servicetemplates.cfg cfg_file=/usr/local/nagios/nagiosql/timeperiods.cfg cfg_dir=/usr/local/nagios/nagiosql/hosts cfg_dir=/usr/local/nagios/nagiosql/services
Step 7 – Restart Nagios Core Service
Finally, verify Nagios core configuration file and restart service using commands.
/usr/local/nagios/bin/nagios -v /usr/local/nagios/etc/nagios.cfg
If above command shows no errors on screen, restart Nagios core service
service nagios restart
References:
http://www.nagios.org/about
while installing nagiosql, it is giving error in mysql extension.
”Mysql not available’
Although ia have installed mysql and all its extensions for php.
Hi Rahul, im facing this problem:
Access denied for user ‘mysqladmin’@’localhost’ to database ‘db_nagiosql_v34’
Database server connection (privileged user) passed (mysqli)
Database server version 5.7.24-0ubuntu0.18.04.1
Database server support supported
Delete existing NagiosQL database done (db_nagiosql_v34)
Creating new database done (db_nagiosql_v34)
Installing NagiosQL database tables done
Create NagiosQL database user failed
i tried with root user and mysqladmin but its the same error.
Thanks in advance.
Please!
How to fix error: Write test on settings directory (config/): failed
i have a question related to step 6.2 of u’r instuctions.
after confirming that all dirs exist and all file listed in the 2nd section r consistent with the pathnames in
nagios.cfg, step 6.2 tells me to comment out all the cfg_dir and cfg_file defs and change to the pathnames you list. (/usr/local/nagios/nagiosql…)
won’t this render the settings in step 6.1?
what am i misunderstanding here?
tnx
ams
Hi! I’m having error after successfully finishing the guide. It always prompt me an invalid login.
And one question more, is it okay if the Database Type is set to mysqli? In this guide, it only shows mysql.
Thnks!
– MD
Yes, its fine. MySQLi is the improved version of mysql php module.
Are you facing issue on NagiosQL admin login? or web server basic authentication configured with Nagios core?
Hi Rahul,
Yes, I’m having problem logging in. It always say “login failed’ even though my login credentials is correct.
Can you help me, fix my issue? 🙁
Thank you!
Hi Rahul,
Yes I’m still having issues upon login. I always gets a ‘Login Failed!’ error.
Anther thing, if anyone is having issue when trying to set the time zone then just copy and past this CLI in. when you locate the time zone and add your time zone in, remember to remove the # or it will not work.
nano /etc/php5/apache2/php.ini
Also, if anyone is having this issue then enter in this CLI (maybe not recommend but is a work around then spending hours and hours)
if you get this error then this should be the fix.
cd /etc/
mkdir nagiosql
chmod -R 775 nagiosql/
chown -R nagios.apache nagiosql/
mkdir nagios
chmod -R 775 nagios
chown -R nagios.apache Nagios
chmod -R 777 /etc/
Write failed error, then just copy and past this in
(Write test on settings directory (config/): failed)
The below command resolved the issue for me
chmod -R 777 /usr/local/nagios/share/nagiosql32/