Skip to Content
This question has been flagged
securitypassworddatabase
2 Replies
33777 Zobrazenia
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
Zrušiť
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
Zrušiť
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
Zrušiť
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 Replies Zobrazenia Aktivita
Admin password reset not working, tried database, odoo.conf
password database admin
Avatar
Avatar
2
máj 25
3432
Enable password recovery from database
password database recovery
Avatar
Avatar
Avatar
6
júl 17
12341
Retrieving Master Database Password
password database master
Avatar
Avatar
Avatar
2
dec 15
10067
Master password for database Solved
password database masterpasswort odooV8
Avatar
Avatar
1
okt 20
4588
Protect database postgresql password
security database postgresql encryption
Avatar
Avatar
1
feb 20
4549