<div dir="ltr"><div><div>I think if I can change this query, it will work:<br><br>Jul 18 18:00:13 opensips /usr/sbin/opensips[7146]: DBG:db_mysql:re_init_statement: query is <select password,ha1 from subscriber where username=? AND domain=?>, ptr=(nil)<br>
<br></div>Use without domain= and now accept any domain.<br><br></div>It is possible?<br><br></div><div class="gmail_extra"><br clear="all"><div>Willian Mazzardo<br>Depto TI - SYSSVOIP<br><a href="http://www.syssvoip.com.br">www.syssvoip.com.br</a><br>
55 3537 2030</div>
<br><br><div class="gmail_quote">2013/7/18 Willian Mazzardo - SYSSVOIP <span dir="ltr"><<a href="mailto:willian@syssvoip.com.br" target="_blank">willian@syssvoip.com.br</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">Sorry ... for <a href="http://test.provider.com" target="_blank">test.provider.com</a> I use <a href="http://opensips.provider.com.br" target="_blank">opensips.provider.com.br</a><br><br>;)<br><br></div><div class="gmail_extra">
<div class="im"><br clear="all">
<div>Willian Mazzardo<br>Depto TI - SYSSVOIP<br><a href="http://www.syssvoip.com.br" target="_blank">www.syssvoip.com.br</a><br><a href="tel:55%203537%202030" value="+555535372030" target="_blank">55 3537 2030</a></div>
<br><br></div><div><div class="h5"><div class="gmail_quote">2013/7/18 Willian Mazzardo - SYSSVOIP <span dir="ltr"><<a href="mailto:willian@syssvoip.com.br" target="_blank">willian@syssvoip.com.br</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr"><div><div><div><div><div>Hi Nick ... thanks for your help ... very appreciated.<br><br></div>Here is the news... changed the opensips.cfg to your modeparams, and use_domain to 0 and the problem still the same:<br>
<br></div>In my domain tables I have all domains (10.1.1.2, <a href="http://test.provider.com" target="_blank">test.provider.com</a>) but into subscriber, i have recreated without VIEW and use more simple data, like 1000 and 1001 as username and password = teste and domain = 10.1.1.2.<br>
<br></div>If I try register softphone with domain = 10.1.1.2, it work, but if I try domain = <a href="http://test.provider.com" target="_blank">test.provider.com</a> wich is using 10.1.1.2 as IP address, doesn't work.<br>
<br></div>here is the log:<br>
<br><a href="http://pastebin.com/zTz0eNjV" target="_blank">http://pastebin.com/zTz0eNjV</a><br><br></div>Thanks for your help<br><div><div><div><div><div><br></div></div></div></div></div></div><div class="gmail_extra"><div>
<br clear="all"><div>
Willian Mazzardo<br>Depto TI - SYSSVOIP<br><a href="http://www.syssvoip.com.br" target="_blank">www.syssvoip.com.br</a><br><a href="tel:55%203537%202030" value="+555535372030" target="_blank">55 3537 2030</a></div>
<br><br></div><div class="gmail_quote">2013/7/18 Nick Khamis <span dir="ltr"><<a href="mailto:symack@gmail.com" target="_blank">symack@gmail.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div>
<div dir="ltr">First things first. Forget the asterisk box for now. The phones are not getting registered with OpenSIPS.<div>dOES the username, domain, in the digest make sense? Also, recheck the auth part of your configuration:</div>
<div><br></div><div><div># ----- auth params -----</div><div>modparam("auth","username_spec","$avp(user_spec)")</div><div>modparam("auth","password_spec","$avp(pass_spec)")</div>
<div><br></div><div><br></div><div># ----- auth_db params -----</div><div>/* uncomment the following lines if you want to enable the DB based</div><div> authentication */</div><div><br></div><div>modparam("auth_db", "user_column", "username")</div>
<div>modparam("auth_db", "password_column", "ha1")</div><div># modparam("auth_db", "password_column2", "ha1b")</div><div>modparam("auth_db", "use_domain", 1)</div>
<div>modparam("auth_db", "calculate_ha1", 0)</div><div>modparam("auth_db", "load_credentials", "rpid")</div><div>modparam("auth_db", "load_credentials", "$avp(pass_spec)=ha1")</div>
<div><br></div><div>Maybe start with clear text username/password and then add the md5 when you know that it is working. Oh!!! Increase</div><div>the debug level of OpenSIPS (debug=4), and eye the REGISTER, it will show you the clear text usernames and passwords</div>
<div>being sent, the comparisson, and why it's etting rejected. You can post it on pastebin, but please make sure it's for an example</div><div>user (i.e, 1001/12345a), that you will delete later.</div>
<div><br></div><div><div><div style="font-family:arial,sans-serif;font-size:13px">>> Not all my customers use same dns name to register.<br>>> I have some: <a href="http://sip.myprovider.com/" target="_blank">sip.myprovider.com</a>, <a href="http://sip2.myprovider.com/" target="_blank">sip2.myprovider.com</a>, <a href="http://sip3.myprovider.com/" target="_blank">sip3.myprovider.com</a> and I have my IPs (111.222.333.444).<br>
>> Can I let domain blank to use "any" ?<br></div><div style="font-family:arial,sans-serif;font-size:13px"><br></div><div style="font-family:arial,sans-serif;font-size:13px"><br></div></div><div style="font-family:arial,sans-serif;font-size:13px">
<span style="font-family:arial;font-size:small">Set, modparam("auth_db", "use_domain", 0).</span><br></div><div style="font-family:arial,sans-serif;font-size:13px"><span style="font-family:arial;font-size:small"><br>
</span></div><div>Let us know how you progress.</div><div><br></div><div>Cheers,</div><div><br></div><div>Nick from Toronto.</div></div><div><br></div><div><br></div></div></div>
<br></div></div><div>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">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></div></blockquote></div><br></div>
</blockquote></div><br></div></div></div>
</blockquote></div><br></div>