[smokeping-users] Re: RTT, latency and availability calculations

[Bostjan Fele]

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: smokeping-users-bounce at list.ee.ethz.ch
[mailto:smokeping-users-bounce at list.ee.ethz.ch]On Behalf Of Arnold Nipper
Sent: Wednesday, October 06, 2004 4:58 PM
To: bostjan.fele at guest.arnes.si
Cc: smokeping-users at list.ee.ethz.ch
Subject: [smokeping-users] Re: RTT, latency and availability calculations


On 06.10.2004 15:36 bostjan.fele at guest.arnes.si 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:smokeping-users-request at list.ee.ethz.ch?subject=unsubscribe
Help        mailto:smokeping-users-request at list.ee.ethz.ch?subject=help
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:smokeping-users-request at list.ee.ethz.ch?subject=unsubscribe
Help        mailto:smokeping-users-request at list.ee.ethz.ch?subject=help
Archive     http://www.ee.ethz.ch/~slist/smokeping-users
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi