|
|
| Author |
Message |
streaker69
Cacti Pro User
Joined: 27 Mar 2006
Posts: 647
Location: Psychic Amish Network Administrator
|
 Posted: Mon Oct 30, 2006 8:30 am Post subject: 3Com Superstack 3's |
 |
|
I believe I have everything in MacTrack setup properly to poll my switch, but I continue to receive the following messages in the Poller Log. I was hoping that maybe someone had some insight into what could be wrong.
| Quote: |
10/30/2006 08:16:11 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "SELECT COUNT(mac_track_ip_ranges.ip_range) FROM mac_track_ip_ranges INNER JOIN mac_track_sites ON (mac_track_ip_ranges.site_id=mac_track_sites.site_id) "
10/30/2006 08:16:11 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT mac_track_sites.site_id, mac_track_sites.site_name, mac_track_ip_ranges.ip_range, mac_track_ip_ranges.ips_max, mac_track_ip_ranges.ips_current, mac_track_ip_ranges.ips_max_date, mac_track_ip_ranges.ips_current_date FROM mac_track_ip_ranges INNER JOIN mac_track_sites ON (mac_track_ip_ranges.site_id=mac_track_sites.site_id) LIMIT 0,30"
10/30/2006 08:10:42 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "DELETE FROM mac_track_processes WHERE device_id='0'"
10/30/2006 08:10:39 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "SELECT COUNT(*) FROM mac_track_processes WHERE device_id <> '0'"
10/30/2006 08:10:38 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "DELETE FROM mac_track_processes WHERE device_id='1'"
10/30/2006 08:10:38 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "UPDATE `mac_track_ip_ranges` SET ips_max=ips_current, ips_max_date=ips_current_date WHERE ips_current > ips_max"
10/30/2006 08:10:38 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed "SELECT * FROM mac_track_processes WHERE device_id = 0"
10/30/2006 08:10:38 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "DELETE FROM mac_track_processes WHERE device_id='-1'"
10/30/2006 08:10:38 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "SELECT count(*) FROM mac_track_processes WHERE device_id > 0"
10/30/2006 08:10:36 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "SELECT COUNT(*) FROM mac_track_processes WHERE device_id <> '0'"
10/30/2006 08:10:36 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "INSERT INTO mac_track_processes (device_id, process_id, status, start_date) VALUES ('0', '24329', 'Running', NOW())"
10/30/2006 08:10:35 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "DELETE FROM mac_track_processes WHERE device_id='2'"
10/30/2006 08:10:35 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "INSERT INTO mac_track_processes (device_id, process_id, status, start_date) VALUES ('1', '24278', 'Running', NOW())"
10/30/2006 08:10:35 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "DELETE FROM mac_track_processes WHERE device_id='3'"
10/30/2006 08:10:35 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "DELETE FROM mac_track_processes WHERE device_id='4'"
10/30/2006 08:10:34 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "INSERT INTO mac_track_processes (device_id, process_id, status, start_date) VALUES ('4', '24284', 'Running', NOW())"
10/30/2006 08:10:34 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "INSERT INTO mac_track_processes (device_id, process_id, status, start_date) VALUES ('2', '24282', 'Running', NOW())"
10/30/2006 08:10:34 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "INSERT INTO mac_track_processes (device_id, process_id, status, start_date) VALUES ('3', '24280', 'Running', NOW())"
10/30/2006 08:10:33 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "INSERT INTO mac_track_processes (device_id, process_id, status, start_date) VALUES ('-1', '0', 'Running', NOW())"
10/30/2006 07:55:36 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "DELETE FROM mac_track_processes WHERE device_id='0'"
10/30/2006 07:55:33 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "SELECT COUNT(*) FROM mac_track_processes WHERE device_id <> '0'"
10/30/2006 07:55:32 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "UPDATE `mac_track_ip_ranges` SET ips_max=ips_current, ips_max_date=ips_current_date WHERE ips_current > ips_max"
10/30/2006 07:55:32 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "REPLACE INTO `mac_track_ip_ranges` (ip_range, site_id, ips_current, ips_current_date) VALUES (XXX.X.X,1,12,2006-10-30 07:55:2 "
|
I have X'ed out my IP range. The Switch is reporting the MAC's attached to it, but even though it was up and running all weekend long it wasn't until this morning that I started to see End Device IP information related to those MAC's. I don't know if it's because of the Switch maybe not supporting certain features or if it's because of the error messages I'm getting above.
Anyone have some insight as to what could be wrong? I have created the device Type for the 3Com Switch, and I believe I have done that correctly. The Switch is showing that it's up with no errors.
Current system is:
1.3Ghz Celeron
512M RAM
CactiEZ 0.2
|
|
| Back to top |
|
 |
