sr-users September 2017

sr-users@lists.kamailio.org

86 participants
124 discussions

Loading keys with key_type="1" from database for htable - Module params help needed
by George Diamantopoulos 06 Sep '17

06 Sep '17

3 3

Call pickup with feature code
by Cyrille Demaret 06 Sep '17

06 Sep '17

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 … [View More]

1 0

SQL for ordered LCR rules
by Patrick Wakano 06 Sep '17

06 Sep '17

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 … [View More]

4 3

Re: [SR-Users] SQL for ordered LCR rules
by Patrick Wakano 06 Sep '17

06 Sep '17

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 … [View More]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 >>> >>> >> > [View Less]

2 4

real-time update question
by Stent, Bob 05 Sep '17

05 Sep '17

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 … [View More]

3 2

5.0 Version compiling gives warning
by Yasin CANER 05 Sep '17

05 Sep '17

3 3

Dialplan Module
by Nelson Migliaro 05 Sep '17

05 Sep '17

Hello, Do you know if its possible to

2 2

Re: [SR-Users] Incorrect value when setting number like values in Htable using Kamcmd
by Tony - Telecomy 05 Sep '17

05 Sep '17

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

1 0

Incorrect value when setting number like values in Htable using Kamcmd
by Tony - Telecomy 05 Sep '17

05 Sep '17

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 … [View More]

3 2

telcosuite3-crm sql
by Kordován Szabolcs 05 Sep '17

05 Sep '17

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

3 7

2025

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