[Bucardo-general] Authentication problem when running bucardo

[Waldemar Biernacki]

The row:

 > #IPv4
 > host     all        all127.0.0.1/32  <http://127.0.0.1/32>

seems strange for me.


Maybe try to change authentication method to 'trust' for a while:

#
#local:
# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
local   all         all                               trust

# The same using local loopback TCP/IP connections.
#
# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
host    all         all         127.0.0.1/32          trust


and if everything will go well (with bucardo - including dbs synch) then 
add some normal authentication.




 > |#Database administrative login by Unix domain socket
 > local     all        postgres         peer
 > local     all        bucardo          md5
 > #"local" is for Unix domain socket connections only
 > local     all        all         peer
 > #IPv4
 > host     all        all127.0.0.1/32  <http://127.0.0.1/32>          md5


W dniu 24.11.2014 o 09:54, Hadri Rahman pisze:
> Whenever I try to synchronize (or even run it in general) I would get
> the error message:
>
> |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 my installation, and confirmed that there is an entry for
> user "Bucardo" and the password for user Bucardo in both the database
> and .pgpass file matched, and I was able to install it successfully. But
> when I tried to run or perform any synchronization, I would get the same
> error message.
>
> The contents of the pg_hba.conf file are as follows:
>
>
> |#Database administrative login by Unix domain socket
> local     all        postgres         peer
> local     all        bucardo          md5
> #"local" is for Unix domain socket connections only
> local     all        all         peer
> #IPv4
> host     all        all127.0.0.1/32  <http://127.0.0.1/32>          md5
> #IPv6
> host     all        all     ::1/128         md5
> #Allow replication connections from localhost:
> host     replication rep192.168.0.111/32  <http://192.168.0.111/32>      md5|
>
>
>
>
>
> _______________________________________________
> Bucardo-general mailing list
> Bucardo-general at bucardo.org
> https://mail.endcrypt.com/mailman/listinfo/bucardo-general
>