standard script query like host_cpu or host_hdd not working

[lethalwp]

Hello,

I have a cacti (0.8.6b), running on linux (fed core 2):
I need to make graphs for a windows server, especially disk usage & cpu.

So i've added the windows "device", snmp is working:
in Associated data queries:
SNMP - Get Mounted Partitions replies 21 Items
SNMP - Get Processor Information replies 4 items

& created the associated graphs

but the rrd doesn't seem to be populated (not even created).
I've already tried to launch a poller (both cactid & cmd.php) in full debug mode, the only thing i can read is:
Host[29]: RECACHE: Processing 3 items in the auto reindex cache for 'server'

An output from:
php -q query_host_cpu.php server community 2 query index
0!21
1!15
2!23
3!18


So here are my questions:
1) can cactid execute/poll script queries?
2) is it normal that the auto generated graphs have names like:
server - Used Space - |query_hrStorageDescr|
server - CPU Utilization - CPU|query_hrProcessorFrwID|

instead ot having the || replaced by the detected "index" ?
where should i debug this?

3) how do you recomment me to debug the poller, to find out if it does the script query poll & what to find out what happens with the data?


Just one thing, that could have an influence, one of the users that had access to cacti deleted all my data templates, which i reimported from the cacti.sql, some of them could still be corrupted, but i did check the ones i am using right now, & most of the graphics i add do work. Only not scripted queries.

Greetings,
J-Y

[lethalwp]

After a lot of debugging, first thing found:

the table
data_local does NOT contain correct values for the added data source (script query)

by this i mean:
snmp_query_id = 0
snmp_index = null

in my case values should have been:
id=9 & idx=0

[lethalwp]

I have some bad news for myself:
i've reinstalled a total fresh cacti
And there, that type of query works out of the box

So something must be fscked in all my tables but what

I'm getting a depression =)

[lethalwp]

Erased everything related to the snmp/templates/...
reimported them from cacti.sql

IT4S WORKING

finally... =)

Case Closed

[slowtrance]

I have run up against the same issue. I can run from the command prompt:

php -q ss_host_cpu.php server community 1 query index

and get:

0!0
1!1
2!2
3!3

In the device information, SNMP Get Mounted Partitions says success but shows 0,0 items as does Get Processor Information. Interface Statistics however shows up with 14,2 items and works.

If I try to do a verbose query on either the partitions or processor information the page hangs and eventually times out.

I have checked the permissions on my cmd.exe as mentioned in another post on this subject.

I am thinking my database might be damaged and was hoping you could point me towards what exactly you had to rebuild. I am hoping not to lose the data that is already in there as it is quite a bit...

I was also wondering since these are the only 2 queries that use the Get Script Server Data method if there might be something wrong with that?

Specs: Cacti 0.8.6c, Windows Server 2003, NetSNMP 5.2.1, PHP 4.3.10, MySQL 4.0.22

Thanks!