[Spce-user] "implicit" extensions

[florent goue]

hi Andrew
I am new to sipwise and kamailio.
My goal is to build a solid platform with sipwise.
  I'll follow your advice.
  I will use at least 7 digits, I can also use a rewrite rule in input and
output to convert to 7 digits and convert back to less than 7 digits.
In all these cases, I would like to say thank you.

I test it in my lab, it's OK !!!!

I appreciate

Le mar. 14 avr. 2020 à 16:05, Andrew Pogrebennyk <apogrebennyk at sipwise.com>
a écrit :

> Florent,
> 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.
> 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.
> 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:
> 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)");
> Hope this helps.
> Andrew
>
> On 14.04.2020, at 17:29, florent goue <florentgoue at gmail.com> wrote:
>
> Hi Andrew
> Did you read my last mail.
> Thx
>
> Le lun. 13 avr. 2020 à 19:59, florent goue <florentgoue at gmail.com> a
> écrit :
>
>> hi Andrew
>> thanks for your mail.
>>
>> information about your setup :
>>  Sipwise CE 8.3.3
>>  I had this problem with 7.5.3 CE
>>  In my lab, I setup:
>>   2 domain
>>   3 customers
>>   9 subscribers ( numbers: 200280, 20012, 200150, 200330, 200338,
>> 200320, 200340)
>>     In my test:
>>   A subscriber call the 200120 number, the call fail  (We would have
>> liked the call to reach the number 20012)
>>   A subscriber call the 2001500 number, the call fail (We would have
>> liked the call to reach the number 200150)
>>  The
>>
>> extended_dialing_mode : Extension matching, send dialed number with
>> extension
>>
>> Log1:
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20200414/fa1904b4/attachment-0002.html>