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

[Nick Hilliard (INEX)]

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