<br><font size=2 face="sans-serif">Henrik,</font>
<br>
<br><font size=2 face="sans-serif">I just tried but I got this error in
the rrd-data.log:</font>
<br><font size=2 face="sans-serif"><i> 2011-03-10
10:31:44 External processor '/project/hobbit0/bin/SQL_feed.pl' started</i></font>
<br><font size=2 face="sans-serif"><i> 2011-03-10
10:31:44 exec() failed for child command /project/hobbit0/bin/SQL_feed.pl:
Bad address</i></font>
<br><font size=2 face="sans-serif"><i> 2011-03-10
10:32:02 Peer at 0.0.0.0:0 failed: Broken pipe</i></font>
<br><font size=2 face="sans-serif"><i> 2011-03-10
10:32:02 Peer not up, flushing message queue</i></font>
<br><font size=2 face="sans-serif"><i> 2011-03-10
10:32:02 Peer not up, flushing message queue</i></font>
<br><font size=2 face="sans-serif"><i> 2011-03-10
10:32:02 Peer not up, flushing message queue</i></font>
<br><font size=2 face="sans-serif"><i> 2011-03-10
10:32:32 Flushed 1 stale messages for 0.0.0.0:0</i></font>
<br><font size=2 face="sans-serif"><i> 2011-03-10
10:36:28 Peer not up, flushing message queue</i></font>
<br>
<br>
<br><font size=2 face="sans-serif">Here is my hobbitlaunch.cfg (XYMON version
4.3.0.0-beta2)</font>
<br><font size=2 face="sans-serif"><i> [rrddata]</i></font>
<br><font size=2 face="sans-serif"><i>
ENVFILE /project/hobbit0/refer/xymon-4.3.0b2/server/etc/hobbitserver.cfg</i></font>
<br><font size=2 face="sans-serif"><i>
NEEDS hobbitd</i></font>
<br><font size=2 face="sans-serif"><i>
CMD hobbitd_channel --channel=data --log=$BBSERVERLOGS/rrd-data.log
hobbitd_rrd --no-cache --extra-tests=zonestat,multicpu</i></font>
<br><font size=2 face="sans-serif"><i> --extra-script=/project/hobbit0/refer/xymon-4.3.0b2/server/ext/rrd_data.pl
--rrddir=$BBVAR/rrd --processor=/project/hobbit0/bin/SQL_feed.pl</i></font>
<br>
<br>
<br>
<br>
<br><font size=2 face="sans-serif">Cordialement, Regards,Mit freundlichen
Grüßen,<br>
<br>
Gautier BEGIN<br>
<br>
Admin and Tools Team<br>
CSC - Luxembourg<br>
<br>
Global Outsourcing Service | p:+352 24 834 276 | m:+352 621 229 172 | gbegin@csc.com
| </font><a href=www.csc.com><font size=2 face="sans-serif">www.csc.com</font></a><font size=2 face="sans-serif"><br>
<br>
<br>
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<br>
• <br>
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</font>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">From:</font>
<td><font size=1 face="sans-serif">Henrik Størner <henrik@hswn.dk></font>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">To:</font>
<td><font size=1 face="sans-serif">xymon@xymon.com</font>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">Date:</font>
<td><font size=1 face="sans-serif">09/03/2011 22:16</font>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">Subject:</font>
<td><font size=1 face="sans-serif">Re: [Xymon] Alternative DB to RRD</font></table>
<br>
<hr noshade>
<br>
<br>
<br><tt><font size=2>Den 09-03-2011 18:16, Gautier Begin skrev:<br>
> I have heard that we could store measurements not only in RRD files
but<br>
> also in standard DataBase (mySQL for expl) using a task through xymon<br>
> channel.<br>
><br>
> Where can I find such dev ?<br>
<br>
Depends on what you want to accomplish.<br>
<br>
If you just want to store the "raw" status messages in an SQL
database, <br>
then Japheth Cleaver wrote a very simple perl script for doing that.<br>
See </font></tt><a href="http://lists.xymon.com/archive/2009-March/023782.html"><tt><font size=2>http://lists.xymon.com/archive/2009-March/023782.html</font></tt></a><tt><font size=2><br>
<br>
If you want to pick up the individual data values that Xymon passes into
<br>
the RRD files, then it gets more complicated. There is a "hook"<br>
into the xymond_rrd module that feeds all of the RRD data into another
<br>
program; you launch this by running xymond_rrd with the <br>
"--processor=/path/to/script" option. The script must then be
able to <br>
handle data in the form of one line per update, each line contains the
<br>
RRD template (names of the datasets), the data values (colon-separated),<br>
the hostname, and the elements of the RRD filename. This isn't something
<br>
that has been used much, so I really don't know what the impact would be
<br>
of running this to store all data in an SQL database. Depends on the <br>
amount of data you are going to handle, obviously.<br>
<br>
But I'm not aware of any such script being available, so you would have
<br>
to code it yourself.<br>
<br>
<br>
Regards,<br>
Henrik<br>
<br>
_______________________________________________<br>
Xymon mailing list<br>
Xymon@xymon.com<br>
</font></tt><a href=http://lists.xymon.com/mailman/listinfo/xymon><tt><font size=2>http://lists.xymon.com/mailman/listinfo/xymon</font></tt></a><tt><font size=2><br>
</font></tt>
<br>
<br>