Odoo Help


Login not working after restore of database

on 10/31/13, 6:09 PM 3,823 views


I recently backed up my database from an old server and restored it to an OpenERP installation on a new server. Problem is that it is not accepting any of my user logins or the admin login. When I go back to the old server I can still login so something must have happened when restoring the database on the new server. What can I do?


What do you mean by 'not working' and 'not accepting'. What error message do you get? If you don't have base_crypt installed, check in PostgreSQL: SELECT login, password FROM res_users;

Ray Carnes
on 10/31/13, 10:25 PM
Abhishek H Menon
On 11/1/13, 1:57 AM

Please do one thing go to your pgadmin inorder to get your database. Select the restored database. Then check the table res_users. check the password field for the login field admin. And take that and login as administrator.

Ok, and what do I do if the table looks like this: login | password -------+---------- admin | (1 row) ?

on 9/19/14, 10:46 AM
On 11/4/13, 5:53 AM

Thanks for you answers. Seems the database versions were different and I could see that it was not fully restored. I then updated the version and migrated to the new server again and now am getting this error:

OpenERP Server Error

Client Traceback (most recent call last): File "/opt/openerp/openerp7/openerp/addons/web/http.py", line 204, in dispatch response["result"] = method(self, **self.params) File "/opt/openerp/openerp7/openerp/addons/web/controllers/main.py", line 867, in authenticate req.session.authenticate(db, login, password, env) File "/opt/openerp/openerp7/openerp/addons/web/session.py", line 115, in authenticate uid = self.proxy('common').authenticate(db, login, password, env) File "/opt/openerp/openerp7/openerp/addons/web/session.py", line 30, in proxy_method result = self.session.send(self.service_name, method, *args) File "/opt/openerp/openerp7/openerp/addons/web/session.py", line 103, in send raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)

Server Traceback (most recent call last): File "/opt/openerp/openerp7/openerp/addons/web/session.py", line 89, in send return openerp.netsvc.dispatch_rpc(service_name, method, args) File "/opt/openerp/openerp7/openerp/netsvc.py", line 292, in dispatch_rpc result = ExportService.getService(service_name).dispatch(method, params) File "/opt/openerp/openerp7/openerp/service/web_services.py", line 433, in dispatch return fn(*params) File "/opt/openerp/openerp7/openerp/service/web_services.py", line 444, in exp_authenticate res_users = pooler.get_pool(db).get('res.users') File "/opt/openerp/openerp7/openerp/pooler.py", line 49, in get_pool return get_db_and_pool(db_name, force_demo, status, update_module)[1] File "/opt/openerp/openerp7/openerp/pooler.py", line 33, in get_db_and_pool registry = RegistryManager.get(db_name, force_demo, status, update_module) File "/opt/openerp/openerp7/openerp/modules/registry.py", line 192, in get update_module) File "/opt/openerp/openerp7/openerp/modules/registry.py", line 218, in new openerp.modules.load_modules(registry.db, force_demo, status, update_module) File "/opt/openerp/openerp7/openerp/modules/loading.py", line 350, in load_modules force, status, report, loaded_modules, update_module) File "/opt/openerp/openerp7/openerp/modules/loading.py", line 256, in load_marked_modules loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks) File "/opt/openerp/openerp7/openerp/modules/loading.py", line 159, in load_module_graph load_openerp_module(package.name) File "/opt/openerp/openerp7/openerp/modules/module.py", line 405, in load_openerp_module __import__('openerp.addons.' + module_name) File "/opt/openerp/openerp7/openerp/modules/module.py", line 133, in load_module mod = imp.load_module('openerp.addons.' + module_part, f, path, descr) File "/opt/openerp/openerp7/openerp/addons/mrp_operations/__init__.py", line 23, in <module> import report File "/opt/openerp/openerp7/openerp/addons/mrp_operations/report/__init__.py", line 22, in <module> import mrp_wc_barcode File "/opt/openerp/openerp7/openerp/addons/mrp_operations/report/mrp_wc_barcode.py", line 32, in <module> report_sxw.report_sxw('report.mrp.wc.barcode', 'mrp.workcenter', 'addons/mrp_operations/report/mrp_wc_barcode.rml',parser=workcenter_code,header=False) File "/opt/openerp/openerp7/openerp/report/report_sxw.py", line 392, in __init__ report_rml.__init__(self, name, table, rml, '') File "/opt/openerp/openerp7/openerp/report/interface.py", line 65, in __init__ super(report_rml, self).__init__(name) File "/opt/openerp/openerp7/openerp/report/interface.py", line 45, in __init__ assert not self.exists(name), 'The report "%s" already exists!' % name AssertionError: The report "report.mrp.wc.barcode" already exists!

Gregoire Huet
On 11/1/13, 6:20 AM

I've experienced that previously, and solved it by restarting the SQL server.


About This Community

This platform 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.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 10/31/13, 6:09 PM
Seen: 3823 times
Last updated: 3/16/15, 8:10 AM