sr-dev March 2016

sr-dev@lists.kamailio.org

27 participants
387 discussions

git:master:57bcad1b: ndb_redis: use pkg-config for compile flags

by Daniel-Constantin Mierla

Module: kamailio Branch: master Commit: 57bcad1b336e7aae5c0933a83ac4ab16f6893896 URL: https://github.com/kamailio/kamailio/commit/57bcad1b336e7aae5c0933a83ac4ab1… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: 2016-03-26T08:44:16+01:00 ndb_redis: use pkg-config for compile flags --- Modified: modules/ndb_redis/Makefile --- Diff: https://github.com/kamailio/kamailio/commit/57bcad1b336e7aae5c0933a83ac4ab1… Patch: https://github.com/kamailio/kamailio/commit/57bcad1b336e7aae5c0933a83ac4ab1… --- diff --git a/modules/ndb_redis/Makefile b/modules/ndb_redis/Makefile index 6e2d86b..524647d 100644 --- a/modules/ndb_redis/Makefile +++ b/modules/ndb_redis/Makefile @@ -5,8 +5,25 @@ include ../../Makefile.defs auto_gen= NAME=ndb_redis.so -DEFS += -I/usr/local/include -LIBS = -lhiredis +ifeq ($(CROSS_COMPILE),) +HIREDIS_BUILDER = $(shell \ + if pkg-config --exists libcre; then \ + echo 'pkg-config hiredis'; \ + else \ + which pcre-config; \ + fi) +endif + +ifeq ($(HIREDIS_BUILDER),) + HIREDISDEFS=-I$(LOCALBASE)/include + HIREDISLIBS=-L$(LOCALBASE)/lib -lhiredis +else + HIREDISDEFS = $(shell $(HIREDIS_BUILDER) --cflags) + HIREDISLIBS = $(shell $(HIREDIS_BUILDER) --libs) +endif + +DEFS+=$(HIREDISDEFS) +LIBS=$(HIREDISLIBS) DEFS+=-DKAMAILIO_MOD_INTERFACE

8 years, 9 months

git:master:3ec7c114: dispatcher: refreshed the readme content

by Daniel-Constantin Mierla

Module: kamailio Branch: master Commit: 3ec7c1142738f1829581534e74574851e0183c21 URL: https://github.com/kamailio/kamailio/commit/3ec7c1142738f1829581534e7457485… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: 2016-03-24T14:09:13+01:00 dispatcher: refreshed the readme content --- Modified: modules/dispatcher/README --- Diff: https://github.com/kamailio/kamailio/commit/3ec7c1142738f1829581534e7457485… Patch: https://github.com/kamailio/kamailio/commit/3ec7c1142738f1829581534e7457485…

8 years, 9 months

git:master:e93bb3db: dispatcher: docs for ds_select()

by Daniel-Constantin Mierla

Module: kamailio Branch: master Commit: e93bb3dba955cb6fe1526bb1737ce0f227f4a8c7 URL: https://github.com/kamailio/kamailio/commit/e93bb3dba955cb6fe1526bb1737ce0f… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: 2016-03-24T14:08:32+01:00 dispatcher: docs for ds_select() --- Modified: modules/dispatcher/doc/dispatcher_admin.xml --- Diff: https://github.com/kamailio/kamailio/commit/e93bb3dba955cb6fe1526bb1737ce0f… Patch: https://github.com/kamailio/kamailio/commit/e93bb3dba955cb6fe1526bb1737ce0f… --- diff --git a/modules/dispatcher/doc/dispatcher_admin.xml b/modules/dispatcher/doc/dispatcher_admin.xml index c79ecaa..8368bb7 100644 --- a/modules/dispatcher/doc/dispatcher_admin.xml +++ b/modules/dispatcher/doc/dispatcher_admin.xml @@ -1050,19 +1050,64 @@ ds_select_dst("1", "4", "3"); <para> If the bit 2 in 'flags' is set, the rest of the addresses from the destination set is stored in AVP list (limited with an optional 'limit' - parameter). You can use 'ds_next_domain()' to use next address to + parameter). You can use 'ds_next_domain()' to use next address to achieve serial forking to all possible destinations. </para> <para> This function can be used from REQUEST_ROUTE, FAILURE_ROUTE. </para> - </section> - <section> - <title> - <function moreinfo="none">ds_next_dst()</function> - </title> - <para> - Takes the next destination address from the AVPs with id 'dst_avp_id' + <example> + <title><function>ds_select_domain</function> usage</title> + <programlisting format="linespecific"> +... +$var(a) = 4; +if(ds_select_domain("1", "$var(a)")) { + t_relay(); + exit; +} +... +</programlisting> + </example> + </section> + <section id="dispatcher.f.ds_select"> + <title> + <function moreinfo="none">ds_select(set, alg [, limit])</function> + </title> + <para> + The method selects a destination from addresses set and adds it + in the AVPs specified for this module. It is not updating R-URI + nor the destination URI. The parameters have same + meaning as for ds_select_dst(). + </para> + <para> + If the bit 2 in 'flags' is set, the rest of the addresses from the + destination set is stored in AVP list (limited with an optional 'limit' + parameter). You can execute 'ds_next_domain()' or 'ds_next_dst()' to use + next address to achieve serial forking to all possible destinations. + </para> + <para> + This function can be used from ANY_ROUTE. + </para> + <example> + <title><function>ds_select</function> usage</title> + <programlisting format="linespecific"> +... +$var(a) = 4; +if(ds_select("1", "$var(a)")) { + ds_next_domain(); + t_relay(); + exit; +} +... +</programlisting> + </example> + </section> + <section> + <title> + <function moreinfo="none">ds_next_dst()</function> + </title> + <para> + Takes the next destination address from the AVPs with id 'dst_avp_id' and sets the dst_uri (outbound proxy address). </para> <para>

