<span class="Apple-style-span" style="border-collapse: collapse; color: rgb(136, 136, 136); "><div>When you change the domain column in the subscriber table, you have to recalculate ha1 and ha1b fields. In order to do that you must have the password of each subscriber. It is stored in the 'password' column if you have set STORE_PLAINTEXT_PW=1 in opensipsctlrc (default).</div>
<div><br></div><div>HA1 is a MD5 hash of "username:domain:password". For example, if you have created a SIP account <a href="mailto:1000@mydomain.com" target="_blank" style="color: rgb(42, 93, 176); ">1000@mydomain.com</a> using password 123456, then HA1 is the MD5 hash of "1000:<a href="http://mydomain.com:123456" target="_blank" style="color: rgb(42, 93, 176); ">mydomain.com:123456</a>" (without quotes). On the other hand HA1B is the MD5 hash of "username@domain:domain:password"; so using the same example above, HA1B would be the MD5 hash of "1000@mydomain.com:m<a href="http://ydomain.com:123456" target="_blank" style="color: rgb(42, 93, 176); ">ydomain.com:123456</a>" (without quotes).</div>
<div><br></div><div>So, to recalculate and update ha1 and ha1b columns in the subscriber table, just execute the following sql statement in mysql:</div><div><br></div><div>update subscriber</div><div>set ha1 = md5(concat(username, ':', domain, ':', password)),</div>
<div>ha1b = md5(concat(username, '@', domain, ':', domain, ':', password))</div><div><br></div><div>I hope this could be useful.</div><div><br></div><div>Regards,</div><div><br></div><font color="#888888"><div>
Dioris</div><div><br></div></font></span><font color="#888888"></font><font color="#888888"></font>