Backup fails

Bug #319190 reported by Joosep-Georg
20
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Odoo GTK Client (MOVED TO GITHUB)
Fix Released
Undecided
Unassigned

Bug Description

Trying to backup a database 5.0.0 rc3 freezes for two minutes and then messages "Could not contact server!" and "Couldn't backup database." pop up.

Client log contains:

WARNING:translate:Unable to set locale English_United States.cp1257

Server log doesn't contain nothing.

Are there any other ways to backup a database in order to import it again into OpenERP?

Revision history for this message
Stephane Wirtel (OpenERP) (stephane-openerp) wrote :

Can you run the server with the command line and add the option --debug to the server please ?

Thank you

Changed in openobject-client:
status: New → Incomplete
Revision history for this message
Stephane Wirtel (OpenERP) (stephane-openerp) wrote :

on Linux, works fine.

I will check on Windows.

Thank you

Revision history for this message
Joosep-Georg (joosep-georg-jarvemaa) wrote :

Tried with --debug:

After initiating backup process in the command window where server is started appears prompt "Password:"

When I enter there default password "admin" the following line appears:

> c:\documents and settings\administrator\service\web_services.pyo(185)dump()
(Pdb)

Revision history for this message
Elias (rtxehi) wrote :

I also had this problem and here are my findings.

I only have this problem when I start the server with a --db_host parameter (e.g. ./bin/openerp-server.py --db_host 127.0.0.1), then pg_dump asks for a password.
When I leave the db_host parameter out, it doesn't ask for the password and it just works.

Guess it has to do with postgresql authentication, probably without the db_host parameter ident authentication is chosen and works, but when you specify a db_host it uses another authentication method that requires a password.

So maybe the issue is that openerp doesn't detect/knows this and doesn't act appropriately.

Hope this helps and someone can reproduce this.

Revision history for this message
Elias (rtxehi) wrote :
Revision history for this message
Stephane Wirtel (OpenERP) (stephane-openerp) wrote :

fixed in trunk

Changed in openobject-client:
status: Incomplete → Fix Released
Revision history for this message
Stephane Wirtel (OpenERP) (stephane-openerp) wrote :

Not fixed correctly, I will provide a new patch

Changed in openobject-client:
status: Fix Released → New
Changed in openobject-client:
status: New → Fix Released
Revision history for this message
mitulv4u (mitulv4u) wrote :

hey guys,

can anyone help me in layman's language. I am not getting anything, on how to go about it. I have installed open ERP on a windows 7 machine and face the same problem while trying to take the backup.

would appreciate any help regarding it.

Regards,
Mitul

Revision history for this message
Christophe Hanon (www.adins.be) (chanon) wrote :

@mitlulv4u
from my experience, start the server from the command prompt. If prompted for password this is the password used by the server to contact the db. Look at your config file.

Alternative way of backup, check postgress. There are two easy menu entry in pgadmin (select a db, right click: backup, restore).

Good luck!

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.