SQL proof of concept (was SQL storage backends (was RE: [hobbit] Xymon 4.3.0:Beta version available on Sourceforge))

[Cleaver, Japheth]

Hello all,

Just wanted to send off a copy of the proof-of-concept SQL
hobbitd_channel storage script we've been using. It could certainly be
more useful, but we just wanted to test some of ramifications of keeping
status reports like this. Any feedback would be appreciated.

Regards,
Japheth Cleaver



To use, add lines in hobbitlaunch.cfg like so:
======== snip =========
# Experiemental SQL storage
[bbsqlstatus]
        ENVFILE /etc/hobbit/hobbitserver.cfg
        NEEDS hobbitd
        CMD hobbitd_channel --channel=status
--log=$BBSERVERLOGS/sqlstatus.log SOMEPATH/hobbitd_sqlstore
======= snip ==========

(Note, I'm using a packagized version of hobbit, so your paths may
vary.)

-------------- next part --------------
A non-text attachment was scrubbed...
Name: hobbitd_sqlstore.pl
Type: application/octet-stream
Size: 3595 bytes
Desc: hobbitd_sqlstore.pl
URL: <http://lists.xymon.com/pipermail/xymon/attachments/20090306/ea445ad8/attachment.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: sqlstorageschema.sql
Type: application/octet-stream
Size: 1408 bytes
Desc: sqlstorageschema.sql
URL: <http://lists.xymon.com/pipermail/xymon/attachments/20090306/ea445ad8/attachment-0001.obj>