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	Replies	Views
Admin password reset not working, tried database, odoo.conf password database admin	2 मई 25	3473
Enable password recovery from database password database recovery	6 जुल॰ 17	12376
Retrieving Master Database Password password database master	2 दिस॰ 15	10093
Master password for database Solved password database masterpasswort odooV8	1 अक्तू॰ 20	4617
Protect database postgresql password security database postgresql encryption	1 फ़र॰ 20	4549

This question has been flagged

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