Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
I am installing odoo 9. I have followed the instructions and installed the server without issue. Now I can't seem to get the database connection going. For the database, I installed postgres and then did the following:
1. create user
> createuser --createdb --username postgres -h 127.0.0.1 --no-createrole --no-superuser --pwprompt odoo9
2. update pg_hba.conf
local all odoo9 md5
host all all 127.0.0.1/32 md5
I can connect to the database on the command line
> psql -U odoo9 -d db_addhaptics_odoo9
Password for user odoo9:
Type "help" for help.
I have updated the odoo config file to match the username and password. But when I try to launch the site, I get the following in my odoo log:
2016-09-06 21:42:02,893 19282 INFO ? openerp.addons.bus.models.bus: Bus.loop listen imbus on db postgres
2016-09-06 21:42:02,897 19282 INFO ? openerp.sql_db: Connection to the database failed
2016-09-06 21:42:02,898 19282 ERROR ? openerp.addons.bus.models.bus: Bus.loop error, sleep and retry
Traceback (most recent call last):
File "/opt/odoo9/addons/bus/models/bus.py", line 168, in run
File "/opt/odoo9/addons/bus/models/bus.py", line 146, in loop
with openerp.sql_db.db_connect('postgres').cursor() as cr:
File "/opt/odoo9/openerp/sql_db.py", line 630, in cursor
return Cursor(self.__pool, self.dbname, self.dsn, serialized=serialized)
File "/opt/odoo9/openerp/sql_db.py", line 164, in __init__
self._cnx = pool.borrow(dsn)
File "/opt/odoo9/openerp/sql_db.py", line 513, in _locked
return fun(self, *args, **kwargs)
File "/opt/odoo9/openerp/sql_db.py", line 581, in borrow
File "/usr/lib/python2.7/dist-packages/psycopg2/__init__.py", line 179, in connect
OperationalError: FATAL: password authentication failed for user "odoo9"
What am I doing wrong?
As per Odoo's installation instruction the user must be a superuser:
and the username to connect as should be Odoo9 and not postgres.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 9/6/16, 5:43 PM|
|Seen: 436 times|
|Last updated: 9/7/16, 4:57 PM|