Kamailio SIP Server Wiki

User Tools

Site Tools

Trace:
install:upgrade:4.3.x-to-4.4.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
Last revision Both sides next revision
install:upgrade:4.3.x-to-4.4.0 [2016/03/29 11:37]
miconda [Parameters] 		install:upgrade:4.3.x-to-4.4.0 [2016/09/07 19:18]
giacomo.vacca [Postgres Database Structure]
Line 34: Line 34:
  
 The functions for routing blocks are the same, no changes are required there. The functions for routing blocks are the same, no changes are required there.
 +
 ===== Core ===== ===== Core =====
  
Line 40: Line 41:
 === fork === === fork ===
  
-This is just heads up notification that the **fork** parameter is planned to be refactored in the next version, because fork=no disables many features without explicit visibility (e.g., no tcp/tls, only listening on first network interface).+(INF) This is just heads up notification that the **fork** parameter is planned to be refactored in the next version, because **fork=no** disables many features without explicit visibility (e.g., no tcp/tls, only listening on first network interface). The value **fork=yes** will preserve existing behaviour. 
 ===== Database ===== ===== Database =====
  
Line 57: Line 59:
 ALTER TABLE active_watchers ALTER TABLE active_watchers
   ADD COLUMN flags int(11) NOT NULL DEFAULT '0',   ADD COLUMN flags int(11) NOT NULL DEFAULT '0',
-  ADD COLUMN user_agent varchar(255) NOT NULL;+  ADD COLUMN user_agent varchar(255) DEFAULT '' NOT NULL;
 DELETE FROM version WHERE TABLE_NAME='active_watchers'; DELETE FROM version WHERE TABLE_NAME='active_watchers';
 INSERT INTO version (`table_name`, `table_version`) VALUES ('active_watchers','12'); INSERT INTO version (`table_name`, `table_version`) VALUES ('active_watchers','12');
  
 -- table: trusted -- table: trusted
-ALTER TABLE trusted+ALTER TABLE `trusted`
   ADD COLUMN priority int(11) NOT NULL DEFAULT '0',   ADD COLUMN priority int(11) NOT NULL DEFAULT '0',
   ADD COLUMN ruri_pattern varchar(64) NULL,   ADD COLUMN ruri_pattern varchar(64) NULL,
Line 76: Line 78:
 INSERT INTO version (`table_name`, `table_version`) VALUES ('uacreg','2'); INSERT INTO version (`table_name`, `table_version`) VALUES ('uacreg','2');
  
 +
 +</code>
 +
 +
 +
 +==== Postgres Database Structure ====
 +Run following SQL statements in psql client to upgrade database structure from v4.3 to v4.4:
 +
 +<code sql>
 +-- table: active_watchers
 +ALTER TABLE active_watchers ADD COLUMN flags INTEGER DEFAULT 0 NOT NULL;
 +ALTER TABLE active_watchers ADD COLUMN user_agent VAR_CHAR(255) DEFAULT '' NOT NULL;
 +DELETE FROM version WHERE TABLE_NAME='active_watchers';
 +INSERT INTO version (TABLE_NAME, table_version) VALUES ('active_watchers','12');
 +
 +-- table: trusted
 +ALTER TABLE trusted ADD COLUMN priority INTEGER DEFAULT 0 NOT NULL;
 +ALTER TABLE trusted ADD COLUMN ruri_pattern VARCHAR(64) NULL;
 +ALTER TABLE trusted ALTER COLUMN tag TYPE VARCHAR(64);
 +DELETE FROM version WHERE TABLE_NAME='trusted';
 +INSERT INTO version (TABLE_NAME, table_version) VALUES ('trusted','6');
 +
 +-- table: uacreg
 +ALTER TABLE uacreg ADD COLUMN reg_delay INTEGER DEFAULT 0 NOT NULL;
 +ALTER TABLE uacreg ADD COLUMN flags INTEGER DEFAULT 0 NOT NULL;
 +DELETE FROM version WHERE TABLE_NAME='uacreg';
 +INSERT INTO version (TABLE_NAME, table_version) VALUES ('uacreg','2');
  
 </code> </code>
install/upgrade/4.3.x-to-4.4.0.txt · Last modified: 2016/09/07 22:47 by giacomo.vacca

Page Tools

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki