Nagios Support Forum

Hello!
I'm not really sure how to go about asking this, I've only been playing around with Nagios Core for a few days now, and I'm a bit of a novice with Linux in general as well. I apologize in advance if I leave out any pertinent information. I'll do my best to include it all!

OS: Ubuntu Server 16.04.1 (running on a Hyper-V Virtual Machine)
Nagios Core Version: 4.2.3
NagiosQL Version: 3.2.0 (downloaed the nagiosql_320.tar.gz file from SourceForge)
MySQL Version: Ver 14.14 Distrib 5.7.16, for Linux (x86_64) using EditLine wrapper
PHP Version: 7.0

I have Nagios Core up and running. Everything seems to be working fine. After downloading NagiosQL I can access the http://[serverip]/nagiosql32/install/index.php page. Under the prereqs, it says "Settings file not found or not readable (config/settings/php). Upgrade not available!" From my research it doesn't seem like that's an issue.

When I click Start Installation, the only requirement I'm not needing is MySQL. It says "MySQL: NOT AVAILABLE"
It doesn't say not installed, which is most of what I've seen online. I can't figure out how to fix this, because I have MySQL installed.

What am I missing?

Regards,
OstrichOtter

NagiosQL is not our product, so we will only be able to provide limited support.

NagiosQL has not been updated since 2013-04-25. It's not really designed for Nagios 4. The very first feature is "Support for Nagios 2.x/3.x and other Nagios compatible monitoring tools." Their website is down...for how long, I do not know. PHP 7 was released 2015-12-03, so NagiosQL is not designed for that.

I think it's safe to say NagiosQL is not a realistic option on a modern system.

That said, we can either help you find a solution, or you can build things appropriately for 2013. Unfortunately, the 2012 Ubuntu LTS loses support 2017-04-26. At least the 2014 LTS isn't going to have PHP 7, so you could give that a shot.

Since we only support XI on Cent/RHEL, we have more expertise there, if you are looking to build a different system. That said, Nagios Core should certainly work on Ubuntu and it sounds like you have it working. I'm just trying to give you "all" the information you might need to make the best decision for you going forward.

A lot of people use things like puppet, chef, ansible, etc. to manage their configs, so if that's a direction you want to go, we can certainly point you to some resources to go that direction.

One that that may be confusing is that we have a database in XI called nagiosql.

Could you please provide the output of:

also, could you provide the output of tail -100 /var/log/mysqld.log?