Re: [Bucardo-general] Password auth issue + Bucardo and postgres
Any update?
Get Outlook for Android<https://aka.ms/AAb9ysg>
From: Kotresh Kumar Toolahalli
Sent: Wednesday, August 3, 2022 4:41:52 PM
To: Jon Jensen
Cc: bucardo-general@bucardo.org
Subject: Re: [Bucardo-general] Password auth issue + Bucardo and postgres
Hello Jon,
Thanks for the answer, it worked well !
I have another blocker now, we configure 3 nodes and sync works well but if
one node goes down then sync not works.
We are using bucardo 5.6.0 and I found the issue
Sync stops when one servers fails
https://bucardo.org/pipermail/bucardo-general/2015-October/002671.html similar
issue
Example:
1. Node A, B, C on group
2. Node B goes down
3. Data created on A and C remains in the respective db but not sync to each
other.
4. Once B turns on – all syncs up
5. But new data on B is not syncs up to A & C
6. But A & C syncs up
Regards,
Kotresh
From: Jon Jensen
Date: Friday, 15 July 2022 at 3:31 AM
To: Kotresh Kumar Toolahalli
Cc: bucardo-general@bucardo.org
Subject: Re: [Bucardo-general] Password auth issue + Bucardo and postgres
On Thu, 14 Jul 2022, Kotresh Kumar Toolahalli wrote:
> Am getting below error, couldn’t able to solve. Please assist
Kotresh,
It looks to me like your pg_hba.conf is requiring a password for
connections from 127.0.0.1, because this line:
host all all 127.0.0.1/32 scram-sha-256
Comes before this one:
host all bucardo 0.0.0.0/0 trust
If you want the "bucardo" user to connect with no password as that
indicates, you should move that bucardo line before the "host" + "all"
line, which takes priority the way you have it now.
Jon
> Ubuntu version: 20.04
> Postgres 14
> And latest bucardo
>
> I have update the hba_conf
> # Database administrative login by Unix domain socket
> local all postgrestrust
> local all all ident map=app
>
>
> # TYPE DATABASEUSERADDRESS METHOD
>
> # "local" is for Unix domain socket connections only
> local all all trust
> # IPv4 local connections:
> hostall all 127.0.0.1/32scram-sha-256
> hostall all 0.0.0.0/0md5
> # IPv6 local connections:
> hostall all ::1/128 scram-sha-256
> hostall all 0.0.0.0/0md5
> hostall bucardo 0.0.0.0/0 trust
> # Allow replication connections from localhost, by a user with the
> # replication privilege.
> local replication all trust
> hostreplication all 127.0.0.1/32scram-sha-256
> hostreplication all ::1/128 scram-sha-256
>
>
> and /etc/postgresql/14/main/pg_ident.conf'
>
> # Put your actual configuration here
> # --
>
> # MAPNAME SYSTEM-USERNAME PG-USERNAME
> app rootpostgres
> app rootbucardo
> app {username} bucardo
>
>
> ubuntu@ip-172-31-32-191:~$ sudo bucardo show all
>
> DBI connect('dbname=bucardo;host=localhost;port=5432','bucardo',...) failed:
> connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL:
> password authentication failed for user "bucardo"
>
> connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL:
> password authentication failed for user "bucardo" at /usr/bin/bucardo line
> 310.
>
> Regards,
> Kotresh
--
Jon Jensen
End Point Corporation
https://www.endpointdev.com/
___
Bucardo-general mailing list
Bucardo-general@bucardo.org
https://bucardo.org/mailman/listinfo/bucardo-general
Re: [Bucardo-general] Password auth issue + Bucardo and postgres
Hello Jon,
Thanks for the answer, it worked well !
I have another blocker now, we configure 3 nodes and sync works well but if
one node goes down then sync not works.
We are using bucardo 5.6.0 and I found the issue
Sync stops when one servers fails
https://bucardo.org/pipermail/bucardo-general/2015-October/002671.html similar
issue
Example:
1. Node A, B, C on group
2. Node B goes down
3. Data created on A and C remains in the respective db but not sync to each
other.
4. Once B turns on – all syncs up
5. But new data on B is not syncs up to A & C
6. But A & C syncs up
Regards,
Kotresh
From: Jon Jensen
Date: Friday, 15 July 2022 at 3:31 AM
To: Kotresh Kumar Toolahalli
Cc: bucardo-general@bucardo.org
Subject: Re: [Bucardo-general] Password auth issue + Bucardo and postgres
On Thu, 14 Jul 2022, Kotresh Kumar Toolahalli wrote:
> Am getting below error, couldn’t able to solve. Please assist
Kotresh,
It looks to me like your pg_hba.conf is requiring a password for
connections from 127.0.0.1, because this line:
host all all 127.0.0.1/32 scram-sha-256
Comes before this one:
host all bucardo 0.0.0.0/0 trust
If you want the "bucardo" user to connect with no password as that
indicates, you should move that bucardo line before the "host" + "all"
line, which takes priority the way you have it now.
Jon
> Ubuntu version: 20.04
> Postgres 14
> And latest bucardo
>
> I have update the hba_conf
> # Database administrative login by Unix domain socket
> local all postgrestrust
> local all all ident map=app
>
>
> # TYPE DATABASEUSERADDRESS METHOD
>
> # "local" is for Unix domain socket connections only
> local all all trust
> # IPv4 local connections:
> hostall all 127.0.0.1/32scram-sha-256
> hostall all 0.0.0.0/0md5
> # IPv6 local connections:
> hostall all ::1/128 scram-sha-256
> hostall all 0.0.0.0/0md5
> hostall bucardo 0.0.0.0/0 trust
> # Allow replication connections from localhost, by a user with the
> # replication privilege.
> local replication all trust
> hostreplication all 127.0.0.1/32scram-sha-256
> hostreplication all ::1/128 scram-sha-256
>
>
> and /etc/postgresql/14/main/pg_ident.conf'
>
> # Put your actual configuration here
> # --
>
> # MAPNAME SYSTEM-USERNAME PG-USERNAME
> app rootpostgres
> app rootbucardo
> app {username} bucardo
>
>
> ubuntu@ip-172-31-32-191:~$ sudo bucardo show all
>
> DBI connect('dbname=bucardo;host=localhost;port=5432','bucardo',...) failed:
> connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL:
> password authentication failed for user "bucardo"
>
> connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL:
> password authentication failed for user "bucardo" at /usr/bin/bucardo line
> 310.
>
> Regards,
> Kotresh
--
Jon Jensen
End Point Corporation
https://www.endpointdev.com/
___
Bucardo-general mailing list
Bucardo-general@bucardo.org
https://bucardo.org/mailman/listinfo/bucardo-general
Re: [Bucardo-general] Password auth issue + Bucardo and postgres
On Thu, 14 Jul 2022, Kotresh Kumar Toolahalli wrote:
Am getting below error, couldn’t able to solve. Please assist
Kotresh,
It looks to me like your pg_hba.conf is requiring a password for
connections from 127.0.0.1, because this line:
host all all 127.0.0.1/32 scram-sha-256
Comes before this one:
host all bucardo 0.0.0.0/0 trust
If you want the "bucardo" user to connect with no password as that
indicates, you should move that bucardo line before the "host" + "all"
line, which takes priority the way you have it now.
Jon
Ubuntu version: 20.04
Postgres 14
And latest bucardo
I have update the hba_conf
# Database administrative login by Unix domain socket
local all postgrestrust
local all all ident map=app
# TYPE DATABASEUSERADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
hostall all 127.0.0.1/32scram-sha-256
hostall all 0.0.0.0/0md5
# IPv6 local connections:
hostall all ::1/128 scram-sha-256
hostall all 0.0.0.0/0md5
hostall bucardo 0.0.0.0/0 trust
# Allow replication connections from localhost, by a user with the
# replication privilege.
local replication all trust
hostreplication all 127.0.0.1/32scram-sha-256
hostreplication all ::1/128 scram-sha-256
and /etc/postgresql/14/main/pg_ident.conf'
# Put your actual configuration here
# --
# MAPNAME SYSTEM-USERNAME PG-USERNAME
app rootpostgres
app rootbucardo
app {username} bucardo
ubuntu@ip-172-31-32-191:~$ sudo bucardo show all
DBI connect('dbname=bucardo;host=localhost;port=5432','bucardo',...) failed: connection to server
at "localhost" (127.0.0.1), port 5432 failed: FATAL: password authentication failed for
user "bucardo"
connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL: password
authentication failed for user "bucardo" at /usr/bin/bucardo line 310.
Regards,
Kotresh
--
Jon Jensen
End Point Corporation
https://www.endpointdev.com/___
Bucardo-general mailing list
Bucardo-general@bucardo.org
https://bucardo.org/mailman/listinfo/bucardo-general
