How can I know the password of the openerp Postgresql user ? v7

Question

On postgresql, there is the openerp user, it gives the possiblity to interact with postgres via user interface. I want to get the password.

On shell, I went to *psql template1, *and I performed :

*select passwd from pg_user where usename = 'openerp'; *

but the password is crypted, is there any way to know the uncrypted password ?

Bole · Answer

If you can start your openerp server then password is in config file,

Look at /etc/openerp-server.conf (or some custom location) open the file and read the ass (db_password = some_pass)

Otherwise, if you can't run openerp server, then you will first need to change the password,
(and write new one in config file ,restart server)
if you need to change pass:
psql
alter role openerp with password 'your_new_password';

hope it helps

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
OpenERP 7 admin Password missing password openerp7	0 kesäk. 23	2241
Trying to extract a pdf file from ir_attachment.dbdatas Ratkaistu attachment postgresql openerp7	3 tammik. 17	10267
Restrict To Return None Value from the SQL Query Ratkaistu postgresql sql openerp7 odooV8	2 jouluk. 19	6313
How to represent Postgresql interval in Openerp 7 ? postgresql python2.7 openerp7 postgresql9.3	0 lokak. 18	3396
White/blank screen when loading OpenERP javascript postgresql python2.7 openerp7	5 tammik. 18	15013

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!