In order to have more than one server with the same DB ``sca`` module has to have a ``server_id`` column to partition subscriptions
version bumped to ``2``
See #782
You can view, comment on, or merge this pull request online at:
https://github.com/kamailio/kamailio/pull/814
-- Commit Summary --
* lib/srdb1: sca add server_id
* utils/kamctl: refresh dbschema
* sca: use new server_id column
-- File Changes --
M lib/srdb1/schema/sca.xml (11)
M modules/sca/sca_db.c (4)
M modules/sca/sca_db.h (6)
M modules/sca/sca_subscribe.c (39)
M modules/sca/sca_subscribe.h (1)
M utils/kamctl/db_berkeley/kamailio/sca_subscriptions (4)
M utils/kamctl/db_berkeley/kamailio/version (2)
M utils/kamctl/db_sqlite/sca-create.sql (5)
M utils/kamctl/dbtext/kamailio/sca_subscriptions (2)
M utils/kamctl/dbtext/kamailio/version (2)
M utils/kamctl/mysql/sca-create.sql (5)
M utils/kamctl/oracle/sca-create.sql (5)
M utils/kamctl/postgres/sca-create.sql (5)
M utils/kamctl/xhttp_pi/pi_framework.xml (4)
M utils/kamctl/xhttp_pi/sca-mod (3)
M utils/kamctl/xhttp_pi/sca-table (1)
-- Patch Links --
https://github.com/kamailio/kamailio/pull/814.patchhttps://github.com/kamailio/kamailio/pull/814.diff
--
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/kamailio/kamailio/pull/814
Sipwise hat ON:
In order to be able to share the same DB and take care of the expired records only related to that server.
We need a module parameter to allow filter by server_id when loading values from DB
Related to #781
--
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/kamailio/kamailio/issues/782
Module: kamailio
Branch: master
Commit: fd208710a6912cc5cd0d6320b9be05b707a8178b
URL: https://github.com/kamailio/kamailio/commit/fd208710a6912cc5cd0d6320b9be05b…
Author: Victor Seva <linuxmaniac(a)torreviejawireless.org>
Committer: Victor Seva <linuxmaniac(a)torreviejawireless.org>
Date: 2016-10-05T15:27:08+02:00
lib/srdb1: sca add server_id
* bump sca_susbcriptions version to 2
See #782
---
Modified: lib/srdb1/schema/sca.xml
---
Diff: https://github.com/kamailio/kamailio/commit/fd208710a6912cc5cd0d6320b9be05b…
Patch: https://github.com/kamailio/kamailio/commit/fd208710a6912cc5cd0d6320b9be05b…
---
diff --git a/lib/srdb1/schema/sca.xml b/lib/srdb1/schema/sca.xml
index 337b315..52a2380 100644
--- a/lib/srdb1/schema/sca.xml
+++ b/lib/srdb1/schema/sca.xml
@@ -9,7 +9,7 @@
<table id="sca_susbcriptions" xmlns:db="http://docbook.org/ns/docbook">
<name>sca_subscriptions</name>
- <version>1</version>
+ <version>2</version>
<type db="mysql">&MYSQL_TABLE_TYPE;</type>
<description>
<db:para>This table is used by the sca module to store active subscriptions. At startup time, the sca module loads unexpired subscriptions into its subscription hash table. More information about the sca module can be found at: &KAMAILIO_MOD_DOC;sca.html
@@ -111,6 +111,14 @@
<description>Cseq for SUBSCRIBEs sent from subscriber</description>
</column>
+ <column id="server_id">
+ <name>server_id</name>
+ <type>int</type>
+ <size>11</size>
+ <default>0</default>
+ <description>The value of server_id from configuration file</description>
+ </column>
+
<index>
<name>sca_subscriptions_idx</name>
<colref linkend="subscriber" />
@@ -122,6 +130,7 @@
<index>
<name>sca_expires_idx</name>
+ <colref linkend="server_id" />
<colref linkend="expires" />
</index>