Problems with Cactus, failure in MySQL

[fsm109]

Good afternoon!
I think I'm having problems in my cacti, although make sure the bank Mysql is integrated without problems because I used the mysqlchek among other tools such as repair_database.php and telling everyone that the base is incorporated (100% OK). But the message of cacti.log and still not know how to fix.
I think I'm having problems in my cacti, although make sure the bank Mysql is integrated without problems because I used the mysqlchek from other tools such as repair_database.php and telling everyone that the base is incorporated (100% OK). But the message of cacti.log and still not know how to fix.
error message:
03/17/2009 04:09:24 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select poller_id,end_time from poller_time where poller_id = 0"
03/17/2009 04:09:24 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"
Please help me!

Att. fsm

[TheWitness]

Your database crashed. For every table that has that error. You need to run the following command:

Code: Select all

mysql cacti
repair table <table_name>;

If you were to be running 087c/d, there is a CLI script called "repair_database.php" that you would simply run.

TheWitness

[fsm109]

ran the script and see the result:

Repairing All Cacti Database Tables
Repairing Table -> 'cdef' Successful
Repairing Table -> 'cdef_items' Successful
Repairing Table -> 'colors' Successful
Repairing Table -> 'data_input' Successful
Repairing Table -> 'data_input_data' Successful
Repairing Table -> 'data_input_data_cache' Successful
Repairing Table -> 'data_input_data_fcache' Successful
Repairing Table -> 'data_input_fields' Successful
Repairing Table -> 'data_local' Successful
Repairing Table -> 'data_template' Successful
Repairing Table -> 'data_template_data' Successful
Repairing Table -> 'data_template_data_rra' Successful
Repairing Table -> 'data_template_rrd' Successful
Repairing Table -> 'graph_local' Successful
Repairing Table -> 'graph_template_input' Successful
Repairing Table -> 'graph_template_input_defs' Successful
Repairing Table -> 'graph_templates' Successful
Repairing Table -> 'graph_templates_gprint' Successful
Repairing Table -> 'graph_templates_graph' Successful
Repairing Table -> 'graph_templates_item' Successful
Repairing Table -> 'graph_tree' Successful
Repairing Table -> 'graph_tree_items' Successful
Repairing Table -> 'host' Successful
Repairing Table -> 'host_snmp_cache' Successful
Repairing Table -> 'host_snmp_query' Successful
Repairing Table -> 'host_template' Successful
Repairing Table -> 'host_template_data_sv' Successful
Repairing Table -> 'host_template_graph' Successful
Repairing Table -> 'host_template_graph_sv' Successful
Repairing Table -> 'host_template_snmp_query' Successful
Repairing Table -> 'rra' Successful
Repairing Table -> 'rra_cf' Successful
Repairing Table -> 'settings' Successful
Repairing Table -> 'settings_graphs' Successful
Repairing Table -> 'settings_tree' Successful
Repairing Table -> 'snmp_query' Successful
Repairing Table -> 'snmp_query_field' Successful
Repairing Table -> 'snmp_query_graph' Successful
Repairing Table -> 'snmp_query_graph_rrd' Successful
Repairing Table -> 'snmp_query_graph_rrd_sv' Successful
Repairing Table -> 'snmp_query_graph_sv' Successful
Repairing Table -> 'user_auth' Successful
Repairing Table -> 'user_auth_perms' Successful
Repairing Table -> 'user_auth_realm' Successful
Repairing Table -> 'user_log' Successful
Repairing Table -> 'user_realm' Successful
Repairing Table -> 'user_realm_filename' Successful
Repairing Table -> 'version' Successful

Shows no failure!

[TheWitness]

Did the problem go away? If not, use may have to use the "usefrm" option.

TheWitness

[TheWitness]

Oh crap, you are missing several tables. Do you see "poller_*"?

TheWitness

Something or someone "whacked" your system. Hope you have a backup.

[fsm109]

Good day friend! Thank you for your help, thanks to your information I discovered that the cacti.sql was used for the bank, was not correct for the version of cacti that I was using. The problem was resolved. Thanks