[Xymon] TS - Is there a DB frontend for Xymon maintenance?

[Henrik Størner]

On 31-01-2012 20:05, d.tom.schmitt at L-3com.com 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