This question has been flagged
1 Reply
10000 Views
Avatar
gpkarthick

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

Avatar
Discard
Avatar
Amit Parik (amp)
Best Answer

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!

Avatar
Discard