Polling does not populate interfaces/mac's

[shadowmanr6]

I read through as many posts that seemed similar to my issue but didn't seem to find anything.

We have a Cisco environment and Cacti pulls snmp info appropriately, and when a switch is added to mactrack under a site it shows the snmp header info and the snmp walk objectid for that particular switch but it does not pull any interfaces or mac's. The device will show an 'unknown' for the status and the sites will show 1 'device error'

I've ran several the php commands i've seen in posts, when i do the
'php -q poller_mactrack.php -f -d -sid=1' i receive the following:

[root@fedora1 mactrack]# php -q poller_mactrack.php -f -d -sid=1
DEBUG: About to enter MacTrack Site Scan Processing
DEBUG: CMD: /usr/bin/php -q /var/www/html/cacti/plugins/mactrack/mactrack_scanner.php -id=1 -d
04/16/2010 12:51:06 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /var/www/html/cacti/plugins/mactrack/mactrack_scanner.php -id=1 -d]
DEBUG: A process cycle launch just completed.
DEBUG: Interum IP addresses to MAC addresses association pass complete.
DEBUG: MAC addresses to Vendor MACS association pass complete.
DEBUG: MAC VLAN's in VLAN Table Updated.
DEBUG: Finished transferring scan results to main table.
DEBUG: Finished updating site table with collection statistics.

As for 'php -q mactrack_scanner.php -d -id=1 ' i get the following:

[root@fedora1 mactrack]# php -q mactrack_scanner.php -d -id=1 DEBUG: ERROR: No device types have been found.

I'm not sure if there is something i'm overlooking for setting up devices or sites?

Any help is appreciate, thank you!

[TheWitness]

Goto Device Types and Press the "Rescan" button. From there you need to find the proper scanning function for your device. With regard to the SysDecription match, you should make that as short as possible while remaining unique. So, edit the device types once they are scanned into the system.

TheWitness

[shadowmanr6]

awesome that lead me into the right direction of what i was missing, thanks for the extra push! awesome program thanks!

[shadowmanr6]

sorry to bug again, 1 last issue i'm encountering is the interfaces tab isn't populating, it displays 'No Scanner Devices Found', it's pulling macs/ips/etc and all my device types seem to be set appropriately, anything special for the interfaces tab to work?

Thanks in advance!

[TheWitness]

Run:

Code: Select all

select count(*) from mac_track_interfaces;

What's in you cacti.log?

TheWitness

[shadowmanr6]

Ok i went to check for that table and it actually had never been created, so grabbed from ur .sql and put it in, now that it was in it still was not generating and gave a value of 0 for the select count.

Checking the cacti logs i get the following:

04/17/2010 11:53:42 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1054', SQL:"UPDATE mac_track_interfaces ...... which it does for each device id, followed by afew lines of what looks to be the interfaces info.

Any ideas?

[shadowmanr6]

just found a post here http://forums.cacti.net/about36142.html referring to this same issue, reading through and seeing what i can get now.

[shadowmanr6]

So the install/enable through pia wasn't creating the mac_track_interfaces table...

so checked the mactrack.sql and this didn't contain all the necessary columns...

so checked setup.php which contained all the appropriate columns, but is missing 2 commas when creating a new table after ifMauAutoNegAdminStatus and ifMauAutoNegRemoteSignaling:

`ifDuplex` int(10) unsigned NOT NULL default '0',
`ifMauAutoNegAdminStatus` integer UNSIGNED NOT NULL default '0'
`ifMauAutoNegRemoteSignaling` integer UNSIGNED NOT NULL default '0'


was able to just steal the needed columns from there and create, now my interfaces are showing.

Next thing to fix is my damn 4x stack 3750's that doesn't wanna play nice, thanks for pointing me in the right direction sir!