[hobbit] Xymon hosts database.

David Peters davidp at electronf.com
Wed Jul 1 12:19:24 CEST 2009


What I wrote was an asset management system with verification stages for
changes and additions, history of changes included storage of previous
versions etc.


-----Original Message-----
From: T.J. Yang [mailto:tj_yang at hotmail.com] 
Sent: Wednesday, 1 July 2009 3:01 PM
To: hobbit system monitoring
Subject: RE: [hobbit] Xymon hosts database.


________________________________
> To: hobbit at hswn.dk
> From: david.peters at dpi.nsw.gov.au
> Date: Wed, 1 Jul 2009 10:18:56 +1000
> Subject: [hobbit] Xymon hosts database.
>
>
>
> I think I have posted this quite a while
> ago but it is still on my mind. 

Not only in my mind. I got to deliver it in next few months.

>We currently configure the hosts, pages
> etc using a windows database and windows front end that I wrote quite some
> time ago. I keep getting the urge to convert it to a linux database and
> a web frontend. However I would not do this if there is no interest in
> using it.

My interest about Xymon and relational DB is mainly from asset inventory
perspective.
Xymon doing a decent jobs collecting system information(io/cpu/memory/disk).
But what about a system's
asset information ? where is rack position of this machine ? what is the
serial number, owner, function ? and is it a owned orleased machnine ? Asset
information like this are most likely kept in Excel files. Won't it be
nature to tight these information together ? Xymon should be able to do both
system and inventory monitoring.(ie, you got a red yellow alert if a
machine's lease is expiring in 1 month).


To achieve this goal, I plan to introduce a relational DB into my Xymon
server system.

Please see the details here, 
http://en.wikibooks.org/wiki/System_Monitoring_with_Xymon/Developer_Guide#Us
ing_relational_DBs_with_Xymon_Server



>
>
> The point is that you never touch the
> bb-hosts file and all configuration of hosts and layouts is done via a
> user interface.

>
>
> Is there any interest in this?

Yes.

> Is there anyone willing to help?

Count me in. 
I am decent at perl programming and currently learning
php/extjs/qWikiOffice.

> If so I was going to convert to mysql
> and either php or perl cgi. Any comments on this?

perl cgi script works but it is really not eye-catching. 
I like to stay with perl but php community is so strong. 
Catalyst is perl's MVC solution but it is weak on "View" part.
As long as your requirement doesn't need EXTJS then Catalyst a very good
solution.



>
>
> We have 400 odd hosts here and have
> pages split by priority, service, location, and support group all on the
> front page but all configured via the database.
>
>
> Currently the bb-hosts is built via
> a perl script that extracts the database and then generates a main
bb-hosts
> file plus include files for each sub-page.

Can you post your perl script here ? or on 
http://en.wikibooks.org/wiki/System_Monitoring_with_Xymon/Developer_Guide#bb
-hosts_generation



Regards


tj
>
>
>
----------------------------------------------------------------------------
--
>
> David Peters
>
>
>
> +61 2 63913565
>
> +61 4 17863572
>
>
----------------------------------------------------------------------------
--
>
>
>
>
>
>
> This message is intended for the addressee named and may contain
confidential information. If you are not the intended recipient, please
delete it and notify the sender. Views expressed in this message are those
of the individual sender, and are not necessarily the views of their
organisation.

_________________________________________________________________
Lauren found her dream laptop. Find the PC that's right for you.
http://www.microsoft.com/windows/choosepc/?ocid=ftp_val_wl_290
To unsubscribe from the hobbit list, send an e-mail to
hobbit-unsubscribe at hswn.dk






More information about the Xymon mailing list