Module: kamailio
Branch: master
Commit: c9f2aa71b2e0d4a4f71b3da92f97306e86f93eea
URL:
https://github.com/kamailio/kamailio/commit/c9f2aa71b2e0d4a4f71b3da92f97306…
Author: Andreas Granig <agranig(a)sipwise.com>
Committer: Andreas Granig <agranig(a)sipwise.com>
Date: 2018-03-08T15:54:24+01:00
db_redis: Align schema with usrloc expires_type default
Since expires_type is DATETIME by default, use "time" type in
upstream schema for location table.
---
Modified: src/modules/db_redis/doc/db_redis_admin.xml
Modified: utils/kamctl/db_redis/kamailio/location
---
Diff:
https://github.com/kamailio/kamailio/commit/c9f2aa71b2e0d4a4f71b3da92f97306…
Patch:
https://github.com/kamailio/kamailio/commit/c9f2aa71b2e0d4a4f71b3da92f97306…
---
diff --git a/src/modules/db_redis/doc/db_redis_admin.xml
b/src/modules/db_redis/doc/db_redis_admin.xml
index 168bd500d4..f57fa8064e 100644
--- a/src/modules/db_redis/doc/db_redis_admin.xml
+++ b/src/modules/db_redis/doc/db_redis_admin.xml
@@ -189,4 +189,17 @@ modparam("auth_db", "db_url", DBURL_AUTH)
</programlisting>
</example>
</section>
+
+ <section>
+ <title>Module specific considerations</title>
+ <section>
+ <title>usrloc</title>
+ <para>
+ If you set "expires_type" to "1" in order to use BIGINT instead
of DATETIME,
+ make sure to update your location schema file and change the type of
"expires"
+ and "last_modified" from "time" to "int".
+ </para>
+ </section>
+ </section>
+
</chapter>
diff --git a/utils/kamctl/db_redis/kamailio/location
b/utils/kamctl/db_redis/kamailio/location
index 9ca18f2fb0..7c0ea2ab81 100644
--- a/utils/kamctl/db_redis/kamailio/location
+++ b/utils/kamctl/db_redis/kamailio/location
@@ -1,2 +1,2 @@
-id/int,ruid/string,username/string,domain/string,contact/string,received/string,path/string,expires/int,q/double,callid/string,cseq/int,last_modified/int,flags/int,cflags/int,user_agent/string,socket/string,methods/int,instance/string,reg_id/int,server_id/int,connection_id/int,keepalive/int,partition/int,
+id/int,ruid/string,username/string,domain/string,contact/string,received/string,path/string,expires/time,q/double,callid/string,cseq/int,last_modified/time,flags/int,cflags/int,user_agent/string,socket/string,methods/int,instance/string,reg_id/int,server_id/int,connection_id/int,keepalive/int,partition/int,
9