Place Your Feature Requests & Bug Reports Here
Moderators: Developers, Moderators
Patch: Add ifAlias as Name for hp_procurve_ngi
TheWitness, here's a tiny patch against the v2.9-1.tgz download ...
- Attachments
-
- 0001-fixed-alias-support.patch
- (1.39 KiB) Downloaded 904 times
-
TheWitness
- Developer
- Posts: 17047
- Joined: Tue May 14, 2002 5:08 pm
- Location: MI, USA
- Contact:
Re: Patch: Add ifAlias as Name for hp_procurve_ngi
Thanks Mike. It's in SVN now just a little differently.mikaelf wrote:TheWitness, here's a tiny patch against the v2.9-1.tgz download ...
TheWitness
True understanding begins only when we realize how little we truly understand...
Life is an adventure, let yours begin with Cacti!
Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages
For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Life is an adventure, let yours begin with Cacti!
Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages
For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Re: Place Your Feature Requests & Bug Reports Here
Feature Request:
A 'Down Interfaces' filter at the Interfaces tab would be nice.
So we ca easily find devices that have been removed from a location.
A 'Down Interfaces' filter at the Interfaces tab would be nice.
So we ca easily find devices that have been removed from a location.
System: Ubuntu 10.04lts@64bit, 2*X5650, 12GB, Cacti 0.8.7g, Spine 0.8.7g, PA2.9, Weathermap 0.97a, CAMM 1.6.75, monitor 1.3.1, realtime 0.43, thold 0.4.9.3, manage 0.6.2, mactrack 2.9(.1) ---- 508 devices, 6741 items, 4263 ds, time 7.01s, intervall 60, proc. 12, threads 14, php server 8
Re: Place Your Feature Requests & Bug Reports Here
A possible bug:
When an apostrophe appears in a device name, MACTrack/SQL seem to poo kittens with syntax errors. The errors go away if the device name is changed to remove the apostrophe:
10/19/2011 09:35:07 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','193','10.123.110.4','Lee's Summit Access Sw 3','910','00:1D:E5:A6:4E:41','10.123.110.4','2011-10-19 09:31:59')'
10/19/2011 09:35:07 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','193','10.123.110.4','Lee's Summit Access Sw 3','910','00:1D:A2:DD:CF:3F','10.123.110.1','2011-10-19 09:31:59')'
10/19/2011 09:35:07 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','191','10.123.110.2','Lee's Summit Access Sw 1','910','00:1D:E5:A6:42:C1','10.123.110.2','2011-10-19 09:31:59')'
10/19/2011 09:35:07 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','191','10.123.110.2','Lee's Summit Access Sw 1','910','00:1D:A2:DD:CF:3F','10.123.110.1','2011-10-19 09:31:59')'
10/19/2011 09:35:05 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','192','10.123.110.3','Lee's Summit Access Sw 2','910','00:1D:E5:A6:38:41','10.123.110.3','2011-10-19 09:31:59')'
10/19/2011 09:35:05 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','192','10.123.110.3','Lee's Summit Access Sw 2','910','00:1D:A2:DD:CF:3F','10.123.110.1','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','195','10.123.110.6','Lee's Summit Access Sw 5','910','00:26:CB:33:D1:C1','10.123.110.6','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','195','10.123.110.6','Lee's Summit Access Sw 5','910','00:1D:A2:DD:CF:3F','10.123.110.1','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','72','00:26:55:29:B4:14','10.123.209.11','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','72','00:26:55:29:B4:0C','10.123.209.10','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','72','00:1D:A2:DD:CF:3F','10.123.209.1','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','71','00:22:64:A4:A7:CF','10.123.253.130','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','71','00:1D:A2:DD:CF:3F','10.123.253.1','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','70','1C:C1:DE:F0:51:DC','10.123.252.10','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','70','00:1D:A2:DD:CF:3F','10.123.252.1','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','69','1C:C1:DE:73:40:14','10.123.251.10','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','69','00:1D:A2:DD:CF:3F','10.123.251.1','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:18:26:14','10.123.1.194','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:18:2C:BD','10.123.1.193','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:AC:C4:02','10.123.1.190','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:18:2C:CA','10.123.1.189','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','D4:85:64:9C:92:11','10.123.1.187','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:21:5A:68:57:AD','10.123.1.183','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:AC:C3:67','10.123.1.181','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:AA:90:9F','10.123.1.180','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:21:5A:68:55:9C','10.123.1.179','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:AC:C3:F4','10.123.1.176','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:A5:15:B5','10.123.1.174','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:1D:21:B0','10.123.1.172','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:A6:46:90','10.123.1.169','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:18:27:88','10.123.1.167','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:1D:21:FA','10.123.1.164','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:AC:C3:49','10.123.1.162','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:1B:08:D4','10.123.1.159','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:1B:03:43','10.123.1.155','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:1D:21:FD','10.123.1.154','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:21:5A:6B:42:08','10.123.1.152','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:A6:46:D0','10.123.1.151','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:18:2C:E0','10.123.1.150','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:18:2C:BC','10.123.1.148','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:1D:20:09','10.123.1.146','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:A6:47:32','10.123.1.145','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:1F:44:F5','10.123.1.144','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:21:5A:6A:0A:78','10.123.1.143','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:1D:E1:ED','10.123.1.142','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:1E:4E:DE','10.123.1.141','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:21:5A:6B:40:69','10.123.1.140','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:1E:4E:63','10.123.1.139','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:1A:4B:74:18:4B','10.123.1.138','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:21:5A:6A:0A:AA','10.123.1.136','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:AC:C4:24','10.123.1.135','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:1F:46:C6','10.123.1.134','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:A5:17:A6','10.123.1.132','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:1E:4D:B5','10.123.1.131','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:1C:F3:6C','10.123.1.130','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:A5:18:1D','10.123.1.91','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:1D:A2:DD:CF:3F','10.123.1.1','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','67','00:21:B7:08:21:34','10.123.131.61','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','67','00:1F:29:24:C3:C7','10.123.131.60','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','67','00:21:5A:7D:F3:FA','10.123.131.50','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','67','00:21:B7:08:21:29','10.123.131.40','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','67','00:23:7D:83:6D:3C','10.123.131.31','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','67','00:23:7D:84:23:CB','10.123.131.30','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','67','00:11:0A:BB:23:9F','10.123.131.23','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','67','00:14:38:5A:85:92','10.123.131.22','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','67','00:21:5A:7A:D6:AA','10.123.131.21','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','67','00:1F:29:24:D3:C0','10.123.131.20','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','67','00:1D:A2:DD:CF:3F','10.123.131.1','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','66','00:10:83:1A:5C:E6','172.28.60.99','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','66','00:21:5A:67:28:DD','172.28.60.91','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','66','00:22:64:18:26:3A','172.28.60.90','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','66','00:1D:A2:DD:CF:3F','172.28.60.1','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','65','00:1A:E8:37:BE:2B','10.123.240.25','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','65','00:1D:A2:DD:CF:3F','10.123.240.1','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','64','00:1D:A2:DD:CF:3F','10.123.230.1','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','63','00:26:CB:33:D1:C1','10.123.110.6','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','63','00:1D:E5:A6:3F:41','10.123.110.5','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','63','00:1D:E5:A6:4E:41','10.123.110.4','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','63','00:1D:E5:A6:38:41','10.123.110.3','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','63','00:1D:E5:A6:42:C1','10.123.110.2','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','63','00:1D:A2:DD:CF:3F','10.123.110.1','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','55','00:1D:A2:DD:CF:3F','10.123.245.2','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','55','00:15:63:E8:E7:E0','10.123.245.1','2011-10-19 09:31:59')'
10/19/2011 09:35:01 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','194','10.123.110.5','Lee's Summit Access Sw 4','910','00:1D:E5:A6:3F:41','10.123.110.5','2011-10-19 09:31:59')'
10/19/2011 09:35:01 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','194','10.123.110.5','Lee's Summit Access Sw 4','910','00:1D:A2:DD:CF:3F','10.123.110.1','2011-10-19 09:31:59')'
When an apostrophe appears in a device name, MACTrack/SQL seem to poo kittens with syntax errors. The errors go away if the device name is changed to remove the apostrophe:
10/19/2011 09:35:07 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','193','10.123.110.4','Lee's Summit Access Sw 3','910','00:1D:E5:A6:4E:41','10.123.110.4','2011-10-19 09:31:59')'
10/19/2011 09:35:07 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','193','10.123.110.4','Lee's Summit Access Sw 3','910','00:1D:A2:DD:CF:3F','10.123.110.1','2011-10-19 09:31:59')'
10/19/2011 09:35:07 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','191','10.123.110.2','Lee's Summit Access Sw 1','910','00:1D:E5:A6:42:C1','10.123.110.2','2011-10-19 09:31:59')'
10/19/2011 09:35:07 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','191','10.123.110.2','Lee's Summit Access Sw 1','910','00:1D:A2:DD:CF:3F','10.123.110.1','2011-10-19 09:31:59')'
10/19/2011 09:35:05 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','192','10.123.110.3','Lee's Summit Access Sw 2','910','00:1D:E5:A6:38:41','10.123.110.3','2011-10-19 09:31:59')'
10/19/2011 09:35:05 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','192','10.123.110.3','Lee's Summit Access Sw 2','910','00:1D:A2:DD:CF:3F','10.123.110.1','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','195','10.123.110.6','Lee's Summit Access Sw 5','910','00:26:CB:33:D1:C1','10.123.110.6','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','195','10.123.110.6','Lee's Summit Access Sw 5','910','00:1D:A2:DD:CF:3F','10.123.110.1','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','72','00:26:55:29:B4:14','10.123.209.11','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','72','00:26:55:29:B4:0C','10.123.209.10','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','72','00:1D:A2:DD:CF:3F','10.123.209.1','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','71','00:22:64:A4:A7:CF','10.123.253.130','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','71','00:1D:A2:DD:CF:3F','10.123.253.1','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','70','1C:C1:DE:F0:51:DC','10.123.252.10','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','70','00:1D:A2:DD:CF:3F','10.123.252.1','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','69','1C:C1:DE:73:40:14','10.123.251.10','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','69','00:1D:A2:DD:CF:3F','10.123.251.1','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:18:26:14','10.123.1.194','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:18:2C:BD','10.123.1.193','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:AC:C4:02','10.123.1.190','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:18:2C:CA','10.123.1.189','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','D4:85:64:9C:92:11','10.123.1.187','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:21:5A:68:57:AD','10.123.1.183','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:AC:C3:67','10.123.1.181','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:AA:90:9F','10.123.1.180','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:21:5A:68:55:9C','10.123.1.179','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:AC:C3:F4','10.123.1.176','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:A5:15:B5','10.123.1.174','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:1D:21:B0','10.123.1.172','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:A6:46:90','10.123.1.169','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:18:27:88','10.123.1.167','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:1D:21:FA','10.123.1.164','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:AC:C3:49','10.123.1.162','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:1B:08:D4','10.123.1.159','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:1B:03:43','10.123.1.155','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:1D:21:FD','10.123.1.154','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:21:5A:6B:42:08','10.123.1.152','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:A6:46:D0','10.123.1.151','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:18:2C:E0','10.123.1.150','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:18:2C:BC','10.123.1.148','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:1D:20:09','10.123.1.146','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:A6:47:32','10.123.1.145','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:1F:44:F5','10.123.1.144','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:21:5A:6A:0A:78','10.123.1.143','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:1D:E1:ED','10.123.1.142','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:1E:4E:DE','10.123.1.141','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:21:5A:6B:40:69','10.123.1.140','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:1E:4E:63','10.123.1.139','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:1A:4B:74:18:4B','10.123.1.138','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:21:5A:6A:0A:AA','10.123.1.136','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:AC:C4:24','10.123.1.135','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:1F:46:C6','10.123.1.134','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:A5:17:A6','10.123.1.132','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:1E:4D:B5','10.123.1.131','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:1C:F3:6C','10.123.1.130','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:22:64:A5:18:1D','10.123.1.91','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','68','00:1D:A2:DD:CF:3F','10.123.1.1','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','67','00:21:B7:08:21:34','10.123.131.61','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','67','00:1F:29:24:C3:C7','10.123.131.60','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','67','00:21:5A:7D:F3:FA','10.123.131.50','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','67','00:21:B7:08:21:29','10.123.131.40','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','67','00:23:7D:83:6D:3C','10.123.131.31','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','67','00:23:7D:84:23:CB','10.123.131.30','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','67','00:11:0A:BB:23:9F','10.123.131.23','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','67','00:14:38:5A:85:92','10.123.131.22','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','67','00:21:5A:7A:D6:AA','10.123.131.21','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','67','00:1F:29:24:D3:C0','10.123.131.20','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','67','00:1D:A2:DD:CF:3F','10.123.131.1','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','66','00:10:83:1A:5C:E6','172.28.60.99','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','66','00:21:5A:67:28:DD','172.28.60.91','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','66','00:22:64:18:26:3A','172.28.60.90','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','66','00:1D:A2:DD:CF:3F','172.28.60.1','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','65','00:1A:E8:37:BE:2B','10.123.240.25','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','65','00:1D:A2:DD:CF:3F','10.123.240.1','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','64','00:1D:A2:DD:CF:3F','10.123.230.1','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','63','00:26:CB:33:D1:C1','10.123.110.6','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','63','00:1D:E5:A6:3F:41','10.123.110.5','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','63','00:1D:E5:A6:4E:41','10.123.110.4','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','63','00:1D:E5:A6:38:41','10.123.110.3','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','63','00:1D:E5:A6:42:C1','10.123.110.2','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','63','00:1D:A2:DD:CF:3F','10.123.110.1','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','55','00:1D:A2:DD:CF:3F','10.123.245.2','2011-10-19 09:31:59')'
10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','55','00:15:63:E8:E7:E0','10.123.245.1','2011-10-19 09:31:59')'
10/19/2011 09:35:01 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','194','10.123.110.5','Lee's Summit Access Sw 4','910','00:1D:E5:A6:3F:41','10.123.110.5','2011-10-19 09:31:59')'
10/19/2011 09:35:01 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','194','10.123.110.5','Lee's Summit Access Sw 4','910','00:1D:A2:DD:CF:3F','10.123.110.1','2011-10-19 09:31:59')'
[color=black]mount -o protected -t voluptuous,selfmaintaining /dev/woman /mnt/me
Attitude is no substitute for competence
See through faded, super jaded, out of my mind[/color]
Attitude is no substitute for competence
See through faded, super jaded, out of my mind[/color]
-
TheWitness
- Developer
- Posts: 17047
- Joined: Tue May 14, 2002 5:08 pm
- Location: MI, USA
- Contact:
Re: Place Your Feature Requests & Bug Reports Here
The most wonderful tag line for a young of breeding age geek, but drinking too, maleARC1450 wrote:A possible bug:
When an apostrophe appears in a device name, MACTrack/SQL seem to poo kittens with syntax errors. The errors go away if the device name is changed to remove the apostrophe:
For now, don't use the apostrophe. It's a pretty large change. Can you log a bug to http://bugs.cacti.net under the 'Cacti Plugins' project so we can track it.True understanding begins only when we realize how little we truly understand...
Life is an adventure, let yours begin with Cacti!
Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages
For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Life is an adventure, let yours begin with Cacti!
Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages
For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Re: Place Your Feature Requests & Bug Reports Here
'Tis logged.
If I knew more than rudimentary SQL (like, enough to do a "drop database") I'd submit the bug fix with it.
Sorry dude.
If I knew more than rudimentary SQL (like, enough to do a "drop database") I'd submit the bug fix with it.
Sorry dude.
[color=black]mount -o protected -t voluptuous,selfmaintaining /dev/woman /mnt/me
Attitude is no substitute for competence
See through faded, super jaded, out of my mind[/color]
Attitude is no substitute for competence
See through faded, super jaded, out of my mind[/color]
-
TheWitness
- Developer
- Posts: 17047
- Joined: Tue May 14, 2002 5:08 pm
- Location: MI, USA
- Contact:
Re: Place Your Feature Requests & Bug Reports Here
Fixed in SVN.10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','63','00:1D:E5:A6:42:C1','10.123.110.2','2011-10-19 09:31:59')'
True understanding begins only when we realize how little we truly understand...
Life is an adventure, let yours begin with Cacti!
Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages
For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Life is an adventure, let yours begin with Cacti!
Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages
For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Re: Place Your Feature Requests & Bug Reports Here
TheWitness wrote:Fixed in SVN.10/19/2011 09:35:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"REPLACE INTO mac_track_ips (site_id,device_id,hostname,device_name,port_number,mac_address,ip_address,scan_date) VALUES ('22','196','10.123.110.1','Lee's Summit Core Switch','63','00:1D:E5:A6:42:C1','10.123.110.2','2011-10-19 09:31:59')'
Found an extra ')' in mactrack_functions.php (line 404). Kinda breaks things.. Here is the patch.
-chadd.
- Attachments
-
- mactrack_functions.patch
- (530 Bytes) Downloaded 332 times
-
TheWitness
- Developer
- Posts: 17047
- Joined: Tue May 14, 2002 5:08 pm
- Location: MI, USA
- Contact:
Re: Place Your Feature Requests & Bug Reports Here
Fixed. Asked Roney to do some pre-validation on commit to reduce the likelihood of this happening moving forward.
True understanding begins only when we realize how little we truly understand...
Life is an adventure, let yours begin with Cacti!
Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages
For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Life is an adventure, let yours begin with Cacti!
Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages
For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Re: Place Your Feature Requests & Bug Reports Here
Hi everyone,
I was trying to use the high-low port limits in the Device Type for our HP switches and it did not work, I edited the mactrack_hp_ng.php to fix it and here it is.
I just deleted the line:
$port_results = get_base_dot1dTpFdbEntry_ports($site, $device, $ifInterfaces, "", "", FALSE);
and added:
if (($highPort == 0) && ($lowPort==0)) {
$port_results = get_base_dot1dTpFdbEntry_ports($site, $device, $ifInterfaces, "", FALSE);
}else {
$port_results = get_base_dot1dTpFdbEntry_ports($site, $device, $ifInterfaces, "", FALSE, $lowPort, $highPort);
}
now it works fine, let me know if it works for you also. I attached the edited php, just rename the txt to php.
PS: I also edited the OID used for $ifIndexes, the new OID is .1.3.6.1.4.1.11.2.14.11.5.1.7.1.3.1.1.1
I was trying to use the high-low port limits in the Device Type for our HP switches and it did not work, I edited the mactrack_hp_ng.php to fix it and here it is.
I just deleted the line:
$port_results = get_base_dot1dTpFdbEntry_ports($site, $device, $ifInterfaces, "", "", FALSE);
and added:
if (($highPort == 0) && ($lowPort==0)) {
$port_results = get_base_dot1dTpFdbEntry_ports($site, $device, $ifInterfaces, "", FALSE);
}else {
$port_results = get_base_dot1dTpFdbEntry_ports($site, $device, $ifInterfaces, "", FALSE, $lowPort, $highPort);
}
now it works fine, let me know if it works for you also. I attached the edited php, just rename the txt to php.
PS: I also edited the OID used for $ifIndexes, the new OID is .1.3.6.1.4.1.11.2.14.11.5.1.7.1.3.1.1.1
- Attachments
-
- mactrack_hp_ng.edited.txt
- (5.75 KiB) Downloaded 339 times
Re: Place Your Feature Requests & Bug Reports Here
Feature request:
- Under Mactrack -> Interfaces i would love to see a count of the number of mac addresses behind each interface/port.
Bug reports:
- The help text under Settings -> Device Tracking for "Interface That Has Changed in Less than 24 Hours" is wrong, see screenshot:
- Under Macktrack -> Devices, the "User ports up" and "Active Macs" count is always the same when it should not be as there might be multiple mac addresses behind access interfaces. In example a Cisco IP phone with passtrough bridge setup.
I'm the running SVN version of mactrack, updated last week.
- Under Mactrack -> Interfaces i would love to see a count of the number of mac addresses behind each interface/port.
Bug reports:
- The help text under Settings -> Device Tracking for "Interface That Has Changed in Less than 24 Hours" is wrong, see screenshot:
- Under Macktrack -> Devices, the "User ports up" and "Active Macs" count is always the same when it should not be as there might be multiple mac addresses behind access interfaces. In example a Cisco IP phone with passtrough bridge setup.
I'm the running SVN version of mactrack, updated last week.
Re: Place Your Feature Requests & Bug Reports Here
Tired of waiting for a fix so i did some coding myself, been awhile since i touched PHP so don't expect to much...
Some code is reused from mactrack_functions.php, so there might be some unneeded code and should probably be cleanup up a little bye the author of the plug-in...
The following code fixes the Count for Total User ports up vs Active Macs:
File: mactrack/lib/mactrack_cisco.php
Line 292, add:
Line 476, add:
Comment out $device["ports_active"]++; around line 450...
Result image:
Some code is reused from mactrack_functions.php, so there might be some unneeded code and should probably be cleanup up a little bye the author of the plug-in...
The following code fixes the Count for Total User ports up vs Active Macs:
File: mactrack/lib/mactrack_cisco.php
Line 292, add:
Code: Select all
/* get port operational status (mod) */
$ifOperStatus = xform_standard_indexed_data(".1.3.6.1.2.1.2.2.1.8", $device);
if (sizeof($ifOperStatus)) {
foreach($ifOperStatus as $key=>$value) {
if ($value == "1") {
$ifOperStatus[$key] = 1;
} else {
$ifOperStatus[$key] = 0;
}
}
}
mactrack_debug("ifOperStatus data collection complete. '" . sizeof($ifOperStatus) . "' rows found!");
Code: Select all
// Get correct count for active end-user interfaces/ports (mod)
foreach($ifOperStatus as $ifIndex => $port_status) {
$ifType = @$ifInterfaces[$ifIndex]["ifType"];
$portTrunkStatus = @$ifInterfaces[$ifIndex]["trunkPortState"];
if (($ifType == 6) && ($port_status == 1) && ($portTrunkStatus == "2")) {
$device["ports_active"]++;
}
}
Result image:
Re: Place Your Feature Requests & Bug Reports Here
Add the option on the Device menu, to change the site for a number of device in the same time, without having to go to each one of them.
Add the option change the default terminal type to None instead of telnet (or is it already possible ?)
Add the option change the default terminal type to None instead of telnet (or is it already possible ?)
Test
Almalinux
php 8.2.14
mariadb 10.6.16
Cacti 1.2.27
Spine 1.2.27
RRD 1.7.2
thold 1.8
monitor 2.5
syslog 3.2
flowview: 3.3
weathermap 1.0 Beta
Almalinux
php 8.2.14
mariadb 10.6.16
Cacti 1.2.27
Spine 1.2.27
RRD 1.7.2
thold 1.8
monitor 2.5
syslog 3.2
flowview: 3.3
weathermap 1.0 Beta
Re: Place Your Feature Requests & Bug Reports Here
Hi folks,
first witness, thanks for the plugin. It does a great job.
I've got maybe a feature request. Would it be possible to generate a mailreport with all new seen mac-adresses after each polling cycle?
Thanks,
Eisenkopf
first witness, thanks for the plugin. It does a great job.
I've got maybe a feature request. Would it be possible to generate a mailreport with all new seen mac-adresses after each polling cycle?
Thanks,
Eisenkopf
Re: Place Your Feature Requests & Bug Reports Here
Hi
I´m using mactrack with the "remote" plugin. Works great! Does anyone know if there is a way to integrate the "TN" icon with the link to the plugin on the interface tab as well as on the devices tab. I think it would greatly increase the usability of the plugin. Now I have to switch between the tabs to connect to my switches and first search for the interfaces in the interface tab and then search for the corresponding device in the device tab before I can connect.
Best regards
Lars
I´m using mactrack with the "remote" plugin. Works great! Does anyone know if there is a way to integrate the "TN" icon with the link to the plugin on the interface tab as well as on the devices tab. I think it would greatly increase the usability of the plugin. Now I have to switch between the tabs to connect to my switches and first search for the interfaces in the interface tab and then search for the corresponding device in the device tab before I can connect.
Best regards
Lars
Who is online
Users browsing this forum: No registered users and 0 guests