PostgreSQL database installed but not configured.

Bug #1061418 reported by PaulSchulz
10
This bug affects 1 person
Affects Status Importance Assigned to Milestone
openerp6.1 (Ubuntu)
Fix Released
High
Yolanda Robla

Bug Description

Well done and good work with this package.. I have installed 'opener6.1-full' on a freshly installed Ubuntu 12.10 x86_64 desktop installation from the standard repositories.

The log message from /var/log/openerp-server.log is
----
2012-10-04 06:19:42,791 25591 INFO ? openerp: OpenERP version 6.1-1
2012-10-04 06:19:42,798 25591 INFO ? openerp: addons paths: /usr/share/openerp/addons
2012-10-04 06:19:42,798 25591 INFO ? openerp: database hostname: localhost
2012-10-04 06:19:42,798 25591 INFO ? openerp: database port: 5432
2012-10-04 06:19:42,798 25591 INFO ? openerp: database user: openerp
2012-10-04 06:19:42,798 25591 INFO ? openerp.service.netrpc_server: starting NET-RPC service on 0.0.0.0:8070
2012-10-04 06:19:42,800 25591 INFO ? openerp.netsvc: Starting 1 services
2012-10-04 06:19:43,143 25591 INFO ? openerp.wsgi.core: HTTP service (werkzeug) running on 0.0.0.0:8069
2012-10-04 06:19:43,153 25591 INFO ? openerp.addons.web: embedded mode
2012-10-04 06:19:44,772 25591 INFO ? openerp: OpenERP server is running, waiting for connections...
2012-10-04 06:19:46,036 25591 INFO ? openerp.netsvc: Stopping 1 services
2012-10-04 06:19:46,037 25591 WARNING ? openerp.service.netrpc_server: Netrpc: closing because of exception [Errno 22] Invalid argument
2012-10-04 06:19:46,191 25591 INFO ? openerp.service: Initiating shutdown
2012-10-04 06:19:46,191 25591 INFO ? openerp.service: Hit CTRL-C again or send a second signal to force the shutdown.
2012-10-04 06:19:47,797 25767 INFO ? openerp: OpenERP version 6.1-1
2012-10-04 06:19:47,798 25767 INFO ? openerp: addons paths: /usr/share/openerp/addons
2012-10-04 06:19:47,798 25767 INFO ? openerp: database hostname: localhost
2012-10-04 06:19:47,798 25767 INFO ? openerp: database port: 5432
2012-10-04 06:19:47,798 25767 INFO ? openerp: database user: openerp
2012-10-04 06:19:47,798 25767 INFO ? openerp.service.netrpc_server: starting NET-RPC service on 0.0.0.0:8070
2012-10-04 06:19:47,798 25767 INFO ? openerp.netsvc: Starting 1 services
2012-10-04 06:19:47,976 25767 INFO ? openerp.wsgi.core: HTTP service (werkzeug) running on 0.0.0.0:8069
2012-10-04 06:19:47,985 25767 INFO ? openerp.addons.web: embedded mode
2012-10-04 06:19:48,430 25767 INFO ? openerp: OpenERP server is running, waiting for connections...
2012-10-04 06:23:47,426 25767 INFO ? werkzeug: 192.168.1.101 - - [04/Oct/2012 06:23:47] "GET / HTTP/1.1" 301 -
2012-10-04 06:23:47,430 25767 INFO ? werkzeug: 192.168.1.101 - - [04/Oct/2012 06:23:47] "GET /web/webclient/home HTTP/1.1" 200 -
2012-10-04 06:23:47,455 25767 INFO ? werkzeug: 192.168.1.101 - - [04/Oct/2012 06:23:47] "GET /web/webclient/css HTTP/1.1" 200 -
2012-10-04 06:23:47,477 25767 INFO ? werkzeug: 192.168.1.101 - - [04/Oct/2012 06:23:47] "GET /web/webclient/js HTTP/1.1" 200 -
2012-10-04 06:23:47,706 25767 INFO ? werkzeug: 192.168.1.101 - - [04/Oct/2012 06:23:47] "POST /web/session/get_session_info HTTP/1.1" 200 -
2012-10-04 06:23:47,709 25767 INFO ? werkzeug: 192.168.1.101 - - [04/Oct/2012 06:23:47] "POST /web/webclient/qweblist HTTP/1.1" 200 -
2012-10-04 06:23:47,746 25767 INFO ? werkzeug: 192.168.1.101 - - [04/Oct/2012 06:23:47] "GET /web/static/src/img/favicon.ico HTTP/1.1" 200 -
2012-10-04 06:23:47,750 25767 INFO ? werkzeug: 192.168.1.101 - - [04/Oct/2012 06:23:47] "POST /web/proxy/load HTTP/1.1" 200 -
2012-10-04 06:23:47,788 25767 ERROR template1 openerp.sql_db: Connection to the database failed
Traceback (most recent call last):
  File "/usr/share/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: FATAL: role "openerp" does not exist

