Yes,
You point script to top directory under which Smokeping RRD files are
located (see tabular.conf). Perl script searches for *.rrd and grabs data
out.
I know I will have to explain a lot so lets start.
I used MySQL database to define what are acceptable values (table sla).
There is a table outage for planned outages and this timeframe is not used
in calculation:
-- MySQL dump 9.10
--
-- Host: localhost Database: smokeping
-- ------------------------------------------------------
-- Server version 4.0.18
--
-- Table structure for table `outage`
--
CREATE TABLE outage (
id int(10) unsigned NOT NULL auto_increment,
target char(30) NOT NULL default '',
start_epoch int(15) NOT NULL default '0',
end_epoch int(15) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;
--
-- Dumping data for table `outage`
--
INSERT INTO outage VALUES (7,'all',1081700326,1081800026);
INSERT INTO outage VALUES (4,'all',1081456056,1081456256);
--
-- Table structure for table `sla`
--
CREATE TABLE sla (
target char(30) NOT NULL default '',
rtt float(10,4) unsigned NOT NULL default '0.0000',
jitter float(8,5) NOT NULL default '0.00000',
reach float(8,5) unsigned NOT NULL default '0.00000',
avail float(8,5) unsigned NOT NULL default '0.00000',
PRIMARY KEY (target)
) TYPE=MyISAM;
--
-- Dumping data for table `sla`
--
INSERT INTO sla VALUES ('default',500.0000,10.00000,95.00000,99.90000);
INSERT INTO sla VALUES ('Brahma',100.0000,10.00000,50.00000,95.00000);
INSERT INTO sla VALUES ('Localhost',5123.4561,10.00000,100.00000,95.00000);
INSERT INTO sla VALUES ('Cisco-WWW',1000.0000,10.00000,90.00000,99.00000);
Rename report.txt into report.pl and point in it to config file
(tabular.conf). Please find required perl modules in report.pl script.
Regards,
Bostjan
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Arnold Nipper
Sent: Wednesday, October 06, 2004 4:58 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: [smokeping-users] Re: RTT, latency and availability calculations
On 06.10.2004 15:36 [EMAIL PROTECTED] wrote:
> Hi,
>
> writen a perl script to get RTT, jitter, availability and packet loss
> from Smokeping RRDs. Anybody interested?
>
rrdtool fetch ... Or what are you doing
Arnold
--
Unsubscribe
mailto:[EMAIL PROTECTED]
Help mailto:[EMAIL PROTECTED]
Archive http://www.ee.ethz.ch/~slist/smokeping-users
WebAdmin http://www.ee.ethz.ch/~slist/lsg2.cgi
-- Attached file removed by Ecartis and put at URL below --
-- Type: text/plain
-- Size: 32k (32986 bytes)
-- URL : http://www.ee.ethz.ch/~slist/p/report.txt
-- Attached file removed by Ecartis and put at URL below --
-- Type: application/octet-stream
-- Size: 773 bytes
-- URL : http://www.ee.ethz.ch/~slist/p/tabular.conf
--
Unsubscribe mailto:[EMAIL PROTECTED]
Help mailto:[EMAIL PROTECTED]
Archive http://www.ee.ethz.ch/~slist/smokeping-users
WebAdmin http://www.ee.ethz.ch/~slist/lsg2.cgi
