Any update?
Get Outlook for Android<https://aka.ms/AAb9ysg> ________________________________ From: Kotresh Kumar Toolahalli <kotresh.ku...@digitalshark.in> Sent: Wednesday, August 3, 2022 4:41:52 PM To: Jon Jensen <j...@endpointdev.com> Cc: bucardo-general@bucardo.org <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 <j...@endpointdev.com> Date: Friday, 15 July 2022 at 3:31 AM To: Kotresh Kumar Toolahalli <kotresh.ku...@digitalshark.in> Cc: bucardo-general@bucardo.org <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 postgres trust > local all all ident map=app > > > # TYPE DATABASE USER ADDRESS METHOD > > # "local" is for Unix domain socket connections only > local all all trust > # IPv4 local connections: > host all all 127.0.0.1/32 scram-sha-256 > host all all 0.0.0.0/0 md5 > # IPv6 local connections: > host all all ::1/128 scram-sha-256 > host all all 0.0.0.0/0 md5 > host all bucardo 0.0.0.0/0 trust > # Allow replication connections from localhost, by a user with the > # replication privilege. > local replication all trust > host replication all 127.0.0.1/32 scram-sha-256 > host replication 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 root postgres > app root bucardo > 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