sr-users

sr-users@lists.kamailio.org

42 participants
37518 discussions

Start a nNew thread

[--SPAM--] Low %
by Loan Offer 30 Mar '19

30 Mar '19

Apply Now!!!

1 0

Lost connection to MySQL server during query
by JR Richardson 29 Mar '19

29 Mar '19

Hey Folks, Getting some annoying logs, pretty certain these are false positives. I'm running kamailio 4.4.7 using localhost mysql 5.5.60 on debian 7.11. Pretty simple setup, have acc and collecting cdrs. Relevant kamailio.cfg: loadmodule "acc.so" loadmodule "rtimer.so" loadmodule "sqlops.so" # ----- acc params ----- modparam("acc", "db_url", DBURLRW) modparam("acc", "db_flag", 1) modparam("acc", "db_missed_flag", 2) modparam("acc", "db_extra", "src_user=$fU;src_domain=$fd;src_ip=$si;" "dst_ouser=$tU;dst_user=$rU;dst_domain=$rd;" "accountcode=$avp(s:acctcode)") modparam("rtimer", "timer", "name=cdr;interval=300;mode=1;") modparam("rtimer", "exec", "timer=cdr;route=CDRS") modparam("sqlops", "sqlcon", "cb=>mysql://rwuser:rwpass@localhost/kamailio") route[CDRS] { sql_query("cb","call kamailio_cdrs()","rb"); } Logs: ERROR: db_mysql [km_dbase.c:128]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) ERROR: <core> [db_query.c:181]: db_do_raw_query(): error while submitting query ERROR: sqlops [sql_api.c:265]: sql_do_query(): cannot do the query [call kamailio_cdrs()] CDRs are working fine, no issues with the results, just the log messages. Errors occur every 5 minutes so this is related to the rtimer cycle, mode=1 is set for new connection so there really wouldn't be a lost connection, the old connection should have been relieved on last cycle. I've seen some other post talking about this issue but could not find any resolution or work around. Any help is appreciated. Thanks. JR -- JR Richardson Engineering for the Masses Chasing the Azeotrope

3 3

log timestamp granularity
by Patrick Murphy 28 Mar '19

28 Mar '19

Hello - Is there a way I can print current timestamp in milli or microseconds in the log file? Something like: 2019-03-28 04:50:15.379 would be ideal The closest thing I could find was $TV(Sn) but it doesn't suit the purpose here since its not human readable. Thanks Pat

2 1

flags definition in kamailio.cfg + 5.2 documentation
by Joel Serrano 27 Mar '19

27 Mar '19

Hi, I saw in the Kazoo default.cfg this: ... ####### Flags ####### flags FLAG_INTERNALLY_SOURCED: 1, FLAG_ASSOCIATE_SERVER: 2, FLAG_SKIP_NAT_CORRECTION: 3, FLAG_ASSOCIATE_USER: 4, FLAG_TRUSTED_SOURCE: 5, FLAG_SESSION_PROGRESS: 6, FLAG_IS_REPLY: 7, FLAG_SIP_TRACE: 8; ... So then I went here to read about it: https://www.kamailio.org/wiki/cookbooks/5.2.x/core#flags I found out it's not documented... is this a drop-in alternative for a: #!define FLAG_NAME FLAG_BIT? Sorry, first time I see this if not I would update the docs myself... :( Thanks, Joel.

4 8

Uri's user part parameters
by Duarte Rocha 27 Mar '19

27 Mar '19

Greetings, Does Kamailio have a way of identifying the user-part parameters of an URI? I have situations where i have sip:user;parameter=yes@host. Best Regards, Duarte Rocha

2 1

Manipulating User Agent header in dispatcher OPTIONS
by Andrew White 27 Mar '19

27 Mar '19

Hi all, I’ve set the server_header variable in my primary config, and I’ve got a catch in the default reply route to modify headers where required. I’m masking this value for security reasons, and filling it with my own value for vanity reasons :). I’ve noticed that the OPTIONS packet that is send via the dispatcher module when probing mode is on contains a User-Agent field which has the full version and OS type. Unfortunately I don’t necessarily have trust of the end destination being dispatcher to, nor the packet switchers in-between. How can I catch this OPTIONS packet to manipulate the value? It doesn’t appear to go through the REQUEST route or the ONSEND route. Thanks! ________________________________ Andrew White - Director uConnected Email: andrew(a)uconnected.com.au Web: www.uConnected.com.au

2 2

accounting and db_redis
by Daniel Tryba 27 Mar '19

27 Mar '19

Under https://www.kamailio.org/docs/modules/5.2.x/modules/db_redis.html#db_redis.… there is an example for using db_redis for accounting. This doesn't appear to work (5.2.2) modparam("db_redis", "keys", "acc=entry:callid,time_hires&cid:callid") results in: db_redis [redis_dbase.c:1886]: db_redis_insert(): inserting to prefix (table) 'acc' db_redis [redis_dbase.c:382]: db_redis_build_entry_keys(): build entry keys db_redis [redis_dbase.c:295]: db_redis_find_query_key(): checking for existence of ent db_redis [redis_dbase.c:306]: db_redis_find_query_key(): found key in entry key db_redis [redis_dbase.c:133]: db_redis_val2str(): converting str value '1db9c0bc57291e db_redis [redis_dbase.c:338]: db_redis_find_query_key(): entry key so far is 'acc:entr db_redis [redis_dbase.c:295]: db_redis_find_query_key(): checking for existence of entry key 'time_hires' in query db_redis [redis_dbase.c:346]: db_redis_find_query_key(): key 'time_hires' for type 'entry' not found, unable to use this type db_redis [redis_dbase.c:405]: db_redis_build_entry_keys(): Failed to create direct entry key, no matching key definition db_redis [redis_dbase.c:1892]: db_redis_insert(): failed to build entry keys db_redis [redis_dbase.c:1976]: db_redis_insert(): failed to do the insert What does work is "time" instead of "time_hires". Since I have no idea what values are available (I guess the table names?) and time only has a 1 sec resolution, what is a correct version of time_hires?

