sr-dev July 2011

sr-dev@lists.kamailio.org

28 participants
199 discussions

git:master: srdb1: Fixed merge error made in commit 8623eeb1c2762d299cd88e0b7bc8d8fdb8fa2a72
by Peter Dunkley 29 Jul '11

29 Jul '11

Module: sip-router Branch: master Commit: fce0a50f90d3fc7625f9d8d4984d34a01079a4d4 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=fce0a50… Author: pd <peter.dunkley(a)crocodile-rcs.com> Committer: pd <peter.dunkley(a)crocodile-rcs.com> Date: Wed Jul 27 13:49:50 2011 +0100 srdb1: Fixed merge error made in commit 8623eeb1c2762d299cd88e0b7bc8d8fdb8fa2a72 - When copying utils/kamctl/mysql/siptrace-create.sql from my local SVN I accidently copied … [View More]

1 0

git:master: srdb1: Added support for logging of messages > 64k in sip_trace with MySQL
by Peter Dunkley 29 Jul '11

29 Jul '11

Module: sip-router Branch: master Commit: 8623eeb1c2762d299cd88e0b7bc8d8fdb8fa2a72 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=8623eeb… Author: pd <peter.dunkley(a)crocodile-rcs.com> Committer: pd <peter.dunkley(a)crocodile-rcs.com> Date: Wed Jul 27 12:18:05 2011 +0100 srdb1: Added support for logging of messages > 64k in sip_trace with MySQL - Some SIP requests - especially full-state NOTIFYs for large resource losts - can easily exceed 64k.… [View More] - This change makes MySQL use the mediumtext type for message contents. - Feature added by Andrew Miller at Crocodile RCS --- lib/srdb1/schema/sip_trace.xml | 2 +- utils/kamctl/mysql/siptrace-create.sql | 14 +++++++------- 2 files changed, 8 insertions(+), 8 deletions(-) diff --git a/lib/srdb1/schema/sip_trace.xml b/lib/srdb1/schema/sip_trace.xml index 0b492c4..630f0dc 100644 --- a/lib/srdb1/schema/sip_trace.xml +++ b/lib/srdb1/schema/sip_trace.xml @@ -53,7 +53,7 @@ <column> <name>msg</name> - <type>text</type> + <type>largetext</type> <description>Full SIP message</description> </column> diff --git a/utils/kamctl/mysql/siptrace-create.sql b/utils/kamctl/mysql/siptrace-create.sql index da4a11f..9021d0c 100644 --- a/utils/kamctl/mysql/siptrace-create.sql +++ b/utils/kamctl/mysql/siptrace-create.sql @@ -1,7 +1,7 @@ INSERT INTO version (table_name, table_version) values ('sip_trace','2'); CREATE TABLE sip_trace ( - id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, - time_stamp DATETIME DEFAULT '1900-01-01 00:00:01' NOT NULL, + id SERIAL PRIMARY KEY NOT NULL, + time_stamp TIMESTAMP WITHOUT TIME ZONE DEFAULT '1900-01-01 00:00:01' NOT NULL, callid VARCHAR(255) DEFAULT '' NOT NULL, traced_user VARCHAR(128) DEFAULT '' NOT NULL, msg TEXT NOT NULL, @@ -11,10 +11,10 @@ CREATE TABLE sip_trace ( toip VARCHAR(50) DEFAULT '' NOT NULL, fromtag VARCHAR(64) DEFAULT '' NOT NULL, direction VARCHAR(4) DEFAULT '' NOT NULL -) ENGINE=MyISAM; +); -CREATE INDEX traced_user_idx ON sip_trace (traced_user); -CREATE INDEX date_idx ON sip_trace (time_stamp); -CREATE INDEX fromip_idx ON sip_trace (fromip); -CREATE INDEX callid_idx ON sip_trace (callid); +CREATE INDEX sip_trace_traced_user_idx ON sip_trace (traced_user); +CREATE INDEX sip_trace_date_idx ON sip_trace (time_stamp); +CREATE INDEX sip_trace_fromip_idx ON sip_trace (fromip); +CREATE INDEX sip_trace_callid_idx ON sip_trace (callid); [View Less]

1 0

git:master: srdb1, modules_k/xcap_server: Added support for XML documents larger than 64k in MySQL
by Peter Dunkley 29 Jul '11

