FATAL: password authentication when bucardo add tables

Bhavesh Odedra

System specification:

  • Ubuntu 14.04
  • bucardo version 4.99.10
  • psql (PostgreSQL) 9.3.14

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@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)

My pg_hba.conf

# Database administrative login by Unix domain socket
local   all             postgres                                ident

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     md5
# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
# IPv6 local connections:
host    all             all             ::1/128                 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
#local   replication     postgres                                peer
#host    replication     postgres        127.0.0.1/32            md5
#host    replication     postgres        ::1/128                 md5

List of database:

                                   List of databases
    Name     |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges   
-------------+----------+----------+-------------+-------------+-----------------------
 bucardo     | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 master      | openerp  | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 postgres    | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 slave       | openerp  | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 slave_copy  | openerp  | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 slave_copy1 | openerp  | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 slave_copy2 | openerp  | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 template0   | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
             |          |          |             |             | postgres=CTc/postgres
 template1   | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
             |          |          |             |             | postgres=CTc/postgres

May you guide me what should I change to fix above error or helpful related links?

How can I achieve master-slave functionality using Bucardo ?

Bhavesh Odedra

I have found that have problem with pg_hba.conf file. To resolve error, I have added below line to that file.

local   all             openerp                                ident

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

FATAL: password authentication failed for user "postgres"

From Dev

remote: Invalid username or password, fatal: Authentication failed for

From Dev

PostgreSQL SSPI authentication - FATAL: 2801: password authentication failed for user "xxx"

From Java

git remote: Invalid username or password. fatal: Authentication failed - ubuntu

From Java

FATAL: password authentication failed for user "postgres" (postgresql 11 with pgAdmin 4)

From Dev

psql: FATAL: password authentication failed for user windows 8

From Dev

remote: Invalid username or password. fatal: Authentication failed for

From Dev

PG::ConnectionBad: FATAL: password authentication failed for user "alphauser"

From Dev

Redshift connection issue: FATAL: password authentication failed for user

From Dev

FATAL: password authentication failed for user "postgres" Ubuntu v20.10

From Dev

How to add Super Password to CakePHP 2.0 Authentication

From Dev

How to handle authentication popup when password contains '#'

From Dev

Authentication fails when add UsernamePasswordAuthenticationFilter

From Dev

Rails 5 in prod: PG::ConnectionBad: FATAL: password authentication failed for user "postgres" with Docker

From Dev

psql: FATAL: password authentication failed for user error while trying to access psql

From Dev

linux - add a password to a user that already has ssh authentication

From Dev

Add a "Full Name" Field to Firebase Email/Password Authentication?

From Dev

How to add authentication(Username/Password) in Twisted client server application in python?

From Dev

How to fallback to password authentication when Touch ID fails on iOS 8?

From Dev

Password authentication fails when trying to connect to postgresql from clojure with jdbc

From Dev

Gitlab 6.2 asking for username and password authentication when pushing to origin

From Dev

Gitlab 6.2 asking for username and password authentication when pushing to origin

From Dev

Allow password authentication in SSH only when there is no key in authorized_keys

From Dev

OpenConnect: Passing-over user password when executing authentication request?

From Dev

Authentication token manipulation error when expiring password (passwd --expire)

From Dev

How to disable "Shake password dialog when authentication fails" of Gnome Screensaver?

From Java

I tried to change postgresql md5 to scram-sha-256 and I get FATAL password authentication failed

From Dev

How to solve " django.db.utils.OperationalError: FATAL: password authentication failed for user "Oeloun-pc" " in Pycharm Windows?

From Java

Receiving "fatal: Not a git repository" when attempting to remote add a Git repo

Related Related

  1. 1

    FATAL: password authentication failed for user "postgres"

  2. 2

    remote: Invalid username or password, fatal: Authentication failed for

  3. 3

    PostgreSQL SSPI authentication - FATAL: 2801: password authentication failed for user "xxx"

  4. 4

    git remote: Invalid username or password. fatal: Authentication failed - ubuntu

  5. 5

    FATAL: password authentication failed for user "postgres" (postgresql 11 with pgAdmin 4)

  6. 6

    psql: FATAL: password authentication failed for user windows 8

  7. 7

    remote: Invalid username or password. fatal: Authentication failed for

  8. 8

    PG::ConnectionBad: FATAL: password authentication failed for user "alphauser"

  9. 9

    Redshift connection issue: FATAL: password authentication failed for user

  10. 10

    FATAL: password authentication failed for user "postgres" Ubuntu v20.10

  11. 11

    How to add Super Password to CakePHP 2.0 Authentication

  12. 12

    How to handle authentication popup when password contains '#'

  13. 13

    Authentication fails when add UsernamePasswordAuthenticationFilter

  14. 14

    Rails 5 in prod: PG::ConnectionBad: FATAL: password authentication failed for user "postgres" with Docker

  15. 15

    psql: FATAL: password authentication failed for user error while trying to access psql

  16. 16

    linux - add a password to a user that already has ssh authentication

  17. 17

    Add a "Full Name" Field to Firebase Email/Password Authentication?

  18. 18

    How to add authentication(Username/Password) in Twisted client server application in python?

  19. 19

    How to fallback to password authentication when Touch ID fails on iOS 8?

  20. 20

    Password authentication fails when trying to connect to postgresql from clojure with jdbc

  21. 21

    Gitlab 6.2 asking for username and password authentication when pushing to origin

  22. 22

    Gitlab 6.2 asking for username and password authentication when pushing to origin

  23. 23

    Allow password authentication in SSH only when there is no key in authorized_keys

  24. 24

    OpenConnect: Passing-over user password when executing authentication request?

  25. 25

    Authentication token manipulation error when expiring password (passwd --expire)

  26. 26

    How to disable "Shake password dialog when authentication fails" of Gnome Screensaver?

  27. 27

    I tried to change postgresql md5 to scram-sha-256 and I get FATAL password authentication failed

  28. 28

    How to solve " django.db.utils.OperationalError: FATAL: password authentication failed for user "Oeloun-pc" " in Pycharm Windows?

  29. 29

    Receiving "fatal: Not a git repository" when attempting to remote add a Git repo

HotTag

Archive