<div dir="ltr">This definitely seems to be the issue. <div><br></div><div>The <span style="background-color:transparent;font-family:Consolas,'Liberation Mono',Courier,monospace;font-size:12px;color:rgb(51,51,51);line-height:19px">/bin/ixptool.php -a switch-cli.snmp-poll script is loading the database with layer 2 interface. (i.e. with out the .0 in the name) and </span></div>
<div><span style="background-color:transparent;font-family:Consolas,'Liberation Mono',Courier,monospace;font-size:12px;color:rgb(51,51,51);line-height:19px">The </span><font color="#333333" face="Consolas, Liberation Mono, Courier, monospace"><span style="font-size:12.222222328186035px;line-height:18.99305534362793px">bin/<a href="http://update-l2database-test.pl">update-l2database-test.pl</a> --debug --vlan 998 script is showing the macaddresses on the layer 3 interfaces.</span></font></div>
<div><font color="#333333" face="Consolas, Liberation Mono, Courier, monospace"><span style="font-size:12.222222328186035px;line-height:18.99305534362793px"><br></span></font></div><div><font color="#333333" face="Consolas, Liberation Mono, Courier, monospace"><span style="font-size:12.222222328186035px;line-height:18.99305534362793px"><div>
root@portal:~# perl /usr/local/bin/<a href="http://update-l2database-test.pl">update-l2database-test.pl</a> --debug --vlan 998</div><div>DEBUG: processing ex4500</div><div>DEBUG: attempting to retrieve dot1qVlanFdbId mapping (.1.3.6.1.2.1.17.7.1.4.2.1.3) on ex4500</div>
<div>DEBUG: that didn't work. let's try Juniper EX jnxExVlanTag mapping instead (.1.3.6.1.4.1.2636.3.40.1.5.1.5.1.5) on ex4500</div><div>DEBUG: attempting Q-BRIDGE-MIB (.1.3.6.1.2.1.17.7.1.2.2.1.2.2) on ex4500</div>
<div>$l2mapping = {</div><div> 'ex4500' => {</div><div> 'ge-0/0/39.0' => [</div><div> '00d02b194100'</div><div> ],</div>
<div> 'ge-0/0/19.0' => [</div><div> '00500b38b419'</div><div> ],</div><div> 'ge-0/0/2.0' => [</div>
<div> '5c5eabdc7e79'</div><div> ],</div><div> 'ge-0/1/1.0' => [</div><div> '5c5eabd24278'</div>
<div>and</div><div><br></div><div><div>$ports = {</div><div> 'ex4500' => {</div><div> 'xe-0/0/26' => {</div><div> 'switchportid' => '10',</div>
<div> 'infrastructure' => '1',</div><div> 'status' => '1',</div><div> 'switch' => 'ex4500',</div>
<div> 'switchport' => 'xe-0/0/26',</div><div> 'spifname' => 'xe-0/0/26',</div><div> 'id' => '25'</div>
<div> },</div><div> 'ge-0/0/25' => {</div><div> 'switchportid' => '21',</div><div> 'infrastructure' => '1',</div>
<div> 'status' => '1',</div><div> 'switch' => 'ex4500',</div><div> 'switchport' => 'ge-0/0/25',</div>
<div> 'spifname' => 'ge-0/0/25',</div><div> 'id' => '24'</div><div> },</div>
<div> 'xe-0/0/0' => {</div><div> 'switchportid' => '5',</div><div> 'infrastructure' => '1',</div>
<div> 'status' => '1',</div><div> 'switch' => 'ex4500',</div><div> 'switchport' => 'xe-0/0/0',</div>
<div> 'spifname' => 'xe-0/0/0',</div><div> 'id' => '2'</div><div> },</div>
</div><div><br></div><div><br></div><div><div>mysql> desc switchport;</div><div>+---------------+--------------+------+-----+---------+----------------+</div><div>| Field | Type | Null | Key | Default | Extra |</div>
<div>+---------------+--------------+------+-----+---------+----------------+</div><div>| id | int(11) | NO | PRI | NULL | auto_increment |</div><div>| switchid | int(11) | YES | MUL | NULL | |</div>
<div>| type | int(11) | YES | | NULL | |</div><div>| name | varchar(255) | YES | | NULL | |</div><div>| active | tinyint(1) | NO | | NULL | |</div>
<div>| ifIndex | int(11) | YES | | NULL | |</div><div>| ifName | varchar(255) | YES | | NULL | |</div><div>| ifAlias | varchar(255) | YES | | NULL | |</div>
<div>| ifHighSpeed | int(11) | YES | | NULL | |</div><div>| ifMtu | int(11) | YES | | NULL | |</div><div>| ifPhysAddress | varchar(17) | YES | | NULL | |</div>
<div>| ifAdminStatus | int(11) | YES | | NULL | |</div><div>| ifOperStatus | int(11) | YES | | NULL | |</div><div>| ifLastChange | int(11) | YES | | NULL | |</div>
<div>| lastSnmpPoll | datetime | YES | | NULL | |</div><div>| lagIfIndex | int(11) | YES | | NULL | |</div><div>+---------------+--------------+------+-----+---------+----------------+</div>
<div>16 rows in set (0.03 sec)</div></div><div><br></div><div><br></div><div><div>+----+----------+------+-----------+--------+---------+-----------+---------------------------------------------+-------------+-------+---------------+---------------+--------------+--------------+---------------------+------------+</div>
<div>| id | switchid | type | name | active | ifIndex | ifName | ifAlias | ifHighSpeed | ifMtu | ifPhysAddress | ifAdminStatus | ifOperStatus | ifLastChange | lastSnmpPoll | lagIfIndex |</div>
<div>+----+----------+------+-----------+--------+---------+-----------+---------------------------------------------+-------------+-------+---------------+---------------+--------------+--------------+---------------------+------------+</div>
<div>| 1 | 1 | 0 | me0 | 1 | 33 | me0 | | 1000 | 1514 | 50C58DA83582 | 1 | 1 | 1378257361 | 2013-09-25 18:51:24 | NULL |</div>
<div>| 2 | 1 | 0 | vme | 1 | 35 | vme | | 1000 | 1518 | 50C58DA83582 | 1 | 1 | 1378257361 | 2013-09-25 18:51:24 | NULL |</div>
<div>| 3 | 1 | 0 | bme0 | 1 | 37 | bme0 | | 0 | 1576 | 000BCAFE0000 | 1 | 1 | 0 | 2013-09-25 18:51:24 | NULL |</div>
<div>| 4 | 1 | 0 | vlan | 1 | 503 | vlan | | 1000 | 1518 | 50C58DA83581 | 1 | 1 | 0 | 2013-09-25 18:51:24 | NULL |</div>
<div>| 5 | 1 | 1 | xe-0/0/0 | 1 | 504 | xe-0/0/0 | xxxxx xe-0/3/0 | 10000 | 1518 | 50C58DA83583 | 1 | 1 | 1377849038 | 2013-09-25 18:51:25 | NULL |</div>
<div>| 6 | 1 | 1 | ge-0/1/3 | 1 | 508 | ge-0/1/3 | xxxxxxxxxxx | 1000 | 1514 | 50C58DA835AE | 1 | 2 | 1378256790 | 2013-09-25 18:51:25 | NULL |</div>
<div>| 7 | 1 | 1 | xe-0/0/4 | 1 | 512 | xe-0/0/4 | xxxxxxxxxxxx | 10000 | 1514 | 50C58DA83587 | 1 | 1 | 1377849039 | 2013-09-25 18:51:25 | NULL |</div>
<div>| 8 | 1 | 1 | xe-0/0/16 | 1 | 536 | xe-0/0/16 | xxxxxxxxxxxx | 10000 | 1514 | 50C58DA83593 | 1 |</div></div></span></font></div></div><div class="gmail_extra">
<br clear="all"><div><strong style="font-family:'Lucida Grande',Verdana,Arial,sans-serif;font-size:12px;line-height:16px;color:rgb(136,136,136)">Brian Thompson</strong><br><span style="color:rgb(0,102,51);font-family:'Lucida Grande',Verdana,Arial,sans-serif;font-size:12px;line-height:16px">Senior Infrastructure Engineer // Senior Second Guesser</span><br>
<font color="#666666" face="Lucida Grande, Verdana, Arial, sans-serif"><span style="font-size:12px;line-height:15px"><br></span></font><span style="color:rgb(102,102,102);font-family:'Lucida Grande',Verdana,Arial,sans-serif;font-size:12px;line-height:16px">Direct: </span><a value="+15039436742" style="font-family:'Lucida Grande',Verdana,Arial,sans-serif;font-size:12px;line-height:16px;color:rgb(17,85,204)">503.943.6779</a><br>
<span style="color:rgb(102,102,102);font-family:'Lucida Grande',Verdana,Arial,sans-serif;font-size:12px;line-height:16px">Mobile: </span><a value="+15033196955" style="font-family:'Lucida Grande',Verdana,Arial,sans-serif;font-size:12px;line-height:16px;color:rgb(17,85,204)">503.707.9018</a><span style="color:rgb(102,102,102);font-family:'Lucida Grande',Verdana,Arial,sans-serif;font-size:12px;line-height:16px"> // Twitter: iovation</span><br>
<strong style="color:rgb(0,102,51);font-family:'Lucida Grande',Verdana,Arial,sans-serif;font-size:12px;line-height:16px"><a href="http://www.iovation.com/" title="Visit iovation.com" style="color:rgb(0,102,51);text-decoration:none;border-bottom-width:0px;border-bottom-style:initial;border-bottom-color:initial" target="_blank">www.iovation.com</a></strong><br>
<font color="#006633" face="Lucida Grande, Verdana, Arial, sans-serif"><span style="font-size:12px;line-height:15px"><br></span></font><span><font color="#888888"><div><font color="#006633" face="'Lucida Grande', Verdana, Arial, sans-serif"><span style="font-size:12px;line-height:16px"><img src="http://www.iovation.com/images/signature/eml_sig_mobilefraud.gif"></span></font></div>
</font></span></div>
<br><br><div class="gmail_quote">On Wed, Sep 25, 2013 at 2:45 AM, Barry O'Donovan <span dir="ltr"><<a href="mailto:barry.odonovan@inex.ie" target="_blank">barry.odonovan@inex.ie</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="im"><br>
<br>
On 25/09/13 10:43, Barry O'Donovan wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Note that the database now also records the ifIndex of ports (and other<br>
additional info - see below)<br>
</blockquote>
<br></div>
Opps... quoted the wrong table. Here's switchport:<br>
<br>
MariaDB [inex]> desc switchport;<br>
+---------------+-------------<u></u>-+<br>
| Field | Type |<br>
+---------------+-------------<u></u>-+<br>
| id | int(11) |<br>
| switchid | int(11) |<br>
| type | int(11) |<br>
| name | varchar(255) |<br>
| ifName | varchar(255) |<br>
| ifAlias | varchar(255) |<br>
| ifHighSpeed | int(11) |<br>
| ifMtu | int(11) |<br>
| ifPhysAddress | varchar(17) |<br>
| ifAdminStatus | int(11) |<br>
| ifOperStatus | int(11) |<br>
| ifLastChange | int(11) |<br>
| lastSnmpPoll | datetime |<br>
| ifIndex | int(11) |<br>
| active | tinyint(1) |<br>
| lagIfIndex | int(11) |<br>
+---------------+-------------<u></u>-+<br>
16 rows in set (0.00 sec)<span class="HOEnZb"><font color="#888888"><br>
<br>
<br>
- Barry</font></span><div class="HOEnZb"><div class="h5"><br>
<br>
<br>
______________________________<u></u>_________________<br>
INEX IXP Manager mailing list<br>
<a href="mailto:ixpmanager@inex.ie" target="_blank">ixpmanager@inex.ie</a><br>
<a href="https://www.inex.ie/mailman/listinfo/ixpmanager" target="_blank">https://www.inex.ie/mailman/<u></u>listinfo/ixpmanager</a><br>
</div></div></blockquote></div><br></div>