====== Upgrade Kamailio from v4.2.x to v4.3.0 ======
The page contains the details about the changes that were made to old components during the development of v4.3.0 compared with what existed in v4.2.x. It does not include the brand new modules, focusing on how to upgrade database and configuration file from v4.2.x to run with Kamailio devel.
===== Previous Stable Release =====
If you look for the guidelines to upgrade to previous stable release, see:
* [[install:upgrade:4.1.x-to-4.2.0|Upgrade Kamailio v4.1.x to v4.2.0]]
===== Remarks =====
Following tokens are used to mark the changes:
* INF - the change doesn't really have any direct impact - 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
===== Modules =====
==== ctl ====
* default path to control unix socket file is now: /var/run/kamailio/kamailio_ctl
==== mi_fifo ====
* default path to fifo file is now: /var/run/kamailio/kamailio_fifo
==== rtpengine ====
* rtpengine_tout parameter was replaced by rtpengine_tout_ms (CPM)
==== siptrace ====
* added totag field to sip_trace table
* increased sip_trace table version to 4
===== Core =====
==== Parameters ====
===== Database =====
==== MySQL Database Structure ====
There are several changes to the database structure, in short:
* location (aliases) table has three new columns: server_id, connection_id, keepalive
* presentity table has a new column: priority
* sip_trace table has a new column: totag
* silo table changed defaults: body and extra_hdrs have no default. BLOB or TEXT have no default. ( See https://dev.mysql.com/doc/refman/5.5/en/blob.html )
* acc_cdrs table uses proper data types for: start_time, end_time, duration. acc_cdrs needs to be empty due to this change.
==== Upgrade Old MySQL Database Structure ====
Run following SQL statements in MySQL client to upgrade database structure from v4.2 to v4.3:
-- table: location
ALTER TABLE location ADD COLUMN `server_id` INT(11) DEFAULT 0 NOT NULL;
ALTER TABLE location ADD COLUMN `connection_id` INT(11) DEFAULT 0 NOT NULL;
ALTER TABLE location ADD COLUMN `keepalive` INT(11) DEFAULT 0 NOT NULL;
ALTER TABLE location ADD COLUMN `partition` INT(11) DEFAULT 0 NOT NULL;
DELETE FROM version WHERE table_name='location';
INSERT INTO version (`table_name`, `table_version`) values ('location','8');
-- table: aliases
ALTER TABLE aliases ADD COLUMN `server_id` INT(11) DEFAULT 0 NOT NULL;
ALTER TABLE aliases ADD COLUMN `connection_id` INT(11) DEFAULT 0 NOT NULL;
ALTER TABLE aliases ADD COLUMN `keepalive` INT(11) DEFAULT 0 NOT NULL;
ALTER TABLE aliases ADD COLUMN `partition` INT(11) DEFAULT 0 NOT NULL;
DELETE FROM version WHERE table_name='aliases';
INSERT INTO version (`table_name`, `table_version`) values ('aliases','8');
-- table: presentity
ALTER TABLE presentity ADD COLUMN `priority` INT(11) DEFAULT 0 NOT NULL;
DELETE FROM version WHERE table_name='presentity';
INSERT INTO version (`table_name`, `table_version`) values ('presentity','4');
-- table: sip_trace
ALTER TABLE sip_trace ADD COLUMN `totag` VARCHAR(64) DEFAULT '' NOT NULL;
UPDATE version SET table_version='4' WHERE table_name='sip_trace';
-- table: acc_cdrs
-- For previous values
-- STRING -> DATETIME ??
-- STRING -> FLOAT ??
ALTER TABLE acc_cdrs MODIFY COLUMN start_time DATETIME DEFAULT '2000-01-01 00:00:00' NOT NULL;
ALTER TABLE acc_cdrs MODIFY COLUMN end_time DATETIME DEFAULT '2000-01-01 00:00:00' NOT NULL;
ALTER TABLE acc_cdrs MODIFY COLUMN duration FLOAT(10,3) DEFAULT 0 NOT NULL;
UPDATE version SET table_version='2' WHERE table_name='acc_cdrs';
-- table: silo
ALTER TABLE silo MODIFY COLUMN body BLOB;
ALTER TABLE silo MODIFY COLUMN extra_hdrs TEXT;
UPDATE version SET table_version='8' WHERE table_name='silo';
==== Upgrade Old Postgres Database Structure ====
Run following SQL statements in psql client to upgrade database structure from v4.2 to v4.3:
NOTE This drops and recreates the acc_cdrs table. Thus make sure to backup them first!!! You might also need to restore the privileges for the acc_cdrs table.
-- table: location
ALTER TABLE location ADD COLUMN server_id INTEGER DEFAULT 0 NOT NULL;
ALTER TABLE location ADD COLUMN connection_id INTEGER DEFAULT 0 NOT NULL;
ALTER TABLE location ADD COLUMN keepalive INTEGER DEFAULT 0 NOT NULL;
ALTER TABLE location ADD COLUMN partition INTEGER DEFAULT 0 NOT NULL;
DELETE FROM version WHERE TABLE_NAME='location';
INSERT INTO version (table_name, table_version) VALUES ('location','8');
-- table: aliases
ALTER TABLE aliases ADD COLUMN server_id INTEGER DEFAULT 0 NOT NULL;
ALTER TABLE aliases ADD COLUMN connection_id INTEGER DEFAULT 0 NOT NULL;
ALTER TABLE aliases ADD COLUMN keepalive INTEGER DEFAULT 0 NOT NULL;
ALTER TABLE aliases ADD COLUMN partition INTEGER DEFAULT 0 NOT NULL;
DELETE FROM version WHERE TABLE_NAME='aliases';
INSERT INTO version (table_name, table_version) VALUES ('aliases','8');
-- table: presentity
ALTER TABLE presentity ADD COLUMN priority INTEGER DEFAULT 0 NOT NULL;
DELETE FROM version WHERE TABLE_NAME='presentity';
INSERT INTO version (table_name, table_version) VALUES ('presentity','4');
-- table: sip_trace
ALTER TABLE sip_trace ADD COLUMN totag VARCHAR(64) DEFAULT '' NOT NULL;
UPDATE version SET table_version='4' WHERE table_name='sip_trace';
-- table: acc_cdrs
DROP TABLE acc_cdrs;
CREATE TABLE acc_cdrs (
id SERIAL PRIMARY KEY NOT NULL,
start_time TIMESTAMP WITHOUT TIME ZONE DEFAULT '2000-01-01 00:00:00' NOT NULL,
end_time TIMESTAMP WITHOUT TIME ZONE DEFAULT '2000-01-01 00:00:00' NOT NULL,
duration REAL DEFAULT 0 NOT NULL
);
UPDATE version SET table_version='2' WHERE table_name='acc_cdrs';
-- table: silo
ALTER TABLE silo ALTER COLUMN body SET DEFAULT '';
ALTER TABLE silo ALTER COLUMN body SET NOT NULL;
ALTER TABLE silo ALTER COLUMN extra_hdrs SET DEFAULT '';
ALTER TABLE silo ALTER COLUMN extra_hdrs SET NOT NULL;
UPDATE version SET table_version='8' WHERE table_name='silo';