Cacti Log File - How to stop an Job: CMDPHP: Poller[0] ...

[mHaber95]

Hello

after trying to install the plugin "Dashboard", this error appears in Cacti Log File.

Code: Select all

09/04/2014 03:17:13 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"CREATE TABLE quicktree_graphs ( id int(11) NOT NULL auto_increment, userid int(11) NOT NULL, local_graph_id mediumint(8) unsigned NOT NULL default '0', rra_id smallint(8) unsigned NOT NULL default '0', title varchar(255) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM;'  
09/04/2014 03:17:11 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"CREATE TABLE quicktree_graphs ( id int(11) NOT NULL auto_increment, userid int(11) NOT NULL, local_graph_id mediumint(8) unsigned NOT NULL default '0', rra_id smallint(8) unsigned NOT NULL default '0', title varchar(255) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM;'  

I have disabled and then deleted the plugin but the error is listet always.

These are the Support Infos:

Code: Select all

General Information 
Date Thu, 04 Sep 2014 15:20:30 +0200 
Cacti Version 0.8.8b 
Cacti OS unix ubuntu 14.04 Server 32 bit
SNMP Version NET-SNMP version: 5.7.2  
RRDTool Version RRDTool 1.4.x  
Hosts 1 
Graphs 4 
Data Sources Script/Command: 5
Total: 5 
Poller Information 
Interval 300 
Type cmd.php 
Items Action[1]: 5
Total: 5 
Concurrent Processes 1 
Max Threads 1 
PHP Servers 1 
Script Timeout 25 
Max OID 10 
Last Run Statistics Time:0.5277 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:5 RRDsProcessed:5 
PHP Information 
PHP Version 5.5.9-1ubuntu4.3 
PHP OS Linux 
PHP uname Linux ProSelMONI01a 3.13.0-35-generic #62-Ubuntu SMP Fri Aug 15 01:58:01 UTC 2014 i686 
PHP SNMP Installed 
max_execution_time 30 
memory_limit 128M 

How do i kill the CMDPHP-Job?

Thanks for your Help
regards, Matthias

[cigamit]

Did you install
http://docs.cacti.net/userplugin:quicktree
as that plugin is what that table belongs to.

[mHaber95]

Quicktree ... yes after disable this plugin all looks good
Thank you very much

P.S. Info to me, open my eyes and drink more coffee

[mHaber95]

... After Change "TYPE=MyISAM" to "ENGINE=MyISAM" in Setup.php it seems to work