User Tools

Site Tools


install:upgrade:3.2.x-to-3.3.0

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
install:upgrade:3.2.x-to-3.3.0 [2012/06/21 08:14]
linuxmaniac [SQL Commands]
install:upgrade:3.2.x-to-3.3.0 [2014/09/23 11:21]
klaus3000
Line 1: Line 1:
-====== Upgrade Kamailio from v3.2.x to v3.3.0 (unreleased) ======+====== Upgrade Kamailio from v3.2.x to v3.3.0 ======
  
-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.+The page contains the details about the changes that were made to old components during the development of v3.3.0 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 ===== ===== Database Structure =====
Line 73: Line 73:
 You can use next SQL commands (made for MySQL) to update the structure of existing tables in v3.2.x for v3.3.0: You can use next SQL commands (made for MySQL) to update the structure of existing tables in v3.2.x for v3.3.0:
  
-<code sql>+<code ->
  
 -- PERMISSIONS module -- PERMISSIONS module
Line 123: Line 123:
   UNIQUE KEY domain_attrs_idx (did,name,value)   UNIQUE KEY domain_attrs_idx (did,name,value)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1; ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 +
 +GRANT ALL PRIVILEGES ON TABLE domain_attrs TO openser;
 +GRANT SELECT ON TABLE domain_attrs TO openserro;
 +GRANT ALL PRIVILEGES ON TABLE domain_attrs_id_seq TO openser;
 +GRANT SELECT ON TABLE domain_attrs_id_seq TO openserro;
  
 -- PRESENCE modules -- PRESENCE modules
Line 197: Line 202:
 === PostgreSQL === === PostgreSQL ===
  
-This is the translation of the above MySQL script for PostgreSQL (should work with 9.1.1, but is untested!)+This is the translation of the above MySQL script for PostgreSQL (Should work with 9.1.1, partially tested on 9.1.5.)
  
-<code sql>+<code ->
 -- PERMISSIONS module -- PERMISSIONS module
 ALTER TABLE address ALTER COLUMN ip_addr TYPE varchar(48); ALTER TABLE address ALTER COLUMN ip_addr TYPE varchar(48);
Line 279: Line 284:
 ); );
    
 +GRANT ALL PRIVILEGES ON TABLE domain_attrs TO openser;
 +GRANT SELECT ON TABLE domain_attrs TO openserro;
 +GRANT ALL PRIVILEGES ON TABLE domain_attrs_id_seq TO openser;
 +GRANT SELECT ON TABLE domain_attrs_id_seq TO openserro;
 +
 -- PRESENCE modules -- PRESENCE modules
 DELETE FROM active_watchers; DELETE FROM active_watchers;
Line 335: Line 345:
 DELETE FROM version WHERE table_name='dialog'; DELETE FROM version WHERE table_name='dialog';
 INSERT INTO version (table_name, table_version) VALUES ('dialog','7'); INSERT INTO version (table_name, table_version) VALUES ('dialog','7');
 +DELETE FROM version WHERE table_name='lcr_rule';
 +INSERT INTO version (table_name, table_version) VALUES ('lcr_rule','2');
 DELETE FROM version WHERE table_name='domain'; DELETE FROM version WHERE table_name='domain';
 INSERT INTO version (table_name, table_version) VALUES ('domain','2'); INSERT INTO version (table_name, table_version) VALUES ('domain','2');
Line 355: Line 367:
 </code> </code>
 ===== Modules ===== ===== Modules =====
 +
 +==== modules_k/domain ====
 +
 +  * Removed support for db only mode and, as consequence, removed db_mode module variable.
  
 ==== modules_k/presence ==== ==== modules_k/presence ====
install/upgrade/3.2.x-to-3.3.0.txt · Last modified: 2014/09/23 11:21 by klaus3000