Author: jfthomps
Date: Mon Jun 5 16:15:46 2017
New Revision: 1797671
URL: http://svn.apache.org/viewvc?rev=1797671&view=rev
Log:
VCL-1045 - Method of encrypting sensitive database entries
vcl.sql and update-vcl.sql: added algorithm, algorithmoption, and keylength to
cryptkey and cryptsecret
Modified:
vcl/trunk/mysql/update-vcl.sql
vcl/trunk/mysql/vcl.sql
Modified: vcl/trunk/mysql/update-vcl.sql
URL:
http://svn.apache.org/viewvc/vcl/trunk/mysql/update-vcl.sql?rev=1797671&r1=1797670&r2=1797671&view=diff
==============================================================================
--- vcl/trunk/mysql/update-vcl.sql (original)
+++ vcl/trunk/mysql/update-vcl.sql Mon Jun 5 16:15:46 2017
@@ -976,8 +976,11 @@ CREATE TABLE IF NOT EXISTS `cryptkey` (
`hostid` smallint(6) unsigned NOT NULL,
`hosttype` enum('managementnode','web') NOT NULL DEFAULT 'managementnode',
`pubkey` varchar(1000) NOT NULL,
+ `algorithm` varchar(80) NOT NULL,
+ `algorithmoption` varchar(255) NOT NULL,
+ `keylength` smallint(5) unsigned NOT NULL,
PRIMARY KEY (`id`),
- KEY `hostid` (`hostid`)
+ UNIQUE KEY `hostid` (`hostid`,`hosttype`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
@@ -991,6 +994,9 @@ CREATE TABLE IF NOT EXISTS `cryptsecret`
`cryptkeyid` smallint(5) unsigned NOT NULL,
`secretid` smallint(5) unsigned NOT NULL,
`cryptsecret` varchar(1000) NOT NULL,
+ `algorithm` varchar(80) NOT NULL,
+ `algorithmoption` varchar(255) NOT NULL,
+ `keylength` smallint(5) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `cryptkeyid` (`cryptkeyid`,`secretid`),
KEY `secretid` (`secretid`)
Modified: vcl/trunk/mysql/vcl.sql
URL:
http://svn.apache.org/viewvc/vcl/trunk/mysql/vcl.sql?rev=1797671&r1=1797670&r2=1797671&view=diff
==============================================================================
--- vcl/trunk/mysql/vcl.sql (original)
+++ vcl/trunk/mysql/vcl.sql Mon Jun 5 16:15:46 2017
@@ -427,8 +427,11 @@ CREATE TABLE IF NOT EXISTS `cryptkey` (
`hostid` smallint(6) unsigned NOT NULL,
`hosttype` enum('managementnode','web') NOT NULL DEFAULT 'managementnode',
`pubkey` varchar(1000) NOT NULL,
+ `algorithm` varchar(80) NOT NULL,
+ `algorithmoption` varchar(255) NOT NULL,
+ `keylength` smallint(5) unsigned NOT NULL,
PRIMARY KEY (`id`),
- KEY `hostid` (`hostid`)
+ UNIQUE KEY `hostid` (`hostid`,`hosttype`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
@@ -442,6 +445,9 @@ CREATE TABLE IF NOT EXISTS `cryptsecret`
`cryptkeyid` smallint(5) unsigned NOT NULL,
`secretid` smallint(5) unsigned NOT NULL,
`cryptsecret` varchar(1000) NOT NULL,
+ `algorithm` varchar(80) NOT NULL,
+ `algorithmoption` varchar(255) NOT NULL,
+ `keylength` smallint(5) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `cryptkeyid` (`cryptkeyid`,`secretid`),
KEY `secretid` (`secretid`)
