Odoo Help


I can't create a database directly from openerp..Help me..??

on 12/11/14, 5:02 AM 1,654 views

Server Traceback (most recent call last): File "/home/azinova/workspace/odoo/server/openerp/addons/web/session.py", line 89, in send return openerp.netsvc.dispatch_rpc(service_name, method, args) File "/home/azinova/workspace/odoo/server/openerp/netsvc.py", line 292, in dispatch_rpc result = ExportService.getService(service_name).dispatch(method, params) File "/home/azinova/workspace/odoo/server/openerp/service/web_services.py", line 122, in dispatch return fn(*params) File "/home/azinova/workspace/odoo/server/openerp/service/web_services.py", line 167, in exp_create_database self._create_empty_database(db_name) File "/home/azinova/workspace/odoo/server/openerp/service/web_services.py", line 136, in _create_empty_database cr.execute("""CREATE DATABASE "%s" ENCODING 'unicode' TEMPLATE "%s" """ % (name, chosen_template)) File "/home/azinova/workspace/odoo/server/openerp/sql_db.py", line 161, in wrapper return f(self, *args, **kwargs) File "/home/azinova/workspace/odoo/server/openerp/sql_db.py", line 226, in execute res = self._obj.execute(query, params) ProgrammingError: permission denied to create database




| 5 3 6
Jakarta, Indonesia
On 12/11/14, 5:57 AM

The database user ID that is used to connect OpenERP database does not have access to create database.  If you can connect to the database using PgAdmin, try to check and change that.  From psql the command is \du.  In the Attributes column next to the database user ID you use to connect to OpenERP, it need to have "Create DB".  To add: ALTER ROLE XXXX CREATEDB; where XXXX is the database user ID.

About This Community

This platform 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.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 12/11/14, 5:02 AM
Seen: 1654 times
Last updated: 3/16/15, 8:10 AM