<div style="line-height:1.7;color:#000000;font-size:14px;font-family:Arial"><br><div>Hi,Nick,</div><div>  "<span style="font-family: Calibri; font-size: 14.6667px;">match up the VLAN with the MAC address, according to what is configured in the Configured-MAC database."means to the follow?</span></div><div><span style="font-family: Calibri; font-size: 14.6667px;"><br></span></div><div><span style="color: rgb(255, 0, 0);">mysql> select * from  l2address                        ;</span></div><div><span style="color: rgb(255, 0, 0);">+----+-------------------+--------------+-----------+----------+---------------------+</span></div><div><span style="color: rgb(255, 0, 0);">| id | vlan_interface_id | mac          | firstseen | lastseen | created             |</span></div><div><span style="color: rgb(255, 0, 0);">+----+-------------------+--------------+-----------+----------+---------------------+</span></div><div><span style="color: rgb(255, 0, 0);">|  3 |                 3 | 9c741ae53100 | NULL      | NULL     | 2019-05-23 03:08:58 |</span></div><div><span style="color: rgb(255, 0, 0);">+----+-------------------+--------------+-----------+----------+---------------------+</span></div><div><br></div><div>And the output of VLAN249 is the follow£º</div><div># sflowtool -4 -p 6343 -l |grep 249</div><div><span style="color: rgb(255, 0, 0);">FLOW,106.48.32.41,967,839,883fd3695800,9c741ae53100,0x0800,2009,249,103.237.184.117,101.251.143.60,6,0x00,53,27994,80,0x10,74,52,2048</span></div><div><span style="color: rgb(255, 0, 0);">FLOW,106.48.32.41,967,841,883fd3695800,9c741ae53100,0x0800,2009,249,103.237.184.70,101.251.143.69,6,0x00,52,42964,80,0x10,74,52,2048</span></div><div><br></div><div>the configuration is like :</div><div>VLAN249,ip is 106.48.35.249,mac is <span style="color: rgb(51, 51, 51); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;">9c:74:1a:e5:31:00.</span></div><div><span style="color: rgb(51, 51, 51); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;"><br></span></div><div><table id="table-list" class="table collapse dataTable no-footer" role="grid" aria-describedby="table-list_info" style="box-sizing: border-box; border-spacing: 0px; width: 1303px; clear: both; color: rgb(51, 51, 51); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; max-width: none !important; margin-bottom: 6px !important; margin-top: 6px !important;"><thead style="box-sizing: border-box;"><tr role="row" style="box-sizing: border-box;"><th class="sorting" tabindex="0" aria-controls="table-list" rowspan="1" colspan="1" aria-label="
                                                                                    Customer                                                                            : activate to sort column ascending" style="font-family: arial, verdana, sans-serif; line-height: 1.42857; box-sizing: content-box; padding: 8px 30px 8px 8px; text-align: left; vertical-align: bottom; border-top: 0px; border-bottom: 2px solid rgb(221, 221, 221); cursor: pointer; position: relative;">Customer</th><th class="sorting_asc" tabindex="0" aria-controls="table-list" rowspan="1" colspan="1" aria-sort="ascending" aria-label="
                                                                                    Interface(s)                                                                            : activate to sort column descending" style="font-family: arial, verdana, sans-serif; line-height: 1.42857; box-sizing: content-box; padding: 8px 30px 8px 8px; text-align: left; vertical-align: bottom; border-top: 0px; border-bottom: 2px solid rgb(221, 221, 221); cursor: pointer; position: relative;">Interface(s)</th><th class="sorting" tabindex="0" aria-controls="table-list" rowspan="1" colspan="1" aria-label="
                                                                                    VLAN                                                                            : activate to sort column ascending" style="font-family: arial, verdana, sans-serif; line-height: 1.42857; box-sizing: content-box; padding: 8px 30px 8px 8px; text-align: left; vertical-align: bottom; border-top: 0px; border-bottom: 2px solid rgb(221, 221, 221); cursor: pointer; position: relative;">VLAN</th><th class="sorting" tabindex="0" aria-controls="table-list" rowspan="1" colspan="1" aria-label="
                                                                                    IPv4                                                                            : activate to sort column ascending" style="font-family: arial, verdana, sans-serif; line-height: 1.42857; box-sizing: content-box; padding: 8px 30px 8px 8px; text-align: left; vertical-align: bottom; border-top: 0px; border-bottom: 2px solid rgb(221, 221, 221); cursor: pointer; position: relative;">IPv4</th><th class="sorting" tabindex="0" aria-controls="table-list" rowspan="1" colspan="1" aria-label="
                                                                                    IPv6                                                                            : activate to sort column ascending" style="font-family: arial, verdana, sans-serif; line-height: 1.42857; box-sizing: content-box; padding: 8px 30px 8px 8px; text-align: left; vertical-align: bottom; border-top: 0px; border-bottom: 2px solid rgb(221, 221, 221); cursor: pointer; position: relative;">IPv6</th><th class="sorting" tabindex="0" aria-controls="table-list" rowspan="1" colspan="1" aria-label="
                                                                                    MAC Address                                                                            : activate to sort column ascending" style="font-family: arial, verdana, sans-serif; line-height: 1.42857; box-sizing: content-box; padding: 8px 30px 8px 8px; text-align: left; vertical-align: bottom; border-top: 0px; border-bottom: 2px solid rgb(221, 221, 221); cursor: pointer; position: relative;">MAC Address</th><th class="sorting" tabindex="0" aria-controls="table-list" rowspan="1" colspan="1" aria-label="
                                                                                    Manufacturer                                                                            : activate to sort column ascending" style="font-family: arial, verdana, sans-serif; line-height: 1.42857; box-sizing: content-box; padding: 8px 30px 8px 8px; text-align: left; vertical-align: bottom; border-top: 0px; border-bottom: 2px solid rgb(221, 221, 221); cursor: pointer; position: relative;">Manufacturer</th><th class="sorting_disabled" rowspan="1" colspan="1" aria-label="" style="font-family: arial, verdana, sans-serif; line-height: 1.42857; box-sizing: content-box; padding: 8px; text-align: left; vertical-align: bottom; border-top: 0px; border-bottom: 2px solid rgb(221, 221, 221); width: 150px;"></th></tr></thead><tbody style="box-sizing: border-box;"><tr role="row" class="odd" style="box-sizing: border-box;"><td style="font-family: arial, verdana, sans-serif; line-height: 1.42857; box-sizing: content-box; padding: 8px; vertical-align: top; border-top: 1px solid rgb(221, 221, 221);"><a href="http://192.168.69.3:81/customer/overview/2" style="color: rgb(51, 122, 183); box-sizing: border-box; background-color: transparent; text-decoration-line: none;">Return source'</a></td><td class="sorting_1" style="font-family: arial, verdana, sans-serif; line-height: 1.42857; box-sizing: content-box; padding: 8px; vertical-align: top; border-top: 1px solid rgb(221, 221, 221);">ER01::10GigabitEthernet14/7<br style="box-sizing: border-box;">ER01::10GigabitEthernet14/8<br style="box-sizing: border-box;">ER01::10GigabitEthernet14/9<br style="box-sizing: border-box;">ER01::10GigabitEthernet14/10<br style="box-sizing: border-box;"></td><td style="font-family: arial, verdana, sans-serif; line-height: 1.42857; box-sizing: content-box; padding: 8px; vertical-align: top; border-top: 1px solid rgb(221, 221, 221);"><a href="http://192.168.69.3:81/vlan/view/2" style="color: rgb(51, 122, 183); box-sizing: border-box; background-color: transparent; text-decoration-line: none;">VLAN249</a></td><td style="font-family: arial, verdana, sans-serif; line-height: 1.42857; box-sizing: content-box; padding: 8px; vertical-align: top; border-top: 1px solid rgb(221, 221, 221);">106.48.35.249</td><td style="font-family: arial, verdana, sans-serif; line-height: 1.42857; box-sizing: content-box; padding: 8px; vertical-align: top; border-top: 1px solid rgb(221, 221, 221);"></td><td style="font-family: arial, verdana, sans-serif; line-height: 1.42857; box-sizing: content-box; padding: 8px; vertical-align: top; border-top: 1px solid rgb(221, 221, 221);"><a id="view-l2a-3" name="9c741ae5314d" href="http://192.168.69.3:81/index.php#" title="View" style="color: rgb(51, 122, 183); box-sizing: border-box; background-color: transparent; text-decoration-line: none;">9c741ae531</a>00</td><td style="font-family: arial, verdana, sans-serif; line-height: 1.42857; box-sizing: content-box; padding: 8px; vertical-align: top; border-top: 1px solid rgb(221, 221, 221);">TECHNOLOGIES CO.,LTD</td></tr></tbody></table></div><div>How can I confirm the ¡°<span style="font-family: Calibri; font-size: 14.6667px;">match up the VLAN with the MAC address</span>¡±£¿</div><div>thanks a lot!</div><br><br><br><div style="position:relative;zoom:1"></div><div id="divNeteaseMailCard"></div><br>At 2019-05-22 20:52:10, "Nick Hilliard (INEX)" <nick@inex.ie> wrote:<br> <blockquote id="isReplyContent" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">

