[SOLVED]SNMP query whitout Output type ID, Index Value,Index

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Moderators, Developers

Post Reply
Author
Message
galco
Cacti User
Posts: 63
Joined: Fri Aug 03, 2007 3:09 am
Location: Barcelona, Catalunya

[SOLVED]SNMP query whitout Output type ID, Index Value,Index

#1 Post by galco » Tue Feb 03, 2009 9:58 am

Hi,
I need some BGP info from a CISCO router and I followed this tutorial:

I created this xml and I add to Cacti my entry on "Data queries":

Code: Select all

<query>
        <name>Cisco BGP Peer statistics</name>
        <oid_index>.1.3.6.1.4.1.9.9.187.1.2.4.1.1</oid_index>
        <oid_index_parse>OID/REGEXP:.*\.([0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,4}\.[0-9]{1,4})$</oid_index_parse>
        <index_order_type>numeric</index_order_type>
        <index_title_format>|chosen_order_field|</index_title_format>

        <fields>
                <bgpPeerAddr_in>
                        <name>Peer_Address</name>
                        <method>walk</method>
                        <source>OID/REGEXP:.*\.([0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3})\.[0-9]{1,4}\.[0-9]{1,4}$</source>
                        <direction>input</direction>
                        <oid>.1.3.6.1.4.1.9.9.187.1.2.4.1.1</oid>
                </bgpPeerAddr_in>

                <bgpAccepted_in>
                        <name>Peer Acceptats</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>input</direction>
                        <oid>.1.3.6.1.4.1.9.9.187.1.2.4.1.1</oid>
                </bgpAccepted_in>

                <bgpLimit_in>
                        <name>Prefix AdminLimit</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>input</direction>
                        <oid>.1.3.6.1.4.1.9.9.187.1.2.4.1.3</oid>
                </bgpLimit_in>

                <bgpDenegats_in>
                        <name>Prefix Denied</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>input</direction>
                        <oid>.1.3.6.1.4.1.9.9.187.1.2.4.1.2</oid>
                </bgpDenegats_in>

                <bgpThreshold_in>
                        <name>Prefix Threshold</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>input</direction>
                        <oid>.1.3.6.1.4.1.9.9.187.1.2.4.1.4</oid>
                </bgpThreshold_in>

                <bgpAdvertised_in>
                        <name>Prefix Advertised</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>input</direction>
                        <oid>.1.3.6.1.4.1.9.9.187.1.2.4.1.6</oid>
                </bgpAdvertised_in>

                <bgpAcceptats>
                        <name>bgp Acceptats</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>output</direction>
                        <oid>.1.3.6.1.4.1.9.9.187.1.2.4.1.1</oid>
                </bgpAcceptats>

                <bgpMaxim>
                        <name>bgp Maxim</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>output</direction>
                        <oid>.1.3.6.1.4.1.9.9.187.1.2.4.1.3</oid>
                </bgpMaxim>
        </fields>
</query>

Also I created a "Data Template" and a "Graph template". I checked "Output type ID", "Index Value" and "Index Type" on my Data Template.
I can make graph because when I go to "New Graphs" I can see my data query, but after the graphs are created, if I go to the associated "data source", the fields "Output type ID", "Index Value" and "Index Type" are empty and I have no option to choose any value.

What I'm doing wrong? My xml file and my templates seems to interface.xml and its related templates.

Thanks!
Cacti Version - 0.8.7b
Plugin Architecture - 2.1
Poller Type - Cactid v
Server Info - Linux 2.6.18-5-xen-686
Web Server - Apache/2.2.3 (Debian) PHP/5.2.0-8+etch13
PHP - 5.2.0-8+etch13
PHP Extensions - zip, xmlwriter, libxml, xml, wddx, tokenizer, sysvshm, sysvsem, sysvmsg, session, SimpleXML, sockets, soap, SPL, shmop, standard, Reflection, posix, mime_magic, mbstring, json, iconv, hash, gettext, ftp, filter, exif, dom, dba, date, ctype, calendar, bz2, bcmath, zlib, pcre, openssl, xmlreader, apache2handler, mysql, gd, mysqli, PDO, pdo_mysql, snmp
MySQL - 5.0.32-Debian_7etch8-log
RRDTool - 1.3.4
SNMP - 5.2.3
Plugins
  • Global Plugin Settings (settings - v0.5)
    Cacti-ReportIt (reportit - v0.6.1)
    Host Info (hostinfo - v0.2)
    Thresholds (thold - v0.3.9)
    Create Aggregate Graphs (aggregate - v0.66)
    Large Site Performane Booster for Cacti (boost - v1.6)
