<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Florent,<div class="">I got it, now it’s clear that the system can not match dialed number with a subscriber, the reason being that subscriber number is too short.</div><div class="">In the log we see messages "Callee is not local” and “No PSTN gateways available”, so it was a mis-routed attempt, this is due to SQL query in /etc/kamailio/proxy/proxy.cfg which does INSTR with min number length 7 digits. Your subscriber’s numbers are shorter than that.</div><div class="">The solution is to use base number of at least 7 digits, or as a work-around (non upgrade-safe and only if you are understand kamailio config file syntax) create a customtt file inside /etc/ngcp-config/templates (according to manual) that permits shorter base numbers, the exact line looking something like this, varying from one to another version:</div><div class=""><span class="Apple-tab-span" style="white-space:pre"> </span>sql_pvquery("local", "select username,domain,alias_username,is_primary,is_devid,devid_alias from dbaliases where alias_username like concat(left('$(var(callee_user){s.escape.common})', 7), '%') and instr('$(var(callee_user){s.escape.common})', alias_username)=1 order by length(alias_username) desc limit 1", "$avp(s:callee_user);$avp(s:callee_domain);$avp(s:callee_base_user);$avp(s:is_primary);$avp(s:callee_is_devid);$avp(s:callee_devid_alias)");<br class=""><div>Hope this helps.</div><div>Andrew</div><div><br class=""><blockquote type="cite" class=""><div class="">On 14.04.2020, at 17:29, florent goue <<a href="mailto:florentgoue@gmail.com" class="">florentgoue@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="auto" class="">Hi Andrew <div dir="auto" class="">Did you read my last mail.</div><div dir="auto" class="">Thx</div></div><br class=""><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Le lun. 13 avr. 2020 à 19:59, florent goue <<a href="mailto:florentgoue@gmail.com" class="">florentgoue@gmail.com</a>> a écrit :<br class=""></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr" class=""><font size="4" class="">hi Andrew</font><div class=""><font size="4" class="">thanks for your mail.</font></div><div class=""><font size="4" class=""><br class=""></font></div><div class=""><font size="4" class="">information about your setup :</font></div><div class=""><font size="4" class=""> Sipwise CE 8.3.3 </font></div><div class=""><font size="4" class=""> I had this problem with 7.5.3 CE<br class=""></font></div><div class=""><font size="4" class=""> In my lab, I setup:</font></div><div class=""><font size="4" class=""> 2 domain</font></div><div class=""><font size="4" class=""> 3 customers</font></div><div class=""><font size="4" class=""> 9 subscribers ( numbers: <span style="background-color:rgb(240,243,247);color:rgb(51,51,51);font-family:"Open Sans",arial,sans-serif" class="">200280, </span><span style="background-color:rgb(245,245,245);color:rgb(51,51,51);font-family:"Open Sans",arial,sans-serif" class="">20012, </span><span style="background-color:rgb(240,243,247);color:rgb(51,51,51);font-family:"Open Sans",arial,sans-serif" class="">200150, </span><span style="background-color:rgb(245,245,245);color:rgb(51,51,51);font-family:"Open Sans",arial,sans-serif" class="">200330, </span><span style="background-color:rgb(240,243,247);color:rgb(51,51,51);font-family:"Open Sans",arial,sans-serif" class="">200338, </span><span style="background-color:rgb(245,245,245);color:rgb(51,51,51);font-family:"Open Sans",arial,sans-serif" class="">200320, </span><span style="background-color:rgb(240,243,247);color:rgb(51,51,51);font-family:"Open Sans",arial,sans-serif" class="">200340)</span></font></div><div class=""><font size="4" class=""><span style="background-color:rgb(240,243,247);color:rgb(51,51,51);font-family:"Open Sans",arial,sans-serif" class=""> </span><span style="background-color:rgb(240,243,247);color:rgb(51,51,51);font-family:"Open Sans",arial,sans-serif" class=""> In my test:</span></font></div><div class=""><font size="4" class=""><span style="background-color:rgb(240,243,247);color:rgb(51,51,51);font-family:"Open Sans",arial,sans-serif" class=""> </span><span style="background-color:rgb(240,243,247);color:rgb(51,51,51);font-family:"Open Sans",arial,sans-serif" class="">A subscriber call the </span>200120 number, the call fail (We would have liked the call to reach the number 20012)</font></div><div class=""><font size="4" class=""> <span style="background-color:rgb(240,243,247);color:rgb(51,51,51);font-family:"Open Sans",arial,sans-serif" class=""> </span><span style="background-color:rgb(240,243,247);color:rgb(51,51,51);font-family:"Open Sans",arial,sans-serif" class="">A subscriber call the </span>2001500 number, the call fail (We would have liked the call to reach the number 200150)</font></div><div class=""><span style="background-color:rgb(240,243,247);color:rgb(51,51,51);font-family:"Open Sans",arial,sans-serif" class=""><font size="4" class=""> The </font></span></div><div class=""><font size="4" class=""><span style="color:rgb(51,51,51);font-family:"Open Sans",arial,sans-serif;background-color:rgb(240,243,247)" class=""><br class="">extended_dialing_mode</span> : Extension matching, send dialed number with extension<br class=""><br class="">Log1:</font></div></div></blockquote></div></div></blockquote></div></div></body></html>