Xymon hosts database. 🔗 link

To: user-ae9b8668bcde@xymon.invalid
From: user-762f8f482193@xymon.invalid
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. 

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.

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?

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

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.

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.

On Wednesday 01 July 2009 02:18:56 user-762f8f482193@xymon.invalid wrote:

I think I have posted this quite a while ago but it is still on my mind.
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.

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?

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

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.

-----Original Message-----
From: T.J. Yang [mailto:user-8e841282cda5@xymon.invalid]
Sent: 01 July 2009 06:01
To: hobbit system monitoring
Subject: RE: [hobbit] Xymon hosts database.

To: user-ae9b8668bcde@xymon.invalid
From: user-762f8f482193@xymon.invalid
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,

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

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

*************************************************************************************

On Wednesday 01 July 2009 07:01:07 T.J. Yang wrote:

To: user-ae9b8668bcde@xymon.invalid
From: user-762f8f482193@xymon.invalid
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,

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.

-----Original Message-----
From: Ward, Martin [mailto:user-2d33a6eb6a05@xymon.invalid] 
Sent: Wednesday, 1 July 2009 6:25 PM
To: user-ae9b8668bcde@xymon.invalid
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:user-8e841282cda5@xymon.invalid]
Sent: 01 July 2009 06:01
To: hobbit system monitoring
Subject: RE: [hobbit] Xymon hosts database.

To: user-ae9b8668bcde@xymon.invalid
From: user-762f8f482193@xymon.invalid
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

****************************************************************************
*********
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
user-61c7f445d564@xymon.invalid 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.

-----Original Message-----
From: T.J. Yang [mailto:user-8e841282cda5@xymon.invalid] 
Sent: Wednesday, 1 July 2009 3:01 PM
To: hobbit system monitoring
Subject: RE: [hobbit] Xymon hosts database.

To: user-ae9b8668bcde@xymon.invalid
From: user-762f8f482193@xymon.invalid
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, 

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 

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

-----Original Message-----
From: Buchan Milne [mailto:user-9b139aff4dec@xymon.invalid] 
Sent: Wednesday, 1 July 2009 6:34 PM
To: user-ae9b8668bcde@xymon.invalid
Cc: T.J. Yang
Subject: Re: [hobbit] Xymon hosts database.

On Wednesday 01 July 2009 07:01:07 T.J. Yang wrote:

To: user-ae9b8668bcde@xymon.invalid
From: user-762f8f482193@xymon.invalid
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#U

sing_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.

IMHO you shouldn't be choosing solutions before you have requirements ....

While qwikioffice looks snazzy, one of my requirements is that a view must
be 
customised (possibly per-user), and a user *must* be able to get their
correct 
view without any interaction (no mouse clicking etc.), so that this display 
can be used e.g. on a video wall, where no one is able to click the mouse.
Any 
cycling of views etc. should be automated.

I have done some simple frame+js pages to do this with current hobbit (e.g.
to 
cycle one frame between weathermap view and main view).

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.

There are a number of AJAX libraries that people use with Catalyst, e.g. 
Prototype, Dojo, with some plugins allowing perl-ish calls in templates that

result in the correct javascript. In conjunction with View::JSON, everything

required is available ...

Maybe it's time to start collecting requirements and prototyping some stuff.
I 
think the first thing we need is a Model::Xymon .

Regards,
Buchan

-----Original Message-----
From: David Peters [mailto:user-66917457e380@xymon.invalid]
Sent: 01 July 2009 11:26
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Xymon hosts database.

What I have is a database front end, database and extraction script to
hobbit. The database was written from the viewpoint of storing data
about
all the hosts that would end up in hobbit. It was always written to be
our
hobbit data source and as such has that in mind.

The model is solid in terms of operations managing the data but
provides
auditing and control.

The downside is that it is written in access because that is what the
manager wanted and I am but a lowly contractor.

I am just a bit wary of trying to put too much into a configuration
tool.

