[Bug 914746] [NEW] cacti SNMP verbose query PHP error

[Launchpad Bug Tracker]

You have been subscribed to a public bug by Paul Gevers (paul-climbing):

[IMPACT]
 * If you try to turn on "SNMP - Interface Statistics" on a host with SNMP facilities turned off, the current behavior of cacti is that it generates a php error instead of catching the empty result. As this behavior is basically strange user behavior, the impact is small, although multiple people report the issue. I don't think this warrants an SRU, but still my patch fixes the issue by testing for empty results (as is intended by the code) and thus allowing the php code to return normally (although still not telling you what went wrong).

[TESTCASE]

 * With cacti installed and configured, go to the /cacti/host.php page (via the "devices" link on every cacti page) and select a device (e.g. localhost)
 * Make sure that in the SNMP Options section the SNMP Version is set to "Not In Use"
 * In the "Associated Data Queries" part, select "SNMP - Interface Statistics" in the "Add data query" drop down selection box and press "Add".
 * The next screen is blank.
 * In the apache error.log you will find:
   PHP Fatal error:  Cannot use string offset as an array in /usr/share/cacti/site/lib/data_query.php on line 183, referer: http://localhost/cacti/host.php?action=edit&id=1
 * After the patch the result will be return to the host.php file, but it will show the added "SNMP - Interface Statistics" with "Success [0 Items, 0 Rows]"

[Regression Potential]

 * I don't know how adding a check for emptyness of a variable that
should not be empty can cause regression. Maybe somebody else can come
up with one?

[Other Info]

  * As mentioned before, I am not sure this issue warrants a SRU.
  * Only lucid (-updates) is effected by this bug, other Ubuntu releases don't experience it.

[original report]
when adding an SNMP - Interface statistics data query, and clicking on the 'verbose list' link, I get a 500 internal error, and the following line in the apache log file:

PHP Fatal error:  Cannot use string offset as an array in
/usr/share/cacti/site/lib/data_query.php on line 183, referer:
http://localhost/cacti/host.php?action=edit&id=1

this prevents me from having network interface statistics followed by
cacti.

additional info:

# lsb_release -rd
Description:	Ubuntu 10.04.3 LTS
Release:	10.04

# apt-cache policy cacti
cacti:
  Installed: 0.8.7e-2ubuntu0.2
  Candidate: 0.8.7e-2ubuntu0.2
  Version table:
 *** 0.8.7e-2ubuntu0.2 0
        500 http://mirror.us.leaseweb.net/ubuntu/ lucid-updates/universe Packages
        500 http://security.ubuntu.com/ubuntu/ lucid-security/universe Packages
        100 /var/lib/dpkg/status
     0.8.7e-2 0
        500 http://mirror.us.leaseweb.net/ubuntu/ lucid/universe Packages

# apt-cache policy php5
php5:
  Installed: 5.3.2-1ubuntu4.11
  Candidate: 5.3.2-1ubuntu4.11
  Version table:
 *** 5.3.2-1ubuntu4.11 0
        500 http://mirror.us.leaseweb.net/ubuntu/ lucid-updates/main Packages
        500 http://security.ubuntu.com/ubuntu/ lucid-security/main Packages
        100 /var/lib/dpkg/status
     5.3.2-1ubuntu4 0
        500 http://mirror.us.leaseweb.net/ubuntu/ lucid/main Packages

** Affects: cacti
     Importance: Undecided
         Status: New

** Affects: cacti (Ubuntu)
     Importance: Undecided
         Status: Fix Released

** Affects: cacti (Ubuntu Lucid)
     Importance: Undecided
         Status: In Progress

** Affects: cacti (Ubuntu Natty)
     Importance: Undecided
         Status: Invalid

** Affects: cacti (Ubuntu Oneiric)
     Importance: Undecided
         Status: Invalid

** Affects: cacti (Debian)
     Importance: Unknown
         Status: Fix Released


** Tags: regression-update
-- 
cacti SNMP verbose query PHP error
https://bugs.launchpad.net/bugs/914746
You received this bug notification because you are a member of Ubuntu Sponsors Team, which is subscribed to the bug report.