"SNMP - Get Mounted Partitions" fails after upgrad

[santisaez]

Dear Srs,

I have the same problem.. with "Data Query [SNMP - Get Mounted Partitions]" template, after upgrading:

I get:

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.

Running debug I get:

+ Running data query [8].
+ Found type = '6 '[script query].
+ Found data query XML file at '/var/www/cacti01/resource/script_server/host_disk.xml'
+ XML file parsed ok.
+ Executing script for list of indexes '/usr/bin/php -q /var/www/cacti01/scripts/ss_host_disk.php x.y.66.187 66 2:161pub:::MD5::DES: index'
+ Executing script query '/usr/bin/php -q /var/www/cacti01/scripts/ss_host_disk.php x.y.66.187 66 2:161pub:::MD5::DES: query index'
+ Executing script query '/usr/bin/php -q /var/www/cacti01/scripts/ss_host_disk.php x.y.66.187 66 2:161pub:::MD5::DES: query description'
+ Executing script query '/usr/bin/php -q /var/www/cacti01/scripts/ss_host_disk.php x.y.66.187 66 2:161pub:::MD5::DES: query sau'
+ Found data query XML file at '/var/www/cacti01/resource/script_server/host_disk.xml'
+ Found data query XML file at '/var/www/cacti01/resource/script_server/host_disk.xml'
+ Found data query XML file at '/var/www/cacti01/resource/script_server/host_disk.xml'
+ Found data query XML file at '/var/www/cacti01/resource/script_server/host_disk.xml'

Thanks!

[gandalf]

Split off. It's a new problem
Reinhard

[llhoweth]

Having the same problem with the 2 Data Queries using the Script Server. The 2 are: "SNMP - Get Mounted Partitions" and "SNMP - Get Processor Information"

Are there any workarounds? Been banging my head against the wall on this one.

Thanks-
Lee

[gandalf]

The issue is solved now.
The root cause is the use of the CAST operation with mysql. CAST is not supported. From mysql.com:

CAST() and CONVERT() are available as of MySQL 4.0.2.

A workaround is to revert a recent patch in graphs_new.php
Search for CAST to find

Code: Select all

$sql_order = "ORDER BY CAST(snmp_index AS unsigned)";

Replace by

Code: Select all

$sql_order = "ORDER BY snmp_index";

. Of course, this will bring problems when using large snmp indices.
Recommendation is to update mysql. Please be aware, that mysql 3.x is way old and not supported any more!

[santisaez]

gandalf,

I have changed SQL query into graphs_new.php file, and I get the same result. Running debug I get the same XML response.

Thanks for your work!!