This question has been flagged
1 Reply
2446 Views
databasedatabasesmigrateodooodooV9
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