Odoo Help


This community 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.


OSX - OperationalError: FATAL: password authentication failed for user

Howard Crow
on 7/4/14, 12:25 AM 2,464 views

Looking for ideas...

I am having a difficult time getting open ERP to connect to PostgreSQL on my Mac Devbox. Running the 8.0 Trunk off Git. 

  • There are super users in Postgresql
  • I have edited both the .Openerp-serverrc and openerp-server.conf files with matching db passwords/users to postgresql
  • Tried running the odoo server under different accounts

I get the 500 internal server error on the webpage and this in terminal.



2014-07-04 04:19:31,589 1987 ERROR ? openerp.addons.bus.bus: Bus.loop error, sleep and retry
Traceback (most recent call last):
  File "/Volumes/SSD/odoo/addons/bus/bus.py", line 136, in run
  File "/Volumes/SSD/odoo/addons/bus/bus.py", line 114, in loop
    with openerp.sql_db.db_connect('postgres').cursor() as cr:
  File "/Volumes/SSD/odoo/openerp/sql_db.py", line 555, in cursor
    return Cursor(self.__pool, self.dbname, serialized=serialized)
  File "/Volumes/SSD/odoo/openerp/sql_db.py", line 176, in __init__
    self._cnx = pool.borrow(dsn(dbname))
  File "/Volumes/SSD/odoo/openerp/sql_db.py", line 448, in _locked
    return fun(self, *args, **kwargs)
  File "/Volumes/SSD/odoo/openerp/sql_db.py", line 511, in borrow
    result = psycopg2.connect(dsn=dsn, connection_factory=PsycoConnection)
  File "/opt/local/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/psycopg2/__init__.py", line 164, in connect
    conn = _connect(dsn, connection_factory=connection_factory, async=async)
OperationalError: FATAL:  password authentication failed for user "xxxxxxxx"

Vasili Pascal
On 1/29/15, 3:46 AM

Hi, that means odoo can not connect postrgesql. 

1. Check connection details login/password/db name.

2. Check if postgresql is running.

Best Regards


Your Answer

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 community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)


Asked: 7/4/14, 12:25 AM
Seen: 2464 times
Last updated: 3/16/15, 8:10 AM