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

i cannot connect openerp fatal error

By
gpkarthick
on 8/2/13, 4:06 AM 5,358 views

asimo@asimo-desktop:/opt/openerp/server$ ./openerp-server 2013-08-02 06:04:22,282 4849 INFO ? openerp: OpenERP version 7.0-20130731-231106 2013-08-02 06:04:22,282 4849 INFO ? openerp: addons paths: /opt/openerp/server/openerp/addons 2013-08-02 06:04:22,282 4849 INFO ? openerp: database hostname: localhost 2013-08-02 06:04:22,282 4849 INFO ? openerp: database port: 5432 2013-08-02 06:04:22,282 4849 INFO ? openerp: database user: asimo 2013-08-02 06:04:22,584 4849 INFO ? openerp.addons.google_docs.google_docs: GData lib version %s GData-Python/2.0.17 detected 2013-08-02 06:04:22,824 4849 INFO ? openerp.service.wsgi_server: HTTP service (werkzeug) running on 0.0.0.0:8069 2013-08-02 06:04:22,824 4849 INFO ? openerp: OpenERP server is running, waiting for connections... 2013-08-02 06:04:26,785 4849 ERROR ? openerp.sql_db: Connection to the database failed Traceback (most recent call last): File "/opt/openerp/server/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 "asimo" does not exist

2013-08-02 06:04:26,786 4849 ERROR ? openerp.netsvc: FATAL: role "asimo" does not exist Traceback (most recent call last): File "/opt/openerp/server/openerp/netsvc.py", line 292, in dispatch_rpc result = ExportService.getService(service_name).dispatch(method, params) File "/opt/openerp/server/openerp/service/web_services.py", line 122, in dispatch return fn(params) File "/opt/openerp/server/openerp/service/web_services.py", line 359, in exp_list cr = db.cursor() File "/opt/openerp/server/openerp/sql_db.py", line 484, in cursor return Cursor(self._pool, self.dbname, serialized=serialized) File "/opt/openerp/server/openerp/sql_db.py", line 182, in __init__ self._cnx = pool.borrow(dsn(dbname)) File "/opt/openerp/server/openerp/sql_db.py", line 377, in _locked return fun(self, *args, *kwargs) File "/opt/openerp/server/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 "asimo" does not exist

1
Amit Parik (amp)
On 8/2/13, 4:13 AM

Hello,

You have to create same user(same name as system user where openerp is running) on postgres and assign the super user role to that user. Would you please try following command.

sudo su postgres

createuser asimo. Create as a superuser : yes.

then connect with template1 db. psql template1

alteruser asimo with password 'postgres';

Thank you!

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

0 follower(s)

Stats

Asked: 8/2/13, 4:06 AM
Seen: 5358 times
Last updated: 3/16/15, 8:10 AM