How to Setup NagiosQL3 with Nagios Core on CentOS, Redhat and Fedora

Written by
Rahul K.
Monitoring Tools, Nagios 51 Comments

Welcome to Part 2 setup instructions. We assume you have completed Step 1 – Installing Nagios Core Service successfully. 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.

nagiosql_logo
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.

# yum install libssh2 libssh2-devel mysql mysql-server php-mysql

Also install ssh2 pecl extension for php. You can use one of below commands to install it.

# pecl install ssh2

[if above command not worked use below else skip it]

# pecl install channel://pecl.php.net/ssh2-0.12

Step 2: Download NagiosQL3 and Extract

Download latest available nagiosql3 archive and extract in nagios document root using below 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: Set Up Timezone

Edit php.ini file and update following variable with required timezone. Click here to get list of available timezone

date.timezone = 'Asia/Kolkata'

We also need to restart Apache server after editing php configuration time.

# 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 showing 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 START INSTALLATION

nagiosql-1

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 Next
nagiosql-2

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 Next

nagiosql-3-3

If you have installed nagios at some other place, only then change the values of path.

4.4: Finishing Setup

This screen showing that all the steps has successfully completed. You just need to click Next
nagiosql-4

4.5: NagiosQL Login

After completing installation, you will be redirected to NagiosQL login screen.
nagiosql-5

Step 5: Access NagiosQL3 Web Interface

After completing web installer, it will automatically redirect you to nagiosql3 admin panel. To open it later use below url.

http://svr2.tecadmin.net/nagios/webadmin

Step 6: Configure NagiosQL3 with Nagios Core

This is the most important part of NagiosQL setup, It may be your setup is different that 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.

nagiosql-config-1

At the below screen, you will find configuration file path, make sure all folder exists in first section and check the files path with Nagios core configuration file.

nagiosql-config-2

6.2: Edit Nagios Core Configuration File