8 years, 9 months

git:master:53a55967: dispatcher: new function ds_select(setid, alg, [limit])

by Daniel-Constantin Mierla

Module: kamailio Branch: master Commit: 53a55967e98d6152acedb32547cbc1028e30d684 URL: https://github.com/kamailio/kamailio/commit/53a55967e98d6152acedb32547cbc10… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: 2016-03-24T10:00:04+01:00 dispatcher: new function ds_select(setid, alg, [limit]) - puts the addresses from destination set in the internal avps lists, without updating dst-uri or r-uri --- Modified: modules/dispatcher/dispatch.c Modified: modules/dispatcher/dispatcher.c --- Diff: https://github.com/kamailio/kamailio/commit/53a55967e98d6152acedb32547cbc10… Patch: https://github.com/kamailio/kamailio/commit/53a55967e98d6152acedb32547cbc10…

8 years, 9 months

git:master:1d401e0a: dispatcher: coherent indentation and whitespacing

by Daniel-Constantin Mierla

Module: kamailio Branch: master Commit: 1d401e0a9b4c3010c32b0084ec6a218fc46e4f78 URL: https://github.com/kamailio/kamailio/commit/1d401e0a9b4c3010c32b0084ec6a218… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: 2016-03-24T09:21:00+01:00 dispatcher: coherent indentation and whitespacing --- Modified: modules/dispatcher/dispatch.c Modified: modules/dispatcher/dispatcher.c --- Diff: https://github.com/kamailio/kamailio/commit/1d401e0a9b4c3010c32b0084ec6a218… Patch: https://github.com/kamailio/kamailio/commit/1d401e0a9b4c3010c32b0084ec6a218… --- diff --git a/modules/dispatcher/dispatch.c b/modules/dispatcher/dispatch.c index 6921aae..60c9121 100644 --- a/modules/dispatcher/dispatch.c +++ b/modules/dispatcher/dispatch.c @@ -305,7 +305,7 @@ int add_dest2list(int id, str uri, int flags, int priority, str *attrs, /* skip IPv6 references if IPv6 lookups are disabled */ if (default_core_cfg.dns_try_ipv6 == 0 && - puri.host.s[0] == '[' && puri.host.s[puri.host.len-1] == ']') { + puri.host.s[0] == '[' && puri.host.s[puri.host.len-1] == ']') { LM_DBG("skipping IPv6 record %.*s\n", puri.host.len, puri.host.s); return 0; } @@ -496,7 +496,7 @@ int dp_init_relative_weights(ds_set_t *dset) if(dset==NULL || dset->dlist==NULL) return -1; - + int rw_sum = 0; /* find the sum of relative weights*/ for(j=0; j<dset->nr; j++){ @@ -514,9 +514,9 @@ int dp_init_relative_weights(ds_set_t *dset) for(j=0; j<dset->nr; j++) { if( ds_skip_dst(dset->dlist[j].flags ) ) - continue; + continue; - int current_slice = dset->dlist[j].attrs.rweight*100/rw_sum; //truncate here; + int current_slice = dset->dlist[j].attrs.rweight*100/rw_sum; //truncate here; for(k=0; k<current_slice; k++) { dset->rwlist[t] = (unsigned int)j; @@ -525,7 +525,7 @@ int dp_init_relative_weights(ds_set_t *dset) } /* if the array was not completely filled (i.e., the sum of rweights is * less than 100 due to truncated), then use last address to fill the rest */ - unsigned int last_insert = t>0? dset->rwlist[t-1] : (unsigned int)(dset->nr-1); + unsigned int last_insert = t>0? dset->rwlist[t-1] : (unsigned int)(dset->nr-1); for(j=t; j<100; j++) dset->rwlist[j] = last_insert; @@ -1765,7 +1765,7 @@ static inline int ds_update_dst(struct sip_msg *msg, str *uri, return -1; } /* dst_uri changes, so it makes sense to re-use the current uri for - forking */ + * forking */ ruri_mark_new(); /* re-use uri for serial forking */ break; } @@ -2487,7 +2487,7 @@ static void ds_run_route(sip_msg_t *msg, str *uri, char *route) /** - recalculate relative states if some destination state was changed + * recalculate relative states if some destination state was changed */ int ds_reinit_rweight_on_state_change(int old_state, int new_state, ds_set_t *dset) { @@ -2495,7 +2495,7 @@ int ds_reinit_rweight_on_state_change(int old_state, int new_state, ds_set_t *ds LM_ERR("destination set is null\n"); return -1; } - if ( (!ds_skip_dst(old_state) && ds_skip_dst(new_state)) || + if ( (!ds_skip_dst(old_state) && ds_skip_dst(new_state)) || (ds_skip_dst(old_state) && !ds_skip_dst(new_state)) ) { dp_init_relative_weights(dset); @@ -2804,8 +2804,8 @@ static void ds_options_callback( struct cell *t, int type, { /* Set the according entry back to "Active" */ state = 0; - if (ds_probing_mode==DS_PROBE_ALL || - ((ds_probing_mode==DS_PROBE_ONLYFLAGGED) + if (ds_probing_mode==DS_PROBE_ALL || + ((ds_probing_mode==DS_PROBE_ONLYFLAGGED) && (ds_get_state(group, &uri) & DS_PROBING_DST))) state |= DS_PROBING_DST; diff --git a/modules/dispatcher/dispatcher.c b/modules/dispatcher/dispatcher.c index 51d1955..2a0ddbc 100644 --- a/modules/dispatcher/dispatcher.c +++ b/modules/dispatcher/dispatcher.c @@ -96,9 +96,9 @@ unsigned short sock_avp_type; pv_elem_t * hash_param_model = NULL; int probing_threshold = 1; /* number of failed requests, before a destination - is taken into probing */ + * is taken into probing */ int inactive_threshold = 1; /* number of replied requests, before a destination - is taken into back in active state */ + * is taken into back in active state */ str ds_ping_method = str_init("OPTIONS"); str ds_ping_from = str_init("sip:dispatcher@localhost"); static int ds_ping_interval = 0;