2012-10-04 06:23:47,791 25767 ERROR template1 openerp.netsvc: FATAL: role "openerp" does not exist

2012-10-04 06:23:47,793 25767 INFO ? werkzeug: 192.168.1.101 - - [04/Oct/2012 06:23:47] "POST /web/session/get_lang_list HTTP/1.1" 200 -
2012-10-04 06:23:47,795 25767 INFO template1 werkzeug: 192.168.1.101 - - [04/Oct/2012 06:23:47] "POST /web/database/get_list HTTP/1.1" 200 -
2012-10-04 06:23:47,797 25767 ERROR template1 openerp.sql_db: Connection to the database failed
Traceback (most recent call last):
  File "/usr/share/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: FATAL: role "openerp" does not exist

2012-10-04 06:23:47,797 25767 ERROR template1 openerp.netsvc: FATAL: role "openerp" does not exist

2012-10-04 06:23:47,798 25767 INFO template1 werkzeug: 192.168.1.101 - - [04/Oct/2012 06:23:47] "POST /web/database/get_list HTTP/1.1" 200 -
2012-10-04 06:23:47,799 25767 INFO ? werkzeug: 192.168.1.101 - - [04/Oct/2012 06:23:47] "GET /web/static/src/img/logo2.png HTTP/1.1" 200 -
2012-10-04 06:23:47,799 25767 INFO ? werkzeug: 192.168.1.101 - - [04/Oct/2012 06:23:47] "GET /web/static/src/img/pattern.png HTTP/1.1" 200 -
2012-10-04 06:23:47,839 25767 INFO ? werkzeug: 192.168.1.101 - - [04/Oct/2012 06:23:47] "GET /web/static/lib/jquery.ui/css/smoothness/images/ui-bg_flat_75_ffffff_40x100.png HTTP/1.1" 200 -
2012-10-04 06:23:47,841 25767 INFO ? werkzeug: 192.168.1.101 - - [04/Oct/2012 06:23:47] "GET /web/static/lib/jquery.ui/css/smoothness/images/ui-icons_222222_256x240.png HTTP/1.1" 200 -
2012-10-04 06:23:47,842 25767 INFO ? werkzeug: 192.168.1.101 - - [04/Oct/2012 06:23:47] "GET /web/static/lib/jquery.ui/css/smoothness/images/ui-bg_glass_75_e6e6e6_1x400.png HTTP/1.1" 200 -
2012-10-04 06:23:47,843 25767 INFO ? werkzeug: 192.168.1.101 - - [04/Oct/2012 06:23:47] "GET /web/static/lib/jquery.ui/css/smoothness/images/ui-bg_flat_0_aaaaaa_40x100.png HTTP/1.1" 200 -
2012-10-04 06:23:47,844 25767 INFO ? werkzeug: 192.168.1.101 - - [04/Oct/2012 06:23:47] "GET /web/static/lib/jquery.ui/css/smoothness/images/ui-bg_glass_75_dadada_1x400.png HTTP/1.1" 200 -
----

When I browse to the appropriate website: http://192.168.1.171:8069 I get the following message.
-----
Your version of OpenERP is unsupported. Support & maintenance services are available here: OpenERP Entreprise.
OpenERP Server Error

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

Server Traceback (most recent call last):
  File "/usr/share/openerp/addons/web/common/http.py", line 592, in send
    result = openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/usr/share/openerp/netsvc.py", line 360, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/usr/share/openerp/service/web_services.py", line 117, in dispatch
    return fn(*params)
  File "/usr/share/openerp/service/web_services.py", line 310, in exp_list
    cr = db.cursor()
  File "/usr/share/openerp/sql_db.py", line 465, in cursor
    return Cursor(self._pool, self.dbname, serialized=serialized)
  File "/usr/share/openerp/sql_db.py", line 173, in __init__
    self._cnx = pool.borrow(dsn(dbname))
  File "/usr/share/openerp/sql_db.py", line 366, in _locked
    return fun(self, *args, **kwargs)
  File "/usr/share/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: FATAL: role "openerp" does not exist

Related branches

Changed in openerp6.1 (Ubuntu):
assignee: nobody → Yolanda Robla (yolanda.robla)
status: New → In Progress
Changed in openerp6.1 (Ubuntu):
importance: Undecided → High
Revision history for this message
Launchpad Janitor (janitor) wrote :

This bug was fixed in the package openerp6.1 - 6.1-1+dfsg-0ubuntu2

---------------
openerp6.1 (6.1-1+dfsg-0ubuntu2) quantal; urgency=low

  * Modified PostgreSQL dependency from Recommends to Depends (LP: #1061418)
 -- Yolanda Robla <email address hidden> Mon, 08 Oct 2012 15:37:00 +0100

Changed in openerp6.1 (Ubuntu):
status: In Progress → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.