Odoo Server (MOVED TO GITHUB)

Backup produce empty file and wierd behavior

Asked by Nicola Riolini - Micronaet

Hi all,
I try to do my DB backup, I both use GTK client: from menù File/Database/Save Database, and web client: press button DATABASE in log in form and BACK UP botton; the password and Database that I chose is correct. When I press OK to do the operation I see the client seems freezing. I leave it for 1 hour without changing.
I decide to look at the server (I launch server and web client as an administrator user from command line, not as a service or with root privileges, normally client activity work fine with this installation), specifically on the bash, where I see on line log (the terminal window is where I launch: openerp-server.py script)
there I have this request:

[2010-08-17 14:49:57,108] INFO:web-services:DUMP DB: databasename
Password:

I write the "admin" password (that is default admin not yet changed) when I do this I get OK message on client (both web and GTK have this behavior). I locate Backup file and I see that is a 0 kbyte file...

Is this a bug or my bad backup procedure?
Thanks

Question information

Language:
English Edit question
Status:
Answered
For:
Odoo Server (MOVED TO GITHUB) Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:

This question was originally filed as bug #619216.

Revision history for this message
Christophe CHAUVET (christophe-chauvet) said : 		#1

Hi

You must create a .pgpass file in your home, see http://www.postgresql.org/docs/8.3/static/libpq-pgpass.html

Regards,

Revision history for this message
xrg (xrg) said : 		#2

On Tuesday 17 August 2010, you wrote:
> New question #121524 on OpenObject Server:
> https://answers.launchpad.net/openobject-server/+question/121524
>
> Hi all,

> I try to do my DB backup, ...
> I decide to look at the
> server ... there I have this request:
> [2010-08-17 14:49:57,108] INFO:web-services:DUMP DB: databasename
> Password:

That has been wrong at the server side.

Please apply this patch, it will prevent the password prompt (but will cause
the scripts to fail if your Postgres configuration doesn't permit the openerp
server to do such actions).

Revision history for this message
Nicola Riolini - Micronaet (nicolariolini) said : 		#3

@xrg
Hi,
sorry, the patch that you are referring for is the Christophe Chauvet posts?
I try to create a file in home/administrator/.pgpass.conf set chmod to 0600
I write in it:
192.168.100.165:5432:openerp:pwd_opener_user

restart PG, server, web client but I have the same error, well not the same, I see that if, in the terminal window of the server log, write the password for openerp postgres user (before I write admin password instead of openerp user) Backup now works fine and the file is a 1.6 Mbyte file... obviously non an automatic procedure :)

Is there something wrong in my file? I try even localhost (IP and port is however visible in the net...)
Thanks

Revision history for this message
mrmango (register-coloniesonline) said : 		#4

I noticed that the pgdump command is not where OpenERP was expecting.

Shows as pgdump not found, guess making a ln link to where it expects may help.

Can you help with this problem?

Provide an answer of your own, or ask Nicola Riolini - Micronaet for more information if necessary.

To post a message you must log in.