sr-users September 2017

sr-users@lists.kamailio.org

86 participants
123 discussions

by Cyrille Demaret

Hi, I'm trying to implement call pickup with a feature code for phones that doesn't support "Replaces" header. User has to dial for example *8 to pickup a call who is in the same group pickup. My idea is to loop for each members of the group (coming from a SQL table using sqlops) and check for calls in early state. I was thinking to use the dialog module to search for active calls but I don't find any function allowing to do this. Does anyone know a module with a function allowing to find an active calls by callee? Thank you, Cyrille

7 years

SQL for ordered LCR rules

by Patrick Wakano

Hello list, Hope you all doing well! I am trying to ease the management of LCR routing rules, since once we begin to have multiple prefixes, multiple GWs and so on, the visualization and management of the rules priorities becomes exponentially hard to do. So first thing I am trying to achieve is an easy way of retrieving the rules in an ordered manner. I couldn't find any tool to do such thing and source code was not very friendly.... so I've come up with this Postgresql query that I think retrieves all rules in the same order I expect LCR to select the GWs. SELECT lr.lcr_id, lr.prefix, lrt.priority, lg.gw_name, lg.ip_addr FROM lcr_rule lr JOIN lcr_rule_target lrt ON lrt.lcr_id = lr.lcr_id AND lrt.rule_id = lr.id JOIN lcr_gw lg ON lg.lcr_id = lr.lcr_id AND lg.id = lrt.gw_id WHERE lr.enabled = 1 AND lg.defunct = 0 AND lr.lcr_id = ID AND lr.prefix SIMILAR TO '(|PREFIX%)' ORDER BY lr.lcr_id, LENGTH(lr.prefix) DESC, lrt.priority; It is missing the weights calculation, but it is rather complex and I am not using it anyway.... Other than that does anyone did something similar to check if my query really matches what LCR engine does? Thanks, Patrick Wakano

7 years

Re: [SR-Users] SQL for ordered LCR rules

by Patrick Wakano

Thanks for the response guys! The link https://github.com/dimitri/prefixIt is returning 404.... Regarding the performance itself I am not worried since this select it is just for management and I don't expect having millions of rules. The idea is just to have an easy way to have a picture of how the LCR will order and select the gateways based on a given prefix. The three LCR tables are not so easy to handle and manage from command line so my idea was to have a single SELECT or VIEW to return me all I need at once! >From what I could check, I think the select I sent pretty much translates what LCR module does internally, I am just trying to verify if it has some flaw, which could mislead me in the rules management. Cheers, Patrick Wakano On 6 September 2017 at 00:32, Dmitry Sinina <dmitry.sinina(a)onat.edu.ua> wrote: > https://yeti-switch.org/demo.html > > > On 9/5/17 5:29 PM, Dmitry Sinina wrote: > >> And you can try our opensource LCR engine. We use kamailio as load >> balancer and SEMS as SBC. >> >> On 9/5/17 3:02 AM, Patrick Wakano wrote: >> >>> Hello list, >>> >>> Hope you all doing well! >>> I am trying to ease the management of LCR routing rules, since once we >>> begin to have multiple prefixes, multiple GWs and so on, the visualization >>> and management of the rules priorities becomes exponentially hard to do. >>> So first thing I am trying to achieve is an easy way of retrieving the >>> rules in an ordered manner. I couldn't find any tool to do such thing and >>> source code was not very friendly.... so I've come up with this Postgresql >>> query that I think retrieves all rules in the same order I expect LCR to >>> select the GWs. >>> >>> SELECT lr.lcr_id, lr.prefix, lrt.priority, lg.gw_name, lg.ip_addr >>> FROM lcr_rule lr >>> JOIN lcr_rule_target lrt ON lrt.lcr_id = lr.lcr_id AND lrt.rule_id = >>> lr.id <http://lr.id> >>> JOIN lcr_gw lg ON lg.lcr_id = lr.lcr_id AND lg.id <http://lg.id> = >>> lrt.gw_id >>> WHERE lr.enabled = 1 AND lg.defunct = 0 AND lr.lcr_id = ID AND lr.prefix >>> SIMILAR TO '(|PREFIX%)' >>> ORDER BY lr.lcr_id, LENGTH(lr.prefix) DESC, lrt.priority; >>> >>> It is missing the weights calculation, but it is rather complex and I am >>> not using it anyway.... Other than that does anyone did something similar >>> to check if my query really matches what LCR engine does? >>> >>> Thanks, >>> Patrick Wakano >>> >>> _______________________________________________ >>> Kamailio (SER) - Users Mailing List >>> sr-users(a)lists.kamailio.org >>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >>> >>> >> >