8 years, 9 months

git:4.4:e8f230e7: kamctl: refreshed definition of location table

by Daniel-Constantin Mierla

Module: kamailio Branch: 4.4 Commit: e8f230e7989eb0aef2510f52738e8718863b8567 URL: https://github.com/kamailio/kamailio/commit/e8f230e7989eb0aef2510f52738e871… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: 2016-03-23T16:09:28+01:00 kamctl: refreshed definition of location table (cherry picked from commit 2ddf88df7deeebf2966344031eb905811b8e86cb) --- Modified: utils/kamctl/db_sqlite/usrloc-create.sql Modified: utils/kamctl/mysql/usrloc-create.sql Modified: utils/kamctl/oracle/usrloc-create.sql Modified: utils/kamctl/postgres/usrloc-create.sql --- Diff: https://github.com/kamailio/kamailio/commit/e8f230e7989eb0aef2510f52738e871… Patch: https://github.com/kamailio/kamailio/commit/e8f230e7989eb0aef2510f52738e871… --- diff --git a/utils/kamctl/db_sqlite/usrloc-create.sql b/utils/kamctl/db_sqlite/usrloc-create.sql index 50f6894..6cbfbdd 100644 --- a/utils/kamctl/db_sqlite/usrloc-create.sql +++ b/utils/kamctl/db_sqlite/usrloc-create.sql @@ -22,12 +22,12 @@ CREATE TABLE location ( connection_id INTEGER DEFAULT 0 NOT NULL, keepalive INTEGER DEFAULT 0 NOT NULL, partition INTEGER DEFAULT 0 NOT NULL, - CONSTRAINT location_ruid_idx UNIQUE (ruid), - CONSTRAINT location_connection_idx UNIQUE (server_id, connection_id) + CONSTRAINT location_ruid_idx UNIQUE (ruid) ); CREATE INDEX location_account_contact_idx ON location (username, domain, contact); CREATE INDEX location_expires_idx ON location (expires); +CREATE INDEX location_connection_idx ON location (server_id, connection_id); INSERT INTO version (table_name, table_version) values ('location','8'); diff --git a/utils/kamctl/mysql/usrloc-create.sql b/utils/kamctl/mysql/usrloc-create.sql index f7edfbb..a300661 100644 --- a/utils/kamctl/mysql/usrloc-create.sql +++ b/utils/kamctl/mysql/usrloc-create.sql @@ -22,12 +22,12 @@ CREATE TABLE `location` ( `connection_id` INT(11) DEFAULT 0 NOT NULL, `keepalive` INT(11) DEFAULT 0 NOT NULL, `partition` INT(11) DEFAULT 0 NOT NULL, - CONSTRAINT ruid_idx UNIQUE (`ruid`), - CONSTRAINT connection_idx UNIQUE (`server_id`, `connection_id`) + CONSTRAINT ruid_idx UNIQUE (`ruid`) ); CREATE INDEX account_contact_idx ON location (`username`, `domain`, `contact`); CREATE INDEX expires_idx ON location (`expires`); +CREATE INDEX connection_idx ON location (`server_id`, `connection_id`); INSERT INTO version (table_name, table_version) values ('location','8'); diff --git a/utils/kamctl/oracle/usrloc-create.sql b/utils/kamctl/oracle/usrloc-create.sql index 8ab1d98..7923229 100644 --- a/utils/kamctl/oracle/usrloc-create.sql +++ b/utils/kamctl/oracle/usrloc-create.sql @@ -22,8 +22,7 @@ CREATE TABLE location ( connection_id NUMBER(10) DEFAULT 0 NOT NULL, keepalive NUMBER(10) DEFAULT 0 NOT NULL, partition NUMBER(10) DEFAULT 0 NOT NULL, - CONSTRAINT location_ruid_idx UNIQUE (ruid), - CONSTRAINT location_connection_idx UNIQUE (server_id, connection_id) + CONSTRAINT location_ruid_idx UNIQUE (ruid) ); CREATE OR REPLACE TRIGGER location_tr @@ -36,6 +35,7 @@ BEGIN map2users('location'); END; / CREATE INDEX location_account_contact_idx ON location (username, domain, contact); CREATE INDEX location_expires_idx ON location (expires); +CREATE INDEX location_connection_idx ON location (server_id, connection_id); INSERT INTO version (table_name, table_version) values ('location','8'); diff --git a/utils/kamctl/postgres/usrloc-create.sql b/utils/kamctl/postgres/usrloc-create.sql index a8102e3..9a56326 100644 --- a/utils/kamctl/postgres/usrloc-create.sql +++ b/utils/kamctl/postgres/usrloc-create.sql @@ -22,12 +22,12 @@ CREATE TABLE location ( connection_id INTEGER DEFAULT 0 NOT NULL, keepalive INTEGER DEFAULT 0 NOT NULL, partition INTEGER DEFAULT 0 NOT NULL, - CONSTRAINT location_ruid_idx UNIQUE (ruid), - CONSTRAINT location_connection_idx UNIQUE (server_id, connection_id) + CONSTRAINT location_ruid_idx UNIQUE (ruid) ); CREATE INDEX location_account_contact_idx ON location (username, domain, contact); CREATE INDEX location_expires_idx ON location (expires); +CREATE INDEX location_connection_idx ON location (server_id, connection_id); INSERT INTO version (table_name, table_version) values ('location','8');

