When I try to Backup database or Drop or change password, it is access denied?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- 客户关系管理
- e-Commerce
- 会计
- 库存
- PoS
- 项目
- MRP
此问题已终结
12
回复
35308
查看
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)
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.
- Installation CRM and a few modules, import/export data is going well
- For a some time testing/evaluation including backup/restore is going well
- Restoring on other computers has number of problem module update doesn't help ...
- 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.
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.
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.
Check pg_path in your openerp-server.conf, it solved my problem
How did 'pg_path' fix your problem?
what should be set here in pg_path
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
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
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......>="" <="" p="">
You need to provide more details, your OS [Windows, Linux, Mac] & what is the installed version [exe, deb, source]..%