poller_item not updated/data source/rrd not created

[jimv]

I have spent two days on trying to figure out why my script server data query isn't working properly and I have come to the end.

I have a custom SS based data query. When I 'Add Data Query' to a host's 'Associated Data Queries' the index/query methods work fine (see img1). I've tested the 'get' methods too (from the command line) and they too work fine.

However, when I actually click the 'create' button from the same page where I would have marked rows for graphing (again, as in img1) the web page refreshes telling me it has created the graphs - but it hasn't. The graph(s) never appear (and the RRD files are not created either).

The poller (cmd.php) is running because the other (as in cacti defaults) graphs continue to be updated. The poller_item SQL table doesn't contain my new SS data query graphs whereas the other, already existing ones are present.

I have tried every permutation of re-creating these data/graph templates and data queries. Even new installs of cacti/clean database etc.

The suggested values are not expanded/substituted either - but thats another story!? I'm guessing this is really because these graphs are never added properly.

Img2 shows the data query setup.
Xml1 gives the SS XML template for the data query.

I have been over this again and again and cannot figure out why this data query works up until I click 'create'. What is meant to happen (as in PHP and SQL code) after I click this button? How is the RRD finally created - because it's not!

Any help appreciated.

Jim

[Sammy]

what cronjob do you have for the poller?

Try running it as root:

*/5 * * * * php /home/www/public_html/cacti/poller.php > /dev/null 2>&1

[jimv]

Nope that wasn't it. I've fixed the problem - was to do with indexing. Anyway, now I have a problem where occasionally all I get from the SS output is 'output: U'. And, when all seems to be working well according to the logfile:

get iowait 27525866990, output: 469567
get sys 27525866990, output: 439549
get user 27525866990, output: 1615580
get nice 27525866990, output: 249
get idle 27525866990, output: 74337170
get iowait 27525866991, output: 569279
get sys 27525866991, output: 469885
get user 27525866991, output: 1451606
get nice 27525866991, output: 540
get idle 27525866991, output: 74416203

The graph only plots the 'idle' output. Everything else, even though valid as seen here in the log file, is apparently 'nan'. Well, it looks like a damn number to me

Any other help?

Ta,

Jim

[gandalf]

Please select the graph from Graph Management. Enable DEBUG and post the whole rrdtool graph statement
Reinhard

[jimv]

K,

<see attached txt file>

It's not that that concerns me... it's these messages:

09/01/2006 11:45:02 AM - CMDPHP: Poller[0] Host[1] DS[55] WARNING: Result from SERVER not valid. Partial Result:
09/01/2006 11:45:02 AM - CMDPHP: Poller[0] Host[1] DS[55] SERVER: /var/www/cacti-0.8.6h/scripts/hostdb/ss_hdbms.php ss_hdbms localhost.localdomain hostdb H05td35Q1 hostdb get swap_total 2133171597, output: U

Whats this output: U stuff? All the others worked fine (well, this is random so sometimes this one works and others don't or all work or none... you get the idea). Works every time from the script_server.php cmd line.

Cactid isn't working for me (on a x86_64 Linux box) so I use cmd.php at the moment. The settings for ss/process etc, is as follows:

Maximum Concurrent Poller Processes: 1

Maximum Threads per Process: 1

Number of PHP Script Servers: 1

Script and Script Server Timeout Value: 25

The Maximum SNMP OID's Per SNMP Get Request: 10

I am not using SNMP at all here and only monitoring one host at the moment (therefore, above, no greater no. than 1 really).

This 'output: U' thing really is a show stopper as I am only on two hosts at the moment - with about 1000 to go! How does the script server work?

Regards,

Jim

[jimv]

Ah ha! I believe I've got it! Amazing, that PHP memory_limit variable really helps

It was set to 16M which, to be honest I would have thought would be enough for just the one host

Anyway, changed it to 64M and no more output: U's

Jim