User Tools

Site Tools


install:upgrade:3.2.x-to-3.3.0

This is an old revision of the document!


Upgrade Kamailio from v3.2.x to v3.3.0 (unreleased)

The page contains the details about the changes that were made to old components during the development of v3.3.0 (unreleased) compared with what existed in v3.2.x. It does not include the brand new modules, focusing on how to upgrade database and configuration file from v3.2.x to run with Kamailio v3.3.0.

Database Structure

These sections presents notes, listed by modules, about the structure of database tables that existed in v3.2.x and changed during development of v3.3.0.

modules/lcr

  • table lcr_gw
    • ip_addr column has now the size varchar(47)

modules_k/domain

  • new table domain_attrs
  • table domain
    • new column did

SQL Commands

You can use next SQL commands (made for MySQL) to update the structure of existing tables in v3.2.x for v3.3.0:

ALTER TABLE lcr_gw MODIFY ip_addr VARCHAR(47) NOT NULL;
CREATE TABLE domain_attrs (
    id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
    did VARCHAR(64) NOT NULL,
    name VARCHAR(32) NOT NULL,
    TYPE INT UNSIGNED NOT NULL,
    VALUE VARCHAR(255) NOT NULL,
    last_modified DATETIME DEFAULT '1900-01-01 00:00:01' NOT NULL,
    CONSTRAINT domain_attrs_idx UNIQUE (did, name, VALUE)
) ENGINE=MyISAM;
INSERT INTO version (TABLE_NAME, table_version) VALUES ('domain_attrs','1');
ALTER TABLE DOMAIN ADD did VARCHAR(64) DEFAULT NULL;
UPDATE version SET table_version=2 WHERE TABLE_NAME='domain';

This is the translation of the above script for PostgreSQL (should work with 9.1.1, but is untested!)

ALTER TABLE lcr_gw ALTER COLUMN ip_addr TYPE VARCHAR(47);

Modules

modules/your-module-here

  • Add changes or additions reflected in kamailio config syntax here.
install/upgrade/3.2.x-to-3.3.0.1333552735.txt.gz · Last modified: 2012/04/04 17:18 by jih