(Not quite solved)Macktrack is not retriving any data

Palermo · Post by **Palermo** » Fri Sep 19, 2008 1:00 am

Hi i have some probles with macktrack
I think this is a realy good and helpfull tool

let me show you what is did.

Mactrack 1.1 comes with CactiEz version 0.4

Somehow the manual in the mactrack folder is nog working well.

i found a kind of manual in cacti forum.

These are the steps i took

cd mactrack
[root@localhost mactrack]#

[root@localhost mactrack]# mysql cacti < mactrack.sql
ERROR 1050 (42S01) at line 19: Table 'mac_track_approved_macs' already exists
[root@localhost mactrack]#
# somehow this database already existing is the SQL-database

# The next commando seems to work with no error.
[root@localhost mactrack]# mysql cacti < mactrack.sql.0.0.1
[root@localhost mactrack]#

# the next commando triggers a lots of actions
[root@mvdcnln001 mactrack]# php database_upgrade.php
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> snmp_timeout, Ok
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> snmp_retries, Ok
SUCCESS: Add Column, Table -> mac_track_ports, Column -> dns_hostname, Already Exists!
SUCCESS: Add Column, Table -> mac_track_temp_ports, Column -> dns_hostname, Already Exists!
SUCCESS: Add Column, Table -> mac_track_ips, Column -> dns_hostname, Already Exists!
SUCCESS: Add Column, Table -> mac_track_devices, Column -> snmp_port, Already Exists!
SUCCESS: Add Column, Table -> mac_track_devices, Column -> macs_active, Already Exists!
SUCCESS: Add Column, Table -> mac_track_devices, Column -> snmp_sysName, Already Exists!
SUCCESS: Add Column, Table -> mac_track_devices, Column -> snmp_sysLocation, Already Exists!
SUCCESS: Add Column, Table -> mac_track_devices, Column -> snmp_sysContact, Already Exists!
SUCCESS: Create Table, Table -> mac_track_scanning_functions, Already Exists!
SUCCESS: Execute SQL, Change Primary Key For 'mac_track_devices', Ok
SUCCESS: Add Index, Table -> mac_track_devices, Index -> device_id, Already Exists!
SUCCESS: Add Column, Table -> mac_track_sites, Column -> total_oper_ports, Already Exists!
SUCCESS: Execute SQL, Change Primary Key For 'mac_track_device_types', Ok
SUCCESS: Add Index, Table -> mac_track_device_types, Index -> device_type_id, Already Exists!
SUCCESS: Modify Column, Table -> mac_track_scanning_functions, Column -> scanning_function, Ok
SUCCESS: Modify Column, Table -> mac_track_scanning_functions, Column -> description, Ok
SUCCESS: Create Table, Table -> mac_track_scan_dates, Already Exists!
SUCCESS: Execute SQL, Addition of Scan Dates, Ok
SUCCESS: Add Index, Table -> mac_track_devices, Index -> snmp_sysDescr, Already Exists!
SUCCESS: Add Index, Table -> mac_track_devices, Index -> snmp_sysObjectID, Already Exists!
SUCCESS: Add Column, Table -> mac_track_devices, Column -> device_type_id, Already Exists!
SUCCESS: Add Index, Table -> mac_track_devices, Index -> device_type_id, Already Exists!
SUCCESS: Add Index, Table -> mac_track_ports, Index -> port_name, Already Exists!
SUCCESS: Add Index, Table -> mac_track_ports, Index -> dns_hostname, Already Exists!
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> ips_total, Ok
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> vlans_total, Ok
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> ports_total, Ok
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> ports_active, Ok
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> ports_trunk, Ok
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> macs_active, Ok
SUCCESS: Add Column, Table -> mac_track_temp_ports, Column -> updated, Already Exists!
SUCCESS: Add Index, Table -> mac_track_temp_ports, Index -> updated, Already Exists!
SUCCESS: Add Index, Table -> mac_track_temp_ports, Index -> ip_address, Already Exists!
SUCCESS: Create Table, Table -> mac_track_ip_ranges, Already Exists!
SUCCESS: Add Column, Table -> mac_track_ip_ranges, Column -> ips_max_date, Already Exists!
SUCCESS: Add Column, Table -> mac_track_ip_ranges, Column -> ips_current_date, Ok
SUCCESS: Add Column, Table -> mac_track_processes, Column -> device_id, Already Exists!
SUCCESS: Add Column, Table -> mac_track_processes, Column -> process_id, Already Exists!
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> snmp_readstring, Ok
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> snmp_readstrings, Ok
SUCCESS: Execute SQL, Change mac_track_temp_ports to Memory Table, Ok
SUCCESS: Execute SQL, Change mac_track_ips to Memory Table, Ok
SUCCESS: Create Table, Table -> mac_track_approved_macs, Already Exists!
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> ignorePorts, Ok
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> snmp_readstring, Ok
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> snmp_readstrings, Ok
SUCCESS: Create Table, Table -> mac_track_oui_database, Already Exists!
SUCCESS: Add Column, Table -> mac_track_ports, Column -> vendor_mac, Ok
SUCCESS: Add Index, Table -> mac_track_ports, Index -> vendor_mac, Ok
SUCCESS: Add Column, Table -> mac_track_temp_ports, Column -> vendor_mac, Ok
SUCCESS: Add Index, Table -> mac_track_temp_ports, Index -> vendor_mac, Ok
SUCCESS: Execute SQL, Add Vendor Macs To 'mac_track_ports', Ok
SUCCESS: Execute SQL, Add Vendor Macs To 'mac_track_temp_ports', Ok
SUCCESS: Add Column, Table -> mac_track_temp_ports, Column -> authorized, Ok
SUCCESS: Add Index, Table -> mac_track_temp_ports, Index -> authorized, Ok
SUCCESS: Add Column, Table -> mac_track_ports, Column -> authorized, Ok
SUCCESS: Add Index, Table -> mac_track_ports, Index -> authorized, Ok
SUCCESS: Create Table, Table -> mac_track_macwatch, Already Exists!
SUCCESS: Create Table, Table -> mac_track_macauth, Already Exists!
SUCCESS: Create Table, Table -> mac_track_vlans, Already Exists!
SUCCESS: Execute SQL, Add VLANS to VLAN Table, Ok
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> description, Ok
SUCCESS: Add Column, Table -> mac_track_devices, Column -> device_name, Ok
SUCCESS: Add Index, Table -> mac_track_devices, Index -> device_name, Ok
SUCCESS: Add Column, Table -> mac_track_sites, Column -> customer_contact, Ok
SUCCESS: Add Column, Table -> mac_track_sites, Column -> netops_contact, Ok
SUCCESS: Add Column, Table -> mac_track_sites, Column -> facilities_contact, Ok
SUCCESS: Add Column, Table -> mac_track_sites, Column -> site_info, Ok
SUCCESS: Add Column, Table -> mac_track_device_types, Column -> serial_number_oid, Ok
SUCCESS: Execute SQL, Move Device Names from the 'description' field to the 'device_name' field., Ok
SUCCESS: Execute SQL, Blank out the 'description' field as it will now be used for something else, Ok
SUCCESS: Add Column, Table -> mac_track_macwatch, Column -> email_addresses, Already Exists!
SUCCESS: Add Column, Table -> mac_track_macwatch, Column -> mac_id, Already Exists!
SUCCESS: Add Column, Table -> mac_track_macwatch, Column -> date_last_seen, Already Exists!
SUCCESS: Add Column, Table -> mac_track_macauth, Column -> mac_id, Already Exists!
SUCCESS: Add Column, Table -> mac_track_ports, Column -> device_name, Ok
SUCCESS: Add Column, Table -> mac_track_temp_ports, Column -> device_name, Ok
SUCCESS: Add Column, Table -> mac_track_devices, Column -> notes, Ok
SUCCESS: Modify Column, Table -> mac_track_ips, Column -> description, Ok
SUCCESS: Delete Column, Table -> mac_track_devices, Column -> serial_number, Column Does NOT Exist!
SUCCESS: Delete Column, Table -> mac_track_devices, Column -> asset_id, Column Does NOT Exist!
SUCCESS: Create Table, Table -> mac_track_interfaces, Already Exists!
SUCCESS: Add Column, Table -> mac_track_scanning_functions, Column -> type, Ok
SUCCESS: Add Column, Table -> mac_track_device_types, Column -> ip_scanning_function, Ok
SUCCESS: Execute SQL, Update the Scanning Function Type to 'Mac' for undefined types, Ok
SUCCESS: Execute SQL, Set the IP Scanning function to N/A for Device Type 1, Ok
SUCCESS: Execute SQL, Set the IP Scanning function to 'get_standard_arp_table' for Routers and L3 Switches, Ok
SUCCESS: Add Column, Table -> mac_track_interfaces, Column -> vlan_trunk, Already Exists!
SUCCESS: Add Column, Table -> mac_track_devices, Column -> user_name, Ok
SUCCESS: Add Column, Table -> mac_track_devices, Column -> user_password, Ok

