Skip to Content
Menu
This question has been flagged
2 Replies
2401 Views

Hi Guys, 

i have some problems by upgrading my odoo Community version to odoo Enterprise. 

I already purchased the Enterprise license, but the upgrading still not working. I am doing exactly what you are writing on the documentation for upgrading: https://www.odoo.com/documentation/10.0/setup/enterprise.html

The installation of the .deb file worked. But now I have a problem with updating the odoo database using the 

  • $ python /usr/bin/odoo.py -d <database_name> -u web --stop-after-init
    

First of all: the data odoo.py does not exists in /usr/bin. There is just a data called odoo without the extension .py 

I always get this message back after running the script:

Running as user 'root' is a security risk.

2017-04-05 21:45:49,407 6869 INFO ? odoo: Odoo version 10.0+e-20170403

2017-04-05 21:45:49,407 6869 INFO ? odoo: addons paths: ['/root/.local/share/Odoo/addons/10.0', u'/usr/lib/python2.7/dist-packages/odoo/addons']

2017-04-05 21:45:49,407 6869 INFO ? odoo: database: default@default:default

2017-04-05 21:45:49,409 6869 INFO ? odoo.sql_db: Connection to the database failed

Traceback (most recent call last):

  File "odoo", line 9, in <module>

    odoo.cli.main()

  File "/usr/lib/python2.7/dist-packages/odoo/cli/command.py", line 64, in main

    o.run(args)

  File "/usr/lib/python2.7/dist-packages/odoo/cli/server.py", line 164, in run

    main(args)

  File "/usr/lib/python2.7/dist-packages/odoo/cli/server.py", line 138, in main

    odoo.service.db._create_empty_database(db_name)

  File "/usr/lib/python2.7/dist-packages/odoo/service/db.py", line 79, in _create_empty_database

    with closing(db.cursor()) as cr:

  File "/usr/lib/python2.7/dist-packages/odoo/sql_db.py", line 622, in cursor

    return Cursor(self.__pool, self.dbname, self.dsn, serialized=serialized)

  File "/usr/lib/python2.7/dist-packages/odoo/sql_db.py", line 164, in __init__

    self._cnx = pool.borrow(dsn)

  File "/usr/lib/python2.7/dist-packages/odoo/sql_db.py", line 505, in _locked

    return fun(self, *args, **kwargs)

  File "/usr/lib/python2.7/dist-packages/odoo/sql_db.py", line 573, in borrow

    **connection_info)

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

    conn = _connect(dsn, connection_factory=connection_factory, async=async)

psycopg2.OperationalError: FATAL:  role "root" does not exist

Avatar
Discard
Best Answer

because the user 'root' doesn't have in your DB user role, so you need to create user 'root' in your DB.

please note one important thing, if you install many version of postgres, you need add argument file config, that in file config specific port that odoo is trying to connect to

ex: ./odoo-bin -c odoo.conf -d web_minhtech -i web_enterprise --stop-after-init

Avatar
Discard
Author Best Answer

Thank you all for nothing.. solved my problem my self.. the odoo documentation is not good enough for me

Avatar
Discard