Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Fri Jul 19, 2019 4:54 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 13 posts ] 
Author Message
 Post subject: Data Query to get the Route Table
PostPosted: Thu Aug 24, 2006 3:58 am 
Offline
User avatar

Joined: Wed Nov 02, 2005 6:34 am
Posts: 24
Location: Alicante SPAIN
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:
File comment: Data Query (SNMP Indexed) for checking the Route Table of any device.
ipRouteTable.xml [2.93 KiB]
Downloaded 4852 times
Top
 Profile  
 
 Post subject: How!
PostPosted: Mon Sep 04, 2006 3:29 pm 
Offline
User avatar

Joined: Fri Feb 10, 2006 9:54 am
Posts: 47
How do I using this script?


Top
 Profile  
 
 Post subject:
PostPosted: Tue Sep 05, 2006 3:01 am 
Offline
User avatar

Joined: Wed Nov 02, 2005 6:34 am
Posts: 24
Location: Alicante SPAIN
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.


Top
 Profile  
 
 Post subject:
PostPosted: Sun Jul 29, 2007 9:41 pm 
Offline

Joined: Wed May 30, 2007 6:16 am
Posts: 19
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


Top
 Profile  
 
 Post subject:
PostPosted: Mon Jul 30, 2007 3:39 am 
Offline
User avatar

Joined: Wed Nov 02, 2005 6:34 am
Posts: 24
Location: Alicante SPAIN
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.


Top
 Profile  
 
 Post subject: Routing table query
PostPosted: Fri Sep 07, 2007 9:43 am 
Offline

Joined: Tue Apr 24, 2007 3:13 pm
Posts: 1
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


Top
 Profile  
 
 Post subject: Re: Data Query to get the Route Table
PostPosted: Mon Sep 10, 2007 3:29 am 
Offline

Joined: Fri Oct 06, 2006 7:36 am
Posts: 42
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


Top
 Profile  
 
 Post subject: any route in my query ...
PostPosted: Fri Sep 28, 2007 5:36 am 
Offline
Cacti User
User avatar

Joined: Thu May 03, 2007 3:17 pm
Posts: 244
Location: Italy
+ 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


Top
 Profile  
 
 Post subject: Re: Data Query to get the Route Table
PostPosted: Fri Sep 28, 2007 5:45 am 
Offline
Cacti User
User avatar

Joined: Thu May 03, 2007 3:17 pm
Posts: 244
Location: Italy
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


Top
 Profile  
 
 Post subject: Re: Data Query to get the Route Table
PostPosted: Mon Oct 01, 2007 10:04 am 
Offline

Joined: Fri Oct 06, 2006 7:36 am
Posts: 42
Quote:

for me would be very interesting ...

can you post it?

sam


Posted it here;

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


Top
 Profile  
 
 Post subject: Re: any route in my query ...
PostPosted: Wed Feb 20, 2008 9:15 pm 
Offline

Joined: Wed Feb 20, 2008 9:13 pm
Posts: 8
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?


Top
 Profile  
 
 Post subject:
PostPosted: Mon Feb 25, 2008 12:00 pm 
Offline

Joined: Sun Aug 26, 2007 3:07 pm
Posts: 12
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


Top
 Profile  
 
 Post subject: Error in data query.
PostPosted: Fri Mar 20, 2009 3:35 pm 
Offline

Joined: Thu Mar 05, 2009 1:47 am
Posts: 43
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


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 13 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 6 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group