User Tools

Site Tools


install:upgrade:5.0.x-to-5.1.0

Differences

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

Link to this comparison view

Next revision
Previous revision
install:upgrade:5.0.x-to-5.1.0 [2017/11/18 17:02]
miconda created
install:upgrade:5.0.x-to-5.1.0 [2017/12/09 09:30] (current)
miconda [Removed Modules]
Line 1: Line 1:
 ====== Upgrade Kamailio from v5.0.x to v5.1.0 (stable) ====== ====== Upgrade Kamailio from v5.0.x to v5.1.0 (stable) ======
  
-The page contains the details about the changes that were made to old components during the development of v5.1.0 compared with what existed in v5.0.x. It does not include the brand new modules, focusing on how to upgrade database and configuration file from v5.0.x to run with Kamailio devel.+The page contains the details about the changes that were made to old components during the development of v5.1.0 compared with what existed in v5.0.x. It does not include the brand new modules, focusing on how to upgrade database and configuration file from v5.0.x to run with Kamailio v5.1.0.
  
 ===== Previous Stable Release ===== ===== Previous Stable Release =====
Line 21: Line 21:
 ==== Removed Modules ==== ==== Removed Modules ====
  
 +  * none
 ==== Renamed Modules ==== ==== Renamed Modules ====
  
 +  * **acc_diameter** has been split for **acc** module
 ===== Internal Libraries ===== ===== Internal Libraries =====
  
 +  * no major change that impacts the configuration file
 ===== Core ===== ===== Core =====
  
 ==== Parameters ==== ==== Parameters ====
  
 +  * no major change that impacts the configuration file
 ===== Database ===== ===== Database =====
  
 +  * increased size of dialplan table repl_exp field to 256 chars
 ==== MySQL Database Structure ==== ==== MySQL Database Structure ====
  
Line 41: Line 42:
 <code sql> <code sql>
 ALTER TABLE lcr_rule ADD COLUMN mt_tvalue VARCHAR(128) DEFAULT NULL AFTER request_uri; ALTER TABLE lcr_rule ADD COLUMN mt_tvalue VARCHAR(128) DEFAULT NULL AFTER request_uri;
-UPDATE version SET table_version='3WHERE table_name='lcr_rule';+UPDATE version SET table_version=3 WHERE table_name='lcr_rule';
 </code> </code>
  
 <code sql> <code sql>
 ALTER TABLE location MODIFY contact VARCHAR(512) NOT NULL DEFAULT ''; ALTER TABLE location MODIFY contact VARCHAR(512) NOT NULL DEFAULT '';
-UPDATE version SET table_version='9WHERE table_name='location';+UPDATE version SET table_version=9 WHERE table_name='location'
 +</code> 
 + 
 +<code sql> 
 +ALTER TABLE active_watchers CHANGE COLUMN reason reason varchar(64) DEFAULT NULL; -- # was varchar(64) NOT NULL 
 +ALTER TABLE domain_attrs DROP INDEX domain_attrs_idx; -- # was UNIQUE (did,name,value) 
 +ALTER TABLE domain_attrs ADD INDEX domain_attrs_idx (did,name); 
 +-- ALTER TABLE lcr_rule ADD COLUMN mt_tvalue varchar(128) DEFAULT NULL; 
 +-- ALTER TABLE location CHANGE COLUMN contact contact varchar(512) NOT NULL DEFAULT ''; # was varchar(255) NOT NULL DEFAULT '' 
 +ALTER TABLE topos_d ADD INDEX a_uuid_idx (a_uuid); 
 +ALTER TABLE topos_d ADD INDEX b_uuid_idx (b_uuid); 
 +ALTER TABLE topos_t ADD INDEX x_vbranch_idx (x_vbranch); 
 +ALTER TABLE topos_t ADD INDEX a_uuid_idx (a_uuid);
 </code> </code>
install/upgrade/5.0.x-to-5.1.0.1511020944.txt.gz · Last modified: 2017/11/18 17:02 by miconda