change server cacti IP , no graphs generated anymore

[DonAmos]

Hi guys

I am the newest fun of cacti , i have installed it some times ago successfully and i was able to monitor some of my Cisco Switch devices.

For security reason i was forced to change the IP addresses of all my network drives and i was forced to change the ip of cacti server also. I changed them but now i am not able to generate graphs anymore

On log i have these errors :

cacti version : Version 0.8.8f

10/05/2017 10:25:27 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=195"
10/05/2017 10:25:27 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=195"
10/05/2017 10:25:27 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=195"
10/05/2017 10:25:27 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=195"
10/05/2017 10:25:27 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=195"
10/05/2017 10:25:27 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=195"
10/05/2017 10:25:27 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=200"
10/05/2017 10:25:27 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=200"
10/05/2017 10:25:27 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=200"
10/05/2017 10:25:27 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=200"
10/05/2017 10:25:27 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=200"
10/05/2017 10:25:27 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=200"
10/05/2017 10:25:27 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=197"
10/05/2017 10:25:27 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=197"
10/05/2017 10:25:27 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=197"
10/05/2017 10:25:27 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=197"
10/05/2017 10:25:27 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=197"
10/05/2017 10:25:27 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=197"
10/05/2017 10:25:26 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=195"
10/05/2017 10:25:26 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=195"
10/05/2017 10:25:26 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=198"
10/05/2017 10:25:26 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=198"
10/05/2017 10:25:26 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=198"
10/05/2017 10:25:26 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=198"
10/05/2017 10:25:26 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=198"
10/05/2017 10:25:26 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=198"
10/05/2017 10:25:26 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=200"
10/05/2017 10:25:26 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=200"
10/05/2017 10:25:26 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=197"
10/05/2017 10:25:26 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=197"
10/05/2017 10:25:26 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=198"
10/05/2017 10:25:26 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=198"
10/05/2017 10:25:26 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=195"
10/05/2017 10:25:26 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=195"
10/05/2017 10:25:26 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=200"
10/05/2017 10:25:26 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=195"
10/05/2017 10:25:26 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=200"
10/05/2017 10:25:26 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=197"
10/05/2017 10:25:26 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=195"
10/05/2017 10:25:26 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=200"
10/05/2017 10:25:26 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=197"
10/05/2017 10:25:26 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=195"
10/05/2017 10:25:26 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=200"
10/05/2017 10:25:26 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'145', SQL:"select name,data_source_path from data_template_data where local_data_id=197"
10/05/2017 10:25:26 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', SQL:"select rra.id, rra.steps, rra.rows, rra.name, rra.timespan, data_template_data.rrd_step from graph_templates_item LEFT JOIN data_template_rrd ON (graph_templates_item.task_item_id=data_template_rrd.id) LEFT JOIN data_template_data ON (data_template_rrd.local_data_id=data_template_data.local_data_id) LEFT JOIN data_template_data_rra ON (data_template_data.id=data_template_data_rra.data_template_data_id) LEFT JOIN rra ON (data_template_data_rra.rra_id=rra.id) where graph_templates_item.local_graph_id=192 AND data_template_rrd.local_data_id != 0 group by rra.id order by rra.timespan"

i am not able to see the old generated graphs anymore ( with old IP address of server )

Please can you help me , is any possibility to see old graphs and new ones ?
I dont want to loose the old graphs.

Please see attached file

br
Amos

[DonAmos]

UPDATE !!!

i have these log also :

root@cacti:~# mysqlcheck -c -u root -p --all-databases
Enter password:
cacti.cdef OK
cacti.cdef_items OK
cacti.colors OK
cacti.data_input OK
cacti.data_input_data OK
cacti.data_input_fields OK
cacti.data_local OK
cacti.data_template OK
cacti.data_template_data
warning : Table is marked as crashed
error : Found wrong record at 24368
error : Corrupt
cacti.data_template_data_rra OK
cacti.data_template_rrd OK
cacti.graph_local OK
cacti.graph_template_input OK
cacti.graph_template_input_defs OK
cacti.graph_templates OK
cacti.graph_templates_gprint OK
cacti.graph_templates_graph OK
cacti.graph_templates_item OK
cacti.graph_tree OK
cacti.graph_tree_items OK
cacti.host OK
cacti.host_graph OK
cacti.host_snmp_cache OK
cacti.host_snmp_query OK
cacti.host_template OK
cacti.host_template_graph OK
cacti.host_template_snmp_query OK
cacti.plugin_config OK
cacti.plugin_db_changes OK
cacti.plugin_hooks OK
cacti.plugin_realms OK
cacti.poller OK
cacti.poller_command OK
cacti.poller_item OK
cacti.poller_output OK
cacti.poller_reindex OK
cacti.poller_time OK
cacti.rra OK
cacti.rra_cf OK
cacti.settings OK
cacti.settings_graphs OK
cacti.settings_tree OK
cacti.snmp_query OK
cacti.snmp_query_graph OK
cacti.snmp_query_graph_rrd OK
cacti.snmp_query_graph_rrd_sv OK
cacti.snmp_query_graph_sv OK
cacti.user_auth OK
cacti.user_auth_perms OK
cacti.user_auth_realm OK
cacti.user_log OK
cacti.version OK
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.innodb_index_stats OK
mysql.innodb_table_stats OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.servers OK
mysql.slave_master_info OK
mysql.slave_relay_log_info OK
mysql.slave_worker_info OK
mysql.slow_log OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
root@cacti:~#