Module: kamailio Branch: master Commit: c9f2aa71b2e0d4a4f71b3da92f97306e86f93eea URL: https://github.com/kamailio/kamailio/commit/c9f2aa71b2e0d4a4f71b3da92f97306e...
Author: Andreas Granig agranig@sipwise.com Committer: Andreas Granig agranig@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/c9f2aa71b2e0d4a4f71b3da92f97306e... Patch: https://github.com/kamailio/kamailio/commit/c9f2aa71b2e0d4a4f71b3da92f97306e...
---
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
-
Andreas Granig