[Vtigercrm-developers] Reset admin password

[Alan Bell]

yeah, that won't work. If you use the php crypt function on the password 
you should get something valid for that field to put in the database, 
you also need to set the user_hash field which is the MD5 of the hashed 
password (no, I have no idea why).

so you would do something like:

$pass=crypt("adpexzg3FUZAk","$2a$07$thisisthesalt$"); $hash=md5($pass);
update vtiger_users set user_password = $pass, user_hash=$hash 
crypt_type = 'BLOWFISH' where user_name = 'mina';
or, copy the user_password and user_hash from a user with a known password.

Alan.

On 19/02/16 10:18, Greg Vas wrote:
> I have changed my admin password and want to modify it
>
> I have also changed also the admin username to "mina"
>
> Used command
>
> update vtiger_users set user_password = 'adpexzg3FUZAk', crypt_type = 
> '' where user_name = 'mina';
> but it cannot do the job.
>
> Is there any other solution?
>
>
> _______________________________________________
> http://www.vtiger.com/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20160219/2df40845/attachment.html>