Send netdisco-users mailing list submissions to
netdisco-users@lists.sourceforge.net
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.sourceforge.net/lists/listinfo/netdisco-users
or, via email, send a message with subject or body 'help' to
netdisco-users-requ...@lists.sourceforge.net
You can reach the person managing the list at
netdisco-users-ow...@lists.sourceforge.net
When replying, please edit your Subject line so it is more specific
than "Re: Contents of netdisco-users digest..."
Today's Topics:
1. Re: OUI with long field (Oliver Gorwits)
--- Begin Message ---
Hi again Barry
I wonder if the schema update didn't work properly, as the oui field of the
node table should be varchar(9) not varchar(8) as in the error.
You could manually run this in psql: ALTER TABLE node ALTER COLUMN oui TYPE
varchar(9);
Or you can redeploy the whole schema which is safe to do on top of an
existing database (well, I hope you have backups anyway!):
~netdisco/bin/netdisco-db-deploy --redeploy-all
You can then re-run netdisco-deploy and the import OUI should work (or run
~netdisco/bin/ieee-oui-import directly).
Do let me know how you get on,
regards
Oliver.
On Mon, 11 Dec 2023 at 11:48, Dean, Barry <b...@liverpool.ac.uk> wrote:
> I was upgrading to 2.71.0 (happened upgrading to 2.71.1 as well). I always
> use all the steps in the “Upgrading from 2.x” section of
> https://metacpan.org/pod/App::Netdisco
>
>
>
> I was using netdisco-deploy, full transcript: (2.71.0 to 2.71.1 upgrade).
>
>
>
> netdisco@netdisco:~$ ~/bin/localenv cpanm --notest App::Netdisco
>
> --> Working on App::Netdisco
>
> Fetching
> http://www.cpan.org/authors/id/O/OL/OLIVER/App-Netdisco-2.071001.tar.gz
> ... OK
>
> Configuring App-Netdisco-2.071001 ... OK
>
> Building App-Netdisco-2.071001 ... OK
>
> Successfully installed App-Netdisco-2.071001 (upgraded from 2.071000)
>
> 1 distribution installed
>
>
>
> netdisco@netdisco:~$ ln -sf ~/perl5/bin/{localenv,netdisco-*} ~/bin/
>
>
>
> netdisco@netdisco:~$ ~/bin/netdisco-deploy
>
> This is the Netdisco 2 deployment script.
>
>
>
> Before we continue, the following prerequisites must be in place:
>
> * Database added to PostgreSQL for Netdisco
>
> * User added to PostgreSQL with rights to the Netdisco Database
>
> * "~/environments/deployment.yml" file configured with Database
> dsn/user/pass
>
> * A full backup of any existing Netdisco database data
>
> * Internet access (for OUIs and MIBs)
>
>
>
> If you are upgrading Netdisco 2 read the release notes:
>
> https://github.com/netdisco/netdisco/wiki/Release-Notes
>
> There you will find required and incompatible changes
>
> which are not covered by this script.
>
>
>
> You will be asked to confirm all changes to your system.
>
>
>
> So, is all of the above in place? [y/N]: y
>
>
>
> Would you like to deploy the database schema? [y/N]: y
>
> DB schema update complete.
>
> Updating statistics... done.
>
>
>
> Download and update vendor MAC prefixes (OUI data)? [y/N]: y
>
> Updating OUI... {UNKNOWN}: DBI Exception: DBD::Pg::db do failed: ERROR:
> value too long for type character varying(8) at
> /usr/local/netdisco/perl5/bin/ieee-oui-import line 114
>
>
>
> netdisco@netdisco:~$ ~/bin/netdisco-deploy
>
> This is the Netdisco 2 deployment script.
>
>
>
> Before we continue, the following prerequisites must be in place:
>
> * Database added to PostgreSQL for Netdisco
>
> * User added to PostgreSQL with rights to the Netdisco Database
>
> * "~/environments/deployment.yml" file configured with Database
> dsn/user/pass
>
> * A full backup of any existing Netdisco database data
>
> * Internet access (for OUIs and MIBs)
>
>
>
> If you are upgrading Netdisco 2 read the release notes:
>
> https://github.com/netdisco/netdisco/wiki/Release-Notes
>
> There you will find required and incompatible changes
>
> which are not covered by this script.
>
>
>
> You will be asked to confirm all changes to your system.
>
>
>
> So, is all of the above in place? [y/N]: y
>
>
>
> Would you like to deploy the database schema? [y/N]: N
>
>
>
> Download and update vendor MAC prefixes (OUI data)? [y/N]: N
>
>
>
> Download and update MIB files? [y/N]: y
>
> MIBs update complete.
>
> netdisco@netdisco:~$ ~/bin/netdisco-web restart
>
> Netdisco Web [Stopped]
>
> Netdisco Web [Started]
>
> config watcher: watching /usr/local/netdisco/environments for updates.
>
> netdisco@netdisco:~$
>
> netdisco@netdisco:~$ ~/bin/netdisco-backend restart
>
> Netdisco Backend [Stopped]
>
> Netdisco Backend [Started]
>
> config watcher: watching /usr/local/netdisco/environments for updates.
>
>
>
> *Thanks*
>
> *Barry Dean*
>
> *Network Analyst Team Leader*
>
>
>
> *From:* Oliver Gorwits <oli...@cpan.org>
> *Sent:* Monday, December 11, 2023 11:29 AM
> *To:* Dean, Barry <b.d...@liverpool.ac.uk>
> *Cc:* netdisco-users@lists.sourceforge.net
> *Subject:* Re: [Netdisco] OUI with long field
>
>
>
> Caution: This email originated from outside of the University. Do not
> click links or open attachments unless you recognise the source of this
> email and know the content is safe. Check sender address, hover over URLs
> and don't open suspicious email attachments.
>
> Hi Barry
>
>
>
> Did you update Netdisco but not run all the netdisco-deploy steps and not
> restart backend(s)?
>
>
>
> There was a re-engineering of the OUI handling a few releases ago. Could
> be a bug but just checking. Be sure to run all deploy steps, both schema
> and OUI download.
>
>
>
> regards
>
> Oliver.
>
>
>
> On Mon, 11 Dec 2023 at 11:26, Dean, Barry <b...@liverpool.ac.uk> wrote:
>
> I am getting this error when updating the OUI database:
>
> Download and update vendor MAC prefixes (OUI data)? [y/N]: y
> Updating OUI... {UNKNOWN}: DBI Exception: DBD::Pg::db do failed: ERROR:
> value too long for type character varying(8) at
> /usr/local/netdisco/perl5/bin/ieee-oui-import line 114
>
>
> Barry Dean
> Network Team, University of Liverpool
>
>
>
> _______________________________________________
> Netdisco mailing list
> netdisco-users@lists.sourceforge.net
> https://sourceforge.net/p/netdisco/mailman/netdisco-users/
>
>
--- End Message ---
_______________________________________________
Netdisco mailing list - Digest Mode
netdisco-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/netdisco-users
