Generation of RRD / Custom untemplated MIBS

Post support questions that directly relate to Linux/Unix operating systems.

Moderators: Developers, Moderators

Post Reply
darrynza
Posts: 2
Joined: Tue Mar 17, 2015 1:18 pm

Generation of RRD / Custom untemplated MIBS

Post by darrynza »

Hi ,

I am in serious need of some assistance here I have read forum posts, gone through documentation and done everything I can in my own strength but to no avail. Perhaps I just need a different perspective or possibly my understanding of how the system works is a bit skewed.. Anyway this is the problem I am sitting with currently. We installed new equipment on a clients network. its called a Sonus SBC. Now I have scoured the internet in search of cacti templates for this device however none such templates are in existence. So I have to build from scratch. Which I am ok with since I am always up to learning something new. So I will list the process I am following as well as post a sample data query that I have built by following docs and reading forums.

Here is the process I am following.

1. Create the Data Query File in /resource/snmp_queries
2. Add the Data Query to the frontend
3. Create the Data Template.
4. Create the Graph Template.
5. Link the Graph Template to the Data Query
6. Link the Graph Template to the Host Template ( forgot to mention I have create this as well, also forgot to mention I have create the device on the frontend as well)
7. Add the Data Query to the Device, Re-Index Method: Index Count Changed
8. Run Verbose Query from the Device Screen.
9. Create Graphs for this Host from the Device Screen
10. Cause I don't wish to wait ten minutes each time I manually run the poller(Please tell me if this is a bad idea ?) with the following command.
sudo -u cacti /usr/bin/php /var/www/html/cacti/poller.php --force --debug && tail -f /var/www/html/cacti/log/cacti.log

Below you will find all my internal parts which I mentioned above.

Please I need some guidance I have been struggling with this for to long now :'(

So here is my DQ.

<interface>
<name>SONUS_ATTEMPTED_COMPLETED_UPDATED_CALLS</name>
<description>Get SNMP based Information on Attempted/Completed/Updated Calls from the SONUS-GLOBAL-OBJECTS::sonusGlobalCallCountStatusTable</description>
<index_order_type>numeric</index_order_type>
<oid_index>.1.3.6.1.4.1.2879.2.10.3.112.1</oid_index>
<index_order>CallIndex</index_order>
<index_title_format>|chosen_order_field|</index_title_format>

<fields>
<CallIndex>
<name>CallIndex</name>
<method>walk</method>
<source>value</source>
<direction>input</direction>
<oid>.1.3.6.1.4.1.2879.2.10.3.112.1</oid>
</CallIndex>

<CallAttempted>
<name>CallAttempted</name>
<method>walk</method>
<source>value</source>
<direction>output</direction>
<oid>.1.3.6.1.4.1.2879.2.10.3.112.1.2.97.108.108</oid>
</CallAttempted>
<CallCompleted>
<name>CallCompleted</name>
<method>walk</method>
<source>value</source>
<direction>output</direction>
<oid>.1.3.6.1.4.1.2879.2.10.3.112.1.3.97.108.108</oid>
</CallCompleted>
<CallUpdated>
<name>CallUpdated</name>
<method>walk</method>
<source>value</source>
<direction>output</direction>
<oid>.1.3.6.1.4.1.2879.2.10.3.112.1.6.97.108.108</oid>
</CallUpdated>
</fields>
</interface>

Image

Image

Image

Image

Image

Image


Technical Support
General Information
Date Wed, 18 Mar 2015 00:10:13 +0200
Cacti Version 0.8.8b
Cacti OS unix
SNMP Version NET-SNMP version: 5.7.2
RRDTool Version RRDTool 1.4.x
Hosts 2
Graphs 9
Data Sources Script/Command: 5
SNMP Query: 5
Total: 10
Poller Information
Interval 300
Type cmd.php
Items Action[0]: 4
Total: 4
Concurrent Processes 1
Max Threads 1
PHP Servers 1
Script Timeout 25
Max OID 10
Last Run Statistics Time:1.5120 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:4 RRDsProcessed:2
PHP Information
PHP Version 5.4.16
PHP OS Linux
PHP uname Linux cacti.slug.com 3.10.0-123.el7.x86_64 #1 SMP Mon Jun 30 12:09:22 UTC 2014 x86_64
PHP SNMP Installed
max_execution_time 30
memory_limit 128M