What I hate about hobbit and trying to sell it is that its host
configuration is pretty ordinary.

*************************************************************************************
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 user-61c7f445d564@xymon.invalid 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.

From: user-762f8f482193@xymon.invalid [mailto:user-762f8f482193@xymon.invalid]
Sent: Tuesday, June 30, 2009 7:19 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: [hobbit] Xymon hosts database.


I think I have posted this quite a while ago but it is still on my mind. 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.

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?
Is there anyone willing to help?
If so I was going to convert to mysql and either php or perl cgi. Any comments on this?

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.


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.

From: user-762f8f482193@xymon.invalid [mailto:user-762f8f482193@xymon.invalid]
Sent: Tuesday, June 30, 2009 7:19 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: [hobbit] Xymon hosts database.

I think I have posted this quite a while ago but it is still on my mind. 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.

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?
Is there anyone willing to help?
If so I was going to convert to mysql and either php or perl cgi. Any comments on this?

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.


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.

From: user-371ba9bb5b75@xymon.invalid
To: user-ae9b8668bcde@xymon.invalid
Date: Wed, 1 Jul 2009 11:44:45 -0400
Subject: Re: [hobbit] Xymon hosts database.

We store information on our systems in LDAP for a variety of reasons.

* Many existing applications (Postfix, Puppet) can use LDAP data
* LDAP tools are pre-installed on most systems
* It's available in most scripting environments (Shell, Python,
PHP, Perl)
* The data can be viewed and edited in many ways (including plain-
text)
* The data's structure is more flexible than a spreadsheet or RDBMS
* We're going to have an LDAP server anyway (for authentication)
* It's easy for people to read and gather information
* It's easy for machines and automated processes to read and gather
information

And yes, much of our bb-hosts file is generated from data in LDAP. :)

user-762f8f482193@xymon.invalid wrote:

I think I have posted this quite a while ago but it is still on my
mind. 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.

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?
Is there anyone willing to help?
If so I was going to convert to mysql and either php or perl cgi. Any
comments on this?

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.

Subject:
RE: [hobbit] Xymon hosts database.


That sounds pretty cool. Do you handle any other files (hobbit-alerts.cfg, etc)?
 I'm not much of a db guy, but I'd say since you already have perl, I'd go that route. I've done a little php, and a lot (20 years) of perl. So I may be a bit biased.   Paul Root         IM/MNS Infrastructure  
From: user-762f8f482193@xymon.invalid [mailto:user-762f8f482193@xymon.invalid] Sent: Tuesday, June 30, 2009 7:19 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: [hobbit] Xymon hosts database.


I think I have posted this quite a while ago but it is still on my mind. 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. 
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? Is there anyone willing to help? If so I was going to convert to mysql and either php or perl cgi. Any comments on this? 
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. 


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.


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.

Subject:
RE: [hobbit] Xymon hosts database.


This does sound cool. If you can, I?d love to see the current Windows implementation too.
 Thanks.
 Ray
  
From: user-762f8f482193@xymon.invalid [mailto:user-762f8f482193@xymon.invalid] Sent: Tuesday, June 30, 2009 7:19 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: [hobbit] Xymon hosts database.

I think I have posted this quite a while ago but it is still on my mind. 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. 
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? Is there anyone willing to help? If so I was going to convert to mysql and either php or perl cgi. Any comments on this? 
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. 


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.
 
CONFIDENTIALITY NOTICE: This email and any attachments are for the
exclusive and confidential use of the intended recipient. If you are not
the intended recipient, please do not read, distribute or take action in
reliance upon this message. If you have received this in error, please
notify us immediately by return email and promptly delete this message
and its attachments from your computer system. We do not waive
attorney-client or work product privilege by the transmission of this
message.


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.

Subject:
Re: [hobbit] Xymon hosts database.


