User Tools

Site Tools


install:upgrade:stable-to-devel

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
Next revision Both sides next revision
install:upgrade:stable-to-devel [2016/02/28 12:42]
miconda [MySQL Database Structure]
install:upgrade:stable-to-devel [2018/08/14 09:56]
miconda [Parameters]
Line 1: Line 1:
-====== Upgrade Kamailio from v4.3.x to v4.4.0 (devel) ======+====== Upgrade Kamailio from v5.1.x to v5.2.0 (devel) ======
  
-The page contains the details about the changes that were made to old components during the development of v4.4.0 compared with what existed in v4.3.x. It does not include the brand new modules, focusing on how to upgrade database and configuration file from v4.3.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.2.0 compared with what existed in v5.1.x. It does not include the brand new modules, focusing on how to upgrade database and configuration file from v5.1.x to run with Kamailio devel.
  
 ===== Previous Stable Release ===== ===== Previous Stable Release =====
Line 7: Line 7:
 If you look for the guidelines to upgrade to previous stable release, see: If you look for the guidelines to upgrade to previous stable release, see:
  
-  * [[install:upgrade:4.2.x-to-4.3.0|Upgrade Kamailio v4.2.x to v4.3.0]]+  * [[install:upgrade:5.0.x-to-5.1.0|Upgrade Kamailio v5.0.x to v5.1.0]]
  
 ===== Remarks ===== ===== Remarks =====
Line 16: Line 16:
   * CPM - the change was used with the new value via explicit parameter in default config file from old releases   * CPM - the change was used with the new value via explicit parameter in default config file from old releases
   * RCM - the change is recommended to be done if you had an explicit different or lower value for this parameter in old config   * RCM - the change is recommended to be done if you had an explicit different or lower value for this parameter in old config
 +  * UPG - the change has to be done, older config does not work any longer
  
 ===== Modules ===== ===== Modules =====
 +
 +==== Upgraded Modules ====
 +
 +=== dispatcher ===
 +
 +UPG: Several parameters that were used to specify AVP names were removed, you have to remove the appropriate config modparams:
 +
 +<code c>
 +modparam("dispatcher", "dst_avp", "$avp(AVP_DST)")
 +modparam("dispatcher", "grp_avp", "$avp(AVP_GRP)")
 +modparam("dispatcher", "cnt_avp", "$avp(AVP_CNT)")
 +modparam("dispatcher", "sock_avp", "$avp(AVP_SOCK)")
 +modparam("dispatcher", "attrs_avp", "$avp(AVP_ATTRS)")
 +</code>
 +
 +Starting with v5.2.0, the module is using XAVPs instead of those AVPs, the related parameters are:
 +
 +  * xavp_dst
 +  * xavp_dst_mode
 +  * xavp_ctx
 +  * xavp_ctx_mode
 +
 +See: https://www.kamailio.org/docs/modules/devel/modules/dispatcher.html
 +
 +
 +==== Removed Modules ====
 +
 +  * none
 +
 +==== Renamed Modules ====
 +
 +  * none
 +
 +===== Internal Libraries =====
 +
  
 ===== Core ===== ===== Core =====
Line 23: Line 59:
 ==== Parameters ==== ==== Parameters ====
  
-===== Database =====+==== Misc ====
  
-==== MySQL Database Structure ====+=== Log Messages ===
  
-=== Upgrade Old MySQL Database Structure ===+The order of the attributes printed in the log messages was changed to have the log level first -- it was:
  
 +<code>
 +$log-prefix $log-level $log-message
 +</code>
  
-Run following SQL statements in MySQL client to upgrade database structure from v4.3 to v4.4:+Now it is:
  
-<code sql+<code> 
--- table: active_watchers +$log-level $log-prefix $log-message 
-ALTER TABLE active_watchers +</code> 
-  ADD COLUMN flags int(11) NOT NULL DEFAULT '0', +===== Database =====
-  ADD COLUMN user_agent varchar(255) NOT NULL; +
-DELETE FROM version WHERE TABLE_NAME='active_watchers'; +
-INSERT INTO version (`table_name`, `table_version`) VALUES ('active_watchers','12');+
  
--- table: trusted 
-ALTER TABLE trusted 
-  ADD COLUMN priority int(11) NOT NULL DEFAULT '0', 
-  ADD COLUMN ruri_pattern varchar(64) NULL, 
-  CHANGE COLUMN tag tag varchar(64) NULL; 
-DELETE FROM version WHERE TABLE_NAME='trusted'; 
-INSERT INTO version (`table_name`, `table_version`) VALUES ('trusted','6'); 
  
--- table: uacreg +==== MySQL Database Structure ====
-ALTER TABLE uacreg +
-  ADD COLUMN reg_delay int(11) NOT NULL DEFAULT '0', +
-  ADD COLUMN flags int(11) NOT NULL DEFAULT '0'; +
-DELETE FROM version WHERE TABLE_NAME='uacreg'; +
-INSERT INTO version (`table_name`, `table_version`) VALUES ('uacreg','2');+
  
 +Run following SQL statements in MySQL client to upgrade database structure from v5.1 to v5.2:
  
 +<code sql>
 +ALTER TABLE presentity ADD COLUMN ruid VARCHAR(64);
 +CREATE UNIQUE INDEX ruid_idx ON presentity (ruid);
 +UPDATE version SET table_version=5 WHERE table_name='presentity';
 </code> </code>
install/upgrade/stable-to-devel.txt · Last modified: 2022/04/15 08:39 by miconda