Community mailing list archives

community@mail.odoo.com

Re: how to change user password using psql

by
Numa Extreme Systems, Gustavo Marino
- 03/23/2015 16:49:11
Robert:
I think you are not asking about Postgresql role password, but the Odoo login password.

I you don't remember your password, you could always reset it, via UI. This is the recommended way.

But as a hack, if you wanna set the password to certain value, you should set on database the field password on res users in clear text, Then you could use this password just once. At the first login it will be encrypted and stored in password_crypt (see module auth_crypt), and the clear text version removed.

Regards

Gustavo Adrian Marino

 

Mobile:  +54 911 5498 2515

Email: gamarino@numaes.com

Skype: gustavo.adrian.marino

 

<img border="0" width="213" height="94" src="cid:image001.jpg@01CC37F5.99B4CD20" alt="Descripción: Numa Logo V 1-0">



2015-03-23 17:22 GMT-03:00 Moises Lopez <moylop260@vauxoo.com>:
What SQL standard you are using openerpmaster@gmail.com? (alter user username with password... really?)

With sql-92 standard is:
UPDATE res_users SET password = 'newpassword' WHERE login='username';

Or you can use in form view of res.users the wizard change password.



2015-03-23 13:58 GMT-06:00 OpenERP Master <openerpmaster@gmail.com>:
alter user username with password 'newpassword';

On Mon, Mar 23, 2015 at 12:42 PM, robert <robert@redcor.ch> wrote:
Hi there,
I would like to change some user password using psql commands:
select login, password, password_crypt from res_users where login = 
'support@redcor.ch';
        login                  | password | password_crypt
--------------------------+--------------+----------------
  support@redcor.ch |                  |
(1 row)

now I would like to set the password of that user.
How would I do that?

thanks for your help
robert

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe




--
Moisés López Calderón
Vauxoo - OpenERP's Gold Partner
Mobile: (+521) 477-752-22-30
Office: (+52) 477-773-33-46
web: http://www.vauxoo.com
twitter: @vauxoo
           @moylop260           

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe