在亚马逊网络服务器EC2上安装时发生Odoo内部服务器错误



我正在亚马逊EC2 web服务器上安装odoo8。我在上面安装了ubuntu 14.04,之后Odoo8在执行所有步骤时,会出现数据库连接的内部服务器错误。

错误是,

Traceback (most recent call last):
  File "/usr/lib/python2.7/dist-packages/werkzeug/serving.py", line 177, in run_wsgi
    execute(self.server.app)
  File "/usr/lib/python2.7/dist-packages/werkzeug/serving.py", line 165, in execute
    application_iter = app(environ, start_response)
  File "/home/ubuntu/odoo/openerp/service/server.py", line 290, in app
    return self.app(e, s)
  File "/home/ubuntu/odoo/openerp/service/wsgi_server.py", line 216, in application
    return application_unproxied(environ, start_response)
  File "/home/ubuntu/odoo/openerp/service/wsgi_server.py", line 202, in application_unproxied
    result = handler(environ, start_response)
  File "/home/ubuntu/odoo/openerp/http.py", line 1290, in __call__
    return self.dispatch(environ, start_response)
  File "/home/ubuntu/odoo/openerp/http.py", line 1264, in __call__
    return self.app(environ, start_wrapped)
  File "/usr/lib/python2.7/dist-packages/werkzeug/wsgi.py", line 579, in __call__
    return self.app(environ, start_response)
  File "/home/ubuntu/odoo/openerp/http.py", line 1406, in dispatch
    self.setup_db(httprequest)
  File "/home/ubuntu/odoo/openerp/http.py", line 1348, in setup_db
    httprequest.session.db = db_monodb(httprequest)
  File "/home/ubuntu/odoo/openerp/http.py", line 1478, in db_monodb
    dbs = db_list(True, httprequest)
  File "/home/ubuntu/odoo/openerp/http.py", line 1452, in db_list
    dbs = dispatch_rpc("db", "list", [force])
  File "/home/ubuntu/odoo/openerp/http.py", line 115, in dispatch_rpc
    result = dispatch(method, params)
  File "/home/ubuntu/odoo/openerp/service/db.py", line 73, in dispatch
    return fn(*params)
  File "/home/ubuntu/odoo/openerp/service/db.py", line 313, in exp_list
    with closing(db.cursor()) as cr:
  File "/home/ubuntu/odoo/openerp/sql_db.py", line 575, in cursor
    return Cursor(self.__pool, self.dbname, self.dsn, serialized=serialized)
  File "/home/ubuntu/odoo/openerp/sql_db.py", line 181, in __init__
    self._cnx = pool.borrow(dsn)
  File "/home/ubuntu/odoo/openerp/sql_db.py", line 464, in _locked
    return fun(self, *args, **kwargs)
  File "/home/ubuntu/odoo/openerp/sql_db.py", line 526, in borrow
    result = psycopg2.connect(dsn=dsn, connection_factory=PsycoConnection)
  File "/usr/lib/python2.7/dist-packages/psycopg2/__init__.py", line 179, in connect
    connection_factory=connection_factory, async=async)
OperationalError: FATAL: role "ubuntu" does not exist
2015-07-01 11:41:16,580 1315 ERROR None openerp.sql_db: Connection to the database failed

我认为问题出在postgres用户身上。检查/etc/openerp-server.conf file中的db_user。看起来用户是ubuntu,而不是postgres用户。您需要在postgres中创建用户ubuntu,或者将配置文件中的用户更改为现有的postgres用户。

问题是您的postgres数据库中不存在用户名ubuntu,让我们转到解决方案:

  1. 首先,您需要使用以下命令在postgres中创建名为ubuntu的use

使用密码"ubuntu"创建用户ubuntu;

  1. 然后,您需要像这样将权限授予ubuntu用户

ALTER USER ubuntu CREATEUSER CREATEDB;

最新更新