Skip to Content
This question has been flagged
12 Replies
33423 Views
Avatar
mrashad

When I try to Backup database or Drop or change password, it is access denied?

Avatar
Discard
Anas Taji

You need to provide more details, your OS [Windows, Linux, Mac] & what is the installed version [exe, deb, source]..%

Avatar
MaxV
Best Answer

Here the solution for me on Linux: the master password is uncorrectly checked.

You master password is stored in /etc/odoo/odoo.conf  and only root can see or edit it.

In odoo.conf file you'll find a line like:   admin_passwd = $pbkdf2-sha512$25000$uncuJQSgVCoFQ...

On Linux comment the line with a semicolon (;) like this:  ;admin_passwd = $pbkdf2-sha512$25000$unc...

Now restart odoo and all will work fine (sudo service odoo restart)

Avatar
Discard
Avatar
Sasha
Best Answer

Well,

OpenERP is a brilliant application, it really is, but, windows version is not ready for production. this is my 3rd attempt to evaluation for live implementation. The weakest pint in OpenERP but, the most importation for production is solid bullet proved backup/restore functionality.

  1. Installation CRM and a few modules, import/export data is going well
  2. For a some time testing/evaluation including backup/restore is going well
  3. Restoring on other computers has number of problem module update doesn't help ...
  4. SUDDENLY on original instillation backup function return "database Backup Access Denied"

Looks like problem with master password in section of managing databases BUT PASSWORD IS RIGHT.

Other function such as 'create', 'drop' and so on are just fine with provided "admin" password even 'backup' function was working fine too until some unexpected moment where nothing special has been done to o applications but, 'backup' function start SUDDENLY responding with "Access Denied" Other functions drop, create, ... work OK but 'backup' NOT.

Conclusion: The most important function from production point of view should be deeply reviewed and make a bullet proved in any configuration and cross platform environment to have openERP ready for production environment.

Well, YES we can hack and play with cases like this but only in testing and private environment for live environment it is work which has to be done.

Sasha

Avatar
Discard
kaynis

encountered a similar problem with backup when I tried to do it from the webclient. But I realized this was because the database had become really big. I now do my backup from the database directly, i mean postgreAdminIII and I backupi fine from there.

Chandni Gandhi

Hello, I am also facing the same problem with master password 'admin', but I think that that db_user is not having rights to take backup of database. So if you know, will you please tell me how to change permission for db_user? Thanks in advance, Chandni.

Chandni Gandhi

Hello, I am also facing the same problem with master password 'admin', but I think that that db_user is not having rights to take backup of database. So if you know, will you please tell me how to change permission for db_user? Thanks in advance, Chandni.

Avatar
Pouya Malekinejad
Best Answer

Check pg_path in your openerp-server.conf, it solved my problem

Avatar
Discard
Don Hoeschen

How did 'pg_path' fix your problem?

Zahin

what should be set here in pg_path

Avatar
Archie Carlos Sy
Best Answer

make sure all your tables in the database you're trying to backup are owned by the user odoo erp uses, i.e. openpg, odoo, or whatever was set during installation of the erp system

Avatar
Discard
Avatar
Gustavo
Best Answer

You have problem accessing your database server. Looks like your credentials are not authorized. Try running psql or createdb from the command line to confirm your authorization problem

Avatar
Discard
Avatar
patrick
Best Answer

There are different use/password combinations related to openERP.

You have password admin, which is the default password for managing the openERP databases, like drop and restore.

When you create a new database, the username is admin, and the password is what you have to type twice before the process continues.

And you have the openERP user / password, which is needed to connect openERP to the database. This password might have been made during the installation of openERP (value depends on which OS used and the steps you have taken).

If you do not know the password for creating/dropping/backing up the database, you can find it at: <have to="" get="" my="" papers......&gt;="" <="" p="">

Avatar
Discard