Also check you "domain" table as well the same entry in the posted table. <br><br><div class="gmail_quote">On Tue, Sep 27, 2011 at 2:51 PM, Max Mühlbronner <span dir="ltr"><<a href="mailto:mm@42com.com">mm@42com.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div bgcolor="#FFFFFF" text="#000000">
Hi,<br>
<br>
it is probably related to the calculate_ha1 modparam in opensips.cfg
(default is 0) .<br>
<br>
The database entry you showed to us, had no ha1/ha1b entries and if
calculate_ha1 is set to 0 the authentification will not work because
there is only a clear-text password in the db.<br>
<br>
<br>
Best Regards<br>
<br>
Max M.<br>
<br>
<br>
Am <a href="tel:27.09.2011%2009" value="+12709201109" target="_blank">27.09.2011 09</a>:26, schrieb yasiru welandawe:
<blockquote type="cite"><div><div></div><div class="h5">
<div style="color:#000;background-color:#fff;font-family:lucida console, sans-serif;font-size:10pt">
<div style="font-family:'lucida console', sans-serif;font-size:10pt"><br>
</div>
<div>
<div style="font-size:12pt;font-family:'times new roman', 'new york', times, serif">Hi all,</div>
<div style="font-family:'times new roman', 'new york', times, serif;font-size:12pt"><br>
</div>
<div style="font-family:'times new roman', 'new york', times, serif;font-size:12pt">I had successfully
install Opensips 1.7.0 and configured mysql DB with it. Now
Opensips up and running. I add sip account to mysql DB as
follows.</div>
<div style="font-family:'times new roman', 'new york', times, serif;font-size:12pt"><br>
</div>
<div>
<div><font face="'Courier New', courier,
monaco, monospace, sans-serif">mysql> select * from
subscriber;</font></div>
<div><font face="'Courier New', courier,
monaco, monospace, sans-serif">+----+----------+----------------+----------+------------------+-----+------+------+</font></div>
<div><font face="'Courier New', courier,
monaco, monospace, sans-serif">| id | username | domain
| password | email_address | ha1 | ha1b |
rpid |</font></div>
<div><font face="'Courier New', courier,
monaco, monospace, sans-serif">+----+----------+----------------+----------+------------------+-----+------+------+</font></div>
<div><font face="'Courier New', courier,
monaco, monospace, sans-serif">| 1 | 1000 |
192.168.102.24 | 1000 | <a href="mailto:modygw@yahoo.com" target="_blank">modygw@yahoo.com</a> | |
| |</font></div>
<div><font face="'Courier New', courier,
monaco, monospace, sans-serif">+----+----------+----------------+----------+------------------+-----+------+------+</font></div>
<div><font face="'Courier New', courier,
monaco, monospace, sans-serif">1 row in set (0.02 sec)</font></div>
<div style="font-family:'times new roman', 'new york', times, serif;font-size:12pt"><br>
</div>
<div style="font-family:'times new roman', 'new york', times, serif;font-size:12pt"><br>
</div>
<div style="font-family:'times new roman', 'new york', times, serif;font-size:12pt">But it gives "SIP/2.0 401
Unauthorized." when I try to register my soft phone with
this account. Can someone help me.</div>
<div style="font-family:'times new roman', 'new york', times, serif;font-size:12pt"><br>
</div>
<div style="font-family:'times new roman', 'new york', times, serif;font-size:12pt"><br>
</div>
<div style="font-family:'times new roman', 'new york', times, serif;font-size:12pt">Thank you,</div>
<div style="font-family:'times new roman', 'new york', times, serif;font-size:12pt">--</div>
<div style="font-family:'times new roman', 'new york', times, serif;font-size:12pt">Yasiru</div>
<div style="font-family:'times new roman', 'new york', times, serif;font-size:12pt"><br>
</div>
</div>
</div>
</div>
<br>
<fieldset></fieldset>
<br>
</div></div><div class="im"><pre>_______________________________________________
Users mailing list
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</div></blockquote>
<br>
<br>
<pre cols="72">--
42com Telecommunication GmbH
Straße der Pariser Kommune 12-16 / D-10243 Berlin
E-mail: <a href="mailto:mm@42com.com" target="_blank">mm@42com.com</a>
Homepage: <a href="http://www.42com.com" target="_blank">www.42com.com</a>
Firmenangaben/Company information:
Handelsregister/Commercial register: Amtsgericht Berlin HRB 99071 B
Umsatzsteuer-ID/VAT-ID: DE223812306, Geschäftsführer/CEO: Thomas Reinig, Alexander Reinig
Diese E-Mail enthält Informationen von 42com Telecommunication GmbH. Diese sind möglicherweise vertraulich und ausschließlich für den Adressaten bestimmt. Sollten Sie diese elektronische Nachricht irrtümlicherweise erhalten haben, so informieren Sie uns bitte unverzüglich telefonisch oder per E-Mail.
This message is intended only for the use of the individual or entity to
which it is addressed. If you have received this message in error, please delete the message and notify us immediately.</pre>
</div>
<br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br>