Hi Dioris Thanks a lot for your tip.
When I calculated ha1 the first time,I missed the colon between fields. It must be included in the hash. Regards DangVinh On Fri, Jul 10, 2009 at 10:40 PM, Bogdan-Andrei Iancu < [email protected]> wrote: > Hi Dioris, > > Could you upload this on the web site (TIPS section) for other people > benefit ? See: http://www.opensips.org/Resources/Documentation#toc4 > > If you create an account on the web site, you are free to edit the content. > > Thanks and regards, > Bogdan > > > > Dioris Moreno wrote: > > 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). > > > > HA1 is a MD5 hash of "username:domain:password". For example, if you > > have created a SIP account [email protected] > > <mailto:[email protected]> using password 123456, then HA1 is the MD5 > > hash of "1000:mydomain.com:123456 <http://mydomain.com:123456>" > > (without quotes). On the other hand HA1B is the MD5 hash of > > "usern...@domain:domain:password"; so using the same example above, > > HA1B would be the MD5 hash of "[email protected]:mydomain.com:123456 > > <http://ydomain.com:123456>" (without quotes). > > > > So, to recalculate and update ha1 and ha1b columns in the subscriber > > table, just execute the following sql statement in mysql: > > > > update subscriber > > set ha1 = md5(concat(username, ':', domain, ':', password)), > > ha1b = md5(concat(username, '@', domain, ':', domain, ':', password)) > > > > I hope this could be useful. > > > > Regards, > > > > Dioris > > > > ------------------------------------------------------------------------ > > > > _______________________________________________ > > Users mailing list > > [email protected] > > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
