No Graphs on Cacti 0.8.7g with Windows Server 2008 R2

[richardjgreen]

Hi all,

Installed Cacti last night, and after reading some of the threads regarding NTFS permissions issues, I still can't get my graphs to work.
I ran the graph in Debug mode, and the message returned by RRDTool is GRAPH ACCESS DENIED.

Installation is Windows Server 2008 R2 using PHP 5.2.17 with the FastCGI IIS Feature and MySQL 5.5.15 (64-bit Version). I am running Spine 0.8.7g and RRDTool 1.2.30.

Process Monitor shows no access denied errors trying to execute the polling.php script, however when I enable polling Debug mode, I see the following MySQL query executing almost as if it's in a loop and then the polling process times out at this step:

08/28/2011 11:25:00 AM - POLLER: Poller[0] WARNING: Scheduled Task is out of sync with the Poller Interval! The Poller Interval is '300' seconds, with a maximum of a '300' second Scheduled Task, but 600 seconds have passed since the last poll!

08/28/2011 11:19:58 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"

08/28/2011 11:19:58 AM - CMDPHP: Poller[0] DEVEL: SQL Cell: "SELECT count(*) FROM poller_time WHERE poller_id=0 AND end_time>'0000-00-00 00:00:00'"

08/28/2011 11:19:57 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"

Hopefully I've just done something wrong in the configuration and it's a quick fix

[richardjgreen]

Since posting this, I've been playing around.
I changed my poller type from Spine to cmd.php and I'm no longer getting the errors with the MySQL statement and it looks like polling is completing, however still no graphs

[BSOD2600]

the scheduled task is running poller.php, right? Only once every 5 minutes? I'd suggest you stick with cmd.php instead of spine until things are running properly.

Got all the cacti patches installed?

[richardjgreen]

I feel like such a noob.
Turns out that the account that I was using to login to Cacti hadn't been given rights to view graphs! I updated the permissions for the account by logging in as admin and the graphs work now.

While I'm being a noob then, with the poller working properly as cmd.php now and the graphs displaying properly, what is the benifit or running Spine over cmd.php? I'm only polling four devices so it's not exactly SNMP-intensive.

[BSOD2600]

what is the benifit or running Spine over cmd.php? I'm only polling four devices so it's not exactly SNMP-intensive.

Spine is much faster for large installations where your polling is pure snmp.