Now edit nagios configuration file ( Eg: /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/contacts.cfg
 #cfg_file=/usr/local/nagios/nagiosql/timeperiods.cfg
 #cfg_file=/usr/local/nagios/nagiosql/templates.cfg
 #cfg_file=/usr/local/nagios/etc/objects/localhost.cfg
 #cfg_file=/usr/local/nagios/etc/objects/windows.cfg
 #cfg_file=/usr/local/nagios/etc/objects/switch.cfg
 #cfg_file=/usr/local/nagios/etc/objects/printer.cfg

 cfg_dir=/usr/local/nagios/nagiosql 

 #cfg_dir=/usr/local/nagios/etc/servers
 #cfg_dir=/usr/local/nagios/etc/printers
 #cfg_dir=/usr/local/nagios/etc/switches
 #cfg_dir=/usr/local/nagios/etc/routers

Step 7: Restart Nagios Core Service

Finally verify nagios core configuration file and restart service using below commands.

# /usr/local/nagios/bin/nagios -v /usr/local/nagios/etc/nagios.cfg

If above command show no errors on screen, restart nagios core service

# service nagios restart

Congratulation’s You have successfully installed Nagios with NagiosQL3.

References:
http://www.nagios.org/about
http://www.nagiosql.org/documentation.html

Rahul K.
Rahul K.
Connect on Facebook Connect on Twitter Connect on Google+

I, Rahul Kumar is the founder and chief editor of TecAdmin.net. I am Red Hat Certified Engineer (RHCE) and working as IT professional since 2009.

51 Comments

  1. MD Reply to MD
    August 15, 2017 at 4:10 am

    Hi,

    I followed the instructions and successfully finished the setup. But when I click the “finish” button, I’m back to the first page of installation. I did repeat the installation but still looping back to first page.

    Please help!

    • Rahul K. Rahul K. Reply to Rahul
      August 15, 2017 at 11:29 am

      Hi, I think you didn’t removed “install” directory.

      • MD Reply to MD
        August 16, 2017 at 2:50 am

        Yeah, I thought it’s okay not to remove the directory.

        Now that I completed the installation, I can’t login to NagiosQL. 🙁

        There’s a red text below login…

        Error while selecting data from database
        :Access denied for user ‘apache’@’localhost’ (using password: NO)

        Already gave privileges to apache user. Not sure what to do next. Please help 🙁

  2. ken Reply to ken
    April 24, 2016 at 7:29 pm

    installing SE linux enforcing, I had to do these to get green for everything on the page “NagiosQL Installation: Checking requirements”

    After this step: # mv nagiosql32 webadmin

    # touch /usr/local/nagios/share/webadmin/config/settings.php
    # semanage fcontext -a -t httpd_nagios_rw_content_t /usr/local/nagios/share/webadmin/config/settings.php
    # restorecon -v /usr/local/nagios/share/webadmin/config/settings.php

    and before this step: # chown -R apache:apache .

  3. Adrian Romo Reply to Adrian
    April 13, 2016 at 9:48 pm

    Hello everybody I hope you can help me, I actually installed everything but when try to setup Nagiosql via browser I have an error message ” Settings file not found or not readable (config/settings.php). Upgrade not available! ”
    what do I have to do? I had other issues that I fixed by myself. But with this I need assistance.

    Thank you!

  4. Luqman Reply to Luqman
    March 29, 2016 at 7:23 am

    Hi,

    I just installed nagios core 4.x, then when about to install nagiosQL, error on requirement “Write test on settings directory (config/): failed”. Is it because I used nagios 4.x? I even change the dir to 777 but no luck.

  5. Matt Reply to Matt
    March 24, 2016 at 6:15 pm

    I ran into this problem “Write test on settings directory (config/): failed” and can’t figure out how to fix it even though I tried to chmod the config folder at /usr/local/nagios/webadmin/config to 777 and other random permissions.

    Is there another config file at a different location I should be dinking with?

  6. Jishnu Reply to Jishnu
    March 8, 2016 at 4:24 pm

    Everything work, the installations. But after a restart from nagiosql, the config file is not getting reloaded. Forced to do a restart from command line. Any comments?

  7. Tomasz Reply to Tomasz
    December 14, 2015 at 2:51 pm

    Hi

    I did everything like in intructions but get that error ;/
    http://imgur.com/a/GbUCz
    Any idea why? What do?

  8. sandeep Kumar Reply to sandeep
    November 3, 2015 at 9:29 am

    Please write down here how can i resolve sql database problem with command line and how can i connect sql on command line , please write all steps

  9. sandeep Kumar Reply to sandeep
    November 3, 2015 at 6:00 am

    I am stuck in this step, please help

    NagiosQL Installation: Finishing Setup

    Create new NagiosQL database
    Error while connecting to database:
    Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
    Database server connection (privileged user) failed

  10. sandeep Kumar Reply to sandeep
    October 30, 2015 at 11:28 am

    I am not getting “php.ini” file, how to fix this problem, where to add timezone??

    • Rahul K. Rahul Reply to Rahul
      October 31, 2015 at 5:28 pm

      Try following command to find file

      php -i | grep “php.ini”

      • sandeep Kumar Reply to sandeep
        November 3, 2015 at 5:59 am

        Thanks rahul, it was helpful, but i stuck in next step, please help to resolve

        NagiosQL Installation: Finishing Setup

        Create new NagiosQL database
        Error while connecting to database:
        Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
        Database server connection (privileged user) failed

  11. arun Reply to arun
    August 23, 2015 at 1:25 pm

    Good doc, some more info can be added for an L board like us, like permission, do and donts will help too.
    Thanks for the doc

  12. Balkishan Singh Reply to Balkishan
    July 14, 2015 at 9:43 am

    Hello guys,
    Please refer to the following commands to set up the nagiosql.
    step 1: installing nagios on centos

    http://tecadmin.net/install-nagios-core-service-on-centos-rhel/
    http://tecadmin.net/install-nagiosql-with-nagios-core-on-centos-rhel/

    prob1: Setting up variable of date.timeZone=Asia/kolkata(Note: Remove semi collan before date.timezone)

    prb2: Setting SSH2 Not availabe issue:

       soln: http://programster.blogspot.in/2013/06/centos-64-install-ssh2-extension-for-php.html

    prob3: Write test on settings directory(config/):failed

        soln 1st:  # echo 0 >/selinux/enforce
                       # sed -i ‘s/SELINUX=enforcing/SELINUX=disable/’ /etc/selinux/config
       
        soln 2nd: # service iptables stop
                       # chkconfig iptables off
                       # gedit /etc/selinux/config
      edit selinux=Disabled and Save.
       #reboot

    Prob4: NagiosQL Installation Setup Finishing
    mysql.sock error or something 
    DB creation Permission is denied for [email protected]

    Soln:
         # service mysqld start
         # chkconfig mysqld on
         # mysql_secure_installation 
         #   mkdir /etc/nagiosql
         #chown apache.apache /etc/nagiosql/

  13. madhav Reply to madhav
    June 17, 2015 at 10:55 am

    heyy Rahul
    I think i am facing problem in Step 4.3 Nagiosql Setup.
    After clicking next it shows

    Error while connecting to database:
    Access denied for user ‘root’@’localhost’ (using password: YES)
    Database server connection (privileged user) failed

    I tried everything still no success. If u can help me out it would of great help.

  14. Luis Reply to Luis
    April 21, 2015 at 12:54 am

    Well everything is fine, some inconsistency here (permissions to nagios and not including apache) but fine…

    My issue is that when I try to save configurations or any other stuff by clicking on the SAVE button, it makes nothing, zero, nada. If I click on Abort or any other part of the menu its fine… so I think it has to be something with saving permsissionsmore than with a JS….
    Any idea?

  15. Padraig Reply to Padraig
    February 22, 2015 at 11:33 pm

    I have spent all day trying to get this to work. I have got as far as the Installation page. For my NagiosQL config path I have /usr/local/nagios
    For my Nagios config path I have /usr/local/nagios/etc. This is where Nagios seems to be installed on my Centos 6.6
    But the problem is, when I click in to the next screen, I get “NagiosQL config path is not writeable – only database values updated”
    My eyes are now sore from Googling and I am so tired from trying to get past this stage all day where I nearly feel like giving up 🙁
    I assume this is some permissions problem, but how can I fix it?

  16. Pradeep Kumar Reply to Pradeep
    January 1, 2015 at 2:47 pm

    Hi Rahul,

    While running below command I am getting three errors

    /usr/local/nagios/bin/nagios -v /usr/local/nagios/etc/nagios.cfg

    Nagios Core 4.0.7
    Copyright (c) 2009-present Nagios Core Development Team and Community Contributors
    Copyright (c) 1999-2009 Ethan Galstad
    Last Modified: 06-03-2014
    License: GPL

    Website: http://www.nagios.org
    Reading configuration data…
    Read main config file okay…
    Read object config files okay…

    Running pre-flight check on configuration data…

    Checking objects…
    Error: There are no services defined!
    Checked 0 services.
    Error: There are no hosts defined!
    Checked 0 hosts.
    Checked 0 host groups.
    Checked 0 service groups.
    Error: There are no contacts defined!
    Checked 0 contacts.
    Checked 0 contact groups.
    Checked 0 commands.
    Checked 0 time periods.
    Checked 0 host escalations.
    Checked 0 service escalations.
    Checking for circular paths…
    Checked 0 hosts
    Checked 0 service dependencies
    Checked 0 host dependencies
    Checked 0 timeperiods
    Checking global event handlers…
    Checking obsessive compulsive processor commands…
    Checking misc settings…

    Total Warnings: 0
    Total Errors: 3

    ***> One or more problems was encountered while running the pre-flight check…

    Check your configuration file(s) to ensure that they contain valid
    directives and data defintions. If you are upgrading from a previous
    version of Nagios, you should be aware that some variables/definitions
    may have been removed or modified in this version. Make sure to read
    the HTML documentation regarding the config files, as well as the
    ‘Whats New’ section to find out what has changed.

    Thanks
    Pradeep

  17. quod Reply to quod
    November 12, 2014 at 2:44 pm

    Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)

  18. dumindu Reply to dumindu
    October 20, 2014 at 7:16 am

    after step 6.2: Edit Nagios Core Configuration File step 7 gives below error

    Nagios Core 4.0.7
    Copyright (c) 2009-present Nagios Core Development Team and Community Contributors
    Copyright (c) 1999-2009 Ethan Galstad
    Last Modified: 06-03-2014
    License: GPL

    Website: http://www.nagios.org
    Reading configuration data…
    Read main config file okay…
    Read object config files okay…

    Running pre-flight check on configuration data…

    Checking objects…
    Error: There are no services defined!
    Checked 0 services.
    Error: There are no hosts defined!
    Checked 0 hosts.
    Checked 0 host groups.
    Checked 0 service groups.
    Error: There are no contacts defined!
    Checked 0 contacts.
    Checked 0 contact groups.
    Checked 0 commands.
    Checked 0 time periods.
    Checked 0 host escalations.
    Checked 0 service escalations.
    Checking for circular paths…
    Checked 0 hosts
    Checked 0 service dependencies
    Checked 0 host dependencies
    Checked 0 timeperiods
    Checking global event handlers…
    Checking obsessive compulsive processor commands…
    Checking misc settings…

    Total Warnings: 0
    Total Errors: 3

    ***> One or more problems was encountered while running the pre-flight check…

    Check your configuration file(s) to ensure that they contain valid
    directives and data defintions. If you are upgrading from a previous
    version of Nagios, you should be aware that some variables/definitions
    may have been removed or modified in this version. Make sure to read
    the HTML documentation regarding the config files, as well as the
    ‘Whats New’ section to find out what has changed.

    when uncommitted error 0

    please help

  19. israel Reply to israel
    September 17, 2014 at 4:24 pm

    hello, i have an issue when i try to restart nagios from nagiosql it seems that nagios was restarted because it says Reset command sent to Nagios successfully but its not true because any change takes effect, please help me i’am using nagios core 4.0.7 and nagiosql 3.2.0

  20. johnnie Reply to johnnie
    September 17, 2014 at 4:21 pm

    hello, i have an issue when i try to restart nagios from nagiosql it seems that nagios was restarted because it says Reset command sent to Nagios successfully but its not true because any change takes effect, please help me i’am using nagios core 4.0.7 and nagiosql 3.2.0

  21. Wardha Anjum Reply to Wardha
    September 8, 2014 at 10:39 am

    Hi Rahul,
    Your article helped me to install Nagios and NagiosQL successfully. Thanks for your article. I am having an issue, I can add host on NagiosQL successfully, and can see it on Hosts panel and database also. But the information in not updating in Nagios. As I heard, If I add any host in NagiosQL, it will show on Nagios automatically. Could please help me on this?? Can you please tell me from which file Nagios get the host information from NagiosQL. Thanks once again.

  22. Ronald Reply to Ronald
    August 4, 2014 at 5:11 pm

    I am still getting came.

    Where do i place this folder i give rights to.

    Please please i need help on this part. I am desperate. Real newbe here

    when running the web gui and it does it checks i get write test on settings directory (config/):failed

    Thanks

  23. Ronald Reply to Ronald
    August 4, 2014 at 12:59 pm

    Thanks i will try again today

  24. Ronald Reply to Ronald
    August 3, 2014 at 3:28 pm

    Thanks so much for the fine work but i think i need to give up on this one.

    there is some step somewhere missing on this how to.

    i get when running the web gui and it does it checks i get write test on settings directory (config/):failed

    no getting around it and 2 days is enough time thanks

  25. Ronald Reply to Ronald
    August 3, 2014 at 3:05 am

    when running the web gui and it does it checks i get write test on settings directory (config/):failed

    how can i fix this?

    Thanks!

    • Lyall Reply to Lyall
      August 3, 2014 at 1:40 pm

      What I did to get around it was to create the /etc/nagios directory as it did not exist. Then set the rights to 777. You will change the config path later anyways. This will just get you buy that error so you can keep going. Probably not the way it should be done but it got me working. Hth.

      • Ronald Reply to Ronald
        August 4, 2014 at 2:51 pm

        still get Write test on settings directory (config/): failed

        What can i do to correct this. ugggg i suck a Linux.

        I made the dir as suggested
        mkdir /etc/nagios

        chown -R apache:apache /etc/nagios
        [[email protected] share]# chmod -R 777 /etc/nagios
        [[email protected] share]#

  26. Lyall Reply to Lyall
    July 25, 2014 at 10:17 pm

    Thanks for the tut, very helpful so far.

    On step 4.3, i get
    “NagiosQL config path is not writeable – only database values updated”
    I have everything just like the screenshot. Everything is “pass” or “done” but for “Create and/or store NagiosQL path settings.” It reports fail and the above error message is displayed at the top.

    Thanks again for the help!

    • Vijay Reply to Vijay
      July 28, 2014 at 9:55 am

      Hi Lyall,

      Give full permission to nagios configuration files and try. It worked for me guess it should help u.

    • Sandeep Kumar Patial Reply to Sandeep
      May 23, 2016 at 1:49 pm

      My Name is Sandeep Fix for this error.
      “NagiosQL config path is not writeable – only database values updated”
      This error is occurred when there is no directory in the path given for Nagios Config file, so create dir and grant permissions. Here we go.

      [[email protected] ~]# cd /etc/
      [[email protected] etc]# mkdir nagiosql
      [[email protected] etc]# chmod -R 775 nagiosql/
      [[email protected] etc]# chown -R nagios.apache nagiosql/
      [[email protected] etc]# mkdir nagios
      [[email protected] etc]# chmod -R 775 nagios
      [[email protected] etc]# chown -R nagios.apache nagios

      Retry again for QL installation. This should fix the issue.

  27. Vijay Reply to Vijay
    July 24, 2014 at 12:20 pm

    Hi Folks,

    I couldn’t find that php.ini file any where in my machine so i couldn’t enter the time zone, which eventually throws an error. My machine configuration is Centos -6.4 with 8 Gb ram i5 processor.

    Thanks
    Vijay

  28. Murfatlar Reply to Murfatlar
    April 21, 2014 at 10:59 pm

    Hello,
    did’t work for me , I guess something is missing
    The requested URL /nagios/webadmin/install/index.php was not found on this server.

  29. Kim Reply to Kim
    April 10, 2014 at 3:52 pm

    hi,

    Thanks for article. This worked fine but do you have any idea if how to configure monitoring for Dell powerconnect switch (which is a stack) via plugin (script) in nagiosQL? I have found plugin here http://exchange.nagios.org/directory/Plugins/Hardware/Network-Gear/Dell/PowerConnect-Switches/details but dont know how to proceed..

    Regards,
    Kim

    • Rahul K. Rahul Reply to Rahul
      April 11, 2014 at 11:20 am

      Hi Kim,

      First confirm if plugin is working properly from nagios server.

      1. Download plugin file to server
      2. Run following command and check results.
      ./check_powerconnect -H REMOTE-IP -t uptime

Leave a Reply

All rights reserved. © 2017 TecAdmin.net. This site uses cookies. By using this website you agree our term and services
Hosted @DigitalOcean