Nagios Support Forum

Yes the problem is solved. ONLY_FULL_GROUP_BY Reject queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are neither named in the GROUP BY clause nor are functionally dependent on (uniquely determined by) GROUP BY columns. As of MySQL 5.7.5, the ...

Just spent about 3 hours with Nagios Tech support and figured it out. On the Nagios XI server you need to do a export LC=C Since I am using MySQL 5.7.10 on the remote MySQL server you need to do: mysql> set GLOBAL sql_mode = ' '; (basically just two tick marks); SQL cannot have ONLY_FULL_GROUP_BY se...

ndo2db.cfg look OK. I made it look like what the Nagios XI - Offloading MySQL to Remote Server document said. nmap command: Starting Nmap 6.47 ( http://nmap.org ) at 2016-02-10 01:28 EST Nmap scan report for 192.168.7.80 Host is up (0.000088s latency). Not shown: 997 closed ports PORT STATE SERVICE ...

The time change did not fix the issue. Settings in core configuration manager are correct. These VM's are on the same subnet and the same EXI server so no real latency. When I go to Admin > System Information > Monitoring Engine Status this on the GUI is showing "Red". I select the action ...

Here is the output: The clocks were not the same, one was UTC the other EST so they are now both EST for time and date. grep server /var/www/html/nagiosql/config/settings.php server = 192.168.7.80 +---------------------+ | now() | +---------------------+ | 2016-02-09 06:45:01 | +--------------------...

Will do, I am off-site today and maybe tomorrow so will try as soon as I can. Thanks for the idea.

Yes. I made sure iptables is off on both servers. Also when I do a "ss dport == 3306" I can see all the connections to the remote mySQL database.

A little history: I have installed the latest Nagioxi on RedHat 6.7 as and evaluation prior to doing this with the production system. I have also created a separate VM with RedHat 6.7 and MySQl 5.7.10. I then followed the NagiosXi offload MySQL to remote server and things seemed to work OK. I could ...