[Bucardo-general] Password auth issue + Bucardo and postgres

[Kotresh Kumar Toolahalli]

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 <jon at endpointdev.com>
Date: Friday, 15 July 2022 at 3:31 AM
To: Kotresh Kumar Toolahalli <kotresh.kumar at digitalshark.in>
Cc: bucardo-general at bucardo.org <bucardo-general at 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 at 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/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20220803/b6d54dc2/attachment.htm>