Verbose query timesout

[murugane]

Hi I'm using CACTI 0.8.7e on Windows 2003. I 'm trying to configure "Cisco QOS CM stats" template and have succesfully imported it.
When i add data query for any device and run the verbose query and runs for long time and then times out.

Any help is highly appreciated.

[BSOD2600]

1) read/followed http://forums.cacti.net/viewtopic.php?f=3&t=11747 yet?
2) you realize cacti 0.8.8a is the latest, right?
3) do other snmp queries against that device function from cacti?

[murugane]

Hi,

All other snmp queries are working fine. In fact, the qos class-map queiries from command prompt are working fine.
I'm importing the template from some other cacti setup. Now i notices that when i import DATA QUERY, it gives me some errors like UNMET DEPENDENCIES. We have similar setup from where we exported the template.

Operating System: Window 2003
Webserver: IIS 6
Cacti: 0.8.7e
Spine:
MySQL: 0.8.7
PHP: 5.2.9
RRDTool (Cygwin or Win32 build): 1.2.30
Net-SNMP:5.4.2.1
Cygwin (cygwin1.dll version): No
Plugin Architecture: 2.4

[murugane]

just to add i get te below error when i import the DATA Query.

Data Query

[success] Cisco Router - CM Stats [new]
+ Found Dependency: (Data Input Method) Get Script Data (Indexed)
+ Found Dependency: (Graph Template) Cisco Router - CM Stats - bitrate
+ Found Dependency: (Data Template) Cisco Router - CM Stats - byte64
+ Found Dependency: (Data Template Item) QoSbyte
+ Found Dependency: (Data Template Item) QoSdropbyte
+ Found Dependency: (Data Template Item) QoSprecbyte
+ Unmet Dependency: (Data Template)
+ Unmet Dependency: (Data Template Item)
+ Unmet Dependency: (Data Template Item)
+ Unmet Dependency: (Data Template Item)
+ Found Dependency: (Graph Template) Cisco Router - CM Stats - 5min Average bitrate
+ Found Dependency: (Data Template) Cisco Router - CM Stats - bitrate
+ Found Dependency: (Data Template Item) QoSprecbitrate
+ Found Dependency: (Data Template Item) QoSdropbitrate
+ Found Dependency: (Data Template Item) QoSbitrate

[BSOD2600]

There ya go. Likely reason why the template isn't working on this install. I seem to recall there was a template export bug a while ago (review changelogs for to find out). Sounds like you're possibly experiencing this.

When you exported the template(s), did you make sure the Include Dependencies option was enabled?

[murugane]

yes i did choose "include dependcies". but still it has issues.... Can you direct me to the URL if possible....I will also try from myside to check on that

[murugane]

Also can you please if below URL refers to it.

http://www.cacti.net/download_patches.p ... ion=0.8.7e

Thanks

[murugane]

i tried export/import again...but i still see the issue..

i referred this url http://www.cacti.net/downloads/patches/ ... e-patched/ , and just used template_export.php from this and tried export/import again.....but no LUCK

success] Cisco Router - CM Stats [update]
+ Found Dependency: (Data Input Method) Get Script Data (Indexed)
+ Found Dependency: (Graph Template) Cisco Router - CM Stats - bitrate
+ Found Dependency: (Data Template) Cisco Router - CM Stats - byte64
+ Found Dependency: (Data Template Item) QoSbyte
+ Found Dependency: (Data Template Item) QoSdropbyte
+ Found Dependency: (Data Template Item) QoSprecbyte
+ Unmet Dependency: (Data Template) Cisco Router - CM Stats
+ Unmet Dependency: (Data Template Item) qosbyte
+ Unmet Dependency: (Data Template Item) qosdropbyte
+ Unmet Dependency: (Data Template Item) qosprebyte + Found Dependency: (Graph Template) Cisco Router - CM Stats - 5min Average bitrate
+ Found Dependency: (Data Template) Cisco Router - CM Stats - bitrate
+ Found Dependency: (Data Template Item) QoSprecbitrate
+ Found Dependency: (Data Template Item) QoSdropbitrate
+ Found Dependency: (Data Template Item) QoSbitrate

[BSOD2600]

Did you try running the new /cacti/cli/repair_templates.php script?

[murugane]

I tried this...but same issue...

[BSOD2600]

Well then I guess your only option is to upgrade Cacti.

Did that script say it fixed any templates? I seem to recall years ago when I ran into a similar issue like this, the script did help.

[murugane]

When i ran the repair on the SOURCE server from where I have exported the template , it gave be below output

C:\Inetpub\wwwroot\cacti\cli>php repair_templates.php
NOTE: Performing Check of Templates
NOTE: Performing Check of Data Templates
NOTE: No Damaged Data Templates Found
NOTE: Performing Check of Graph Templates
NOTE: No Damaged Graph Templates Found

[murugane]

Also one more that i want to confirm....

While exporting ,....i export the graph template (this export data template also) and data query.

While importing .....I import graph template (this imports data template also) and then import the data query.

Correct me if I'm wrong here....

[BSOD2600]

One needs to use the --execute option on repair_template.php.

While exporting ,....i export the graph template (this export data template also) and data query.

Only if the option the Include Dependencies was enabled. If the source has the template broken, it will always fail to import elsewhere.

Any dependent scripts must be manually copied into the new system (i.e. stuff which lives in \cacti\scripts\ or \cacti\resource\ subfolders).

[murugane]

hi,

i did ran the command "php repair_templates.php --excute" and i still get the same output on both source and destination servers.

NOTE: Repairing All Duplicated Templates
NOTE: Repairing Data Templates
NOTE: No Damaged Data Templates Found
NOTE: Repairing Graph Templates
NOTE: No Damaged Graph Templates Found

regards