[Xymon] Alternative DB to RRD

[Gautier Begin]

Henrik,

I just tried but I got this error in the rrd-data.log:
        2011-03-10 10:31:44 External processor 
'/project/hobbit0/bin/SQL_feed.pl' started
        2011-03-10 10:31:44 exec() failed for child command 
/project/hobbit0/bin/SQL_feed.pl: Bad address
        2011-03-10 10:32:02 Peer at 0.0.0.0:0 failed: Broken pipe
        2011-03-10 10:32:02 Peer not up, flushing message queue
        2011-03-10 10:32:02 Peer not up, flushing message queue
        2011-03-10 10:32:02 Peer not up, flushing message queue
        2011-03-10 10:32:32 Flushed 1 stale messages for 0.0.0.0:0
        2011-03-10 10:36:28 Peer not up, flushing message queue


Here is my hobbitlaunch.cfg (XYMON version 4.3.0.0-beta2)
        [rrddata]
                ENVFILE 
/project/hobbit0/refer/xymon-4.3.0b2/server/etc/hobbitserver.cfg
                NEEDS hobbitd
                CMD hobbitd_channel --channel=data 
--log=$BBSERVERLOGS/rrd-data.log hobbitd_rrd --no-cache 
--extra-tests=zonestat,multicpu
 
--extra-script=/project/hobbit0/refer/xymon-4.3.0b2/server/ext/rrd_data.pl 
--rrddir=$BBVAR/rrd --processor=/project/hobbit0/bin/SQL_feed.pl




Cordialement, Regards,Mit freundlichen Grüßen,

Gautier BEGIN

Admin and Tools Team
CSC - Luxembourg

Global Outsourcing Service | p:+352 24 834 276 | m:+352 621 229 172 | 
gbegin at csc.com | www.csc.com


CSC • This is a PRIVATE message. If you are not the intended recipient, 
please delete without copying and kindly advise us by e-mail of the 
mistake in delivery.  NOTE: Regardless of content, this e-mail shall not 
operate to bind CSC to any order or other contract unless pursuant to 
explicit written agreement or government initiative expressly permitting 
the use of e-mail for such purpose
 • 
CSC Computer Sciences SAS • Registered Office: Immeuble Le Balzac, 10 
Place des Vosges, 92072 Paris La Défense Cedex, France • Registered in 
France: RCS Nanterre B 315 268 664



From:
Henrik Størner <henrik at hswn.dk>
To:
xymon at xymon.com
Date:
09/03/2011 22:16
Subject:
Re: [Xymon] Alternative DB to RRD



Den 09-03-2011 18:16, Gautier Begin skrev:
> I have heard that we could store measurements not only in RRD files but
> also in standard DataBase (mySQL for expl) using a task through xymon
> channel.
>
> Where can I find such dev ?

Depends on what you want to accomplish.

If you just want to store the "raw" status messages in an SQL database, 
then Japheth Cleaver wrote a very simple perl script for doing that.
See http://lists.xymon.com/archive/2009-March/023782.html

If you want to pick up the individual data values that Xymon passes into 
the RRD files, then it gets more complicated. There is a "hook"
into the xymond_rrd module that feeds all of the RRD data into another 
program; you launch this by running xymond_rrd with the 
"--processor=/path/to/script" option. The script must then be able to 
handle data in the form of one line per update, each line contains the 
RRD template (names of the datasets), the data values (colon-separated),
the hostname, and the elements of the RRD filename. This isn't something 
that has been used much, so I really don't know what the impact would be 
of running this to store all data in an SQL database. Depends on the 
amount of data you are going to handle, obviously.

But I'm not aware of any such script being available, so you would have 
to code it yourself.


Regards,
Henrik

_______________________________________________
Xymon mailing list
Xymon at xymon.com
http://lists.xymon.com/mailman/listinfo/xymon



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.xymon.com/pipermail/xymon/attachments/20110310/279736fc/attachment.html>