23 Feb
2018
23 Feb
'18
11:05 a.m.
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