sr-dev April 2012

sr-dev@lists.kamailio.org

29 participants
346 discussions

[tracker] Task closed: pua_reginfo: registration state may be incorrect when unregistering single contact

by sip-router

THIS IS AN AUTOMATED MESSAGE, DO NOT REPLY. The following task is now closed: FS#213 - pua_reginfo: registration state may be incorrect when unregistering single contact User who did this - Daniel-Constantin Mierla (miconda) Reason for closing: Fixed Additional comments about closing: Thanks, patch applied. More information can be found at the following URL: http://sip-router.org/tracker/index.php?do=details&task_id=213 You are receiving this message because you have requested it from the Flyspray bugtracking system. If you did not expect this message or don't want to receive mails in future, you can change your notification settings at the URL shown above.

12 years, 7 months

git:master: pua_reginfo: fix for state of the registration during unregister

by Daniel-Constantin Mierla

Module: sip-router Branch: master Commit: c4be935b40b23b87b321fd604e761332bb07b8f8 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=c4be935… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: Tue Apr 17 22:55:35 2012 +0200 pua_reginfo: fix for state of the registration during unregister - when unregistering a single contact, the state of the registration may be incorrectly reported . - fix of a small inefficiency of repeatedly calling time(2) in the same function. - patch by Stefan Sayer, FS#213 --- modules_k/pua_reginfo/usrloc_cb.c | 30 ++++++++++++++++-------------- 1 files changed, 16 insertions(+), 14 deletions(-) diff --git a/modules_k/pua_reginfo/usrloc_cb.c b/modules_k/pua_reginfo/usrloc_cb.c index addeea9..92cf427 100644 --- a/modules_k/pua_reginfo/usrloc_cb.c +++ b/modules_k/pua_reginfo/usrloc_cb.c @@ -60,6 +60,8 @@ str* build_reginfo_full(urecord_t * record, str uri, ucontact_t* c, int type) { ucontact_t * ptr; char buf[512]; int buf_len; + int reg_active = 0; + time_t cur_time = time(0); /* create the XML-Body */ doc = xmlNewDoc(BAD_CAST "1.0"); @@ -94,18 +96,9 @@ str* build_reginfo_full(urecord_t * record, str uri, ucontact_t* c, int type) { buf_len = snprintf(buf, sizeof(buf), "%p", record); xmlNewProp(registration_node, BAD_CAST "id", BAD_CAST buf); - /* look first for an un-expired and suported contact */ - ptr = record->contacts; - while ((ptr) && !(VALID_CONTACT(ptr,time(0)))) - ptr = ptr->next; - if (ptr==0) - xmlNewProp(registration_node, BAD_CAST "state", BAD_CAST "terminated"); - else - xmlNewProp(registration_node, BAD_CAST "state", BAD_CAST "active"); - ptr = record->contacts; while (ptr) { - if (VALID_CONTACT(ptr, time(0))) { + if (VALID_CONTACT(ptr, cur_time)) { LM_DBG("Contact %.*s, %p\n", ptr->c.len, ptr->c.s, ptr); /* Contact-Node */ contact_node =xmlNewChild(registration_node, NULL, BAD_CAST "contact", NULL) ; @@ -118,9 +111,10 @@ str* build_reginfo_full(urecord_t * record, str uri, ucontact_t* c, int type) { xmlNewProp(contact_node, BAD_CAST "id", BAD_CAST buf); /* Check, if this is the modified contact: */ if (ptr == c) { - if ((type & UL_CONTACT_INSERT) || (type & UL_CONTACT_UPDATE)) + if ((type & UL_CONTACT_INSERT) || (type & UL_CONTACT_UPDATE)) { + reg_active = 1; xmlNewProp(contact_node, BAD_CAST "state", BAD_CAST "active"); - else + } else xmlNewProp(contact_node, BAD_CAST "state", BAD_CAST "terminated"); if (type & UL_CONTACT_INSERT) xmlNewProp(contact_node, BAD_CAST "event", BAD_CAST "created"); else if (type & UL_CONTACT_UPDATE) xmlNewProp(contact_node, BAD_CAST "event", BAD_CAST "refreshed"); @@ -128,13 +122,14 @@ str* build_reginfo_full(urecord_t * record, str uri, ucontact_t* c, int type) { else if (type & UL_CONTACT_DELETE) xmlNewProp(contact_node, BAD_CAST "event", BAD_CAST "unregistered"); else xmlNewProp(contact_node, BAD_CAST "event", BAD_CAST "unknown"); memset(buf, 0, sizeof(buf)); - buf_len = snprintf(buf, sizeof(buf), "%i", (int)(ptr->expires-time(0))); + buf_len = snprintf(buf, sizeof(buf), "%i", (int)(ptr->expires-cur_time)); xmlNewProp(contact_node, BAD_CAST "expires", BAD_CAST buf); } else { + reg_active = 1; xmlNewProp(contact_node, BAD_CAST "state", BAD_CAST "active"); xmlNewProp(contact_node, BAD_CAST "event", BAD_CAST "registered"); memset(buf, 0, sizeof(buf)); - buf_len = snprintf(buf, sizeof(buf), "%i", (int)(ptr->expires-time(0))); + buf_len = snprintf(buf, sizeof(buf), "%i", (int)(ptr->expires-cur_time)); xmlNewProp(contact_node, BAD_CAST "expires", BAD_CAST buf); } if (ptr->q != Q_UNSPECIFIED) { @@ -163,6 +158,13 @@ str* build_reginfo_full(urecord_t * record, str uri, ucontact_t* c, int type) { ptr = ptr->next; } + /* add registration state (at least one active contact): */ + if (reg_active==0) + xmlNewProp(registration_node, BAD_CAST "state", BAD_CAST "terminated"); + else + xmlNewProp(registration_node, BAD_CAST "state", BAD_CAST "active"); + + /* create the body */ body = (str*)pkg_malloc(sizeof(str)); if(body == NULL) {

