This question has been flagged
1 Reply
4964 Views

Hello, I can start the openerp-server as a daemon and use it without any problems.

Now if I want to start a test server via Eclipse I get the following error in the browser:
Internal Server Error {"message": "OpenERP Server Error", "code": 200, "data": {"debug": "Server Traceback (most recent call last):\n File \"/home/ubuntu/workspace/OpenERP_deploy/openerp/addons/web/session.py\", line 89, in send\n return openerp.netsvc.dispatch_rpc(service_name, method, args)\n File \"/home/ubuntu/workspace/OpenERP_deploy/openerp/netsvc.py\", line 292, in dispatch_rpc\n result = ExportService.getService(service_name).dispatch(method, params)\n File \"/home/ubuntu/workspace/OpenERP_deploy/openerp/service/web_services.py\", line 122, in dispatch\n return fn(params)\n File \"/home/ubuntu/workspace/OpenERP_deploy/openerp/service/web_services.py\", line 359, in exp_list\n cr = db.cursor()\n File \"/home/ubuntu/workspace/OpenERP_deploy/openerp/sql_db.py\", line 484, in cursor\n return Cursor(self._pool, self.dbname, serialized=serialized)\n File \"/home/ubuntu/workspace/OpenERP_deploy/openerp/sql_db.py\", line 182, in __init__\n self._cnx = pool.borrow(dsn(dbname))\n File \"/home/ubuntu/workspace/OpenERP_deploy/openerp/sql_db.py\", line 377, in _locked\n return fun(self, *args, *kwargs)\n File \"/home/ubuntu/workspace/OpenERP_deploy/openerp/sql_db.py\", line 440, in borrow\n result = psycopg2.connect(dsn=dsn, connection_factory=PsycoConnection)\n File \"/usr/lib/python2.7/dist-packages/psycopg2/__init__.py\", line 179, in connect\n connection_factory=connection_factory, async=async)\nOperationalError: FATAL: Peer authentication failed for user \"openerp\"\n\n\nClient Traceback (most recent call last):\n File \"/home/ubuntu/workspace/OpenERP_deploy/openerp/addons/web/http.py\", line 285, in dispatch\n r = method(self, **self.params)\n File \"/home/ubuntu/workspace/OpenERP_deploy/openerp/addons/web/controllers/main.py\", line 570, in index\n db, redir = db_monodb_redirect(req)\n File \"/home/ubuntu/workspace/OpenERP_deploy/openerp/addons/web/controllers/main.py\", line 98, in db_monodb_redirect\n return db_redirect(req, not config['list_db'])\n File \"/home/ubuntu/workspace/OpenERP_deploy/openerp/addons/web/controllers/main.py\", line 109, in db_redirect\n dbs = db_list(req, True)\n File \"/home/ubuntu/workspace/OpenERP_deploy/openerp/addons/web/controllers/main.py\", line 90, in db_list\n dbs = proxy.list(force)\n File \"/home/ubuntu/workspace/OpenERP_deploy/openerp/addons/web/session.py\", line 30, in proxy_method\n result = self.session.send(self.service_name, method, *args)\n File \"/home/ubuntu/workspace/OpenERP_deploy/openerp/addons/web/session.py\", line 103, in send\n raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)\nFault: <fault fatal:="" peer="" authentication="" failed="" for="" user="" \"openerp\"\n:="" 'traceback="" (most="" recent="" call="" last):\\n="" file="" \"="" home="" ubuntu="" workspace="" openerp_deploy="" openerp="" addons="" web="" session.py\",="" line="" 89,="" in="" send\\n="" return="" openerp.netsvc.dispatch_rpc(service_name,="" method,="" args)\\n="" file="" \"="" home="" ubuntu="" workspace="" openerp_deploy="" openerp="" netsvc.py\",="" line="" 292,="" in="" dispatch_rpc\\n="" result="ExportService.getService(service_name).dispatch(method," params)\\n="" file="" \"="" home="" ubuntu="" workspace="" openerp_deploy="" openerp="" service="" web_services.py\",="" line="" 122,="" in="" dispatch\\n="" return="" fn(*params)\\n="" file="" \"="" home="" ubuntu="" workspace="" openerp_deploy="" openerp="" service="" web_services.py\",="" line="" 359,="" in="" exp_list\\n="" cr="db.cursor()\\n" file="" \"="" home="" ubuntu="" workspace="" openerp_deploy="" openerp="" sql_db.py\",="" line="" 484,="" in="" cursor\\n="" return="" cursor(self._pool,="" self.dbname,="" serialized="serialized)\\n" file="" \"="" home="" ubuntu="" workspace="" openerp_deploy="" openerp="" sql_db.py\",="" line="" 182,="" in="" __init__\\n="" self._cnx="pool.borrow(dsn(dbname))\\n" file="" \"="" home="" ubuntu="" workspace="" openerp_deploy="" openerp="" sql_db.py\",="" line="" 377,="" in="" _locked\\n="" return="" fun(self,="" *args,="" **kwargs)\\n="" file="" \"="" home="" ubuntu="" workspace="" openerp_deploy="" openerp="" sql_db.py\",="" line="" 440,="" in="" borrow\\n="" result="psycopg2.connect(dsn=dsn," connection_factory="PsycoConnection)\\n" file="" \"="" usr="" lib="" python2.7="" dist-packages="" psycopg2="" __init__.py\",="" line="" 179,="" in="" connect\\n="" connection_factory="connection_factory," async="async)\\nOperationalError:" fatal:="" peer="" authentication="" failed="" for="" user="" \"openerp\"\\n\\n'="">\n", "fault_code": "FATAL: Peer authentication failed for user \"openerp\"\n", "type": "server_exception"}}

