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 no longer working cannot access admin - Server Error

By
Afzol Ali
on 2/21/15, 9:46 AM 4,800 views

Hi guys, Im new on here, 

My Odoo install has been working fine for over 4 months now. Last night I tried to install the Notes/collabrotive module and did google calander sync. 

When I tried to log back into the Odoo admin the Error message comes up on the browser:

"Internal Server Error

The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application."

I started and stopped and restarted the Odoo server and database, still cannot access the Odoo

Please assist, any help will be useful. Im not great with servers, or databases, so anything related to that would appreciate steps to follow.

Thanks

Below is part of the Error log I got:

2015-02-21 03:30:35,152 6592 INFO odoo_demo openerp.modules.loading: loading 1 modules...
2015-02-21 03:30:35,454 6592 INFO odoo_demo openerp.modules.loading: 1 modules loaded in 0.30s, 0 queries
2015-02-21 03:30:36,116 6592 INFO odoo_demo openerp.modules.loading: loading 108 modules...
2015-02-21 03:30:37,337 6592 INFO odoo_demo openerp.modules.module: module document: creating or updating database tables
2015-02-21 03:30:37,562 6592 INFO odoo_demo openerp.modules.loading: loading document/security/document_security.xml
2015-02-21 03:30:38,075 6592 INFO odoo_demo openerp.modules.loading: loading document/document_view.xml
2015-02-21 03:30:38,514 6592 INFO odoo_demo openerp.modules.loading: loading document/document_data.xml
2015-02-21 03:30:38,548 6592 INFO odoo_demo openerp.modules.loading: loading document/wizard/document_configuration_view.xml
2015-02-21 03:30:38,609 6592 INFO odoo_demo openerp.modules.loading: loading document/security/ir.model.access.csv
2015-02-21 03:30:38,981 6592 INFO odoo_demo openerp.modules.loading: loading document/report/document_report_view.xml
2015-02-21 03:30:39,289 6592 INFO odoo_demo openerp.modules.loading: loading document/views/document.xml
2015-02-21 03:30:39,443 6592 INFO odoo_demo openerp.modules.loading: loading document/document_demo.xml
2015-02-21 03:30:39,459 6592 INFO odoo_demo werkzeug: 151.227.23.228 - - [21/Feb/2015 03:30:39] "POST /longpolling/poll HTTP/1.1" 500 -
2015-02-21 03:30:39,487 6592 ERROR odoo_demo werkzeug: Error on request:
Traceback (most recent call last):
  File "/usr/share/pyshared/werkzeug/serving.py", line 159, in run_wsgi
    execute(app)
  File "/usr/share/pyshared/werkzeug/serving.py", line 146, in execute
    application_iter = app(environ, start_response)
  File "/opt/odoo/odoo/openerp/service/server.py", line 281, in app
    return self.app(e, s)
  File "/opt/odoo/odoo/openerp/service/wsgi_server.py", line 216, in application
    return application_unproxied(environ, start_response)
  File "/opt/odoo/odoo/openerp/service/wsgi_server.py", line 202, in application_unproxied
    result = handler(environ, start_response)
  File "/opt/odoo/odoo/openerp/http.py", line 1236, in __call__
    return self.dispatch(environ, start_response)
  File "/opt/odoo/odoo/openerp/http.py", line 1210, in __call__
    return self.app(environ, start_wrapped)
  File "/usr/share/pyshared/werkzeug/wsgi.py", line 411, in __call__
    return self.app(environ, start_response)
  File "/opt/odoo/odoo/openerp/http.py", line 1210, in __call__
    return self.app(environ, start_wrapped)
  File "/usr/share/pyshared/werkzeug/wsgi.py", line 411, in __call__
    return self.app(environ, start_response)
  File "/opt/odoo/odoo/openerp/http.py", line 1210, in __call__
    return self.app(environ, start_wrapped)
  File "/usr/share/pyshared/werkzeug/wsgi.py", line 411, in __call__
    return self.app(environ, start_response)
  File "/opt/odoo/odoo/openerp/http.py", line 1210, in __call__
    return self.app(environ, start_wrapped)
  File "/usr/share/pyshared/werkzeug/wsgi.py", line 411, in __call__
    return self.app(environ, start_response)
  File "/opt/odoo/odoo/openerp/http.py", line 1210, in __call__
    return self.app(environ, start_wrapped)
  File "/usr/share/pyshared/werkzeug/wsgi.py", line 411, in __call__
    return self.app(environ, start_response)
  File "/opt/odoo/odoo/openerp/http.py", line 1210, in __call__
    return self.app(environ, start_wrapped)
  File "/usr/share/pyshared/werkzeug/wsgi.py", line 411, in __call__
    return self.app(environ, start_response)
  File "/opt/odoo/odoo/openerp/http.py", line 1210, in __call__
    return self.app(environ, start_wrapped)
  File "/usr/share/pyshared/werkzeug/wsgi.py", line 411, in __call__
    return self.app(environ, start_response)
  File "/opt/odoo/odoo/openerp/http.py", line 1210, in __call__
    return self.app(environ, start_wrapped)
  File "/usr/share/pyshared/werkzeug/wsgi.py", line 411, in __call__
    return self.app(environ, start_response)
  File "/opt/odoo/odoo/openerp/http.py", line 1210, in __call__
    return self.app(environ, start_wrapped)
  File "/usr/share/pyshared/werkzeug/wsgi.py", line 411, in __call__
    return self.app(environ, start_response)
  File "/opt/odoo/odoo/openerp/http.py", line 1210, in __call__
    return self.app(environ, start_wrapped)
  File "/usr/share/pyshared/werkzeug/wsgi.py", line 411, in __call__
    return self.app(environ, start_response)
  File "/opt/odoo/odoo/openerp/http.py", line 1368, in dispatch
    ir_http = request.registry['ir.http']
  File "/opt/odoo/odoo/openerp/http.py", line 330, in registry
    return openerp.modules.registry.RegistryManager.get(self.db) if self.db else None
  File "/opt/odoo/odoo/openerp/modules/registry.py", line 310, in get
    update_module)
  File "/opt/odoo/odoo/openerp/modules/registry.py", line 341, in new
    openerp.modules.load_modules(registry._db, force_demo, status, update_module)
  File "/opt/odoo/odoo/openerp/modules/loading.py", line 354, in load_modules
    force, status, report, loaded_modules, update_module)
  File "/opt/odoo/odoo/openerp/modules/loading.py", line 263, in load_marked_modules
    loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks)
  File "/opt/odoo/odoo/openerp/modules/loading.py", line 185, in load_module_graph
    _load_data(cr, module_name, idref, mode, kind='demo')
  File "/opt/odoo/odoo/openerp/modules/loading.py", line 118, in _load_data
    tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report)
  File "/opt/odoo/odoo/openerp/tools/convert.py", line 901, in convert_file
    convert_xml_import(cr, module, fp, idref, mode, noupdate, report)
  File "/opt/odoo/odoo/openerp/tools/convert.py", line 987, in convert_xml_import
    obj.parse(doc.getroot(), mode=mode)
  File "/opt/odoo/odoo/openerp/tools/convert.py", line 853, in parse
    self._tags[rec.tag](self.cr, rec, n, mode=mode)
  File "/opt/odoo/odoo/openerp/tools/convert.py", line 763, in _tag_record
    id = self.pool['ir.model.data']._update(cr, self.uid, rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode, context=rec_context )
  File "/opt/odoo/odoo/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "/opt/odoo/odoo/openerp/addons/base/ir/ir_model.py", line 1066, in _update
    res_id = model_obj.create(cr, uid, values, context=context)
  File "/opt/odoo/odoo/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "/opt/odoo/odoo/openerp/addons/mail/res_users.py", line 75, in create
    raise openerp.exceptions.RedirectWarning(msg, action_id, _('Go to the configuration panel'))
