Zum Inhalt springen
Menü
Sie müssen registriert sein, um mit der Community zu interagieren.
Diese Frage wurde gekennzeichnet
3 Antworten
10396 Ansichten

Hi

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?

Thanks

Avatar
Verwerfen

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;

Beste Antwort

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.

Avatar
Verwerfen

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

Beste Antwort

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

AJ

Avatar
Verwerfen
Autor Beste Antwort

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!

Avatar
Verwerfen
Verknüpfte Beiträge Antworten Ansichten Aktivität
0
Mai 25
885
13
Sept. 24
190657
2
Juli 24
12097
3
März 15
8890
1
März 15
5519