Skip to Content
This question has been flagged
securitypassworddatabase
2 Replies
32097 Views
Avatar
Anas Taji

I can read the Postgres server username and password inside the openerp-server.conf file, how to hide/encrypt the Postgres password?

Removing/changing the values will prevent openerp server from connecting to postgresql database server.

Avatar
Discard
Avatar
Manuel Villar Guijarro
Best Answer

You can't BUT you can make it secure.

  1. Use an user just for openerp not a general admin of postgresql

  2. Adjust the permisions of the file:

    chmod 600 openerp-server.conf

Avatar
Discard
Avatar
André Schenkels
Best Answer

You should change your PostgreSQL Server configuration.

If you run the OpenERP server with a openerp user make sure the pg_hba.conf file has a setting telling the postgresql server to use peer or ident authentication and not MD5.

If this is the case you are able to just put the db_user=openerp in your OpenERP server config file and it will no longer be needed to put the password in the config file.

André Schenkels

Avatar
Discard
NSC

In my openerp-server.conf, there is only written admin_passwd in plain text, but not the password for postgres database user, although my psql authentication mode in pg_hba.conf file is set to MD5...

Related Posts Replies Views Activity
Admin password reset not working, tried database, odoo.conf
password database admin
Avatar
Avatar
2
May 25
125
Enable password recovery from database
password database recovery
Avatar
Avatar
Avatar
6
Jul 17
10804
Retrieving Master Database Password
password database master
Avatar
Avatar
Avatar
2
Dec 15
8743
Master password for database Solved
password database masterpasswort odooV8
Avatar
Avatar
1
Oct 20
3110
Protect database postgresql password
security database postgresql encryption
Avatar
Avatar
1
Feb 20
4549