Build and run master-server as Docker container

2 files changed, 0 insertions, 306 deletions

diff --git a/extras/content.sql b/extras/content.sql
deleted file mode 100644
index 40db734..0000000
--- a/extras/content.sql
+++ /dev/null
@@ -1,57 +0,0 @@
--- MySQL dump 10.16  Distrib 10.1.35-MariaDB, for debian-linux-gnu (i686)
---
--- Host: localhost    Database: bwlp
--- ------------------------------------------------------
--- Server version	10.1.35-MariaDB-1
-
-/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
-/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
-/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
-/*!40101 SET NAMES utf8 */;
-/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
-/*!40103 SET TIME_ZONE='+00:00' */;
-/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
-/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
-/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
-/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-
---
--- Dumping data for table `os_x_virt`
---
-
-LOCK TABLES `os_x_virt` WRITE;
-/*!40000 ALTER TABLE `os_x_virt` DISABLE KEYS */;
-INSERT INTO `os_x_virt` VALUES (13,'virtualbox','Debian'),(14,'virtualbox','Debian_64'),(13,'vmware','debian8'),(14,'vmware','debian8-64'),(15,'virtualbox','DOS'),(15,'vmware','dos'),(8,'virtualbox','Linux'),(9,'virtualbox','Linux_64'),(6,'virtualbox','OpenSUSE'),(6,'vmware','opensuse'),(7,'virtualbox','OpenSUSE_64'),(7,'vmware','opensuse-64'),(16,'virtualbox','Other'),(16,'vmware','other'),(17,'virtualbox','Other_64'),(17,'vmware','other-64'),(8,'vmware','other3xlinux'),(9,'vmware','other3xlinux-64'),(4,'virtualbox','Ubuntu'),(4,'vmware','ubuntu'),(5,'virtualbox','Ubuntu_64'),(5,'vmware','ubuntu-64'),(11,'vmware','win2000pro'),(18,'virtualbox','Windows10_64'),(11,'virtualbox','Windows2000'),(10,'virtualbox','Windows7'),(10,'vmware','windows7'),(1,'virtualbox','Windows7_64'),(1,'vmware','windows7-64'),(2,'virtualbox','Windows8'),(2,'vmware','windows8'),(3,'virtualbox','Windows8_64'),(3,'vmware','windows8-64'),(18,'vmware','windows9-64'),(19,'virtualbox','WindowsNT'),(12,'virtualbox','WindowsXP'),(19,'vmware','winnt'),(12,'vmware','winxppro');
-/*!40000 ALTER TABLE `os_x_virt` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Dumping data for table `virtualizer`
---
-
-LOCK TABLES `virtualizer` WRITE;
-/*!40000 ALTER TABLE `virtualizer` DISABLE KEYS */;
-INSERT INTO `virtualizer` VALUES ('qemukvm','QEMU-KVM'),('virtualbox','VirtualBox'),('vmware','VMware');
-/*!40000 ALTER TABLE `virtualizer` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Dumping data for table `operatingsystem`
---
-
-LOCK TABLES `operatingsystem` WRITE;
-/*!40000 ALTER TABLE `operatingsystem` DISABLE KEYS */;
-INSERT INTO `operatingsystem` VALUES (1,'Windows 7 (64 Bit)','AMD64',196608,256),(2,'Windows 8 (32 Bit)','x86',4096,32),(3,'Windows 8 (64 Bit)','AMD64',131072,256),(4,'Ubuntu (32 Bit)','x86',0,0),(5,'Ubuntu (64 Bit)','AMD64',0,0),(6,'OpenSUSE (32 Bit)','x86',0,0),(7,'OpenSUSE (64 Bit)','AMD64',0,0),(8,'Other Linux (32 Bit)','x86',0,0),(9,'Other Linux (64 Bit)','AMD64',0,0),(10,'Windows 7 (32 Bit)','x86',4096,32),(11,'Windows 2000 Professional','x86',4096,4),(12,'Windows XP (32 Bit)','x86',4096,8),(13,'Debian (32Bit)','x86',0,0),(14,'Debian (64Bit)','AMD64',0,0),(15,'DOS','x86',32,1),(16,'Anderes (32 Bit)','x86',0,0),(17,'Anderes (64 Bit)','AMD64',0,0),(18,'Windows 10 (64 Bit)','AMD64',131072,256),(19,'Windows NT 4','x86',4096,4);
-/*!40000 ALTER TABLE `operatingsystem` ENABLE KEYS */;
-UNLOCK TABLES;
-/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
-
-/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
-/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
-/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
-/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
-/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
-/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
-/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-
--- Dump completed on 2018-10-16 11:55:16
diff --git a/extras/database.sql b/extras/database.sql
deleted file mode 100644
index 538de95..0000000
--- a/extras/database.sql
+++ /dev/null
@@ -1,249 +0,0 @@
--- MySQL dump 10.16  Distrib 10.1.35-MariaDB, for debian-linux-gnu (i686)
---
--- Host: localhost    Database: bwlp
--- ------------------------------------------------------
--- Server version	10.1.35-MariaDB-1
-
-/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
-/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
-/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
-/*!40101 SET NAMES utf8 */;
-/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
-/*!40103 SET TIME_ZONE='+00:00' */;
-/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
-/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
-/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
-/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-
---
--- Table structure for table `imagebase`
---
-
-DROP TABLE IF EXISTS `imagebase`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `imagebase` (
-  `imagebaseid` char(36) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
-  `latestversionid` char(36) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL,
-  `displayname` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
-  `description` text COLLATE utf8mb4_unicode_ci,
-  `osid` int(11) DEFAULT NULL,
-  `virtid` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
-  `createtime` bigint(20) NOT NULL,
-  `updatetime` bigint(20) NOT NULL,
-  `ownerid` char(36) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
-  `updaterid` char(36) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
-  `istemplate` tinyint(1) NOT NULL,
-  PRIMARY KEY (`imagebaseid`),
-  KEY `owner` (`ownerid`),
-  KEY `fk_imagebase_1_idx` (`osid`),
-  KEY `fk_imagebase_updater_idx` (`updaterid`),
-  KEY `fk_imagebase_1_idx1` (`virtid`),
-  KEY `latestversion_idx` (`latestversionid`),
-  CONSTRAINT `imagebase_ibfk_1` FOREIGN KEY (`virtid`) REFERENCES `virtualizer` (`virtid`),
-  CONSTRAINT `imagebase_ibfk_2` FOREIGN KEY (`osid`) REFERENCES `operatingsystem` (`osid`),
-  CONSTRAINT `imagebase_ibfk_3` FOREIGN KEY (`ownerid`) REFERENCES `user` (`userid`),
-  CONSTRAINT `imagebase_ibfk_4` FOREIGN KEY (`updaterid`) REFERENCES `user` (`userid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `imageblock`
---
-
-DROP TABLE IF EXISTS `imageblock`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `imageblock` (
-  `imageversionid` char(36) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
-  `startbyte` bigint(20) NOT NULL,
-  `blocksize` int(11) NOT NULL,
-  `blocksha1` binary(20) DEFAULT NULL,
-  `ismissing` tinyint(1) NOT NULL COMMENT 'true if this block is missing from the file, either because it was not transferred to the server yet, or because it failed an integrity check.',
-  PRIMARY KEY (`imageversionid`,`startbyte`,`blocksize`),
-  KEY `checksums` (`blocksha1`,`blocksize`),
-  CONSTRAINT `fk_imageblocksha1_1` FOREIGN KEY (`imageversionid`) REFERENCES `imageversion` (`imageversionid`) ON DELETE CASCADE ON UPDATE CASCADE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `imageversion`
---
-
-DROP TABLE IF EXISTS `imageversion`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `imageversion` (
-  `imageversionid` char(36) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
-  `imagebaseid` char(36) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL,
-  `createtime` bigint(20) NOT NULL,
-  `expiretime` bigint(20) NOT NULL,
-  `filesize` bigint(20) NOT NULL,
-  `filepath` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
-  `uploaderid` char(36) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
-  `isvalid` tinyint(1) NOT NULL,
-  `isprocessed` tinyint(1) NOT NULL,
-  `mastersha1` binary(20) DEFAULT NULL,
-  `virtualizerconfig` blob COMMENT 'Specific configuration of the virtualizer for this image. For vmware, this is basically a dump of the *.vmx.',
-  PRIMARY KEY (`imageversionid`),
-  KEY `version_access` (`imagebaseid`,`isvalid`,`createtime`),
-  KEY `fk_imageversion_2_idx` (`uploaderid`),
-  KEY `expire_index` (`expiretime`),
-  CONSTRAINT `imageversion_ibfk_1` FOREIGN KEY (`imagebaseid`) REFERENCES `imagebase` (`imagebaseid`),
-  CONSTRAINT `imageversion_ibfk_2` FOREIGN KEY (`uploaderid`) REFERENCES `user` (`userid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `operatingsystem`
---
-
-DROP TABLE IF EXISTS `operatingsystem`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `operatingsystem` (
-  `osid` int(11) NOT NULL AUTO_INCREMENT,
-  `displayname` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
-  `architecture` varchar(14) COLLATE utf8mb4_unicode_ci NOT NULL,
-  `maxmem` int(11) NOT NULL DEFAULT '0',
-  `maxcpu` int(11) NOT NULL DEFAULT '0',
-  PRIMARY KEY (`osid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `organization`
---
-
-DROP TABLE IF EXISTS `organization`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `organization` (
-  `organizationid` char(36) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
-  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
-  `authmethod` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
-  `publickey` text COLLATE utf8mb4_unicode_ci,
-  PRIMARY KEY (`organizationid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `organization_suffix`
---
-
-DROP TABLE IF EXISTS `organization_suffix`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `organization_suffix` (
-  `organizationid` char(36) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
-  `suffix` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
-  PRIMARY KEY (`suffix`),
-  KEY `organizationid` (`organizationid`),
-  CONSTRAINT `organization_suffix_ibfk_1` FOREIGN KEY (`organizationid`) REFERENCES `organization` (`organizationid`) ON DELETE CASCADE ON UPDATE CASCADE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `os_x_virt`
---
-
-DROP TABLE IF EXISTS `os_x_virt`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `os_x_virt` (
-  `osid` int(11) NOT NULL,
-  `virtid` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
-  `virtoskeyword` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
-  PRIMARY KEY (`osid`,`virtid`),
-  KEY `virtoskeyword` (`virtoskeyword`),
-  KEY `virtid` (`virtid`),
-  CONSTRAINT `os_x_virt_ibfk_2` FOREIGN KEY (`virtid`) REFERENCES `virtualizer` (`virtid`) ON DELETE CASCADE,
-  CONSTRAINT `os_x_virt_ibfk_3` FOREIGN KEY (`osid`) REFERENCES `operatingsystem` (`osid`) ON DELETE CASCADE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `satellite`
---
-
-DROP TABLE IF EXISTS `satellite`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `satellite` (
-  `satelliteid` int(11) NOT NULL AUTO_INCREMENT,
-  `organizationid` char(36) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
-  `satellitename` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
-  `addresses` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,
-  `certsha256` binary(32) DEFAULT NULL,
-  `publickey` text COLLATE utf8mb4_unicode_ci NOT NULL,
-  `dateline` bigint(20) NOT NULL,
-  `userid` varchar(36) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL,
-  PRIMARY KEY (`satelliteid`),
-  UNIQUE KEY `organizationid` (`organizationid`,`satellitename`),
-  KEY `dateline` (`dateline`),
-  CONSTRAINT `satellite_ibfk_1` FOREIGN KEY (`organizationid`) REFERENCES `organization` (`organizationid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `user`
---
-
-DROP TABLE IF EXISTS `user`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `user` (
-  `userid` char(36) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
-  `shibid` varchar(36) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL,
-  `password` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
-  `organizationid` char(36) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
-  `firstname` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
-  `lastname` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
-  `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
-  `fixedname` tinyint(1) NOT NULL,
-  PRIMARY KEY (`userid`),
-  UNIQUE KEY `username` (`organizationid`,`userid`),
-  UNIQUE KEY `shibid` (`shibid`),
-  CONSTRAINT `user_ibfk_1` FOREIGN KEY (`organizationid`) REFERENCES `organization` (`organizationid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `virtualizer`
---
-
-DROP TABLE IF EXISTS `virtualizer`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `virtualizer` (
-  `virtid` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
-  `virtname` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
-  PRIMARY KEY (`virtid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `websession`
---
-
-DROP TABLE IF EXISTS `websession`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `websession` (
-  `sid` char(40) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
-  `dateline` bigint(11) NOT NULL,
-  `data` varchar(3000) COLLATE utf8mb4_unicode_ci NOT NULL,
-  PRIMARY KEY (`sid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
-
-/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
-/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
-/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
-/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
-/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
-/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
-/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-
--- Dump completed on 2018-10-15 13:36:27