Skip to Content
Menu
This question has been flagged
1 Reply
3656 Views

Hi , I am installing odoo8 on amazon EC2 web server . I installed ubuntu 14.04 on it and after that Odoo8 where executing all the steps it gives Internal Server Error for the Database Connection.

The error is,

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

Avatar
Discard
Best Answer

To me it looks like Odoo is connecting to Postgres using the username "ubuntu". The error message states that there is no Postgres user "ubuntu".

1) Find out what are the Postgres credentials (username and password)

2) Edit the Odoo config file (usually at /etc/odoo-server.conf) and change the db_user and db_pass options

Avatar
Discard
Related Posts Replies Views Activity
0
Mar 17
2640
1
Mar 15
3467
3
Nov 24
1077
1
Nov 23
1374
4
Sep 23
5987