User Tools

Site Tools


install:upgrade:4.3.x-to-4.4.0

Differences

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

Link to this comparison view

Next revision
Previous revision
install:upgrade:4.3.x-to-4.4.0 [2016/03/28 23:22]
miconda created
install:upgrade:4.3.x-to-4.4.0 [2016/09/07 22:47] (current)
giacomo.vacca [Postgres Database Structure]
Line 1: Line 1:
-====== Upgrade Kamailio from v4.3.x to v4.4.0 (devel) ======+====== Upgrade Kamailio from v4.3.x to v4.4.0 ======
  
 The page contains the details about the changes that were made to old components during the development of v4.4.0 compared with what existed in v4.3.x. It does not include the brand new modules, focusing on how to upgrade database and configuration file from v4.3.x to run with Kamailio devel. The page contains the details about the changes that were made to old components during the development of v4.4.0 compared with what existed in v4.3.x. It does not include the brand new modules, focusing on how to upgrade database and configuration file from v4.3.x to run with Kamailio devel.
Line 18: Line 18:
  
 ===== Modules ===== ===== Modules =====
 +
 +==== ims_dialog ====
 +
 +The **dialog-ng** module was renamed to **ims_dialog**.
 +
 +The modparams statements in your configuration file must be updated to reflect the new name of the module.
 +
 +<code c>
 +# old version
 +modparam("dialog-ng", ...)
 +
 +# new version
 +modparam("ims_dialog", ...)
 +</code>
 +
 +The functions for routing blocks are the same, no changes are required there.
  
 ===== Core ===== ===== Core =====
  
 ==== Parameters ==== ==== Parameters ====
 +
 +=== fork ===
 +
 +(INF) This is just heads up notification that the **fork** parameter is planned to be refactored in the next version, because **fork=no** disables many features without explicit visibility (e.g., no tcp/tls, only listening on first network interface). The value **fork=yes** will preserve existing behaviour.
  
 ===== Database ===== ===== Database =====
Line 39: Line 59:
 ALTER TABLE active_watchers ALTER TABLE active_watchers
   ADD COLUMN flags int(11) NOT NULL DEFAULT '0',   ADD COLUMN flags int(11) NOT NULL DEFAULT '0',
-  ADD COLUMN user_agent varchar(255) NOT NULL;+  ADD COLUMN user_agent varchar(255) DEFAULT '' NOT NULL;
 DELETE FROM version WHERE TABLE_NAME='active_watchers'; DELETE FROM version WHERE TABLE_NAME='active_watchers';
 INSERT INTO version (`table_name`, `table_version`) VALUES ('active_watchers','12'); INSERT INTO version (`table_name`, `table_version`) VALUES ('active_watchers','12');
  
 -- table: trusted -- table: trusted
-ALTER TABLE trusted+ALTER TABLE `trusted`
   ADD COLUMN priority int(11) NOT NULL DEFAULT '0',   ADD COLUMN priority int(11) NOT NULL DEFAULT '0',
   ADD COLUMN ruri_pattern varchar(64) NULL,   ADD COLUMN ruri_pattern varchar(64) NULL,
Line 58: Line 78:
 INSERT INTO version (`table_name`, `table_version`) VALUES ('uacreg','2'); INSERT INTO version (`table_name`, `table_version`) VALUES ('uacreg','2');
  
 +
 +</code>
 +
 +
 +
 +==== Postgres Database Structure ====
 +Run following SQL statements in psql client to upgrade database structure from v4.3 to v4.4:
 +
 +<code sql>
 +-- table: active_watchers
 +ALTER TABLE active_watchers ADD COLUMN flags INTEGER DEFAULT 0 NOT NULL;
 +ALTER TABLE active_watchers ADD COLUMN user_agent VARCHAR(255) DEFAULT '' NOT NULL;
 +DELETE FROM version WHERE TABLE_NAME='active_watchers';
 +INSERT INTO version (TABLE_NAME, table_version) VALUES ('active_watchers','12');
 +
 +-- table: trusted
 +ALTER TABLE trusted ADD COLUMN priority INTEGER DEFAULT 0 NOT NULL;
 +ALTER TABLE trusted ADD COLUMN ruri_pattern VARCHAR(64) NULL;
 +ALTER TABLE trusted ALTER COLUMN tag TYPE VARCHAR(64);
 +DELETE FROM version WHERE TABLE_NAME='trusted';
 +INSERT INTO version (TABLE_NAME, table_version) VALUES ('trusted','6');
 +
 +-- table: uacreg
 +ALTER TABLE uacreg ADD COLUMN reg_delay INTEGER DEFAULT 0 NOT NULL;
 +ALTER TABLE uacreg ADD COLUMN flags INTEGER DEFAULT 0 NOT NULL;
 +DELETE FROM version WHERE TABLE_NAME='uacreg';
 +INSERT INTO version (TABLE_NAME, table_version) VALUES ('uacreg','2');
  
 </code> </code>
install/upgrade/4.3.x-to-4.4.0.1459200122.txt.gz ยท Last modified: 2016/03/28 23:22 by miconda