user-762f8f482193@xymon.invalid wrote: 
I think I have posted this quite a while ago but it is still on my mind. 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. 
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? Is there anyone willing to help? If so I was going to convert to mysql and either php or perl cgi. Any comments on this? 
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. 

I would definitely be interested in this - I have some modest experience with the LAMP stack, and also have some LAMP servers (ubuntu and SLES) available for testing and development.

Let me know -

Joe


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.

David Peeters wrote:

(...) We currently configure the hosts, pages etc using a windows database and windows front end. (...) Is there any interest in this?

T.J. Yang wrote:

a cool(easy) GUI for people to update a host's information easily over the > web. Currently I am fond of extjs' editor grid. it is very much like
Excel's clickm,edit and update(on a real db).

From: user-762f8f482193@xymon.invalid [mailto:user-762f8f482193@xymon.invalid]
Sent: Wednesday, July 01, 2009 7:23 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Xymon hosts database.


I'd be happy to send the windows implementation, however it is very specific to our setup. Well the conversion script to bb-hosts is anyway. But the windows part is pretty stand alone.

I am not really looking to distribute a standalone access application. Rather I really want to convert the screens and logic to something a bit more open.

David Peters

+61 2 63913565
+61 4 17863572


From:

"Storer, Raymond" <user-bbaa567d59bb@xymon.invalid>

To:

"'user-ae9b8668bcde@xymon.invalid'" <user-ae9b8668bcde@xymon.invalid>

Date:

02/07/2009 01:19 AM

Subject:

RE: [hobbit] Xymon hosts database.


This does sound cool. If you can, I'd love to see the current Windows implementation too.

Thanks.

Ray


From: user-762f8f482193@xymon.invalid [mailto:user-762f8f482193@xymon.invalid]
Sent: Tuesday, June 30, 2009 7:19 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: [hobbit] Xymon hosts database.

I think I have posted this quite a while ago but it is still on my mind. 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.

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?
Is there anyone willing to help?
If so I was going to convert to mysql and either php or perl cgi. Any comments on this?

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.


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.


CONFIDENTIALITY NOTICE: This email and any attachments are for the
exclusive and confidential use of the intended recipient. If you are not
the intended recipient, please do not read, distribute or take action in
reliance upon this message. If you have received this in error, please
notify us immediately by return email and promptly delete this message
and its attachments from your computer system. We do not waive
attorney-client or work product privilege by the transmission of this
message.


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.


CONFIDENTIALITY NOTICE: This email and any attachments are for the
exclusive and confidential use of the intended recipient. If you are not
the intended recipient, please do not read, distribute or take action in
reliance upon this message. If you have received this in error, please
notify us immediately by return email and promptly delete this message
and its attachments from your computer system. We do not waive
attorney-client or work product privilege by the transmission of this
message.

From: user-762f8f482193@xymon.invalid [mailto:user-762f8f482193@xymon.invalid]
Sent: Tuesday, June 30, 2009 8:19 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: [hobbit] Xymon hosts database.


I think I have posted this quite a while ago but it is still on my mind. 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.

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?
Is there anyone willing to help?
If so I was going to convert to mysql and either php or perl cgi. Any comments on this?

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.


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.

-----Original Message-----
From: David Peters [mailto:user-66917457e380@xymon.invalid] 
Sent: Wednesday, 1 July 2009 8:26 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Xymon hosts database.

What I have is a database front end, database and extraction script to
hobbit. The database was written from the viewpoint of storing data about
all the hosts that would end up in hobbit. It was always written to be our
hobbit data source and as such has that in mind.

The model is solid in terms of operations managing the data but provides
auditing and control.

The downside is that it is written in access because that is what the
manager wanted and I am but a lowly contractor. 

I am just a bit wary of trying to put too much into a configuration tool.

What I hate about hobbit and trying to sell it is that its host
configuration is pretty ordinary.

