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. Deployment not working (Basti S.)
2. Re: Deployment not working (Christian Ramseyer)
3. Re: Deployment not working (Oliver Gorwits)
--- Begin Message ---
Hello community,
I want to install a second Netdisco instance and stuck in the Deploy step
with this error:
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/sa-netdisco/perl5/lib/perl5/DBICx/Sugar.pm line 121
DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed:
DBIx::Class::Storage::DBI::catch {...} (): DBI
Connection failed: DBI connect('dbname=netdisco','netdisco',...) failed:
FATAL: Peer authentication fa iled for user
"netdisco" at /home/sa-netdisco/perl5/lib/perl5/DBIx/Class/Storage/DBI.pm
line 1639. at /home/
sa-netdisco/perl5/bin/netdisco-db-deploy line 110 at
/home/sa-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/sa-netdisco/perl5/lib/perl5/DBICx/Sugar.pm line 121
DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI
connect('dbname=netdisco','netdisco',. ..) failed:
FATAL: Peer authentication failed for user "netdisco" at
/home/sa-netdisco/perl5/lib/perl5/DBIx
/Class/Storage/DBI.pm line 1639. at
/home/sa-netdisco/perl5/lib/perl5/App/Netdisco/Util/Statistics.pm line 3
I tested the connection to the database with psql and the netdisco user and
password, but it was only working when I also added "-h 127.0.0.1".
Otherwise I get the same error: "failed: FATAL: Peer authentication failed
for user..."
I have already checked the pg_hba.conf, seems to be correct.
What else can I try?
Thanks in advance!
Regards,
Bastian
--- End Message ---
--- Begin Message ---
Hi
Peer authentication matches the OS username to the database username
(netdisco), but it seems like your Linux user is called "sa-netdisco" so
there is not match. You need to replace the peer authentication for the
netdisco database on local connections to something else, e.g.
scram-sha-256, md5 or trust. Post your pg_hba.conf if you can't get it
to work.
Cheers
Christian
On 10.11.21 08:50, Basti S. wrote:
Hello community,
I want to install a second Netdisco instance and stuck in the Deploy
step with this error:
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/sa-netdisco/perl5/lib/perl5/DBICx/Sugar.pm line 121
DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed:
DBIx::Class::Storage::DBI::catch {...} ():
DBI Connection failed: DBI connect('dbname=netdisco','netdisco',...)
failed: FATAL: Peer authentication fa iled for user "netdisco" at
/home/sa-netdisco/perl5/lib/perl5/DBIx/Class/Storage/DBI.pm line 1639.
at /home/ sa-netdisco/perl5/bin/netdisco-db-deploy line 110 at
/home/sa-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/sa-netdisco/perl5/lib/perl5/DBICx/Sugar.pm line 121
DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI
connect('dbname=netdisco','netdisco',. ..) failed: FATAL: Peer
authentication failed for user "netdisco" at
/home/sa-netdisco/perl5/lib/perl5/DBIx /Class/Storage/DBI.pm line
1639. at
/home/sa-netdisco/perl5/lib/perl5/App/Netdisco/Util/Statistics.pm line 3
I tested the connection to the database with psql and the netdisco
user and password, but it was only working when I also added "-h
127.0.0.1".
Otherwise I get the same error: "failed: FATAL: Peer authentication
failed for user..."
I have already checked the pg_hba.conf, seems to be correct.
What else can I try?
Thanks in advance!
Regards,
Bastian
_______________________________________________
Netdisco mailing list
[email protected]
https://sourceforge.net/p/netdisco/mailman/netdisco-users/
--
Christian Ramseyer, netnea ag
Network Management. Security. OpenSource.
Phone: +41 79 644 77 64
Teams:[email protected]
--- End Message ---
--- Begin Message ---
Hi Bastian
The configuration for this is pretty simple so not too many places it can
go wrong. In Netdisco you have the DB name, the DB user and password, and
DB host. On the other side you have pg_hba.conf but also check that
PostgreSQL is listening on the address specified.
Are you able to share the Netdisco config (but replace the secret parts
e.g. password)?
thanks
Oliver.
On Wed, 10 Nov 2021 at 08:03, Basti S. <[email protected]> wrote:
> Hello community,
>
> I want to install a second Netdisco instance and stuck in the Deploy step
> with this error:
>
> 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/sa-netdisco/perl5/lib/perl5/DBICx/Sugar.pm line 121
>
> DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed:
> DBIx::Class::Storage::DBI::catch {...} (): DBI
> Connection failed: DBI connect('dbname=netdisco','netdisco',...) failed:
> FATAL: Peer authentication fa iled for user
> "netdisco" at /home/sa-netdisco/perl5/lib/perl5/DBIx/Class/Storage/DBI.pm
> line 1639. at /home/
> sa-netdisco/perl5/bin/netdisco-db-deploy line 110 at
> /home/sa-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/sa-netdisco/perl5/lib/perl5/DBICx/Sugar.pm line 121
>
> DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI
> connect('dbname=netdisco','netdisco',. ..) failed:
> FATAL: Peer authentication failed for user "netdisco" at
> /home/sa-netdisco/perl5/lib/perl5/DBIx
> /Class/Storage/DBI.pm line 1639. at
> /home/sa-netdisco/perl5/lib/perl5/App/Netdisco/Util/Statistics.pm line 3
>
>
>
> I tested the connection to the database with psql and the netdisco user
> and password, but it was only working when I also added "-h 127.0.0.1".
>
> Otherwise I get the same error: "failed: FATAL: Peer authentication
> failed for user..."
>
>
> I have already checked the pg_hba.conf, seems to be correct.
>
>
> What else can I try?
>
>
> Thanks in advance!
>
>
> Regards,
>
> Bastian
> _______________________________________________
> Netdisco mailing list
> [email protected]
> https://sourceforge.net/p/netdisco/mailman/netdisco-users/
--- End Message ---
_______________________________________________
Netdisco mailing list - Digest Mode
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users
