Odoo Help


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.


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

on 12/11/14, 5:02 AM 1,013 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.

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)


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