Data Query to get the Route Table

[fabio]

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 !!!

Cheers,

Fabio.

[pgus]

How do I using this script?

[fabio]

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

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

Best regards,

Fabian.

[tonzy0907]

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

[fabio]

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]

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]

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

[zorrosam]

+ 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

[zorrosam]

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]

for me would be very interesting ...

can you post it?

sam

Posted it here;

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

[ryanherdian]

+ 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]

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]

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