Odoo Help

0

Can't connect to postgres with user

By
Mike Greenish
on 9/6/16, 5:43 PM 632 views

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?

1
Kinner Vachhani
On 9/7/16, 7:04 AM

Hi Mike,

Change the db_host in config to 127.0.0.1 and see if solves it.

0
Mike Greenish
On 9/7/16, 4:57 PM

Hi Kinner,

Changing the db_host (and adding a corresponding host line in my pg_hba.conf) did the trick!

Thanks for the help!!!

Mike

0

Ermin Trevisan

--Ermin Trevisan--
4484
| 6 4 7
Walchwil, Switzerland
--Ermin Trevisan--


Ermin Trevisan
On 9/7/16, 3:05 AM

As per Odoo's installation instruction the user must be a superuser:

https://www.odoo.com/documentation/9.0/setup/install.html#setup-install-source        

and the username to connect as should be Odoo9 and not postgres.

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

Question tools

1 follower(s)

Stats

Asked: 9/6/16, 5:43 PM
Seen: 632 times
Last updated: 9/7/16, 4:57 PM