Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

إدارة علاقات العملاء
e-Commerce
المحاسبة
المخزون
PoS
المشروع
MRP

All apps

كافة المنشورات الأفراد الشارات

علامات التصنيف (عرض الكل)

odoo accounting v14 pos v15

حول هذا المنتدى

المساعدة

Odoo v8 fails to create new databases [SOLVED]

server database create base odooV8

2 الردود

9785 أدوات العرض

E.M.

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?

E.M.

الكاتب أفضل إجابة

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

Emipro Technologies Pvt. Ltd.

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

E.M.

الكاتب

Emipro Technologies Pvt. Ltd.

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.

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,

E.M.

الكاتب

see my edit above.

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!

أنشئ حساباً اليوم لتستمتع بالخصائص الحصرية، وتفاعل مع مجتمعنا الرائع!

تسجيل

المنشورات ذات الصلة	الردود	أدوات العرض
Creating database in new installation results in "server error" server error database create v7	1 مارس 15	7249
Is there a way to clear a database of all posted transactions, stock movement and activity without changing configurations and settings in the modules? (Odoo V8) تم الحل database odooV8	3 يناير 24	8219
Why does the server need to restart after creation of new DB? server database	0 مارس 15	4577
When should Database be separated on Separate Server. تم الحل server database postgresql	1 يوليو 25	4581
Database does not connect to server server database Odoo14	1 أغسطس 24	3058

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!