<div style="font-size: 
11pt;font-family: Calibri;">Hi Jennifer<br><span>

</span><br>sflow-to-rrd-handler needs to be able to match up the VLAN 
with the MAC address, according to what is configured in the 
Configured-MAC database.  If it can't match these up, it will set the 
source and destination VLAN interface ID (srcvli / dstvli) to be 0, and 
that will cause the sflow record to be dropped.  This means that all the
 counters in the RRD archive will be set to zero.<br><br>The output from
 sflowtool is showing multiple separate VLANs with IDs 2810, 3005, 1516,
 1702, 205, and vlan 1, with different src and destination vlans.  
Probably this is what is causing sflow-to-rrd-handler to be unable to 
work out what ports / vlans are being used.<br><br>Nick<br><br><blockquote type="cite" cite="mid:51ee6c3d.1baea.16aded96e8c.Coremail.yabuqi_0905@163.com" style="border: 0px none ! important;"><div class="__pbConvHr" style="margin:30px 25px 10px 25px;"><div style="width:100%;border-top:2px solid #EDF1F4;padding-top:10px;">   <div style="display:inline-block;white-space:nowrap;vertical-align:middle;width:49%;">
        <a style="color:#485664 
!important;padding-right:6px;font-weight:500;text-decoration:none 
!important;" href="mailto:yabuqi_0905@163.com" moz-do-not-send="true">jennifer
 xue</a></div>   <div style="display:inline-block;white-space:nowrap;vertical-align:middle;width:48%;text-align:
 right;">     <font color="#909AA4"><span style="padding-left:6px">22 