8 years, 9 months

git:master:2ddf88df: kamctl: refreshed definition of location table

by Daniel-Constantin Mierla

Module: kamailio Branch: master Commit: 2ddf88df7deeebf2966344031eb905811b8e86cb URL: https://github.com/kamailio/kamailio/commit/2ddf88df7deeebf2966344031eb9058… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: 2016-03-23T16:08:48+01:00 kamctl: refreshed definition of location table --- Modified: utils/kamctl/db_sqlite/usrloc-create.sql Modified: utils/kamctl/mysql/usrloc-create.sql Modified: utils/kamctl/oracle/usrloc-create.sql Modified: utils/kamctl/postgres/usrloc-create.sql --- Diff: https://github.com/kamailio/kamailio/commit/2ddf88df7deeebf2966344031eb9058… Patch: https://github.com/kamailio/kamailio/commit/2ddf88df7deeebf2966344031eb9058… --- diff --git a/utils/kamctl/db_sqlite/usrloc-create.sql b/utils/kamctl/db_sqlite/usrloc-create.sql index 50f6894..6cbfbdd 100644 --- a/utils/kamctl/db_sqlite/usrloc-create.sql +++ b/utils/kamctl/db_sqlite/usrloc-create.sql @@ -22,12 +22,12 @@ CREATE TABLE location ( connection_id INTEGER DEFAULT 0 NOT NULL, keepalive INTEGER DEFAULT 0 NOT NULL, partition INTEGER DEFAULT 0 NOT NULL, - CONSTRAINT location_ruid_idx UNIQUE (ruid), - CONSTRAINT location_connection_idx UNIQUE (server_id, connection_id) + CONSTRAINT location_ruid_idx UNIQUE (ruid) ); CREATE INDEX location_account_contact_idx ON location (username, domain, contact); CREATE INDEX location_expires_idx ON location (expires); +CREATE INDEX location_connection_idx ON location (server_id, connection_id); INSERT INTO version (table_name, table_version) values ('location','8'); diff --git a/utils/kamctl/mysql/usrloc-create.sql b/utils/kamctl/mysql/usrloc-create.sql index f7edfbb..a300661 100644 --- a/utils/kamctl/mysql/usrloc-create.sql +++ b/utils/kamctl/mysql/usrloc-create.sql @@ -22,12 +22,12 @@ CREATE TABLE `location` ( `connection_id` INT(11) DEFAULT 0 NOT NULL, `keepalive` INT(11) DEFAULT 0 NOT NULL, `partition` INT(11) DEFAULT 0 NOT NULL, - CONSTRAINT ruid_idx UNIQUE (`ruid`), - CONSTRAINT connection_idx UNIQUE (`server_id`, `connection_id`) + CONSTRAINT ruid_idx UNIQUE (`ruid`) ); CREATE INDEX account_contact_idx ON location (`username`, `domain`, `contact`); CREATE INDEX expires_idx ON location (`expires`); +CREATE INDEX connection_idx ON location (`server_id`, `connection_id`); INSERT INTO version (table_name, table_version) values ('location','8'); diff --git a/utils/kamctl/oracle/usrloc-create.sql b/utils/kamctl/oracle/usrloc-create.sql index 8ab1d98..7923229 100644 --- a/utils/kamctl/oracle/usrloc-create.sql +++ b/utils/kamctl/oracle/usrloc-create.sql @@ -22,8 +22,7 @@ CREATE TABLE location ( connection_id NUMBER(10) DEFAULT 0 NOT NULL, keepalive NUMBER(10) DEFAULT 0 NOT NULL, partition NUMBER(10) DEFAULT 0 NOT NULL, - CONSTRAINT location_ruid_idx UNIQUE (ruid), - CONSTRAINT location_connection_idx UNIQUE (server_id, connection_id) + CONSTRAINT location_ruid_idx UNIQUE (ruid) ); CREATE OR REPLACE TRIGGER location_tr @@ -36,6 +35,7 @@ BEGIN map2users('location'); END; / CREATE INDEX location_account_contact_idx ON location (username, domain, contact); CREATE INDEX location_expires_idx ON location (expires); +CREATE INDEX location_connection_idx ON location (server_id, connection_id); INSERT INTO version (table_name, table_version) values ('location','8'); diff --git a/utils/kamctl/postgres/usrloc-create.sql b/utils/kamctl/postgres/usrloc-create.sql index a8102e3..9a56326 100644 --- a/utils/kamctl/postgres/usrloc-create.sql +++ b/utils/kamctl/postgres/usrloc-create.sql @@ -22,12 +22,12 @@ CREATE TABLE location ( connection_id INTEGER DEFAULT 0 NOT NULL, keepalive INTEGER DEFAULT 0 NOT NULL, partition INTEGER DEFAULT 0 NOT NULL, - CONSTRAINT location_ruid_idx UNIQUE (ruid), - CONSTRAINT location_connection_idx UNIQUE (server_id, connection_id) + CONSTRAINT location_ruid_idx UNIQUE (ruid) ); CREATE INDEX location_account_contact_idx ON location (username, domain, contact); CREATE INDEX location_expires_idx ON location (expires); +CREATE INDEX location_connection_idx ON location (server_id, connection_id); INSERT INTO version (table_name, table_version) values ('location','8');

