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 [2016/02/28 12:44] miconda [Database] |
install:upgrade:stable-to-devel [2017/02/26 23:49] miconda [MySQL Database Structure] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== Upgrade Kamailio from v4.3.x to v4.4.0 (devel) ====== | + | ====== Upgrade Kamailio from v4.4.x to v5.0.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.0.0 compared with what existed in v4.4.x. It does not include the brand new modules, focusing on how to upgrade database and configuration file from v4.4.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 18: | Line 18: | ||
===== Modules ===== | ===== Modules ===== | ||
+ | |||
+ | ==== Removed Modules ==== | ||
+ | |||
+ | === mi_datagram === | ||
+ | |||
+ | The **jsonrpcs** module can be used instead to execute RPC commands over datagram sockets (unix socket file, IPv4 or IPv6). | ||
+ | |||
+ | === mi_fifo === | ||
+ | |||
+ | The **jsonrpcs** module can be used instead to execute RPC commands over a FIFO file. | ||
+ | |||
+ | === mi_xmlrpc === | ||
+ | |||
+ | The **xmlrpc** module can be used instead to execute RPC commands over HTTP/S XMLRPC. | ||
+ | |||
+ | === pua_mi === | ||
+ | |||
+ | The **pua_rpc** module can be used instead to trigger presence PUBLISH or SUBSCRIBE requests via RPC commands. | ||
+ | |||
+ | ==== Renamed Modules ==== | ||
+ | |||
+ | The module that had a ' | ||
+ | |||
+ | * cpl-c => cplc | ||
+ | * janssonrpc-c => jsonrpcc | ||
+ | * jsonrpc-c => jsonrpcc | ||
+ | * jsonrpc-s => jsonrpcs | ||
+ | ===== Internal Libraries ===== | ||
+ | |||
+ | ==== kcore ==== | ||
+ | |||
+ | The library has been removed. | ||
+ | |||
+ | Parts of its code have been removed or merged into other components. | ||
+ | |||
+ | ==== kmi ==== | ||
+ | |||
+ | The library has been removed. | ||
+ | |||
+ | The entire Management Interface (MI) code was removed. Instead of MI commands use RPC commands. The tool **kamctl** is using now RPC commands via **jsonrpcs** module. | ||
===== Core ===== | ===== Core ===== | ||
Line 25: | Line 65: | ||
===== Database ===== | ===== Database ===== | ||
- | There are quite minimal changes to the database structure, in short: | ||
- | * presence active_watchers table has new columns | ||
- | * permissions trusted table has new columns | ||
- | * uac uacreg table has new columns | ||
==== MySQL Database Structure ==== | ==== MySQL Database Structure ==== | ||
- | Run following SQL statements in MySQL client to upgrade database structure from v4.3 to v4.4: | + | Run following SQL statements in MySQL client to upgrade database structure from v4.4 to v5.0: |
<code sql> | <code sql> | ||
- | -- table: active_watchers | ||
- | ALTER TABLE active_watchers | ||
- | ADD COLUMN flags int(11) NOT NULL DEFAULT ' | ||
- | ADD COLUMN user_agent varchar(255) NOT NULL; | ||
- | DELETE FROM version WHERE TABLE_NAME=' | ||
- | INSERT INTO version (`table_name`, | ||
- | -- table: | + | --table: |
- | ALTER TABLE trusted | + | ALTER TABLE dialplan CHANGE COLUMN repl_exp repl_exp varchar(256) NOT NULL; -- was varchar(64) NOT NULL |
- | ADD COLUMN | + | |
- | ADD COLUMN | + | --table: sca_subscriptions |
- | CHANGE COLUMN | + | ALTER TABLE sca_subscriptions |
- | DELETE FROM version WHERE TABLE_NAME='trusted'; | + | ALTER TABLE sca_subscriptions DROP INDEX sca_expires_idx; |
- | INSERT INTO version | + | ALTER TABLE sca_subscriptions |
+ | UPDATE version SET table_version=2 WHERE table_name=" | ||
+ | |||
+ | --table: subscriber | ||
+ | ALTER TABLE subscriber CHANGE | ||
+ | ALTER TABLE subscriber | ||
+ | ALTER TABLE subscriber CHANGE COLUMN password password varchar(64) NOT NULL DEFAULT | ||
+ | ALTER TABLE subscriber CHANGE COLUMN ha1 ha1 varchar(128) NOT NULL DEFAULT ''; | ||
+ | ALTER TABLE subscriber CHANGE COLUMN ha1b ha1b varchar(128) NOT NULL DEFAULT | ||
+ | UPDATE version SET table_version=7 WHERE table_name=" | ||
- | -- table: uacreg | ||
- | ALTER TABLE uacreg | ||
- | ADD COLUMN reg_delay int(11) NOT NULL DEFAULT ' | ||
- | ADD COLUMN flags int(11) NOT NULL DEFAULT ' | ||
- | DELETE FROM version WHERE TABLE_NAME=' | ||
- | INSERT INTO version (`table_name`, | ||
+ | --table: uacreg | ||
+ | ALTER TABLE uacreg CHANGE COLUMN auth_proxy auth_proxy varchar(128) NOT NULL DEFAULT ''; | ||
+ | ALTER TABLE uacreg CHANGE COLUMN l_domain l_domain varchar(64) NOT NULL DEFAULT ''; | ||
+ | ALTER TABLE uacreg CHANGE COLUMN r_domain r_domain varchar(64) NOT NULL DEFAULT ''; | ||
+ | ALTER TABLE uacreg ADD COLUMN auth_ha1 varchar(128) NOT NULL DEFAULT ''; | ||
+ | UPDATE version SET table_version=3 WHERE table_name=" | ||
</ | </ |