sr-users

sr-users@lists.kamailio.org

42 participants
37519 discussions

How can client get registered users list from Kamailio server or server may broadcast this actively?
by Jack Wang 07 Sep '17

07 Sep '17

Hey guys, As indicated by the title, is there any module providing the related function? My server version is 4.2. Thanks. :)

2 1

Cost deduction in kamailio
by Logeshwaran G 07 Sep '17

07 Sep '17

Hi, How to deduct the call cost or credits for the subscribers with the cnxcc module? Input Please Thanks & Kind Regards, Logeshwaran G

3 15

Query in LCR
by Logeshwaran G 07 Sep '17

07 Sep '17

Hi, I am handling Two Different Account holders and Two Different Gateways with the different lcr_ids: id :1 lcr_id:1 gw_name:car1 ip_addr : 1.2.3.4 id :2 lcr_id:2 gw_name:car2 ip_addr : 1.2.5.3 In kamailio config file I am using load_gws(1), Here Comes my doubt, I need to Pass the lcr_id value inside the load_gws(lcr_id) Dynamically, Is it Possible , Please Guide me. Thanks & Kind Regards, *Logeshwaran G* *"Be Hunger, Stay Foolish"*

2 2

Doubt in Lcr_table
by Logeshwaran G 07 Sep '17

07 Sep '17

Hi, May I know the Difference between the "prefix" column in Lcr_gw table and lcr_rule table. I am using the prefix value in lcr_rule table, like 00091. But What is the use of Prefix Column in lcr_gw table. Input Please Thanks & Kind Regards, *Logeshwaran G* *"Be Hunger, Stay Foolish"*

2 2

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 allowing to find an active calls by callee? Thank you, Cyrille

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 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

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 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 >>> >>> >> >

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 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.

3 2

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

05 Sep '17

3 3

Jump to page:

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