-----Original Message-----
From: Buchan Milne [mailto:user-9b139aff4dec@xymon.invalid] 
Sent: Wednesday, 1 July 2009 6:34 PM
To: user-ae9b8668bcde@xymon.invalid
Cc: T.J. Yang
Subject: Re: [hobbit] Xymon hosts database.

On Wednesday 01 July 2009 07:01:07 T.J. Yang wrote:

To: user-ae9b8668bcde@xymon.invalid
From: user-762f8f482193@xymon.invalid
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#U

sing_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.

IMHO you shouldn't be choosing solutions before you have requirements ....

While qwikioffice looks snazzy, one of my requirements is that a view must
be 
customised (possibly per-user), and a user *must* be able to get their
correct 
view without any interaction (no mouse clicking etc.), so that this display 
can be used e.g. on a video wall, where no one is able to click the mouse.
Any 
cycling of views etc. should be automated.

I have done some simple frame+js pages to do this with current hobbit (e.g.
to 
cycle one frame between weathermap view and main view).

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.

There are a number of AJAX libraries that people use with Catalyst, e.g. 
Prototype, Dojo, with some plugins allowing perl-ish calls in templates that

result in the correct javascript. In conjunction with View::JSON, everything

required is available ...

Maybe it's time to start collecting requirements and prototyping some stuff.
I 
think the first thing we need is a Model::Xymon .

Regards,
Buchan

 
From: user-762f8f482193@xymon.invalid [mailto:user-762f8f482193@xymon.invalid] 
Sent: Wednesday, 1 July 2009 10:19 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: [hobbit] Xymon hosts database.

 
I think I have posted this quite a while ago but it is still on my mind. 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. 

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? 
Is there anyone willing to help? 
If so I was going to convert to mysql and either php or perl cgi. Any
comments on this? 

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. 


--
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.

On Tue, Jul 7, 2009 at 1:59 AM, David Peters <user-66917457e380@xymon.invalid> wrote:

 Well I have the database schema created in mysql now. I should be close
to getting enough together to upload to the sourceforge server very soon
now. Then anyone who wants to help can join in. Have been sick for the last
coupla days (couch cough....)


*From:* user-762f8f482193@xymon.invalid [mailto:user-762f8f482193@xymon.invalid]
*Sent:* Wednesday, 1 July 2009 10:19 AM
*To:* user-ae9b8668bcde@xymon.invalid
*Subject:* [hobbit] Xymon hosts database.


I think I have posted this quite a while ago but it is still on my mind. 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.

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?
Is there anyone willing to help?
If so I was going to convert to mysql and either php or perl cgi. Any
comments on this?

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.


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.

-- 

From: user-5425c7b245e1@xymon.invalid
Date: Thu, 9 Jul 2009 14:42:51 -0400
To: user-ae9b8668bcde@xymon.invalid
Subject: Re: [hobbit] Xymon hosts database.

I'll help as much as I have time for. I am experienced with php and mysql. Learning web dev (I'm really a Solaris sysadmin, though :-).

I'll watch for info on your posting. I've been away from the list for a while and I'm just catching up today.


Steve.


On Tue, Jul 7, 2009 at 1:59 AM, David Peters wrote:


Well I have the database schema created in
mysql now. I should be close to getting enough together to upload to the
sourceforge server very soon now. Then anyone who wants to help can join in.
Have been sick for the last coupla days (couch cough....)


From: user-762f8f482193@xymon.invalid
[mailto:user-762f8f482193@xymon.invalid]

Sent: Wednesday, 1 July 2009 10:19
AM

To: user-ae9b8668bcde@xymon.invalid

Subject: [hobbit] Xymon hosts
database.


I think I have posted this quite a while ago but it is
still on my mind. 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.


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?

Is
there anyone willing to help?

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


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.


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.


--
Do you wish to rise? Begin by descending. You plan a tower that will pierce the clouds? Lay first the foundation of humility. -St. Augustine (354-430)

Truth never damages a cause that is just. -Mohandas Karamchand Gandhi (1869-1948)

