On 31-01-2012 20:05, user-9c1ae820b621@xymon.invalid wrote:
Has anyone created a Database (MySQL) front-end to handle the HOSTS and
ALERTS information?
Thus, when finished, you extract all of the data from the tables in the
DB and re-create the HOSTS and/or ALERTS files.
It would probably be a simple thing to do, but I haven't heard of any.
And then you restart Xymon?
Usually not required, and certainly not for changes to {hosts,alerts}.cfg
I have a need for multiple Admins to do ADD, CHANGE, DELETE requests to
the system but they cannot work on the files at the same time.
I have had to create a LOCK and UNLOCK (exclusive) while someone is
working on the files.
Isn't it possible to spread your configuration over multiple files ? In my experience, most admins only handle a limited number of hosts - in my setup hosts for a specific client - so by splitting up the hosts.cfg / alerts.cfg files into customer-specific "bits" you avoid the problem of multiple simultaneous updates.
Apart from that, consider putting your configuration files under some sort of revision control system (CVS, Subversion, git, even plain old RCS if you must). The newer ones are quite good at managing multiple updates to a shared set of files.
I am not saying that using a DB backend for - at least - the hosts.cfg information is a bad idea; in fact, I am considering this for the next version. I just want to point out that there may be less "fancy" - but usable - solutions to this specific problem.
Regards,
Henrik