Skip to Content
This question has been flagged
databasedatabasesmigrateodooodooV9
1 Reply
3889 Views
Avatar
Nicolas Cordi

Please i need help with that. i run the following command

sudo python migrate.py --config=/home/ayt/odoo80/config/openerp-server2.conf --database=aytcomputers2 --run-migrations=9.0

and i got these errors

raceback (most recent call last):

  File "migrate.py", line 361, in <module>

    db_name = copy_database(conn_parms)

  File "migrate.py", line 25, in copy_database

    conn = psycopg2.connect(**conn_parms)

  File "/usr/lib/python2.7/dist-packages/psycopg2/__init__.py", line 179, in connect

    connection_factory=connection_factory, async=async)

psycopg2.OperationalError: FATAL: password authentication failed for user "odoo"

Avatar
Discard
Avatar
Subhanullah
Best Answer

The odoo password in the openerp config file does not match with the odoo password in PostgreSQL database, please alter the role odoo in your PostgreSQL DB with a proper password then set that password in the odoo config file.

Do this in your PostgreSQL DB

ALTER ROLE odoo WITH PASSWORD 'Your Password'

Edit the /etc/odoo-config

db_user = odoo

db_password = Your Password

 

Avatar
Discard
Related Posts Replies Views Activity
Where can get sample databases for testing? Solved
database databases odoo examples
Avatar
Avatar
Avatar
2
Feb 22
15257
How to migrate from Odoo 8 database to Odoo 9?
database restore migrate odooV8 odooV9
Avatar
Avatar
Avatar
Avatar
3
Mar 16
21228
clean purchase history
database odoo
Avatar
Avatar
1
Mar 24
2429
How can I recover ownership? Solved
database odoo
Avatar
Avatar
1
Feb 23
2749
Odoo database failed Solved
database odoo
Avatar
Avatar
1
Dec 22
12607