Hi!
I have an interface which is an alias in Linux that I want Kamailio to listen to.
The interface name is eth0:p01
I've tried with
listen=udp:eth0:p01:5080
listen=eth0:p01:5080
listen=eth0:p01
Kamailio doesn't accept this syntax. Claims "syntax error" and " ip address, interface name or hostname expected".
Since this way of naming interfaces is common in Linux, I think we should support it. Or?
Is there a way - are quotation marks allowed here?
Cheers,
/O
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
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
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
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.
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.
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>
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
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
