I wrote perl and php scripts to connect by ssh to our new AirFiber AF5X HD devices. I haven't yet found a way to do this on the Airfiber with SNMP though I was able to get cpu load averages. Probably I am not going about it the easiest way but wanted to use the php script server to preload the code and make it more efficient. I did research and was somewhat confused by the Data Query XML specifications vs just running as a script server with appropriate modification to the regular script. So I am posting here for other cacti newbies step by step and looking for tips to improve and/or correct mistakes. I did use the cacti site and some php ssh2 references so hat's off to my sources.
<?php
$no_http_headers = true;
// to test script in script server
// php /usr/share/cacti/script_server.php
// /usr/share/cacti/scripts/ss_afthroughput.php ss_afthroughput IP_ADDRESS admin ssh_passwd
/* display No errors */
error_reporting(E_ERROR);
//$fh = fopen("/var/log/cacti/ss_afthoughput.log", "a");
if (!isset($called_by_script_server)) {
// array_shift($_SERVER["argv"]);
print call_user_func('ss_afthroughput', $_SERVER["argv"][1],$_SERVER["argv"][2],$_SERVER["argv"][3]);
}
//if ($fh) { fclose($fh); }
function ss_afthroughput($host='IP_ADDRESS',$user='admin',$pass='ssh_passwd') {
if (!function_exists("ssh2_connect")) die("function ssh2_connect doesn't exist");
$methods = array(
'hostkey'=>'ssh-rsa,ssh-dss',
'client_to_server' => array(
'crypt' => 'aes256-ctr,aes192-ctr,aes128-ctr,aes256-cbc,aes192-cbc,aes128-cbc,3des-cbc,blowfish-cbc',
'comp' => 'none'),
'server_to_client' => array(
'crypt' => 'aes256-ctr,aes192-ctr,aes128-ctr,aes256-cbc,aes192-cbc,aes128-cbc,3des-cbc,blowfish-cbc',
'comp' => 'none'));
$callbacks = array('disconnect' => 'ssh_disconnect');
$cmd = '/usr/www/status.cgi | sed \'1,2d\' | sed s/\,\"time_sec.*// | sed s/.*rx_throughput/RX/ | sed s/\,\"tx_bytes.*tx_throughput/\ TX/ | sed s/\"\:/\:\/g';
$connection = ssh2_connect($host, 22, $methods, $callbacks);
if (!$connection) die("Connection failed:");
ssh2_auth_password($connection, $user, $pass) or die("Unable to authenticate");
$stream = ssh2_exec($connection, $cmd);
stream_set_blocking($stream, true);
$stream_out = ssh2_fetch_stream($stream, SSH2_STREAM_STDIO);
return stream_get_contents($stream_out);
}
/* Notify the user if the server terminates the connection */
function ssh_disconnect($reason, $message, $language) {
printf("Server disconnected with reason code [%d] and message: %s\n", $reason, $message);
}
?>
I copied this to /usr/share/cacti/scripts. I initially tried making an XML and decided this probably wasn't necessary ... and it works.
So hopefully the code is cached in the script server though not a Data Query?
Go to Console / Data Collection / Data Input Methods / and add a new data source
Name AirFiber - SS_Throughput
Input Type Script Server
Input String<path_cacti>/scripts/ss_afthroughput.php ss_afthroughput <hostname> <username> <password>
Input Fields
hostname Hostname 1
username Username 2
password Password 3
Output Fields
RX Recieved Throughput Selected (update rrd file toggle on)
TX Transmitted Throughput Selected (update rrd file toggle on)
I am not sure what the use is of passing the function name to the script when I don't need it to run the script though it might be useful if I wanted to select than one function.
I also wasn't able to pass the $_SERVER['argv'] as an array so passed individual values, I'm a little weak in php.
Go to Console / Template / Data Source / add a new data source
AirFiber - SS_Throughput *Edit Data Input Method.
Name |host_description| - AirFiber SS_Throughput
Data Source Name AirFiber - SS_Throughput
Name |host_description| - SS_Throughput
Data Input Method Airfiber SS_Throughput
Data Source Profile
Data Source Active
1: RX
2: TX
Data Source Item [RX]
Internal Data Source Name
Minimum Value ("U" for No Minimum) 0
Maximum Value ("U" for No Maximum) U
Data Source Type
Output Field
Custom Data [data input: AirFiber - SS_Throughput]
Hostname
Password ssh_password
Username admin_username in this case airfiber uses admin
You need to add input and output fields, input will be hostname username and password .. check the toggle to allow changes to username and password after creation
For output add first RX then TX and select the correct Output Field RX - Recieved Output for RX and TX - Transmitted Throughput for TX
and Save
Go to Templates / Graph / I would just copy one of the other graphs for Interface throughput I think I used the 95th percentile graph. You manually copy the template or just select the graph and make a copy and make the copie's name AirFiber - SS_Througkput.
Delete all the data sources from graph item inputs, these will be recreated.
Go to each indivdual graph item and change the Data Input Filter to Airfiber SS_Throughput and Data Source to the RX for old RX entries and TX for old TX entries aka in and out.
Save the graph when done.
Go to Management / Devices and select the device to edit
Go to add a graph template and add Airfiber SS_Throughput - modify username and password though you can set defaults in the data source template
And, it should say graphing, after the poller runs once it should show up under graphs
