<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Hi Joan,<div class=""><br class=""></div><div class="">My guess is you’re providing a string value from the phones/terminals, rather than an integer value.</div><div class=""><br class=""></div><div class=""><div style="caret-color: rgb(7, 55, 99); color: rgb(7, 55, 99);" class=""> 9(39) ERROR: <core> [db_ut.c:92]: db_str2int(): <b class="">Unexpected characters: [-03-29 18:16:36]</b></div><div style="caret-color: rgb(7, 55, 99); color: rgb(7, 55, 99);" class=""> 9(39) ERROR: <core> [db_val.c:76]: db_str2val(): error while converting <b class="">integer value from string</b></div><div style="caret-color: rgb(7, 55, 99); color: rgb(7, 55, 99);" class=""> 9(39) ERROR: db_redis [redis_dbase.c:1062]: db_redis_convert_row(): Failed to convert redis column 'expires' to db value</div><div class="">
<div dir="auto" style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div dir="auto" style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><br class=""></div><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;">I’m guessing the string given is “2019-03-29 18:16:38”. I don’t know the location DB well in Kamailio, but I’d guess this is meant to be an epoch timestamp.</div><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><br class=""></div><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;">I’ve not really ever used usrloc, but having a look, I’d say maybe you need to set the “expires_type” value in the module? <a href="https://www.kamailio.org/docs/modules/devel/modules/usrloc.html#usrloc.p.expires_type" class="">https://www.kamailio.org/docs/modules/devel/modules/usrloc.html#usrloc.p.expires_type</a></div><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><br class=""></div><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;">Someone who knows USRLOC could probably confirm this!<br class=""><br class="">Best of luck fellow Redis user!<br class=""><br class="">________________________________<br class=""><br class="">Andrew White - Director<br class="">uConnected<br class=""><a href="mailto:andrew@uconnected.com.au" class="">Email: andrew@uconnected.com.au</a><br class="">Web: www.uConnected.com.au<br class=""></div></div></div>
</div>
<div><br class=""><blockquote type="cite" class=""><div class="">On 30 Mar 2019, at 5:17 am, Joan Salvatella <<a href="mailto:juansalvatella@gmail.com" class="">juansalvatella@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div class="gmail_default"><div class="gmail_default" style="color:rgb(7,55,99)">Hello,</div><div class="gmail_default" style="color:rgb(7,55,99)"><br class=""></div><div class="gmail_default" style="color:rgb(7,55,99)">We are working on a project that's using two active-active <span class="gmail-m_6411249386169963595gmail-il">Kamailio</span> 5.2 instances that redirect traffic to several Asterisk 15.4 instances. Kamailio is acting as a registrar and should store the location information of the registered terminals. The backend database is db_redis.</div><div class="gmail_default" style="color:rgb(7,55,99)"><br class=""></div><div class="gmail_default" style="color:rgb(7,55,99)">Phone terminals get registered and the information gets looked up from the subscriber schema in redis (That's cool) but we are having problems with the locations. This is the related code:</div><div class="gmail_default" style="color:rgb(7,55,99)"><br class=""></div><div class="gmail_default"><font color="#073763" class="">modparam("db_redis", "keys", "location=entry:ruid&usrdom:username,domain&timer:partition,keepalive")</font><br class=""></div><div class="gmail_default" style="color:rgb(7,55,99)"><br class=""></div><div class="gmail_default"><div class="gmail_default"><div class="gmail_default" style="color:rgb(7,55,99)">if(ds_is_from_list("1", "2", "<a href="sip:$fd:5080" class="">sip:$fd:5080</a>")) {</div><div class="gmail_default" style="color:rgb(7,55,99)"> record_route();</div><div class="gmail_default" style="color:rgb(7,55,99)"> route(INVITE_ASTERISK);</div><div class="gmail_default" style="color:rgb(7,55,99)"> exit;</div><div class="gmail_default" style="color:rgb(7,55,99)">}</div><div class="gmail_default" style="color:rgb(7,55,99)"><br class=""></div><div class="gmail_default"><div class="gmail_default" style="color:rgb(7,55,99)">route[INVITE_ASTERISK] {</div><div class="gmail_default" style="color:rgb(7,55,99)"> xlog("L_INFO", "[R-INVITE-RESOLVER:$ci] Entering ASTERISK INVITE resolver\n");</div><div class="gmail_default" style="color:rgb(7,55,99)"> if (!lookup("location")) {</div><div class="gmail_default" style="color:rgb(7,55,99)"><span style="white-space:pre" class=""> </span>sl_send_reply("404", "User Not Found");</div><div class="gmail_default" style="color:rgb(7,55,99)"><span style="white-space:pre" class=""> </span>return;</div><div class="gmail_default" style="color:rgb(7,55,99)"><span style="white-space:pre" class=""> </span>}</div><div class="gmail_default" style="color:rgb(7,55,99)"> route(INVITE_POSTROUTE);</div><div class="gmail_default" style="color:rgb(7,55,99)">}</div><div style="color:rgb(7,55,99)" class=""><br class=""></div><div class=""><div class=""><font color="#073763" class="">route[INVITE_POSTROUTE] {</font></div><div class=""><font color="#073763" class=""> rtpproxy_manage();</font></div><div class=""><font color="#073763" class=""> t_on_reply("MAIN_REPLY");</font></div><div class=""><font color="#073763" class=""><br class=""></font></div><div class=""><font color="#073763" class=""> if(!t_relay()) </font></div><div class=""><font color="#073763" class=""><span style="white-space:pre" class=""> </span>sl_reply_error();</font></div><div class=""><font color="#073763" class="">}</font></div></div><div style="color:rgb(7,55,99)" class=""><br class=""></div><div style="color:rgb(7,55,99)" class="">When looking up the location schema this errors appear:</div><div style="color:rgb(7,55,99)" class=""><br class=""></div><div style="color:rgb(7,55,99)" class=""><div class="">9(39) WARNING: db_redis [redis_dbase.c:1098]: db_redis_perform_query(): performing full table scan on table 'location' while performing query</div><div class=""> 9(39) WARNING: db_redis [redis_dbase.c:1101]: db_redis_perform_query(): scan key 0 is 'expires'</div><div class=""> 9(39) WARNING: db_redis [redis_dbase.c:1101]: db_redis_perform_query(): scan key 1 is 'expires'</div><div class=""> 9(39) ERROR: <core> [db_ut.c:92]: db_str2int(): Unexpected characters: [-03-29 18:16:36]</div><div class=""> 9(39) ERROR: <core> [db_val.c:76]: db_str2val(): error while converting integer value from string</div><div class=""> 9(39) ERROR: db_redis [redis_dbase.c:1062]: db_redis_convert_row(): Failed to convert redis column 'expires' to db value</div><div class=""> 9(39) ERROR: db_redis [redis_dbase.c:1231]: db_redis_perform_query(): Failed to convert redis reply for row</div><div class=""> 9(39) ERROR: db_redis [redis_dbase.c:1243]: db_redis_perform_query(): failed to perform the query</div><div class=""> 9(39) ERROR: db_redis [redis_dbase.c:1829]: db_redis_query(): failed to do the query</div><div class=""> 9(39) ERROR: usrloc [udomain.c:981]: udomain_contact_expired_cb(): db_query failed</div></div></div></div></div><div class="gmail_default" style="color:rgb(7,55,99)"><br class=""></div><div class="gmail_default" style="color:rgb(7,55,99)">Any hints?</div><div class="gmail_default" style="color:rgb(7,55,99)"><br class=""></div><div class="gmail_default" style="color:rgb(7,55,99)">Thanks and regards,</div></div></div></div></div></div></div></div></div>
_______________________________________________<br class="">Kamailio (SER) - Users Mailing List<br class=""><a href="mailto:sr-users@lists.kamailio.org" class="">sr-users@lists.kamailio.org</a><br class="">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users<br class=""></div></blockquote></div><br class=""></div></body></html>