Skip to Content
Menu
This question has been flagged
1 Reply
10251 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.

 

ideas?

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
    self.loop()
  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"

Avatar
Discard
Best Answer

Hi, that means odoo can not connect postrgesql. 

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

2. Check if postgresql is running.

Best Regards

 

Avatar
Discard
Related Posts Replies Views Activity
17
Jul 24
63375
1
Mar 15
4571
3
Sep 17
23612
1
Aug 16
5540
1
Mar 15
6421