[Bucardo-general] Possible bug?

[Olaf Rühenbeck]

Hi there and thanks for the quick answer:

On Mon, 3 Jun 2013 10:18:19 -0400
Greg Sabino Mullane <greg at endpoint.com> wrote:

> On Mon, Jun 03, 2013 at 12:35:25PM +0200, Olaf Rühenbeck wrote:
> ...
> > Well as I said, I cant figure out why bucardo would get a permission
> > denied as I granted all on database baculadir to bucardo and can do
> > everything "by hand" :x
> 
> Make sure the bucardo account exists on all databases involved, and
> that it is a superuser. Then make sure that's the account name used
> inside the bucardo.db table:
> 
> bucardo list dbs
> 

root at maguro:~# bucardo list dbs
Database: m_baculadir  Status: active  Conn: psql -p 5432 -U baculadir
-d baculadir -h localhost 
Database: v_baculadir  Status: active  Conn:
psql -p 5432 -U maguro -d baculadir -h XXX

Postgres on XXX:

http://pastebin.com/CbE9ye7z

(So the user is a superuser and bucardo actually connected as this one)

http://pastebin.com/VxmqApwF

(same here)

sadly same error:

root at maguro:/home/rueheo4v# bucardo add sync m_baculadir_v herd=maguro
dbs=maguro onetimecopy=2 WARNING:  Issuing rollback() due to DESTROY
without explicit disconnect() of DBD::Pg::db handle
dbname=baculadir;host=localhost;port=5432 at line 273. CONTEXT:
PL/Perl function "validate_sync" SQL statement "SELECT
validate_sync('m_baculadir_v')" PL/Perl function "validate_sync" Failed
to add sync: DBD::Pg::st execute failed: ERROR:  DBD::Pg::db do failed:
ERROR:  permission denied for database baculadir at line 274. at line
30. CONTEXT:  PL/Perl function "validate_sync" at /usr/bin/bucardo line
4113.

maguro and bucardo respectively have been granted all on bucardo and
baculadir databases on both hosts.

Greetings,

Olaf Rühenbeck
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 836 bytes
Desc: not available
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20130604/3ec971e7/attachment.sig>