Verlihub Stats (user count and sharesize)

[cyberwolf]

Hy.

I've managed to make my first script/template for Cacti.
It shows the current user count and share size from Verlihub. You must have STATS plugin loaded and running in verlihub for this to work.

To make it work follow this steps :
1. edit the 2 perl scripts and enter a username and password that can access the verlihub table in mySQL (it must be a mySQL user, not a linux user ).
2. copy the 2 Perl scripts to your cacti/plugins folder.
3. import the 2 XML templates
4. create the graphs, and you should be set.

NOTE : look in the XML file, you might need to change the path to perl according to your system's settings (for me it's /usr/bin/perl but on other systems might be /usr/local/bin/perl)

Happy "graphing"

[hgd26]

My suggestion

Little fix to perl scripts to use remote DB and diferent DB:

Code: Select all

my $db_user = 'user_name';
my $db_pass = 'password';

my $dbh = DBI->connect('DBI:mysql:verlihub', $db_user, $db_pass)
    or die "Couldn't connect to database: " . DBI->errstr;

replace with

Code: Select all

my $db = 'verlihub_db';
my $host = 'db_host';
my $user = 'verlihub_user';
my $pass = 'verlihub_password';

# Connect to the database.
my $dbh = DBI->connect("DBI:mysql:database=$db;host=$host",
                                         $user, $pass,
                                         {'RaiseError' => 1});

[enzake]

can you do also a script for bandwitdh consumed included? thx!