User Tools

Site Tools


install:upgrade:3.3.x-to-4.0.0

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
install:upgrade:3.3.x-to-4.0.0 [2013/01/23 14:44]
miconda [MySQL - Updates to old database tables]
install:upgrade:3.3.x-to-4.0.0 [2014/09/23 11:35] (current)
klaus3000 syntax higlighting automatically writes reserved words in capital letters
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. 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).   * 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. 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 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 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 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 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 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 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 UNIQUE ruid_idx (ruid);
 ALTER TABLE location ADD INDEX expires_idx (expires); 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_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) 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 DROP INDEX tmp_dlg1_idx; # was INDEX (call_id,from_tag)
 ALTER TABLE pua ADD INDEX record_idx (pres_id); 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 rls_watchers DROP INDEX rls_watchers_delete; # was INDEX (callid,to_tag)
 +
 ALTER TABLE version ADD UNIQUE table_name_idx (table_name); ALTER TABLE version ADD UNIQUE table_name_idx (table_name);
  
Line 46: Line 57:
   ruid varchar(64) NOT NULL DEFAULT '',   ruid varchar(64) NOT NULL DEFAULT '',
   username varchar(64) NOT NULL DEFAULT '',   username varchar(64) NOT NULL DEFAULT '',
-  domain varchar(64) DEFAULT NULL,+  `domainvarchar(64) DEFAULT NULL,
   aname varchar(64) NOT NULL DEFAULT '',   aname varchar(64) NOT NULL DEFAULT '',
   atype int(11) NOT NULL DEFAULT '0',   atype int(11) NOT NULL DEFAULT '0',
Line 71: 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. 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 ( CREATE TABLE sca_subscriptions (
   id int(10) unsigned NOT NULL AUTO_INCREMENT,   id int(10) unsigned NOT NULL AUTO_INCREMENT,
Line 177: Line 188:
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1; ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 </code> </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
install/upgrade/3.3.x-to-4.0.0.1358948676.txt.gz · Last modified: 2013/01/23 14:44 by miconda