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	Odpovědi	Zobrazení
Admin password reset not working, tried database, odoo.conf password database admin	2 kvě 25	3371
Enable password recovery from database password database recovery	6 čvc 17	12293
Retrieving Master Database Password password database master	2 pro 15	10024
Master password for database Vyřešeno password database masterpasswort odooV8	1 říj 20	4544
Protect database postgresql password security database postgresql encryption	1 úno 20	4549

This question has been flagged

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