[hobbit] Xymon hosts database.

[David Peters]

Back again. I have now coded the search and host screen functions based on
the schema of the original database.

Still a couple of lookup fields and host fields to go, however, I was
looking for some feedback on the existing state.

The code to convert the database into bb-hosts including laid out by
host-owner, location, application service etc has already been completed but
I am not quite at the stage to run the existing dataset and blow away my
current hobbit bb-hosts.

You can view a mockup db running here.
http://www.electronf.com/xymondb/xymondb.pl
The screens are ready for update delete but I am finalizing the change audit
management functions atm.


I also added some code that generates a graphical tree structure based on
the layout of hobbit pages that gets generated from the db.

You can view that here:
http://www.electronf.com/xymondb/xymondb.pl


Feedback please.


-----Original Message-----
From: David Peters [mailto:davidp at electronf.com] 
Sent: Wednesday, 1 July 2009 8:17 PM
To: hobbit at hswn.dk
Subject: RE: [hobbit] Xymon hosts database.

The code already includes an on-screen field and code that allows you to add
any extra hobbit options.

-----Original Message-----
From: Ward, Martin [mailto:Martin.Ward at colt.net] 
Sent: Wednesday, 1 July 2009 6:25 PM
To: hobbit at hswn.dk
Subject: RE: [hobbit] Xymon hosts database.

Interest: I am certainly interested in this, especially with the asset
management additions that TJ mentioned.

Aid: I would push for PHP rather than perl although I can code in both
and am willing to help.

Nitty-gritty: However you write the code to generate the bb-hosts file
you will need to include a comments field that allows users to add extra
options to the comments field in the bb-hosts file. This is so that when
Xymon is upgraded and Henrik adds more options in that would be added to
the comments field, users can add those new options without having to
wait until you rewrite the front-end.


|\/|artin

> -----Original Message-----
> From: T.J. Yang [mailto:tj_yang at hotmail.com]
> Sent: 01 July 2009 06:01
> 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_Gui
> de#Using_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_Gui
> de#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
> 



****************************************************************************
*********
The message is intended for the named addressee only and may not be
disclosed to or used by anyone else, nor may it be copied in any way. 

The contents of this message and its attachments are confidential and may
also be subject to legal privilege.  If you are not the named addressee
and/or have received this message in error, please advise us by e-mailing
security at colt.net and delete the message and any attachments without
retaining any copies. 

Internet communications are not secure and COLT does not accept
responsibility for this message, its contents nor responsibility for any
viruses. 

No contracts can be created or varied on behalf of COLT Telecommunications,
its subsidiaries or affiliates ("COLT") and any other party by email
Communications unless expressly agreed in writing with such other party.  

Please note that incoming emails will be automatically scanned to eliminate
potential viruses and unsolicited promotional emails. For more information
refer to www.colt.net or contact us on +44(0)20 7390 3900.


To unsubscribe from the hobbit list, send an e-mail to
hobbit-unsubscribe at hswn.dk




To unsubscribe from the hobbit list, send an e-mail to
hobbit-unsubscribe at hswn.dk