Odoo Help

Welcome!

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

0

database Backup Access denied

By
mrashad
on 5/11/13, 5:49 PM 6,741 views

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

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

Smart Way LLC, Anas Taji
on 5/11/13, 7:33 PM
0
Sasha
On 9/7/13, 12:35 PM

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

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.

kaynis
on 9/7/13, 7:32 PM

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
on 12/4/15, 1:17 AM

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
on 12/4/15, 1:17 AM
0

patrick

--patrick--
1958
| 5 4 7
Baarn, Netherlands
--patrick--
patrick
On 5/12/13, 12:33 PM

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="">

0
Archie Carlos Sy
On 1/22/15, 12:03 AM

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

0
Pouya Maleki
On 7/1/13, 11:36 AM

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

How did 'pg_path' fix your problem?

Granite City Performance, Don Hoeschen
on 7/20/13, 10:42 PM

what should be set here in pg_path

Zahin
on 8/9/13, 6:52 AM
0

Gustavo

--Gustavo--
950
| 2 1 4
Buenos Aires, Argentina
--Gustavo--

Python developer, big fan of sailing

Gustavo
On 5/11/13, 6:07 PM

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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 5/11/13, 5:49 PM
Seen: 6741 times
Last updated: 3/16/15, 8:10 AM