Data Query to get the Route Table

Templates, scripts for templates, scripts and requests for templates.

Moderators: Moderators, Developers

Post Reply
Author
Message
User avatar
fabio
Posts: 24
Joined: Wed Nov 02, 2005 6:34 am
Location: Alicante SPAIN

Data Query to get the Route Table

#1 Post by fabio » Thu Aug 24, 2006 3:58 am

Hi all,

this is my first contribution to the Forum so any comments and suggestion will be highly apreciated.

I made a very simple Data Query to be able to get the Route Table from any SNMP-able device.

I know that it is not very useful for graphing purposes, but the motivation for such a query was to be able to check the route table from several critical devices, that our Service Providers don't allow us access to the console, but we do are allowed SNMP read access. This way we can monitor the routing of our whole network and improve our troubleshooting response times.

Hey, I find it very useful, but don't try to get this data from a Full Routing BGP device because it will time-out, it is too heavy even for the 9th wonder of the world, also known as cacti !!! :lol:

Cheers,

Fabio.
Attachments
ipRouteTable.xml
Data Query (SNMP Indexed) for checking the Route Table of any device.
(2.93 KiB) Downloaded 4864 times

User avatar
pgus
Posts: 47
Joined: Fri Feb 10, 2006 9:54 am

How!

#2 Post by pgus » Mon Sep 04, 2006 3:29 pm

How do I using this script?

User avatar
fabio
Posts: 24
Joined: Wed Nov 02, 2005 6:34 am
Location: Alicante SPAIN

#3 Post by fabio » Tue Sep 05, 2006 3:01 am

Hi Gus,

just copy this template in to your "<cacti_path>/resource/snmp_queries/" directory and go to Data Queries and Add this new one just give it the name you want and fill the path to that xml file.

