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 ?
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:
alter role openerp with password 'your_new_password';
hope it helps
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 1/1/15, 2:35 PM|
|Seen: 471 times|
|Last updated: 3/16/15, 8:10 AM|