This question has been flagged
2 Replies
5749 Views

After install openerp on raspberry Pi, and i run openerp-server it shows "OperERP server is running, waiting for connection".

However, when I use client broswer accessing "http://192.168.1.139:8069" it shows "500 Internal Server Error" with the following message,

 

{"message": "OpenERP Server Error", "code": 200, "data": {"debug": "Server Traceback (most recent call last):\n File \"/usr/lib/pymodules/python2.7/openerp/addons/web/session.py\", line 89, in send\n return openerp.netsvc.dispatch_rpc(service_name, method, args)\n File \"/usr/lib/pymodules/python2.7/openerp/netsvc.py\", line 296, in dispatch_rpc\n result = ExportService.getService(service_name).dispatch(method, params)\n File \"/usr/lib/pymodules/python2.7/openerp/service/web_services.py\", line 122, in dispatch\n return fn(*params)\n File \"/usr/lib/pymodules/python2.7/openerp/service/web_services.py\", line 359, in exp_list\n cr = db.cursor()\n File \"/usr/lib/pymodules/python2.7/openerp/sql_db.py\", line 484, in cursor\n return Cursor(self.__pool, self.dbname, serialized=serialized)\n File \"/usr/lib/pymodules/python2.7/openerp/sql_db.py\", line 182, in __init__\n self._cnx = pool.borrow(dsn(dbname))\n File \"/usr/lib/pymodules/python2.7/openerp/sql_db.py\", line 377, in _locked\n return fun(self, *args, **kwargs)\n File \"/usr/lib/pymodules/python2.7/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: could not connect to server: No such file or directory\n\tIs the server running locally and accepting\n\tconnections on Unix domain socket \"/var/run/postgresql/.s.PGSQL.5432\"?\n\n\nClient Traceback (most recent call last):\n File \"/usr/lib/pymodules/python2.7/openerp/addons/web/http.py\", line 285, in dispatch\n r = method(self, **self.params)\n File \"/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py\", line 570, in index\n db, redir = db_monodb_redirect(req)\n File \"/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py\", line 98, in db_monodb_redirect\n return db_redirect(req, not config['list_db'])\n File \"/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py\", line 109, in db_redirect\n dbs = db_list(req, True)\n File \"/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py\", line 90, in db_list\n dbs = proxy.list(force)\n File \"/usr/lib/pymodules/python2.7/openerp/addons/web/session.py\", line 30, in proxy_method\n result = self.session.send(self.service_name, method, *args)\n File \"/usr/lib/pymodules/python2.7/openerp/addons/web/session.py\", line 103, in send\n raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)\nFault: <Fault could not connect to server: No such file or directory\n\tIs the server running locally and accepting\n\tconnections on Unix domain socket \"/var/run/postgresql/.s.PGSQL.5432\"?\n: 'Traceback (most recent call last):\\n File \"/usr/lib/pymodules/python2.7/openerp/addons/web/session.py\", line 89, in send\\n return openerp.netsvc.dispatch_rpc(service_name, method, args)\\n File \"/usr/lib/pymodules/python2.7/openerp/netsvc.py\", line 296, in dispatch_rpc\\n result = ExportService.getService(service_name).dispatch(method, params)\\n File \"/usr/lib/pymodules/python2.7/openerp/service/web_services.py\", line 122, in dispatch\\n return fn(*params)\\n File \"/usr/lib/pymodules/python2.7/openerp/service/web_services.py\", line 359, in exp_list\\n cr = db.cursor()\\n File \"/usr/lib/pymodules/python2.7/openerp/sql_db.py\", line 484, in cursor\\n return Cursor(self.__pool, self.dbname, serialized=serialized)\\n File \"/usr/lib/pymodules/python2.7/openerp/sql_db.py\", line 182, in __init__\\n self._cnx = pool.borrow(dsn(dbname))\\n File \"/usr/lib/pymodules/python2.7/openerp/sql_db.py\", line 377, in _locked\\n return fun(self, *args, **kwargs)\\n File \"/usr/lib/pymodules/python2.7/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: could not connect to server: No such file or directory\\n\\tIs the server running locally and accepting\\n\\tconnections on Unix domain socket \"/var/run/postgresql/.s.PGSQL.5432\"?\\n\\n'>\n", "fault_code": "could not connect to server: No such file or directory\n\tIs the server running locally and accepting\n\tconnections on Unix domain socket \"/var/run/postgresql/.s.PGSQL.5432\"?\n", "type": "server_exception"}}

 

 

 

I'm a newbie to odoo, I have no concept for everything.  Please help.

Avatar
Discard

Hi Adam, What were the steps you used to install Odoo? What linux distribution are you using? Please explain a little more about your setup.

Odoo best way run only on ubuntu with 1GB RAM minimum, please Odoo not for raspberry pi, if you want to run it better way. Utilize Peewee

Author Best Answer

Thanks for replying.  I'm using Raspbian comes with Raspberry PI. 

 

Luke:

I'm using a fresh installed OS.  After using "apt-get install openerp", it required me to change the locale setting, so I set all locale related setting to "en_US.UTF-8", other things keep unchange.

 

Zahin:

I am trying to make a similar project as POSBOX, and I just want to use in my small shop.  So it would be nice if I can make it by my owned Raspberry PI, iPad without purchasing other hardware.

Similar project has been made by others:

http://www.baconconsult.eu/home/our-products/openerp/technical-documentation/installing-openerp-v70-on-a-raspberry-pi

I think it would be run properly.

 

 

 

Avatar
Discard
Best Answer

As the log says, openerp has not been able to connect to your PostgreSQL instance - check your openerp-server.conf file if it is correctly set up. Most likely instance is not running at all, so check if you are able to connect with postgres user directly to psql server.

Avatar
Discard