Subject:
RE: [hobbit] Xymon hosts database.

From: user-5425c7b245e1@xymon.invalid
Date: Thu, 9 Jul 2009 14:42:51 -0400
To: user-ae9b8668bcde@xymon.invalid
Subject: Re: [hobbit] Xymon hosts database.

I'll help as much as I have time for. I am experienced with php and 
mysql. Learning web dev (I'm really a Solaris sysadmin, though :-).

Being a Solaris admin can help too ;) Hint, Sun's webstack for SAMP. 

tj

I'll watch for info on your posting. I've been away from the list for a 
while and I'm just catching up today.


Steve.


On Tue, Jul 7, 2009 at 1:59 AM, David Peters wrote:


Well I have the database schema created in
mysql now. I should be close to getting enough together to upload to the
sourceforge server very soon now. Then anyone who wants to help can join 
in.
Have been sick for the last coupla days (couch cough....)


From: user-762f8f482193@xymon.invalid
[mailto:user-762f8f482193@xymon.invalid]

Sent: Wednesday, 1 July 2009 10:19
AM

To: user-ae9b8668bcde@xymon.invalid

Subject: [hobbit] Xymon hosts
database.


I think I have posted this quite a while ago but it is
still on my mind. 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.


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?

Is
there anyone willing to help?

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


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.


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.


--
Do you wish to rise? Begin by descending. You plan a tower that will 
pierce the clouds? Lay first the foundation of humility. -St. Augustine (354-430)

Truth never damages a cause that is just. -Mohandas Karamchand Gandhi 

(1869-1948)

Hotmail® has ever-growing storage! Don?t worry about storage limits. http://windowslive.com/Tutorial/Hotmail/Storage?ocid=TXT_TAGLM_WL_HM_Tutorial_Storage_062009


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.

Subject:
RE: [hobbit] Xymon hosts database.


I have decided to use mysql and php. I have an initial host page design up and running although the code is automatically generated from a form generator at the moment. 

David Peters

+61 2 63913565
+61 4 17863572


From: "T.J. Yang" <user-8e841282cda5@xymon.invalid> To: hobbit system monitoring <user-ae9b8668bcde@xymon.invalid> Date: 10/07/2009 05:06 AM Subject: RE: [hobbit] Xymon hosts database.

From: user-5425c7b245e1@xymon.invalid
Date: Thu, 9 Jul 2009 14:42:51 -0400
To: user-ae9b8668bcde@xymon.invalid
Subject: Re: [hobbit] Xymon hosts database.

I'll help as much as I have time for. I am experienced with php and 
mysql. Learning web dev (I'm really a Solaris sysadmin, though :-).

Being a Solaris admin can help too ;) Hint, Sun's webstack for SAMP. 

tj

I'll watch for info on your posting. I've been away from the list for a 
while and I'm just catching up today.


Steve.


On Tue, Jul 7, 2009 at 1:59 AM, David Peters wrote:


Well I have the database schema created in
mysql now. I should be close to getting enough together to upload to the
sourceforge server very soon now. Then anyone who wants to help can join 
in.
Have been sick for the last coupla days (couch cough....)


From: user-762f8f482193@xymon.invalid
[mailto:user-762f8f482193@xymon.invalid]

Sent: Wednesday, 1 July 2009 10:19
AM

To: user-ae9b8668bcde@xymon.invalid

Subject: [hobbit] Xymon hosts
database.


I think I have posted this quite a while ago but it is
still on my mind. 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.


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?

Is
there anyone willing to help?

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


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.


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.


--
Do you wish to rise? Begin by descending. You plan a tower that will 
pierce the clouds? Lay first the foundation of humility. -St. Augustine (354-430)

Truth never damages a cause that is just. -Mohandas Karamchand Gandhi 

(1869-1948)

