sr-users

sr-users@lists.kamailio.org

49 participants
37556 discussions

MySQL query result pagination
by Allen Zhang 05 Jun '14

05 Jun '14

Hi, When an user does a REGISTER and has a large number of msilo messages stored, say 7k, kamailio server easily runs out of private memory when trying to allocate memory to the result set. I know I can set a max on the messages a user can store, but I'd like to support a crazy number like 7k messages. I'm trying to introduce paging to the query. So that I can process N number of results at one time. I can't find an easy way of doing this with the current MySQL driver. The db_mysql_query() function doesn't have built-in paging and with this function it's not easy to build a complex query like this: Select * from silo where ...(the matching algorithm) AND id > lower_limit AND id < higher_limit, ordered by id. Is there a way to do this? Or maybe I'm on the wrong track and there is already a solution to this problem? Regards, Allen Zhang

2 4

Re: [SR-Users] MySQL query result pagination
by Allen Zhang 05 Jun '14

05 Jun '14

I found this: SELECT column FROM table LIMIT N OFFSET offset Increment offset by index*N in the loop to fetch N records at a time. But the remaining question is how do I do this using kamailio's MySQL driver? Raw query? Allen From: Allen Zhang Sent: Thursday, 5 June 2014 12:19 p.m. To: 'sr-users(a)lists.sip-router.org' Subject: MySQL query result pagination Hi, When an user does a REGISTER and has a large number of msilo messages stored, say 7k, kamailio server easily runs out of private memory when trying to allocate memory to the result set. I know I can set a max on the messages a user can store, but I'd like to support a crazy number like 7k messages. I'm trying to introduce paging to the query. So that I can process N number of results at one time. I can't find an easy way of doing this with the current MySQL driver. The db_mysql_query() function doesn't have built-in paging and with this function it's not easy to build a complex query like this: Select * from silo where ...(the matching algorithm) AND id > lower_limit AND id < higher_limit, ordered by id. Is there a way to do this? Or maybe I'm on the wrong track and there is already a solution to this problem? Regards, Allen Zhang

1 0

CNXCC and multiple servers
by Kelvin Chua 04 Jun '14

04 Jun '14

I was just playing around with the dmq module when i thought of an idea, cnxcc being able to track users across servers. cnxcc would have to be aware of dialogs created on another server. is this something doable? Kelvin Chua

2 1

mediaproxy
by Slava Bendersky 03 Jun '14

03 Jun '14

Hello Everyone, I am trying setup mediappoxy on the gateway and log get fill up with this message. Jun 3 12:28:11 /usr/sbin/kamailio[3595]: ERROR: rtpproxy-ng [rtpproxy.c:1425]: rtpp_test(): proxy responded with invalid response Jun 3 12:28:11 /usr/sbin/kamailio[3597]: ERROR: rtpproxy-ng [rtpproxy.c:1425]: rtpp_test(): proxy responded with invalid response Jun 3 12:17:59 mediaproxy-ng[3294]: Failed to properly parse UDP command line '3394_0 d7:command4:pinge' from 127.0.0.1:59326, using fallback RE Jun 3 12:17:59 mediaproxy-ng[3294]: Failed to properly parse UDP command line '3402_1 d7:command4:pinge' from 127.0.0.1:51867, using fallback RE [root@sipgw01 kamailio]# rpm -qa | grep kam kamailio-4.1.3-2.1.x86_64 Any help thank you Slava.

3 3

cxdx_forced_peer - more info
by Daniel Ciprus 03 Jun '14

03 Jun '14

Hi, Could any of you please point me to the doc which explains more in details parameter cxdx_forced_peer ? The only place I found is http://kamailio.org/docs/modules/stable/modules/ims_icscf.html#idp190000. thanks -- Daniel Ciprus Integration engineer http://www.acision.com 9954 Mayland Dr Suite 3100 Richmond, VA 23233 USA T: +1 804 762 5601 E: daniel.ciprus(a)acision.com<mailto:daniel.ciprus@acision.com> ________________________________ This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you for understanding.

2 2

DB ERROR using presence status persistence
by Nuno Reis 03 Jun '14

03 Jun '14

