[solved] SNMP data query trouble

[rejnol]

hi,
I have a trouble with SMNP data query.
So.. I created a new host. Then I want create new grafs for this host, but I see this message "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." in the Data Query field.
Ok, I ran data query in debug mode and I saw

Code: Select all

+ Running data query [1].
+ Found type = '3' [SNMP Query].
+ Found data query XML file at '/usr/local/share/cacti/resource/snmp_queries/interface.xml'
+ XML file parsed ok.
+ Executing SNMP get for num of indexes @ '.1.3.6.1.2.1.2.1.0' Index Count: 8
+ Executing SNMP walk for list of indexes @ '.1.3.6.1.2.1.2.2.1.1' Index Count: 8
+ Index found at OID: 'ifIndex.1' value: '1'
+ Index found at OID: 'ifIndex.2' value: '2'
+ Index found at OID: 'ifIndex.3' value: '3'
+ Index found at OID: 'ifIndex.4' value: '4'
+ Index found at OID: 'ifIndex.7' value: '7'
+ Index found at OID: 'ifIndex.8' value: '8'
+ Index found at OID: 'ifIndex.9' value: '9'
+ Index found at OID: 'ifIndex.10' value: '10'
+ Located input field 'ifIndex' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.2.2.1.1'
+ Found item [ifIndex='1'] index: 1 [from value]
+ Found item [ifIndex='2'] index: 2 [from value]
+ Found item [ifIndex='3'] index: 3 [from value]
+ Found item [ifIndex='4'] index: 4 [from value]
+ Found item [ifIndex='7'] index: 7 [from value]
+ Found item [ifIndex='8'] index: 8 [from value]
+ Found item [ifIndex='9'] index: 9 [from value]

and more.
What I do wrong?
I'm using cacti 088b on freebsd.

ps. Sorry for my english. It's not my native language.

[rejnol]

Problem is solved.
Mysql told me - "Table host_snmp_cache is marked as crashed and should be repaired". Do repair the table and enjoy)))