ParseError: "You cannot create a new user from here.
 To create new user please go to configuration panel.
76
Go to the configuration panel" while parsing /opt/odoo/odoo/openerp/addons/document/document_demo.xml:4, near
<record id="base.user_demo" model="res.users">
        <field eval="[(4, ref('base.group_document_user'))]" name="groups_id"/>
    </record>

Hi Afzol! I was wondering if you could give me some more insight in this since we had this problem on an Odoo a while ago too. I see this is referring to demo files (document_demo.xml:4).. Did you know how this happend and how/when this showed up? I fixes this by commenting out the demo files that caused the errors but I would like to know why and how this has happend. I hope you can provide me with some more details/insight :)

Yenthe
on 2/24/15, 9:32 AM
1
Afzol Ali
On 2/24/15, 9:18 AM

Hi

Thanks guys,

I actually figured out that the main problem was within the documents module, and another module. It was trying to create an incorrect database user !!

To diagnose the problem I got extra help from a developer who fixed the problem. And found not only was it trying to create a new user, but also the Notes Module was clashing and was in pending install mode with another install.

Exactly what the solution to this problem was I will update here again with instructions as I am sure there are other Odoo users who will come across this similar bug. Martin instructions are easy to follow and will be trying it thanks, and Y3 That talent is beyond me at present as I am not great with databases, can perform terminal comands but need step by step guide, sorry on that a bit new to postgres.

