<html theme="themeKey88rand710" iconset="monochrome"><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head><body text="#000000">Vladimir,<br>
<br>
just to make sure we're all on the same page:<br>
<br>
1. The update-l2database.pl script is only for "Discovered" and not
"Configured" MAC addresses. The distinction is explained here:<br>
<br>
<a class="moz-txt-link-freetext" href="https://docs.ixpmanager.org/features/layer2-addresses/">https://docs.ixpmanager.org/features/layer2-addresses/</a><br>
<br>
On a modern IX you would ideally be using configured MAC addresses with
static l2 acls on members ports to match these (either automation or
manually). <br>
<br>
2. Your ixpmanager.conf file should have the following for discovered mac
addresses:<br>
<br>
macdbtype = discovered<br>
<br>
Can you share your ixpmanager.conf file with passwords removed?<br>
<br>
3. It's critical MySQL works. Have you manually verified MySQL access
from the command line with the params as set in your ixpmanager.conf
file?<br>
<br>
mysql -h xxx -u xxx -pxxx xxx<br>
<br>
<br>
4. The update-l2database.pl script is one of the older legacy elements
of IXP Manager. It's also probably the last thing that requires the SQL
views to be in place. See:<br>
<br>
<a class="moz-txt-link-freetext" href="https://docs.ixpmanager.org/install/manually/#database-setup">https://docs.ixpmanager.org/install/manually/#database-setup</a> under "Some
older scripts still rely on MySQL view tables. Create these with:"<br>
<br>
Then check this manually in your database and ensure this SQL command
returns data:<br>
<br>
SELECT id, switchport, switchportid, spifname, switch, switchhostname,
status, infrastructure, virtualinterfacename FROM
view_switch_details_by_custid;<br>
<br>
<br>
5. There does not seem to be any action at the end of your debug output
indicating inserting SQL. Line 168 in the script for example which would
look like:<br>
<br>
INSERT: 001122334455 -> switch1.example.com:swp42<br>
<br>
<br>
6. The last output line for you is from line 147 where it dumps the
ports. I note that the ports in your output have nothing in common with
the ports where MAC addresses were found (i.e. the intersection of
$l2mapping and $ports has nothing in common. This may be the issue. Have
you the ports set up correctly in IXP Manager and do they match the
ports on the switch? IXP Manager is uninterested in any ports other than
those configured as member peering ports.<br>
<br>
7. It also doesn't seem to be able to read switch2 and switch3 but it
can switch1? What's the difference here? Maybe just no ports in use?<br>
<br>
- Barry<br>
<br>
<br>
vladimir franciz blando wrote on 17/09/2021 07:56:<br>
<blockquote type="cite"
cite="mid:CALZCvArKOs+-81GF0i2xYWEye1QJSeHHRPe09mbuXJqqEwZrCA@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<div dir="ltr">What do you think Nick? <div><br clear="all"><div><div
dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div
dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div>Regards,</div><div><br></div><div>Vladimir
Blando</div></div></div></div></div></div></div></div><br></div></div>
<br>
<div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Aug
26, 2021 at 4:18 PM vladimir franciz blando <<a
href="mailto:vladimir.blando@gmail.com" moz-do-not-send="true">vladimir.blando@gmail.com</a>>
wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px
0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div
dir="ltr">Hi Nick,<div><br></div><div>Here's the complete and update
output <a href="https://paste.opendev.org/show/b40QzDqQz90uuvqU5d5c/"
target="_blank" moz-do-not-send="true">https://paste.opendev.org/show/b40QzDqQz90uuvqU5d5c/</a></div><div><br
clear="all"><div><div dir="ltr"><div dir="ltr"><div><div dir="ltr"><div><div
dir="ltr"><div>Regards,</div><div><br></div><div>Vladimir Blando</div></div></div></div></div></div></div></div><br></div></div><br><div
class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Aug 24,
2021 at 11:57 PM Nick Hilliard <<a href="mailto:nick@foobar.org"
target="_blank" moz-do-not-send="true">nick@foobar.org</a>> wrote:<br></div><blockquote
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px
solid rgb(204,204,204);padding-left:1ex"><div
style="font-family:Calibri;font-size:14px"><div
style="font-size:14px;font-family:Calibri">Hi
Vladimir,<br><br>this doesn't match the pastebin output you provided
from a couple of weeks ago. Can you provide output from the two of them
taken at the same time?<br><br>Nick<br><span>
</span><br>vladimir franciz blando wrote on 24/08/2021 07:59:<blockquote
type="cite"><div dir="ltr">Hi Nick,<div><br></div><div>Here's the
output from the 3 switches.</div><div><br></div><div>switch1</div><div>---</div><div>show
ethernet-switching table vlan 800 <br>Ethernet-switching table: 7
unicast entries<br> VLAN MAC address Type
Age Interfaces<br> v800-ixp-lan1 * Flood -
All-members<br> v800-ixp-lan1 18:2a:d3:6f:fa:e8 Learn 0 ae11.0<br>
v800-ixp-lan1 80:71:1f:14:0f:cc Learn 0 ae12.0<br>
v800-ixp-lan1 a6:b0:8c:65:e8:90 Learn 0 xe-0/0/13.0<br>
v800-ixp-lan1 d4:af:f7:c5:ef:7d Learn 0 ae3.0<br>
v800-ixp-lan1 d4:af:f7:c5:ef:e8 Learn 0 ae3.0<br>
v800-ixp-lan1 d4:af:f7:c5:ef:f8 Learn 0 ae3.0<br>
v800-ixp-lan1 ee:71:92:73:f9:49 Learn 0 xe-1/0/11.0<br></div><div>---</div><div><br></div><div>switch
2</div><div>---</div><div>show ethernet-switching table vlan 800 <br>Ethernet-switching
table: 0 unicast entries<br> VLAN MAC address Type
Age Interfaces<br> v800-ixp-lan1 * Flood
- All-members<br></div><div>---</div><div><br></div><div>switch 3</div><div>---</div><div>show
ethernet-switching table vlan 800 <br>Ethernet-switching table: 1
unicast entries<br> VLAN MAC address Type
Age Interfaces<br> v800-ixp-lan1 * Flood -
All-members<br> v800-ixp-lan1 ee:71:92:73:f9:49 Learn 0
xe-0/0/1.0<br></div><div>---</div><div><br></div><div><br clear="all"><div><div
dir="ltr"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div>Regards,</div><div><br></div><div>Vladimir
Blando</div></div></div></div></div></div></div></div><br></div></div><br><div
class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Aug 6,
2021 at 11:16 PM Nick Hilliard <<a href="mailto:nick@foobar.org"
target="_blank" moz-do-not-send="true">nick@foobar.org</a>>
wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px
0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">vladimir
franciz blando wrote on 27/07/2021 14:41:<br>
> Hi Nick,<br>
> <br>
> #1 I did specify the VLAN ID, here's the sample output <br>
> <a href="https://paste.opendev.org/show/bbgUwfiVBD0ZTy8H71pr/"
rel="noreferrer" target="_blank" moz-do-not-send="true">https://paste.opendev.org/show/bbgUwfiVBD0ZTy8H71pr/</a><br>
<br>
that looks odd. Can you post the output of "show ethernet-switching <br>
table" on the switch?<br>
<br>
Nick<br>
<br></blockquote></div>
<br><fieldset></fieldset><br><pre>_______________________________________________
INEX IXP Manager mailing list
<a href="mailto:ixpmanager@inex.ie" target="_blank" moz-do-not-send="true">ixpmanager@inex.ie</a>
Unsubscribe or change options here: <a href="https://www.inex.ie/mailman/listinfo/ixpmanager" target="_blank" moz-do-not-send="true">https://www.inex.ie/mailman/listinfo/ixpmanager</a>
</pre></blockquote><br></div></div></blockquote></div></blockquote></div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
INEX IXP Manager mailing list
<a class="moz-txt-link-abbreviated" href="mailto:ixpmanager@inex.ie">ixpmanager@inex.ie</a>
Unsubscribe or change options here: <a class="moz-txt-link-freetext" href="https://www.inex.ie/mailman/listinfo/ixpmanager">https://www.inex.ie/mailman/listinfo/ixpmanager</a>
</pre>
</blockquote>
<br>
<div class="moz-signature">-- <br><br>
Kind regards,
<br>
Barry O'Donovan
<br>
INEX <br>
<br>
<a class="moz-txt-link-freetext" href="https://www.inex.ie/support/">https://www.inex.ie/support/</a>
<br>
+353 1 531 3339<br>
<br>
<br>
</div>
</body></html>