<html><head></head><body><div style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div></div>
<div>I fugured out the issue. "Alias" is the ext and not the other way around. Works perfectly now.</div><div><br></div><div>Thanks for the help.</div><div><br></div><div>KD</div><div><br></div>
<div id="yahoo_quoted_5516781374" class="yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Thursday, May 3, 2018, 5:43:03 PM EDT, KamDev Essa <kamdevessa@yahoo.com> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id="yiv6809342258"><div><div style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div></div>
<div><span>I added alias and user via SQL insert (actual data changed for privacy)</span></div><div><span><br clear="none"></span></div><div><span><span>insert kamailio.dbaliases(alias_username,alias_domain, username , domain) values('12345678901','123.123.123.123','202','justanother.domain.net');</span><br clear="none"></span></div><div><span><br clear="none"></span></div><div><span><span></span></span><div>On the SIPOUT route I have intentionally called <span>alias_db_lookup("dbaliases"); right @ the start so that I see the change. I dont because the function never finds it.</span></div><div><span><br clear="none"></span></div><div><span><span></span></span><div>$tu is sip:+<span><span style="color:rgb(0, 0, 0);">12345678901@<span><span style="color:rgb(0, 0, 0);">123.123.123.123</span></span></span></span></div><div><span><span style="color:rgb(0, 0, 0);"><span><span style="color:rgb(0, 0, 0);"><br clear="none"></span></span></span></span></div><div><span><span style="color:rgb(0, 0, 0);"><span><span style="color:rgb(0, 0, 0);">I have tried <span><span style="color:rgb(0, 0, 0);">+</span><span style="color:rgb(0, 0, 0);">12345678901 and <span><span style="color:rgb(0, 0, 0);">sip:+</span><span style="color:rgb(0, 0, 0);">12345678901 as alias_username and nothing works.</span></span></span></span></span></span></span></span></div><div><span><span style="color:rgb(0, 0, 0);"><span><span style="color:rgb(0, 0, 0);"><span><span style="color:rgb(0, 0, 0);"><span><span style="color:rgb(0, 0, 0);"><br clear="none"></span></span></span></span></span></span></span></span></div><div><span><span style="color:rgb(0, 0, 0);"><span><span style="color:rgb(0, 0, 0);"><span><span style="color:rgb(0, 0, 0);"><span><span style="color:rgb(0, 0, 0);">What and I doing incorrectly?</span></span></span></span></span></span></span></span></div><div><span><span style="color:rgb(0, 0, 0);"><span><span style="color:rgb(0, 0, 0);"><span><span style="color:rgb(0, 0, 0);"><span><span style="color:rgb(0, 0, 0);"><br clear="none"></span></span></span></span></span></span></span></span></div><div><span><span style="color:rgb(0, 0, 0);"><span><span style="color:rgb(0, 0, 0);"><span><span style="color:rgb(0, 0, 0);"><span><span style="color:rgb(0, 0, 0);">H</span></span></span></span></span></span></span></span></div></div></div>
<div class="yiv6809342258yqt9282168663" id="yiv6809342258yqt78344"><div class="yiv6809342258yahoo_quoted" id="yiv6809342258yahoo_quoted_6239161636">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Thursday, May 3, 2018, 2:01:33 PM EDT, Alex Balashov <abalashov@evaristesys.com> wrote:
</div>
<div><br clear="none"></div>
<div><br clear="none"></div>
<div><div dir="ltr">You populate the table by... using SQL, I suppose.<br clear="none"><br clear="none">This module does no in-memory caching, so table changes have immediate effect and no reload is required. <br clear="none"><div class="yiv6809342258yqt0047592220" id="yiv6809342258yqtfd23181"><br clear="none">On May 3, 2018 1:56:11 PM EDT, KamDev Essa <<a rel="nofollow" shape="rect" ymailto="mailto:kamdevessa@yahoo.com" target="_blank" href="mailto:kamdevessa@yahoo.com">kamdevessa@yahoo.com</a>> wrote:<br clear="none">>How do I add entries into the dbaliases table and how do I reload<br clear="none">>without restating Kamailio.<br clear="none">>KD</div><br clear="none"><br clear="none"><br clear="none">-- Alex<br clear="none"><br clear="none">--<br clear="none">Sent via mobile, please forgive typos and brevity. <br clear="none"><br clear="none">_______________________________________________<br clear="none">Kamailio (SER) - Users Mailing List<br clear="none"><a rel="nofollow" shape="rect" ymailto="mailto:sr-users@lists.kamailio.org" target="_blank" href="mailto:sr-users@lists.kamailio.org">sr-users@lists.kamailio.org</a><br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><div class="yiv6809342258yqt0047592220" id="yiv6809342258yqtfd44256"><br clear="none"></div></div></div>
</div>
</div></div></div></div></div></div>
</div>
</div></div></body></html>