Please let me know if you require any further info from me.


Thanks so much...
darrynza
Posts: 2
Joined: Tue Mar 17, 2015 1:18 pm

Re: Generation of RRD / Custom untemplated MIBS

Post by darrynza »

So Here is the snmpwalk On the table with the corresponding names.

.1.3.6.1.4.1.2879.2.10.3.112.1.2.97.108.108 = Counter32: 665761
.1.3.6.1.4.1.2879.2.10.3.112.1.3.97.108.108 = Counter32: 453597
.1.3.6.1.4.1.2879.2.10.3.112.1.4.97.108.108 = Gauge32: 0
.1.3.6.1.4.1.2879.2.10.3.112.1.5.97.108.108 = Gauge32: 0
.1.3.6.1.4.1.2879.2.10.3.112.1.6.97.108.108 = Counter32: 1304277
.1.3.6.1.4.1.2879.2.10.3.112.1.7.97.108.108 = Gauge32: 0
.1.3.6.1.4.1.2879.2.10.3.112.1.8.97.108.108 = Gauge32: 0
.1.3.6.1.4.1.2879.2.10.3.112.1.9.97.108.108 = Counter32: 0
.1.3.6.1.4.1.2879.2.10.3.112.1.10.97.108.108 = Counter32: 0
.1.3.6.1.4.1.2879.2.10.3.112.1.11.97.108.108 = Counter32: 0
.1.3.6.1.4.1.2879.2.10.3.112.1.12.97.108.108 = Counter32: 0


SONUS-GLOBAL-OBJECTS::sonusGlobalCallCountStatusCallAttempts.'all' = Counter32: 665764
SONUS-GLOBAL-OBJECTS::sonusGlobalCallCountStatusCallCompletions.'all' = Counter32: 453599
SONUS-GLOBAL-OBJECTS::sonusGlobalCallCountStatusActiveCalls.'all' = Gauge32: 1
SONUS-GLOBAL-OBJECTS::sonusGlobalCallCountStatusStableCalls.'all' = Gauge32: 1
SONUS-GLOBAL-OBJECTS::sonusGlobalCallCountStatusCallUpdates.'all' = Counter32: 1304282
SONUS-GLOBAL-OBJECTS::sonusGlobalCallCountStatusActiveCallsNonUser.'all' = Gauge32: 0
SONUS-GLOBAL-OBJECTS::sonusGlobalCallCountStatusStableCallsNonUser.'all' = Gauge32: 0
SONUS-GLOBAL-OBJECTS::sonusGlobalCallCountStatusTotalCalls.'all' = Counter32: 1
SONUS-GLOBAL-OBJECTS::sonusGlobalCallCountStatusTotalCallsNonUser.'all' = Counter32: 0
SONUS-GLOBAL-OBJECTS::sonusGlobalCallCountStatusTotalCallsEmergEstablishing.'all' = Counter32: 0
SONUS-GLOBAL-OBJECTS::sonusGlobalCallCountStatusTotalCallsEmergStable.'all' = Counter32: 0



Currently i have managed to get the rrd generated seeing as though it was counter values i followed the documentation about that and used a regex in the query.

Here is my update query:


<interface>
<name>Get sonusGlobalCallCountStatusTable Attempted/Completed Calls</name>
<description>Get SNMP based Information on Attempted and Completed Calls from the SONUS-GLOBAL-OBJECTS::sonusGlobalCallCountStatusTable</description>
<oid_index_parse>OID/REGEXP:([0-9]*).'all'</oid_index_parse>
<oid_index>.1.3.6.1.4.1.2879.2.10.3.112.1</oid_index>
<index_order>Index</index_order>
<index_order_type>numeric</index_order_type>

