cacti log error

Post support questions that directly relate to Linux/Unix operating systems.

Moderators: Developers, Moderators

Post Reply
zero13ro
Posts: 24
Joined: Tue Sep 28, 2010 12:06 pm

cacti log error

Post by zero13ro »

Hi,

i have cat the cacti log file and find this

09/30/2010 12:37:13 PM - SYSTEM STATS: Time:1.1374 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:0 RRDsProcessed:1
09/30/2010 12:37:23 PM - SYSTEM STATS: Time:1.1367 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:0 RRDsProcessed:0
09/30/2010 12:37:33 PM - SYSTEM STATS: Time:1.1323 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:0 RRDsProcessed:0
09/30/2010 12:37:43 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_templates_graph.local_graph_id from (graph_templates_graph,graph_local) left join host on (host.id=graph_local.host_id) left join graph_templates on (graph_templates.id=graph_local.graph_template_id) left join user_auth_perms on ((graph_templates_graph.local_graph_id=user_auth_perms.item_id and user_auth_perms.type=1 and user_auth_perms.user_id=1) OR (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=1) OR (graph_templates.id=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=1)) where graph_templates_graph.local_graph_id=graph_local.id and ((user_auth_perms.type != 1 OR user_auth_perms.type is null) AND ((user_auth_perms.type != 3) OR (user_auth_perms.type is null)) AND ((user_auth_perms.type != 4) OR (user_auth_perms.type is null))) and graph_templates_graph.local_graph_id= group by graph_templates_graph.local_graph_id"



I also want to add that cacti its working fine and graphics are added corectly.

Can someone help

Thanks
Nice
Posts: 30
Joined: Mon Sep 20, 2010 9:23 am
Location: Lede, Belgium

Re: cacti log error

Post by Nice »

I have exactly the same error.

Anyone has a solution?

I checked "System utilities" --> techical support and there are no errors
User avatar
Howie
Cacti Guru User
Posts: 5508
Joined: Thu Sep 16, 2004 5:53 am
Location: United Kingdom
Contact:

Re: cacti log error

Post by Howie »

Mysql Error 1064 is a SQL syntax error.

That SQL statement is checking permissions for a graph, but the very end has no graph_id.

What were you trying to do when the error appeared?
Weathermap 0.98a is out! & QuickTree 1.0. Superlinks is over there now (and built-in to Cacti 1.x).
Some Other Cacti tweaks, including strip-graphs, icons and snmp/netflow stuff.
(Let me know if you have UK DevOps or Network Ops opportunities, too!)
Nice
Posts: 30
Joined: Mon Sep 20, 2010 9:23 am
Location: Lede, Belgium

Re: cacti log error

Post by Nice »

I upgraded from PA2.6 to PA2.8
Nice
Posts: 30
Joined: Mon Sep 20, 2010 9:23 am
Location: Lede, Belgium

Re: cacti log error

Post by Nice »

I found the problem.
It was a problem with the Graph List View Searching patch .
I replaced the old graph_view.php file an now it works
Nice
Posts: 30
Joined: Mon Sep 20, 2010 9:23 am
Location: Lede, Belgium

Re: cacti log error

Post by Nice »

Unfortunately the problem isn't fixed.
Again I have following errors.
I always get it when I open a page with the graphs tab.

Code: Select all

10/11/2010 02:20:45 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_templates_graph.local_graph_id from (graph_templates_graph,graph_local) left join host on (host.id=graph_local.host_id) left join graph_templates on (graph_templates.id=graph_local.graph_template_id) left join user_auth_perms on ((graph_templates_graph.local_graph_id=user_auth_perms.item_id and user_auth_perms.type=1 and user_auth_perms.user_id=4) OR (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=4) OR (graph_templates.id=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=4)) where graph_templates_graph.local_graph_id=graph_local.id and ((user_auth_perms.type != 1 OR user_auth_perms.type is null) AND ((user_auth_perms.type != 3) OR (user_auth_perms.type is null)) AND ((user_auth_perms.type != 4) OR (user_auth_perms.type is null))) and graph_templates_graph.local_graph_id= group by graph_templates_graph.local_graph_id"
Any idea what is wrong?
Nice
Posts: 30
Joined: Mon Sep 20, 2010 9:23 am
Location: Lede, Belgium

Re: cacti log error

Post by Nice »

Anybody who can help me?

I reinstalled my whole cacti environment and I still get the error...

Cacti 0.8.7g
PIA 2.9b
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Re: cacti log error

Post by gandalf »

What exactly where you trying to view when this error occurs?
You may want to open a bug report for this
R.
Nice
Posts: 30
Joined: Mon Sep 20, 2010 9:23 am
Location: Lede, Belgium

Re: cacti log error

Post by Nice »

I get this error when I want to view a graph.

Everything is workin fine but I always get the error in the logs.

I already reintstalled my cacti system en it is still the samen.
Nice
Posts: 30
Joined: Mon Sep 20, 2010 9:23 am
Location: Lede, Belgium

Re: cacti log error

Post by Nice »

I can specify the problem.

I get the error when I visit a graph.php page by clicking on a graph in tree mode to see the details.

I'm searching right now for the sql code that i found in the error.

Anybody who can help?
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Re: cacti log error

Post by gandalf »

The error is a result of

Code: Select all

...graph_templates_graph.local_graph_id= group...
The local_graph_id is missing. But it is unclear, how this might happen.
R.
Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests