Interface Statistics query, timing out

fratzeskos · Joined: 21 Sep 2007 Posts: 9 Location: GR

Hi all,
i have a problem with that script.

When i add this query to our BRAS, because it has hunters of interfaces it times out with no result after some time.
Is there a way that i can tune the xml file so it will stop the query after "X" lines, or it will query interfaces with "X" characters long ?

Thank you all.

jay · Posted: Thu Jan 17, 2008 7:53 am Post subject:

Hi

Have you increased the timeout and memory values in your php.ini config?? If not then you will need to do so.

max_execution_time

memory_limit

It may also be a visual thing

Settings - Visual - Maximum JavaScript Rows

If you are using 0.8.7 then its under Settings - visual - Data Query Graph Rows

I don't know your answer regarding changing the xml file. I think a proper script would do this but don't know how. Hopefully the above solution will solve your problem so you don't need to go down the script road.

Jay

gandalf · Posted: Thu Jan 17, 2008 7:56 am Post subject:

No, there's not really such a filter.
You "may" try to use oid_index_parse with an OID/REGEXP, see http://docs.cacti.net/node/501 if it is possible to filter on index only
Reinhard

fonts · Joined: 08 Jan 2008 Posts: 7

i had a similar issue about getting the data sources
it was my switch.
try plugging the cacti box directly into the device and getting the data sources again.
once u have the data sources everything else works fine so u can plug it back how it was.