Re: [cacti-user] Cacti SQL error

[Patrick T. <pat...@hy...>]

Larry,

Thanks for your help on this.  Attached is the file with the output from
the snmpwalk you requested.  Thanks.

-Patrick

On Wed, 2006-04-26 at 22:40 +0000, lar...@co... wrote:

> Patrick,
> 
> Could ypu please run the following command:
> 
> snmpwalk -c <your_community> -v 2c <your_host> > gsr_snmp.out
> 
> Send that file to me.  You might want to limit it only to the ifInterfaces though.
> 
> Thanks,
> 
> Larry
> 
>  -------------- Original message ----------------------
> From: Patrick Topping <pat...@hy...>
> > I have just installed cacti for the first time.  I have added in a GSR
> > 12410 and 6513, both have 10 gig Ethernet interfaces.  I am getting the
> > following error in the logs:
> > 
> > 04/26/2006 03:47:59 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed
> > "update data_template_data set rrd_maximum='|query_ifSpeed|' where
> > local_data_id=13"
> > 04/26/2006 03:47:59 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed
> > "update data_template_data set rrd_maximum='|query_ifSpeed|' where
> > local_data_id=14"
> > 04/26/2006 03:47:59 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed
> > "update data_template_data set rrd_maximum='|query_ifSpeed|' where
> > local_data_id=15"
> > 04/26/2006 03:47:59 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed
> > "update data_template_data set rrd_maximum='|query_ifSpeed|' where
> > local_data_id=16"
> > 04/26/2006 03:47:59 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed
> > "update data_template_data set rrd_maximum='|query_ifSpeed|' where
> > local_data_id=17"
> > 04/26/2006 03:47:59 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed
> > "update data_template_data set rrd_maximum='|query_ifSpeed|' where
> > local_data_id=18"
> > 04/26/2006 03:47:59 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed
> > "update data_template_data set rrd_maximum='|query_ifSpeed|' where
> > local_data_id=19"
> > 04/26/2006 03:47:59 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed
> > "update data_template_data set rrd_maximum='|query_ifSpeed|' where
> > local_data_id=20"
> > 04/26/2006 03:47:59 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed
> > "update data_template_data set rrd_maximum='|query_ifSpeed|' where
> > local_data_id=21"
> > 
> > I have checked the DB table data_template_data for this field and I am
> > not seeing it.  Is this a required field?  Thanks in advance for all the
> > help.
> > 
> > -Patrick
> > 
> > 
> > 
> > 
> 
> 
> 
> 
> email message attachment
> On Wed, 2006-04-26 at 22:40 +0000, lar...@co... wrote:
> 
> > I have just installed cacti for the first time.  I have added in a
> > GSR 12410 and 6513, both have 10 gig Ethernet interfaces.  I am
> > getting the following error in the logs:
> > 
> > 04/26/2006 03:47:59 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed
> > "update data_template_data set rrd_maximum='|query_ifSpeed|' where
> > local_data_id=13"
> > 04/26/2006 03:47:59 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed
> > "update data_template_data set rrd_maximum='|query_ifSpeed|' where
> > local_data_id=14"
> > 04/26/2006 03:47:59 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed
> > "update data_template_data set rrd_maximum='|query_ifSpeed|' where
> > local_data_id=15"
> > 04/26/2006 03:47:59 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed
> > "update data_template_data set rrd_maximum='|query_ifSpeed|' where
> > local_data_id=16"
> > 04/26/2006 03:47:59 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed
> > "update data_template_data set rrd_maximum='|query_ifSpeed|' where
> > local_data_id=17"
> > 04/26/2006 03:47:59 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed
> > "update data_template_data set rrd_maximum='|query_ifSpeed|' where
> > local_data_id=18"
> > 04/26/2006 03:47:59 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed
> > "update data_template_data set rrd_maximum='|query_ifSpeed|' where
> > local_data_id=19"
> > 04/26/2006 03:47:59 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed
> > "update data_template_data set rrd_maximum='|query_ifSpeed|' where
> > local_data_id=20"
> > 04/26/2006 03:47:59 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed
> > "update data_template_data set rrd_maximum='|query_ifSpeed|' where
> > local_data_id=21"
> > 
> > I have checked the DB table data_template_data for this field and I
> > am not seeing it.  Is this a required field?  Thanks in advance for
> > all the help.
> > 
> > -Patrick
> > 
> > 
> >