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:21]
miconda [Upgrade Kamailio from v4.1.x to v4.2.0]
+++ install:upgrade:4.1.x-to-4.2.0 [2015/10/09 13:09] (current)
klaus3000
@@ Line 19: / 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 33: / 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 76: / 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