[Bucardo-general] Unable to proceed with Bucardo installation

[Hadri Rahman]

I've changed the values in pg_hba.conf to:

# TYPE   DATABASE   USER       METHOD
local       all                 postgres    trust
local       all                 all             trust

but I still received the same error. I then changed it to
# TYPE   DATABASE   USER       METHOD
local       all                 postgres    ident
local       all                 all             trust

and (trust, ident)

but I'm still receiving the same error.

On Mon, Oct 13, 2014 at 6:37 PM, Irfin A [GMail] <foo.bazz at gmail.com> wrote:

> Hi there, I remember that I also have several issues when configuring
> Bucardo first time. Currently I'm using Bucardo 4.5 with PostgreSQL 9.1 on
> CentOS 6.4.  The configuration is master-master.
>
> If password authentication is currently holding you back, I suggest you to
> allow bucardo user with authentication method 'trust'. As you might already
> know, you can do this in pg_hba.conf file.
>
> After all your test and installation successful, you can then change that
> 'trust' to 'md5' or something else depends on your configuration.
>
> Hope this help you guys.
>
> Regards,
>
> Irfin A
> -----
> Bandung, Indonesia
>
> On Mon, Oct 13, 2014 at 1:28 PM, Bernard O'Flynn <bernard.oflynn at gmail.com
> > wrote:
>
>> This is the same issue I'm getting.
>> On 13 Oct 2014 05:47, "Hadri Rahman" <hadri90 at gmail.com> wrote:
>>
>>> I'm recently installing Bucardo to work with PostgreSQL. I had trouble
>>> installing Bucardo and the relevant libraries from packages, so I installed
>>> them through apt-get instead.
>>>
>>> My problem is that after I created a directory to act as its piddir
>>> (either `/tmp/bucardo/` or `/var/run/bucardo/`) and proceed with the
>>> installation, I received this error message:
>>>
>>>     psql: FATAL: password authentication failed for user "postgres"
>>> Sorry, unable to determine the database version.
>>>
>>> I then rest the password for user postgres, as well as giving it a new
>>> password, but the problem still remains. I've also deleted the password and
>>> left it blank, but when I tried to proceed with the installation, I
>>> received an error message saying
>>>
>>>     psql: fe_sendauth: no password supplied
>>>
>>> I've also edited the pg_hba.conf in both master and slave servers so
>>> that it includes the lines:
>>>
>>> # TYPE   DATABASE   USER       METHOD
>>> local    all        postgres   ident
>>> local    all        all        md5
>>>
>>> and I tried restarting postgres and continuing with the installation,
>>> but I keep on getting the same error message.
>>>
>>> I'm using PSQL 9.1.14 and Bucardo 4.4.8 on Ubuntu Server 12.04, if that
>>> helps.
>>>
>>> _______________________________________________
>>> Bucardo-general mailing list
>>> Bucardo-general at bucardo.org
>>> https://mail.endcrypt.com/mailman/listinfo/bucardo-general
>>>
>>>
>> _______________________________________________
>> 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/20141013/da780af5/attachment.html>