OperationalError: Unable to use a closed cursor -- Unable to create new database via interface v7 -- Potential solutions given
When trying to create a database from user interface it shows :
Server Traceback (most recent call last): File "/opt/openerp/server/openerp/addons/web/session.py", line 89, in send return openerp.netsvc.dispatch_rpc(service_name, method, args) File "/opt/openerp/server/openerp/netsvc.py", line 296, 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 168, in exp_create_database _initialize_db(self, id, db_name, demo, lang, user_password) File "/opt/openerp/server/openerp/service/web_services.py", line 98, in _initialize_db cr.close() File "/opt/openerp/server/openerp/sql_db.py", line 160, in wrapper raise psycopg2.OperationalError(msg) OperationalError: Unable to use a closed cursor.
The sql connection is closed, but I don't know why.
Potential solution 1 :
After further researches, I found that to be able to create database from user interface, you should do the following configuration :
On openerp-server.conf, you should put on db_password : the password for the role attributed to the "openerp" user, it's that role that gives the openerp user the ability to create databases from user interface. if the two passwords does not match you won't be able to create databases from user interface.
In my case, I found that my openerp-server.conf contained : db_password : False, I changed it into the password of the role gived to openerp user ( createdb), I restarted the server but nothing changes, When trying to create database from user interface, same error occurs.
Potential Solution 2 :
I tried to create database from psql, by accessing postgres from shell, with openerp user, I tried : createdb db_name, the database is created, but I can't log in, I don't know how to attribute my database creation a administrator account, while performing createdb. the functionnal side of this potential solution2, is to be able to perform the same database creation process from user interface, on postgres.
Can anyone please, give me a hand on this 2 potential solutions ? I'm really struggling with this. Thanks.
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
|Asked: 12/31/14, 10:04 AM|
|Seen: 1114 times|
|Last updated: 3/12/16, 2:45 PM|