8 years, 9 months

[kamailio] auth_check: to 2 accounts on the same Phone, same username different realm fails with -2 (#548)

by chiluap

Hi there, we are using kamailio as Registrar and Dispatcher. Running ```modparam("auth_db", "use_domain", MULTIDOMAIN) //with MULTIDOMAIN = 1``` In our ```route[AUTH]``` I call ```if (!auth_check("$fd", "subscriber", "1")) {``` to filter unwanted Guests and and brute-force attacks to the blacklist. strangely auth_check fails under the following conditions: 1 UserAgent(Phone) with 2 SipAccounts with the same user-name but different realm The first account can REGISTER without a problem. for the second Account REGISTER fails with -2. If I disable the first one the second one Registered. Could it be that auth_check is not multidomain-safe in one user-agent thread? Hope to here from you... PS: I like kamailio =). --- 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/548

8 years, 9 months

git:4.4:d11cc80c: srdb1/schema: removed unique constraint from connection_idx

by Juha Heinanen

Module: kamailio Branch: 4.4 Commit: d11cc80c3a4a2fdeb446837c550517e4f4a511a9 URL: https://github.com/kamailio/kamailio/commit/d11cc80c3a4a2fdeb446837c550517e… Author: Juha Heinanen <jh(a)tutpro.com> Committer: Juha Heinanen <jh(a)tutpro.com> Date: 2016-03-23T16:37:38+02:00 srdb1/schema: removed unique constraint from connection_idx (cherry picked from commit d72ac166b152ca6906248d67e2605d5b283fa01e) --- Modified: lib/srdb1/schema/location.xml --- Diff: https://github.com/kamailio/kamailio/commit/d11cc80c3a4a2fdeb446837c550517e… Patch: https://github.com/kamailio/kamailio/commit/d11cc80c3a4a2fdeb446837c550517e… --- diff --git a/lib/srdb1/schema/location.xml b/lib/srdb1/schema/location.xml index 07c8d58..c22fcaf 100644 --- a/lib/srdb1/schema/location.xml +++ b/lib/srdb1/schema/location.xml @@ -232,7 +232,6 @@ <name>connection_idx</name> <colref linkend="server_id"/> <colref linkend="connection_id"/> - <unique/> </index>