7 years

real-time update question

by Stent, Bob

I am just starting out with Kamailio. One of the things I want to be able to do is add a domain to the configuration and have Kamailio pick it up without having to restart. I see there is a runtime update framework but I am having trouble navigating the documentation to find out what this actually does for me. Can somebody point me to the right set of docs to read to figure this out? Do I simply add an alias to the kamalio.cfg file and somehow send an RPC command to Kamalio to re-read configuration? Bob Stent Aspect Software 5 Technology Park Drive Suite #9 Westford, MA 01886 This email (including any attachments) is proprietary to Aspect Software, Inc. and may contain information that is confidential. If you have received this message in error, please do not read, copy or forward this message. Please notify the sender immediately, delete it from your system and destroy any copies. You may not further disclose or distribute this email or its attachments.

7 years

5.0 Version compiling gives warning

by Yasin CANER

7 years

Dialplan Module

by Nelson Migliaro

Hello, Do you know if its possible to

7 years

Re: [SR-Users] Incorrect value when setting number like values in Htable using Kamcmd

by Tony - Telecomy

Prefixing the numbers with "s:" fixed the issue. Thank you for your help. Tony

7 years

Incorrect value when setting number like values in Htable using Kamcmd

by Tony - Telecomy

Hello, I'm having an issue setting phone numbers values in htable using kamcmd when the phone number is above the integer range 2147483647. Initially I planned to set the values as strings but this is not working as expected as well. Please find below some examples: root@tst:~/tst/test# kamcmd htable.seti tst_sim integer_limit "2147483647" root@tst:~/tst/test# kamcmd htable.seti tst_sim integer_exceeded_limit "2147483648" root@tst:~/tst/test# kamcmd htable.sets tst_sim integer_as_string_valid "2147483647" root@tst:~/tst/test# kamcmd htable.sets tst_sim integer_as_string_invalid "2147483648" root@tst:~/tst/test# kamcmd htable.dump tst_sim | grep -A 1 integer name: integer_as_string_valid value: 2147483647 -- name: integer_limit value: 2147483647 -- name: integer_as_string_invalid value: 18446744071562067968 -- name: integer_exceeded_limit value: -2147483648 my ctl params are as follow: modparam("ctl", "binrpc", "unix:/var/run/kamailio/kamailio_ctl") modparam("ctl", "binrpc_max_body_size", 1024) modparam("ctl", "binrpc_struct_max_body_size", 1024) Thanks, Tony

7 years

telcosuite3-crm sql

by Kordován Szabolcs

Hi, I would like to try the IMS according to the Kamailio World 2017: Kamailio For IMS And VoLTE presentation. Unfortunately I have problem with telcosuite, the sql structure is missing. Where can I find the whole create.sql? Thanks for help. Regards, Szabolcs

7 years

Kamailio SIP protocol over WSS

by Washington Costa

Hi, I solved my problem. I was missing load some modules and routers. I saw this file as example: https://gist.github.com/jesusprubio/4066845 but is important to know that every module the begin "mi" they aren't supporte on Kamailio 5.0. You will need replace for the module relative the version 5.0. Washington L da Costa Analista de Sistemas (82) 9 9823-4782

7 years

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

sr-users September 2017