This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next 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:17] klaus3000 syntax highlighting for SQL automatically writes the word domain in capital letters as it is a reserved word. Thus, ALTER TABLE DOMAIN will fail |
||
---|---|---|---|
Line 123: | Line 123: | ||
UNIQUE KEY domain_attrs_idx (did, | UNIQUE KEY domain_attrs_idx (did, | ||
) 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 | + | This is the translation of the above MySQL script for PostgreSQL (Should |
<code sql> | <code sql> | ||
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=' | DELETE FROM version WHERE table_name=' | ||
INSERT INTO version (table_name, | INSERT INTO version (table_name, | ||
+ | DELETE FROM version WHERE table_name=' | ||
+ | INSERT INTO version (table_name, | ||
DELETE FROM version WHERE table_name=' | DELETE FROM version WHERE table_name=' | ||
INSERT INTO version (table_name, | INSERT INTO version (table_name, | ||
Line 355: | Line 367: | ||
</ | </ | ||
===== Modules ===== | ===== Modules ===== | ||
+ | |||
+ | ==== modules_k/ | ||
+ | |||
+ | * Removed support for db only mode and, as consequence, | ||
==== modules_k/ | ==== modules_k/ |