05.02.06.12

Feature

05.02.06.11

Feature

05.02.06.10

Feature

Bugfix

05.02.06.09

Bugfix

05.02.06.08

Feature

Bugfix

05.02.06.07

Bugfix

05.02.06.06

Feature

Bugfix

05.02.06.05

05.02.06.04

Feature

Bugfix

05.02.06.03

Bugfix

05.02.06.02

Feature

05.02.06.01

Bugfix

05.02.06.00

Feature

Bugfix

05.02.05.00

Bugfix

05.02.04.00

Feature

Bugfix

05.02.03.00

Feature

Bugfix

05.02.02.00

Feature

Bugfix

05.02.01.00

Feature

Bugfix

05.02.00.00

5.2.0.0

Feature

5.2.0

Feature

5.2rc2

Feature

Bugfix

Breaking Change

There is new a database schema for the storage_controller table. This SQL will update an existing DB, but you will lose your existing controller configurations in the process:

  DROP TABLE IF EXISTS storage_controller;
  CREATE TABLE storage_controller (
  id		INT AUTO_INCREMENT PRIMARY KEY,
  scope_map_id	INT NOT NULL,
  enclosure	INT NOT NULL,
  adapter		INT NOT NULL,
  slot		INT NOT NULL,
  raidlevel	VARCHAR(16) NOT NULL,
  arrayid		INT NOT NULL,
  options		VARCHAR(512) NOT NULL,
  INDEX (enclosure, adapter, slot),
  FOREIGN KEY (scope_map_id) REFERENCES scope_map(id) ON DELETE CASCADE
  );

There is new a database schema for the routes. This SQL will update an existing DB, but you will lose your existing routes in the process:

  DROP TABLE IF EXISTS global_routes;
  DROP TABLE IF EXISTS os_routes;
  DROP TABLE IF EXISTS appliance_routes;
  DROP TABLE IF EXISTS node_routes;
  DROP TABLE IF EXISTS environment_routes;
  
  CREATE TABLE routes (
  id		INT AUTO_INCREMENT PRIMARY KEY,
  scope_map_id	INT NOT NULL,
  address		VARCHAR(32) NOT NULL,
  netmask		VARCHAR(32) NOT NULL,
  gateway		VARCHAR(32) DEFAULT NULL,
  subnet_id	INT DEFAULT NULL,
  interface	VARCHAR(32) DEFAULT NULL,
  INDEX (address),
  INDEX (interface),
  FOREIGN KEY (scope_map_id) REFERENCES scope_map(id) ON DELETE CASCADE,
  FOREIGN KEY (subnet_id) REFERENCES subnets(id) ON DELETE CASCADE
  );
  mysqladmin --defaults-extra-file=/etc/root.my.cnf --user=root create shadow
  mysql --defaults-extra-file=/etc/root.my.cnf
  > grant select,update,insert,delete,lock tables on shadow.*  to apache@localhost;
  > grant select,update,insert,delete,lock tables on shadow.*  to apache@HOSTNAME;
  mysql --defaults-extra-file=/etc/root.my.cnf --user=root shadow
  > DROP TABLE IF EXISTS attributes;
  CREATE TABLE attributes (
  Scope           enum ('global', 'os', 'environment', 'appliance', 'host'),
  Attr            varchar(128) NOT NULL,
  Value           text,
  ScopeID         int(11)
  );

You can no longer pass network=all or output-network=all to the add firewall commands. That is the default, so if you want the firewall rule to apply to all networks, just don’t specify the network or output-network parameters. This is how it really worked in the previous code, specifying all was just a nop.

There is new a database schema for the firewall rules. This SQL will update an existing DB, but you will lose your existing firewall rules in the process:

  DROP TABLE IF EXISTS global_firewall;
  DROP TABLE IF EXISTS os_firewall;
  DROP TABLE IF EXISTS appliance_firewall;
  DROP TABLE IF EXISTS node_firewall;
  DROP TABLE IF EXISTS environment_firewall;
  
  CREATE TABLE scope_map (
  id		INT AUTO_INCREMENT PRIMARY KEY,
  scope		ENUM('global','appliance','os','environment', 'host') NOT NULL,
  appliance_id	INT DEFAULT NULL,
  os_id		INT DEFAULT NULL,
  environment_id	INT DEFAULT NULL,
  node_id		INT DEFAULT NULL,
  INDEX (scope),
  FOREIGN KEY (appliance_id) REFERENCES appliances(id) ON DELETE CASCADE,
  FOREIGN KEY (os_id) REFERENCES oses(id) ON DELETE CASCADE,
  FOREIGN KEY (environment_id) REFERENCES environments(id) ON DELETE CASCADE,
  FOREIGN KEY (node_id) REFERENCES nodes(id) ON DELETE CASCADE
  );
  
  CREATE TABLE firewall_rules (
  id		INT AUTO_INCREMENT PRIMARY KEY,
  scope_map_id	INT NOT NULL,
  name		VARCHAR(256) NOT NULL,
  table_type	ENUM('nat','filter','mangle','raw') NOT NULL,
  chain		VARCHAR(256) NOT NULL,
  action		VARCHAR(256) NOT NULL,
  service		VARCHAR(256) NOT NULL,
  protocol 	VARCHAR(256) NOT NULL,
  in_subnet_id	INT DEFAULT NULL,
  out_subnet_id	INT DEFAULT NULL,
  flags		VARCHAR(256) DEFAULT NULL,
  comment		VARCHAR(256) DEFAULT NULL,
  INDEX (name),
  INDEX (table_type),
  FOREIGN KEY (scope_map_id) REFERENCES scope_map(id) ON DELETE CASCADE,
  FOREIGN KEY (in_subnet_id) REFERENCES subnets(id) ON DELETE CASCADE,
  FOREIGN KEY (out_subnet_id) REFERENCES subnets(id) ON DELETE CASCADE
  );

Edited by: Chris Ladd on Fri Oct 4 14:22:56 2019 -0700
Commit: 0a101cb