Skip to Content
This question has been flagged
securitypassworddatabase
2 Respostes
32523 Vistes
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
Descartar
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
Descartar
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
Descartar
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 Respostes Vistes Activitat
Admin password reset not working, tried database, odoo.conf
password database admin
Avatar
Avatar
2
de maig 25
899
Enable password recovery from database
password database recovery
Avatar
Avatar
Avatar
6
de jul. 17
11172
Retrieving Master Database Password
password database master
Avatar
Avatar
Avatar
2
de des. 15
9106
Master password for database Solved
password database masterpasswort odooV8
Avatar
Avatar
1
d’oct. 20
3498
Protect database postgresql password
security database postgresql encryption
Avatar
Avatar
1
de febr. 20
4549