Postgres server password inside openerp-server.conf file!!

Question

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.

Manuel Villar Guijarro · Accepted Answer

You can't BUT you can make it secure.
Use an user just for openerp not a general admin of postgresql
Adjust the permisions of the file:
chmod 600 openerp-server.conf

André Schenkels · 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.

Related Posts	Odgovori	Prikazi
Admin password reset not working, tried database, odoo.conf password database admin	2 maj 25	3474
Enable password recovery from database password database recovery	6 jul. 17	12378
Retrieving Master Database Password password database master	2 dec. 15	10095
Master password for database Solved password database masterpasswort odooV8	1 okt. 20	4619
Protect database postgresql password security database postgresql encryption	1 feb. 20	4549

This question has been flagged

Enjoying the discussion? Don't just read, join in!