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:22]
miconda [Remarks]
+++ install:upgrade:4.1.x-to-4.2.0 [2015/10/09 13:09] (current)
klaus3000
@@ 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