29 Jul '11

Module: sip-router Branch: master Commit: 6033da2e644ccdca7fa57bee03f82cb03c36e45e URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=6033da2… Author: pd <peter.dunkley(a)crocodile-rcs.com> Committer: pd <peter.dunkley(a)crocodile-rcs.com> Date: Wed Jul 27 12:13:25 2011 +0100 srdb1, modules_k/xcap_server: Added support for XML documents larger than 64k in MySQL - It is easily possible for some XML documents (particularly resource lists used as a … [View More]Network Address Book) to exceed 64k in size. - Feature added by Andrew Miller at Crocodile RCS --- lib/srdb1/schema/pr_xcap.xml | 2 +- modules_k/xcap_server/xcap_server.c | 2 +- utils/kamctl/mysql/presence-create.sql | 70 ++++++++++++++++---------------- 3 files changed, 37 insertions(+), 37 deletions(-) diff --git a/lib/srdb1/schema/pr_xcap.xml b/lib/srdb1/schema/pr_xcap.xml index 92ffda3..ef30273 100644 --- a/lib/srdb1/schema/pr_xcap.xml +++ b/lib/srdb1/schema/pr_xcap.xml @@ -44,7 +44,7 @@ <column> <name>doc</name> - <type>binary</type> + <type>largebinary</type> <description>doc</description> </column> diff --git a/modules_k/xcap_server/xcap_server.c b/modules_k/xcap_server/xcap_server.c index 1a041e3..db1e0f5 100644 --- a/modules_k/xcap_server/xcap_server.c +++ b/modules_k/xcap_server/xcap_server.c @@ -351,7 +351,7 @@ static int xcaps_put_db(str* user, str *domain, xcap_uri_t *xuri, str *etag, ncols++; qcols[ncols] = &str_doc_col; - qvals[ncols].type = DB1_STR; + qvals[ncols].type = DB1_BLOB; qvals[ncols].nul = 0; qvals[ncols].val.str_val= *doc; ncols++; diff --git a/utils/kamctl/mysql/presence-create.sql b/utils/kamctl/mysql/presence-create.sql index 740149b..3b2608c 100644 --- a/utils/kamctl/mysql/presence-create.sql +++ b/utils/kamctl/mysql/presence-create.sql @@ -1,20 +1,20 @@ INSERT INTO version (table_name, table_version) values ('presentity','3'); CREATE TABLE presentity ( - id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, + id SERIAL PRIMARY KEY NOT NULL, username VARCHAR(64) NOT NULL, domain VARCHAR(64) NOT NULL, event VARCHAR(64) NOT NULL, etag VARCHAR(64) NOT NULL, - expires INT(11) NOT NULL, - received_time INT(11) NOT NULL, - body BLOB NOT NULL, + expires INTEGER NOT NULL, + received_time INTEGER NOT NULL, + body BYTEA NOT NULL, sender VARCHAR(128) NOT NULL, - CONSTRAINT presentity_idx UNIQUE (username, domain, event, etag) -) ENGINE=MyISAM; + CONSTRAINT presentity_presentity_idx UNIQUE (username, domain, event, etag) +); INSERT INTO version (table_name, table_version) values ('active_watchers','9'); CREATE TABLE active_watchers ( - id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, + id SERIAL PRIMARY KEY NOT NULL, presentity_uri VARCHAR(128) NOT NULL, watcher_username VARCHAR(64) NOT NULL, watcher_domain VARCHAR(64) NOT NULL, @@ -25,68 +25,68 @@ CREATE TABLE active_watchers ( to_tag VARCHAR(64) NOT NULL, from_tag VARCHAR(64) NOT NULL, callid VARCHAR(255) NOT NULL, - local_cseq INT(11) NOT NULL, - remote_cseq INT(11) NOT NULL, + local_cseq INTEGER NOT NULL, + remote_cseq INTEGER NOT NULL, contact VARCHAR(128) NOT NULL, record_route TEXT, - expires INT(11) NOT NULL, - status INT(11) DEFAULT 2 NOT NULL, + expires INTEGER NOT NULL, + status INTEGER DEFAULT 2 NOT NULL, reason VARCHAR(64) NOT NULL, - version INT(11) DEFAULT 0 NOT NULL, + version INTEGER DEFAULT 0 NOT NULL, socket_info VARCHAR(64) NOT NULL, local_contact VARCHAR(128) NOT NULL, - CONSTRAINT active_watchers_idx UNIQUE (presentity_uri, callid, to_tag, from_tag) -) ENGINE=MyISAM; + CONSTRAINT active_watchers_active_watchers_idx UNIQUE (presentity_uri, callid, to_tag, from_tag) +); INSERT INTO version (table_name, table_version) values ('watchers','3'); CREATE TABLE watchers ( - id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, + id SERIAL PRIMARY KEY NOT NULL, presentity_uri VARCHAR(128) NOT NULL, watcher_username VARCHAR(64) NOT NULL, watcher_domain VARCHAR(64) NOT NULL, event VARCHAR(64) DEFAULT 'presence' NOT NULL, - status INT(11) NOT NULL, + status INTEGER NOT NULL, reason VARCHAR(64), - inserted_time INT(11) NOT NULL, - CONSTRAINT watcher_idx UNIQUE (presentity_uri, watcher_username, watcher_domain, event) -) ENGINE=MyISAM; + inserted_time INTEGER NOT NULL, + CONSTRAINT watchers_watcher_idx UNIQUE (presentity_uri, watcher_username, watcher_domain, event) +); INSERT INTO version (table_name, table_version) values ('xcap','3'); CREATE TABLE xcap ( - id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, + id SERIAL PRIMARY KEY NOT NULL, username VARCHAR(64) NOT NULL, domain VARCHAR(64) NOT NULL, - doc BLOB NOT NULL, - doc_type INT(11) NOT NULL, + doc BYTEA NOT NULL, + doc_type INTEGER NOT NULL, etag VARCHAR(64) NOT NULL, - source INT(11) NOT NULL, + source INTEGER NOT NULL, doc_uri VARCHAR(128) NOT NULL, - port INT(11) NOT NULL, - CONSTRAINT account_doc_type_idx UNIQUE (username, domain, doc_type, doc_uri) -) ENGINE=MyISAM; + port INTEGER NOT NULL, + CONSTRAINT xcap_account_doc_type_idx UNIQUE (username, domain, doc_type, doc_uri) +); -CREATE INDEX source_idx ON xcap (source); +CREATE INDEX xcap_source_idx ON xcap (source); INSERT INTO version (table_name, table_version) values ('pua','6'); CREATE TABLE pua ( - id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, + id SERIAL PRIMARY KEY NOT NULL, pres_uri VARCHAR(128) NOT NULL, pres_id VARCHAR(255) NOT NULL, - event INT(11) NOT NULL, - expires INT(11) NOT NULL, - desired_expires INT(11) NOT NULL, - flag INT(11) NOT NULL, + event INTEGER NOT NULL, + expires INTEGER NOT NULL, + desired_expires INTEGER NOT NULL, + flag INTEGER NOT NULL, etag VARCHAR(64) NOT NULL, tuple_id VARCHAR(64), watcher_uri VARCHAR(128) NOT NULL, call_id VARCHAR(128) NOT NULL, to_tag VARCHAR(64) NOT NULL, from_tag VARCHAR(64) NOT NULL, - cseq INT(11) NOT NULL, + cseq INTEGER NOT NULL, record_route TEXT, contact VARCHAR(128) NOT NULL, remote_contact VARCHAR(128) NOT NULL, - version INT(11) NOT NULL, + version INTEGER NOT NULL, extra_headers TEXT NOT NULL -) ENGINE=MyISAM; +); [View Less]