1 2

DBText does not exists!
by Andrew White 27 Mar '19

27 Mar '19

Hi all, I’m currently playing with the UAC module to hand off remote registrations with trunks to Kamailio. I want to keep Kamailio’s external connections low, so I’m planning to use db_text to load the UAC info, and populate the flat file via other methods. When attempting to load my UAC DB via db_text however, I get the following: Mar 26 04:59:30 ip-10-0-0-2 /usr/local/sbin/kamailio[31904]: ERROR: db_text [dbt_lib.c:143]: dbt_cache_get_db(): database [/etc/kamailio/uac.db] does not exists! Mar 26 04:59:30 ip-10-0-0-2 /usr/local/sbin/kamailio[31902]: INFO: jsonrpcs [jsonrpcs_sock.c:443]: jsonrpc_dgram_process(): a new child 0/31902 Mar 26 04:59:30 ip-10-0-0-2 /usr/local/sbin/kamailio[31904]: ERROR: db_text [dbt_base.c:102]: dbt_init(): cannot get the link to database Mar 26 04:59:30 ip-10-0-0-2 /usr/local/sbin/kamailio[31904]: ERROR: uac [uac_reg.c:1318]: uac_reg_load_db(): failed to connect to the database When running using WITH_DEBUG flag, it does not appear to attempt on normal start. A kamcmd uac.reg_reload yields: Mar 26 05:07:52 ip-10-0-0-2 kamailio: 22(32177) DEBUG: ctl [io_listener.c:442]: handle_new_connect(): handle_stream read: new connection (1) on /var/run/kamailio//kamailio_ctl Mar 26 05:07:52 ip-10-0-0-2 kamailio: 22(32177) DEBUG: <core> [core/sr_module.c:632]: find_mod_export_record(): found export of <db_bind_api> in module db_text [/usr/local/lib64/kamailio/modules/db_text.so] Mar 26 05:07:52 ip-10-0-0-2 kamailio: 22(32177) DEBUG: <core> [db.c:210]: db_bind_mod(): using db bind api for db_text Mar 26 05:07:52 ip-10-0-0-2 kamailio: 22(32177) DEBUG: db_text [dbt_base.c:55]: dbt_init(): initializing for db url: [text:///etc/kamailio/uac.db] Mar 26 05:07:52 ip-10-0-0-2 kamailio: 22(32177) DEBUG: db_text [dbt_lib.c:125]: dbt_cache_get_db(): looking for db /etc/kamailio/uac.db! Mar 26 05:07:52 ip-10-0-0-2 kamailio: 22(32177) ERROR: db_text [dbt_lib.c:143]: dbt_cache_get_db(): database [/etc/kamailio/uac.db] does not exists! Mar 26 05:07:52 ip-10-0-0-2 kamailio: 22(32177) ERROR: db_text [dbt_base.c:102]: dbt_init(): cannot get the link to database Mar 26 05:07:52 ip-10-0-0-2 kamailio: 22(32177) ERROR: uac [uac_reg.c:1318]: uac_reg_load_db(): failed to connect to the database Mar 26 05:07:52 ip-10-0-0-2 kamailio: 22(32177) DEBUG: ctl [io_listener.c:495]: handle_stream_read(): handle_stream read: eof on /var/run/kamailio//kamailio_ctl The file of course does exist, and has fine permissions (Kamailio runs as root in this case): -rw-r--r-- 1 root root 169 Mar 26 04:49 /etc/kamailio/uac.db Contents of file: l_uuid(str) l_username(str) l_domain(str) r_username(str) r_domain(str) realm(str) auth_username(str) auth_password(str) auth_proxy(str) expires(int) flags(int) reg_delay(int) 123:test:test.com:test:test.com:test.com:user:pass:10.0.0.100:600:: (At this stage I just want to see the reg packet in Wireshark). 1) Is this the correct method to do UAC? Load credentials, then Kamailio will handle the registration and renewal? I’ve struggled a bit to understand the documentation, hence the testing 2) Why is my db_text failing to load the file? Thanks! ________________________________ Andrew White - Director uConnected Email: andrew(a)uconnected.com.au Web: www.uConnected.com.au

3 6

Extract URI from Headers
by Duarte Rocha 27 Mar '19

27 Mar '19

Greetings, In my SBC i usually have to do operations on P-Asserted-Identity and Contact header. For those operations i usually have to get the user part, domain, etc. For that i'm using the URI Transformations provided by Kamailio. However, in order to do this i have to trim the header value by hand in order to remove brackets, display infos, etc. Does Kamailio have a method for extracting the URI from those kinds of headers? Best Regards, Duarte Rocha

3 3

Disable Dispatcher GW from DB
by Patrick Wakano 26 Mar '19

26 Mar '19

Hello list, Hope you are all doing well! I am looking for a way to disable a Dispatcher GW from the DB. I know I can disable it using the "kamcmd dispatcher.set_state d ..."command, but in case I do a reload or restart after that, the disabled GW will be back as active. Of course I could also delete the GW from DB, but for CDR purposes I want to keep the entry but mark as permanently disabled, so Kamailio won't try to use it nor ping it anymore. Does anyone how can I do that in the DB? I am looking for the exact same behavior the "kamcmd dispatcher.set_state d" does but from some change in the DB. Thanks, Kind regards, Patrick Wakano

3 5

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