Page 1 of 1

Where in the CFG files or mysql are the auth servers stored?

Posted: Mon May 18, 2020 12:19 pm
by GKWilly
My scenario:
We're standing up a 20 server XI environment, using LDAP to authenticate the users.
Sometime later this year our central operations team will be rolling out new authentication servers.

So I am looking for the location in the cfgs, mysql database or someplace else where Nagios stores the LDAP server information
1) So that I can change the server when the operations team gives us a new name, without visiting every XI server in my fleet
2) So that when I stand up new XI servers I can import the users and metadata tables from a master source without needing to find the alias assigned when one manually adds a server to the interface.
While I can do a quick SQL job to find the new alias and repair the xi_usermeta table for all the users... there has to be a more efficient way :D

-GKWilly

Re: Where in the CFG files or mysql are the auth servers sto

Posted: Tue May 19, 2020 12:07 pm
by cdienger
The auth servers are stored in the xi_options table of the nagiosxi database. You can get the information(which is base 64 encoded) with:

Code: Select all

select value from xi_options where name='ldap_ad_integration_component_servers';