Well, it seems that if solved the authentication problem, but whenever I tried to add a database in Bucardo I would now get the error message:
Cannot add database: must supply a database name to connect to However, when I connect to the database from the postgres console, I would be able to connect to the database: postgres=#\c postgres; You are now connected to database "postgres" as user "postgres" On Tue, Nov 25, 2014 at 6:17 PM, Waldemar Biernacki <[email protected]> wrote: > 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 >> [email protected] >> https://mail.endcrypt.com/mailman/listinfo/bucardo-general >> >>
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
