Nagios Support Forum

Try this query against the nagiosxi database: select * from xi_usermeta where keyname='ldap_ad_dn' || keyname='ldap_ad_username'; Spectacular! That does the trick perfectly! Thanks for the quick reply! OK to lock up this topic. For posterity and to benefit others who may find it helpful, some obfus...

Also since one of the possible solutions might be SQL, I should note the database basics... All four of our XI instances are using MySQL. Three of the four are using the latest available on RHEL 6.10, MySQL 5.1.73. One has an offloaded MySQL on AWS RDS, engine 5.7.23. (I doubt the engine version mak...

I forgot to mention... three of the four are XI version 5.5.11, and one is 5.5.7.

Hi everyone -- I searched every-which-way for a previous topic which answered this but came up empty... We have four Nagios XI servers (two active, two standby) and I need to sync up all the user accounts across all of them. The accounts involved are all "imported" from Active Directory, w...

By the way, we can't enable CCM access for everyone, so it's not a solution to have people View in Nagios Core from the Advanced tab.

Hi folks -- I am working on migrating our last (and largest) Nagios Core implementation into XI. We have almost 1800 Hosts and more than 7700 Services in this Core right now. We make extensive use of notes_url and action_url and notes in Core, to provide info to everyone from support teams to busine...

stefanw , Glad that solution worked for you. Sure, we'll keep this open for a while. As far as converting tables to InnoDB. The latest XI supports InnoDB engine for the nagiosxi and nagiosql databases. Nagios database needs to stay in My-ISAM. Perhaps instead of using AWS backup system, you can set...

Holy @#&% setting the timezone in the RDS might have finally been the solution!!! I have to do more testing, but now (for the first time in a week or more!) things that are edited are now appearing with "Status: Applied" and the " Changes detected! " is not showing up! This i...

Let's compare time/timezones on your nagios server and the remote mysql server. Run these commands on the Nagios server and show me the output. ## checking time / date on systems grep "date.timezone" /etc/php.ini ls -l /etc/localtime php -r 'echo date("D M j G:i:s T Y")."\n...

Also as I mentioned before, I'm willing to try running /usr/local/nagiosxi/scripts/restore_defaults.sh if you can confirm for me that it ONLY sets Core / CCM to defaults. This is a pre-production server that has nothing important in Core configs, but I don't want to have to set up XI all over again....