Attachments
snmp_query.png
snmp_query.png (35.66 KiB) Viewed 4283 times
Last edited by galco on Tue Feb 24, 2009 7:23 am, edited 1 time in total.

User avatar
gandalf
Developer
Posts: 22375
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

#2 Post by gandalf » Tue Feb 03, 2009 4:55 pm

Please post results of a "Verbose Query"
Reinhard

galco
Cacti User
Posts: 63
Joined: Fri Aug 03, 2007 3:09 am
Location: Barcelona, Catalunya

#3 Post by galco » Wed Feb 04, 2009 3:43 am

Thank you for your support gandalf. I changed my public IP range for a private IP range and that's my output.

Code: Select all

+ Running data query [15].
+ Found type = '3' [snmp query].
+ Found data query XML file at '/var/www/cacti-0.8.7b/resource/snmp_queries/cisco_bgp4.xml'
+ XML file parsed ok.
+ Executing SNMP walk for list of indexes @ '.1.3.6.1.4.1.9.9.187.1.2.4.1.1'
+ Located input field 'bgpPeerAddr_in' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.4.1.9.9.187.1.2.4.1.1'
+ Found item [bgpPeerAddr_in='10.10.15.129'] index: 10.10.15.129.1.1 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.10.15.129'] index: 10.10.15.129.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.10.15.131'] index: 10.10.15.131.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.10.15.133'] index: 10.10.15.133.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.10.15.135'] index: 10.10.15.135.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.10.16.30'] index: 10.10.16.30.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.10.16.34'] index: 10.10.16.34.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.10.16.38'] index: 10.10.16.38.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.10.18.6'] index: 10.10.18.6.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.10.18.18'] index: 10.10.18.18.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.10.18.38'] index: 10.10.18.38.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.10.18.42'] index: 10.10.18.42.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.10.18.46'] index: 10.10.18.46.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.10.18.54'] index: 10.10.18.54.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.10.18.74'] index: 10.10.18.74.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.10.18.98'] index: 10.10.18.98.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.10.18.114'] index: 10.10.18.114.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.10.18.134'] index: 10.10.18.134.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.10.18.182'] index: 10.10.18.182.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.10.18.206'] index: 10.10.18.206.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.10.18.218'] index: 10.10.18.218.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.10.19.54'] index: 10.10.19.54.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.10.19.82'] index: 10.10.19.82.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.10.19.178'] index: 10.10.19.178.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.11.214.93'] index: 10.11.214.93.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.12.202.29'] index: 10.12.202.29.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.12.202.37'] index: 10.12.202.37.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.12.202.45'] index: 10.12.202.45.1.2 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.13.98.3'] index: 10.13.98.3.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.13.98.4'] index: 10.13.98.4.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.13.98.5'] index: 10.13.98.5.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.13.98.8'] index: 10.13.98.8.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.13.98.9'] index: 10.13.98.9.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.13.98.11'] index: 10.13.98.11.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.13.98.12'] index: 10.13.98.12.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.13.98.13'] index: 10.13.98.13.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.13.98.14'] index: 10.13.98.14.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.13.98.16'] index: 10.13.98.16.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.13.98.17'] index: 10.13.98.17.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.13.98.18'] index: 10.13.98.18.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.13.98.124'] index: 10.13.98.124.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.13.98.129'] index: 10.13.98.129.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.13.98.130'] index: 10.13.98.130.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.13.98.131'] index: 10.13.98.131.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.13.98.132'] index: 10.13.98.132.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.13.98.134'] index: 10.13.98.134.1.128 [from regexp oid parse]
+ Found item [bgpPeerAddr_in='10.13.98.135'] index: 10.13.98.135.1.128 [from regexp oid parse]
+ Located input field 'bgpAccepted_in' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.4.1.9.9.187.1.2.4.1.1'
+ Found item [bgpAccepted_in='0'] index: 10.10.15.129.1.1 [from value]
+ Found item [bgpAccepted_in='31'] index: 10.10.15.129.1.128 [from value]
+ Found item [bgpAccepted_in='20950'] index: 10.10.15.131.1.128 [from value]
+ Found item [bgpAccepted_in='0'] index: 10.10.15.133.1.128 [from value]
+ Found item [bgpAccepted_in='0'] index: 10.10.15.135.1.128 [from value]
+ Found item [bgpAccepted_in='1'] index: 10.10.16.30.1.128 [from value]
+ Found item [bgpAccepted_in='1'] index: 10.10.16.34.1.128 [from value]
+ Found item [bgpAccepted_in='1'] index: 10.10.16.38.1.128 [from value]
+ Found item [bgpAccepted_in='1'] index: 10.10.18.6.1.128 [from value]
+ Found item [bgpAccepted_in='1'] index: 10.10.18.18.1.128 [from value]
+ Found item [bgpAccepted_in='1'] index: 10.10.18.38.1.128 [from value]
+ Found item [bgpAccepted_in='1'] index: 10.10.18.42.1.128 [from value]
+ Found item [bgpAccepted_in='3'] index: 10.10.18.46.1.128 [from value]
+ Found item [bgpAccepted_in='2'] index: 10.10.18.54.1.128 [from value]
+ Found item [bgpAccepted_in='1'] index: 10.10.18.74.1.128 [from value]
+ Found item [bgpAccepted_in='1'] index: 10.10.18.98.1.128 [from value]
+ Found item [bgpAccepted_in='34'] index: 10.10.18.114.1.128 [from value]
+ Found item [bgpAccepted_in='1'] index: 10.10.18.134.1.128 [from value]
+ Found item [bgpAccepted_in='1'] index: 10.10.18.182.1.128 [from value]
+ Found item [bgpAccepted_in='1'] index: 10.10.18.206.1.128 [from value]
+ Found item [bgpAccepted_in='1'] index: 10.10.18.218.1.128 [from value]
+ Found item [bgpAccepted_in='2'] index: 10.10.19.54.1.128 [from value]
+ Found item [bgpAccepted_in='1'] index: 10.10.19.82.1.128 [from value]
+ Found item [bgpAccepted_in='2'] index: 10.10.19.178.1.128 [from value]
+ Found item [bgpAccepted_in='272014'] index: 10.11.214.93.1.128 [from value]
+ Found item [bgpAccepted_in='273778'] index: 10.12.202.29.1.128 [from value]
+ Found item [bgpAccepted_in='1'] index: 10.12.202.37.1.128 [from value]
+ Found item [bgpAccepted_in='3124'] index: 10.12.202.45.1.2 [from value]
+ Found item [bgpAccepted_in='21'] index: 10.13.98.3.1.128 [from value]
+ Found item [bgpAccepted_in='10'] index: 10.13.98.4.1.128 [from value]
+ Found item [bgpAccepted_in='161'] index: 10.13.98.5.1.128 [from value]
+ Found item [bgpAccepted_in='9'] index: 10.13.98.8.1.128 [from value]
+ Found item [bgpAccepted_in='7'] index: 10.13.98.9.1.128 [from value]
+ Found item [bgpAccepted_in='73'] index: 10.13.98.11.1.128 [from value]
+ Found item [bgpAccepted_in='4'] index: 10.13.98.12.1.128 [from value]
+ Found item [bgpAccepted_in='115'] index: 10.13.98.13.1.128 [from value]
+ Found item [bgpAccepted_in='0'] index: 10.13.98.14.1.128 [from value]
+ Found item [bgpAccepted_in='161'] index: 10.13.98.16.1.128 [from value]
+ Found item [bgpAccepted_in='23'] index: 10.13.98.17.1.128 [from value]
+ Found item [bgpAccepted_in='2'] index: 10.13.98.18.1.128 [from value]
+ Found item [bgpAccepted_in='0'] index: 10.13.98.124.1.128 [from value]
+ Found item [bgpAccepted_in='5002'] index: 10.13.98.129.1.128 [from value]
+ Found item [bgpAccepted_in='24'] index: 10.13.98.130.1.128 [from value]
+ Found item [bgpAccepted_in='166'] index: 10.13.98.131.1.128 [from value]
+ Found item [bgpAccepted_in='2'] index: 10.13.98.132.1.128 [from value]
+ Found item [bgpAccepted_in='243'] index: 10.13.98.134.1.128 [from value]
+ Found item [bgpAccepted_in='5'] index: 10.13.98.135.1.128 [from value]
+ Located input field 'bgpLimit_in' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.4.1.9.9.187.1.2.4.1.3'
+ Found item [bgpLimit_in='0'] index: 10.10.15.129.1.1 [from value]
+ Found item [bgpLimit_in='0'] index: 10.10.15.129.1.128 [from value]
+ Found item [bgpLimit_in='0'] index: 10.10.15.131.1.128 [from value]
+ Found item [bgpLimit_in='0'] index: 10.10.15.133.1.128 [from value]
+ Found item [bgpLimit_in='0'] index: 10.10.15.135.1.128 [from value]
+ Found item [bgpLimit_in='0'] index: 10.10.16.30.1.128 [from value]
+ Found item [bgpLimit_in='0'] index: 10.10.16.34.1.128 [from value]
+ Found item [bgpLimit_in='0'] index: 10.10.16.38.1.128 [from value]
+ Found item [bgpLimit_in='100'] index: 10.10.18.6.1.128 [from value]
+ Found item [bgpLimit_in='0'] index: 10.10.18.18.1.128 [from value]
+ Found item [bgpLimit_in='0'] index: 10.10.18.38.1.128 [from value]
+ Found item [bgpLimit_in='0'] index: 10.10.18.42.1.128 [from value]
+ Found item [bgpLimit_in='0'] index: 10.10.18.46.1.128 [from value]
+ Found item [bgpLimit_in='0'] index: 10.10.18.54.1.128 [from value]
+ Found item [bgpLimit_in='0'] index: 10.10.18.74.1.128 [from value]
+ Found item [bgpLimit_in='0'] index: 10.10.18.98.1.128 [from value]
+ Found item [bgpLimit_in='100'] index: 10.10.18.114.1.128 [from value]
+ Found item [bgpLimit_in='0'] index: 10.10.18.134.1.128 [from value]
+ Found item [bgpLimit_in='0'] index: 10.10.18.182.1.128 [from value]
+ Found item [bgpLimit_in='0'] index: 10.10.18.206.1.128 [from value]
+ Found item [bgpLimit_in='0'] index: 10.10.18.218.1.128 [from value]
+ Found item [bgpLimit_in='0'] index: 10.10.19.54.1.128 [from value]
+ Found item [bgpLimit_in='0'] index: 10.10.19.82.1.128 [from value]
+ Found item [bgpLimit_in='0'] index: 10.10.19.178.1.128 [from value]
+ Found item [bgpLimit_in='300000'] index: 10.11.214.93.1.128 [from value]
+ Found item [bgpLimit_in='300000'] index: 10.12.202.29.1.128 [from value]
+ Found item [bgpLimit_in='1'] index: 10.12.202.37.1.128 [from value]
+ Found item [bgpLimit_in='0'] index: 10.12.202.45.1.2 [from value]
+ Found item [bgpLimit_in='10000'] index: 10.13.98.3.1.128 [from value]
+ Found item [bgpLimit_in='10000'] index: 10.13.98.4.1.128 [from value]
+ Found item [bgpLimit_in='10000'] index: 10.13.98.5.1.128 [from value]
+ Found item [bgpLimit_in='10000'] index: 10.13.98.8.1.128 [from value]
+ Found item [bgpLimit_in='10000'] index: 10.13.98.9.1.128 [from value]
+ Found item [bgpLimit_in='10000'] index: 10.13.98.11.1.128 [from value]
+ Found item [bgpLimit_in='10000'] index: 10.13.98.12.1.128 [from value]
+ Found item [bgpLimit_in='10000'] index: 10.13.98.13.1.128 [from value]
+ Found item [bgpLimit_in='10000'] index: 10.13.98.14.1.128 [from value]
+ Found item [bgpLimit_in='10000'] index: 10.13.98.16.1.128 [from value]
+ Found item [bgpLimit_in='10000'] index: 10.13.98.17.1.128 [from value]
+ Found item [bgpLimit_in='10000'] index: 10.13.98.18.1.128 [from value]
+ Found item [bgpLimit_in='10000'] index: 10.13.98.124.1.128 [from value]
+ Found item [bgpLimit_in='10000'] index: 10.13.98.129.1.128 [from value]
+ Found item [bgpLimit_in='10000'] index: 10.13.98.130.1.128 [from value]
+ Found item [bgpLimit_in='10000'] index: 10.13.98.131.1.128 [from value]
+ Found item [bgpLimit_in='10000'] index: 10.13.98.132.1.128 [from value]
+ Found item [bgpLimit_in='10000'] index: 10.13.98.134.1.128 [from value]
+ Found item [bgpLimit_in='10000'] index: 10.13.98.135.1.128 [from value]
+ Located input field 'bgpDenegats_in' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.4.1.9.9.187.1.2.4.1.2'
+ Found item [bgpDenegats_in='0'] index: 10.10.15.129.1.1 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.10.15.129.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.10.15.131.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.10.15.133.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.10.15.135.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.10.16.30.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.10.16.34.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.10.16.38.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.10.18.6.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.10.18.18.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.10.18.38.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.10.18.42.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.10.18.46.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.10.18.54.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.10.18.74.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.10.18.98.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.10.18.114.1.128 [from value]
+ Found item [bgpDenegats_in='2'] index: 10.10.18.134.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.10.18.182.1.128 [from value]
+ Found item [bgpDenegats_in='1'] index: 10.10.18.206.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.10.18.218.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.10.19.54.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.10.19.82.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.10.19.178.1.128 [from value]
+ Found item [bgpDenegats_in='99'] index: 10.11.214.93.1.128 [from value]
+ Found item [bgpDenegats_in='11369'] index: 10.12.202.29.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.12.202.37.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.12.202.45.1.2 [from value]
+ Found item [bgpDenegats_in='2'] index: 10.13.98.3.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.13.98.4.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.13.98.5.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.13.98.8.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.13.98.9.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.13.98.11.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.13.98.12.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.13.98.13.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.13.98.14.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.13.98.16.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.13.98.17.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.13.98.18.1.128 [from value]
+ Found item [bgpDenegats_in='27334'] index: 10.13.98.124.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.13.98.129.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.13.98.130.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.13.98.131.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.13.98.132.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.13.98.134.1.128 [from value]
+ Found item [bgpDenegats_in='0'] index: 10.13.98.135.1.128 [from value]
+ Located input field 'bgpThreshold_in' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.4.1.9.9.187.1.2.4.1.4'
+ Found item [bgpThreshold_in='0'] index: 10.10.15.129.1.1 [from value]
+ Found item [bgpThreshold_in='0'] index: 10.10.15.129.1.128 [from value]
+ Found item [bgpThreshold_in='0'] index: 10.10.15.131.1.128 [from value]
+ Found item [bgpThreshold_in='0'] index: 10.10.15.133.1.128 [from value]
+ Found item [bgpThreshold_in='0'] index: 10.10.15.135.1.128 [from value]
+ Found item [bgpThreshold_in='0'] index: 10.10.16.30.1.128 [from value]
+ Found item [bgpThreshold_in='0'] index: 10.10.16.34.1.128 [from value]
+ Found item [bgpThreshold_in='0'] index: 10.10.16.38.1.128 [from value]
+ Found item [bgpThreshold_in='75'] index: 10.10.18.6.1.128 [from value]
+ Found item [bgpThreshold_in='0'] index: 10.10.18.18.1.128 [from value]
+ Found item [bgpThreshold_in='0'] index: 10.10.18.38.1.128 [from value]
+ Found item [bgpThreshold_in='0'] index: 10.10.18.42.1.128 [from value]
+ Found item [bgpThreshold_in='0'] index: 10.10.18.46.1.128 [from value]
+ Found item [bgpThreshold_in='0'] index: 10.10.18.54.1.128 [from value]
+ Found item [bgpThreshold_in='0'] index: 10.10.18.74.1.128 [from value]
+ Found item [bgpThreshold_in='0'] index: 10.10.18.98.1.128 [from value]
+ Found item [bgpThreshold_in='75'] index: 10.10.18.114.1.128 [from value]
+ Found item [bgpThreshold_in='0'] index: 10.10.18.134.1.128 [from value]
+ Found item [bgpThreshold_in='0'] index: 10.10.18.182.1.128 [from value]
+ Found item [bgpThreshold_in='0'] index: 10.10.18.206.1.128 [from value]
+ Found item [bgpThreshold_in='0'] index: 10.10.18.218.1.128 [from value]
+ Found item [bgpThreshold_in='0'] index: 10.10.19.54.1.128 [from value]
+ Found item [bgpThreshold_in='0'] index: 10.10.19.82.1.128 [from value]
+ Found item [bgpThreshold_in='0'] index: 10.10.19.178.1.128 [from value]
+ Found item [bgpThreshold_in='90'] index: 10.11.214.93.1.128 [from value]
+ Found item [bgpThreshold_in='90'] index: 10.12.202.29.1.128 [from value]
+ Found item [bgpThreshold_in='75'] index: 10.12.202.37.1.128 [from value]
+ Found item [bgpThreshold_in='0'] index: 10.12.202.45.1.2 [from value]
+ Found item [bgpThreshold_in='90'] index: 10.13.98.3.1.128 [from value]
+ Found item [bgpThreshold_in='90'] index: 10.13.98.4.1.128 [from value]
+ Found item [bgpThreshold_in='90'] index: 10.13.98.5.1.128 [from value]
+ Found item [bgpThreshold_in='90'] index: 10.13.98.8.1.128 [from value]
+ Found item [bgpThreshold_in='90'] index: 10.13.98.9.1.128 [from value]
+ Found item [bgpThreshold_in='90'] index: 10.13.98.11.1.128 [from value]
+ Found item [bgpThreshold_in='90'] index: 10.13.98.12.1.128 [from value]
+ Found item [bgpThreshold_in='90'] index: 10.13.98.13.1.128 [from value]
+ Found item [bgpThreshold_in='90'] index: 10.13.98.14.1.128 [from value]
+ Found item [bgpThreshold_in='90'] index: 10.13.98.16.1.128 [from value]
+ Found item [bgpThreshold_in='90'] index: 10.13.98.17.1.128 [from value]
+ Found item [bgpThreshold_in='90'] index: 10.13.98.18.1.128 [from value]
+ Found item [bgpThreshold_in='90'] index: 10.13.98.124.1.128 [from value]
+ Found item [bgpThreshold_in='90'] index: 10.13.98.129.1.128 [from value]
+ Found item [bgpThreshold_in='90'] index: 10.13.98.130.1.128 [from value]
+ Found item [bgpThreshold_in='90'] index: 10.13.98.131.1.128 [from value]
+ Found item [bgpThreshold_in='90'] index: 10.13.98.132.1.128 [from value]
+ Found item [bgpThreshold_in='90'] index: 10.13.98.134.1.128 [from value]
+ Found item [bgpThreshold_in='90'] index: 10.13.98.135.1.128 [from value]
+ Located input field 'bgpAdvertised_in' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.4.1.9.9.187.1.2.4.1.6'
+ Found item [bgpAdvertised_in='0'] index: 10.10.15.129.1.1 [from value]
+ Found item [bgpAdvertised_in='6803693'] index: 10.10.15.129.1.128 [from value]
+ Found item [bgpAdvertised_in='4988574'] index: 10.10.15.131.1.128 [from value]
+ Found item [bgpAdvertised_in='0'] index: 10.10.15.133.1.128 [from value]
+ Found item [bgpAdvertised_in='0'] index: 10.10.15.135.1.128 [from value]
+ Found item [bgpAdvertised_in='0'] index: 10.10.16.30.1.128 [from value]
+ Found item [bgpAdvertised_in='0'] index: 10.10.16.34.1.128 [from value]
+ Found item [bgpAdvertised_in='1'] index: 10.10.16.38.1.128 [from value]
+ Found item [bgpAdvertised_in='0'] index: 10.10.18.6.1.128 [from value]
+ Found item [bgpAdvertised_in='1'] index: 10.10.18.18.1.128 [from value]
+ Found item [bgpAdvertised_in='2626345'] index: 10.10.18.38.1.128 [from value]
+ Found item [bgpAdvertised_in='4903660'] index: 10.10.18.42.1.128 [from value]
+ Found item [bgpAdvertised_in='44202'] index: 10.10.18.46.1.128 [from value]
+ Found item [bgpAdvertised_in='1'] index: 10.10.18.54.1.128 [from value]
+ Found item [bgpAdvertised_in='1'] index: 10.10.18.74.1.128 [from value]
+ Found item [bgpAdvertised_in='1'] index: 10.10.18.98.1.128 [from value]
+ Found item [bgpAdvertised_in='0'] index: 10.10.18.114.1.128 [from value]
+ Found item [bgpAdvertised_in='0'] index: 10.10.18.134.1.128 [from value]
+ Found item [bgpAdvertised_in='1'] index: 10.10.18.182.1.128 [from value]
+ Found item [bgpAdvertised_in='0'] index: 10.10.18.206.1.128 [from value]
+ Found item [bgpAdvertised_in='7954066'] index: 10.10.18.218.1.128 [from value]
+ Found item [bgpAdvertised_in='1'] index: 10.10.19.54.1.128 [from value]
+ Found item [bgpAdvertised_in='0'] index: 10.10.19.82.1.128 [from value]
+ Found item [bgpAdvertised_in='0'] index: 10.10.19.178.1.128 [from value]
+ Found item [bgpAdvertised_in='2'] index: 10.11.214.93.1.128 [from value]
+ Found item [bgpAdvertised_in='31'] index: 10.12.202.29.1.128 [from value]
+ Found item [bgpAdvertised_in='57'] index: 10.12.202.37.1.128 [from value]
+ Found item [bgpAdvertised_in='0'] index: 10.12.202.45.1.2 [from value]
+ Found item [bgpAdvertised_in='23'] index: 10.13.98.3.1.128 [from value]
+ Found item [bgpAdvertised_in='15'] index: 10.13.98.4.1.128 [from value]
+ Found item [bgpAdvertised_in='15'] index: 10.13.98.5.1.128 [from value]
+ Found item [bgpAdvertised_in='12'] index: 10.13.98.8.1.128 [from value]
+ Found item [bgpAdvertised_in='15'] index: 10.13.98.9.1.128 [from value]
+ Found item [bgpAdvertised_in='15'] index: 10.13.98.11.1.128 [from value]
+ Found item [bgpAdvertised_in='23'] index: 10.13.98.12.1.128 [from value]
+ Found item [bgpAdvertised_in='23'] index: 10.13.98.13.1.128 [from value]
+ Found item [bgpAdvertised_in='23'] index: 10.13.98.14.1.128 [from value]
+ Found item [bgpAdvertised_in='15'] index: 10.13.98.16.1.128 [from value]
+ Found item [bgpAdvertised_in='23'] index: 10.13.98.17.1.128 [from value]
+ Found item [bgpAdvertised_in='15'] index: 10.13.98.18.1.128 [from value]
+ Found item [bgpAdvertised_in='23'] index: 10.13.98.124.1.128 [from value]
+ Found item [bgpAdvertised_in='15'] index: 10.13.98.129.1.128 [from value]
+ Found item [bgpAdvertised_in='15'] index: 10.13.98.130.1.128 [from value]
+ Found item [bgpAdvertised_in='15'] index: 10.13.98.131.1.128 [from value]
+ Found item [bgpAdvertised_in='15'] index: 10.13.98.132.1.128 [from value]
+ Found item [bgpAdvertised_in='15'] index: 10.13.98.134.1.128 [from value]
+ Found item [bgpAdvertised_in='15'] index: 10.13.98.135.1.128 [from value]
+ Found data query XML file at '/var/www/cacti-0.8.7b/resource/snmp_queries/cisco_bgp4.xml'
+ Found data query XML file at '/var/www/cacti-0.8.7b/resource/snmp_queries/cisco_bgp4.xml'
+ Found data query XML file at '/var/www/cacti-0.8.7b/resource/snmp_queries/cisco_bgp4.xml'

