Cisco equipment not matching and field not large enough

[pbulteel]

I found out that the reason I wasn't getting any IPs on my install of Mactrack was that my cisco equipment isn't matching the strings in the device type table, so I decided to create a new one with same properties as the other one (3750.)

However, I discovered that the field for the description isn't large enough since whenever I tried adding my description it left the last character off.

WS-C3750-IPSERVICES-M (drops the M when saved.)

I'm going to increase the field of the table.

ALTER TABLE mac_track_device_types MODIFY sysDescr_match VARCHAR(25);

However -- I'm not sure what to check for on my 6509!!

Cisco Internetwork Operating System Software IOS (tm) s72033_rp Software (s72033_rp-ADVIPSERVICESK9_WAN-M), Version 12.2(18)SXF7, RELEASE SOFTWARE (fc1) Technical Support: http://www.cisco.com/techsupport Copyright (c) 1986-2006 by cisco Systems, Inc.

ADVIPSERVICESK9_WAN-M ?

-P[/code]

[pbulteel]

Crap that didn't work...

[code]
DEBUG: SQL: UPDATE mac_track_devices SET ports_total='0',device_type_id='0',scan_type = '2',vlans_total='0',ports_active='0',ports_trunk='0',macs_active='0',snmp_readstring='public',snmp_sysName='sw1-lon',snmp_sysLocation='LON1.305B.R51B6',snmp_sysContact='sysadmin@rgmadvisors.com',snmp_sysObjectID='.1.3.6.1.4.1.9.1.516',snmp_sysDescr='Cisco IOS Software, C3750 Software (C3750-IPSERVICES-M), Version 12.2(25)SEB4, RELEASE SOFTWARE (fc1) Copyright (c) 1986-2005 by Cisco Systems, Inc. Compiled Tue 30-Aug-05 15:47 by yenanh',snmp_sysUptime='2886472144',snmp_status='4',last_runmessage='WARNING: Device Type Not Found in Device Type Table.',last_rundate='2007-05-08 12:05:03',last_runduration='26.9437' WHERE device_id ='2'
[/code]

I had to remove the WS- from the C3750-IPSERVICES-M which means that the 6509 won't work either unless I get exactly what's in the description... (i.e. it's not a regex right?)