This question has been flagged
4 Replies
7763 Views

Hi all

Trying out OpenERP to see if it's what im looking for :)

I have made a openvz in proxmox based on ubuntu server 12.04.3 64 bit.

I have installed my template contaning the ubuntu image.

I have added the ppa to the source list

I then updated the system using "apt-get update"

I then installed openvz using "apt-get install openerp"

then i logged into the webpage and got this error:

{"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 292, 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 573, 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 292, 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 found this post here: my karma is too low to post link but the tital was:

ubuntu-linux-1204-64-bit-after-installation-internal-server-error

where the suggested answer is:

sudo su - postgres
createuser --createdb --username postgres --no-createrole --no-superuser --pwprompt openerp

i still get the error though.. also after reboot..

Any suggestions?

THANKS

Casper

Avatar
Discard
Best Answer

Reinstall/Upgrade your postgresql. I have upgraded to postgresql-9.3 and that seems to solve the issue.

Avatar
Discard
Best Answer

Only this solved my problem,

make a symbolic link to the /tmp/.s.PGSQL.5432:

sudo ln -s /tmp/.s.PGSQL.5432 /var/run/postgresql/.s.PGSQL.5432

Thanks to this post https://sukhjitsehra.wordpress.com/2015/07/06/is-postgresql-server-is-running-and-accepting-and-issue-with-varpgsql_socket-s-pgsql-5432/

Avatar
Discard
Best Answer

Hi, It seems to be problem with your postgres server. Try psql -l to fetch list of database and if it works try connecting openerp db via command psql -d <dbname> -U openerp -W <password>.

Provide the same username and password to openerp server.

Avatar
Discard
Best Answer

Casper,

This should surely help: http://www.serpentcs.com/serpentcs-category/installation

Feel free to post your question here.

Thanks.

Avatar
Discard