User Tools

Site Tools


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
install:upgrade:4.3.x-to-4.4.0 [2016/03/29 11:38]
miconda [Parameters]
install:upgrade:4.3.x-to-4.4.0 [2016/09/07 22:47] (current)
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). The value **fork=yes** will preserve existing behaviour.+(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 VARCHAR(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.1459244292.txt.gz · Last modified: 2016/03/29 11:38 by miconda