[ixpmanager] Issue with mac addresses not updating after conversion to 6.2

[Paul Emmons]

Thanks Nick - Really making progress here.

I've got all the mac addresses in the table now!  I'll work on sFLOW next.

Just to confirm, the addresses don't show up on the the ADMIN UI 
*unless* we switch to configured MACs.

Or do I need to change to configured to move on to sFLOW?

~ Paul


On 3/2/2022 10:36 AM, Nick Hilliard (INEX) wrote:
> Paul Emmons wrote on 02/03/2022 16:52:
>> root at ixp6:/usr/local/etc# /usr/local/bin/update-l2database.pl
>> WARNING: executing this program without the "--vlanid" parameter is 
>> deprecated and will be removed in a future version of IXP Manager.
>
> You really need to use the --vlanid parameter here. It's not joking.
>
>> WARNING: sw1.qts120.phx.nix-ops.net: cannot read BRIDGE-MIB or 
>> Q-BRIDGE-MIB. Not processing sw1.qts120.phx.nix-ops.net further.
>> DBD::mysql::st execute failed: View 
>> 'ixpmanager.view_switch_details_by_custid' references invalid 
>> table(s) or column(s) or function(s) or definer/invoker of view lack 
>> rights to use them at /usr/local/bin/update-l2database.pl line 143.
>
> Mmm.  What's happened here is that you didn't update the views list. 
> You can fix this either using:
>
> $ artisan update:reset-mysql-views
>
> Or you can download the version of update-l2database.pl from the 
> master branch:
>
>> https://github.com/inex/IXP-Manager/blob/master/tools/runtime/l2database/update-l2database.pl 
>>
>
> I'd recommend the latter option, which will be included in the next 
> minor release of IXP Manager.
>
> Nick

-- 
~ Paul Emmons
Executive Director
+1 480 265-2525 cell