21 Feb
2018
21 Feb
'18
8:48 p.m.
Dear list..
I'm using kamailio on a live enviroment with dialogs support.. what I
made is a script that permit me to see the concurrent call (live) with
all parameters using the info saved on dialogs tables.
The problem is that if the call is not going on the first termination of
LCR but for examples in the second, the dialog is not updated with the
paramenter of the second supplier..
Is this problem only on my system or maybe i forgot to make some
configuration steps ?
Regards
Laura
22 Feb
22 Feb
11 a.m.
New subject: Using the db_redis module for integration with usrloc
Hello Andreas,
Congratulations for adding db_redis, which I find a very interesting and
useful module.
I know it is not yet in its final form, but I have tried to make a
REGISTER/INVITE save()/lookup() scenario by adding the db_redis snippets
from the README in the default Kamailio configuration (usrloc db_mode=3).
The save() succeeds, but only a "location:entry::uloc-5a8d7eb2-6bd1-1"
hash and a "location:timer::0:0" set are created (I seem to miss the
location:usrdom). Besides this, the lookup("location") fails.
I guess I have made some wrong configurations? The REGISTER/INVITE
scenario works fine for you with only the upmentioned changes to the config?
My *config* contains:
loadmodule "db_redis.so"
#!define DBURL_USRLOC "redis://127.0.0.1:6379/5"
#!define DBURL_ACC "redis://127.0.0.1:6379/6"
#!define DBURL_AUTH "redis://127.0.0.1:6379/7"
modparam("db_redis", "schema_path",
"/home/XXX/utils/kamctl/db_redis/kamailio")
modparam("db_redis", "keys",
"location=entry:ruid&usrdom:username,domain&timer:partition,keepalive")
modparam("db_redis", "keys",
"acc=entry:callid,time_hires&cid:callid")
modparam("db_redis", "keys",
"subscriber=entry:username,domain")
modparam("usrloc", "db_mode", 3)
modparam("usrloc", "use_domain", MULTIDOMAIN)
modparam("usrloc", "db_url", DBURL_USRLOC)
The lookup("location") leads to this *log*:
/1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:1683]: db_redis_query(): querying prefix (table) 'location'//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:508]: db_redis_build_query_keys(): build query keys//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:281]: db_redis_find_query_key(): checking for existence
of entry key 'ruid' in query//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:332]: db_redis_find_query_key(): key 'ruid' for type
'entry' not found, unable to use this type//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:534]: db_redis_build_query_keys(): no direct entry key
found, checking type keys//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:537]: db_redis_build_query_keys(): checking type 'usrdom'//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:281]: db_redis_find_query_key(): checking for existence
of entry key 'username' in query//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:291]: db_redis_find_query_key(): found key in entry key//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:119]: db_redis_val2str(): converting str value '33' with
len 2 to str//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:323]: db_redis_find_query_key(): entry key so far is
'location:usrdom::33'//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:281]: db_redis_find_query_key(): checking for existence
of entry key 'domain' in query//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:332]: db_redis_find_query_key(): key 'domain' for type
'usrdom' not found, unable to use this type//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:537]: db_redis_build_query_keys(): checking type 'timer'//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:281]: db_redis_find_query_key(): checking for existence
of entry key 'partition' in query//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:332]: db_redis_find_query_key(): key 'partition' for type
'timer' not found, unable to use this type//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:1726]: db_redis_query(): unable to build query keys,
falling back to full table scan//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:1741]: db_redis_query(): done performing query//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: usrloc
[udomain.c:645]: db_load_urecord(): aor 33 not found in table location//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:2145]: db_redis_free_result(): perform redis free result//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: registrar
[lookup.c:233]: lookup_helper(): '33' Not found in usrloc//
/
Any input is appreciated.
Many thanks,
Lucian Balaceanu
23 Feb
23 Feb
11:05 a.m.
New subject: Using the db_redis module for integration with usrloc
Hello,
Just a quick note to say that I debugged the issue down to having the
MULTIDOMAIN set to 0 and as such most probably the
"&usrdom:username,domain" should have been in my case just
"&usrdom:username".
Also if parsing of a field in redis comes out as having errors, just
tweak the type of value according to that field in the schema_path. I
had problems with usrloc's expires and last_modified which I changed
from "int" to "string".
Thank you,
Lucian
On 22.02.2018 12:00, Lucian Balaceanu wrote:
Hello Andreas,
Congratulations for adding db_redis, which I find a very interesting
and useful module.
I know it is not yet in its final form, but I have tried to make a
REGISTER/INVITE save()/lookup() scenario by adding the db_redis
snippets from the README in the default Kamailio configuration (usrloc
db_mode=3).
The save() succeeds, but only a "location:entry::uloc-5a8d7eb2-6bd1-1"
hash and a "location:timer::0:0" set are created (I seem to miss the
location:usrdom). Besides this, the lookup("location") fails.
I guess I have made some wrong configurations? The REGISTER/INVITE
scenario works fine for you with only the upmentioned changes to the
config?
My *config* contains:
loadmodule "db_redis.so"
#!define DBURL_USRLOC "redis://127.0.0.1:6379/5"
#!define DBURL_ACC "redis://127.0.0.1:6379/6"
#!define DBURL_AUTH "redis://127.0.0.1:6379/7"
modparam("db_redis", "schema_path",
"/home/XXX/utils/kamctl/db_redis/kamailio")
modparam("db_redis", "keys",
"location=entry:ruid&usrdom:username,domain&timer:partition,keepalive")
modparam("db_redis", "keys",
"acc=entry:callid,time_hires&cid:callid")
modparam("db_redis", "keys",
"subscriber=entry:username,domain")
modparam("usrloc", "db_mode", 3)
modparam("usrloc", "use_domain", MULTIDOMAIN)
modparam("usrloc", "db_url", DBURL_USRLOC)
The lookup("location") leads to this *log*:
/1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:1683]: db_redis_query(): querying prefix (table)
'location'//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:508]: db_redis_build_query_keys(): build query keys//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:281]: db_redis_find_query_key(): checking for existence
of entry key 'ruid' in query//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:332]: db_redis_find_query_key(): key 'ruid' for type
'entry' not found, unable to use this type//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:534]: db_redis_build_query_keys(): no direct entry key
found, checking type keys//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:537]: db_redis_build_query_keys(): checking type 'usrdom'//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:281]: db_redis_find_query_key(): checking for existence
of entry key 'username' in query//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:291]: db_redis_find_query_key(): found key in entry key//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:119]: db_redis_val2str(): converting str value '33'
with len 2 to str//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:323]: db_redis_find_query_key(): entry key so far is
'location:usrdom::33'//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:281]: db_redis_find_query_key(): checking for existence
of entry key 'domain' in query//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:332]: db_redis_find_query_key(): key 'domain' for type
'usrdom' not found, unable to use this type//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:537]: db_redis_build_query_keys(): checking type 'timer'//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:281]: db_redis_find_query_key(): checking for existence
of entry key 'partition' in query//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:332]: db_redis_find_query_key(): key 'partition' for
type 'timer' not found, unable to use this type//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:1726]: db_redis_query(): unable to build query keys,
falling back to full table scan//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:1741]: db_redis_query(): done performing query//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: usrloc
[udomain.c:645]: db_load_urecord(): aor 33 not found in table location//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:2145]: db_redis_free_result(): perform redis free result//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: registrar
[lookup.c:233]: lookup_helper(): '33' Not found in usrloc//
/
Any input is appreciated.
Many thanks,
Lucian Balaceanu
27 Feb
27 Feb
11:54 a.m.
New subject: Using the db_redis module for integration with usrloc
Hi Lucian,
Yes, it's probably worth noting in the README that for use_domain=0 the
usrdom key should be adjusted. So does it work for you now?
Eventually, I'll extend the module to ship with default key definitions
for the most common modules, however it'll take some time because it
needs an analysis of the query patterns each module performs.
Best,
Andreas
On 2018-02-23 11:05, Lucian Balaceanu wrote:
Hello,
Just a quick note to say that I debugged the issue down to having the
MULTIDOMAIN set to 0 and as such most probably the
"&usrdom:username,domain" should have been in my case just
"&usrdom:username".
Also if parsing of a field in redis comes out as having errors, just
tweak the type of value according to that field in the schema_path. I
had problems with usrloc's expires and last_modified which I changed
from "int" to "string".
Thank you,
Lucian
On 22.02.2018 12:00, Lucian Balaceanu wrote:
Hello Andreas,
Congratulations for adding db_redis, which I find a very interesting
and useful module.
I know it is not yet in its final form, but I have tried to make a
REGISTER/INVITE save()/lookup() scenario by adding the db_redis
snippets from the README in the default Kamailio configuration (usrloc
db_mode=3).
The save() succeeds, but only a "location:entry::uloc-5a8d7eb2-6bd1-1"
hash and a "location:timer::0:0" set are created (I seem to miss the
location:usrdom). Besides this, the lookup("location") fails.
I guess I have made some wrong configurations? The REGISTER/INVITE
scenario works fine for you with only the upmentioned changes to the
config?
My *config* contains:
loadmodule "db_redis.so"
#!define DBURL_USRLOC "redis://127.0.0.1:6379/5"
#!define DBURL_ACC "redis://127.0.0.1:6379/6"
#!define DBURL_AUTH "redis://127.0.0.1:6379/7"
modparam("db_redis", "schema_path",
"/home/XXX/utils/kamctl/db_redis/kamailio")
modparam("db_redis", "keys",
"location=entry:ruid&usrdom:username,domain&timer:partition,keepalive")
modparam("db_redis", "keys",
"acc=entry:callid,time_hires&cid:callid")
modparam("db_redis", "keys",
"subscriber=entry:username,domain")
modparam("usrloc", "db_mode", 3)
modparam("usrloc", "use_domain", MULTIDOMAIN)
modparam("usrloc", "db_url", DBURL_USRLOC)
The lookup("location") leads to this *log*:
/1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:1683]: db_redis_query(): querying prefix (table)
'location'//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:508]: db_redis_build_query_keys(): build query keys//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:281]: db_redis_find_query_key(): checking for existence
of entry key 'ruid' in query//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:332]: db_redis_find_query_key(): key 'ruid' for type
'entry' not found, unable to use this type//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:534]: db_redis_build_query_keys(): no direct entry key
found, checking type keys//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:537]: db_redis_build_query_keys(): checking type 'usrdom'//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:281]: db_redis_find_query_key(): checking for existence
of entry key 'username' in query//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:291]: db_redis_find_query_key(): found key in entry key//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:119]: db_redis_val2str(): converting str value '33'
with len 2 to str//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:323]: db_redis_find_query_key(): entry key so far is
'location:usrdom::33'//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:281]: db_redis_find_query_key(): checking for existence
of entry key 'domain' in query//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:332]: db_redis_find_query_key(): key 'domain' for type
'usrdom' not found, unable to use this type//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:537]: db_redis_build_query_keys(): checking type 'timer'//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:281]: db_redis_find_query_key(): checking for existence
of entry key 'partition' in query//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:332]: db_redis_find_query_key(): key 'partition' for
type 'timer' not found, unable to use this type//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:1726]: db_redis_query(): unable to build query keys,
falling back to full table scan//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:1741]: db_redis_query(): done performing query//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: usrloc
[udomain.c:645]: db_load_urecord(): aor 33 not found in table location//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: db_redis
[redis_dbase.c:2145]: db_redis_free_result(): perform redis free result//
//{1 1 INVITE 1-23806(a)127.0.1.1} 0(23787) DEBUG: registrar
[lookup.c:233]: lookup_helper(): '33' Not found in usrloc//
/
Any input is appreciated.
Many thanks,
Lucian Balaceanu
2260
days inactive
2266
days old
3 comments
3 participants
participants (3)
-
Andreas Granig -
Laura -
Lucian Balaceanu