May 2019 at 09:22</span></font></div>    </div></div><div class="__pbConvBody" __pbrmquotes="true" style="color:#909AA4;margin-left:24px;margin-right:24px;">
<div style="line-height:1.7;color:#000000;font-size:14px;font-family:Arial"><div id="isForwardContent"><div style="line-height:1.7;color:#000000;font-size:14px;font-family:Arial"><div id="isForwardContent"><div style="line-height:1.7;color:#000000;font-size:14px;font-family:Arial"><div>Hello
 team,</div><div><div>I'm the newbie one regarding IXP Manager:<br>I'm 
trying to get peer-to-peer statistics and need help in that;</div><div>To
 be short: VM is CentOS  7</div><div>Installed via manual</div><div>PHP 
7.3.2</div><div>the SW is the physical one.</div><div><br></div><div>The
 switch is being detected via SNMP, port states are OK.</div><div>sFlow 
is configured on SW: I can tcpdump it on VM, traffic is comming;<br>(the
 same VM as IXP manager is installed on); I mean collector will be the 
same VM where IXP Manager is installed on.</div><div><br></div><div>but 
the output of rrdtool dump like is:</div><div><span style="color: 
rgb(255, 0, 0);">©À©¤©¤ ipv4<br>©¦   ©À©¤©¤ bytes<br>©¦   ©¦   ©À©¤©¤ aggregate<br>©¦  
 ©¦   ©¦   ©À©¤©¤ aggregate.ipv4.bytes.vlan00005.rrd<br>©¦   ©¦   ©¦   ©¸©¤©¤ 
aggregate.ipv4.bytes.vlan00249.rrd<br>©¦   ©¦   ©¸©¤©¤ individual<br>©¦   ©¦   
    ©¸©¤©¤ individual.ipv4.bytes.src-00003.rrd<br>©¦   ©¸©¤©¤ pkts<br>©¦       
©À©¤©¤ aggregate<br>©¦       ©¦   ©À©¤©¤ aggregate.ipv4.pkts.vlan00005.rrd<br>©¦  
     ©¦   ©¸©¤©¤ aggregate.ipv4.pkts.vlan00249.rrd<br>©¦       ©¸©¤©¤ individual<br>©¦  
         ©¸©¤©¤ individual.ipv4.pkts.src-00003.rrd<br>©À©¤©¤ ipv6<br>©¦   ©À©¤©¤ 
bytes<br>©¦   ©¦   ©À©¤©¤ aggregate<br>©¦   ©¦   ©¦   ©À©¤©¤ 
aggregate.ipv6.bytes.vlan00005.rrd<br>©¦   ©¦   ©¦   ©¸©¤©¤ 
aggregate.ipv6.bytes.vlan00249.rrd<br>©¦   ©¦   ©¸©¤©¤ individual<br>©¦   ©¦   
    ©¸©¤©¤ individual.ipv6.bytes.src-00003.rrd<br>©¦   ©¸©¤©¤ pkts<br>©¦       
