RTG

From Hurlster Wiki
Jump to navigation Jump to search

Get Source

http://sourceforge.net/projects/rtg/

Build Supporting Packages

apt-get install libapache2-mod-php5 mysql-server php5-mysql php5-snmp rrdtool  \
libmysqlclient-dev libmysqlclient16 php-pear php5-cgi php5-cli php5-gd \
php5-mysql php5-snmp libsnmp-base libsnmp libsnmp-dev php5-snmp snmp gcc g++ make patch unp

Compile

./configure
make
make install

This will install all the configuration files under /usr/local/rtg folder

Configure

Now you need to copy rtgplolt file using the following command 

cp /usr/local/src/rtg-0.7.4/src/rtgplot /usr/local/bin/rtgplot

If you want to configure your database you must know the MYSQL root password. The createdb script will setup the database for RTG. 

/usr/local/rtg/etc/createdb mysqlrootpassword

If you want to configure Rtg you need to edit two configuration files in 

/usr/local/rtg/etc/routers

Target Maker file

Edit rtgtargmkr.pl(located at /usr/local/rtg/etc) to change the default SNMP read community if necessary.
To use 64bit OIDs (recommended if supported by the device), change the "bits" field in rtgtargmkr.pl to 64.
rtgtargmkr.pl script to manage the RTG target file. The first run will create a targets.cfg file. 

./rtgtargmkr.pl

This will create a targets.cfg file with all your routers and switches interfaces details in this.One more important thing
is if you do any changes to your router configuration file you need to run the rtgtargmkr.pl otherwise it will not show the
new changes after running this script you need to update your database to see these changes.When you run the perl
script it will give the command name you need to run in mysql database command you can see one example as follows 

     Interface description changed.
      Was: "global network 100Mbps"
      Now: "global_network 100Mbps"
      Suggest: UPDATE interface SET description='global_network 100Mbps' WHERE id=7

now you need to login in to your mysql database using the following command 

mysql rtg -p -u snmp
Enter PASSWORD
mysql> UPDATE interface SET description='global_network 100Mbps' WHERE id=7;

this will update the changes in your database.
Presently you need to do manually every time you do some changes and this one i don't like personally.

Starting Poller

Start up the poller to use the target list 

/usr/local/rtg/bin/rtgpoll -v -t /usr/local/rtg/etc/targets.cfg

If the poller does not find a configuration file, it will create one in the current directory called "rtg.conf". You may need to edit this file if your installation is non-standard. If the poller is successful, the "Polls" counter in the statistics banner will increase and then a countdown to the next poll is displayed. The DBInserts should increment after the second polling round.

If rtgpoll or rtgplot cannot find an rtg.conf file in any of these paths, it will attempt to create one in the current working directory.Most users maintain a master rtg.conf file customized for their environment. rtg.conf contains the following configurable fields: 

Interval         300
HighSkewSlop     3
LowSkewSlop      .5
OutOfRange       93750000000
SNMP_Ver         1
SNMP_Port       161
DB_Host          localhost
DB_Database      rtg
DB_User          snmp
DB_Pass          rtgdefault
Threads          5

Interval is the time between successive polls of the target list,default is 300 seconds (5 minutes). HighSkewSlop defines the maximum number of Intervals allowed between two consecutive poll values before the time in seconds between said points is deemed too large to calculate a valid rate. With the default Interval and HighSkewSlop values, that time would be 300 * 3 (15 minutes). LowSkewSlop defines the minimum number of Intervals alloweed between two consecutive poll values before the time in seconds between said points is deemed two low to calculate a valid rate. With the default Interval and LowSkewSlop values, that time would be 300 * 0.5 (2.5 minutes). OutOfRange defines an upper bound above which rtgpoll will never attempt an insert into the database.

OutOfRange should be a multiple of the maximum number of bytes possible in the defined Interval for your highest speed link. The default OutOfRange value will suffice in most installations. SNMP_Ver specifies the SNMP version the poller will use. The number of threads rtgpoll will use is defined in the variable Threads.

Variables in rtg.conf must match the names above exactly.Comments and blank lines are allowed and the ordering of variables in rtg.conf does not matter.

The target file specifies the objects to be SNMP polled. Comments must be preceded with a '#' sign. Elements in the target file are tab delimited.

The format of the target file is fixed: 

Host  OID  64/32  Community  Table   ID   Description

where 

Host        = IP or hostname of target
OID         = Full SNMP OID, e.g. .1.3.6.1.2.1.31.1.1.1.10.19
64/32/0     = Specify 64/32 bit objects or 0 for gauge objects
Community   = SNMP Community
Table       = MySQL table in the database to use
ID          = A unique ID that is used with each insert
Description = Free text

rtgpoll first reads the configuration file, then the target file.For each SNMP poll, rtgpoll will attempt an SQL INSERT of the form: 

INSERT INTO Table VALUES (ID, NOW(), bigint)

Where Table is the name of the database table and ID is an integer. Both Table and ID come from the target list, NOW() is the current timestamp and bigint is the delta value between successive SNMP polls.

RTG makes no attempt at determining rate; one must look at the time difference successive entries in the database. The RTG graphing and reporting tools automatically calculate rate.

Adding poller to crontab 

crontab -e

@reboot /usr/local/rtg/bin/rtgpoll -v -t /usr/local/rtg/etc/targets.cfg -c /usr/local/rtg/etc/rtg.conf

The above command automatically starts when you reboot your server.

Web interface and Graphs

your configuration is ready and now you need to configure the web interface to view graphs and 95th percentile data for this you need to configure the following steps 

cp /usr/local/rtg/web/ /var/www/rtgweb/

Copy the rtgplot binary to the /var/www/rtgweb/ directory and *add* .cgi 

cp /usr/local/rtg/bin/rtgplot /var/www/rtgweb/rtgplot.cgi

or

ln -i -s /usr/local/bin/rtgplot /var/www/rtgweb/rtgplot.cgi

Now you need to create a apache2 website enable file name rtg with the following content 

vi /etc/apache2/sites-enabled/rtg

<Directory "/var/www/rtgweb/">

      AllowOverride AuthConfig
      AddType application/x-httpd-php .php
      AddHandler cgi-script .cgi
      Options +ExecCGI

</Directory>

Save and exit this file.Now you need to enable this site using the following 

a2ensite rtg

Restart apache server 

/etc/init.d/apache2 restart

Now you need to secure rtg web interface with .htaccess file for this we need to create a .htaccess file in /var/www/rtgweb/ directory 

cd /var/www/rtgweb/

touch .htaccess

Now you need to enter the content in .htaccess file as follows 

AuthUserFile /var/www/rtgweb/.htpasswd
AuthName Members
AuthType Basic
require valid-user

Now you need to create admin user or users using the following command 

htpasswd -b /var/www/rtgweb/.htpasswd  masteradmin password

the above command will create a username as masteradmin with password as password.

You can access rtg using the following command 

http://yourserverip/rtgweb/

Point your web browser at the URL (substitute your site in) 

      http://yourserverip/rtgweb/rtg.php  (Interactive Reports)
      http://yourserverip/rtgweb/95.php   (95th Percentile Queries)
      http://yourserverip/rtgweb/view.php (MRTG-style overview + day/wk/mo plots)
Retrieved from "https://hurlster.com/wiki/index.php?title=RTG&oldid=2406"