[sr-dev] git:master: utils/kamctl/presence-create. sql Increased size of contact and callid in presence tables
Daniel-Constantin Mierla
miconda at gmail.com
Wed Apr 27 12:18:47 CEST 2011
You should change first the xml files defining the tables located in
lib/srdb1/schema/
Then run 'make dbschema' to regenerate the sql files.
Cheers,
Daniel
On 4/27/11 11:07 AM, Marius Zbihlei wrote:
> Module: sip-router
> Branch: master
> Commit: f2ffcfc6a74098b0df250771865c322c9502a643
> URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=f2ffcfc6a74098b0df250771865c322c9502a643
>
> Author: Marius Zbihlei<marius.zbihlei at 1and1.ro>
> Committer: Marius Zbihlei<marius.zbihlei at 1and1.ro>
> Date: Wed Apr 27 11:48:46 2011 +0300
>
> utils/kamctl/presence-create.sql Increased size of contact and callid in presence tables
>
> Some CPE (e.g. FritzBox,Samsung) issue larger contacts that 64 chars, thus resulting in a truncation in the
> DB backend
> (cherry picked from commit ac679cf5093f99931da6aeea4b40c1215e295a4b)
>
> ---
>
> utils/kamctl/mysql/presence-create.sql | 6 +++---
> 1 files changed, 3 insertions(+), 3 deletions(-)
>
> diff --git a/utils/kamctl/mysql/presence-create.sql b/utils/kamctl/mysql/presence-create.sql
> index 6af8d0a..b764976 100644
> --- a/utils/kamctl/mysql/presence-create.sql
> +++ b/utils/kamctl/mysql/presence-create.sql
> @@ -24,10 +24,10 @@ CREATE TABLE active_watchers (
> event_id VARCHAR(64),
> to_tag VARCHAR(64) NOT NULL,
> from_tag VARCHAR(64) NOT NULL,
> - callid VARCHAR(64) NOT NULL,
> + callid VARCHAR(128) NOT NULL,
> local_cseq INT(11) NOT NULL,
> remote_cseq INT(11) NOT NULL,
> - contact VARCHAR(64) NOT NULL,
> + contact VARCHAR(128) NOT NULL,
> record_route TEXT,
> expires INT(11) NOT NULL,
> status INT(11) DEFAULT 2 NOT NULL,
> @@ -79,7 +79,7 @@ CREATE TABLE pua (
> etag VARCHAR(64) NOT NULL,
> tuple_id VARCHAR(64),
> watcher_uri VARCHAR(128) NOT NULL,
> - call_id VARCHAR(64) 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,
>
>
> _______________________________________________
> sr-dev mailing list
> sr-dev at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
--
Daniel-Constantin Mierla
http://www.asipto.com
More information about the sr-dev
mailing list