<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN" "http://www.w3.org/TR/REC-html40/strict.dtd">
<html><head><meta name="qrichtext" content="1" /><style type="text/css">
p, li { white-space: pre-wrap; }
</style></head><body style=" font-family:'Sans Serif'; font-size:10pt; font-weight:400; font-style:normal;">
<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;"><span style=" font-family:'monospace'; color:#000000; background-color:#ffffff;">[root@slim opensips]# opensipsctl add abc xyz </span><span style=" font-family:'monospace';"><br />Updated subscriber, rows affected: 1 <br /></span><span style=" font-family:'monospace'; font-weight:600; color:#000000; background-color:#ffffff;">new user 'abc' added</span><span style=" font-family:'monospace';"><br /></span></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;"><span style=" font-family:'monospace'; color:#000000; background-color:#ffffff;">10:abc:localhost:xyz::6c7faf173d3b8e26d95e7f26dd0388d6:e091cc8c08b19e1d50ee3891d3f37153:</span><span style=" font-family:'monospace';"><br /></span></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;"><span style=" font-family:'monospace'; color:#000000; background-color:#ffffff;">[root@slim opensips]# opensipsctl rm abc </span><span style=" font-family:'monospace';"><br />Updated dbaliases, rows affected: 0<br /><br /></span><span style=" font-family:'monospace'; color:#000000; background-color:#ffffff;">[root@slim opensips]# opensipsctl add abc@192.168.1.2 xyz </span><span style=" font-family:'monospace';"><br />Updated subscriber, rows affected: 1 <br /></span><span style=" font-family:'monospace'; font-weight:600; color:#000000; background-color:#ffffff;">new user 'abc@192.168.1.2' added</span><span style=" font-family:'monospace';"><br /></span></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;"><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:0px; margin-right:0px; -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:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'monospace';">abc@ not found.<br /></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:0px; margin-right:0px; -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:<br /></p>
<p style=" margin-top:12px; margin-bottom:12px; margin-left:40px; margin-right:40px; -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.<br /> <br /> Regards, </span><br /> </p>
<p style=" margin-top:12px; margin-bottom:12px; margin-left:40px; margin-right:40px; -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"><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/"><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:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">On 11/14/2018 06:52 PM, Robert Dyck wrote:<br /> </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;"> </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;">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:80px; margin-right:80px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"> </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;">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:80px; margin-right:80px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"> </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 Wednesday, November 14, 2018 6:11:52 AM PST Bogdan-Andrei Iancu 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;"> <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"><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:120px; margin-right:120px; -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"><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/"><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:120px; margin-right:120px; -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:160px; margin-right:160px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"> </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;">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:160px; margin-right:160px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"> </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;">So I added the users but made an error. </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;">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:160px; margin-right:160px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"> </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;">I corrected the user. </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;">opensipsctl rm abc, opensipsctl add <a href="mailto:abc@192.168.1.2"><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:160px; margin-right:160px; -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:160px; margin-right:160px; -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:160px; margin-right:160px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"> </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;">Opensips is restarted and the UAC registers. </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;"> </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;">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:160px; margin-right:160px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"> </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;">Some error checking in opensipsctl or the DB interface would be helpful. </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;"> </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;">Thanks for your time and the product. </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;">Rob </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';">_______________________________________________Users mailing list</span><a href="mailto:Users@lists.opensips.org"><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"><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:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"> <br /> </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;"><br /><br /></p></body></html>