Data query "ucd 10 fs" stopped working

[jwilda]

This issue is affecting both Linux and Windows devices.

I have an issue where data query "ucd 10 fs" was working and for the devices/hosts that it was working on it continues to work unless I run the "Verbose Query" under "Associated Data Queries". However for new devices it doesn't work and if I run the "Verbose Query" on old devices it stops working. I'm looking at http://forums.cacti.net/post-108237.html and like them it looks like the only thing that has changed is that I've installed the plugin architecture.

Here are the results of running the "Verbose Query":

Data Query Debug Information:

Code: Select all

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

Now if I run those same scripts from the command line I get:

Code: Select all

$ /usr/bin/php -q /var/www/cacti/scripts/ss_host_disk.php machine1 6 2:161:500:public:::MD5::DES: index
PHP Notice:  Undefined index:  sess_user_id in /var/www/cact/lib/functions.php on line 1472 
PHP Notice:  Undefined index:  sess_user_id in /var/www/cact/lib/functions.php on line 1485 
PHP Notice:  Undefined variable: sql_where in /var/www/cacti/lib/functions.php on line 1487
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

Code: Select all

$ /usr/bin/php -q /var/www/cacti/scripts/ss_host_disk.php machine1 6 2:161:500:public:::MD5::DES: query index 
PHP Notice:  Undefined index:  sess_user_id in /var/www/cact/lib/functions.php on line 1472 
PHP Notice:  Undefined index:  sess_user_id in /var/www/cact/lib/functions.php on line 1485 
PHP Notice:  Undefined variable: sql_where in /var/www/cact/lib/functions.php on line 1487
1!1
2!2
3!3
4!4
5!5
6!6
7!7
8!8
9!9
10!10
11!11
12!12
13!13
14!14
15!15
16!16
17!17
18!18

Code: Select all

$ /usr/bin/php -q /var/www/cacti/scripts/ss_host_disk.php machine1 6 2:161:500:public:::MD5::DES: query description 
PHP Notice:  Undefined index:  sess_user_id in /var/www/cact/lib/functions.php on line 1472 
PHP Notice:  Undefined index:  sess_user_id in /var/www/cact/lib/functions.php on line 1485 
PHP Notice:  Undefined variable: sql_where in /var/www/cact/lib/functions.php on line 1487 
1!Memory Buffers 
2!Real Memory 
3!Swap Space 
4!/ 
5!/sys 
6!/proc/bus/usb 
7!/applogs 
8!/boot 
9!/home 
10!/opt 
11!/sw 
12!/tmp 
13!/usr 
14!/usr/local 
15!/var 
16!/proc/sys/fs/binfmt_misc 
17!/var/lib/nfs/rpc_pipefs 
18!/proc/fs/nfsd 

Code: Select all

$ /usr/bin/php -q /var/www/cacti/scripts/ss_host_disk.php machine1 6 2:161:500:public:::MD5::DES: query sau
PHP Notice:  Undefined index:  sess_user_id in /var/www/cact/lib/functions.php on line 1472 
PHP Notice:  Undefined index:  sess_user_id in /var/www/cact/lib/functions.php on line 1485 
PHP Notice:  Undefined variable: sql_where in /var/www/cact/lib/functions.php on line 1487
1!1024 Bytes
2!1024 Bytes
3!1024 Bytes
4!4096 Bytes
5!4096 Bytes
6!4096 Bytes
7!4096 Bytes
8!1024 Bytes
9!4096 Bytes
10!4096 Bytes
11!4096 Bytes
12!4096 Bytes
13!4096 Bytes
14!4096 Bytes
15!4096 Bytes
16!4096 Bytes
17!4096 Bytes
18!4096 Bytes

When I go to one of the graphs that was working but is now not showing anything (do to running the "verbose query") and run it in Debug mode here is the output.

Code: Select all

RRDTool Command:
/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="machine1 - Used Space - /" \
--rigid \
--base=1024 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bytes" \
--slope-mode \
--font TITLE:12: \
--font AXIS:8: \
--font LEGEND:9: \
--font UNIT:8: \
DEF:a="/var/www/cacti/rra/machine1_hdd_used_130.rrd":hdd_total:AVERAGE \ DEF:b="/var/www/cacti/rra/machine1_hdd_used_130.rrd":hdd_total:LAST \ DEF:c="/var/www/cacti/rra/machine1_hdd_used_130.rrd":hdd_total:MIN \ DEF:d="/var/www/cacti/rra/machine1_hdd_used_130.rrd":hdd_total:MAX \ DEF:e="/var/www/cacti/rra/machine1_hdd_used_130.rrd":hdd_used:AVERAGE \ DEF:f="/var/www/cacti/rra/machine1_hdd_used_130.rrd":hdd_used:LAST \ DEF:g="/var/www/cacti/rra/machine1_hdd_used_130.rrd":hdd_used:MIN \ DEF:h="/var/www/cacti/rra/machine1_hdd_used_130.rrd":hdd_used:MAX \ AREA:a#002A97FF:"Total"  \ GPRINT:b:LAST:"Current\:%8.2lf %s"  \ GPRINT:a:AVERAGE:"Average\:%8.2lf %s"  \ GPRINT:d:MAX:"Maximum\:%8.2lf %s\n"  \ AREA:e#F51D30FF:"Used"  \ GPRINT:f:LAST:" Current\:%8.2lf %s"  \ GPRINT:e:AVERAGE:"Average\:%8.2lf %s"  \ GPRINT:h:MAX:"Maximum\:%8.2lf %s\n" 

RRDTool Says:

OK

Cacti Version - 0.8.7b
Plugin Architecture - 2.1
Poller Type - Cactid v
Server Info - Linux 2.6.9-67.ELsmp
Web Server - Apache
PHP - 5.2.0
PHP Extensions - libxml, xml, wddx, tokenizer, sysvshm, sysvsem, sysvmsg, session, SimpleXML, sockets, SPL, shmop, standard, Reflection, pspell, posix, mime_magic, iconv, hash, gmp, gettext, ftp, filter, exif, date, curl, ctype, calendar, bz2, zlib, pcre, openssl, apache2handler, bcmath, dba, dom, gd, imap, mbstring, mysql, mysqli, ncurses, odbc, PDO, pdo_mysql, PDO_ODBC, pdo_pgsql, pdo_sqlite, pgsql, snmp, soap, xmlreader, xmlrpc, xmlwriter, xsl
MySQL - 4.1.20
RRDTool - 1.2.23
SNMP - 5.1.2
Plugins

• Create Aggregate Graphs (aggregate - v0.66)
  Network Tools (tools - v0.3)
  Global Plugin Settings (settings - v0.5)
  Device Monitoring (monitor - v0.8.2)
  Thresholds (thold - v0.3.9)
  Host Info (hostinfo - v0.2)
  uptime
  Login Page Mod (loginmod - v1.0)
  Documents (docs - v0.1)

Any and all help is greatly appreciated.

[eternal]

I just started to receive the same error.

I Think mine was from a template. Removed it, fixed

[jwilda]

which template did you remove to fix it?

[jwilda]

I found that the solution was to change the permissions on the ss_host_disk.php script. The permissions were 700 and changing them to 755 fixed the issue.