User avatar
gandalf
Developer
Posts: 22375
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

#4 Post by gandalf » Wed Feb 04, 2009 2:05 pm

Please post the related Data Template as a screenshot
Reinhard

galco
Cacti User
Posts: 63
Joined: Fri Aug 03, 2007 3:09 am
Location: Barcelona, Catalunya

#5 Post by galco » Wed Feb 04, 2009 3:04 pm

My Data Template.

Thanks!
Attachments
data_template.png
data_template.png (161.39 KiB) Viewed 4210 times

galco
Cacti User
Posts: 63
Joined: Fri Aug 03, 2007 3:09 am
Location: Barcelona, Catalunya

#6 Post by galco » Wed Feb 04, 2009 3:09 pm

This is my Graph Template
Attachments
graph_template_r.png
graph_template_r.png (147.16 KiB) Viewed 4208 times

User avatar
gandalf
Developer
Posts: 22375
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

#7 Post by gandalf » Wed Feb 04, 2009 3:22 pm

Well, that's all correct. Out of ideas, now
Reinhard

galco
Cacti User
Posts: 63
Joined: Fri Aug 03, 2007 3:09 am
Location: Barcelona, Catalunya

#8 Post by galco » Thu Feb 05, 2009 10:00 am

Hi,
I omitted that when I finished all the process and I created my first graph I could get a correct graph, but just this one.
Then I recreated "data query", "data template" and "graph template" but the problem doesn't solved.

