– Kamailio SIP Server –

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
install:1.2.1-to-1.2.2 [2011/08/30 13:36]
92.112.174.164
install:1.2.1-to-1.2.2 [2012/03/22 13:38] (current)
80.250.1.245 removed spam
Line 1: Line 1:
 +====== Migrating OpenSER v1.2.1 to v1.2.2 ======
 +
 +This page is dedicated to the differences between versions 1.2.1 and 1.2.2 of OpenSER.
 +
 +<hi #​ffff00>​If you do not use presence module, then you don't need to do anything. All configuration files and database tables are compatible</​hi>​.
 +
 +===== Migrating Presence module =====
 +
 +The table "​active_watchers"​ has a new structure. To update it, follow the next instructions:​
 +
 +* stop openser
 +* login to your mysql server with mysql client, connect to "​openser"​ database and execute:
 +<​code>​
 +drop table active_watchers;​
 +DELETE FROM version WHERE table_name='​active_watchers';​
 +INSERT INTO version VALUES ( '​active_watchers',​ '​2'​);​
 +CREATE TABLE active_watchers (
 +  id int(10) NOT NULL auto_increment,​
 +  to_user varchar(64) NOT NULL,
 +  to_domain varchar(128) NOT NULL,
 +  from_user varchar(64) NOT NULL,
 +  from_domain varchar(128) NOT NULL,
 +  event varchar(64) NOT NULL default '​presence',​
 +  event_id varchar(64),​
 +  to_tag varchar(128) NOT NULL,
 +  from_tag varchar(128) NOT NULL,
 +  callid varchar(128) NOT NULL,
 +  local_cseq int(11) NOT NULL,
 +  remote_cseq int(11) NOT NULL,
 +  contact varchar(128) NOT NULL,
 +  record_route varchar(255),​
 +  expires int(11) NOT NULL,
 +  status varchar(32) NOT NULL default '​pending',​
 +  version int(11) default '​0',​
 +  PRIMARY KEY  (id),
 +  UNIQUE KEY tt_watchers (to_tag),
 +  KEY due_activewatchers (to_domain,​to_user,​event)
 +);
 +</​code>​
 +
 +* start openser