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

Odoo v8 fails to create new databases [SOLVED]

By
E.M.
on 9/23/15, 5:02 AM 2,172 views

I have two Odoo v8 servers. I have noticed that I can't no longer create new databases.

Everything was working fine and no recent update was performed. When I try to create a new database from database management everything seems to work fine but then after odoo redirects to admin login for that new database there is a version error.

This is the log:

57:44] "POST /web/database/get_list HTTP/1.1" 200 -
2015-09-23 08:58:18,273 25443 ERROR None openerp.http: Exception during JSON req uest handling.
Traceback (most recent call last):
File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 537, in _handle_ exception
return super(JsonRequest, self)._handle_exception(exception)
File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 574, in dispatch
result = self._call_function(**self.params)
File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 311, in _call_fu nction
return self.endpoint(*args, **kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 803, in __call__
return self.method(*args, **kw)
File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 403, in response _wrap
response = f(*args, **kw)
File "/usr/lib/python2.7/dist-packages/openerp/addons/web/controllers/main.py" , line 704, in create
params['create_admin_pwd'])
File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 879, in proxy_me thod
result = dispatch_rpc(self.service_name, method, args)
File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 115, in dispatch _rpc
result = dispatch(method, params)
File "/usr/lib/python2.7/dist-packages/openerp/service/db.py", line 65, in dis patch
security.check_super(passwd)
File "/usr/lib/python2.7/dist-packages/openerp/service/security.py", line 32, in check_super
raise openerp.exceptions.AccessDenied()
AccessDenied: Access denied.
2015-09-23 08:58:18,280 25443 INFO None werkzeug: 127.0.0.1 - - [23/Sep/2015 08: 58:18] "POST /web/database/create HTTP/1.1" 200 -


Does anyone experience the same issue?

0
E.M.
On 9/23/15, 6:25 AM

I have tried:

1.) For admin_passwd I am using the odoo admin password.

2.) I do not know what do you mean with to set the database user's password. Which database? which user? should not admin user for the new generated database be defined by the manage database GUI?

3.) I added the line for odoo (which is the user for odoo without succes). I ensured a fresh start by rebooting the server.


I think it might be relevant to notice this:

2015-09-23 10:22:44,383 829 WARNING newdatabase1 openerp.addons.base.ir.ir_cron: Skipping database newdatabase1 as its base version is not 8.0.1.3.

As I suspect it might be the reason for not being able to further access the database. Any help is really welcomed, it is very frustrating as this is happening in two servers.


Finally I noticed that the issue was in one of my custom module. Despite aparently Odoo was creating the database and it was an access issue, Odoo was not actually creating the database. I noticed that using the Odoo log while creating the new database

Database user which you have specified in "db_user" attribute of your openerp_server.conf file. I am asking to provide it's password.

Emipro Technologies Pvt. Ltd.
on 9/23/15, 6:52 AM

Finally I noticed that the issue was in one of my custom module. Despite aparently Odoo was creating the database and it was an access issue, Odoo was not actually creating the database. I noticed that using the Odoo log while creating the new database. Thanks for your help.

E.M.
on 9/23/15, 7:01 AM

I don't believe "AccessDenied: Access denied." error comes from problem of any custom module. You haven't caught your problem in right way. However afterall your problem is solved that matters !

Emipro Technologies Pvt. Ltd.
on 9/23/15, 8:03 AM
0

Emipro Technologies Pvt. Ltd.

--Emipro Technologies Pvt. Ltd.--
Tiny ERP Pvt Ltd
http://www.odoo.com
5975
| 6 7 8
Rajkot, India
--Emipro Technologies Pvt. Ltd.--

Being an emerging leader in IT market since 2011, Emipro Technologies Pvt. Ltd. has been providing a wide range of business solutions in Odoo & Magento. We are pleased to have a large pool of contented customers with our meticulous work in the domain of ERP & e-Commerce. A ray of relief & satisfaction to  our customers heart by our successful deployment in their organization, purely represents our success in Odoo platform. Hence, we take pride for being an Odoo partner with a vision of expanding our strategic alliances with our customers to offer them high value-added, trustworthy & cost effective solutions.

 

Since establishment, our business has span across 11 countries of the world. Our customers are companies of all sizes ranging from start-ups to large enterprises, who realize that they need a professional business solutions to generate revenue streams, establish proper communication channels or streamline business operations. Standing with strong determination of customer satisfaction, observing each minute detail of their business processes, providing proper guidance and moving forth to develop product accordingly adds our value and reliability among our customers. 

 

We are blessed with efficient, passionate & eclectic young developers who have come across almost all kinds of business profiles, working with full dedication, applying creativity & new features in existing modules and completing customer's projects successfully on predefined target. Our in-depth knowledge while giving business solutions in Odoo allows us to offer following services to our customers :

 

  • Consulting
  • Installation, Configuration & Customization
  • Training & Support
  • Maintenance
  • Upgradation
  • Documentation
  • Crafting community modules
  • Drafting videos on demand
  • Smart Apps development

We will be :) to welcome you @ www.emiprotechnologies.com to solve any kind of your business needs around Odoo. However we are just an inch away from you by email info@emiprotechnologies.com or a tweet to @EmiproTech

Emipro Technologies Pvt. Ltd.
On 9/23/15, 5:39 AM

There should be 2 reasons.

1. Super admin password is not matching with your given password.

Please verify "admin_passwd" value of openerp_server.conf file with the super admin password you given at the time of create database from frontend.

2. Database user's password is not set yet. ( Go to psql command line and from template1 user you can set db user's pwd )

3. Database user with which you have started Odoo has no enough right to create database. To solve that please follow below steps. ( I guess you are using Ubuntu 12.04+ versions )

1. Go to terminal and open pg_hba.conf file by this command sudo vi /etc/postgresql/9.1/main/pg_hba.conf

2. Add one line for your database user, ( Here I guess you are running with database user odoo )

local     all    odoo     trust

3. Restart Postgresql Database.

Now please try to create database.

Hope this helps,

see my edit above.

E.M.
on 9/23/15, 6:25 AM

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)

Stats

Asked: 9/23/15, 5:02 AM
Seen: 2172 times
Last updated: 9/23/15, 7:01 AM