Send netdisco-users mailing list submissions to
[email protected]
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
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of netdisco-users digest..."
Today's Topics:
1. Re: Upgrade to 2.42 fails (Nikolaos Milas)
2. Re: Upgrade to 2.42 fails (Christian Ramseyer)
--- Begin Message ---
Thank you all for your feedback!
I have struggled with db upgrade, but I managed to install postgresql 11
(I thought I would give it a try) and migrated the netdisco db to the
new version.
However, after all that, I am still having a problem with netdisco-deploy:
[netdisco@netgaze ~]$ ~/bin/localenv cpanm --notest App::Netdisco
App::Netdisco is up to date. (2.042010)
[netdisco@netgaze ~]$ ln -sf ~/perl5/bin/{localenv,netdisco-*} ~/bin/
[netdisco@netgaze ~]$ ~/bin/netdisco-deploy
This is the Netdisco II 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)
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
DBIx::Class::Schema::Versioned::_on_connect(): Your DB is currently
unversioned. Please call upgrade on your schema to sync the DB. at
/home/netdisco/perl5/lib/perl5/Dancer/Plugin/DBIC.pm line 62
DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed:
DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed:
DBI connect('dbname=netdisco;host=localhost','netdisco',...) failed:
FATAL: Ident authentication failed for user "netdisco" at
/home/netdisco/perl5/lib/perl5/DBIx/Class/Storage/DBI.pm line 1517.
at /home/netdisco/perl5/bin/netdisco-db-deploy line 110 at
/home/netdisco/perl5/bin/netdisco-db-deploy line 110
DB schema update complete.
DBIx::Class::Schema::Versioned::_on_connect(): Your DB is currently
unversioned. Please call upgrade on your schema to sync the DB. at
/home/netdisco/perl5/lib/perl5/Dancer/Plugin/DBIC.pm line 62
DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed:
DBI connect('dbname=netdisco;host=localhost','netdisco',...) failed:
FATAL: Ident authentication failed for user "netdisco" at
/home/netdisco/perl5/lib/perl5/DBIx/Class/Storage/DBI.pm line 1517.
at /home/netdisco/perl5/lib/perl5/App/Netdisco/Util/Statistics.pm
line 77
Can you please help me to resolve this problem? What does the message:
"Your DB is currently unversioned" mean?
Thanks,
Nick
On 26/8/2019 2:19 μ.μ., Nick Nauwelaerts wrote:
newer versions (and 4.042010 too, but not documented) will require at least
pg9.4....
--- End Message ---
--- Begin Message ---
Hi Nick
On 02.09.19 12:33, Nikolaos Milas wrote:
> Thank you all for your feedback!
>
> I have struggled with db upgrade, but I managed to install postgresql 11
> (I thought I would give it a try) and migrated the netdisco db to the
> new version.
>
> However, after all that, I am still having a problem with netdisco-deploy:
>
> [netdisco@netgaze ~]$ ~/bin/localenv cpanm --notest App::Netdisco
> App::Netdisco is up to date. (2.042010)
>
> [netdisco@netgaze ~]$ ln -sf ~/perl5/bin/{localenv,netdisco-*} ~/bin/
>
> [netdisco@netgaze ~]$ ~/bin/netdisco-deploy
> This is the Netdisco II 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)
>
> 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
> DBIx::Class::Schema::Versioned::_on_connect(): Your DB is currently
> unversioned. Please call upgrade on your schema to sync the DB. at
> /home/netdisco/perl5/lib/perl5/Dancer/Plugin/DBIC.pm line 62
> DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed:
> DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed:
> DBI connect('dbname=netdisco;host=localhost','netdisco',...) failed:
> FATAL: Ident authentication failed for user "netdisco" at
> /home/netdisco/perl5/lib/perl5/DBIx/Class/Storage/DBI.pm line 1517.
> at /home/netdisco/perl5/bin/netdisco-db-deploy line 110 at
> /home/netdisco/perl5/bin/netdisco-db-deploy line 110
> DB schema update complete.
> DBIx::Class::Schema::Versioned::_on_connect(): Your DB is currently
> unversioned. Please call upgrade on your schema to sync the DB. at
> /home/netdisco/perl5/lib/perl5/Dancer/Plugin/DBIC.pm line 62
> DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed:
> DBI connect('dbname=netdisco;host=localhost','netdisco',...) failed:
> FATAL: Ident authentication failed for user "netdisco" at
> /home/netdisco/perl5/lib/perl5/DBIx/Class/Storage/DBI.pm line 1517.
> at /home/netdisco/perl5/lib/perl5/App/Netdisco/Util/Statistics.pm
> line 77
>
> Can you please help me to resolve this problem? What does the message:
> "Your DB is currently unversioned" mean?
>
"Your DB is currently unversioned" is expected at this point,
netdisco-deploy would deal with it. The real problem is:
FATAL: Ident authentication failed for user "netdisco"
This means that you need to create the netdisco role (aka user) with a
password in your postgres 11 DB. It this part from
https://metacpan.org/pod/App::Netdisco:
root:~# su - postgres
postgres:~$ createuser -DRSP netdisco
Enter password for new role:
Enter it again:
Also you might need this:
<https://github.com/netdisco/netdisco/wiki/Install-Tips#enable-md5-authentication-to-postgresql>
Then verify with "psql -U netdisco -h localhost netdisco" if it works
with the given password.
You said you migrated the netdisco DB. Depending on how you did it, this
did not migrate the user from the old db - in Postgres you'd also need
to import the "postgres" metadata/permission DB in addition to
"netdisco", or use a dump from pg_dumpall. But just recreating the role
should do it, netdisco has nothing else important in there.
Hope that helps
Christian
--- End Message ---
_______________________________________________
Netdisco mailing list - Digest Mode
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users