mjaz
Joined: 18 Apr 2005
Posts: 8
|
| Posted: Mon Oct 30, 2006 9:21 am Post subject: |
|
|
I'm also stuggling with the same issue. I've created a new Device type to match my device (3com superstack 3) and told it to use get_generic_switch_ports as the scanning function. When the mactrack poller runs I'm missing all data for End device ip address, end device DNS hostname, Port Name, Vlan ID and Vlan Name. All other data is returned correctly although the log files have the following errors:
| Code: | 10/30/2006 01:55:51 PM - SYSTEM MACTRACK STATS: Time:29.0340 ConcurrentProcesses:7 Devices:7
10/30/2006 01:55:48 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "UPDATE `mac_track_ip_ranges` SET ips_max=ips_current, ips_max_date=ips_current_date WHERE ips_current > ips_max"
10/30/2006 01:55:47 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "REPLACE INTO `mac_track_ip_ranges` (ip_range, site_id, ips_current, ips_current_date) VALUES ('172.16.6',1,'134','2006-10-30 13:55:22')" |
Any ideas how i can get this working correctly? I've attached a full snmp trace of the device.
Thanks in advance
Mark
| Description: |
|
Download |
| Filename: |
superstack.rar |
| Filesize: |
96.94 KB |
| Downloaded: |
662 Time(s) |
|
|
| Back to top |
|
|
streaker69
Cacti Pro User
Joined: 27 Mar 2006
Posts: 647
Location: Psychic Amish Network Administrator
|
| Posted: Thu Nov 16, 2006 9:09 pm Post subject: |
|
|
Just thought I'd post the Device Type information for the 3Com SuperStacks. This one will work with the 4200 Series switches. Should work for anything between 1 and 50 port switches. I've tested in a 24 +2 (3C17300) and a 48+2 (3C17302A) Switch and it appears to be functioning just fine now.
Maybe we should start a thread of custom device types, so that everyone doesn't have to figure these things out on their own.
| Description: |
|
| Filesize: |
53 KB |
| Viewed: |
6210 Time(s) |
|
|
|
| Back to top |
|
|
mjaz
Joined: 18 Apr 2005
Posts: 8
|
| Posted: Thu Nov 23, 2006 6:58 am Post subject: |
|
|
OK, got this working now. Added the device type as streaker69 had it and installed the latest version of mactrack from the cvs. I can also confim the standard scanning functions also work with Allied Telesyn AT-8326GB switches (OID: .1.3.6.1.4.1.207.1.4.72)
Mark
|
|
| Back to top |
|
|
TheWitness
Developer
Joined: 14 May 2002
Posts: 9671
Location: MI, USA
|
| Posted: Thu Nov 23, 2006 7:59 am Post subject: |
|
|
I keep promising to get Release 1.0 out, but I keep getting stuck on things like "Boost" and a plugin that I am writing for my company. It pretty huge. My goal is to issue a second release of MacTrack by sometime January. It's going to take a lot of work though, gulp!
TheWitness
|
|
| Back to top |
|
|
chadd
Cacti User
Joined: 24 Mar 2005
Posts: 194
Location: Ocoee, Florida
|
| Posted: Wed Dec 13, 2006 12:42 pm Post subject: |
|
|
Just wondered if you are still on track for a January time frame? I have users interested in the capabilities of Mactrack. I would have to write scanning functions for all the foundry switches we have (I presume), but mostly I was wondering if there are a lot of changes between the current version and the 1.0 release. If so, I can wait until you get it completed, if not maybe I will install it and try to get the foundry stuff taken care of. Thanks for all your work on Cacti.
P.S. Do you have any pointers for creating new scanning functions, or for implementing support for new vendors - like Foundry?
|
|
| Back to top |
|
|
TheWitness
Developer
Joined: 14 May 2002
Posts: 9671
Location: MI, USA
|
| Posted: Mon Jan 01, 2007 4:20 pm Post subject: |
|
|
Please review the top post under MacTrack for my status. I am working on this today.
TheWitness
|
|
| Back to top |
|
|
mcutting
Cacti Pro User
Joined: 16 Oct 2006
Posts: 974
|
| Posted: Mon Mar 05, 2007 9:39 am Post subject: |
|
|
For some unknown reason, I am unable to get IP Addresses, despite using the correct settings (as per Steaker69's screenshot). There are no errors in the log, and I've run database_upgrade.php - the files are also the latest SVN.
Anyone have any ideas, as I'd love to get this to work...
Thanks
|
|
| Back to top |
|
|
streaker69
Cacti Pro User
Joined: 27 Mar 2006
Posts: 647
Location: Psychic Amish Network Administrator
|
| Posted: Mon Mar 05, 2007 3:50 pm Post subject: |
|
|
| mcutting wrote: | For some unknown reason, I am unable to get IP Addresses, despite using the correct settings (as per Steaker69's screenshot). There are no errors in the log, and I've run database_upgrade.php - the files are also the latest SVN.
Anyone have any ideas, as I'd love to get this to work...
Thanks |
Do you have a Router paired up with the switch at the Site?
|
|
| Back to top |
|
|
mcutting
Cacti Pro User
Joined: 16 Oct 2006
Posts: 974
|
| Posted: Tue Mar 06, 2007 1:32 am Post subject: |
|
|
| I have a PIX firewall as the gateway ({PIX 515), although the switches are local to my LAN ?
|
|
| Back to top |
|
|
mcutting
Cacti Pro User
Joined: 16 Oct 2006
Posts: 974
|
| Posted: Tue Mar 06, 2007 6:17 am Post subject: |
|
|
Can anyone shed some light on this ?
TIA
|
|
| Back to top |
|
|
TheWitness
Developer
Joined: 14 May 2002
Posts: 9671
Location: MI, USA
|
| Posted: Tue Mar 06, 2007 9:15 am Post subject: |
|
|
mcutting,
The latest SVN allows for you sto store a userid and password per device and define a IP Scanning function per device type, say a pix. With the PIX, you will have to SSH to the device and then run the arp command and then parse the output into the mac_track_ips table.
You should amend the mactrack_cisco.php vendor library with your scanning function and then post the modified file here. Good luck.
I don't have a PIX, so I can not do it.
TheWitness
|
|
| Back to top |
|
|
mcutting
Cacti Pro User
Joined: 16 Oct 2006
Posts: 974
|
| Posted: Tue Mar 06, 2007 9:22 am Post subject: |
|
|
| Thanks, but do I need to be concerned about the PIX ? These switches are on my local LAN ?
|
|
| Back to top |
|
|
TheWitness
Developer
Joined: 14 May 2002
Posts: 9671
Location: MI, USA
|
| Posted: Tue Mar 06, 2007 1:31 pm Post subject: |
|
|
MacTrack requires at least 1 L3 device. If all your switches are L3 and you declare them as such, you won't have a problem, but if they are L2, you will need to get information from either the PIX or an upstream L3 device.
TheWitness
|
|
| Back to top |
|
|
mcutting
Cacti Pro User
Joined: 16 Oct 2006
Posts: 974
|
| Posted: Wed Mar 07, 2007 1:07 am Post subject: |
|
|
TheWitness - thanks for the explanation
Streaker69 - could you offer a brief outline of what you did to get these working, as it looks like you have the same switches as I ?
Thanks
|
|
| Back to top |
|
|
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Register
Profile
Log in to check your private messages
Log in