The following was recorded in the log file:
2014-02-14 22:19:18,523 5017 INFO ? openerp: OpenERP version 7.0-20140214-002644 2014-02-14 22:19:18,524 5017 INFO ? openerp: addons paths: /home/ubuntu/workspace/OpenERP_deploy/openerp/addons 2014-02-14 22:19:18,524 5017 INFO ? openerp: database hostname: localhost 2014-02-14 22:19:18,524 5017 INFO ? openerp: database port: 5432 2014-02-14 22:19:18,524 5017 INFO ? openerp: database user: openerp 2014-02-14 22:19:18,981 5017 INFO ? openerp.addons.google_docs.google_docs: GData lib version %s GData-Python/2.0.14 detected 2014-02-14 22:19:19,257 5017 INFO ? openerp.service.wsgi_server: HTTP service (werkzeug) running on 0.0.0.0:8069 2014-02-14 22:19:19,258 5017 INFO ? openerp: OpenERP server is running, waiting for connections... 2014-02-14 22:19:34,288 5017 INFO ? openerp.service: Initiating shutdown 2014-02-14 22:19:34,288 5017 INFO ? openerp.service: Hit CTRL-C again or send a second signal to force the shutdown. 2014-02-14 22:20:07,579 5040 INFO ? openerp: OpenERP version 7.0-20140214-002644 2014-02-14 22:20:07,579 5040 INFO ? openerp: addons paths: /home/ubuntu/workspace/OpenERP_deploy/openerp/addons 2014-02-14 22:20:07,579 5040 INFO ? openerp: database hostname: localhost 2014-02-14 22:20:07,579 5040 INFO ? openerp: database port: 5432 2014-02-14 22:20:07,579 5040 INFO ? openerp: database user: openerp 2014-02-14 22:20:08,003 5040 INFO ? openerp.addons.google_docs.google_docs: GData lib version %s GData-Python/2.0.14 detected 2014-02-14 22:20:08,316 5040 INFO ? openerp.service.wsgi_server: HTTP service (werkzeug) running on 0.0.0.0:8069 2014-02-14 22:20:08,317 5040 INFO ? openerp: OpenERP server is running, waiting for connections... 2014-02-14 22:20:21,706 5040 ERROR ? openerp.sql_db: Connection to the database failed Traceback (most recent call last): File "/home/ubuntu/workspace/OpenERP_deploy/openerp/sql_db.py", line 440, in borrow result = psycopg2.connect(dsn=dsn, connection_factory=PsycoConnection) File "/usr/lib/python2.7/dist-packages/psycopg2/__init__.py", line 179, in connect connection_factory=connection_factory, async=async) OperationalError: FATAL: Peer authentication failed for user "openerp"

Finally it should be mentioned that I have set in the Eclipse run configuration arguments the same openerp-server.conf as it is used by the demon.

regards

Avatar
Discard
Author Best Answer

I fixed it by replacing the content of the pg_hba.conf file with:

local all postgres peer
local all all trust
host all all 127.0.0.1/32 md5
host all all ::1/128 ident

Avatar
Discard