Hi guys. I've setup presence management in kamailio and i'm currently persisting the presence info in a postgres DB. I'm having a recurring issue on DB key violations, here's a log error output on that: Jun 3 15:09:46 144227 ERROR: pua_dialoginfo [pua_dialoginfo.c:264]: __dialog_sendpublish(): bad reply or missing CONTACT hdr Jun 3 15:10:01 723993 ERROR: presence [presentity.c:807]: update_presentity(): No E_Tag match a.1401768964.671509.1990.6 Jun 3 15:10:06 242334 WARNING: db_postgres [km_dbase.c:235]: db_postgres_submit_query(): postgres result check failed with code 7 (PGRES_FATAL_ERROR) Jun 3 15:10:06 242370 WARNING: db_postgres [km_dbase.c:239]: db_postgres_submit_query(): postgres query command failed, connection status 0, error [ERROR: duplicate key value violates unique constraint "pua_pua_idx"#012DETAIL: Key (etag, tuple_id, call_id, from_tag)=(a.1401768964.671497.1902.6, , , ) already exists.#012] Jun 3 15:10:06 243415 WARNING: db_postgres [km_dbase.c:235]: db_postgres_submit_query(): postgres result check failed with code 7 (PGRES_FATAL_ERROR) Jun 3 15:10:06 243449 WARNING: db_postgres [km_dbase.c:239]: db_postgres_submit_query(): postgres query command failed, connection status 0, error [ERROR: duplicate key value violates unique constraint "pua_pua_idx"#012DETAIL: Key (etag, tuple_id, call_id, from_tag)=(a.1401768964.671497.1902.6, , , ) already exists.#012] Jun 3 15:10:06 244458 WARNING: db_postgres [km_dbase.c:235]: db_postgres_submit_query(): postgres result check failed with code 7 (PGRES_FATAL_ERROR) Jun 3 15:10:06 244487 WARNING: db_postgres [km_dbase.c:239]: db_postgres_submit_query(): postgres query command failed, connection status 0, error [ERROR: duplicate key value violates unique constraint "pua_pua_idx"#012DETAIL: Key (etag, tuple_id, call_id, from_tag)=(a.1401768964.671497.1902.6, , , ) already exists.#012] Jun 3 15:10:06 244504 ERROR: db_postgres [km_dbase.c:247]: db_postgres_submit_query(): 0x7f21476b1910 PQsendQuery Error: ERROR: duplicate key value violates unique constraint "pua_pua_idx"#012DETAIL: Key (etag, tuple_id, call_id, from_tag)=(a.1401768964.671497.1902.6, , , ) already exists.#012 Query: update kamailio.pua set expires=1401807715,cseq=0,etag='a.1401768964.671497.1902.6',desired_expires=1401811600,version=2 where pres_uri='sip:208@freguesiadearroios.govoice.pt' AND pres_id='DIALOG_PUBLISH.440163220-35219-52(a)BJC.BGI.B.BAI' AND flag=1024 AND event=32 Jun 3 15:10:06 244521 ERROR: <core> [db_query.c:337]: db_do_update(): error while submitting query Jun 3 15:10:06 244548 ERROR: db_postgres [km_dbase.c:537]: db_postgres_store_result(): invalid query, execution aborted Jun 3 15:10:06 244560 ERROR: db_postgres [km_dbase.c:538]: db_postgres_store_result(): driver error: PGRES_FATAL_ERROR, ERROR: duplicate key value violates unique constraint "pua_pua_idx"#012DETAIL: Key (etag, tuple_id, call_id, from_tag)=(a.1401768964.671497.1902.6, , , ) already exists.#012 Jun 3 15:10:06 244584 WARNING: db_postgres [km_dbase.c:647]: db_postgres_update(): unexpected result returned Jun 3 15:10:06 244591 ERROR: pua [pua.c:1076]: db_update(): while updating in database I've read the module documentation, but there isn't much documentation on it and i'm basically guessing and trying here. Can someone tell me what am i doing wrong or maybe what should a try to be able to persist the presence status in a postgres database. I know that i could use in memory persistence or other type of DB, but i really want to know if i can use a normal postgres DB for presence persistence and what could be used to avoid key violations. Looking forward to hear from you. Best Regards, -- *Nuno Miguel Reis* | *Unified Communication** Systems* M. +351 913907481 | nreis(a)wavecom.pt WAVECOM-Soluções Rádio, S.A. Cacia Park | Rua do Progresso, Lote 15 3800-639 AVEIRO | Portugal T. +351 309 700 225 | F. +351 234 919 191 *GPS <http://maps.google.com/maps/ms?msa=0&msid=202333747613191340808.0004b4b227a…> | www.wavecom.pt <http://www.wavecom.pt/>** <http://www.wavecom.pt/>* [image: Description: Description: WavecomSignature] <http://www.wavecom.pt/pt/wavecom/premios.php> [image: Publicity] <http://www.wavecom.pt/pt/mail_eventos.php>

1 1

ODP: cnxcc
by Andrzej Ciupek 03 Jun '14

03 Jun '14

Yes. I want prepaid subscribers be able to create only one channel to prevent frauds for simultaneous calls. Greetings Andrzej Ciupek ________________________________ Od: Carlos Ruiz Díaz<mailto:carlos.ruizdiaz@gmail.com> Wysłano: ‎2014-‎04-‎26 16:42 Do: Andrzej Ciupek<mailto:andrzej.ciupek@hotmail.com> DW: Kamailio (SER) - Users Mailing List<mailto:sr-users@lists.sip-router.org> Temat: Re: [SR-Users] cnxcc Hi Andrzej, are you trying to setup cnxcc to check both credit and maximum simultaneous calls? Regards, On Sat, Apr 26, 2014 at 9:26 AM, Andrzej Ciupek <andrzej.ciupek(a)hotmail.com>wrote: > Hello > > I’am using default config with options from an example. It looks like > event route isn’t execuded after hangup. > > Apr 26 16:26:14 kamailio /usr/local/sbin/kamailio[4611]: INFO: <script>: > 1000 has 1 call(s) > Apr 26 16:26:15 kamailio /usr/local/sbin/kamailio[4611]: INFO: <script>: > 1000 has 1 call(s) > Apr 26 16:26:16 kamailio /usr/local/sbin/kamailio[4611]: INFO: <script>: > 1000 has 1 call(s) > Apr 26 16:26:17 kamailio /usr/local/sbin/kamailio[4611]: INFO: <script>: > 1000 has 1 call(s) > Apr 26 16:26:18 kamailio /usr/local/sbin/kamailio[4611]: INFO: <script>: > 1000 has 1 call(s) > Apr 26 16:26:19 kamailio /usr/local/sbin/kamailio[4611]: INFO: <script>: > 1000 has 1 call(s) > Apr 26 16:26:20 kamailio /usr/local/sbin/kamailio[4611]: INFO: <script>: > 1000 has 1 call(s) > Apr 26 16:26:20 kamailio /usr/local/sbin/kamailio[4604]: INFO: <script>: > Setting up money based credit control > Apr 26 16:26:20 kamailio /usr/local/sbin/kamailio[4604]: INFO: <script>: > Setting up channel based credit control > Apr 26 16:26:20 kamailio /usr/local/sbin/kamailio[4604]: INFO: <script>: > CNXCC ROUTE: 1000 has 2 call(s) > > kamailio.cfg > … > … > # ----- prepaid call controll ----- > > #!define DLG_FLAG 28 > #!define CC_FLAG 29 > > loadmodule "dialog.so" > > modparam("dialog", "hash_size", 2048) > modparam("dialog", "default_timeout", 3600) > modparam("dialog", "db_mode", 0) > modparam("dialog", "dlg_flag", DLG_FLAG) > > modparam("rtimer", "timer", "name=ta;interval=1;mode=1;") > modparam("rtimer", "exec", "timer=ta;route=SHOW_CHANNEL_COUNT") > > loadmodule "cnxcc.so" > > modparam("cnxcc", "dlg_flag", CC_FLAG) > modparam("cnxcc", "credit_check_period", 1) #check every 1 second > > … > … > … > route { > … > … > if (!allow_source_address("2") and !allow_source_address("1")){ > route(CNXCC); > route(PSTN); > } > … > } > > route[CNXCC] > { > > $var(client) = "1000"; > > xlog("L_INFO", "Setting up money based credit control"); > > $var(credit) = "10"; # 10$ of credit > $var(cost_per_sec) = "1"; # 1$ per sec > $var(i_pulse) = "1"; # 1$ to establish the call > $var(f_pulse) = "1"; # 1$ per second > > # if only one call is established, that call should last 9 seconds. > > if (!cnxcc_set_max_credit("$var(client)", > "$var(credit)", > "$var(cost_per_sec)", > "$var(i_pulse)", > "$var(f_pulse)")) { > xlog("Error setting up credit control"); > return; > } > $var(count) = -1; > > if (!cnxcc_get_channel_count("$var(client)", "$var(count)")) { > xlog("Error getting customer's channel count"); > } > > xlog("L_INFO", "CNXCC ROUTE: $var(client) has $var(count) > call(s)"); > > if ($var(retcode) < -1) { > xlog("Too many channels for customer"); > sl_send_reply(403, "Forbidden"); > > if (!cnxcc_terminate_all("$var(client)")) { > xlog("Error terminating customer's calls"); > } else { > xlog("Terminating customer's call"); > } > > exit; > } > } > > route[SHOW_CHANNEL_COUNT] > { > $var(count) = @cnxcc.channels["1000"].count; > xlog("L_INFO", "1000 has $var(count) call(s)"); > } > > event_route[dialog:failed] > { > xlog("dialog failed"); > } > > event_route[cnxcc:call-shutdown] > { > xlog("L_INFO", "Shutting down channel by callcontroll"); > xlog("L_INFO", "[$ci]: call killed"); > $var(count) = $var(count)-1; > if (!cnxcc_get_channel_count("$var(client)", "$var(count)")) { > xlog("Error getting customer's channel count"); > } > xlog("L_INFO", "CNXCC ROUTE: $var(client) has $var(count) > call(s)"); > # perform some kind of notification, database update, email > sending, etc > } > > Greetings > Andrzej Ciupek > > *Od:* Carlos Ruiz Díaz <carlos.ruizdiaz(a)gmail.com> > *Wysłano:* ‎sobota‎, ‎26‎ ‎kwietnia‎ ‎2014 ‎15‎:‎19 > *Do:* Kamailio (SER) - Users Mailing List <sr-users(a)lists.sip-router.org>, > Andrzej Ciupek <andrzej.ciupek(a)hotmail.com> > > Hi, > > sorry guys, I forgot about this. I will make my own tests and post the > results. > > Andrzej, can you post the configuration file you are using? > > Regards, > Carlos > > > On Sat, Apr 26, 2014 at 4:15 AM, Kelvin Chua <kelchy(a)gmail.com> wrote: > >> No, I have not yet found the solution for this issue on my setup. >> >> Maybe Carlos can help us out >> On Apr 26, 2014 5:10 PM, "Andrzej Ciupek" <andrzej.ciupek(a)hotmail.com> >> wrote: >> >>> Hello >>> >>> Have You solved this issue ? >>> I’am using Kamailio 4.1.3 and I’am getting the same results. >>> >>> Greetings >>> Andrzej Ciupek >>> >> >> _______________________________________________ >> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list >> sr-users(a)lists.sip-router.org >> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users >> >> > > > -- > Carlos > http://caruizdiaz.com > http://ngvoice.com > +52 55 3048 3303 > -- Carlos http://caruizdiaz.com http://ngvoice.com +52 55 3048 3303

3 10

what is the difference between outbound module and stun module
by vast 03 Jun '14

03 Jun '14

Hi, what is the difference between （make FLAVOUR=kamailio cfg STUN=1 outbound module ）and （stun module）？ and the debug log has this： DEBUG: <core> [sr_module.c:707]: find_mod_export_record(): find_export_record: <bind_ob> not found INFO: rr [../outbound/api.h:54]: ob_load_api(): Failed to import bind_ob INFO: rr [rr_mod.c:159]: mod_init(): outbound module not available can you tell me about it , Thank you

1 0

sqlops
by Kelvin Chua 03 Jun '14

03 Jun '14

what is wrong with this sql query? it works outside kamailio. select s.* from (select @p1:=4088112345 p) parm , lrn.lrnx s; ERROR: sqlops [sql_api.c:435]: sql_exec_xquery(): cannot do the query Kelvin Chua

2 2

app_python not able to import from Router
by Örn Arnarson 02 Jun '14

02 Jun '14

Hello, I've tried installing kamailio both from deb and from source (4.0.4 in both cases) on Ubuntu server 14.04. In both cases, I'm having problems with importing from the Router module in python, which I presume is made available when invoked from kamailio with the python module loaded. Here's what I see when trying to start kamailio with a python script with "from Router import LM_ERR": May 28 16:34:13 vcr01 kamailio: NOTICE: <core> [sr_module.c:627]: load_module(): /usr/lib/x86_64-linux-gnu/kamailio/modules/app_python.so: exports dlflags interface is deprecated and it will not be supported in newer versions; consider using mod_register() instead May 28 16:34:13 vcr01 /usr/sbin/kamailio[19652]: INFO: rr [../outbound/api.h:49]: ob_load_api(): Failed to import bind_ob May 28 16:34:13 vcr01 /usr/sbin/kamailio[19652]: INFO: rr [rr_mod.c:159]: mod_init(): outbound module not available May 28 16:34:13 vcr01 /usr/sbin/kamailio[19652]: ERROR: app_python [python_support.c:132]: python_handle_exception(): mod_init: Unhandled exception in the Python code:#012Traceback (most recent call last):#012 File "/etc/kamailio/callrouting.py", line 2, in <module>#012 from Router import LM_ERR#012ImportError: cannot import name LM_ERR May 28 16:34:13 vcr01 /usr/sbin/kamailio[19652]: ERROR: <core> [sr_module.c:939]: init_mod(): init_mod(): Error while initializing module app_python (/usr/lib/x86_64-linux-gnu/kamailio/modules/app_python.so) I load the module so: loadmodule "app_python.so" and set the following parameters: modparam("app_python", "script_name", "/etc/kamailio/handler.py") modparam("app_python", "mod_init_function", "mod_init") What am I doing wrong? Am I missing some additional modules from kamailio? handler.py is just the sample python script provided with the package. Any pointers appreciated. Regards, Örn

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