openerp-india team mailing list archive

Thread
Date
[Bug 1001748] Re: [6.1] Server error after new installation on Ubuntu 12.04 LTS

To: openerp-india@xxxxxxxxxxxxxxxxxxx
From: "Amit Parik \(OpenERP\)" <amp@xxxxxxxxxxx>
Date: Mon, 23 Jul 2012 11:24:00 -0000
Reply-to: Bug 1001748 <1001748@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Hello Daniel,

It's not a bug, but the problem comes due to the problem of postgres
configuration. I think you have to reinstall postgres and reconfigure
it. (please create postgres user same as your system user)

Please check this link
http://doc.openerp.com/v6.1/install/linux/postgres/index.html. It will
help you.

Thank you!

** Changed in: openobject-server
       Status: New => Invalid

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Server.
https://bugs.launchpad.net/bugs/1001748

Title:
  [6.1] Server error after new installation on Ubuntu 12.04 LTS

Status in OpenERP Server:
  Invalid

Bug description:
  I Installed Ubuntu 12.04 LTS on a new virtual machine.
  I completed all updates for the operating system (date of today).
  I downloaded the debian-package from the website and used the package manager to install it.
  __________________________________________________________
  I opened a browser and tried to open the adress localhost:8069
  I get the following error message in the browser:

  Client Traceback (most recent call last):
    File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/http.py", line 180, in dispatch
      response["result"] = method(controller, self, **self.params)
    File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 353, in get_list
      dbs = proxy.list()
    File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/openerplib/main.py", line 117, in proxy
      result = self.connector.send(self.service_name, method, *args)
    File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/http.py", line 611, in send
      raise fault

  
  Server Traceback (most recent call last):
    File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/http.py", line 592, in send
      result = openerp.netsvc.dispatch_rpc(service_name, method, args)
    File "/usr/lib/pymodules/python2.7/openerp/netsvc.py", line 360, in dispatch_rpc
      result = ExportService.getService(service_name).dispatch(method, params)
    File "/usr/lib/pymodules/python2.7/openerp/service/web_services.py", line 117, in dispatch
      return fn(*params)
    File "/usr/lib/pymodules/python2.7/openerp/service/web_services.py", line 310, in exp_list
      cr = db.cursor()
    File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 465, in cursor
      return Cursor(self._pool, self.dbname, serialized=serialized)
    File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 173, in __init__
      self._cnx = pool.borrow(dsn(dbname))
    File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 366, in _locked
      return fun(self, *args, **kwargs)
    File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 421, 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: could not connect to server: No such file or directory
  	Is the server running locally and accepting
  	connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
  ____________________________________________________________
  I opened a terminal and tried to start the openerp-server manually.
  I get the following error messages:

  openerp@openerp-VirtualBox:~$ openerp-server 
  2012-05-19 18:41:57,578 2022 INFO ? openerp: OpenERP version 6.1-1
  2012-05-19 18:41:57,578 2022 INFO ? openerp: addons paths: /usr/lib/pymodules/python2.7/openerp/addons
  2012-05-19 18:41:57,579 2022 INFO ? openerp: database hostname: localhost
  2012-05-19 18:41:57,579 2022 INFO ? openerp: database port: 5432
  2012-05-19 18:41:57,579 2022 INFO ? openerp: database user: openerp
  Traceback (most recent call last):
    File "/usr/bin/openerp-server", line 248, in <module>
      openerp.service.start_services()
    File "/usr/lib/pymodules/python2.7/openerp/service/__init__.py", line 65, in start_services
      netrpc_server.init_servers()
    File "/usr/lib/pymodules/python2.7/openerp/service/netrpc_server.py", line 165, in init_servers
      int(tools.config.get('netrpc_port', 8070)))
    File "/usr/lib/pymodules/python2.7/openerp/service/netrpc_server.py", line 110, in __init__
      self.socket.bind((self.__interface, self.__port))
    File "/usr/lib/python2.7/socket.py", line 224, in meth
      return getattr(self._sock,name)(*args)
  socket.error: [Errno 98] Address already in use

  ________________________________________________________
  I restarted the system, but the error messages stay the same.

  ________________________________________________________________
  In analgy to bug report #986310 I searched for the process id of openerp-server and killed the process.
  I started the process new.
  Log:

  openerp@openerp-VirtualBox:~$ ps -FC openerp-server
  UID        PID  PPID  C    SZ   RSS PSR STIME TTY          TIME CMD
  openerp    927     1  0 166808 54944  0 20:31 ?        00:00:03 /usr/bin/python
  openerp@openerp-VirtualBox:~$ kill -9 927
  openerp@openerp-VirtualBox:~$ openerp-server 
  2012-05-19 18:52:29,627 2543 INFO ? openerp: OpenERP version 6.1-1
  2012-05-19 18:52:29,627 2543 INFO ? openerp: addons paths: /usr/lib/pymodules/python2.7/openerp/addons
  2012-05-19 18:52:29,628 2543 INFO ? openerp: database hostname: localhost
  2012-05-19 18:52:29,628 2543 INFO ? openerp: database port: 5432
  2012-05-19 18:52:29,628 2543 INFO ? openerp: database user: openerp
  2012-05-19 18:52:29,628 2543 INFO ? openerp.service.netrpc_server: starting NET-RPC service on 0.0.0.0:8070
  2012-05-19 18:52:29,629 2543 INFO ? openerp.netsvc: Starting 1 services
  2012-05-19 18:52:29,732 2543 INFO ? openerp.wsgi.core: HTTP service (werkzeug) running on 0.0.0.0:8069
  2012-05-19 18:52:29,733 2543 INFO ? openerp.addons.web: embedded mode
  2012-05-19 18:52:29,974 2543 INFO ? openerp: OpenERP server is running, waiting for connections...
  2012-05-19 18:52:55,468 2543 INFO ? werkzeug: 127.0.0.1 - - [19/May/2012 18:52:55] "GET /web/webclient/home HTTP/1.1" 200 -
  2012-05-19 18:52:55,487 2543 INFO ? werkzeug: 127.0.0.1 - - [19/May/2012 18:52:55] "GET /web/webclient/css HTTP/1.1" 304 -
  2012-05-19 18:52:55,493 2543 INFO ? werkzeug: 127.0.0.1 - - [19/May/2012 18:52:55] "GET /web/webclient/js HTTP/1.1" 304 -
  2012-05-19 18:52:55,699 2543 INFO ? werkzeug: 127.0.0.1 - - [19/May/2012 18:52:55] "POST /web/session/get_session_info HTTP/1.1" 200 -
  2012-05-19 18:52:55,721 2543 INFO ? werkzeug: 127.0.0.1 - - [19/May/2012 18:52:55] "POST /web/webclient/qweblist HTTP/1.1" 200 -
  2012-05-19 18:52:55,786 2543 INFO ? werkzeug: 127.0.0.1 - - [19/May/2012 18:52:55] "POST /web/proxy/load HTTP/1.1" 200 -
  2012-05-19 18:52:55,843 2543 ERROR template1 openerp.sql_db: Connection to the database failed
  Traceback (most recent call last):
    File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 421, 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: could not connect to server: No such file or directory
  	Is the server running locally and accepting
  	connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

  2012-05-19 18:52:55,844 2543 ERROR template1 openerp.netsvc: could not connect to server: No such file or directory
  	Is the server running locally and accepting
  	connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

  2012-05-19 18:52:55,849 2543 INFO template1 werkzeug: 127.0.0.1 - - [19/May/2012 18:52:55] "POST /web/database/get_list HTTP/1.1" 200 -
  2012-05-19 18:52:55,863 2543 INFO ? werkzeug: 127.0.0.1 - - [19/May/2012 18:52:55] "POST /web/session/get_lang_list HTTP/1.1" 200 -
  2012-05-19 18:52:55,866 2543 ERROR template1 openerp.sql_db: Connection to the database failed
  Traceback (most recent call last):
    File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 421, 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: could not connect to server: No such file or directory
  	Is the server running locally and accepting
  	connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

  2012-05-19 18:52:55,866 2543 ERROR template1 openerp.netsvc: could not connect to server: No such file or directory
  	Is the server running locally and accepting
  	connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

  2012-05-19 18:52:55,867 2543 INFO template1 werkzeug: 127.0.0.1 - -
  [19/May/2012 18:52:55] "POST /web/database/get_list HTTP/1.1" 200 -

  _____________________________________________________
  The error message did not seem to change in the browser.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-server/+bug/1001748/+subscriptions
References

[Bug 1001748] [NEW] [6.1] Server error after new installation on Ubuntu 12.04 LTS
From: Daniel Krause, 2012-05-19