diff options
| -rw-r--r-- | satellit_installer/includes/00-variables.inc | 6 | ||||
| -rw-r--r-- | satellit_installer/includes/20-get_files_http.inc | 29 | ||||
| -rwxr-xr-x | satellit_installer/satellit_installer | 6 | ||||
| -rw-r--r-- | satellit_installer/static_files/db_bwLehrpool_dump.sql | 527 | ||||
| -rw-r--r-- | satellit_installer/static_files/db_openslx_dump.sql | 282 |
5 files changed, 40 insertions, 810 deletions
diff --git a/satellit_installer/includes/00-variables.inc b/satellit_installer/includes/00-variables.inc index 36a6eab..5126c4f 100644 --- a/satellit_installer/includes/00-variables.inc +++ b/satellit_installer/includes/00-variables.inc @@ -2,6 +2,10 @@ ### Script variables, directories etc.: +# these vars are set in main program, just to mention them: +# SELF="$(readlink -f "$0")" +# BASEDIR="$(dirname "${SELF}")" + export LOGDIR="$BASEDIR/config" export INSTALLDIR="/opt/dmsd/" export TASKMANDIR="/opt/taskmanager/" @@ -14,7 +18,7 @@ export LANG=en_US.UTF-8 ### Needed Packages: # Set list of needed packages (scripting needs) - remember, Debian-specific so far. -PACKAGELIST_SCRIPT="cracklib-runtime" +PACKAGELIST_SCRIPT="cracklib-runtime wget" # Set list of needed packages (server needs) - remember, Debian-specific so far. PACKAGELIST_SERVER="mysql-server lighttpd pure-ftpd-mysql atftpd php5-cgi php5-curl cifs-utils" diff --git a/satellit_installer/includes/20-get_files_http.inc b/satellit_installer/includes/20-get_files_http.inc new file mode 100644 index 0000000..2b8aff4 --- /dev/null +++ b/satellit_installer/includes/20-get_files_http.inc @@ -0,0 +1,29 @@ +get_file_http() { + wget --tries=10 --no-verbose --user-agent="bwLehrpool-Download" -O "${FILE}" "${HTTP_BASE}/${FILE}" + ERR=$? +} + + +get_files_http() { + local FILE + echo "# Downloading static files." + cd "$BASEDIR/static_files" + for FILE in $HTTP_FILES; do + echo -n "# Downloading: " + get_file_http + if [ "$ERR" -ne 0 ]; then + echo + echo "# Could not download file ${HTTP_BASE}/${FILE}. Please check the variables" + echo "# HTTP_BASE and HTTP_FILES given in includes 00-variables.inc." + echo "# Values now: HTTP_BASE: $HTTP_BASE - HTTP_FILES: $HTTP_FILE." + echo "#" + echo "# This is a serious error, as there is no point in commencing script" + echo "# execution when static files are missing." + echo "#" + echo "# Terminating." + break + fi + done + [[ "$ERR" -eq 0 ]] && echo "# Static files were downloaded correctly." + cd - 1>/dev/null +} diff --git a/satellit_installer/satellit_installer b/satellit_installer/satellit_installer index 9638807..8c49f12 100755 --- a/satellit_installer/satellit_installer +++ b/satellit_installer/satellit_installer @@ -50,6 +50,12 @@ echo " ok" ####### Main program ####### install_packages "$PACKAGELIST_SCRIPT" # Packages needed for script + +# Then, let's download the needed helper files to static_files, as there +# is no sense in commencing if one of these files is missing. +get_files_http +[ "${ERR}" -ne 0 ] && exit 1 + setup_dhcp # dhcp: no dhclient but pump prerequisites # config directory, locales diff --git a/satellit_installer/static_files/db_bwLehrpool_dump.sql b/satellit_installer/static_files/db_bwLehrpool_dump.sql deleted file mode 100644 index 3eb7054..0000000 --- a/satellit_installer/static_files/db_bwLehrpool_dump.sql +++ /dev/null @@ -1,527 +0,0 @@ --- MySQL dump 10.13 Distrib 5.5.35, for debian-linux-gnu (i686) --- --- Host: localhost Database: bwLehrpool --- ------------------------------------------------------ --- Server version 5.5.35-0+wheezy1 - -/*!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 `FtpUsers` --- - -DROP TABLE IF EXISTS `FtpUsers`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `FtpUsers` ( - `User` varchar(16) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, - `Password` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, - `Uid` int(11) NOT NULL DEFAULT '-1', - `Gid` int(11) NOT NULL DEFAULT '-1', - `Dir` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, - `CreationDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, - PRIMARY KEY (`User`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `FtpUsers` --- - -LOCK TABLES `FtpUsers` WRITE; -/*!40000 ALTER TABLE `FtpUsers` DISABLE KEYS */; -/*!40000 ALTER TABLE `FtpUsers` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_VLData_imageContent` --- - -DROP TABLE IF EXISTS `m_VLData_imageContent`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_VLData_imageContent` ( - `imageID` int(11) NOT NULL, - `imageVersion` int(11) NOT NULL, - `SW_ID` int(11) NOT NULL, - `LicenseType` int(11) NOT NULL COMMENT 'free | testVersion | Key | ownLicenseKey | licenseServer | onlyOne', - `licenseServerAdress` varchar(100) DEFAULT NULL, - `comment` varchar(255) DEFAULT NULL, - PRIMARY KEY (`imageID`,`imageVersion`,`SW_ID`), - KEY `imageID_idx` (`imageID`), - KEY `imageVersion_idx` (`imageVersion`), - KEY `SW_ID_idx` (`SW_ID`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_VLData_imageContent` --- - -LOCK TABLES `m_VLData_imageContent` WRITE; -/*!40000 ALTER TABLE `m_VLData_imageContent` DISABLE KEYS */; -/*!40000 ALTER TABLE `m_VLData_imageContent` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_VLData_imageInfo` --- - -DROP TABLE IF EXISTS `m_VLData_imageInfo`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_VLData_imageInfo` ( - `GUID_imageID` varchar(45) NOT NULL, - `imageVersion` int(11) NOT NULL, - `image_name` varchar(45) DEFAULT NULL, - `image_path` varchar(255) DEFAULT NULL, - `image_lastCall` datetime DEFAULT NULL, - `image_create_time` datetime DEFAULT NULL, - `image_update_time` datetime DEFAULT NULL, - `image_owner` varchar(45) DEFAULT NULL, - `image_change_by` varchar(45) DEFAULT NULL, - `rec_create_time` datetime DEFAULT NULL, - `rec_change_time` datetime DEFAULT NULL, - `rec_owner` varchar(45) DEFAULT NULL, - `rec_change_by` varchar(45) DEFAULT NULL, - `content_operatingSystem` int(11) DEFAULT NULL, - `status_isCompressed` tinyint(1) DEFAULT '0', - `status_isSecure` tinyint(1) DEFAULT '0', - `status_isOptimzed` tinyint(1) DEFAULT '0', - `status_isValid` tinyint(1) DEFAULT '0', - `status_isReady` tinyint(1) DEFAULT '0', - `status_isDeleted` tinyint(1) DEFAULT NULL, - `status_isLastOfficialVersion` tinyint(1) DEFAULT NULL COMMENT 'wird verwendet, wenn z.B. eine Lecturezeit verändert werden soll, so dass dies nur möglich ist, wenn die Lecture auch die aktuelle Version verwendet. Wenn auf eine ImageVersion keine aktive Lecture mehr verweist, kann diese gelöscht werden.', - `cond_hasLicenseRestriction` tinyint(1) DEFAULT '0' COMMENT 'mehrere Kategorien: 1: free; 2: UserOwnLicense; 3: licenseServer; 4: restricted; wobei als Wert immer die höherwertigste der Programmpakete genommen wird', - `cond_hasInternetRestriction` tinyint(1) DEFAULT '0', - `cond_minRAM` int(11) DEFAULT NULL, - `cond_minCPUs` int(11) DEFAULT NULL, - `image_isTemplate` varchar(45) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT 'FALSE' COMMENT 'Flag zum setzen, ob ein Image als Vorlage behandelt werden soll oder als bestehendes Labor', - `image_filesize` bigint(20) DEFAULT NULL, - `image_syncMode` enum('only_local','to_be_published','being_published','successfully_published','to_be_decentralized','being_decentralized','successfully_decentralized') NOT NULL DEFAULT 'only_local' COMMENT 'ENUM(''only_local'',''to_be_published'',''being_published'',''successfully_published'',''to_be_decentralized'',''being_decentralized'',''successfully_decentralized'')', - PRIMARY KEY (`GUID_imageID`,`imageVersion`), - KEY `userID_idx` (`image_owner`,`image_change_by`,`rec_owner`,`rec_change_by`), - KEY `operatingSystemID_idx` (`content_operatingSystem`), - KEY `GUID_imageID_idx` (`GUID_imageID`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_VLData_imageInfo` --- - -LOCK TABLES `m_VLData_imageInfo` WRITE; -/*!40000 ALTER TABLE `m_VLData_imageInfo` DISABLE KEYS */; -/*!40000 ALTER TABLE `m_VLData_imageInfo` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_VLData_lecture` --- - -DROP TABLE IF EXISTS `m_VLData_lecture`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_VLData_lecture` ( - `lectureID` varchar(45) NOT NULL, - `name` varchar(45) DEFAULT NULL, - `isActive` tinyint(1) DEFAULT NULL, - `startTime` datetime DEFAULT NULL, - `endTime` datetime DEFAULT NULL, - `lastUsed` datetime DEFAULT NULL, - `shortDescription` varchar(50) DEFAULT NULL, - `description` varchar(500) DEFAULT NULL, - `imageID` varchar(45) DEFAULT NULL, - `imageVersion` int(11) DEFAULT NULL, - `admin_createTime` datetime DEFAULT NULL, - `admin_changeTime` datetime DEFAULT NULL, - `admin_owner` varchar(45) DEFAULT NULL, - `admin_change_by` varchar(45) DEFAULT NULL, - PRIMARY KEY (`lectureID`), - KEY `imageID_idx` (`imageID`), - KEY `userID_idx` (`admin_owner`,`admin_change_by`), - KEY `imageVersion_idx` (`imageVersion`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_VLData_lecture` --- - -LOCK TABLES `m_VLData_lecture` WRITE; -/*!40000 ALTER TABLE `m_VLData_lecture` DISABLE KEYS */; -/*!40000 ALTER TABLE `m_VLData_lecture` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_applicationsoftware` --- - -DROP TABLE IF EXISTS `m_applicationsoftware`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_applicationsoftware` ( - `SoftwarePackageID` int(11) NOT NULL, - `name` varchar(45) DEFAULT NULL, - `architecture` int(11) DEFAULT NULL COMMENT 'Angaben in Bit\n32 | 64', - `supplier` int(11) DEFAULT NULL, - PRIMARY KEY (`SoftwarePackageID`), - KEY `supplierID_idx` (`supplier`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_applicationsoftware` --- - -LOCK TABLES `m_applicationsoftware` WRITE; -/*!40000 ALTER TABLE `m_applicationsoftware` DISABLE KEYS */; -INSERT INTO `m_applicationsoftware` VALUES (0,'Office 2010',64,1); -/*!40000 ALTER TABLE `m_applicationsoftware` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_group` --- - -DROP TABLE IF EXISTS `m_group`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_group` ( - `groupID` int(11) NOT NULL, - `name` varchar(45) DEFAULT NULL, - `description` varchar(100) DEFAULT NULL, - PRIMARY KEY (`groupID`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_group` --- - -LOCK TABLES `m_group` WRITE; -/*!40000 ALTER TABLE `m_group` DISABLE KEYS */; -INSERT INTO `m_group` VALUES (0,'All','Enthält alle User'); -/*!40000 ALTER TABLE `m_group` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_image` --- - -DROP TABLE IF EXISTS `m_image`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_image` ( - `GUID_imageID` int(11) NOT NULL, - PRIMARY KEY (`GUID_imageID`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_image` --- - -LOCK TABLES `m_image` WRITE; -/*!40000 ALTER TABLE `m_image` DISABLE KEYS */; -/*!40000 ALTER TABLE `m_image` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_institution` --- - -DROP TABLE IF EXISTS `m_institution`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_institution` ( - `institutionID` varchar(50) NOT NULL, - `name` varchar(80) DEFAULT NULL, - PRIMARY KEY (`institutionID`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_institution` --- - -LOCK TABLES `m_institution` WRITE; -/*!40000 ALTER TABLE `m_institution` DISABLE KEYS */; -/*!40000 ALTER TABLE `m_institution` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_operatingSystem` --- - -DROP TABLE IF EXISTS `m_operatingSystem`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_operatingSystem` ( - `operatingSystemID` int(11) NOT NULL, - `name` varchar(45) DEFAULT NULL, - `architecture` int(11) DEFAULT NULL COMMENT 'Angaben in Bit\n32 | 64', - `supplier` int(11) DEFAULT NULL, - PRIMARY KEY (`operatingSystemID`), - KEY `supplierID_idx` (`supplier`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_operatingSystem` --- - -LOCK TABLES `m_operatingSystem` WRITE; -/*!40000 ALTER TABLE `m_operatingSystem` DISABLE KEYS */; -INSERT INTO `m_operatingSystem` VALUES (0,'Windows 7',64,0),(1,'Windows 7',32,0),(2,'Windows 8.1',64,0),(3,'Windows 8.1',32,0),(4,'Ubuntu 12',64,1),(5,'Ubuntu 12',32,1),(6,'Ubuntu 13',64,1),(7,'Ubuntu 13',32,1),(8,'Ubuntu 14',64,1),(9,'Ubuntu 14',32,1),(10,'openSUSE 13',64,2),(11,'openSUSE 13',32,2); -/*!40000 ALTER TABLE `m_operatingSystem` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_role` --- - -DROP TABLE IF EXISTS `m_role`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_role` ( - `roleID` int(11) NOT NULL, - `name` varchar(45) DEFAULT NULL, - `description` varchar(100) DEFAULT NULL, - PRIMARY KEY (`roleID`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_role` --- - -LOCK TABLES `m_role` WRITE; -/*!40000 ALTER TABLE `m_role` DISABLE KEYS */; -INSERT INTO `m_role` VALUES (0,'Creator','Darf die Lecture und das Image ändern'); -/*!40000 ALTER TABLE `m_role` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_supplier` --- - -DROP TABLE IF EXISTS `m_supplier`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_supplier` ( - `supplierID` int(11) NOT NULL, - `name` varchar(45) DEFAULT NULL, - PRIMARY KEY (`supplierID`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_supplier` --- - -LOCK TABLES `m_supplier` WRITE; -/*!40000 ALTER TABLE `m_supplier` DISABLE KEYS */; -INSERT INTO `m_supplier` VALUES (0,'Microsoft'),(1,'Ubuntu Foundation'),(2,'SUSE Linux GmbH'); -/*!40000 ALTER TABLE `m_supplier` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_user` --- - -DROP TABLE IF EXISTS `m_user`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_user` ( - `userID` varchar(45) NOT NULL, - `loginName` varchar(45) DEFAULT NULL, - `Nachname` varchar(45) DEFAULT NULL, - `Vorname` varchar(45) DEFAULT NULL, - `mail` varchar(45) DEFAULT NULL, - `lastLogin` datetime DEFAULT NULL, - `institution` varchar(45) DEFAULT NULL, - PRIMARY KEY (`userID`), - KEY `institutionID_idx` (`institution`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_user` --- - -LOCK TABLES `m_user` WRITE; -/*!40000 ALTER TABLE `m_user` DISABLE KEYS */; -/*!40000 ALTER TABLE `m_user` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `pm_VLData_image` --- - -DROP TABLE IF EXISTS `pm_VLData_image`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `pm_VLData_image` ( - `GUID` bigint(20) NOT NULL COMMENT 'GUID Typ', - `GUID_imageID` int(11) DEFAULT NULL, - `roleID` int(11) DEFAULT NULL, - `userID` int(11) DEFAULT NULL, - `groupID` int(11) DEFAULT NULL COMMENT 'es gibt eine Gruppe ALL', - `image_read` tinyint(1) DEFAULT NULL, - `image_write` tinyint(1) DEFAULT NULL, - `image_admin` tinyint(1) DEFAULT NULL, - `image_changePermission` tinyint(1) DEFAULT NULL, - `info_read` tinyint(1) DEFAULT NULL, - `info_write` tinyint(1) DEFAULT NULL, - `info_admin` tinyint(1) DEFAULT NULL, - `info_changePermission` tinyint(1) DEFAULT NULL, - `link_allowed` tinyint(1) DEFAULT NULL, - PRIMARY KEY (`GUID`), - KEY `GUID_imageID_idx` (`GUID_imageID`), - KEY `userID_idx` (`userID`), - KEY `roleID_idx` (`roleID`), - KEY `groupID_idx` (`groupID`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `pm_VLData_image` --- - -LOCK TABLES `pm_VLData_image` WRITE; -/*!40000 ALTER TABLE `pm_VLData_image` DISABLE KEYS */; -/*!40000 ALTER TABLE `pm_VLData_image` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `pm_VLData_lecture` --- - -DROP TABLE IF EXISTS `pm_VLData_lecture`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `pm_VLData_lecture` ( - `GUID` bigint(20) NOT NULL COMMENT 'GUID Typ', - `lectureID` int(11) DEFAULT NULL, - `roleID` int(11) DEFAULT NULL, - `userID` int(11) DEFAULT NULL, - `groupID` int(11) DEFAULT NULL COMMENT 'es gibt eine Gruppe ALL', - `rec_read` tinyint(1) DEFAULT NULL, - `rec_write` tinyint(1) DEFAULT NULL, - `rec_admin` tinyint(1) DEFAULT NULL, - `rec_changePermission` tinyint(1) DEFAULT NULL, - PRIMARY KEY (`GUID`), - KEY `lectureID_idx` (`lectureID`), - KEY `roleID_idx` (`roleID`), - KEY `userID_idx` (`userID`), - KEY `groupID_idx` (`groupID`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `pm_VLData_lecture` --- - -LOCK TABLES `pm_VLData_lecture` WRITE; -/*!40000 ALTER TABLE `pm_VLData_lecture` DISABLE KEYS */; -/*!40000 ALTER TABLE `pm_VLData_lecture` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `pm_group_role` --- - -DROP TABLE IF EXISTS `pm_group_role`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `pm_group_role` ( - `groupID` int(11) NOT NULL, - `roleID` int(11) NOT NULL, - PRIMARY KEY (`groupID`,`roleID`), - KEY `groupID_idx` (`groupID`), - KEY `roleID_idx` (`roleID`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `pm_group_role` --- - -LOCK TABLES `pm_group_role` WRITE; -/*!40000 ALTER TABLE `pm_group_role` DISABLE KEYS */; -INSERT INTO `pm_group_role` VALUES (1,1); -/*!40000 ALTER TABLE `pm_group_role` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `pm_user_group` --- - -DROP TABLE IF EXISTS `pm_user_group`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `pm_user_group` ( - `userID` int(11) NOT NULL, - `groupID` int(11) NOT NULL, - PRIMARY KEY (`userID`,`groupID`), - KEY `userID_idx` (`userID`), - KEY `groupID_idx` (`groupID`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `pm_user_group` --- - -LOCK TABLES `pm_user_group` WRITE; -/*!40000 ALTER TABLE `pm_user_group` DISABLE KEYS */; -INSERT INTO `pm_user_group` VALUES (1,1); -/*!40000 ALTER TABLE `pm_user_group` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `pm_user_role` --- - -DROP TABLE IF EXISTS `pm_user_role`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `pm_user_role` ( - `userID` int(11) NOT NULL, - `roleID` int(11) NOT NULL, - PRIMARY KEY (`userID`,`roleID`), - KEY `userID_idx` (`userID`), - KEY `roleID_idx` (`roleID`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `pm_user_role` --- - -LOCK TABLES `pm_user_role` WRITE; -/*!40000 ALTER TABLE `pm_user_role` DISABLE KEYS */; -INSERT INTO `pm_user_role` VALUES (1,1); -/*!40000 ALTER TABLE `pm_user_role` 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 2014-05-26 10:27:35 diff --git a/satellit_installer/static_files/db_openslx_dump.sql b/satellit_installer/static_files/db_openslx_dump.sql deleted file mode 100644 index 8e96340..0000000 --- a/satellit_installer/static_files/db_openslx_dump.sql +++ /dev/null @@ -1,282 +0,0 @@ -SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; - -SET time_zone = "+00:00"; - - - -CREATE TABLE `cat_setting` ( - - `catid` int(10) unsigned NOT NULL AUTO_INCREMENT, - - `name` varchar(250) NOT NULL, - - `sortval` smallint(5) unsigned NOT NULL, - - PRIMARY KEY (`catid`), - - KEY `sortval` (`sortval`) - -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - - - -CREATE TABLE `clientlog` ( - - `logid` int(10) unsigned NOT NULL AUTO_INCREMENT, - - `dateline` int(10) unsigned NOT NULL, - - `logtypeid` varchar(30) NOT NULL, - - `clientip` varchar(40) NOT NULL, - - `description` varchar(255) NOT NULL, - - `extra` text NOT NULL, - - PRIMARY KEY (`logid`), - - KEY `dateline` (`dateline`), - - KEY `logtypeid` (`logtypeid`,`dateline`), - - KEY `clientip` (`clientip`,`dateline`) - -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - - - -CREATE TABLE `configtgz` ( - - `configid` int(10) unsigned NOT NULL AUTO_INCREMENT, - - `title` varchar(200) NOT NULL, - - `filepath` varchar(255) NOT NULL, - - PRIMARY KEY (`configid`) - -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - - - -CREATE TABLE `configtgz_module` ( - - `moduleid` int(10) unsigned NOT NULL AUTO_INCREMENT, - - `title` varchar(200) NOT NULL, - - `moduletype` varchar(16) NOT NULL, - - `filepath` varchar(250) NOT NULL, - - `contents` text NOT NULL, - - PRIMARY KEY (`moduleid`), - - KEY `title` (`title`), - - KEY `moduletype` (`moduletype`,`title`) - -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - - - -CREATE TABLE `configtgz_x_module` ( - - `configid` int(10) unsigned NOT NULL, - - `moduleid` int(10) unsigned NOT NULL, - - PRIMARY KEY (`configid`,`moduleid`), - - KEY `moduleid` (`moduleid`) - -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - - - -CREATE TABLE `permission` ( - - `mask` int(10) unsigned NOT NULL, - - `identifier` varchar(32) NOT NULL, - - `description` text NOT NULL, - - PRIMARY KEY (`mask`), - - UNIQUE KEY `identifier` (`identifier`) - -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - - - -CREATE TABLE `property` ( - - `name` varchar(50) NOT NULL, - - `value` text NOT NULL, - - PRIMARY KEY (`name`) - -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - - - -CREATE TABLE `setting` ( - - `setting` varchar(28) NOT NULL, - - `catid` int(10) unsigned NOT NULL, - - `defaultvalue` text NOT NULL, - - `permissions` int(10) unsigned NOT NULL, - - `validator` varchar(250) NOT NULL DEFAULT '', - - `description` text NOT NULL, - - PRIMARY KEY (`setting`), - - KEY `catid` (`catid`,`setting`) - -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - - - -CREATE TABLE `setting_distro` ( - - `distroid` int(10) unsigned NOT NULL, - - `setting` varchar(28) NOT NULL, - - `value` text NOT NULL, - - PRIMARY KEY (`distroid`,`setting`), - - KEY `setting` (`setting`) - -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - - - -CREATE TABLE `setting_global` ( - - `setting` varchar(28) NOT NULL, - - `value` text NOT NULL, - - PRIMARY KEY (`setting`) - -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - - - -CREATE TABLE `user` ( - - `userid` int(10) unsigned NOT NULL AUTO_INCREMENT, - - `login` varchar(100) NOT NULL, - - `passwd` varchar(150) NOT NULL, - - `fullname` varchar(100) DEFAULT NULL, - - `phone` varchar(100) DEFAULT NULL, - - `email` varchar(100) DEFAULT NULL, - - `permissions` int(10) unsigned NOT NULL, - - PRIMARY KEY (`userid`), - - UNIQUE KEY `login` (`login`) - -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - - - - - -ALTER TABLE `configtgz_x_module` - - ADD CONSTRAINT `configtgz_x_module_ibfk_1` FOREIGN KEY (`configid`) REFERENCES `configtgz` (`configid`) ON DELETE CASCADE, - - ADD CONSTRAINT `configtgz_x_module_ibfk_2` FOREIGN KEY (`moduleid`) REFERENCES `configtgz_module` (`moduleid`); - - - -ALTER TABLE `setting` - - ADD CONSTRAINT `setting_ibfk_1` FOREIGN KEY (`catid`) REFERENCES `cat_setting` (`catid`) ON UPDATE CASCADE; - - - -ALTER TABLE `setting_distro` - - ADD CONSTRAINT `setting_distro_ibfk_1` FOREIGN KEY (`setting`) REFERENCES `setting` (`setting`) ON DELETE CASCADE ON UPDATE CASCADE; - - -SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; - -SET time_zone = "+00:00"; - - - -INSERT IGNORE INTO `cat_setting` (`catid`, `name`, `sortval`) VALUES - -(0, 'Unkategorisiert', 20000), - -(1, 'Inaktivität und Abschaltung', 30), - -(2, 'Internetzugriff', 20), - -(3, 'Zeitsynchronisation', 100), - -(4, 'Grundsystem', 10); - - - -INSERT IGNORE INTO `permission` (`mask`, `identifier`, `description`) VALUES - -(1, 'superadmin', 'SuperAdmin - Dieser Benutzer darf alle Einstellungen sehen und ändern, unabhängig davon, ob ihr die Rechte dafür explizit gewährt wurden.'), - -(2, 'baseconfig_global', 'Basiskonfiguration global und für jeden Poolraum ändern.'), - -(4, 'baseconfig_local', 'Basiskonfiguration für dem Benutzer zugewiesene Poolräume ändern.'); - - - -INSERT IGNORE INTO `setting` (`setting`, `catid`, `defaultvalue`, `permissions`, `validator`, `description`) VALUES - -('SLX_ADDONS', 0, 'vmware', 2, '', 'Zu ladende Addons. Zur Zeit steht nur vmware zur Verfügung.'), - -('SLX_BIOS_CLOCK', 3, 'off', 2, 'regex:/^(off|local|utc)$/', 'Legt fest, ob und wie die interne Uhr des Rechners im Bezug auf die Systemzeit des /MiniLinux/ gesetzt werden soll.\r\n*off* = Die interne Uhr des Rechners wird nicht verändert.\r\n*local* = Die interne Uhr wird auf die Lokalzeit gesetzt. Bevorzugt wenn z.B. noch eine native Windows-Installation auf dem PC vorhanden ist.\r\n*utc* = Die interne Uhr wird auf die /Koordinierte Weltzeit/ gesetzt. Dies ist die gängige Einstellung in einem reinen Linux-Umfeld.'), - -('SLX_LOGOUT_TIMEOUT', 1, '1800', 2, 'regex:/^\\d*$/', 'Zeit /in Sekunden/, die eine Benutzersitzung ohne Aktion sein darf, bevor sie beendet wird.\r\nFeld leer lassen, um die Funktion zu deaktivieren.'), - -('SLX_NET_DOMAIN', 2, '', 2, '', 'DNS-Domäne, in die sich die Clients eingliedern, sofern der DHCP Server keine solche vorgibt.'), - -('SLX_NTP_SERVER', 3, '0.de.pool.ntp.org 1.de.pool.ntp.org', 2, '', 'Adresse des NTP-Zeitservers. Es können mehrere Server mit Leerzeichen getrennt angegeben werden.\r\nDie Server werden der Reihe nach angefragt, bis ein antwortender Server gefunden wird.'), - -('SLX_PROXY_BLACKLIST', 2, '', 2, '', 'Adressen bzw. Adressbereiche, für die der Proxyserver nicht verwendet werden soll (z.B. der Adressbereich der Einrichtung). Gültige Angaben sind einzelne IP-Adressen, sowie IP-Bereiche in CIDR-Notation (z.B. 1.2.0.0/16). Mehrere Angaben können durch Leerzeichen getrennt werden.'), - -('SLX_PROXY_IP', 2, '', 2, '', 'Die Adresse des zu verwendenden Proxy Servers.'), - -('SLX_PROXY_MODE', 2, 'off', 2, 'regex:/^(off|on|auto|wpad)$/', 'Legt fest, ob zum Zugriff aufs Internet ein Proxy-Server benötigt wird.\r\n*off* = keinen Proxy benutzen.\r\n*on* = Proxy immer benutzen.\r\n*auto* = Proxy nur benutzen, wenn sich der Client-PC in einem privaten Adressbereich befindet.'), - -('SLX_PROXY_PORT', 2, '', 2, 'regex:/^\\d*$/', 'Der Port des zu verwendenden Proxy Servers.'), - -('SLX_PROXY_TYPE', 2, 'socks5', 2, '', 'Art des Proxys.\r\n*socks4*, *socks5*,\r\n*http-connect* (HTTP Proxy mit Unterstützung der CONNECT-Methode),\r\n*http-relay* (Klassischer HTTP Proxy)'), - -('SLX_REMOTE_LOG_SESSIONS', 0, 'anonymous', 2, 'regex:/^(yes|anonymous|no)$/', 'Legt fest, ob Logins und Logouts der Benutzer an den Satelliten gemeldet werden sollen.\r\n*yes* = Mit Benutzerkennung loggen\r\n*anonymous* = Anonym loggen\r\n*no* = Nicht loggen'), - -('SLX_ROOT_PASS', 4, '', 2, 'function:linuxPassword', 'Das root-Passwort des Grundsystems. Wird nur für Diagnosezwecke am Client benötigt.\r\nFeld leer lassen, um root-Logins zu verbieten.\r\n/Hinweis/: Das Passwort wird crypt $6$ gehasht, daher wir das Passwort nach dem Speichern nicht mehr lesbar sein!'), - -('SLX_SHUTDOWN_SCHEDULE', 1, '22:10 00:00', 2, 'regex:/^(\\s*\\d{1,2}:\\d{1,2})*$/', 'Feste Uhrzeit, zu der sich die Rechner ausschalten, auch wenn noch ein Benutzer aktiv ist.\r\nMehrere Zeitpunkte können durch Leerzeichen getrennt angegeben werden.'), - -('SLX_SHUTDOWN_TIMEOUT', 1, '1200', 2, 'regex:/^\\d*$/', 'Zeit in Sekunden, nach dem ein Rechner abgeschaltet wird, sofern kein Benutzer angemeldet ist.\r\nFeld leer lassen, um die Funktion zu deaktivieren.'); - - |