Differences

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

--- install:upgrade:3.3.x-to-4.0.0 [2013/01/23 13:37] – created miconda
+++ install:upgrade:3.3.x-to-4.0.0 [2014/09/23 09:35] (current) – syntax higlighting automatically writes reserved words in capital letters klaus3000
@@ Line 7: / Line 7: @@
 These sections presents notes, listed by modules, about changes that need to be made to Kamailio configuration file when upgrading from Kamailio v3.3.x to devel.
-==== modules/tm ====
+==== kex ====
+  * km_append_branch() has been replaced with append_branch() from **corex** module
+==== tm ====
   * Changed value of module parameter contacts_avp from AVP definition to XAVP name (string).
@@ Line 19: / Line 23: @@
 Next are the SQL statements that must be executed to get the database structure required by modules that existed in v3.3.x.
-<code sql>
+<code ->
-ALTER TABLE active_watchers DROP INDEX active_watchers_pres; # was INDEX (presentity_uri)
-ALTER TABLE active_watchers ADD INDEX active_watchers_pres (presentity_uri,event);
 ALTER TABLE address CHANGE COLUMN ip_addr ip_addr varchar(50) NOT NULL; # was varchar(48) NOT NULL
 ALTER TABLE aliases CHANGE COLUMN expires expires datetime NOT NULL DEFAULT '2030-05-28 21:32:15'; # was datetime NOT NULL DEFAULT '2020-05-28 21:32:15'
 ALTER TABLE aliases ADD UNIQUE ruid_idx (ruid);
 ALTER TABLE lcr_gw CHANGE COLUMN ip_addr ip_addr varchar(50) DEFAULT NULL; # was varchar(47) DEFAULT NULL
 ALTER TABLE location CHANGE COLUMN path path varchar(512) DEFAULT NULL; # was varchar(128) DEFAULT NULL
 ALTER TABLE location CHANGE COLUMN expires expires datetime NOT NULL DEFAULT '2030-05-28 21:32:15'; # was datetime NOT NULL DEFAULT '2020-05-28 21:32:15'
 ALTER TABLE location ADD UNIQUE ruid_idx (ruid);
 ALTER TABLE location ADD INDEX expires_idx (expires);
+ALTER TABLE active_watchers DROP INDEX active_watchers_pres; # was INDEX (presentity_uri)
+ALTER TABLE active_watchers ADD INDEX active_watchers_pres (presentity_uri,event);
 ALTER TABLE pua DROP INDEX tmp_record2_idx; # was INDEX (pres_id,etag)
 ALTER TABLE pua DROP INDEX tmp_dlg2_idx; # was INDEX (pres_id,pres_uri,call_id,from_tag)
@@ Line 39: / Line 48: @@
 ALTER TABLE pua DROP INDEX tmp_dlg1_idx; # was INDEX (call_id,from_tag)
 ALTER TABLE pua ADD INDEX record_idx (pres_id);
 ALTER TABLE rls_watchers DROP INDEX rls_watchers_delete; # was INDEX (callid,to_tag)
 ALTER TABLE version ADD UNIQUE table_name_idx (table_name);
-INSERT INTO version (table_name, table_version) values ('location_attrs','1');
 CREATE TABLE location_attrs (
   id int(10) unsigned NOT NULL AUTO_INCREMENT,
   ruid varchar(64) NOT NULL DEFAULT '',
   username varchar(64) NOT NULL DEFAULT '',
-  domain varchar(64) DEFAULT NULL,
+  `domain` varchar(64) DEFAULT NULL,
   aname varchar(64) NOT NULL DEFAULT '',
   atype int(11) NOT NULL DEFAULT '0',
@@ Line 55: / Line 66: @@
   KEY last_modified_idx (last_modified)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+INSERT INTO version (table_name, table_version) values ('location_attrs','1');
+DELETE FROM version WHERE table_name='address';
+INSERT INTO version (table_name, table_version) values ('address','6');
+DELETE FROM version WHERE table_name='lcr_gw';
+INSERT INTO version (table_name, table_version) values ('lcr_gw','3');
+DELETE FROM version WHERE table_name='aliases';
+INSERT INTO version (table_name, table_version) values ('aliases','6');
+DELETE FROM version WHERE table_name='location';
+INSERT INTO version (table_name, table_version) values ('location','6');
 </code>
@@ Line 61: / Line 82: @@
 Next are the SQL statements that must be executed to get the database structure required by new modules added in v4.0.0.
-<code sql>
+<code ->
 CREATE TABLE sca_subscriptions (
   id int(10) unsigned NOT NULL AUTO_INCREMENT,
@@ Line 167: / Line 188: @@
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 </code>
+===== SER Modules =====
+SER modules that had no equivalent in Kamailio were moved to **modules/** folder. Several of them were renamed:
+  * auth_db => uid_auth_db
+  * avp_db => uid_auth_db
+  * domain => uid_domain
+  * gflags => uid_gflags
+  * uri_db => uid_uri_db