[Bucardo-general] Unable to proceed with Bucardo installation

[Hadri Rahman]

Well, I somehow fixed the issue halfway by following the instructions given
here:
http://askubuntu.com/questions/413585/postgres-password-authentication-fails

But basically, what I did was:

Open the pg_hba.conf file, and added this below the line “Database
administrative login by Unix domain socket”:

        local    postgres     postgres     peer

I then saved the file and restarted PSQL. Once PSQL has restarted, type
this command to access the PSQL interface.

        sudo -u postgres psql

 Once the PSQL prompt has loaded, type:

        ALTER USER postgres PASSWORD 'password';



Now quit the PSQL console, open the pg_hba.conf file, remove the line we
had added earlier, and restart PSQL. I
was able to proceed with the installation as it accepts the password, but I
now receive an error message saying FATAL: password authentication failed
for user "bucardo" and Installation cannot proceed unless the Pl/PerlU
package is available. (Despite the fact I have installed Pl/PerlU earlier.)


On Mon, Oct 13, 2014 at 9:34 PM, Hadri Rahman <hadri90 at gmail.com> wrote:

> 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/20141014/b0f511cc/attachment.html>