Nagios Support Forum

Hello!!

I am trying to install XI on a CentOS (6.9). I run the curl command and everything seems to be going fine and then it stalls at Database servers initialized OK. It just sits there and doesn't move on.

Hello @letter17,

Make sure you're logged in as root and run the following commands. If it fails, post the errors and/or screenshot of the output to the thread.

that seems to work, but it is taking forever.
Does this change firewall rules? I can't get to my database now and people are freaking out

That seemed to be working, but was taking forever and my database went down to the outside world. People are freaking out. How do I get things back??? I don't have time to mess with this

Unfortunately, I had to abort the install as people were freaking out that the site was offline - then I spent 2 hours moving my database to another server, changing users, etc etc etc. I was able to go back to the install, start over and it went relatively fast. Had I known that it would have killed any outside access to the database, I wouldn't have started it at 4:30 PM. Now unfortunately, that server probably is going to be de-commissioned as the database is elsewhere.

That being said - can XI be easily installed on a cpanel installation w/o any issues?

I take that back - I still can't access the database if it isn't localhost. What gives?

Hello @letter17,

Sorry to hear about your troubles installing XI and hopefully we can get this going for you.

That being said - can XI be easily installed on a cpanel installation w/o any issues?

We recommend installing Nagios XI on a minimal system as other programs may interfere or result in package dependency issues.
Nagios XI - System Requirements

I still can't access the database if it isn't localhost. What gives?

You can offload the database, but it's easier to manage a local database host.
Offloading MySQL to Remote Server

If you're able to access the web interface, can you send me your system profile. If not, I'd like to review the installation log for errors and know more specifics about the server environment.

To send us your system profile.
Login to the Nagios XI GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button
Save the profile.zip file and share in a private message and then reply to this post to bring it up in the queue.

I guess I didn't understand that Nagios should run independently and not side by side like other monitoring tools. Nor that installation would block public access to the database.

Fortunately, I was able to get what is going to be a better a long term solution for my databases.

Once I get the rest of my databases off that server, I will be destroying it and creating a new droplet to install Nagios on.

I'll send the profile.zip as soon as I can.

Hello,

Once I get the rest of my databases off that server, I will be destroying it and creating a new droplet to install Nagios on.
I'll send the profile.zip as soon as I can.

Sounds good. We'll wait for your update.

Hi,
How is the new installation working now? After reviewing the profile, Nagios is running checks and sending notifications. However, I did see this entry in the Apache log for a fatal phpmyadmin error.

[Fri Sep 27 10:36:08 2019] [error] [client 24.8.234.134] PHP Fatal error: Maximum execution time of 300 seconds exceeded in /usr/share/phpMyAdmin/export.php on line 300
[Fri Sep 27 10:42:55 2019] [error] [client 24.8.234.134] PHP Fatal error: Maximum execution time of 300 seconds exceeded in /usr/share/phpMyAdmin/libraries/plugins/export/ExportSql.class.php on line 1796
[Fri Sep 27 10:51:18 2019] [error] [client 24.8.234.134] PHP Fatal error: Maximum execution time of 300 seconds exceeded in /usr/share/phpMyAdmin/libraries/plugins/export/ExportSql.class.php on line 1796

You can try increasing the ExecTimeLimit in the phpmyadmin confg ( see: this).