Cacti (home)ForumsRepositoryDocumentation
Cacti: offical forums and support  

 FAQFAQ   SearchSearch   MemberlistMemberlist    RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in    


Data query "ucd 10 fs" stopped working

 
Post new topic   Reply to topic    Cacti Forum Index -> Help: General
Author Message
jwilda



Joined: 22 Oct 2008
Posts: 7
Location: Tampa, FL
PostPosted: Fri Nov 14, 2008 10:04 am    Post subject: Data query "ucd 10 fs" stopped working Reply with quote
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:
+ 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:
$ /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:
$ /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:
$ /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:
$ /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:
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


Quote:
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.
Back to top
eternal
Cacti User


Joined: 14 Dec 2006
Posts: 57
Location: Kingsport TN
PostPosted: Fri Nov 14, 2008 1:14 pm    Post subject: Reply with quote
I just started to receive the same error.

I Think mine was from a template. Removed it, fixed
Back to top
jwilda



Joined: 22 Oct 2008
Posts: 7
Location: Tampa, FL
PostPosted: Mon Nov 17, 2008 1:40 pm    Post subject: Reply with quote
which template did you remove to fix it?
Back to top
jwilda



Joined: 22 Oct 2008
Posts: 7
Location: Tampa, FL
PostPosted: Mon Nov 17, 2008 2:43 pm    Post subject: FIXED Reply with quote
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.
Back to top
Display posts from previous:   
Post new topic   Reply to topic    Cacti Forum Index -> Help: General All times are GMT - 5 Hours
Page 1 of 1

 



Powered by phpBB © 2001, 2005 phpBB Group