Alternative DB to RRD

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 | user-083785ae1711@xymon.invalid | 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 <user-ce4a2c883f75@xymon.invalid>
To:
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