[Bucardo-general] Password auth issue + Bucardo and postgres
Kotresh Kumar Toolahalli
kotresh.kumar at digitalshark.in
Thu Jul 14 13:34:02 UTC 2022
Hello Bucardo Team,
Am getting below error, couldn’t able to solve. Please assist
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20220714/0b02d7f5/attachment.htm>
More information about the Bucardo-general
mailing list