cacti wmi plugins ERROR

[erteck]

im am new user in cacti version 0.8.8a my WMI error is this
i dont know how to fixed it

someone help me

01/07/2013 04:41:40 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(*) FROM plugin_wmi_accounts"
01/07/2013 04:41:40 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM plugin_wmi_accounts limit 0, 30"
01/07/2013 04:41:38 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(*) FROM plugin_wmi_queries"
01/07/2013 04:41:38 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM plugin_wmi_queries limit 0, 30"
01/07/2013 04:41:36 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(*) FROM plugin_wmi_accounts"
01/07/2013 04:41:36 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM plugin_wmi_accounts limit 0, 30"
01/07/2013 04:41:36 PM - CMDPHP: Poller[0] ERROR: SQL Save Command Failed for Table 'plugin_wmi_accounts'. Error was 'Table 'cacti.plugin_wmi_accounts' doesn't exist'
01/07/2013 04:41:22 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(*) FROM plugin_wmi_accounts"
01/07/2013 04:41:22 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM plugin_wmi_accounts limit 0, 30"
01/07/2013 04:41:21 PM - CMDPHP: Poller[0] ERROR: SQL Save Command Failed for Table 'plugin_wmi_accounts'. Error was 'Table 'cacti.plugin_wmi_accounts' doesn't exist'
01/07/2013 04:41:15 PM - CMDPHP: Poller[0] ERROR: SQL Save Command Failed for Table 'plugin_wmi_accounts'. Error was 'Table 'cacti.plugin_wmi_accounts' doesn't exist'
01/07/2013 04:41:07 PM - CMDPHP: Poller[0] ERROR: SQL Save Command Failed for Table 'plugin_wmi_accounts'. Error was 'Table 'cacti.plugin_wmi_accounts' doesn't exist'
01/07/2013 04:40:53 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(*) FROM plugin_wmi_accounts"
01/07/2013 04:40:53 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM plugin_wmi_accounts limit 0, 30"
01/07/2013 04:40:53 PM - CMDPHP: Poller[0] ERROR: SQL Save Command Failed for Table 'plugin_wmi_accounts'. Error was 'Table 'cacti.plugin_wmi_accounts' doesn't exist'
01/07/2013 04:40:37 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(*) FROM plugin_wmi_accounts"
01/07/2013 04:40:37 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM plugin_wmi_accounts limit 0, 30"

i have this error!!!!

how can i fixed this one,,
pls,,pls help me



if there someone have try to run the WMI in cacti?????
plsssssss help

[webroxy]

You have to import in mysql wmi.sql.

Download from http://forums.cacti.net/viewtopic.php?f=19&t=29392
file http://mirror.cactiusers.org/wmi.zip

Then extract in plugin dir. You'll see a file wmi.sql. Read file README...
import in mysql:

mysql -u username -p cacti < wmi.sql

After that install plugin as usual.

[webroxy]

As saied on this page, http://forums.cacti.net/viewtopic.php?t=29392
there is another change to cacti db table host:

ALTER TABLE `host` ADD `wmi_account` INT( 12 ) NOT NULL ;

Bye