<fields>
<Index>
<name>Index</name>
<source>index</source>
<direction>input</direction>
</Index>
<CallAttempts>
<name>CallAttempts</name>
<method>walk</method>
<source>value</source>
<direction>output</direction>
<oid>.1.3.6.1.4.1.2879.2.10.3.112.1</oid>
<oid_sufix>2</oid_sufix>
</CallAttempts>
<CallCompletions>
<name>Call Completions</name>
<method>walk</method>
<source>value</source>
<direction>output</direction>
<oid>.1.3.6.1.4.1.2879.2.10.3.112.1</oid>
<oid_sufix>3</oid_sufix>
</CallCompletions>
<CallUpdates>
<name>Call Updates</name>
<method>walk</method>
<source>value</source>
<direction>output</direction>
<oid>.1.3.6.1.4.1.2879.2.10.3.112.1</oid>
<oid_sufix>6</oid_sufix>
</CallUpdates>
</fields>
</interface>

with this I get the rrd's generate but with nan values.

here is the log file. it seems the names are being added to the end of the oid's :oops:


03/19/2015 01:50:03 AM - CMDPHP: Poller[0] Host[2] DS[10] SNMP: v2: xx.xx.xx.xx, dsname: CallAttempts, oid: .1.3.6.1.4.1.2879.2.10.3.112.1.sonusGlobalCallCountStatusCallUpdates, output: U
03/19/2015 01:50:03 AM - CMDPHP: Poller[0] WARNING: SNMP Get Timeout for Host:'41.77.27.179', and OID:'.1.3.6.1.4.1.2879.2.10.3.112.1.sonusGlobalCallCountStatusCallUpdates'
03/19/2015 01:50:03 AM - CMDPHP: Poller[0] Host[2] DS[10] WARNING: Result from SNMP not valid. Partial Result: U
03/19/2015 01:50:03 AM - CMDPHP: Poller[0] Host[2] DS[10] SNMP: v2: xx.xx.xx.xx, dsname: CallCompletions, oid: .1.3.6.1.4.1.2879.2.10.3.112.1.sonusGlobalCallCountStatusCallUpdates, output: U
03/19/2015 01:50:03 AM - CMDPHP: Poller[0] WARNING: SNMP Get Timeout for Host:'41.77.27.179', and OID:'.1.3.6.1.4.1.2879.2.10.3.112.1.sonusGlobalCallCountStatusCallUpdates'
03/19/2015 01:50:03 AM - CMDPHP: Poller[0] Host[2] DS[10] WARNING: Result from SNMP not valid. Partial Result: U
03/19/2015 01:50:03 AM - CMDPHP: Poller[0] Host[2] DS[10] SNMP: v2: xx.xx.xx.xx, dsname: CallUpdates, oid: .1.3.6.1.4.1.2879.2.10.3.112.1.sonusGlobalCallCountStatusCallUpdates, output: U
03/19/2015 01:50:03 AM - CMDPHP: Poller[0] Time: 2.1802 s, Theads: N/A, Hosts: 2
03/19/2015 01:50:04 AM - POLLER: Poller[0] CACTI2RRD: /bin/rrdtool update /usr/share/cacti/rra/sonus_sbc-2_callattempts_10.rrd --template CallAttempts:CallCompletions:CallUpdates 1426729801:U:U:U
03/19/2015 01:50:04 AM - SYSTEM STATS: Time:2.4337 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:14 RRDsProcessed:8

before the regex the values were being added onto the end of the oid and the value field was equal to U.

Please someone if you can tell me what I am doing wrong here
osiris123d
Cacti User
Posts: 59
Joined: Fri Mar 23, 2007 3:38 pm

Re: Generation of RRD / Custom untemplated MIBS

Post by osiris123d »

Did you ever get this template working?
mmccaugh
Cacti User
Posts: 100
Joined: Mon Apr 09, 2018 1:37 pm

Re: Generation of RRD / Custom untemplated MIBS

Post by mmccaugh »

Curious if this was ever completed, if so it could save me a fair amount of work as I need to do the same :)
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest