<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>Hi Robert,<br>
<br>
So, the data in DB is ok, but the auth still fails - please paste
the exact setting/modparams you have for the auth_db module along
with the return code provided by the www_auth function - see
<a class="moz-txt-link-freetext" href="http://www.opensips.org/html/docs/modules/2.4.x/auth_db.html#func_www_authorize">http://www.opensips.org/html/docs/modules/2.4.x/auth_db.html#func_www_authorize</a><br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a>
OpenSIPS Bootcamp 2018
<a class="moz-txt-link-freetext" href="http://opensips.org/training/OpenSIPS_Bootcamp_2018/">http://opensips.org/training/OpenSIPS_Bootcamp_2018/</a>
</pre>
<div class="moz-cite-prefix">On 11/14/2018 08:03 PM, Robert Dyck
wrote:<br>
</div>
<blockquote type="cite" cite="mid:3727916.AF73741jUM@blacky.mylan">
<meta name="qrichtext" content="1">
<style type="text/css">
p, li { white-space: pre-wrap; }
</style>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">I added "modparam("auth_db", "use_domain", 1)" but it doesn't make a difference to the subscriber table.</p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; "> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">On Wednesday, November 14, 2018 9:36:34 AM PST Robert Dyck wrote:
</p>
<p style=" margin-top:12px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'monospace'; color:#000000; background-color:#ffffff;">[root@slim opensips]# opensipsctl add abc xyz </span><span style=" font-family:'monospace';">
Updated subscriber, rows affected: 1
</span><span style=" font-family:'monospace'; font-weight:600; color:#000000; background-color:#ffffff;">new user 'abc' added</span><span style=" font-family:'monospace';">
</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'monospace'; color:#000000; background-color:#ffffff;">10:abc:localhost:xyz::6c7faf173d3b8e26d95e7f26dd0388d6:e091cc8c08b19e1d50ee3891d3f37153:</span><span style=" font-family:'monospace';">
</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'monospace'; color:#000000; background-color:#ffffff;">[root@slim opensips]# opensipsctl rm abc </span><span style=" font-family:'monospace';">
Updated dbaliases, rows affected: 0
</span><span style=" font-family:'monospace'; color:#000000; background-color:#ffffff;">[root@slim opensips]# opensipsctl add <a class="moz-txt-link-abbreviated" href="mailto:abc@192.168.1.2">abc@192.168.1.2</a> xyz </span><span style=" font-family:'monospace';">
Updated subscriber, rows affected: 1
</span><span style=" font-family:'monospace'; font-weight:600; color:#000000; background-color:#ffffff;">new user '<a class="moz-txt-link-abbreviated" href="mailto:abc@192.168.1.2">abc@192.168.1.2</a>' added</span><span style=" font-family:'monospace';">
</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'monospace'; color:#000000; background-color:#ffffff;">10:abc:192.168.1.2:xyz::9ce761c3a9f328510ea011bd5c9bd2c5:cc312796ec331326cd537f3a3ffad7b6:</span></p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; "> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'monospace';">The difference being localhost vs 192.168.1.2</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'monospace';">abc@ not found.
</span></p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; "> </p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; "> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">On Wednesday, November 14, 2018 8:59:10 AM PST Bogdan-Andrei Iancu wrote:
</p>
<p style=" margin-top:12px; margin-bottom:12px; margin-left:80px; margin-right:80px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"> <span style=" font-family:'Monospace';">That's the whole idea - if the "use_domain" is on 0, OpenSIPS will reference the users only by username. So try "opensipsctl add abc xyz" and post what record you get into the subscriber table.
Regards, </span>
</p>
<p style=" margin-top:12px; margin-bottom:12px; margin-left:80px; margin-right:80px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Monospace';">Bogdan-Andrei IancuOpenSIPS Founder and Developer </span><a href="http://www.opensips-solutions.com" moz-do-not-send="true"><span style=" font-family:'Monospace'; text-decoration: underline; color:#2980b9;">http://www.opensips-solutions.com</span></a><span style=" font-family:'Monospace';">OpenSIPS Bootcamp 2018 </span><a href="http://opensips.org/training/OpenSIPS_Bootcamp_2018/" moz-do-not-send="true"><span style=" font-family:'Monospace'; text-decoration: underline; color:#2980b9;">http://opensips.org/training/OpenSIPS_Bootcamp_2018/</span></a> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:80px; margin-right:80px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">On 11/14/2018 06:52 PM, Robert Dyck wrote:
</p>
<p style=" margin-top:12px; margin-bottom:12px; margin-left:120px; margin-right:120px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:120px; margin-right:120px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">I do not have that parameter set and I do not use multiple domains. </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:120px; margin-right:120px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:120px; margin-right:120px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">The problem was that after I corrected the error ( missing domain ), opensips continued to look for abc@ rather than abc. I was looking for a graceful way to correct the internal representation of the user name. Restarting opensips is no problem on a small installation but it is less than ideal. </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:120px; margin-right:120px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:120px; margin-right:120px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">On Wednesday, November 14, 2018 6:11:52 AM PST Bogdan-Andrei Iancu wrote: </p>
<p style=" margin-top:12px; margin-bottom:12px; margin-left:160px; margin-right:160px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"> <span style=" font-family:'Monospace';">Hi Robert, Do you have the "use_domain" parameter enabled in the auth_db module ? </span><a href="http://www.opensips.org/html/docs/modules/2.4.x/auth_db.html#param_use_domain" moz-do-not-send="true"><span style=" font-family:'Monospace'; text-decoration: underline; color:#2980b9;">http://www.opensips.org/html/docs/modules/2.4.x/auth_db.html#param_use_domain</span></a><span style=" font-family:'Monospace';"> Regards, </span> </p>
<p style=" margin-top:12px; margin-bottom:12px; margin-left:160px; margin-right:160px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Monospace';">Bogdan-Andrei IancuOpenSIPS Founder and Developer </span><a href="http://www.opensips-solutions.com" moz-do-not-send="true"><span style=" font-family:'Monospace'; text-decoration: underline; color:#2980b9;">http://www.opensips-solutions.com</span></a><span style=" font-family:'Monospace';">OpenSIPS Bootcamp 2018 </span><a href="http://opensips.org/training/OpenSIPS_Bootcamp_2018/" moz-do-not-send="true"><span style=" font-family:'Monospace'; text-decoration: underline; color:#2980b9;">http://opensips.org/training/OpenSIPS_Bootcamp_2018/</span></a> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:160px; margin-right:160px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">On 11/07/2018 04:30 AM, Robert Dyck wrote: </p>
<p style=" margin-top:12px; margin-bottom:12px; margin-left:200px; margin-right:200px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:200px; margin-right:200px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">I have updated my small test bed from 2.3.2 to 2.4.2. I didn't bother to back up the 'subscriber" table and it was wiped by the installation. No big deal, it was tiny. </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:200px; margin-right:200px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:200px; margin-right:200px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">So I added the users but made an error. </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:200px; margin-right:200px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">opensipsctl add abc xyz -- I didn't specify the domain. The UAC would not register. </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:200px; margin-right:200px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:200px; margin-right:200px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">I corrected the user. </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:200px; margin-right:200px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">opensipsctl rm abc, opensipsctl add <a href="mailto:abc@192.168.1.2" moz-do-not-send="true"><span style=" text-decoration: underline; color:#2980b9;">abc@192.168.1.2</span></a> xyz </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:200px; margin-right:200px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">The UAC still cannot register. </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:200px; margin-right:200px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'monospace'; color:#000000; background-color:#ffffff;">DBG:auth_db:get_ha1: no result for user 'abc@'</span> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:200px; margin-right:200px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:200px; margin-right:200px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Opensips is restarted and the UAC registers. </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:200px; margin-right:200px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:200px; margin-right:200px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Restaring a production machine is problematic. Is there a way to flush the bad data which I assume has been cached? </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:200px; margin-right:200px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:200px; margin-right:200px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Some error checking in opensipsctl or the DB interface would be helpful. </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:200px; margin-right:200px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:200px; margin-right:200px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Thanks for your time and the product. </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:200px; margin-right:200px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Rob </p>
<p style=" margin-top:12px; margin-bottom:12px; margin-left:200px; margin-right:200px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Monospace';">_______________________________________________Users mailing list</span><a href="mailto:Users@lists.opensips.org" moz-do-not-send="true"><span style=" font-family:'Monospace'; text-decoration: underline; color:#2980b9;">Users@lists.opensips.org</span></a><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" moz-do-not-send="true"><span style=" font-family:'Monospace'; text-decoration: underline; color:#2980b9;">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</span></a> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">
</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">
</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">
</p>
</blockquote>
<br>
</body>
</html>