Hotmail® has ever-growing storage! Don?t worry about storage limits. http://windowslive.com/Tutorial/Hotmail/Storage?ocid=TXT_TAGLM_WL_HM_Tutorial_Storage_062009


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.


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.

To: user-ae9b8668bcde@xymon.invalid
From: user-762f8f482193@xymon.invalid
Date: Tue, 14 Jul 2009 08:12:14 +1000
Subject: RE: [hobbit] Xymon hosts database.


Still sick. Something should get put
up soon.

tj

David Peters


+61 2 63913565

+61 4 17863572


From:
user-762f8f482193@xymon.invalid

To:
user-ae9b8668bcde@xymon.invalid

Date:
10/07/2009 09:25 AM

Subject:
RE: [hobbit] Xymon hosts database.


I have decided to use mysql and php. I have an initial host page design
up and running although the code is automatically generated from a form
generator at the moment.


David Peters


+61 2 63913565

+61 4 17863572


From:

"T.J. Yang"

Date:

10/07/2009 05:06 AM


Subject:

RE: [hobbit] Xymon hosts database.

From: user-5425c7b245e1@xymon.invalid

Date: Thu, 9 Jul 2009 14:42:51 -0400

To: user-ae9b8668bcde@xymon.invalid

Subject: Re: [hobbit] Xymon hosts database.

I'll help as much as I have time for. I am experienced with php and
mysql. Learning web dev (I'm really a Solaris sysadmin, though :-).

Being a Solaris admin can help too ;)

Hint, Sun's webstack for SAMP.


tj

I'll watch for info on your posting. I've been away from the list
for a while and I'm just catching up today.

Steve.

On Tue, Jul 7, 2009 at 1:59 AM, David Peters wrote:

Well I have the database schema created in

mysql now. I should be close to getting enough together to upload
to the

sourceforge server very soon now. Then anyone who wants to help can
join in.

Have been sick for the last coupla days (couch cough....)

From: user-762f8f482193@xymon.invalid

[mailto:user-762f8f482193@xymon.invalid]

Sent: Wednesday, 1 July 2009 10:19

AM

To: user-ae9b8668bcde@xymon.invalid

Subject: [hobbit] Xymon hosts

database.

I think I have posted this quite a while ago but it is

still on my mind. 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.

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?

Is

there anyone willing to help?

If

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

this?

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.

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.

--

Do you wish to rise? Begin by descending. You plan a tower that will
pierce the clouds? Lay first the foundation of humility. -St. Augustine

(354-430)

Truth never damages a cause that is just. -Mohandas Karamchand Gandhi

(1869-1948)

Hotmail® has ever-growing storage! Don’t worry about storage limits.

http://windowslive.com/Tutorial/Hotmail/Storage?ocid=TXT_TAGLM_WL_HM_Tutorial_Storage_062009


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.


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.

David Peters

+61 2 63913565
+61 4 17863572


From:
"T.J. Yang" <user-8e841282cda5@xymon.invalid>
To:
hobbit system monitoring <user-ae9b8668bcde@xymon.invalid>
Date:

Subject:
RE: [hobbit] Xymon hosts database.

To: user-ae9b8668bcde@xymon.invalid
From: user-762f8f482193@xymon.invalid
Date: Tue, 14 Jul 2009 08:12:14 +1000
Subject: RE: [hobbit] Xymon hosts database.


Still sick. Something should get put
up soon.

Hey, David

I am currently using SCM software(RCS) to manage bb-hosts and other 
configuration files.
Do you know if there is a way to implement rollback of change operations 
on bb-hosts* files in MySQL/PHP ?

This is my only concern for switching to MySQLTABLE_TO_BBHOST type of 
architecture.


I created this URL, trying to capture this email threads into formal doc.
Please document your work there if you can/interested.

http://en.wikibooks.org/wiki/System_Monitoring_with_Xymon/Developer_Guide#Using_relational_DBs_with_Xymon_Server


