Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Mon Mar 25, 2019 3:27 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 7 posts ] 
Author Message
 Post subject: Uninstall Mactrack - still errors in logfile?
PostPosted: Thu May 03, 2012 2:34 am 
Offline
Cacti User

Joined: Tue Sep 22, 2009 7:46 am
Posts: 100
All,

I have moved Mactrack from our 'regular' cacti instance to a dedicated Mactrack server. Today I disabled/uninstalled Mactrack but I get lots of errors in the log:
Code:
05/03/2012 09:23:14 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM mac_track_temp_ports WHERE ip_address != '' AND (dns_hostname = '' OR dns_hostname IS NULL)"
05/03/2012 09:23:14 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM mac_track_temp_ports WHERE ip_address != '' AND (dns_hostname = '' OR dns_hostname IS NULL)"
05/03/2012 09:23:14 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT last_rundate, COUNT(last_rundate) AS devices FROM mac_track_devices WHERE disabled = '' GROUP BY last_rundate ORDER BY last_rundate DESC;"
05/03/2012 09:23:14 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT last_rundate, COUNT(last_rundate) AS devices FROM mac_track_devices WHERE disabled = '' GROUP BY last_rundate ORDER BY last_rundate DESC;"
05/03/2012 09:23:14 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(*) FROM mac_track_processes WHERE device_id <> '0'"
05/03/2012 09:23:14 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(*) FROM mac_track_processes WHERE device_id <> '0'"
05/03/2012 09:23:14 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(*) FROM mac_track_processes WHERE device_id <> '0'"
05/03/2012 09:23:14 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM mac_track_temp_ports WHERE ip_address != '' AND (dns_hostname = '' OR dns_hostname IS NULL)"


I checked all the tables but there's no Mactrack table anywhere left.
How to get rid of these errors?

Thanks,

Phil


Top
 Profile  
 
 Post subject: Re: Uninstall Mactrack - still errors in logfile?
PostPosted: Sat May 12, 2012 7:33 am 
Offline
Developer
User avatar

Joined: Thu Dec 02, 2004 2:46 am
Posts: 22376
Location: Muenster, Germany
Please see the "plugins_*" tables. There seems to be some left-behinds
R.

_________________
Official Cacti Documentation
Official Debugging Help
Central Plugin Repository
Central Templates Repository


Top
 Profile  
 
 Post subject: Re: Uninstall Mactrack - still errors in logfile?
PostPosted: Tue May 15, 2012 2:54 am 
Offline
Cacti User

Joined: Tue Sep 22, 2009 7:46 am
Posts: 100
I removed the table "mac_track_interface_graphs" as this one was still there but that didn't help.

I did not see any left-behinds in the Plugin_* tables, here's what I have as tables:

Code:
mysql> show tables;
+---------------------------------------+
| Tables_in_cacti087g                   |
+---------------------------------------+
| cdef                                  |
| cdef_items                            |
| colors                                |
| data_input                            |
| data_input_data                       |
| data_input_fields                     |
| data_local                            |
| data_template                         |
| data_template_data                    |
| data_template_data_rra                |
| data_template_rrd                     |
| graph_local                           |
| graph_template_input                  |
| graph_template_input_defs             |
| graph_templates                       |
| graph_templates_gprint                |
| graph_templates_graph                 |
| graph_templates_item                  |
| graph_tree                            |
| graph_tree_items                      |
| host                                  |
| host_graph                            |
| host_snmp_cache                       |
| host_snmp_query                       |
| host_template                         |
| host_template_graph                   |
| host_template_snmp_query              |
| plugin_aggregate_color_template_items |
| plugin_aggregate_color_templates      |
| plugin_config                         |
| plugin_db_changes                     |
| plugin_hooks                          |
| plugin_realms                         |
| plugin_routerconfigs_accounts         |
| plugin_routerconfigs_backups          |
| plugin_routerconfigs_devices          |
| plugin_routerconfigs_devicetypes      |
| plugin_rrdclean                       |
| plugin_rrdclean_action                |
| poller                                |
| poller_command                        |
| poller_item                           |
| poller_output                         |
| poller_output_rt                      |
| poller_reindex                        |
| poller_time                           |
| reportit_cache_measurands             |
| reportit_cache_reports                |
| reportit_cache_variables              |
| reportit_data_items                   |
| reportit_data_source_items            |
| reportit_measurands                   |
| reportit_presets                      |
| reportit_recipients                   |
| reportit_reports                      |
| reportit_results_1                    |
| reportit_rvars                        |
| reportit_templates                    |
| reportit_variables                    |
| rra                                   |
| rra_cf                                |
| settings                              |
| settings_graphs                       |
| settings_tree                         |
| snmp_query                            |
| snmp_query_graph                      |
| snmp_query_graph_rrd                  |
| snmp_query_graph_rrd_sv               |
| snmp_query_graph_sv                   |
| syslog                                |
| syslog_alert                          |
| syslog_incoming                       |
| syslog_remove                         |
| syslog_reports                        |
| user_auth                             |
| user_auth_perms                       |
| user_auth_realm                       |
| user_log                              |
| version                               |
| weathermap_auth                       |
| weathermap_data                       |
| weathermap_groups                     |
| weathermap_maps                       |
| weathermap_settings                   |
+---------------------------------------+
84 rows in set (0.00 sec)


No reference to Mactrack in plugin_config or any of the others.
I have to enable mactrack again to get rid of the errors.

Thanks,

Phil


Top
 Profile  
 
 Post subject: Re: Uninstall Mactrack - still errors in logfile?
PostPosted: Sun May 20, 2012 12:17 pm 
Offline
Developer
User avatar

Joined: Thu Dec 02, 2004 2:46 am
Posts: 22376
Location: Muenster, Germany
I meant to check
| plugin_config |
| plugin_db_changes |
| plugin_hooks |
| plugin_realms |
for mactrack entries.
R.

_________________
Official Cacti Documentation
Official Debugging Help
Central Plugin Repository
Central Templates Repository


Top
 Profile  
 
 Post subject: Re: Uninstall Mactrack - still errors in logfile?
PostPosted: Mon May 21, 2012 1:50 am 
Offline
Cacti User

Joined: Tue Sep 22, 2009 7:46 am
Posts: 100
gandalf wrote:
I meant to check
| plugin_config |
| plugin_db_changes |
| plugin_hooks |
| plugin_realms |
for mactrack entries.
R.


None of them contains any references to macktrack...


Top
 Profile  
 
 Post subject: Re: Uninstall Mactrack - still errors in logfile?
PostPosted: Mon May 21, 2012 11:17 am 
Offline
Developer
User avatar

Joined: Thu Dec 02, 2004 2:46 am
Posts: 22376
Location: Muenster, Germany
Are you running the mactrack poller from crontab?
R.

_________________
Official Cacti Documentation
Official Debugging Help
Central Plugin Repository
Central Templates Repository


Top
 Profile  
 
 Post subject: Re: Uninstall Mactrack - still errors in logfile?
PostPosted: Tue May 22, 2012 1:37 am 
Offline
Cacti User

Joined: Tue Sep 22, 2009 7:46 am
Posts: 100
gandalf wrote:
Are you running the mactrack poller from crontab?
R.


Nope, in fact I am not running Mactrack at all. The scanning frequency is set to 'disabled'

Thanks,

Philip


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 7 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 9 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group