<html><head></head><body><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></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></span></div><div><span><br></span></div><div><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></span></div><div><span><span><div>$tu is sip:+<span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;">12345678901@<span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;">123.123.123.123</span></span></span></span></div><div><span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;"><span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;"><br></span></span></span></span></div><div><span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;"><span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;">I have tried <span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;">+</span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;">12345678901 and <span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;">sip:+</span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;">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); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;"><span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;"><span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;"><span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;"><br></span></span></span></span></span></span></span></span></div><div><span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;"><span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;"><span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;"><span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;">What and I doing incorrectly?</span></span></span></span></span></span></span></span></div><div><span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;"><span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;"><span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;"><span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;"><br></span></span></span></span></span></span></span></span></div><div><span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;"><span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;"><span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;"><span><span style="color: rgb(0, 0, 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;">H</span></span></span></span></span></span></span></span></div></span></span></div></span></span></div>
<div id="yahoo_quoted_6239161636" class="yahoo_quoted">
<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></div>
<div><br></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="yqt0047592220" id="yqtfd23181"><br clear="none">On May 3, 2018 1:56:11 PM EDT, KamDev Essa <<a shape="rect" ymailto="mailto:kamdevessa@yahoo.com" 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 shape="rect" ymailto="mailto:sr-users@lists.kamailio.org" href="mailto:sr-users@lists.kamailio.org">sr-users@lists.kamailio.org</a><br clear="none"><a shape="rect" href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><div class="yqt0047592220" id="yqtfd44256"><br clear="none"></div></div></div>
</div>
</div></div></body></html>