Getting no data back from Data Queries after upgrade

[llhoweth]

Hello,

I upgraded cacti last week, it was long overdue. Went from 0.8.6g to 0.8.7b. Since that time I am having problems with getting data back from 2 Data Queries on Windows servers.

Versions:
cacti 0.8.7b
OS SUSE Linux Enterprise Server 9 patch 4
Apache/2.0.59
mysqld Ver 4.0.18
PHP 4.3.9, Zend Engine v1.3.0
NET-SNMP version: 5.1.3.1
RRDtool 1.0.46

Verbose Query results of "SNMP - Get Mounted Partitions":

Code: Select all

+ Running data query [8].
+ Found type = '6 '[script query].
+ Found data query XML file at '/srv/www/htdocs/resource/script_server/host_disk.xml'
+ XML file parsed ok.
+ Executing script for list of indexes '/usr/bin/php -q /srv/www/htdocs/scripts/ss_host_disk.php hebron.salisbury.edu 217 1:161:500:!:~SNMPSTRING~:!:::MD5::DES: index'
+ Executing script query '/usr/bin/php -q /srv/www/htdocs/scripts/ss_host_disk.php hebron.salisbury.edu 217 1:161:500:!:~SNMPSTRING~:!:::MD5::DES: query index'
+ Executing script query '/usr/bin/php -q /srv/www/htdocs/scripts/ss_host_disk.php hebron.salisbury.edu 217 1:161:500:!:~SNMPSTRING~:!:::MD5::DES: query description'
+ Executing script query '/usr/bin/php -q /srv/www/htdocs/scripts/ss_host_disk.php hebron.salisbury.edu 217 1:161:500:!:~SNMPSTRING~:!:::MD5::DES: query sau'
+ Found data query XML file at '/srv/www/htdocs/resource/script_server/host_disk.xml'
+ Found data query XML file at '/srv/www/htdocs/resource/script_server/host_disk.xml'
+ Found data query XML file at '/srv/www/htdocs/resource/script_server/host_disk.xml'

Verbose Query results of "SNMP - Get Processor Information":

Code: Select all

+ Running data query [9].
+ Found type = '6 '[script query].
+ Found data query XML file at '/srv/www/htdocs/resource/script_server/host_cpu.xml'
+ XML file parsed ok.
+ Executing script for list of indexes '/usr/bin/php -q /srv/www/htdocs/scripts/ss_host_cpu.php hebron.salisbury.edu 217 1:161:500:!:~~SNMPSTRING~:~:!:::MD5::DES: index'
+ Executing script query '/usr/bin/php -q /srv/www/htdocs/scripts/ss_host_cpu.php hebron.salisbury.edu 217 1:161:500:!:~~SNMPSTRING~:~:!:::MD5::DES: query index'
+ Found data query XML file at '/srv/www/htdocs/resource/script_server/host_cpu.xml'
+ Found data query XML file at '/srv/www/htdocs/resource/script_server/host_cpu.xml'
+ Found data query XML file at '/srv/www/htdocs/resource/script_server/host_cpu.xml'

Each of those show status of Success [0 Items, 0 Rows]. Right after I upgraded they still had items and rows as before, but with the first reload or verbose query that goes to zero for both.

Other queries like "SNMP - Interface Statistics" are working fine. Does anyone have any ideas? Could be something simple I am missing. If you need any additional info. just let me know. We have been running cacti for 4 years with no issues.

[gandalf]

Edited some SNMPSTRINGS. They are really uncommon (that makes them good!). Does this behaviour show up for all devices? I want you to verify with simpler community strings.
Reinhard

[llhoweth]

That seems to do it. That's not our exact string but we do use some extended characters similar to what was in my post. We got dinged by auditors before for having strings too simple, guess we'll need to start changing them. Thanks for the quick solution!

[gandalf]

That seems to do it. That's not our exact string but we do use some extended characters similar to what was in my post. We got dinged by auditors before for having strings too simple, guess we'll need to start changing them. Thanks for the quick solution!

Oh, honestly this is NOT a solution.
Please file a bug as given by http://www.cacti.net/bugs.php adding the characters you've used in an arbitrary sequence for us to debug.
Reinhard

[llhoweth]

Thanks Reinhard! It has been submitted (0001196).

Lee