1 0

git:master: core, srdb1, modules/db_*, modules_k/db_*: Added support for configuring SQL buffer size and mediumblob/ mediumtext in MySQL
by Peter Dunkley 29 Jul '11

29 Jul '11

Module: sip-router Branch: master Commit: 5cd87175faa97161023c37e2cc0f0c064e08d571 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=5cd8717… Author: pd <peter.dunkley(a)crocodile-rcs.com> Committer: pd <peter.dunkley(a)crocodile-rcs.com> Date: Wed Jul 27 11:50:20 2011 +0100 core, srdb1, modules/db_*, modules_k/db_*: Added support for configuring SQL buffer size and mediumblob/mediumtext in MySQL - Currently the SQL buffer size is hard-coded to 64k. … [View More]

1 0

new in devel wiki updates
by Daniel-Constantin Mierla 29 Jul '11

29 Jul '11

Hello, I can't be more happier than seeing many of you adding new features to master branch, however, this is a reminder to drop a short note about the relevant enhancements in the wiki page: http://sip-router.org/wiki/features/new-in-devel The wiki is open for everyone -- no need to register, just fill the captcha, or register and get rid of captcha. The wiki page is very useful to build the release notes as well as to let people know what is new during the development phase and get … [View More]

2 1

git:pd/crocodile: module_k/rls: Added support for resource-list indices.
by Peter Dunkley 29 Jul '11

