Differences

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

--- install:upgrade:4.1.x-to-4.2.0 [2014/10/14 12:19]
miconda
+++ install:upgrade:4.1.x-to-4.2.0 [2015/10/09 13:09] (current)
klaus3000
@@ Line 1: / Line 1: @@
 ====== Upgrade Kamailio from v4.1.x to v4.2.0 ======
-The page contains the details about the changes that were made to old components during the development of v4.2.0 compared with what existed in v4.1.x. It does not include the brand new modules, focusing on how to upgrade database and configuration file from v4.1.x to run with Kamailio 4.2.x.
+The page contains the details about the changes that were made to old components during the development of v4.2.0 compared with what existed in v4.1.x.
+It does not include the brand new modules, focusing on how to upgrade database and configuration file from v4.1.x to run with Kamailio 4.2.x.
+The draft with what is new in release 4.2.x is available at:
+  * [[features:new-in-4.2.x|New Features in Release 4.2.x]]
 ===== Previous Stable Release =====
@@ Line 13: / Line 19: @@
 Following tokens are used to mark the changes:
-  * INF - the change doesn't really have any direct impact - no action required in old config
+  * INF - the change doesn't really have any direct impact to config content - no action required in old config
   * 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
@@ Line 27: / Line 33: @@
   * parameter failure_reply_mode is set to 3 (CPM)
+==== auth_db ====
+  * load_credentials default value is now "" instead of "rpid". (CPM)
 ===== Core =====
@@ Line 70: / Line 80: @@
 </code>
+==== Upgrade Old Postgresql Database Structure ====
+Run following SQL statements in psql client to upgrade database structure from v4.1 to v4.2:
+<code sql>
+-- table: acc
+ALTER TABLE acc ALTER COLUMN sip_reason TYPE VARCHAR(128);
+DELETE FROM version WHERE TABLE_NAME='acc';
+INSERT INTO version (`table_name`, `table_version`) VALUES ('acc','5');
+-- table: dialplan
+ALTER TABLE dialplan ALTER COLUMN repl_exp TYPE VARCHAR(64);
+ALTER TABLE dialplan ALTER COLUMN attrs TYPE VARCHAR(64);
+DELETE FROM version WHERE TABLE_NAME='dialplan';
+INSERT INTO version (table_name, table_version) VALUES ('dialplan','2');
+-- table: missed_calls
+ALTER TABLE missed_calls ALTER COLUMN sip_reason TYPE VARCHAR(128);
+DELETE FROM version WHERE TABLE_NAME='missed_calls';
+INSERT INTO version (table_name, table_version) VALUES ('missed_calls','4');
+</code>

Kamailio SIP Server Wiki

User Tools

Site Tools

Differences

Page Tools