Bucardo unable to authenticate password when running.

Suburban Errorist · 11-17-2014, 02:00 AM

So I've installed Bucardo onto my system, but whenever I try to perform a sync or running it in general, I would get the error message:

Code:

DBI connect('dbname=bucardo;host=localhost;port5432', 'bucardo',...) failed: FATAL: password authentication failed for user "bucardo"
FATAL: password authentication failed for user "bucardo" at /usr/local/bin/bucardo line 296

I've checked and confirmed that the user "Bucardo" is in the PostgreSQL database, and that the passwords in both the database and .pgpass are correct. I've searched online and it was suggested that there might be a problem in my pg_hba.conf file. The contents of the file are as follows:

Code:

#Database administrative login by Unix domain socket
local     all        postgres         peer
#"local" is for Unix domain socket connections only
local     all        all              peer
#IPv4
local     all        all     127.0.0.1/32         md5
#IPv6
local     all        all     ::1/128         peer
#Allow replication connections from localhost:
host     replication rep     192.168.0.111/32     md5
local    bucardo     bucardo                      md5

I've tried changing the authentication method for user "bucardo" from md5 to trust and ident, but I'm still getting the same error.

ciotog · 12-09-2014, 10:56 PM

I'm not sure if you're still dealing with this but...

Quote:

Originally Posted by Suburban Errorist

[CODE}#IPv4
local all all 127.0.0.1/32 md5
#IPv6
local all all ::1/128 peer
[/CODE]

Those two lines don't make sense, for local connections you don't specify address ranges. I believe Postgresql is stopping at the first of those lines, and treating 127.0.0.1/32 as an authentication method, which naturally fails. The remaining lines are ignored, for local connections.

You can have "local all all md5" and then you don't need to add "local bucardo bucardo md5" because the "all" line would cover it.