This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
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:08] klaus3000 |
||
---|---|---|---|
Line 19: | Line 19: | ||
Following tokens are used to mark the changes: | Following tokens are used to mark the changes: | ||
- | * INF - the change doesn' | + | * INF - the change doesn' |
* CPM - the change was used with the new value via explicit parameter in default config file from old releases | * 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 | * 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) | * parameter failure_reply_mode is set to 3 (CPM) | ||
+ | |||
+ | ==== auth_db ==== | ||
+ | |||
+ | * load_credentials default value is now "" | ||
===== Core ===== | ===== Core ===== | ||
Line 76: | Line 80: | ||
</ | </ | ||
+ | ==== Upgrade Old Postgresql Database Structure ==== | ||
+ | |||
+ | Run following SQL statements in psql client to upgrade database structure from v4.1 to v4.2: | ||
+ | |||
+ | < | ||
+ | -- table: acc | ||
+ | ALTER TABLE acc ALTER COLUMN sip_reason TYPE VARCHAR(128); | ||
+ | DELETE FROM version WHERE TABLE_NAME=' | ||
+ | INSERT INTO version (`table_name`, | ||
+ | |||
+ | -- 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=' | ||
+ | INSERT INTO version (table_name, | ||
+ | |||
+ | -- table: missed_calls | ||
+ | ALTER TABLE missed_calls ALTER COLUMN sip_reason TYPE VARCHAR(128); | ||
+ | DELETE FROM version WHERE TABLE_NAME=' | ||
+ | INSERT INTO version (table_name, | ||
+ | </ | ||
+ |