12 years, 7 months

[tracker] Task closed: Problem with Max-Forwards header parsing

by sip-router

THIS IS AN AUTOMATED MESSAGE, DO NOT REPLY. The following task is now closed: FS#214 - Problem with Max-Forwards header parsing User who did this - Daniel-Constantin Mierla (miconda) Reason for closing: Fixed Additional comments about closing: I pushed a patch in git master branch to return false in case MF header cannot be processed. http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=a15428e… More information can be found at the following URL: http://sip-router.org/tracker/index.php?do=details&task_id=214 You are receiving this message because you have requested it from the Flyspray bugtracking system. If you did not expect this message or don't want to receive mails in future, you can change your notification settings at the URL shown above.

12 years, 7 months

[tracker] User took ownership: Problem with Max-Forwards header parsing

by sip-router

THIS IS AN AUTOMATED MESSAGE, DO NOT REPLY. Daniel-Constantin Mierla has taken ownership of the following task: FS#214 - Problem with Max-Forwards header parsing More information can be found at the following URL: http://sip-router.org/tracker/index.php?do=details&task_id=214 You are receiving this message because you have requested it from the Flyspray bugtracking system. If you did not expect this message or don't want to receive mails in future, you can change your notification settings at the URL shown above.

12 years, 7 months

git:master: maxfwd(k): return -2 (false) if MF header cannot be processed

by Daniel-Constantin Mierla

Module: sip-router Branch: master Commit: a15428e688049e7ef49174a2e24cbf49eb7a7cad URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=a15428e… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: Tue Apr 17 22:40:06 2012 +0200 maxfwd(k): return -2 (false) if MF header cannot be processed - reported by Ladislav Jurak, FS#214 --- modules_k/maxfwd/maxfwd.c | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/modules_k/maxfwd/maxfwd.c b/modules_k/maxfwd/maxfwd.c index 792949f..4e1735e 100644 --- a/modules_k/maxfwd/maxfwd.c +++ b/modules_k/maxfwd/maxfwd.c @@ -153,7 +153,7 @@ int process_maxfwd_header(struct sip_msg *msg, int limit) return 2; /* error */ case -2: - break; + goto error; /* found */ case 0: return -1;

12 years, 7 months

[tracker] Task opened: Problem with Max-Forwards header parsing

by sip-router