I have been looking for something different into mysql database between that graph that's working correctly and the others. I see that the table data_local has an entry for this graph who is working correctly but any entry for the other ones.

Which is the action that fills this table?

Thanks!

galco
Cacti User
Posts: 63
Joined: Fri Aug 03, 2007 3:09 am
Location: Barcelona, Catalunya

#9 Post by galco » Tue Feb 10, 2009 7:24 am

Hi,

I think the problem could be a bug because using the same xml file without this line:

Code: Select all

<oid_index_parse>OID/REGEXP:.*\.([0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,4}\.[0-9]{1,4})$</oid_index_parse>
I get a correct "data souce" but obviously the index values aren't right. Are there any problem using OID/REGEXP as index? The expression returns correct values but cacti internally don't use this information correctly.

Thanks a lot in advance!
Attachments
snmp_query_bo.png
snmp_query_bo.png (20.49 KiB) Viewed 4077 times

galco
Cacti User
Posts: 63
Joined: Fri Aug 03, 2007 3:09 am
Location: Barcelona, Catalunya

#10 Post by galco » Tue Feb 24, 2009 7:21 am

At the end I solved the problem.

Thanks

Code: Select all

<query> 
	<name>Cisco BGP Peer statistics</name>
	<oid_index>.1.3.6.1.4.1.9.9.187.1.2.4.1.1</oid_index>
        <oid_index_parse>OID/REGEXP:.*\.([0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,4}\.[0-9]{1,4})$</oid_index_parse>
	<index_order_type>alphabetic</index_order_type>
        <index_title_format>|chosen_order_field|</index_title_format>
        <fields>
                <IfIndex>
                        <name>Index</name>
                        <method>walk</method>
                        <source>OID/REGEXP:.*\.([0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,4}\.[0-9]{1,4})$</source>
			<direction>input</direction>
                        <oid>.1.3.6.1.4.1.9.9.187.1.2.4.1.1</oid>
                </IfIndex>
		
		<IpAddress>
                        <name>Peer_Address</name>
                        <method>walk</method>
                        <source>OID/REGEXP:.*\.([0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3})\.[0-9]{1,4}\.[0-9]{1,4}$</source>
                        <direction>input</direction>
                        <oid>.1.3.6.1.4.1.9.9.187.1.2.4.1.1</oid>
                </IpAddress>

		<cbgpPeerAccepted>
                        <name>Peer_Acceptats</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>input</direction>
                        <oid>.1.3.6.1.4.1.9.9.187.1.2.4.1.1</oid>
                </cbgpPeerAccepted>

                <cbgpPeerPrefixAdminLimit_in>
                        <name>PeerPrefixAdminLimit</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>input</direction>
                        <oid>.1.3.6.1.4.1.9.9.187.1.2.4.1.3</oid>
                </cbgpPeerPrefixAdminLimit_in>

                <PrefixesDenegats>
                        <name>PeerPrefixDenied</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>input</direction>
                        <oid>.1.3.6.1.4.1.9.9.187.1.2.4.1.2</oid>
                </PrefixesDenegats>

                <PrefixesThreshold>
                        <name>PeerPrefixThreshold</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>input</direction>
                        <oid>.1.3.6.1.4.1.9.9.187.1.2.4.1.4</oid>
                </PrefixesThreshold>

                <PrefixesAdvertised>
                        <name>PeerPrefixAdvertised</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>input</direction>
                        <oid>.1.3.6.1.4.1.9.9.187.1.2.4.1.6</oid>
                </PrefixesAdvertised>

                <cbgpPeerAcceptedPrefixes>
                        <name>cbgpPeerAcceptedPrefixes</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>output</direction>
                        <oid>.1.3.6.1.4.1.9.9.187.1.2.4.1.1</oid>
                </cbgpPeerAcceptedPrefixes>

                <cbgpPeerPrefixAdminLimit>
                        <name>cbgpPeerPrefixAdminLimit</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>output</direction>
                        <oid>.1.3.6.1.4.1.9.9.187.1.2.4.1.3</oid>
                </cbgpPeerPrefixAdminLimit>
		<PrefixesAdvertisedOut>
                        <name>PeerPrefixAdvertised</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>output</direction>
                        <oid>.1.3.6.1.4.1.9.9.187.1.2.4.1.6</oid>
                </PrefixesAdvertisedOut>
		<PrefixesDenegatsOut>
                        <name>PeerPrefixDenied</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>output</direction>
                        <oid>.1.3.6.1.4.1.9.9.187.1.2.4.1.2</oid>
                </PrefixesDenegatsOut>
        </fields>
</query>

User avatar
gandalf
Developer
Posts: 22375
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

#11 Post by gandalf » Sat Mar 07, 2009 3:47 am

Thanks for posting. But please enlight me about the change that was applied. I do not get it from a first glance
Reinhard

Post Reply