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:15]
linuxmaniac [Upgrade Kamailio from v3.2.x to v3.3.0]
install:upgrade:3.2.x-to-3.3.0 [2014/09/23 11:21]
klaus3000
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