User Tools

Site Tools


install:upgrade:5.4.x-to-5.5.0

Differences

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

Link to this comparison view

Next revision
Previous revision
install:upgrade:5.4.x-to-5.5.0 [2021/04/01 12:14]
miconda created
install:upgrade:5.4.x-to-5.5.0 [2021/10/04 17:40] (current)
henningw
Line 30: Line 30:
 ==== Renamed Modules ==== ==== Renamed Modules ====
  
-  none+=== userblacklist to userblocklist === 
 + 
 +  https://www.kamailio.org/docs/modules/5.5.x/modules/userblocklist.html 
 + 
 +Impacted resources: 
 + 
 +  * version table, userblacklist and globalblacklist entries renamed to userblocklist and globalblocklist 
 +  * database table **globalblacklist** renamed to **globalblocklist** - its definition is now: 
 + 
 +<code> 
 +CREATE TABLE globalblocklist ( 
 +  id int(10) unsigned NOT NULL AUTO_INCREMENT, 
 +  prefix varchar(64) NOT NULL DEFAULT '', 
 +  allowlist tinyint(1) NOT NULL DEFAULT 0, 
 +  description varchar(255) DEFAULT NULL, 
 +  PRIMARY KEY (id), 
 +  KEY globalblocklist_idx (prefix) 
 +); 
 +</code> 
 + 
 +Note also the changes in the column names and indexes. 
 + 
 + 
 +  * database table **userblacklist** renamed to **userblocklist** - its definition is now: 
 + 
 +<code> 
 +CREATE TABLE userblocklist ( 
 +  id int(10) unsigned NOT NULL AUTO_INCREMENT, 
 +  username varchar(64) NOT NULL DEFAULT '', 
 +  domain varchar(64) NOT NULL DEFAULT '', 
 +  prefix varchar(64) NOT NULL DEFAULT '', 
 +  allowlist tinyint(1) NOT NULL DEFAULT 0, 
 +  PRIMARY KEY (id), 
 +  KEY userblocklist_idx (username,domain,prefix) 
 +); 
 +</code> 
 + 
 +Note also the changes in the column names and indexes.
  
 ===== Internal Libraries ===== ===== Internal Libraries =====
Line 48: Line 85:
 ==== Misc ==== ==== Misc ====
  
 +  * **#!substdef "/match/replacement/flags"** evaluates the **replacement** for variables to be coherent with **#!subst**, if there are variables that should not be evaluated during pre-processing phase, use **$$** at the beginning of variable (e.g., **$$var(x)***
 ===== Database ===== ===== Database =====
  
Line 56: Line 94:
  
 <code sql> <code sql>
-...+-- topos_d table 
 +ALTER TABLE topos_d ADD COLUMN x_context varchar(64) NOT NULL DEFAULT ''; 
 +UPDATE version SET table_version=2 WHERE TABLE_NAME='topos_d'; 
 + 
 +-- topos_t table 
 +ALTER TABLE topos_t ADD COLUMN x_context varchar(64) NOT NULL DEFAULT ''; 
 +UPDATE version SET table_version=2 WHERE TABLE_NAME='topos_t'; 
 + 
 +-- uacreg table 
 +ALTER TABLE uacreg ADD COLUMN contact_addr varchar(255) NOT NULL DEFAULT ''; 
 +UPDATE version SET table_version=5 WHERE TABLE_NAME='uacreg'; 
 + 
 +-- IMPORTANT: see also the notes about the userblocklist module
 </code> </code>
install/upgrade/5.4.x-to-5.5.0.1617272052.txt.gz · Last modified: 2021/04/01 12:14 by miconda