Did you check out qWikiOffice since you are a PHP person ? 
I am dreaming(since I know little php currently) to port qWikiOffice or 
TomatoCart's admin tool to xymon server. 


Please take care, I need your php skill to help/work on xymon dashboard.

tj

David Peters


+61 2 63913565

+61 4 17863572


From:
user-762f8f482193@xymon.invalid

To:
user-ae9b8668bcde@xymon.invalid

Date:
10/07/2009 09:25 AM

Subject:
RE: [hobbit] Xymon hosts database.


I have decided to use mysql and php. I have an initial host page design
up and running although the code is automatically generated from a form
generator at the moment.


David Peters


+61 2 63913565

+61 4 17863572


From:

"T.J. Yang"


To:

hobbit system monitoring


Date:

10/07/2009 05:06 AM


Subject:

RE: [hobbit] Xymon hosts database.

From: user-5425c7b245e1@xymon.invalid

Date: Thu, 9 Jul 2009 14:42:51 -0400

To: user-ae9b8668bcde@xymon.invalid

Subject: Re: [hobbit] Xymon hosts database.

I'll help as much as I have time for. I am experienced with php and
mysql. Learning web dev (I'm really a Solaris sysadmin, though :-).

Being a Solaris admin can help too ;)

Hint, Sun's webstack for SAMP.


tj

I'll watch for info on your posting. I've been away from the list
for a while and I'm just catching up today.

Steve.

On Tue, Jul 7, 2009 at 1:59 AM, David Peters wrote:

Well I have the database schema created in

mysql now. I should be close to getting enough together to upload
to the

sourceforge server very soon now. Then anyone who wants to help can
join in.

Have been sick for the last coupla days (couch cough....)

From: user-762f8f482193@xymon.invalid

[mailto:user-762f8f482193@xymon.invalid]

Sent: Wednesday, 1 July 2009 10:19

AM

To: user-ae9b8668bcde@xymon.invalid

Subject: [hobbit] Xymon hosts

database.

I think I have posted this quite a while ago but it is

still on my mind. 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.

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?

Is

there anyone willing to help?

If

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

this?

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.

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.

--

Do you wish to rise? Begin by descending. You plan a tower that will
pierce the clouds? Lay first the foundation of humility. -St. Augustine

(354-430)

Truth never damages a cause that is just. -Mohandas Karamchand Gandhi

(1869-1948)

Hotmail® has ever-growing storage! Don?t worry about storage limits.

http://windowslive.com/Tutorial/Hotmail/Storage?ocid=TXT_TAGLM_WL_HM_Tutorial_Storage_062009

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.


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.

Windows Live?: Keep your life in sync. 
http://windowslive.com/explore?ocid=TXT_TAGLM_WL_BR_life_in_synch_062009


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.

-----Original Message-----
From: David Peters [mailto:user-66917457e380@xymon.invalid] 
Sent: Wednesday, 1 July 2009 8:17 PM
To: user-ae9b8668bcde@xymon.invalid
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:user-2d33a6eb6a05@xymon.invalid] 
Sent: Wednesday, 1 July 2009 6:25 PM
To: user-ae9b8668bcde@xymon.invalid
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:user-8e841282cda5@xymon.invalid]
Sent: 01 July 2009 06:01
To: hobbit system monitoring
Subject: RE: [hobbit] Xymon hosts database.

To: user-ae9b8668bcde@xymon.invalid
From: user-762f8f482193@xymon.invalid
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

****************************************************************************
*********
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
user-61c7f445d564@xymon.invalid 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.

-----Original Message-----
From: David Peters [mailto:user-66917457e380@xymon.invalid] 
Sent: Tuesday, 6 October 2009 7:25 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Xymon hosts database.

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:user-66917457e380@xymon.invalid] 
Sent: Wednesday, 1 July 2009 8:17 PM
To: user-ae9b8668bcde@xymon.invalid
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:user-2d33a6eb6a05@xymon.invalid] 
Sent: Wednesday, 1 July 2009 6:25 PM
To: user-ae9b8668bcde@xymon.invalid
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:user-8e841282cda5@xymon.invalid]
Sent: 01 July 2009 06:01
To: hobbit system monitoring
Subject: RE: [hobbit] Xymon hosts database.

