System Utilities says wrong RRDTool and Graphs dont show up

[jmaris]

hi
I have done a complete reinstall without success.
I have done this in a clean VMware player build of Windows XP Professional XP SP3 with all updates installed.
Still, no RRD files created.
I guess I'll return to the Linux version.
cheers, Jan.

[etegration]

I am getting closer.
I was able to use the User Management area to give myself permissions for the graphs.
But now in graph debug mode I only see Graph Access Denied. I have given rights to IIS User in the rrdtool directory and within the rra directory inside of the cacti directory.

I also checked the log file and am seeing an abundance of sql errors?

01/11/2012 03:48:36 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1064', SQL:"select local_graph_id from graph_templates_graph where local_graph_id="
01/11/2012 03:48:36 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.local_graph_id, graph_templates_graph.title from (graph_templates_graph,graph_local) where graph_templates_graph.local_graph_id=graph_local.id and graph_local.id="
01/11/2012 03:48:36 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.local_graph_id, graph_templates_graph.title from (graph_templates_graph,graph_local) where graph_templates_graph.local_graph_id=graph_local.id and graph_local.id="
01/11/2012 03:48:36 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.local_graph_id, graph_templates_graph.title from (graph_templates_graph,graph_local) where graph_templates_graph.local_graph_id=graph_local.id and graph_local.id="
01/11/2012 03:48:36 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.local_graph_id, graph_templates_graph.title from (graph_templates_graph,graph_local) where graph_templates_graph.local_graph_id=graph_local.id and graph_local.id="

I ran: php repair_database.php inside of c:\inetpub\wwwroot\cacti\cli directory and it reports that their are no errors in the records.


Can anyone tell me where to look or how to fix this please ?

I have the same running Linux and suddenly had this....there dont seem to be any solution other than starting over?


#tail /var/log/cacti/cacti.log
09/07/2012 05:28:24 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.title from (graph_templates_graph,graph_local) where graph_templates_graph.local_graph_id=graph_local.id and graph_local.id="
09/07/2012 05:28:24 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.title from (graph_templates_graph,graph_local) where graph_templates_graph.local_graph_id=graph_local.id and graph_local.id="
09/07/2012 05:28:24 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1064', SQL:"select local_graph_id from graph_templates_graph where local_graph_id="
09/07/2012 05:30:02 PM - SYSTEM STATS: Time:0.2240 Method:cmd.php Processes:1 Threads:N/A Hosts:17 HostsPerProcess:17 DataSources:0 RRDsProcessed:0
09/07/2012 05:33:25 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.title from (graph_templates_graph,graph_local) where graph_templates_graph.local_graph_id=graph_local.id and graph_local.id="
09/07/2012 05:33:25 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.title from (graph_templates_graph,graph_local) where graph_templates_graph.local_graph_id=graph_local.id and graph_local.id="
09/07/2012 05:33:25 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.title from (graph_templates_graph,graph_local) where graph_templates_graph.local_graph_id=graph_local.id and graph_local.id="
09/07/2012 05:33:25 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.title from (graph_templates_graph,graph_local) where graph_templates_graph.local_graph_id=graph_local.id and graph_local.id="
09/07/2012 05:33:25 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1064', SQL:"select local_graph_id from graph_templates_graph where local_graph_id="
09/07/2012 05:35:01 PM - SYSTEM STATS: Time:0.2023 Method:cmd.php Processes:1 Threads:N/A Hosts:17 HostsPerProcess:17 DataSources:0 RRDsProcessed:0

[BSOD2600]

MySQL error 1064 is a syntax error (google ftw).

what version of cacti?
the technical support page show any issues?

[etegration]

MySQL error 1064 is a syntax error (google ftw).

what version of cacti?
the technical support page show any issues?

google ftw brought me here and many other results all with people giving up and reinstalling or threads just ending with no resolution. Google FTW but support for cacti, not so much?