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:
psql (9.3.11)
Type "help" for help.
db_addhaptics_odoo9=>
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
self.loop()
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
**connection_info)
File "/usr/lib/python2.7/dist-packages/psycopg2/__init__.py", line 179, in connect
connection_factory=connection_factory, async=async)
OperationalError: FATAL: password authentication failed for user "odoo9"
What am I doing wrong?