Updating Device Types in Devices Table. Please be patient.

Device Types Updated, You have '0' Good Device Type Mapping and '0' Bad Device Type Mapping.
If the Bad Device type mapping is greater than '0', you should inspect your devices for unmapped device types.

Importing the Vendor MAC Address Table from the IEEE

PHP Notice: Undefined variable: oui_file in /var/www/html/plugins/mactrack/mactrack_import_ouidb.php on line 70

Notice: Undefined variable: oui_file in /var/www/html/plugins/mactrack/mactrack_import_ouidb.php on line 70
Getting OUI Database from the IEEE
PHP Warning: file(): php_network_getaddresses: getaddrinfo failed: Name or service not known in /var/www/html/plugins/mactrack/lib/mactrack_functions.php on line 1576

Warning: file(): php_network_getaddresses: getaddrinfo failed: Name or service not known in /var/www/html/plugins/mactrack/lib/mactrack_functions.php on line 1576
PHP Warning: file(http://standards.ieee.org/regauth/oui/oui.txt): failed to open stream: Success in /var/www/html/plugins/mactrack/lib/mactrack_functions.php on line 1576

Warning: file(http://standards.ieee.org/regauth/oui/oui.txt): failed to open stream: Success in /var/www/html/plugins/mactrack/lib/mactrack_functions.php on line 1576
OUI Database Download from IEEE Complete
PHP Warning: Invalid argument supplied for foreach() in /var/www/html/plugins/mactrack/lib/mactrack_functions.php on line 1600

Warning: Invalid argument supplied for foreach() in /var/www/html/plugins/mactrack/lib/mactrack_functions.php on line 1600

There were '0' Entries Added/Updated in the database.
There were '0' Records Removed from the database.

Database Upgrade Complete
[root@localhost mactrack]#

It gave som errors in the end. Could there be the problem?

Then i tryd the next commando

Code: Select all

[root@localhost ~]# php /var/www/html/plugins/mactrack/mactrack_scanner.php  -d
PHP Notice:  Undefined variable: device_id in /var/www/html/plugins/mactrack/mactrack_scanner.php on line 108

Notice: Undefined variable: device_id in /var/www/html/plugins/mactrack/mactrack_scanner.php on line 108
PHP Notice:  Undefined variable: device_id in /var/www/html/plugins/mactrack/mactrack_scanner.php on line 112

Notice: Undefined variable: device_id in /var/www/html/plugins/mactrack/mactrack_scanner.php on line 112
PHP Notice:  Undefined variable: device_id in /var/www/html/plugins/mactrack/mactrack_scanner.php on line 114

Notice: Undefined variable: device_id in /var/www/html/plugins/mactrack/mactrack_scanner.php on line 114
DEBUG: ERROR: Device with Id of '' not found in database.  Can not continue.
PHP Notice:  Undefined variable: device_id in /var/www/html/plugins/mactrack/mactrack_scanner.php on line 115

Notice: Undefined variable: device_id in /var/www/html/plugins/mactrack/mactrack_scanner.php on line 115
[root@localhost ~]#

Maybe someone recognises this problem?
Or any sugestions?

Post by **TheWitness** » Fri Sep 19, 2008 6:16 am

The first error is likely due to you not having direct www access to the OUI database at the IEEE. The second is because you need to specify a device id when running the scanner.

TheWitness

Palermo · Post by **Palermo** » Fri Sep 19, 2008 7:15 am

Hmm that is strange i do have an inter connection.

I already downloaded al kinds of stuff.
Can i put is in manualy?

How can i determine a device ID

123ralle · Post by **123ralle** » Fri Sep 19, 2008 10:26 am

Hi,

use something like this :

php /var/www/html/plugins/mactrack/mactrack_scanner.php -id=26 -d

Where 26 is the device id for your device you would like to scan.

You can get the device id, if you edit a mactrack device and look at the url, which should like this :

XXX/cacti/plugins/mactrack/mactrack_devices.php?action=edit&device_id=26

Ralf

BTW: Great plugin, thx to all contributors.

Palermo · Post by **Palermo** » Fri Sep 19, 2008 1:03 pm

Hi 123ralle

I don't have only 2 devices enterd in cacti so gues device ID 1 shout be correct
í ran the link you gave

Code: Select all


[root@localhost ~]# php /var/www/html/plugins/mactrack/mactrack_scanner.php -id=1 -d 
DEBUG: HOST: xXX.XXX.XXX.11 is alive, processing has begun.
DEBUG: WARNING: SITE: Nijmegen , IP: xXX.XXX.XXX.11, TYPE: Cisco Internetwork Operating System Soft, Device Type Not Found in Device Type Table.
DEBUG: WARNING: SITE: Nijmegen , IP: xXX.XXX.XXX.11, TYPE: Cisco Internetwork Operating System Soft, Device Type Not Found in Device Type Table.
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='switchname.wan.ao-srv.net',snmp_sysLocation='',snmp_sysContact='',snmp_sysObjectID='.1.3.6.1.4.1.9.1.310',snmp_sysDescr='Cisco Internetwork Operating System Software   IOS (tm) s72033_rp Software (s72033_rp-ADVIPSERVICESK9_WAN-M), Version 12.2(18)SXF11, RELEASE SOFTWARE (fc1)  Technical Support: http://www.cisco.com/techsupport  Copyright (c) 1986-2007 by cisco Systems, Inc',snmp_sysUptime='1864411579',snmp_status='4',last_runmessage='WARNING: Device Type Not Found in Device Type Table.',last_rundate='2008-09-19 19:22:03',last_runduration='0.0102' WHERE device_id ='1'
[root@localhost ~]#

Looks like that he found something

You can get the device id, if you edit a mactrack device and look at the url, which should like this :

XXX/cacti/plugins/mactrack/mactrack_devices.php?action=edit&device_id=26

I don't understand what you mean with this.

What do have to do with the file "mactrack_devices.php"

Palermo · Post by **Palermo** » Fri Sep 19, 2008 3:32 pm

You can get the device id, if you edit a mactrack device and look at the url, which should like this :

XXX/cacti/plugins/mactrack/mactrack_devices.php?action=edit&device_id=26

Ralf

I manual downloaded the oui file from de web page.
Cop yd the file to a download folder and updated the location in
mactrack_functions.php on line 1576

Code: Select all

function import_oui_database($type = "ui", $oui_file = "/root/downloads/oui.txt")

i ran the php database_upgrade.php again
and the result is much better..

Code: Select all


SUCCESS: Execute SQL,   Set the IP Scanning function to 'get_standard_arp_table' for Routers and L3 Switches, Ok
SUCCESS: Add Column,    Table -> mac_track_interfaces, Column -> vlan_trunk, Already Exists!
SUCCESS: Add Column,    Table -> mac_track_devices, Column -> user_name, Already Exists!
SUCCESS: Add Column,    Table -> mac_track_devices, Column -> user_password, Already Exists!

Updating Device Types in Devices Table.  Please be patient.


Device Types Updated, You have '0' Good Device Type Mapping and '1' Bad Device Type Mapping.
If the Bad Device type mapping is greater than '0', you should inspect your devices for unmapped device types.

Importing the Vendor MAC Address Table from the IEEE

PHP Notice:  Undefined variable: oui_file in /var/www/html/plugins/mactrack/mactrack_import_ouidb.php on line 70

Notice: Undefined variable: oui_file in /var/www/html/plugins/mactrack/mactrack_import_ouidb.php on line 70
Getting OUI Database from the IEEE
OUI Database Download from IEEE Complete
.......................................................................................................................
There were '11880' Entries Added/Updated in the database.
There were '0' Records Removed from the database.

Database Upgrade Complete

still an error on line 70
and still no mac reading in cati...

i don't even know where to look.

123ralle · Post by **123ralle** » Mon Sep 22, 2008 9:21 am

Hi,

your mactrack installation isn't recognizing the device.
Your problem is in detail described here :
[http://forums.cacti.net/viewtopic.php?t ... tion+Match]

But in that thread there is no solution to your problem.

Maybe TheWitness can help you.

Ralf

Palermo · Post by **Palermo** » Tue Sep 23, 2008 1:08 am

Hi 123ralle,

I follow all the forum posts but my problem indeed was not in there.
But some times you must stop take a break.
after a wile in the cantina ideas starting coming up

after all the it had something to do with this: (See picture)

I do have a deferent problem now but I'm gonna look first in the forum an try something..

Thx for listening 123ralle

Vins · Post by **Vins** » Wed Oct 01, 2008 5:39 am

Palermo, your "System description match" cannot be "Cisco"... it must be something similar to

c6sup2_rp-PSV-M

in case of a 6500...
you have to copy here the string that identifies your model, doing a "show version" on Cisco models

have a look here:

http://forums.cacti.net/viewtopic.php?t=29027

Palermo · Post by **Palermo** » Wed Oct 01, 2008 11:18 am

Vins wrote:

Palermo, your "System description match" cannot be "Cisco"... it must be something similar to

c6sup2_rp-PSV-M

in case of a 6500...
you have to copy here the string that identifies your model, doing a "show version" on Cisco models

have a look here:

http://forums.cacti.net/viewtopic.php?t=29027

Hi vins,

If i issue this command:

Code: Select all

php /var/www/html/plugins/mactrack/mactrack_scanner.php -id=1 -d

then i get this error :

Code: Select all

[root@localhost html]# php /var/www/html/plugins/mactrack/mactrack_scanner.php -id=1 -d
DEBUG: HOST: 10.217.128.11 is alive, processing has begun.
DEBUG: WARNING: SITE: Amsterdam (NRW), IP: 10.217.128.11, TYPE: Cisco Internetwork Operating System Soft, Device Type Not Found in Device Type Table.
DEBUG: WARNING: SITE: Amsterdam (NRW), IP: 10.217.128.11, TYPE: Cisco Internetwork Operating System Soft, Device Type Not Found in Device Type Table.
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='switch domain',snmp_sysLocation='',snmp_sysContact='',snmp_sysObjectID='.1.3.6.1.4.1.9.1.310',snmp_sysDescr='Cisco Internetwork Operating System Software   IOS (tm) s72033_rp Software (s72033_rp-ADVIPSERVICESK9_WAN-M), Version 12.2(18)SXF11, RELEASE SOFTWARE (fc1)  Technical Support: http://www.cisco.com/techsupport  Copyright (c) 1986-2007 by cisco Systems, Inc',snmp_sysUptime='1967431991',snmp_status='4',last_runmessage='WARNING: Device Type Not Found in Device Type Table.',last_rundate='',last_runduration='0.0104' WHERE device_id ='1'
[root@localhost html]#

If i i look in the switch with "sh version" i get this:

Code: Select all

switchname#sh ver
Cisco Internetwork Operating System Software 
IOS (tm) s72033_rp Software (s72033_rp-ADVIPSERVICESK9_WAN-M), Version 12.2(18)SXF11, RELEASE SOFTWARE (fc1)

is also works with the name s72033_rp
but i do have a strange different probem i don't see mac adresses and ip adresses. how is that possible ? does it have some thing to do with the name i use or is it a config problem?

This is what is have

Post by **TheWitness** » Wed Oct 01, 2008 7:52 pm

last_runmessage='WARNING: Device Type Not Found in Device Type Table.'

Seems to me this is the problem. I thought there was a bug related to this, and I am sure it was fixed.

TheWitness

Palermo · Post by **Palermo** » Thu Oct 02, 2008 6:03 am

TheWitness wrote:
last_runmessage='WARNING: Device Type Not Found in Device Type Table.'
Seems to me this is the problem. I thought there was a bug related to this, and I am sure it was fixed.

TheWitness

Hi Witness,

The problem is that i don't know what he is looking for..
If i change the hub/switch to switch/router then i have 1728 ip adressen.
But no mac adresses.

end result is after polling is

Code: Select all

DEBUG: HOST: 10.217.128.11, IP address information collection complete
DEBUG: SQL: UPDATE mac_track_devices SET ports_total='0',device_type_id='41',scan_type = '2',vlans_total='261',ports_active='0',ports_trunk='125',macs_active='0',snmp_readstring='public',snmp_sysName='switch sytem',snmp_sysLocation='',snmp_sysContact='',snmp_sysObjectID='.1.3.6.1.4.1.9.1.310',snmp_sysDescr='Cisco Internetwork Operating System Software   IOS (tm) s72033_rp Software (s72033_rp-ADVIPSERVICESK9_WAN-M), Version 12.2(18)SXF11, RELEASE SOFTWARE (fc1)  Technical Support: http://www.cisco.com/techsupport  Copyright (c) 1986-2007 by cisco Systems, Inc',snmp_sysUptime='1973803408',snmp_status='3',last_runmessage='Data collection completed ok.  No active end devices on this device.',last_rundate='',last_runduration='939.4069' WHERE device_id ='1'
[root@localhost /]#

What is the string text for getting mac entry

My be this error has some thing to do with it??

Code: Select all

EBUG: VLAN Analysis for VLAN: number/NameVlan is complete. ACTIVE PORTS: 0
DEBUG: VLAN Analysis for VLAN: number/NameVlan is complete. ACTIVE PORTS: 0
DEBUG: VLAN Analysis for VLAN: number/NameVlan is complete. ACTIVE PORTS: 0
INFO: HOST: 1xx.xxx.xxx.xxx, TYPE: Cisco Internetwork Operating System Soft, No active end devices on this device.DEBUG: Scanning function is 'get_standard_arp_table'  <---------------
DEBUG: atifIndexes data collection complete
DEBUG: atPhysAddress data collection complete
DEBUG: atNetAddress data collection complete
DEBUG: atEntries assembly complete.

Post by **TheWitness** » Thu Oct 02, 2008 6:07 am

Likely due to it being a Router and not a Switch.

TheWitness

Palermo · Post by **Palermo** » Thu Oct 02, 2008 6:27 am

So it is not possible to get the mac addresses for a 6509 with a sup720?

Post by **TheWitness** » Thu Oct 02, 2008 6:35 am

No, it's not a Catalyst OS, it is IOS. All 6509's are not created equal. I think most Cisco 6509's these days are IOS. That is a different Scanning Function. If you alter your device type, you will find Joy.

TheWitness

(Not quite solved)Macktrack is not retriving any data

(Not quite solved)Macktrack is not retriving any data

Who is online