[Bucardo-general] Some more questions

[Hadri Rahman]

Okay, so I've looked around for solutions regarding the .pgpass file, and
found this:
http://linuxandryan.wordpress.com/2013/03/07/creating-and-using-a-pgpass-file/

So I've created a new .pgpass file like this:


*#vim /root/.pgpass , entered the necessary information, saved it, and
applied chmod:*
#chmod 600 /root/.pgpass

Next, I deleted the Bucardo Database table, and ran the installer
again, and although it changed from user

"bucardo" to "postgres" (since Database bucardo is deleted), and asked
for the password for user "bucardo",
and it was able to complete the installation.

Thanks for all the suggestions and help given when I was having this problem.


On Mon, Nov 10, 2014 at 2:31 PM, Hadri Rahman <hadri90 at gmail.com> wrote:

> I've edited the line:   $dbh = DBI->connect($BDSN, 'bucardo', undef,
> {AutoCommit=>0,RaiseError=>1,
> PrintError=>0}); in /usr/local/bin/bucardo back to   $dbh =
> DBI->connect($BDSN, 'bucardo', '', {AutoCommit=>0,RaiseError=>1,
> PrintError=>0}); but that resulted in an error and the installer couldn't
> run, so I reverted it back to include 'undef', but unfortunately so far I'm
> still getting the same error message.
>
>
>
>
> On Mon, Nov 10, 2014 at 12:56 PM, Hadri Rahman <hadri90 at gmail.com> wrote:
>
>> I've dropped the database "bucardo" and ran the installer again.
>>
>> What happened during the installer was:
>>
>> Failed to connect to database 'bucardo', will try 'postgres'. Once the
>> installer changes it to postgres, the installer would them give the message:
>>
>> Password for user bucardo:
>>
>> Database creation is complete
>>
>> DBI connect('dbname=bucardo;host=localhost;port5432', 'bucardo',...)
>> failed: fe_sendauth: no password supplied at /usr/local/bin/bucardo line
>> 8627
>>
>> I tried to edit the line in the /usr/local/bin/bucardo file but now the
>> installer wouldn't run. I'll try and fix that first before updating further
>> if the installation works or not.
>>
>> On Mon, Nov 10, 2014 at 11:59 AM, Juned Khan <jkhan6722 at gmail.com> wrote:
>>
>>> Can you give a try with droping bucardo database ?
>>>
>>> Thanks,
>>> Juned Khan
>>> iNextrix Technologies Pvt. Ltd.
>>> www.inextrix.com <http://www.inextrix.com/>
>>>
>>> [image: Facebook] <https://www.facebook.com/junedkhan23> [image:
>>> Twitter] <https://twitter.com/juned23> [image: Google Plus]
>>> <https://plus.google.com/+JunedKhan> [image: Linkedin]
>>> <http://htmlsig.com/in.linkedin.com/in/junedk>
>>>
>>> On Mon, Nov 10, 2014 at 8:33 AM, Hadri Rahman <hadri90 at gmail.com> wrote:
>>>
>>>> Okay, so I've tried to change the permission for .pgass in user "root"
>>>> but I got the error message: chmod: cannot access `~./pgpass': No such file
>>>> or directory.
>>>>
>>>> So I then reverted back to my own account, changed the file permission,
>>>> but when I tried to install Bucardo I got the error message:
>>>>
>>>> "INSTALLATION FAILED! Looks like you already have Bucardo installed
>>>> there. Try running "Bucardo upgrade"
>>>>
>>>> The contents of the .pgpass file so far looks like this:
>>>>
>>>>
>>>> localhost:5432:bucardo:bucardo:password
>>>>
>>>> On Sun, Nov 9, 2014 at 5:04 AM, Joshua Tolley <josh at endpoint.com>
>>>> wrote:
>>>>
>>>>> On Fri, Nov 07, 2014 at 03:42:59PM -0500, Greg Sabino Mullane wrote:
>>>>> > On Fri, Nov 07, 2014 at 10:54:54AM +0800, Hadri Rahman wrote:
>>>>> > > A psql connection (via user postgres) seems to work:
>>>>> > >
>>>>> > > postgres at vmachine:$ psql -h localhost -p -5432 -U bucardo bucardo
>>>>> > > Password for user bucardo:
>>>>> >
>>>>> > Why is it asking for a password here? Are you typing anything in?
>>>>> > If the .pgpass file is being read and working, this prompt should
>>>>> > not be appearing.
>>>>>
>>>>> Are the permissions on .pgpass correct? From
>>>>> http://www.postgresql.org/docs/9.3/static/libpq-pgpass.html:
>>>>>
>>>>> "On Unix systems, the permissions on .pgpass must disallow any access
>>>>> to world
>>>>> or group; achieve this by the command chmod 0600 ~/.pgpass. If the
>>>>> permissions
>>>>> are less strict than this, the file will be ignored."
>>>>>
>>>>> --
>>>>> Josh Tolley   josh at endpoint.com   801-987-0252
>>>>> End Point Corporation  http://www.endpoint.com
>>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> 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/20141111/928dd100/attachment-0001.html>