3Com Superstack 3's

streaker69 · Post by **streaker69** » Mon Oct 30, 2006 8:30 am

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.

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:28)"

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

mjaz · Post by **mjaz** » Mon Oct 30, 2006 9:21 am

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: Select all

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

streaker69 · Post by **streaker69** » Thu Nov 16, 2006 9:09 pm

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.

mjaz · Post by **mjaz** » Thu Nov 23, 2006 6:58 am

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

Post by **TheWitness** » Thu Nov 23, 2006 7:59 am

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

chadd · Post by **chadd** » Wed Dec 13, 2006 12:42 pm

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?

Post by **TheWitness** » Mon Jan 01, 2007 4:20 pm

Please review the top post under MacTrack for my status. I am working on this today.

TheWitness

mcutting · Post by **mcutting** » Mon Mar 05, 2007 9:39 am

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

streaker69 · Post by **streaker69** » Mon Mar 05, 2007 3:50 pm

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?

mcutting · Post by **mcutting** » Tue Mar 06, 2007 1:32 am

I have a PIX firewall as the gateway ({PIX 515), although the switches are local to my LAN ?

mcutting · Post by **mcutting** » Tue Mar 06, 2007 6:17 am

Can anyone shed some light on this ?

TIA

Post by **TheWitness** » Tue Mar 06, 2007 9:15 am

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

mcutting · Post by **mcutting** » Tue Mar 06, 2007 9:22 am

Thanks, but do I need to be concerned about the PIX ? These switches are on my local LAN ?

Post by **TheWitness** » Tue Mar 06, 2007 1:31 pm

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

mcutting · Post by **mcutting** » Wed Mar 07, 2007 1:07 am

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

3Com Superstack 3's

3Com Superstack 3's

Who is online