Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Mon Mar 27, 2017 1:58 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: SQL ISSUE and PHP Issue with MacTrac3
PostPosted: Fri Jun 03, 2016 2:09 pm 
Offline

Joined: Fri May 27, 2016 3:34 am
Posts: 7
I am currently running Cacti 8.8h with various plugins all working fine.

I downloaded MacTrack 3.0 plugin and have installed. Its installed fine, but I have various issues with it:

1st being poller error below:
CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT mac_track_sites.site_id, mac_track_sites.site_name, mac_track_sites.total_devices, mac_track_sites.total_device_errors, mac_track_sites.total_macs, mac_track_sites.total_ips, mac_track_sites.total_oper_ports, mac_track_sites.total_user_ports FROM mac_track_sites ORDER BY site_name ASC LIMIT 0

2nd being several link from the cacti console generate http 500 errors. I have had no other issues with this server running weather map, thold, monitor and nector. This Server also runs CES 3.3 (Centreon 2.7.4)
Specific links are, the macktrack tab across the top and snmp options( Under device tracking - mactrack_snmp.php)

server is running centos 6.7.

Any help or suggestions would be appreciated.


Top
 Profile  
 
 Post subject: Re: SQL ISSUE and PHP Issue with MacTrac3
PostPosted: Mon Jun 06, 2016 4:12 am 
Offline

Joined: Fri May 27, 2016 3:34 am
Posts: 7
Any 1 any thoughts on this please? Its really frustrating.....


Kind regards,

Paul


Top
 Profile  
 
 Post subject: Re: SQL ISSUE and PHP Issue with MacTrac3
PostPosted: Tue Jun 07, 2016 4:26 pm 
Offline

Joined: Fri May 27, 2016 3:34 am
Posts: 7
I have disabled the plugin and uninstalled it. Confirmed plugin removal from /cacti/plugins.

I have then downloaded a fresh copy from git hub and installed. Tried adding a device as before and same errors.

1st being poller error below:
CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT mac_track_sites.site_id, mac_track_sites.site_name, mac_track_sites.total_devices, mac_track_sites.total_device_errors, mac_track_sites.total_macs, mac_track_sites.total_ips, mac_track_sites.total_oper_ports, mac_track_sites.total_user_ports FROM mac_track_sites ORDER BY site_name ASC LIMIT 0

Also now getting:
CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT last_rundate, COUNT(last_rundate) AS devices FROM mac_track_devices WHERE disabled = '' AND site_id=Sitexx GROUP BY last_rundate ORDER BY last_rundate DESC;"

I have installed phpmyadmin and browsed the tables, found the last rundate description is "WARNING: Device Type Not Found in Device Type Table."

Issue 2:

Still getting http 500 issues on 2 specific links. I did wonder if it was to do with the JSON extension for php as both mactrack tab and mactrack_snmp has .js extensions. I disabled it and found phpmyadmin complained it was running. So renabled it.

Yes I was clutching at straws!

Any help really would be appreciated. I am so close to this working and its very frustrating...



Kind regards,

Paul


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

All times are UTC - 5 hours


Who is online

Users browsing this forum: Yahoo [Bot] and 2 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