After creating it succesfully (don't forget that it is required that you receive the "Successfully located XML file"), go to "Devices", then go to "Associated Data Queries" and execute the Query you just created to retrieve the Route Table.

You then can go to "Create Graphs for this Host" to see the route table for that device.

I am glad that you wan't to try this my-query :D

Don't hesitate to reply to me if you can't work it out.

Best regards,

Fabian.

tonzy0907
Posts: 19
Joined: Wed May 30, 2007 6:16 am

#4 Post by tonzy0907 » Sun Jul 29, 2007 9:41 pm

You then can go to "Create Graphs for this Host" to see the route table for that device.

I got this error.


This data query returned 0 rows, perhaps there was a problem executing this data query. You can run this data query in debug mode to get more information.



running : centos 4.5 , cacti 0.8.6j

User avatar
fabio
Posts: 24
Joined: Wed Nov 02, 2005 6:34 am
Location: Alicante SPAIN

#5 Post by fabio » Mon Jul 30, 2007 3:39 am

Hi Tonzy,

Did you try to make the query in debug mode? Could you paste the output.

Also, I understand that you have checked that your device supports the "ip route" MIB, which device is it?

Regards,
Fabian.

mamir01
Posts: 1
Joined: Tue Apr 24, 2007 3:13 pm

Routing table query

#6 Post by mamir01 » Fri Sep 07, 2007 9:43 am

Hi,

This is an excellent query but I'm stuck and would appreciate some help as I'm a newbie to cacti. I have created the new data query and added the path to the xml file but what do i put into the graphs parameters. When i click on add a graph i'm not sure about the parameters. Any help will be appreciated. Many thanks.

Regards,

Amir

UKS-Gavin
Posts: 42
Joined: Fri Oct 06, 2006 7:36 am

Re: Data Query to get the Route Table

#7 Post by UKS-Gavin » Mon Sep 10, 2007 3:29 am

fabio wrote:Hey, I find it very useful, but don't try to get this data from a Full Routing BGP device because it will time-out, it is too heavy even for the 9th wonder of the world
If anyone is after BGP table sizes then drop me a note, I've put one together to query Cisco/Foundry devices using expect-ssh and expect-telnet.

If there's a lot of interest I'll make it portable and publish it.

Cheers,
Gavin

User avatar
zorrosam
Cacti User
Posts: 244
Joined: Thu May 03, 2007 3:17 pm
Location: Italy

any route in my query ...

#8 Post by zorrosam » Fri Sep 28, 2007 5:36 am

+ Running data query [13].
+ Found type = '4 '[script query].
+ Found data query XML file at '/var/www/cacti/resource/snmp_queries/iproutetable.xml'
+ XML file parsed ok.
+ Executing script for list of indexes ' '
+ Executing script query ' '
+ Executing script query ' '
+ Executing script query ' '
+ Executing script query ' '
+ Executing script query ' '
+ Executing script query ' '
+ Executing script query ' '
+ Found data query XML file at '/var/www/cacti/resource/snmp_queries/iproutetable.xml'
+ Found data query XML file at '/var/www/cacti/resource/snmp_queries/iproutetable.xml'
+ Found data query XML file at '/var/www/cacti/resource/snmp_queries/iproutetable.xml'

please help me .... why

User avatar
zorrosam
Cacti User
Posts: 244
Joined: Thu May 03, 2007 3:17 pm
Location: Italy

Re: Data Query to get the Route Table

#9 Post by zorrosam » Fri Sep 28, 2007 5:45 am

UKS-Gavin wrote:
fabio wrote:Hey, I find it very useful, but don't try to get this data from a Full Routing BGP device because it will time-out, it is too heavy even for the 9th wonder of the world
If anyone is after BGP table sizes then drop me a note, I've put one together to query Cisco/Foundry devices using expect-ssh and expect-telnet.

If there's a lot of interest I'll make it portable and publish it.

Cheers,
Gavin
for me would be very interesting ...

can you post it?

sam

UKS-Gavin
Posts: 42
Joined: Fri Oct 06, 2006 7:36 am

Re: Data Query to get the Route Table

#10 Post by UKS-Gavin » Mon Oct 01, 2007 10:04 am


for me would be very interesting ...

can you post it?

sam
Posted it here;

http://forums.cacti.net/viewtopic.php?p=112189#112189

ryanherdian
Posts: 8
Joined: Wed Feb 20, 2008 9:13 pm

Re: any route in my query ...

#11 Post by ryanherdian » Wed Feb 20, 2008 9:15 pm

zorrosam wrote:+ Running data query [13].
+ Found type = '4 '[script query].
+ Found data query XML file at '/var/www/cacti/resource/snmp_queries/iproutetable.xml'
+ XML file parsed ok.
+ Executing script for list of indexes ' '
+ Executing script query ' '
+ Executing script query ' '
+ Executing script query ' '
+ Executing script query ' '
+ Executing script query ' '
+ Executing script query ' '
+ Executing script query ' '
+ Found data query XML file at '/var/www/cacti/resource/snmp_queries/iproutetable.xml'
+ Found data query XML file at '/var/www/cacti/resource/snmp_queries/iproutetable.xml'
+ Found data query XML file at '/var/www/cacti/resource/snmp_queries/iproutetable.xml'

please help me .... why
i also have this kind of message, and no data is executed. could anybody give the solution?

EoinDubh
Posts: 12
Joined: Sun Aug 26, 2007 3:07 pm

#12 Post by EoinDubh » Mon Feb 25, 2008 12:00 pm

I am getting the same result as zorrosam and others. I am running:
Cacti Version 0.8.7a
Plugin Architecture 1.4
Poller Type CMD.php
Server Info Linux 2.6.9-67.0.4.plus.c4smp
Web Server Apache/2.0.59 (CentOS)
PHP Version 5.1.6
MySQL Version 5.0.54
RRDTool Version 1.2.23
SNMP Version 5.1.2

I did a snmpwlak on one of my Cisco 2800 routers and see all the OIDs that are listed in ipRouteTable.xml.

Does anyone have a fix for this.

Thanks

mkhalil10
Posts: 43
Joined: Thu Mar 05, 2009 1:47 am

Error in data query.

#13 Post by mkhalil10 » Fri Mar 20, 2009 3:35 pm

hey all
i took the xml file and placed it in the snmp_quries directory
and made a data query and successfully located the xml file
when i go to devices and create a new graphs i got the error Error in data query.

any help

Thanks,
Mohammad Khalil

Post Reply