User Tools

Site Tools


install:upgrade:4.1.x-to-4.2.0

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
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)   * parameter failure_reply_mode is set to 3 (CPM)
 +
 +==== auth_db ====
 +
 +  * load_credentials default value is now "" instead of "rpid". (CPM)
  
 ===== Core ===== ===== Core =====
Line 76: Line 80:
  
 </code> </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>
 +
install/upgrade/4.1.x-to-4.2.0.1413282138.txt.gz ยท Last modified: 2014/10/14 12:22 by miconda