[SR-Users] Using the db_redis module for integration with usrloc

[Lucian Balaceanu]

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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 127.0.1.1}  0(23787) DEBUG: db_redis 
[redis_dbase.c:1741]: db_redis_query(): done performing query//
//{1 1 INVITE 1-23806 at 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 at 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 at 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



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20180222/297a5a89/attachment.html>