User Tools

Site Tools



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

Link to this comparison view

Next revision
Previous revision
Last revision Both sides next revision
install:upgrade:5.1.x-to-5.2.0 [2018/11/23 09:35]
miconda created
install:upgrade:5.1.x-to-5.2.0 [2018/11/28 09:52]
Line 43: Line 43:
 See: See:
 +=== presence ===
 +A new column 'ruid' has been added to the **presentity** table. This table holds the records corresponding to the PUBLISH requests sent by UAs.
 +The cleanest way to upgrade is:
 +  * stop kamailio 5.1
 +  * delete records from presentity table
 +  * update the structure of presentity table
 +  * start kamailio 5.2
 +The UAs will send new PUBLISH periodically, so the table will get populated again. If you want to shorten the interval for PUBLISH requests, set max_expire parameter for presence module, then restart and wait some time until all UAs send another PUBLISH. Do the upgrade as described above, and then set back the max_expire to the older value.
 ==== Removed Modules ==== ==== Removed Modules ====
Line 82: Line 94:
 <code sql> <code sql>
 +-- location table - optional update
 +ALTER TABLE location_attrs CHANGE COLUMN avalue avalue varchar(512) NOT NULL DEFAULT '';
 +-- presentity table
 +ALTER TABLE presentity CHANGE COLUMN etag etag varchar(128) NOT NULL;
 ALTER TABLE presentity ADD COLUMN ruid VARCHAR(64); ALTER TABLE presentity ADD COLUMN ruid VARCHAR(64);
 CREATE UNIQUE INDEX ruid_idx ON presentity (ruid); CREATE UNIQUE INDEX ruid_idx ON presentity (ruid);
 UPDATE version SET table_version=5 WHERE table_name='presentity'; UPDATE version SET table_version=5 WHERE table_name='presentity';
 +-- pua table - optional update
 +ALTER TABLE pua CHANGE COLUMN etag etag varchar(128) NOT NULL;
 +-- subscriber table - optional update
 +ALTER TABLE subscriber DROP COLUMN rpid;
 +ALTER TABLE subscriber DROP COLUMN email_address;
 +-- xcap table - optional update
 +ALTER TABLE xcap CHANGE COLUMN etag etag varchar(128) NOT NULL;
 </code> </code>
install/upgrade/5.1.x-to-5.2.0.txt ยท Last modified: 2018/11/28 09:53 by miconda