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

Internal server error - cannot login to database

By
Kurt Schoenhoff
on 2/20/16, 3:20 AM 531 views

Hello I have recently developed an "internal server error" that does not allow me to even enter my login details when selecting a database.



-----------------------------------------------------------------

2016-02-20 07:55:35,306 1102 INFO KurtSch openerp.addons.base.ir.ir_model: Access Denied by ACLs for operation: read, uid: 3, model: ir.ui.view

2016-02-20 07:55:35,309 1102 INFO KurtSch openerp.addons.base.ir.ir_model: Access Denied by ACLs for operation: read, uid: 3, model: ir.ui.view

2016-02-20 07:55:35,326 1102 INFO KurtSch werkzeug: 124.148.51.177 - - [20/Feb/2016 07:55:35] "GET /web/login HTTP/1.1" 500 -

2016-02-20 07:55:35,353 1102 ERROR KurtSch werkzeug: Error on request:

Traceback (most recent call last):

File "/usr/local/lib/python2.7/dist-packages/werkzeug/serving.py", line 177, in run_wsgi

execute(self.server.app)

File "/usr/local/lib/python2.7/dist-packages/werkzeug/serving.py", line 165, in execute

application_iter = app(environ, start_response)

File "/opt/odoo/odoo-server/openerp/service/server.py", line 245, in app

return self.app(e, s)

File "/opt/odoo/odoo-server/openerp/service/wsgi_server.py", line 184, in application

return application_unproxied(environ, start_response)

File "/opt/odoo/odoo-server/openerp/service/wsgi_server.py", line 170, in application_unproxied

result = handler(environ, start_response)

File "/opt/odoo/odoo-server/openerp/http.py", line 1488, in __call__

return self.dispatch(environ, start_response)

File "/opt/odoo/odoo-server/openerp/http.py", line 1462, in __call__

return self.app(environ, start_wrapped)

File "/usr/local/lib/python2.7/dist-packages/werkzeug/wsgi.py", line 588, in __call__

return self.app(environ, start_response)

File "/opt/odoo/odoo-server/openerp/http.py", line 1652, in dispatch

result = ir_http._dispatch()

File "/opt/odoo/odoo-server/addons/website/models/ir_http.py", line 190, in _dispatch

resp = super(ir_http, self)._dispatch()

File "/opt/odoo/odoo-server/addons/web_editor/models/ir_http.py", line 16, in _dispatch

return super(ir_http, self)._dispatch()

File "/opt/odoo/odoo-server/openerp/addons/base/ir/ir_http.py", line 186, in _dispatch

return self._handle_exception(e)

File "/opt/odoo/odoo-server/addons/website/models/ir_http.py", line 296, in _handle_exception

html = request.website._render('website.http_error', values)

File "/opt/odoo/odoo-server/openerp/api.py", line 248, in wrapper

return new_api(self, *args, **kwargs)

File "/opt/odoo/odoo-server/openerp/api.py", line 574, in new_api

result = method(self._model, cr, uid, self.ids, *args, **old_kwargs)

File "/opt/odoo/odoo-server/addons/website/models/website.py", line 409, in _render

return self.pool['ir.ui.view'].render(cr, uid, template, values=values, context=context)

File "/opt/odoo/odoo-server/openerp/api.py", line 250, in wrapper

return old_api(self, *args, **kwargs)

File "/opt/odoo/odoo-server/addons/website/models/ir_ui_view.py", line 136, in render

view_obj = request.website.get_template(id_or_xml_id)

File "/opt/odoo/odoo-server/openerp/api.py", line 248, in wrapper

return new_api(self, *args, **kwargs)

File "/opt/odoo/odoo-server/openerp/api.py", line 574, in new_api

result = method(self._model, cr, uid, self.ids, *args, **old_kwargs)

File "/opt/odoo/odoo-server/addons/website/models/website.py", line 402, in get_template

view_id = View.get_view_id(cr, uid, template, context=context)

File "/opt/odoo/odoo-server/openerp/api.py", line 250, in wrapper

return old_api(self, *args, **kwargs)

File "<string>", line 2, in get_view_id

File "/opt/odoo/odoo-server/openerp/tools/cache.py", line 85, in lookup

value = d[key] = self.method(*args, **kwargs)

File "/opt/odoo/odoo-server/addons/website/models/ir_ui_view.py", line 107, in get_view_id

[view_id] = self.search(cr, uid, domain, order='website_id', limit=1, context=context) or [None]

File "/opt/odoo/odoo-server/openerp/api.py", line 250, in wrapper

return old_api(self, *args, **kwargs)

File "/opt/odoo/odoo-server/openerp/models.py", line 1657, in search

return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)

File "/opt/odoo/odoo-server/openerp/api.py", line 250, in wrapper

return old_api(self, *args, **kwargs)

File "/opt/odoo/odoo-server/openerp/models.py", line 4738, in _search

self.check_access_rights(cr, access_rights_uid or user, 'read')

File "/opt/odoo/odoo-server/openerp/api.py", line 250, in wrapper

return old_api(self, *args, **kwargs)

File "/opt/odoo/odoo-server/openerp/models.py", line 3533, in check_access_rights

return self.pool.get('ir.model.access').check(cr, uid, self._name, operation, raise_exception)

File "/opt/odoo/odoo-server/openerp/api.py", line 250, in wrapper

return old_api(self, *args, **kwargs)

File "<string>", line 2, in check

File "/opt/odoo/odoo-server/openerp/tools/cache.py", line 85, in lookup

value = d[key] = self.method(*args, **kwargs)

File "/opt/odoo/odoo-server/openerp/addons/base/ir/ir_model.py", line 825, in check

raise openerp.exceptions.AccessError(msg % msg_params)

AccessError: (u'Sorry, you are not allowed to access this document. Only users with the following access level are currently allowed to do that:\n- Administration/Settings\n\t- Administration/Access Rights\n\t- Website/Editor and Design$

2016-02-20 07:58:43,601 1102 INFO KurtSch openerp.addons.fetchmail.fetchmail: start checking for new emails on imap server XXXX@XXXX.com

2016-02-20 07:58:45,059 1102 INFO KurtSch openerp.addons.fetchmail.fetchmail: Fetched 0 email(s) on imap server

XXXX@XXXX.com

; 0 succeeded, 0 failed.

-----------------------------------------------------------------------------------------------------------------------------------


I have not changed any access privileges on this database :(

Last thing I was doing was exporting some data (as "admin"), then next time I tried to login it shows the "internal server error" before getting to the login page(just after you click on the database).

Ermin what user are you talking about my ubuntu odoo user or my admin user inside odoo?

Thanks for the response

Kurt Schoenhoff
on 2/21/16, 8:52 PM

I'm talking about the admin user inside odoo.

Ermin Trevisan
on 2/22/16, 1:25 AM

do you have any hints on how to do this? i.e. what table(s) should i be looking at? and what values should there be? Thankyou. :)

Kurt Schoenhoff
on 2/22/16, 2:21 PM
0

Ermin Trevisan

--Ermin Trevisan--
3548
| 6 3 7
Walchwil, Switzerland
--Ermin Trevisan--


Ermin Trevisan
On 2/21/16, 2:50 AM

Looks like you locked yourself out of accessing the web frontend by taking away your access to the website. If you did that as admin, you can say "Houston, we have a problem". Using pgadmin you can try to give you access rights again directly in the database.

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: 2/20/16, 3:20 AM
Seen: 531 times
Last updated: 2/22/16, 1:24 AM