©À©¤©¤ aggregate<br>©¦       ©¦   ©À©¤©¤ aggregate.ipv6.pkts.vlan00005.rrd<br>©¦  
     ©¦   ©¸©¤©¤ aggregate.ipv6.pkts.vlan00249.rrd<br>©¦       ©¸©¤©¤ individual<br>©¦  
         ©¸©¤©¤ individual.ipv6.pkts.src-00003.rrd</span></div><div>the 
content of file is :</div><div><rra><br>                
<cf>AVERAGE</cf><br>          
<pdp_per_row>1</pdp_per_row> <!-- 300 seconds --><br><br>
                <params><br>                <xff>5.0000000000e-01</xff><br>               
</params><br>               <cdp_prep><br>                      <ds><br>                    
<primary_value>0.0000000000e+00</primary_value><br>                   
<secondary_value>NaN</secondary_value><br>                    
<value>NaN</value><br>                        
<unknown_datapoints>0</unknown_datapoints><br>                        </ds><br>
                        <ds><br>                    
<primary_value>0.0000000000e+00</primary_value><br>                   
<secondary_value>NaN</secondary_value><br>                    
<value>NaN</value><br>                        
<unknown_datapoints>0</unknown_datapoints><br>                        </ds><br>
                </cdp_prep><br>             <database><br>                      <!-- 2019-05-18 
09:10:00 CST / 1558141800 --> 
<row><v>NaN</v><v>NaN</v></row><br>   
                <!-- 2019-05-18 09:15:00 CST / 1558142100 --> 
<row><v>NaN</v><v>NaN</v></row><br>   
                <!-- 2019-05-18 09:20:00 CST / 1558142400 --> 
<row><v>NaN</v><v>NaN</v></row><br>   
                <!-- 2019-05-18 09:25:00 CST / 1558142700 --> 
<row><v>NaN</v><v>NaN</v></row><br>   
                <!-- 2019-05-18 09:30:00 CST / 1558143000 --> 
<row><v>NaN</v><v>NaN</v></row><br>   
                <!-- 2019-05-18 09:35:00 CST / 1558143300 --> 
<row><v>NaN</v><v>NaN</v></row><br>   
                ¡­¡­</div><div><br></div><div>And the output of sflowtool is :</div><div><span style="color: rgb(255, 0, 0);">FLOW,106.48.32.32,837,967,0007586fa14d,70096d41fe99,0x0800,2810,3005,108.12.26.71,42.62.101.14,6,0x00,56,443,50248,0x10,1522,1500,2048<br>FLOW,106.48.32.32,912,970,d004ff2107c5,900374f5e219,0x0800,1516,1702,128.228.93.219,103.208.15.238,6,0x00,61,80,50295,0x10,1518,1496,2048</span></div><div><br></div><div>however,the
 output of "sflow-to-rrd-handler --macdbtype=configured --debug" is:</div><div><span style="color: rgb(255, 0, 0);">DEBUG: dropped update for: protocol: 4 
vlan: 205 srcvli: 0 dstvli: 0 pktsize: 1522 samplerate: 2048 <br>DEBUG: 
rejected: 
FLOW,106.48.32.32,903,1,100080acbb6e,f4007f99abe9,0x0800,205,1,223.202.84.225,47.110.33.18,6,0x00,59,443,63334,0x10,1522,1500,2048<br>DEBUG:
 dropped update for: protocol: 4 vlan: 1516 srcvli: 0 dstvli: 0 pktsize:
 1362 samplerate: 2048 <br>DEBUG: rejected: 
FLOW,106.48.32.32,912,970,d400ff2107c5,9c0074f5e219,0x0800,1516,1702,122.228.93.219,43.254.90.120,6,0x00,61,80,33968,0x10,1362,1340,2048</span></div><div><br></div><div><span style="color: rgb(0, 0, 0);">1¡¢There is no p2p file like "</span>p2p.ipv4.bytes.src-00001.dst-00003.rrd"
 been made;</div><div>2¡¢output of sflow-to-rrd-handler is correct??  
cannot find "accepted" word.</div><div><br><br><br></div><div><span style="color: rgb(0, 0, 0);"><br></span></div></div></div>Best Regards£¡<br><br><span title="neteasefooter"><p> </p></span></div></div><br><br><span title="neteasefooter"><p> </p></span></div></div><br><br><span title="neteasefooter"><p> </p></span>

</div></blockquote><br></div>
</blockquote></div><br><br><span title="neteasefooter"><p> </p></span>