Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

OpenERP Server Error after installing on Ubuntu.

By
Shahar Or
on 3/11/13, 7:34 AM 6,240 views

Hey,

  1. I've installed on Ubuntu precise (12.04) using the deb package 7.0-20130311-002114-1 .
  2. Visited the web interface and bam!

I get this error:

OpenERP Server Error

Client Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/http.py", line 203, in dispatch
    response["result"] = method(self, **self.params)
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 704, in get_list
    return db_list(req)
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 88, in db_list
    dbs = proxy.list()
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/session.py", line 31, in proxy_method
    result = self.session.send(self.service_name, method, *args)
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/session.py", line 104, in send
    raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)


Server Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/session.py", line 90, in send
    return openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/usr/lib/pymodules/python2.7/openerp/netsvc.py", line 293, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/usr/lib/pymodules/python2.7/openerp/service/web_services.py", line 122, in dispatch
    return fn(*params)
  File "/usr/lib/pymodules/python2.7/openerp/service/web_services.py", line 351, in exp_list
    cr = db.cursor()
  File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 484, in cursor
    return Cursor(self._pool, self.dbname, serialized=serialized)
  File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 182, in __init__
    self._cnx = pool.borrow(dsn(dbname))
  File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 377, in _locked
    return fun(self, *args, **kwargs)
  File "/usr/lib/pymodules/python2.7/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:  role "openerp" does not exist

Edit: I went #dpkg-reconfigure openerp And I don't get this message anymore. Perhaps while the openerp package was configured initially, postgresql wasn't yet configured?

2

Parth Gajjar

--Parth Gajjar--
1484
| 3 3 5
Ahmadabad, India
--Parth Gajjar--
Parth Gajjar
On 3/11/13, 7:47 AM

Click at below link and follow instruction for create new role with name 'openerp' and other postgres database Configuration

http://doc.openerp.com/v6.1/install/linux/postgres/index.html#setup-a-postgresql-user-for-openerp (Doc.Openerp)

#dpkg-reconfigure openerp did it

Shahar Or
on 3/11/13, 4:57 PM
1
Shahar Or
On 3/11/13, 4:58 PM
#dpkg-reconfigure openerp

Solves the problem. This is probably a bug.

0

Andreas Brueckl

--Andreas Brueckl--
5056
| 7 8 7
Vienna, Austria
--Andreas Brueckl--
OpenERP Consulting and Development
Andreas Brueckl
On 3/11/13, 8:14 AM

Thanks. There was no need for me to go into all that script writing, setting up, configuring and such. That's what distro packages are for :)

Shahar Or
on 3/11/13, 4:57 PM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 3/11/13, 7:34 AM
Seen: 6240 times
Last updated: 3/16/15, 8:10 AM