Great help guys really appreciate it.

Hi Afzol! I was wondering if you could give me some more insight in this since we had this problem on an Odoo a while ago too. I see this is referring to demo files (document_demo.xml:4).. Did you know how this happend and how/when this showed up? I fixes this by commenting out the demo files that caused the errors but I would like to know why and how this has happend. I hope you can provide me with some more details/insight :)

Yenthe
on 2/24/15, 9:32 AM
1
Martin Temmink
On 2/22/15, 7:38 AM

you can do severall things.

1. stop odoo server
2. login with ssh on your system as odoo user
3. issue the database update command on de commandline. for instructions follow this link: Database run full update command.

then logout as odoo user, and restart your server

if the above doesn't work you have to mannually move the contents in the addons directory. And restart your server.
this will restart odoo without any modules. You should be able to login.
Then stop the server and move one module at the time back to the addons directory. start the server and if succesfully. repeat the procedure for the rest of the modules.

if you find this information has helped you, please give me a thumb up vote!

1

I can't comment on the specifics of the error that you have encountered.  However, I had a similar experience where my Odoo server failed after I made some mistakes during the installation of a customised module.  After the failed installation and further wrong moves on the Odoo server, I decided to cut loss and recovered the database instances using postgres directly.

I install pgadmin III to attempt to connect to the postgres server.  You will need to enable access to pgadmin by editing the pg_hba.conf file found in /etc/postgresl/9.3/main directory with an entry like

host     all    all    0.0.0.0/0      md5

Please note that the above allows access from anywhere in the internet.  

You will need to use a command like:

sudo kill -HUP main_postgres_pid_number (for the postgres server to re-read the revised setting)

You can connect to the postgres server with a postgres user id like odoo (assuming that the odoo user is the one that was used to create the postgres database instance).

You may have to alter the odoo user password in order to use pgadmin using a statement like this:

# login to postgres user in ssh

sudo su postgres

# go into psql

psql

$ALTER ROLE odoo with PASSWORD 'Newpassword';

Once your odoo ID has a password, you will be able to connect to the postgres server using pgadmin.

You can use the pgadmin program to do a database backup of the database instances that you need.

After the backup is done, you can go to a fresh installation of odoo-server to restore the database instance.  Restoration consists of creating a database instance with the same name as that of the backup database using postgres odoo ID:

$CREATE DATABASE databasename;

Restore the backup file using pg_dump

#pg_dump -d databasename < backupdatabase.sql

If there are no errors, you should be able to see the restored database in your odoo-server.

I may have missed out some steps along the way.  But that generally is how I managed to restore a database instance from a corrupted odoo-server to a working odoo-server.

 

 

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

2 follower(s)

Stats

Asked: 2/21/15, 9:46 AM
Seen: 4800 times
Last updated: 3/16/15, 8:10 AM