29 Jul '11

Module: sip-router Branch: pd/crocodile Commit: 81ee00f531c1148e5077f81c5ece3094136bc8f0 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=81ee00f… Author: pd <peter.dunkley(a)crocodile-rcs.com> Committer: pd <peter.dunkley(a)crocodile-rcs.com> Date: Thu Jul 28 12:35:03 2011 +0100 module_k/rls: Added support for resource-list indices. - That is, support for resource lists that contain references to other resource lists. - This is needed for OMA/RCS … [View More]

3 6

git:pd/crocodile: core: removing SQL buffer size stuff from doc/cfg_list/ docbook/cfg_core.xml
by Peter Dunkley 29 Jul '11

29 Jul '11

Module: sip-router Branch: pd/crocodile Commit: c50367e242afb64352b55bf1eb0959caf594d058 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=c50367e… Author: pd <peter.dunkley(a)crocodile-rcs.com> Committer: pd <peter.dunkley(a)crocodile-rcs.com> Date: Fri Jul 29 12:19:10 2011 +0100 core: removing SQL buffer size stuff from doc/cfg_list/docbook/cfg_core.xml --- doc/cfg_list/docbook/cfg_core.xml | 12 ------------ 1 files changed, 0 insertions(+), 12 … [View More]

1 0

git:pd/crocodile: module_k/xcap_server: Added support HTTP 1. 1 pre-conditions (If-Match: and If-None-Match:)
by Peter Dunkley 29 Jul '11

29 Jul '11

Module: sip-router Branch: pd/crocodile Commit: d38e225fbb91128d127770126a42f47d21e238c2 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=d38e225… Author: pd <peter.dunkley(a)crocodile-rcs.com> Committer: pd <peter.dunkley(a)crocodile-rcs.com> Date: Fri Jul 29 11:56:14 2011 +0100 module_k/xcap_server: Added support HTTP 1.1 pre-conditions (If-Match: and If-None-Match:) - Also fixed the ETag: header send by xcap_server as it should be a quoted-string … [View More]

1 0

git:pd/crocodile: Merge branch 'master' into pd
by Peter Dunkley 29 Jul '11

29 Jul '11

Module: sip-router Branch: pd/crocodile Commit: f0784ecd899eb486e39bce2973a07225ba5d9cf6 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=f0784ec… Author: pd <peter.dunkley(a)crocodile-rcs.com> Committer: pd <peter.dunkley(a)crocodile-rcs.com> Date: Fri Jul 29 11:44:56 2011 +0100 Merge branch 'master' into pd * master: core: fix all reported doxygen errors in PV and value evaluation code tls: restrict visibility of 4 only internal used functions … [View More]

1 0

git:pd/crocodile: core, srdb1, modules/db_*, modules_k/db_*: Added support for configuring SQL buffer size and mediumblob/ mediumtext in MySQL
by Peter Dunkley 29 Jul '11

29 Jul '11

Module: sip-router Branch: pd/crocodile Commit: 5cd87175faa97161023c37e2cc0f0c064e08d571 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=5cd8717… Author: pd <peter.dunkley(a)crocodile-rcs.com> Committer: pd <peter.dunkley(a)crocodile-rcs.com> Date: Wed Jul 27 11:50:20 2011 +0100 core, srdb1, modules/db_*, modules_k/db_*: Added support for configuring SQL buffer size and mediumblob/mediumtext in MySQL - Currently the SQL buffer size is hard-coded to … [View More]

2 2

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

sr-dev July 2011