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	Răspunsuri	Vizualizări
Admin password reset not working, tried database, odoo.conf password database admin	2 mai 25	3414
Enable password recovery from database password database recovery	6 iul. 17	12324
Retrieving Master Database Password password database master	2 dec. 15	10050
Master password for database Rezolvat password database masterpasswort odooV8	1 oct. 20	4568
Protect database postgresql password security database postgresql encryption	1 feb. 20	4549

Această întrebare a fost marcată

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