To: user-ae9b8668bcde@xymon.invalid
From: user-762f8f482193@xymon.invalid
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

****************************************************************************
*********
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
user-61c7f445d564@xymon.invalid 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.

-----Original Message-----
From: David Peters [mailto:user-66917457e380@xymon.invalid] 
Sent: Tuesday, 6 October 2009 8:04 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Xymon hosts database.

Oops those links were:

The main search screen:

http://www.electronf.com/xymondb/xymondb.pl

and the graphical tree was:

http://www.electronf.com/xymondb/xymondb.pl?rm=bbhosts


-----Original Message-----
From: David Peters [mailto:user-66917457e380@xymon.invalid] 
Sent: Tuesday, 6 October 2009 7:25 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Xymon hosts database.

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:user-66917457e380@xymon.invalid] 
Sent: Wednesday, 1 July 2009 8:17 PM
To: user-ae9b8668bcde@xymon.invalid
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:user-2d33a6eb6a05@xymon.invalid] 
Sent: Wednesday, 1 July 2009 6:25 PM
To: user-ae9b8668bcde@xymon.invalid
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:user-8e841282cda5@xymon.invalid]
Sent: 01 July 2009 06:01
To: hobbit system monitoring
Subject: RE: [hobbit] Xymon hosts database.

To: user-ae9b8668bcde@xymon.invalid
From: user-762f8f482193@xymon.invalid
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

****************************************************************************
*********
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
user-61c7f445d564@xymon.invalid 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.

On Tue, 6 Oct 2009, David Peters wrote:

Sorry there was a problem with my web server and the graphical tree. Is
fixed now.


-----Original Message-----
From: David Peters [mailto:user-66917457e380@xymon.invalid]
Sent: Tuesday, 6 October 2009 8:04 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Xymon hosts database.

Oops those links were:

The main search screen:

http://www.electronf.com/xymondb/xymondb.pl

and the graphical tree was:

http://www.electronf.com/xymondb/xymondb.pl?rm=bbhosts


-----Original Message-----
From: David Peters [mailto:user-66917457e380@xymon.invalid]
Sent: Tuesday, 6 October 2009 7:25 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Xymon hosts database.

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:user-66917457e380@xymon.invalid]
Sent: Wednesday, 1 July 2009 8:17 PM
To: user-ae9b8668bcde@xymon.invalid
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:user-2d33a6eb6a05@xymon.invalid]
Sent: Wednesday, 1 July 2009 6:25 PM
To: user-ae9b8668bcde@xymon.invalid
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:user-8e841282cda5@xymon.invalid]
Sent: 01 July 2009 06:01
To: hobbit system monitoring
Subject: RE: [hobbit] Xymon hosts database.

To: user-ae9b8668bcde@xymon.invalid
From: user-762f8f482193@xymon.invalid
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

****************************************************************************
*********
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
user-61c7f445d564@xymon.invalid 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.

 
From: Craig Cook [mailto:user-850f03189cf7@xymon.invalid] 
Sent: Wednesday, 7 October 2009 12:19 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Xymon hosts database.

 
Looks good.

 
Do you have plans to introduce the "template" and/or "group" concept?

 
e.g.  I have a template called "Windows"  Apply it to my windows servers,
they get defaults applied for thresholds.  Eg. Cpu is set to 80% warning,
disk is set to 75% full, certain services are checked, etc.

 
Another template called "Apache"  It gets process checks for http added to
the host.

 
My host called win-apache.example.com gets 2 templates applied to it.  You
can also override default settings for each host.

 
Concepts from bbconfigure on deadcat ;)  Makes large scale management much
easier.

 
Craig