This question has been flagged
2 Replies
4361 Views

I have a fresh install of OpenERP on Ubuntu and followed the instructions for running sudo apt-get... I can open the page at :8069 and get

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 759, in get_list return db_list(req) File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 89, 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 359, 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

I am unable to login as well. Any ideas?

Avatar
Discard
Author

Searched for a solution prior to posting then found it as soon as I posted. Here is the solution: http://help.openerp.com/question/8975/openerp-server-error/ Only need the openerp user in postgres

Best Answer

there is a problem with the openerp role in your PostgreSQL database. Looks like it does not exist. Try creating the role in the database,

Avatar
Discard
Best Answer

Just you need to create openerp user in postgres just follow these steps:: doc.openerp.com/v6.1/install/linux/postgres/index.html#setup-a-postgresql-user-for-openerp

Avatar
Discard