[ixpmanager] update-l2database.pl not updating database

[Nick Hilliard]

On 25/09/2013 04:09, Brian Thompson wrote:
> perl /usr/local/bin/update-l2database-test.pl --debug --vlan 998 --do-nothing
> 
> Completes with no errors, although it does not populate the macaddress
> table in mysql.
> 
> Removing the --do-nothing does not have an effect.

Hi Brian,

If you run update-l2database-test.pl with the --debug option, the last of
the output should be a list of the MAC addresses which are assigned to each
port.  It should look something like:

INSERT: 001824663b80 -> switch1:GigabitEthernet7
INSERT: 001b0dac3670 -> switch3:GigabitEthernet2

etc.

If you're not seeing this, then probably there is a mismatch between the
switch port names in the database and the switch port interfaces that are
being picked up via SNMP.

The --debug option dumps out two data structures: $l2mapping is what's
picked up from the switch and is a list of all the MAC addresses picked up
on each port, keyed on the name of the port.  $ports is a list of ports
from the database, keyed on the name of the port.  The two key names should
match for each switch. If they don't, there is a problem.

JUNOS can be a bit funny about interface names (e.g. ge-0/0/1 vs
ge-0/0/1.0), and there is a good degree of scope for interpretation in the
various MIBs.

Nick