User Tools
install:upgrade:stable-to-devel
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
install:upgrade:stable-to-devel [2015/04/27 09:36] linuxmaniac [Upgrade Old MySQL Database Structure] |
install:upgrade:stable-to-devel [2020/07/17 08:40] miconda [Upgrade Kamailio from v5.5.x to v5.5.0 (devel)] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== Upgrade Kamailio from v4.2.x to v4.3.0 (devel) ====== | + | ====== Upgrade Kamailio from v5.4.x to v5.5.0 (devel) ====== |
| - | The page contains the details about the changes that were made to old components during the development of v4.3.0 compared with what existed in v4.2.x. It does not include the brand new modules, focusing on how to upgrade database and configuration file from v4.2.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.4.0 compared with what existed in v5.3.x. It does not include the brand new modules, focusing on how to upgrade database and configuration file from v5.3.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: | + | * [[install: |
| ===== 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 ===== | ||
| - | ==== rtpengine ==== | ||
| - | * rtpengine_tout parameter was replaced by rtpengine_tout_ms (CPM) | + | ==== Upgraded Modules ==== |
| - | ==== siptrace ==== | + | * none |
| - | * added totag field to sip_trace table | + | ==== Removed Modules ==== |
| - | * increased sip_trace table version to 4 | + | |
| - | ===== Core ===== | + | * none |
| - | ==== Parameters | + | ==== Renamed Modules |
| - | ===== Database ===== | + | * none |
| - | ==== MySQL Database Structure | + | ===== Internal Libraries ===== |
| - | There are several changes to the database structure, in short: | ||
| - | * location table has three new columns: server_id, connection_id, | + | ===== Core ===== |
| - | * presentity table has a new column: priority | + | |
| - | * sip_trace table has a new column: totag | + | |
| - | * silo table changed defaults: body and extra_hdrs have no default. BLOB or TEXT have no default. ( See https:// | + | |
| - | * acc_cdrs table uses proper data types for: start_time, end_time, duration. acc_cdrs needs to be empty due to this change. | + | |
| - | ==== Upgrade Old MySQL Database Structure | + | |
| - | Run following SQL statements in MySQL client to upgrade database structure from v4.2 to v4.3: | + | ==== Parameters ==== |
| - | <code sql> | + | ==== Misc ==== |
| - | -- table: location | + | |
| - | ALTER TABLE location ADD COLUMN server_id INT(11) DEFAULT 0 NOT NULL; | + | |
| - | ALTER TABLE location ADD COLUMN connection_id INT(11) DEFAULT 0 NOT NULL; | + | |
| - | ALTER TABLE location ADD COLUMN keepalive INT(11) DEFAULT 0 NOT NULL; | + | |
| - | DELETE FROM version WHERE table_name=' | + | |
| - | INSERT INTO version (`table_name`, | + | |
| - | -- table: presentity | + | ===== Database ===== |
| - | ALTER TABLE presentity ADD COLUMN priority INT(11) DEFAULT 0 NOT NULL; | + | |
| - | DELETE FROM version WHERE table_name=' | + | |
| - | INSERT INTO version (`table_name`, | + | |
| - | -- table: sip_trace | ||
| - | ALTER TABLE sip_trace ADD COLUMN totag VARCHAR(64) DEFAULT '' | ||
| - | UPDATE version SET table_version=' | ||
| - | -- table: acc_cdrs | + | ==== MySQL Database Structure ==== |
| - | -- For previous values | + | |
| - | -- STRING -> DATETIME ?? | + | |
| - | -- STRING -> FLOAT ?? | + | |
| - | ALTER TABLE acc_cdrs MODIFY COLUMN start_time DATETIME DEFAULT ' | + | |
| - | ALTER TABLE acc_cdrs MODIFY COLUMN end_time DATETIME DEFAULT ' | + | |
| - | ALTER TABLE acc_cdrs MODIFY COLUMN duration FLOAT(10,3) DEFAULT 0 NOT NULL; | + | |
| - | UPDATE version SET table_version=' | + | |
| - | -- table: silo | + | Run following SQL statements in MySQL client to upgrade database structure from v5.4 to v5.5: |
| - | ALTER TABLE silo ALTER COLUMN body DROP DEFAULT; | + | |
| - | ALTER TABLE silo ALTER COLUMN extra_hdrs DROP DEFAULT; | + | |
| - | UPDATE version SET table_version=' | + | |
| + | <code sql> | ||
| + | ... | ||
| </ | </ | ||
install/upgrade/stable-to-devel.txt · Last modified: 2022/04/15 08:39 by miconda
Page Tools
