[Bucardo-general] FATAL: password authentication when bucardo add tables
Alan Silva
alanceu2000 at yahoo.com.br
Thu Sep 1 18:16:46 UTC 2016
Bhavesh,
Alter your file pg_hba.conf, or paste configuration here.
[], Alan Ribeiro (061) 98353-9715
Em Quarta-feira, 31, Agosto 2016 14:24:13, Bhavesh Odedra <bodedra at ursainfosystems.com> escreveu:
Hello Respected Team,
I am willing to learn Bucardo.
I face some problem when add table into bucardo.
What I have tried so far ?
I have created master database with openerp postgres user.
- Setup Source Database
export SOURCE_HOST=localhost
export SOURCE_PORT=5432
export SOURCE_DATABASE=master
export SOURCE_USERNAME=openerp
export SOURCE_PASSWORD=openerp
- Setup Destination Database
export DEST_HOST=localhost
export DEST_PORT=5432
export DEST_DATABASE=slave
export DEST_USERNAME=openerp
export DEST_PASSWORD=openerp
- Finally, the tables to be migrated
export TABLES="-t res_partner"
export TABLES_WITH_SPACES="res_partner"
- Set up the Destination Database
cat >> $HOME/.pgpass <<EOL
$DEST_HOST:$DEST_PORT:$DEST_DATABASE:$DEST_USERNAME:$DEST_PASSWORD
$SOURCE_HOST:$SOURCE_PORT:$SOURCE_DATABASE:$SOURCE_USERNAME:$SOURCE_PASSWORD
EOL
- Create schema.sql
- Create Slave database
- Load schema into Slave
- Setting up Bucardo Sync (Source Database and Destination Database)
- Now I am trying to add the tables we want to migrate and add them to a "copying herd"
./bucardo add tables res_partner db=master
I got following error:
openerp at odedra-Lenovo-Z50-70:/usr/local/src/bucardo$ ./bucardo add tables res_partner db=master
DBI connect('dbname=master;host=localhost;port=5432','openerp',...) failed: FATAL: password authentication failed for user "openerp"
FATAL: password authentication failed for user "openerp" at ./bucardo line 8632.
I have analytic script bucardo. I have confusion with dbuser and dbpass variable declared at line number 84, 85.
(I have tried with dbuser = 'openerp' and dbpass='openerp' but result same)
May you guide me what should I change to fix above error?
Looking forward
-
With regards,
Bhavesh Odedra
| | Bhavesh Odedra - Odoo Software Developer
Ursa Information Systems
1706 Plum Lane, Suite 127
Redlands, California, 92374
Office: 1-855-URSA ERP
1-855-877 2377
|
|
_______________________________________________
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/20160901/b8665647/attachment.html>
More information about the Bucardo-general
mailing list