This is an old revision of the document!
The page contains the details about the changes that were made to old components during the development of v5.3.0 compared with what existed in v5.2.x. It does not include the brand new modules, focusing on how to upgrade database and configuration file from v5.2.x to run with Kamailio devel.
If you look for the guidelines to upgrade to previous stable release, see:
Following tokens are used to mark the changes:
# old config loadmodule "app_lua.so" modparam("app_lua", "register", "sl") # new config loadmodule "app_lua.so" loadmodule "app_lua_sr.so" modparam("app_lua_sr", "register", "sl")
Run following SQL statements in MySQL client to upgrade database structure from v5.2 to v5.3:
-- acc table ALTER TABLE acc CHANGE COLUMN to_tag to_tag VARCHAR(128) NOT NULL DEFAULT ''; -- # was varchar(64) NOT NULL DEFAULT '' ALTER TABLE acc CHANGE COLUMN from_tag from_tag VARCHAR(128) NOT NULL DEFAULT ''; -- # was varchar(64) NOT NULL DEFAULT '' -- active_watchers table ALTER TABLE active_watchers CHANGE COLUMN contact contact VARCHAR(255) NOT NULL; -- # was varchar(128) NOT NULL ALTER TABLE active_watchers CHANGE COLUMN from_tag from_tag VARCHAR(128) NOT NULL; -- # was varchar(64) NOT NULL ALTER TABLE active_watchers CHANGE COLUMN to_tag to_tag VARCHAR(128) NOT NULL; -- # was varchar(64) NOT NULL ALTER TABLE active_watchers CHANGE COLUMN presentity_uri presentity_uri VARCHAR(255) NOT NULL; -- # was varchar(128) NOT NULL ALTER TABLE active_watchers CHANGE COLUMN local_contact local_contact VARCHAR(255) NOT NULL; -- # was varchar(128) NOT NULL ALTER TABLE aliases CHANGE COLUMN received received VARCHAR(255) DEFAULT NULL; -- # was varchar(128) DEFAULT NULL ALTER TABLE carrierfailureroute CHANGE COLUMN host_name host_name VARCHAR(255) NOT NULL DEFAULT ''; -- # was varchar(128) NOT NULL DEFAULT '' ALTER TABLE carrierroute CHANGE COLUMN rewrite_host rewrite_host VARCHAR(255) NOT NULL DEFAULT ''; -- # was varchar(128) NOT NULL DEFAULT '' ALTER TABLE dialog CHANGE COLUMN req_uri req_uri VARCHAR(255) NOT NULL; -- # was varchar(128) NOT NULL ALTER TABLE dialog CHANGE COLUMN caller_contact caller_contact VARCHAR(255) NOT NULL; -- # was varchar(128) NOT NULL ALTER TABLE dialog CHANGE COLUMN callee_contact callee_contact VARCHAR(255) NOT NULL; -- # was varchar(128) NOT NULL ALTER TABLE dialog CHANGE COLUMN to_tag to_tag VARCHAR(128) NOT NULL; -- # was varchar(64) NOT NULL ALTER TABLE dialog CHANGE COLUMN from_tag from_tag VARCHAR(128) NOT NULL; -- # was varchar(64) NOT NULL ALTER TABLE dialog CHANGE COLUMN from_uri from_uri VARCHAR(255) NOT NULL; -- # was varchar(128) NOT NULL ALTER TABLE dialog CHANGE COLUMN to_uri to_uri VARCHAR(255) NOT NULL; -- # was varchar(128) NOT NULL ALTER TABLE missed_calls CHANGE COLUMN to_tag to_tag VARCHAR(128) NOT NULL DEFAULT ''; -- # was varchar(64) NOT NULL DEFAULT '' ALTER TABLE missed_calls CHANGE COLUMN from_tag from_tag VARCHAR(128) NOT NULL DEFAULT ''; -- # was varchar(64) NOT NULL DEFAULT '' ALTER TABLE pdt CHANGE COLUMN DOMAIN DOMAIN VARCHAR(255) NOT NULL DEFAULT ''; -- # was varchar(128) NOT NULL DEFAULT '' ALTER TABLE pdt CHANGE COLUMN sdomain sdomain VARCHAR(255) NOT NULL; -- # was varchar(128) NOT NULL ALTER TABLE presentity CHANGE COLUMN sender sender VARCHAR(255) NOT NULL; -- # was varchar(128) NOT NULL ALTER TABLE pua CHANGE COLUMN remote_contact remote_contact VARCHAR(255) NOT NULL; -- # was varchar(128) NOT NULL ALTER TABLE pua CHANGE COLUMN watcher_uri watcher_uri VARCHAR(255) NOT NULL; -- # was varchar(128) NOT NULL ALTER TABLE pua CHANGE COLUMN contact contact VARCHAR(255) NOT NULL; -- # was varchar(128) NOT NULL ALTER TABLE pua CHANGE COLUMN to_tag to_tag VARCHAR(128) NOT NULL; -- # was varchar(64) NOT NULL ALTER TABLE pua CHANGE COLUMN from_tag from_tag VARCHAR(128) NOT NULL; -- # was varchar(64) NOT NULL ALTER TABLE pua CHANGE COLUMN pres_uri pres_uri VARCHAR(255) NOT NULL; -- # was varchar(128) NOT NULL ALTER TABLE purplemap CHANGE COLUMN sip_user sip_user VARCHAR(255) NOT NULL; -- # was varchar(128) NOT NULL ALTER TABLE purplemap CHANGE COLUMN ext_user ext_user VARCHAR(255) NOT NULL; -- # was varchar(128) NOT NULL ALTER TABLE rls_presentity CHANGE COLUMN resource_uri resource_uri VARCHAR(255) NOT NULL; -- # was varchar(128) NOT NULL ALTER TABLE rls_watchers CHANGE COLUMN to_tag to_tag VARCHAR(128) NOT NULL; -- # was varchar(64) NOT NULL ALTER TABLE rls_watchers CHANGE COLUMN from_tag from_tag VARCHAR(128) NOT NULL; -- # was varchar(64) NOT NULL ALTER TABLE rls_watchers CHANGE COLUMN presentity_uri presentity_uri VARCHAR(255) NOT NULL; -- # was varchar(128) NOT NULL ALTER TABLE rls_watchers CHANGE COLUMN local_contact local_contact VARCHAR(255) NOT NULL; -- # was varchar(128) NOT NULL ALTER TABLE rls_watchers CHANGE COLUMN contact contact VARCHAR(255) NOT NULL; -- # was varchar(128) NOT NULL ALTER TABLE sca_subscriptions CHANGE COLUMN to_tag to_tag VARCHAR(128) NOT NULL; -- # was varchar(64) NOT NULL ALTER TABLE sca_subscriptions CHANGE COLUMN from_tag from_tag VARCHAR(128) NOT NULL; -- # was varchar(64) NOT NULL ALTER TABLE silo CHANGE COLUMN dst_addr dst_addr VARCHAR(255) NOT NULL DEFAULT ''; -- # was varchar(128) NOT NULL DEFAULT '' ALTER TABLE silo CHANGE COLUMN src_addr src_addr VARCHAR(255) NOT NULL DEFAULT ''; -- # was varchar(128) NOT NULL DEFAULT '' ALTER TABLE sip_trace CHANGE COLUMN fromtag fromtag VARCHAR(128) NOT NULL DEFAULT ''; -- # was varchar(64) NOT NULL DEFAULT '' ALTER TABLE sip_trace CHANGE COLUMN STATUS STATUS VARCHAR(255) NOT NULL DEFAULT ''; -- # was varchar(128) NOT NULL DEFAULT '' ALTER TABLE sip_trace CHANGE COLUMN traced_user traced_user VARCHAR(255) NOT NULL DEFAULT ''; -- # was varchar(128) NOT NULL DEFAULT '' ALTER TABLE sip_trace CHANGE COLUMN totag totag VARCHAR(128) NOT NULL DEFAULT ''; -- # was varchar(64) NOT NULL DEFAULT '' ALTER TABLE speed_dial CHANGE COLUMN new_uri new_uri VARCHAR(255) NOT NULL DEFAULT ''; -- # was varchar(128) NOT NULL DEFAULT '' ALTER TABLE topos_d CHANGE COLUMN a_contact a_contact VARCHAR(512) NOT NULL DEFAULT ''; -- # was varchar(128) NOT NULL DEFAULT '' ALTER TABLE topos_d CHANGE COLUMN b_contact b_contact VARCHAR(512) NOT NULL DEFAULT ''; -- # was varchar(128) NOT NULL DEFAULT '' ALTER TABLE topos_d CHANGE COLUMN b_uri b_uri VARCHAR(255) NOT NULL DEFAULT ''; -- # was varchar(128) NOT NULL DEFAULT '' ALTER TABLE topos_d CHANGE COLUMN a_uri a_uri VARCHAR(255) NOT NULL DEFAULT ''; -- # was varchar(128) NOT NULL DEFAULT '' ALTER TABLE topos_d CHANGE COLUMN bs_contact bs_contact VARCHAR(512) NOT NULL DEFAULT ''; -- # was varchar(128) NOT NULL DEFAULT '' ALTER TABLE topos_d CHANGE COLUMN as_contact as_contact VARCHAR(512) NOT NULL DEFAULT ''; -- # was varchar(128) NOT NULL DEFAULT '' ALTER TABLE topos_d CHANGE COLUMN r_uri r_uri VARCHAR(255) NOT NULL DEFAULT ''; -- # was varchar(128) NOT NULL DEFAULT '' ALTER TABLE topos_t CHANGE COLUMN x_uri x_uri VARCHAR(255) NOT NULL DEFAULT ''; -- # was varchar(128) NOT NULL DEFAULT '' ALTER TABLE topos_t CHANGE COLUMN a_contact a_contact VARCHAR(512) NOT NULL DEFAULT ''; -- # was varchar(128) NOT NULL DEFAULT '' ALTER TABLE topos_t CHANGE COLUMN b_contact b_contact VARCHAR(512) NOT NULL DEFAULT ''; -- # was varchar(128) NOT NULL DEFAULT '' ALTER TABLE topos_t CHANGE COLUMN bs_contact bs_contact VARCHAR(512) NOT NULL DEFAULT ''; -- # was varchar(128) NOT NULL DEFAULT '' ALTER TABLE topos_t CHANGE COLUMN b_srcaddr b_srcaddr VARCHAR(255) NOT NULL DEFAULT ''; -- # was varchar(128) NOT NULL DEFAULT '' ALTER TABLE topos_t CHANGE COLUMN as_contact as_contact VARCHAR(512) NOT NULL DEFAULT ''; -- # was varchar(128) NOT NULL DEFAULT '' ALTER TABLE topos_t CHANGE COLUMN a_srcaddr a_srcaddr VARCHAR(255) NOT NULL DEFAULT ''; -- # was varchar(128) NOT NULL DEFAULT '' ALTER TABLE uacreg CHANGE COLUMN auth_proxy auth_proxy VARCHAR(255) NOT NULL DEFAULT ''; -- # was varchar(128) NOT NULL DEFAULT '' ALTER TABLE uacreg ADD COLUMN socket VARCHAR(128) NOT NULL DEFAULT ''; ALTER TABLE usr_preferences CHANGE COLUMN username username VARCHAR(255) NOT NULL DEFAULT '0'; -- # was varchar(128) NOT NULL DEFAULT '0' ALTER TABLE watchers CHANGE COLUMN presentity_uri presentity_uri VARCHAR(255) NOT NULL; -- # was varchar(128) NOT NULL