[Bucardo-general] Authentication problem when running bucardo

[Hadri Rahman]

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 <wb at sao.pl> 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
>> Bucardo-general at bucardo.org
>> https://mail.endcrypt.com/mailman/listinfo/bucardo-general
>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20141126/afcea947/attachment-0001.html>