8 years, 9 months

git:master:4f9e0ffc: srdb1/schema: added connection_idx index to location table

by Juha Heinanen

Module: kamailio Branch: master Commit: 4f9e0ffc7c320666de1d139658c6b645561e217d URL: https://github.com/kamailio/kamailio/commit/4f9e0ffc7c320666de1d139658c6b64… Author: Juha Heinanen <jh(a)tutpro.com> Committer: Juha Heinanen <jh(a)tutpro.com> Date: 2016-03-01T09:46:52+02:00 srdb1/schema: added connection_idx index to location table --- Modified: lib/srdb1/schema/location.xml --- Diff: https://github.com/kamailio/kamailio/commit/4f9e0ffc7c320666de1d139658c6b64… Patch: https://github.com/kamailio/kamailio/commit/4f9e0ffc7c320666de1d139658c6b64… --- diff --git a/lib/srdb1/schema/location.xml b/lib/srdb1/schema/location.xml index 698fcc0..07c8d58 100644 --- a/lib/srdb1/schema/location.xml +++ b/lib/srdb1/schema/location.xml @@ -179,7 +179,7 @@ <description>The value of reg-id contact parameter</description> </column> - <column> + <column id="server_id"> <name>server_id</name> <type>int</type> <size>11</size> @@ -187,7 +187,7 @@ <description>The value of server_id from configuration file</description> </column> - <column> + <column id="connection_id"> <name>connection_id</name> <type>int</type> <size>11</size> @@ -228,6 +228,12 @@ <name>expires_idx</name> <colref linkend="expires"/> </index> + <index> + <name>connection_idx</name> + <colref linkend="server_id"/> + <colref linkend="connection_id"/> + <unique/> + </index> </table>

8 years, 9 months

← Newer
1
...
14
15
16
17
18
19
20
...
39
Older →

Jump to page:

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

sr-dev March 2016