<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
true, in fact you *only* need to change user_privileges file if you
want to log on and then reset from within vtiger.<br>
<br>
Alan.<br>
<br>
<div class="moz-cite-prefix">On 19/02/16 15:06, Sutharsan Jeganathan
wrote:<br>
</div>
<blockquote
cite="mid:CABTTUfu7g3cGJ_GopR7WvZ4nKM_b9+H_jmRod4Mo7ujnwevDsw@mail.gmail.com"
type="cite">
<p dir="ltr">Hi </p>
<p dir="ltr">Also need to change user_privileges.php. correct?</p>
<p dir="ltr">Thanks</p>
<div class="gmail_quote">On 19 Feb 2016 16:19, "Alan Bell" <<a
moz-do-not-send="true" href="mailto:alan.bell@libertus.co.uk"><a class="moz-txt-link-abbreviated" href="mailto:alan.bell@libertus.co.uk">alan.bell@libertus.co.uk</a></a>>
wrote:<br type="attribution">
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> 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).<br>
<br>
so you would do something like:<br>
<br>
$pass=crypt(<span style="color:rgb(51,51,51);font-family:monospace;font-size:10.5625px;line-height:18.2px;white-space:pre-wrap;background-color:rgb(255,255,153)">"adpexzg3FUZAk","$2a$07$thisisthesalt$");
$hash=md5($pass);
</span><br>
<div>
<div><span style="color:rgb(51,51,51);font-family:monospace;font-size:10.5625px;line-height:18.2px;white-space:pre-wrap;background-color:rgb(255,255,153)">update vtiger_users set user_password = $pass, user_hash=$hash crypt_type = 'BLOWFISH' where user_name = 'mina';</span><br>
</div>
</div>
<div><span style="color:rgb(51,51,51);font-family:monospace;font-size:10.5625px;line-height:18.2px;white-space:pre-wrap;background-color:rgb(255,255,153)">
</span></div>
or, copy the user_password and user_hash from a user with a
known password.<br>
<br>
Alan.<br>
<br>
<div>On 19/02/16 10:18, Greg Vas wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">I have changed my admin password and want
to modify it
<div><br>
</div>
<div>I have also changed also the admin username to
"mina"</div>
<div> </div>
<div><br>
</div>
<div>Used command </div>
<div><br>
</div>
<div>
<div><span style="color:rgb(51,51,51);font-family:monospace;font-size:10.5625px;line-height:18.2px;white-space:pre-wrap;background-color:rgb(255,255,153)">update vtiger_users set user_password = 'adpexzg3FUZAk', crypt_type = '' where user_name = 'mina';</span><br>
</div>
</div>
<div><span style="color:rgb(51,51,51);font-family:monospace;font-size:10.5625px;line-height:18.2px;white-space:pre-wrap;background-color:rgb(255,255,153)">
</span></div>
<div>but it cannot do the job.<br>
</div>
<div><br>
</div>
<div>Is there any other solution?</div>
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
<a moz-do-not-send="true" href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a></pre>
</blockquote>
<br>
</div>
<br>
_______________________________________________<br>
<a moz-do-not-send="true" href="http://www.vtiger.com/"
rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br>
</blockquote>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
<a class="moz-txt-link-freetext" href="http://www.vtiger.com/">http://www.vtiger.com/</a></pre>
</blockquote>
<br>
</body>
</html>