THIS IS AN AUTOMATED MESSAGE, DO NOT REPLY. A new Flyspray task has been opened. Details are below. User who did this - Ladislav Jurak (ladis) Attached to Project - sip-router Summary - Problem with Max-Forwards header parsing Task Type - Bug Report Category - Core Status - Assigned Assigned To - Andrei Pelinescu-Onciul Operating System - Linux Severity - Medium Priority - Normal Reported Version - Development Due in Version - Undecided Due Date - Undecided Details - Hello, I am testing some SIP DoS attacks vulnerabilities on Kamailio v3.2 server and I found in an loop based attack this thing: When Max-Forwards header is set to some text value that server cannot parse or a numeric value higher than 99999, server only copy the Max-Forwards header and forwards the message with the same malformed Max-Forwards value. Server logs this error - "ERROR: maxfwd [mf_funcs.c:80]: unable to parse the max forwards number" but does not drop the message. Thus message can be forwarded infinitely. This can by exploitable in loop based attacks. I think that message with malformed Max-Forward header that server cannot parse should be dropped, or at least reset the Max-Forward header to some defined value. More information can be found at the following URL: http://sip-router.org/tracker/index.php?do=details&task_id=214 You are receiving this message because you have requested it from the Flyspray bugtracking system. If you did not expect this message or don't want to receive mails in future, you can change your notification settings at the URL shown above.

12 years, 7 months

[tracker] Assignee added: Problem with Max-Forwards header parsing

by sip-router

THIS IS AN AUTOMATED MESSAGE, DO NOT REPLY. A user has added themself to the list of users assigned to this task. FS#214 - Problem with Max-Forwards header parsing User who did this - Ladislav Jurak (ladis) http://sip-router.org/tracker/index.php?do=details&task_id=214 You are receiving this message because you have requested it from the Flyspray bugtracking system. If you did not expect this message or don't want to receive mails in future, you can change your notification settings at the URL shown above.

12 years, 7 months

registrar/usrloc updates - gruu support (rfc 5627)

by Daniel-Constantin Mierla

Hello, I just pushed GRUU support in git master branch. That implied adding two new columns to location table, therefore if you use devel version, **you have to update your db schema**. Perhaps a bit of tuning will follow in the next days, but GRUU support should be fully functional in terms of routing. Testing and feedback will be very appreciated as well as hints on what SIP hard/phones support GRUU properly. Be also aware that now you may have to do lookup location even for within dialog requests, if the r-uri is a local GRUU. Cheers, Daniel -- Daniel-Constantin Mierla Kamailio Advanced Training, April 23-26, 2012, Berlin, Germany http://www.asipto.com/index.php/kamailio-advanced-training/

12 years, 7 months

git:master: usrloc(k): handle reg-id Contact parameter defined by RFC5626

by Daniel-Constantin Mierla

Module: sip-router Branch: master Commit: 221073eb54dbf9a29d8b68d6af86c3bbccdc2b17 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=221073e… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: Tue Apr 17 11:48:46 2012 +0200 usrloc(k): handle reg-id Contact parameter defined by RFC5626 - if reg-id is given in the Contact header, use it to match the usrloc record along with +sip.instance --- modules_k/usrloc/ucontact.c | 24 +++++++++++++++++++----- modules_k/usrloc/udomain.c | 34 +++++++++++++++++++++------------- modules_k/usrloc/ul_mi.c | 6 ++++++ modules_k/usrloc/ul_mod.c | 22 +++++++++++++--------- modules_k/usrloc/ul_mod.h | 7 ++++--- modules_k/usrloc/ul_rpc.c | 9 +++++++++ modules_k/usrloc/urecord.c | 14 +++++++------- modules_k/usrloc/urecord.h | 9 +++------ modules_k/usrloc/usrloc.h | 7 ++++--- 9 files changed, 86 insertions(+), 46 deletions(-) Diff: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commitdiff;h=221…

12 years, 7 months

git:master: srdb1: new column reg_id to location and aliases tables

by Daniel-Constantin Mierla

