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

[Lucian Balaceanu]

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 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/20180223/46b53b53/attachment.html>