Module: sip-router Branch: master Commit: 6927fcf7bb48d88a708028a0c877a050150ef05d URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=6927fcf… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: Tue Apr 17 11:47:34 2012 +0200 srdb1: new column reg_id to location and aliases tables - stores the value of reg-id Contact parameter defined by RFC5626 --- lib/srdb1/schema/aliases.xml | 9 +++++++++ lib/srdb1/schema/location.xml | 8 ++++++++ utils/kamctl/db_berkeley/kamailio/aliases | 4 ++-- utils/kamctl/db_berkeley/kamailio/location | 4 ++-- utils/kamctl/db_sqlite/registrar-create.sql | 3 ++- utils/kamctl/db_sqlite/usrloc-create.sql | 3 ++- utils/kamctl/dbtext/kamailio/aliases | 2 +- utils/kamctl/dbtext/kamailio/location | 2 +- utils/kamctl/mysql/registrar-create.sql | 3 ++- utils/kamctl/mysql/usrloc-create.sql | 3 ++- utils/kamctl/oracle/registrar-create.sql | 3 ++- utils/kamctl/oracle/usrloc-create.sql | 3 ++- utils/kamctl/postgres/registrar-create.sql | 3 ++- utils/kamctl/postgres/usrloc-create.sql | 3 ++- 14 files changed, 39 insertions(+), 14 deletions(-) diff --git a/lib/srdb1/schema/aliases.xml b/lib/srdb1/schema/aliases.xml index d5bad5a..fe7df18 100644 --- a/lib/srdb1/schema/aliases.xml +++ b/lib/srdb1/schema/aliases.xml @@ -171,6 +171,15 @@ <description>The value of SIP instance parameter for GRUU.</description> </column> + <column> + <name>reg_id</name> + <type>int</type> + <size>11</size> + <default>0</default> + <description>The value of reg-id contact parameter</description> + </column> + + <index> <name>alias_idx</name> <colref linkend="username"/> diff --git a/lib/srdb1/schema/location.xml b/lib/srdb1/schema/location.xml index ddf0b48..0276212 100644 --- a/lib/srdb1/schema/location.xml +++ b/lib/srdb1/schema/location.xml @@ -171,6 +171,14 @@ <description>The value of SIP instance parameter for GRUU.</description> </column> + <column> + <name>reg_id</name> + <type>int</type> + <size>11</size> + <default>0</default> + <description>The value of reg-id contact parameter</description> + </column> + <index> <name>account_contact_idx</name> diff --git a/utils/kamctl/db_berkeley/kamailio/aliases b/utils/kamctl/db_berkeley/kamailio/aliases index 87bf7d5..edc1177 100644 --- a/utils/kamctl/db_berkeley/kamailio/aliases +++ b/utils/kamctl/db_berkeley/kamailio/aliases @@ -1,5 +1,5 @@ METADATA_COLUMNS -id(int) ruid(str) username(str) domain(str) contact(str) received(str) path(str) expires(datetime) q(double) callid(str) cseq(int) last_modified(datetime) flags(int) cflags(int) user_agent(str) socket(str) methods(int) instance(str) +id(int) ruid(str) username(str) domain(str) contact(str) received(str) path(str) expires(datetime) q(double) callid(str) cseq(int) last_modified(datetime) flags(int) cflags(int) user_agent(str) socket(str) methods(int) instance(str) reg_id(int) METADATA_KEY 1 2 3 METADATA_READONLY @@ -7,4 +7,4 @@ METADATA_READONLY METADATA_LOGFLAGS 0 METADATA_DEFAULTS -NIL|''|''|NULL|''|NULL|NULL|'2020-05-28 21:32:15'|1.0|'Default-Call-ID'|1|'1900-01-01 00:00:01'|0|0|''|NULL|NULL|NULL +NIL|''|''|NULL|''|NULL|NULL|'2020-05-28 21:32:15'|1.0|'Default-Call-ID'|1|'1900-01-01 00:00:01'|0|0|''|NULL|NULL|NULL|0 diff --git a/utils/kamctl/db_berkeley/kamailio/location b/utils/kamctl/db_berkeley/kamailio/location index 87bf7d5..edc1177 100644 --- a/utils/kamctl/db_berkeley/kamailio/location +++ b/utils/kamctl/db_berkeley/kamailio/location @@ -1,5 +1,5 @@ METADATA_COLUMNS -id(int) ruid(str) username(str) domain(str) contact(str) received(str) path(str) expires(datetime) q(double) callid(str) cseq(int) last_modified(datetime) flags(int) cflags(int) user_agent(str) socket(str) methods(int) instance(str) +id(int) ruid(str) username(str) domain(str) contact(str) received(str) path(str) expires(datetime) q(double) callid(str) cseq(int) last_modified(datetime) flags(int) cflags(int) user_agent(str) socket(str) methods(int) instance(str) reg_id(int) METADATA_KEY 1 2 3 METADATA_READONLY @@ -7,4 +7,4 @@ METADATA_READONLY METADATA_LOGFLAGS 0 METADATA_DEFAULTS -NIL|''|''|NULL|''|NULL|NULL|'2020-05-28 21:32:15'|1.0|'Default-Call-ID'|1|'1900-01-01 00:00:01'|0|0|''|NULL|NULL|NULL +NIL|''|''|NULL|''|NULL|NULL|'2020-05-28 21:32:15'|1.0|'Default-Call-ID'|1|'1900-01-01 00:00:01'|0|0|''|NULL|NULL|NULL|0 diff --git a/utils/kamctl/db_sqlite/registrar-create.sql b/utils/kamctl/db_sqlite/registrar-create.sql index 27a4d8f..8743517 100644 --- a/utils/kamctl/db_sqlite/registrar-create.sql +++ b/utils/kamctl/db_sqlite/registrar-create.sql @@ -17,7 +17,8 @@ CREATE TABLE aliases ( user_agent VARCHAR(255) DEFAULT '' NOT NULL, socket VARCHAR(64) DEFAULT NULL, methods INTEGER DEFAULT NULL, - instance VARCHAR(255) DEFAULT NULL + instance VARCHAR(255) DEFAULT NULL, + reg_id INTEGER DEFAULT 0 NOT NULL ); CREATE INDEX aliases_alias_idx ON aliases (username, domain, contact); diff --git a/utils/kamctl/db_sqlite/usrloc-create.sql b/utils/kamctl/db_sqlite/usrloc-create.sql index 5d80120..72fd3d9 100644 --- a/utils/kamctl/db_sqlite/usrloc-create.sql +++ b/utils/kamctl/db_sqlite/usrloc-create.sql @@ -17,7 +17,8 @@ CREATE TABLE location ( user_agent VARCHAR(255) DEFAULT '' NOT NULL, socket VARCHAR(64) DEFAULT NULL, methods INTEGER DEFAULT NULL, - instance VARCHAR(255) DEFAULT NULL + instance VARCHAR(255) DEFAULT NULL, + reg_id INTEGER DEFAULT 0 NOT NULL ); CREATE INDEX location_account_contact_idx ON location (username, domain, contact); diff --git a/utils/kamctl/dbtext/kamailio/aliases b/utils/kamctl/dbtext/kamailio/aliases index 29c4968..f3f0c72 100644 --- a/utils/kamctl/dbtext/kamailio/aliases +++ b/utils/kamctl/dbtext/kamailio/aliases @@ -1 +1 @@ -id(int,auto) ruid(string) username(string) domain(string,null) contact(string) received(string,null) path(string,null) expires(int) q(double) callid(string) cseq(int) last_modified(int) flags(int) cflags(int) user_agent(string) socket(string,null) methods(int,null) instance(string,null) +id(int,auto) ruid(string) username(string) domain(string,null) contact(string) received(string,null) path(string,null) expires(int) q(double) callid(string) cseq(int) last_modified(int) flags(int) cflags(int) user_agent(string) socket(string,null) methods(int,null) instance(string,null) reg_id(int) diff --git a/utils/kamctl/dbtext/kamailio/location b/utils/kamctl/dbtext/kamailio/location index 29c4968..f3f0c72 100644 --- a/utils/kamctl/dbtext/kamailio/location +++ b/utils/kamctl/dbtext/kamailio/location @@ -1 +1 @@ -id(int,auto) ruid(string) username(string) domain(string,null) contact(string) received(string,null) path(string,null) expires(int) q(double) callid(string) cseq(int) last_modified(int) flags(int) cflags(int) user_agent(string) socket(string,null) methods(int,null) instance(string,null) +id(int,auto) ruid(string) username(string) domain(string,null) contact(string) received(string,null) path(string,null) expires(int) q(double) callid(string) cseq(int) last_modified(int) flags(int) cflags(int) user_agent(string) socket(string,null) methods(int,null) instance(string,null) reg_id(int) diff --git a/utils/kamctl/mysql/registrar-create.sql b/utils/kamctl/mysql/registrar-create.sql index 54d143f..73f808c 100644 --- a/utils/kamctl/mysql/registrar-create.sql +++ b/utils/kamctl/mysql/registrar-create.sql @@ -17,7 +17,8 @@ CREATE TABLE aliases ( user_agent VARCHAR(255) DEFAULT '' NOT NULL, socket VARCHAR(64) DEFAULT NULL, methods INT(11) DEFAULT NULL, - instance VARCHAR(255) DEFAULT NULL + instance VARCHAR(255) DEFAULT NULL, + reg_id INT(11) DEFAULT 0 NOT NULL ) ENGINE=MyISAM; CREATE INDEX alias_idx ON aliases (username, domain, contact); diff --git a/utils/kamctl/mysql/usrloc-create.sql b/utils/kamctl/mysql/usrloc-create.sql index 3e86737..dc1fa5a 100644 --- a/utils/kamctl/mysql/usrloc-create.sql +++ b/utils/kamctl/mysql/usrloc-create.sql @@ -17,7 +17,8 @@ CREATE TABLE location ( user_agent VARCHAR(255) DEFAULT '' NOT NULL, socket VARCHAR(64) DEFAULT NULL, methods INT(11) DEFAULT NULL, - instance VARCHAR(255) DEFAULT NULL + instance VARCHAR(255) DEFAULT NULL, + reg_id INT(11) DEFAULT 0 NOT NULL ) ENGINE=MyISAM; CREATE INDEX account_contact_idx ON location (username, domain, contact); diff --git a/utils/kamctl/oracle/registrar-create.sql b/utils/kamctl/oracle/registrar-create.sql index 9ba6898..0409d84 100644 --- a/utils/kamctl/oracle/registrar-create.sql +++ b/utils/kamctl/oracle/registrar-create.sql @@ -17,7 +17,8 @@ CREATE TABLE aliases ( user_agent VARCHAR2(255) DEFAULT '', socket VARCHAR2(64) DEFAULT NULL, methods NUMBER(10) DEFAULT NULL, - instance VARCHAR2(255) DEFAULT NULL + instance VARCHAR2(255) DEFAULT NULL, + reg_id NUMBER(10) DEFAULT 0 NOT NULL ); CREATE OR REPLACE TRIGGER aliases_tr diff --git a/utils/kamctl/oracle/usrloc-create.sql b/utils/kamctl/oracle/usrloc-create.sql index 144c859..386af40 100644 --- a/utils/kamctl/oracle/usrloc-create.sql +++ b/utils/kamctl/oracle/usrloc-create.sql @@ -17,7 +17,8 @@ CREATE TABLE location ( user_agent VARCHAR2(255) DEFAULT '', socket VARCHAR2(64) DEFAULT NULL, methods NUMBER(10) DEFAULT NULL, - instance VARCHAR2(255) DEFAULT NULL + instance VARCHAR2(255) DEFAULT NULL, + reg_id NUMBER(10) DEFAULT 0 NOT NULL ); CREATE OR REPLACE TRIGGER location_tr diff --git a/utils/kamctl/postgres/registrar-create.sql b/utils/kamctl/postgres/registrar-create.sql index b8889a2..2771e01 100644 --- a/utils/kamctl/postgres/registrar-create.sql +++ b/utils/kamctl/postgres/registrar-create.sql @@ -17,7 +17,8 @@ CREATE TABLE aliases ( user_agent VARCHAR(255) DEFAULT '' NOT NULL, socket VARCHAR(64) DEFAULT NULL, methods INTEGER DEFAULT NULL, - instance VARCHAR(255) DEFAULT NULL + instance VARCHAR(255) DEFAULT NULL, + reg_id INTEGER DEFAULT 0 NOT NULL ); CREATE INDEX aliases_alias_idx ON aliases (username, domain, contact); diff --git a/utils/kamctl/postgres/usrloc-create.sql b/utils/kamctl/postgres/usrloc-create.sql index c972d71..a74fe87 100644 --- a/utils/kamctl/postgres/usrloc-create.sql +++ b/utils/kamctl/postgres/usrloc-create.sql @@ -17,7 +17,8 @@ CREATE TABLE location ( user_agent VARCHAR(255) DEFAULT '' NOT NULL, socket VARCHAR(64) DEFAULT NULL, methods INTEGER DEFAULT NULL, - instance VARCHAR(255) DEFAULT NULL + instance VARCHAR(255) DEFAULT NULL, + reg_id INTEGER DEFAULT 0 NOT NULL ); CREATE INDEX location_account_contact_idx ON location (username, domain, contact);

12 years, 7 months

← Newer
1
...
22
23
24
25
26
27
28
...
35
Older →

Jump to page:

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

sr-dev April 2012