def removeApacheConf(self, domain): if os.path.isfile("/etc/apache2/sites-available/{0}.conf".format(domain)): Log.debug(self, "Removing Apache configuration") SSSFileUtils.rm(self, "/etc/apache2/sites-enabled/{0}.conf".format(domain)) SSSFileUtils.rm(self, "/etc/apache2/sites-available/{0}.conf".format(domain)) SSSService.reload_service(self, "apache2") SSSGit.add(self, ["/etc/apache2"], msg="Deleted {0} ".format(domain))
def removeApacheConf(self, domain): if os.path.isfile('/etc/apache2/sites-available/{0}.conf'.format(domain)): Log.debug(self, "Removing Apache configuration") SSSFileUtils.rm(self, '/etc/apache2/sites-enabled/{0}.conf'.format(domain)) SSSFileUtils.rm(self, '/etc/apache2/sites-available/{0}.conf'.format(domain)) SSSService.reload_service(self, 'apache2') SSSGit.add(self, ["/etc/apache2"], msg="Deleted {0} ".format(domain))
def enable(self): if not self.app.pargs.site_name: try: while not self.app.pargs.site_name: self.app.pargs.site_name = (input('Enter site name : ') .strip()) except IOError as e: Log.error(self, 'could not input site name') self.app.pargs.site_name = self.app.pargs.site_name.strip() # validate domain name (sss_domain, sss_www_domain) = ValidateDomain(self.app.pargs.site_name) # check if site exists if not check_domain_exists(self, sss_domain): Log.error(self, "site {0} does not exist".format(sss_domain)) if os.path.isfile('/etc/apache2/sites-available/{0}.conf' .format(sss_domain)): Log.info(self, "Enable domain {0:10} \t".format(sss_domain), end='') SSSFileUtils.create_symlink(self, ['/etc/apache2/sites-available/{0}.conf' .format(sss_domain), '/etc/apache2/sites-enabled/{0}.conf' .format(sss_domain)]) SSSGit.add(self, ["/etc/apache2"], msg="Enabled {0} " .format(sss_domain)) updateSiteInfo(self, sss_domain, enabled=True) Log.info(self, "[" + Log.ENDC + "OK" + Log.OKGREEN + "]") if not SSSService.reload_service(self, 'apache2'): Log.error(self, "service Apache2 reload failed. " "check issues with `apachectl configtest` command") else: Log.error(self, "Apache configuration file does not exist" .format(sss_domain))
def default(self): if not self.app.pargs.site_name: try: while not self.app.pargs.site_name: self.app.pargs.site_name = (input('Enter site name : ') .strip()) except IOError as e: Log.error(self, 'Unable to read input, Please try again') self.app.pargs.site_name = self.app.pargs.site_name.strip() (sss_domain, sss_www_domain) = ValidateDomain(self.app.pargs.site_name) if not check_domain_exists(self, sss_domain): Log.error(self, "site {0} does not exist".format(sss_domain)) sss_site_webroot = SSSVariables.sss_webroot + sss_domain if os.path.isfile('/etc/apache2/sites-available/{0}.conf' .format(sss_domain)): try: SSSShellExec.invoke_editor(self, '/etc/apache2/sites-availa' 'ble/{0}.conf'.format(sss_domain)) except CommandExecutionError as e: Log.error(self, "Failed invoke editor") if (SSSGit.checkfilestatus(self, "/etc/apache2", '/etc/apache2/sites-available/{0}.conf'.format(sss_domain))): SSSGit.add(self, ["/etc/apache2"], msg="Edit website: {0}" .format(sss_domain)) # Reload Apache if not SSSService.reload_service(self, 'apache2'): Log.error(self, "service apache2 reload failed. " "check issues with `service apache2 reload` command") else: Log.error(self, "Apache configuration file does not exists" .format(sss_domain))
def stop(self): """Stop services""" services = [] if not (self.app.pargs.apache2 or self.app.pargs.php or self.app.pargs.mysql or self.app.pargs.memcache): self.app.pargs.apache2 = True self.app.pargs.php = True self.app.pargs.mysql = True if self.app.pargs.apache2: if SSSAptGet.is_installed(self, 'apache2'): services = services + ['apache2'] else: Log.info(self, 'Apache is not installed') if self.app.pargs.php: if SSSAptGet.is_installed(self, 'php7.0-fpm'): services = services + ['php7.0-fpm'] else: Log.info(self, "PHP7-FPM is not installed") if self.app.pargs.mysql: if ((SSSVariables.sss_mysql_host is "localhost") or (SSSVariables.sss_mysql_host is "127.0.0.1")): if (SSSAptGet.is_installed(self, 'mysql-server') or SSSAptGet.is_installed(self, 'percona-server-server-5.6') or SSSAptGet.is_installed(self, 'mariadb-server')): services = services + ['mysql'] else: Log.info(self, "MySQL is not installed") else: Log.warn( self, "Remote MySQL found, " "Unable to check MySQL service status") if self.app.pargs.memcache: if SSSAptGet.is_installed(self, 'memcached'): services = services + ['memcached'] else: Log.info(self, "Memcache is not installed") for service in services: Log.debug(self, "Stopping service: {0}".format(service)) SSSService.stop_service(self, service)
def stop(self): """Stop services""" services = [] if not (self.app.pargs.apache2 or self.app.pargs.php or self.app.pargs.mysql or self.app.pargs.memcache): self.app.pargs.apache2 = True self.app.pargs.php = True self.app.pargs.mysql = True if self.app.pargs.apache2: if SSSAptGet.is_installed(self,'apache2'): services = services + ['apache2'] else: Log.info(self,'Apache is not installed') if self.app.pargs.php: if SSSAptGet.is_installed(self, 'php7.0-fpm'): services = services + ['php7.0-fpm'] else: Log.info(self, "PHP7-FPM is not installed") if self.app.pargs.mysql: if ((SSSVariables.sss_mysql_host is "localhost") or (SSSVariables.sss_mysql_host is "127.0.0.1")): if (SSSAptGet.is_installed(self, 'mysql-server') or SSSAptGet.is_installed(self, 'percona-server-server-5.6') or SSSAptGet.is_installed(self, 'mariadb-server')): services = services + ['mysql'] else: Log.info(self, "MySQL is not installed") else: Log.warn(self, "Remote MySQL found, " "Unable to check MySQL service status") if self.app.pargs.memcache: if SSSAptGet.is_installed(self, 'memcached'): services = services + ['memcached'] else: Log.info(self, "Memcache is not installed") for service in services: Log.debug(self, "Stopping service: {0}".format(service)) SSSService.stop_service(self, service)
def disable(self): if not self.app.pargs.site_name: try: while not self.app.pargs.site_name: self.app.pargs.site_name = ( input('Enter site name : ').strip()) except IOError as e: Log.error(self, 'could not input site name') self.app.pargs.site_name = self.app.pargs.site_name.strip() (sss_domain, sss_www_domain) = ValidateDomain(self.app.pargs.site_name) # check if site exists if not check_domain_exists(self, sss_domain): Log.error(self, "site {0} does not exist".format(sss_domain)) if os.path.isfile( '/etc/apache2/sites-available/{0}.conf'.format(sss_domain)): Log.info(self, "Disable domain {0:10} \t".format(sss_domain), end='') if not os.path.isfile( '/etc/apache2/sites-enabled/{0}.conf'.format(sss_domain)): Log.info(self, "[" + Log.FAIL + "Failed" + Log.OKGREEN + "]") Log.info(self, "Site {0} already disabled".format(sss_domain)) else: SSSFileUtils.remove_symlink( self, '/etc/apache2/sites-enabled/{0}.conf'.format(sss_domain)) SSSGit.add(self, ["/etc/apache2"], msg="Disabled {0} ".format(sss_domain)) updateSiteInfo(self, sss_domain, enabled=False) Log.info(self, "[" + Log.ENDC + "OK" + Log.OKGREEN + "]") if not SSSService.reload_service(self, 'apache2'): Log.error( self, "service apache2 reload failed. " "check issues with `apachectl configtest` command") else: Log.error( self, "Apache configuration file does not exist".format(sss_domain))
def default(self): if not self.app.pargs.site_name: try: while not self.app.pargs.site_name: self.app.pargs.site_name = ( input('Enter site name : ').strip()) except IOError as e: Log.error(self, 'Unable to read input, Please try again') self.app.pargs.site_name = self.app.pargs.site_name.strip() (sss_domain, sss_www_domain) = ValidateDomain(self.app.pargs.site_name) if not check_domain_exists(self, sss_domain): Log.error(self, "site {0} does not exist".format(sss_domain)) sss_site_webroot = SSSVariables.sss_webroot + sss_domain if os.path.isfile( '/etc/apache2/sites-available/{0}.conf'.format(sss_domain)): try: SSSShellExec.invoke_editor( self, '/etc/apache2/sites-availa' 'ble/{0}.conf'.format(sss_domain)) except CommandExecutionError as e: Log.error(self, "Failed invoke editor") if (SSSGit.checkfilestatus( self, "/etc/apache2", '/etc/apache2/sites-available/{0}.conf'.format(sss_domain)) ): SSSGit.add(self, ["/etc/apache2"], msg="Edit website: {0}".format(sss_domain)) # Reload Apache if not SSSService.reload_service(self, 'apache2'): Log.error( self, "service apache2 reload failed. " "check issues with `service apache2 reload` command") else: Log.error( self, "Apache configuration file does not exists".format(sss_domain))
def default(self): # self.app.render((data), 'default.mustache') # Check domain name validation data = dict() host, port = None, None try: stype, cache = detSitePar(vars(self.app.pargs)) except RuntimeError as e: Log.debug(self, str(e)) Log.error(self, "Please provide valid options to creating site") if stype is None and self.app.pargs.proxy: stype, cache = 'proxy', '' proxyinfo = self.app.pargs.proxy[0].strip() if not proxyinfo: Log.error(self, "Please provide proxy server host information") proxyinfo = proxyinfo.split(':') host = proxyinfo[0].strip() port = '80' if len(proxyinfo) < 2 else proxyinfo[1].strip() elif stype is None and not self.app.pargs.proxy: stype, cache = 'html', 'basic' elif stype and self.app.pargs.proxy: Log.error(self, "proxy should not be used with other site types") if (self.app.pargs.proxy and (self.app.pargs.pagespeed or self.app.pargs.hhvm)): Log.error(self, "Proxy site can not run on pagespeed or hhvm") if not self.app.pargs.site_name: try: while not self.app.pargs.site_name: # preprocessing before finalize site name self.app.pargs.site_name = ( input('Enter site name : ').strip()) except IOError as e: Log.debug(self, str(e)) Log.error(self, "Unable to input site name, Please try again!") self.app.pargs.site_name = self.app.pargs.site_name.strip() (sss_domain, sss_www_domain) = ValidateDomain(self.app.pargs.site_name) if not sss_domain.strip(): Log.error("Invalid domain name, " "Provide valid domain name") sss_site_webroot = SSSVariables.sss_webroot + sss_domain if check_domain_exists(self, sss_domain): Log.error(self, "site {0} already exists".format(sss_domain)) elif os.path.isfile( '/etc/apache2/sites-available/{0}.conf'.format(sss_domain)): Log.error( self, "Apache configuration /etc/apache2/sites-available/" "{0} already exists".format(sss_domain)) if stype in ['html', 'php']: data = dict(site_name=sss_domain, www_domain=sss_www_domain, static=True, basic=False, webroot=sss_site_webroot) if stype == 'php': data['static'] = False data['basic'] = True elif stype in ['mysql', 'wp']: data = dict(site_name=sss_domain, www_domain=sss_www_domain, static=False, basic=True, wp=False, w3tc=False, wpfc=False, wpsc=False, wpredis=False, multisite=False, wpsubdir=False, webroot=sss_site_webroot, sss_db_name='', sss_db_user='', sss_db_pass='', sss_db_host='') else: pass # Check rerequired packages are installed or not sss_auth = site_package_check(self, stype) try: pre_run_checks(self) except SiteError as e: Log.debug(self, str(e)) Log.error(self, "Apache configuration check failed.") try: try: # setup Apache configuration, and webroot setupdomain(self, data) except SiteError as e: # call cleanup actions on failure Log.info(self, Log.FAIL + "Oops Something went wrong !!") Log.info(self, Log.FAIL + "Calling cleanup actions ...") doCleanupAction(self, domain=sss_domain, webroot=data['webroot']) Log.debug(self, str(e)) Log.error( self, "Check logs for reason " "`tail /var/log/sss/sss.log` & Try Again!!!") addNewSite(self, sss_domain, stype, cache, sss_site_webroot) # Setup Database for MySQL site if 'sss_db_name' in data.keys() and not data['wp']: try: data = setupdatabase(self, data) # Add database information for site into database updateSiteInfo(self, sss_domain, db_name=data['sss_db_name'], db_user=data['sss_db_user'], db_password=data['sss_db_pass'], db_host=data['sss_db_host']) except SiteError as e: # call cleanup actions on failure Log.debug(self, str(e)) Log.info(self, Log.FAIL + "Oops Something went wrong !!") Log.info(self, Log.FAIL + "Calling cleanup actions ...") doCleanupAction(self, domain=sss_domain, webroot=data['webroot'], dbname=data['sss_db_name'], dbuser=data['sss_db_user'], dbhost=data['sss_db_host']) deleteSiteInfo(self, sss_domain) Log.error( self, "Check logs for reason " "`tail /var/log/sss/sss.log` & Try Again!!!") try: sssdbconfig = open( "{0}/sss-config.php".format(sss_site_webroot), encoding='utf-8', mode='w') sssdbconfig.write("<?php \ndefine('DB_NAME', '{0}');" "\ndefine('DB_USER', '{1}'); " "\ndefine('DB_PASSWORD', '{2}');" "\ndefine('DB_HOST', '{3}');\n?>".format( data['sss_db_name'], data['sss_db_user'], data['sss_db_pass'], data['sss_db_host'])) sssdbconfig.close() stype = 'mysql' except IOError as e: Log.debug(self.str(e)) Log.debug( self, "Error occured while generating " "sss-config.php") Log.info(self, Log.FAIL + "Oops Something went wrong !!") Log.info(self, Log.FAIL + "Calling cleanup actions ...") doCleanupAction(self, domain=sss_domain, webroot=data['webroot'], dbname=data['sss_db_name'], dbuser=data['sss_db_user'], dbhost=data['sss_db_host']) deleteSiteInfo(self, sss_domain) Log.error( self, "Check logs for reason " "`tail /var/log/sss/sss.log` & Try Again!!!") if not SSSService.reload_service(self, 'apache2'): Log.info(self, Log.FAIL + "Oops Something went wrong !!") Log.info(self, Log.FAIL + "Calling cleanup actions ...") doCleanupAction(self, domain=sss_domain, webroot=data['webroot']) deleteSiteInfo(self, sss_domain) Log.info( self, Log.FAIL + "service Apache reload failed." "check issues with `apachectl configtest` command") Log.error( self, "Check logs for reason " "`tail /var/log/sss/sss.log` & Try Again!!!") SSSGit.add(self, ["/etc/apache2"], msg="{0} created with {1} {2}".format( sss_www_domain, stype, cache)) # Setup Permissions for webroot try: setwebrootpermissions(self, data['webroot']) #fix for log permission Log.debug(self, "Fixing Log file Permissions") if os.path.isfile( '/var/log/apache2/{0}.access.log'.format(sss_domain)): SSSFileUtils.chown( self, '/var/log/apache2/{0}.access.log'.format(sss_domain), "root", "root") if os.path.isfile( '/var/log/apache2/{0}.error.log'.format(sss_domain)): SSSFileUtils.chown( self, '/var/log/apache2/{0}.error.log'.format(sss_domain), "root", "root") except SiteError as e: Log.debug(self, str(e)) Log.info(self, Log.FAIL + "Oops Something went wrong !!") Log.info(self, Log.FAIL + "Calling cleanup actions ...") doCleanupAction(self, domain=sss_domain, webroot=data['webroot']) deleteSiteInfo(self, sss_domain) Log.error( self, "Check logs for reason " "`tail /var/log/sss/sss.log` & Try Again!!!") if sss_auth and len(sss_auth): for msg in sss_auth: Log.info(self, Log.ENDC + msg, log=False) Log.info( self, "Successfully created site" " http://{0}".format(sss_domain)) except SiteError as e: Log.error( self, "Check logs for reason " "`tail /var/log/sss/sss.log` & Try Again!!!")
def default(self): # self.app.render((data), 'default.mustache') # Check domain name validation data = dict() host,port = None, None try: stype, cache = detSitePar(vars(self.app.pargs)) except RuntimeError as e: Log.debug(self, str(e)) Log.error(self, "Please provide valid options to creating site") if stype is None and self.app.pargs.proxy: stype, cache = 'proxy', '' proxyinfo = self.app.pargs.proxy[0].strip() if not proxyinfo: Log.error(self, "Please provide proxy server host information") proxyinfo = proxyinfo.split(':') host = proxyinfo[0].strip() port = '80' if len(proxyinfo) < 2 else proxyinfo[1].strip() elif stype is None and not self.app.pargs.proxy: stype, cache = 'html', 'basic' elif stype and self.app.pargs.proxy: Log.error(self, "proxy should not be used with other site types") if (self.app.pargs.proxy and (self.app.pargs.pagespeed or self.app.pargs.hhvm)): Log.error(self, "Proxy site can not run on pagespeed or hhvm") if not self.app.pargs.site_name: try: while not self.app.pargs.site_name: # preprocessing before finalize site name self.app.pargs.site_name = (input('Enter site name : ') .strip()) except IOError as e: Log.debug(self, str(e)) Log.error(self, "Unable to input site name, Please try again!") self.app.pargs.site_name = self.app.pargs.site_name.strip() (sss_domain, sss_www_domain) = ValidateDomain(self.app.pargs.site_name) if not sss_domain.strip(): Log.error("Invalid domain name, " "Provide valid domain name") sss_site_webroot = SSSVariables.sss_webroot + sss_domain if check_domain_exists(self, sss_domain): Log.error(self, "site {0} already exists".format(sss_domain)) elif os.path.isfile('/etc/apache2/sites-available/{0}.conf' .format(sss_domain)): Log.error(self, "Apache configuration /etc/apache2/sites-available/" "{0} already exists".format(sss_domain)) if stype in ['html', 'php']: data = dict(site_name=sss_domain, www_domain=sss_www_domain, static=True, basic=False,webroot=sss_site_webroot) if stype == 'php': data['static'] = False data['basic'] = True elif stype in ['mysql', 'wp']: data = dict(site_name=sss_domain, www_domain=sss_www_domain, static=False, basic=True, wp=False, w3tc=False, wpfc=False, wpsc=False, wpredis=False, multisite=False, wpsubdir=False, webroot=sss_site_webroot, sss_db_name='', sss_db_user='', sss_db_pass='', sss_db_host='') else: pass # Check rerequired packages are installed or not sss_auth = site_package_check(self, stype) try: pre_run_checks(self) except SiteError as e: Log.debug(self, str(e)) Log.error(self, "Apache configuration check failed.") try: try: # setup Apache configuration, and webroot setupdomain(self, data) except SiteError as e: # call cleanup actions on failure Log.info(self, Log.FAIL + "Oops Something went wrong !!") Log.info(self, Log.FAIL + "Calling cleanup actions ...") doCleanupAction(self, domain=sss_domain, webroot=data['webroot']) Log.debug(self, str(e)) Log.error(self, "Check logs for reason " "`tail /var/log/sss/sss.log` & Try Again!!!") addNewSite(self, sss_domain, stype, cache, sss_site_webroot) # Setup Database for MySQL site if 'sss_db_name' in data.keys() and not data['wp']: try: data=setupdatabase(self,data) # Add database information for site into database updateSiteInfo(self, sss_domain, db_name=data['sss_db_name'], db_user=data['sss_db_user'], db_password=data['sss_db_pass'], db_host=data['sss_db_host']) except SiteError as e: # call cleanup actions on failure Log.debug(self, str(e)) Log.info(self, Log.FAIL + "Oops Something went wrong !!") Log.info(self, Log.FAIL + "Calling cleanup actions ...") doCleanupAction(self, domain=sss_domain, webroot=data['webroot'], dbname=data['sss_db_name'], dbuser=data['sss_db_user'], dbhost=data['sss_db_host']) deleteSiteInfo(self, sss_domain) Log.error(self, "Check logs for reason " "`tail /var/log/sss/sss.log` & Try Again!!!") try: sssdbconfig = open("{0}/sss-config.php" .format(sss_site_webroot), encoding='utf-8', mode='w') sssdbconfig.write("<?php \ndefine('DB_NAME', '{0}');" "\ndefine('DB_USER', '{1}'); " "\ndefine('DB_PASSWORD', '{2}');" "\ndefine('DB_HOST', '{3}');\n?>" .format(data['sss_db_name'], data['sss_db_user'], data['sss_db_pass'], data['sss_db_host'])) sssdbconfig.close() stype = 'mysql' except IOError as e: Log.debug(self.str(e)) Log.debug(self, "Error occured while generating " "sss-config.php") Log.info(self, Log.FAIL + "Oops Something went wrong !!") Log.info(self, Log.FAIL + "Calling cleanup actions ...") doCleanupAction(self, domain=sss_domain, webroot=data['webroot'], dbname=data['sss_db_name'], dbuser=data['sss_db_user'], dbhost=data['sss_db_host']) deleteSiteInfo(self, sss_domain) Log.error(self, "Check logs for reason " "`tail /var/log/sss/sss.log` & Try Again!!!") if not SSSService.reload_service(self, 'apache2'): Log.info(self, Log.FAIL + "Oops Something went wrong !!") Log.info(self, Log.FAIL + "Calling cleanup actions ...") doCleanupAction(self, domain=sss_domain, webroot=data['webroot']) deleteSiteInfo(self, sss_domain) Log.info(self, Log.FAIL + "service Apache reload failed." "check issues with `apachectl configtest` command") Log.error(self, "Check logs for reason " "`tail /var/log/sss/sss.log` & Try Again!!!") SSSGit.add(self, ["/etc/apache2"], msg="{0} created with {1} {2}" .format(sss_www_domain, stype, cache)) # Setup Permissions for webroot try: setwebrootpermissions(self, data['webroot']) #fix for log permission Log.debug(self,"Fixing Log file Permissions") if os.path.isfile('/var/log/apache2/{0}.access.log' .format(sss_domain)): SSSFileUtils.chown(self,'/var/log/apache2/{0}.access.log' .format(sss_domain),"root","root") if os.path.isfile('/var/log/apache2/{0}.error.log' .format(sss_domain)): SSSFileUtils.chown(self,'/var/log/apache2/{0}.error.log' .format(sss_domain),"root","root") except SiteError as e: Log.debug(self, str(e)) Log.info(self, Log.FAIL + "Oops Something went wrong !!") Log.info(self, Log.FAIL + "Calling cleanup actions ...") doCleanupAction(self, domain=sss_domain, webroot=data['webroot']) deleteSiteInfo(self, sss_domain) Log.error(self, "Check logs for reason " "`tail /var/log/sss/sss.log` & Try Again!!!") if sss_auth and len(sss_auth): for msg in sss_auth: Log.info(self, Log.ENDC + msg, log=False) Log.info(self, "Successfully created site" " http://{0}".format(sss_domain)) except SiteError as e: Log.error(self, "Check logs for reason " "`tail /var/log/sss/sss.log` & Try Again!!!")
def migrate_mariadb(self): # Backup all database SSSMysql.backupAll(self) # Add MariaDB repo Log.info(self, "Adding repository for MariaDB, please wait...") mysql_pref = "Package: *\nPin: origin sfo1.mirrors.digitalocean.com" "\nPin-Priority: 1000\n" with open("/etc/apt/preferences.d/" "MariaDB.pref", "w") as mysql_pref_file: mysql_pref_file.write(mysql_pref) SSSRepo.add(self, repo_url=SSSVariables.sss_mysql_repo) Log.debug(self, "Adding key for {0}".format(SSSVariables.sss_mysql_repo)) SSSRepo.add_key(self, "0xcbcb082a1bb943db", keyserver="keyserver.ubuntu.com") config = configparser.ConfigParser() if os.path.exists("/etc/mysql/conf.d/my.cnf"): config.read("/etc/mysql/conf.d/my.cnf") else: config.read(os.path.expanduser("~") + "/.my.cnf") try: chars = config["client"]["password"] except Exception as e: Log.error(self, "Error: process exited with error %s" % e) Log.debug(self, "Pre-seeding MariaDB") Log.debug( self, 'echo "mariadb-server-10.0 ' "mysql-server/root_password " 'password " | ' "debconf-set-selections" ) SSSShellExec.cmd_exec( self, 'echo "mariadb-server-10.0 ' "mysql-server/root_password " 'password {chars}" | ' "debconf-set-selections".format(chars=chars), log=False, ) Log.debug( self, 'echo "mariadb-server-10.0 ' "mysql-server/root_password_again " 'password " | ' "debconf-set-selections", ) SSSShellExec.cmd_exec( self, 'echo "mariadb-server-10.0 ' "mysql-server/root_password_again " 'password {chars}" | ' "debconf-set-selections".format(chars=chars), log=False, ) # Install MariaDB apt_packages = SSSVariables.sss_mysql # If PHP is installed then install php5-mysql if SSSAptGet.is_installed(self, "php5-fpm"): apt_packages = apt_packages + ["php5-mysql"] # If mail server is installed then install dovecot-sql and postfix-sql if SSSAptGet.is_installed(self, "dovecot-core"): apt_packages = apt_packages + ["dovecot-mysql", "postfix-mysql", "libclass-dbi-mysql-perl"] Log.info(self, "Updating apt-cache, please wait...") SSSAptGet.update(self) Log.info(self, "Installing MariaDB, please wait...") SSSAptGet.remove(self, ["mysql-common", "libmysqlclient18"]) SSSAptGet.auto_remove(self) SSSAptGet.install(self, apt_packages) # Restart dovecot and postfix if installed if SSSAptGet.is_installed(self, "dovecot-core"): SSSService.restart_service(self, "dovecot") SSSService.restart_service(self, "postfix")
def default(self): # All package update apt_packages = [] packages = [] if ((not self.app.pargs.web) and (not self.app.pargs.apache2) and (not self.app.pargs.php) and (not self.app.pargs.mysql) and (not self.app.pargs.all)): self.app.pargs.web = True if self.app.pargs.all: self.app.pargs.web = True if self.app.pargs.web: self.app.pargs.apache2 = True self.app.pargs.php = True self.app.pargs.mysql = True if self.app.pargs.apache2: if SSSAptGet.is_installed(self, 'apache2'): apt_packages = apt_packages + SSSVariables.sss_apache else: Log.info(self, "Apache is not already installed") if self.app.pargs.php: if SSSAptGet.is_installed(self, 'php7.0-fpm'): apt_packages = apt_packages + SSSVariables.sss_php else: Log.info(self, "PHP is not installed") if self.app.pargs.mysql: if SSSAptGet.is_installed(self, 'mariadb-server'): apt_packages = apt_packages + SSSVariables.sss_mysql else: Log.info(self, "MariaDB is not installed") if len(packages) or len(apt_packages): Log.info( self, "During package update process non Apache" " parts of your site may remain down") # Check prompt if (not self.app.pargs.no_prompt): start_upgrade = input("Do you want to continue:[y/N]") if start_upgrade != "Y" and start_upgrade != "y": Log.error(self, "Not starting package update") Log.info(self, "Updating packages, please wait...") if len(apt_packages): # apt-get update SSSAptGet.update(self) # Update packages SSSAptGet.install(self, apt_packages) # Post Actions after package updates if set(SSSVariables.sss_apache).issubset(set(apt_packages)): SSSService.restart_service(self, 'apache2') if set(SSSVariables.sss_php).issubset(set(apt_packages)): SSSService.restart_service(self, 'php7.0-fpm') if set(SSSVariables.sss_mysql).issubset(set(apt_packages)): SSSService.restart_service(self, 'mysql') if len(packages): pass Log.info(self, "Successfully updated packages")
def post_pref(self, apt_packages, packages): """Post activity after installation of packages""" if len(apt_packages): if set(SSSVariables.sss_apache).issubset(set(apt_packages)): if not (os.path.isfile('/etc/apache2/conf-available/acl.conf')): data = dict(webroot=SSSVariables.sss_webroot) Log.debug(self, 'Writting the Apache configuration to ' 'file /etc/apache2/conf-available/acl.conf') sss_apache = open('/etc/apache2/conf-available/acl.conf', encoding='utf-8', mode='w') self.app.render((data), 'acl.mustache', out=sss_apache) sss_apache.close() # 22222 port setting Log.debug(self, 'Writting the Apache configuration to ' 'file /etc/apache2/sites-available/' '22222') sss_apache = open('/etc/apache2/sites-available/22222.conf',encoding='utf-8', mode='w') self.app.render((data), '22222.mustache', out=sss_apache) sss_apache.close() passwd = ''.join([random.choice (string.ascii_letters + string.digits) for n in range(6)]) try: SSSShellExec.cmd_exec(self, "printf \"SSS:" "$(openssl passwd -crypt " "{password} 2> /dev/null)\n\"" "> /etc/apache2/htpasswd-sss " "2>/dev/null" .format(password=passwd)) except CommandExecutionError as e: Log.error(self, "Failed to save HTTP Auth") # Create Symbolic link for 22222 SSSFileUtils.create_symlink(self, ['/etc/apache2/' 'sites-available/' '22222.conf', '/etc/apache2/' 'sites-enabled/' '22222.conf']) # Create htdocs folder if not os.path.exists('{0}22222/htdocs' .format(SSSVariables.sss_webroot)): Log.debug(self, "Creating directory " "{0}22222/htdocs " .format(SSSVariables.sss_webroot)) os.makedirs('{0}22222/htdocs' .format(SSSVariables.sss_webroot)) if not os.path.exists('/etc/apache2/ssl'): Log.debug(self, "Creating directory " "/etc/apache2/ssl/") os.makedirs('/etc/apache2/ssl') try: SSSShellExec.cmd_exec(self, "openssl genrsa -out " "/etc/apache2/ssl/22222.key 2048") SSSShellExec.cmd_exec(self, "openssl req -new -batch " "-subj /commonName=127.0.0.1/ " "-key /etc/apache2/ssl/22222.key " "-out /etc/apache2/ssl/" "22222.csr") SSSFileUtils.mvfile(self, "/etc/apache2/ssl/22222.key", "/etc/apache2/ssl/" "22222.key.org") SSSShellExec.cmd_exec(self, "openssl rsa -in " "/etc/apache2/ssl/" "22222.key.org -out " "/etc/apache2/ssl/22222.key") SSSShellExec.cmd_exec(self, "openssl x509 -req -days " "3652 -in /etc/apache2/ssl/" "22222.csr -signkey " "/etc/apache2/ssl/22222.key -out " "/etc/apache2/ssl/22222.crt") except CommandExecutionError as e: Log.error(self, "Failed to generate SSL for 22222") # Apache Configation into GIT SSSGit.add(self, ["/etc/apache2"], msg="Adding Apache into Git") SSSService.restart_service(self, 'apache2') self.msg = (self.msg + ["HTTP Auth User Name: SSS"] + ["HTTP Auth Password : {0}".format(passwd)]) if set(SSSVariables.sss_php).issubset(set(apt_packages)): # Create log directories if not os.path.exists('/var/log/php/7.0/'): Log.debug(self, 'Creating directory /var/log/php/7.0/') os.makedirs('/var/log/php/7.0/') # TOD : xdebug # Parse etc/php5/fpm/php.ini config = configparser.ConfigParser() Log.debug(self, "configuring php file /etc/php/7.0/fpm/php.ini") config.read('/etc/php/7.0/fpm/php.ini') config['PHP']['expose_php'] = 'Off' config['PHP']['post_max_size'] = '100M' config['PHP']['upload_max_filesize'] = '100M' config['PHP']['max_execution_time'] = '300' config['PHP']['date.timezone'] = SSSVariables.sss_timezone with open('/etc/php/7.0/fpm/php.ini', encoding='utf-8', mode='w') as configfile: Log.debug(self, "Writting php configuration into " "/etc/php/7.0/fpm/php.ini") config.write(configfile) # Prase /etc/php/7.0/fpm/php-fpm.conf config = configparser.ConfigParser() Log.debug(self, "configuring php file" "/etc/php/7.0/fpm/php-fpm.conf") config.read_file(codecs.open("/etc/php/7.0/fpm/php-fpm.conf", "r", "utf8")) config['global']['error_log'] = '/var/log/php/7.0/fpm.log' config.remove_option('global', 'include') config['global']['log_level'] = 'notice' config['global']['include'] = '/etc/php/7.0/fpm/pool.d/*.conf' with codecs.open('/etc/php/7.0/fpm/php-fpm.conf', encoding='utf-8', mode='w') as configfile: Log.debug(self, "writting php7 configuration into " "/etc/php/7.0/fpm/php-fpm.conf") config.write(configfile) # Parse /etc/php/7.0/fpm/pool.d/www.conf config = configparser.ConfigParser() config.read_file(codecs.open('/etc/php/7.0/fpm/pool.d/www.conf', "r", "utf8")) config['www']['ping.path'] = '/ping' config['www']['pm.status_path'] = '/status' config['www']['pm.max_requests'] = '500' config['www']['pm.max_children'] = '100' config['www']['pm.start_servers'] = '20' config['www']['pm.min_spare_servers'] = '10' config['www']['pm.max_spare_servers'] = '30' config['www']['request_terminate_timeout'] = '300' config['www']['pm'] = 'ondemand' config['www']['listen'] = '127.0.0.1:9000' with codecs.open('/etc/php/7.0/fpm/pool.d/www.conf', encoding='utf-8', mode='w') as configfile: Log.debug(self, "writting PHP5 configuration into " "/etc/php/7.0/fpm/pool.d/www.conf") config.write(configfile) #TODO : Debug Config #TODO : Disable xdebug # PHP and Debug pull configuration if not os.path.exists('{0}22222/htdocs/fpm/status/' .format(SSSVariables.sss_webroot)): Log.debug(self, 'Creating directory ' '{0}22222/htdocs/fpm/status/ ' .format(SSSVariables.sss_webroot)) os.makedirs('{0}22222/htdocs/fpm/status/' .format(SSSVariables.sss_webroot)) open('{0}22222/htdocs/fpm/status/debug' .format(SSSVariables.sss_webroot), encoding='utf-8', mode='a').close() open('{0}22222/htdocs/fpm/status/php' .format(SSSVariables.sss_webroot), encoding='utf-8', mode='a').close() # Write info.php if not os.path.exists('{0}22222/htdocs/php/' .format(SSSVariables.sss_webroot)): Log.debug(self, 'Creating directory ' '{0}22222/htdocs/php/ ' .format(SSSVariables.sss_webroot)) os.makedirs('{0}22222/htdocs/php' .format(SSSVariables.sss_webroot)) with open("{0}22222/htdocs/php/info.php" .format(SSSVariables.sss_webroot), encoding='utf-8', mode='w') as myfile: myfile.write("<?php\nphpinfo();\n?>") SSSFileUtils.chown(self, "{0}22222" .format(SSSVariables.sss_webroot), SSSVariables.sss_php_user, SSSVariables.sss_php_user, recursive=True) SSSGit.add(self, ["/etc/php/"], msg="Adding PHP into Git") SSSService.restart_service(self, 'php7.0-fpm') if set(SSSVariables.sss_mysql).issubset(set(apt_packages)): if not os.path.isfile("/etc/mysql/my.cnf"): config = ("[mysqld]\nwait_timeout = 30\n" "interactive_timeout=60\nperformance_schema = 0" "\nquery_cache_type = 1") config_file = open("/etc/mysql/my.cnf", encoding='utf-8', mode='w') config_file.write(config) config_file.close() else: try: SSSShellExec.cmd_exec(self, "sed -i \"/#max_conn" "ections/a wait_timeout = 30 \\n" "interactive_timeout = 60 \\n" "performance_schema = 0\\n" "query_cache_type = 1 \" " "/etc/mysql/my.cnf") except CommandExecutionError as e: Log.error(self, "Unable to update MySQL file") # Set MySQL Tuning Primer permission SSSFileUtils.chmod(self, "/usr/bin/tuning-primer", 0o775) SSSGit.add(self, ["/etc/mysql"], msg="Adding MySQL into Git") SSSService.reload_service(self, 'mysql') if len(packages): if any('/tmp/pma.tar.gz' == x[1] for x in packages): SSSExtract.extract(self, '/tmp/pma.tar.gz', '/tmp/') Log.debug(self, 'Extracting file /tmp/pma.tar.gz to ' 'location /tmp/') if not os.path.exists('{0}22222/htdocs/db' .format(SSSVariables.sss_webroot)): Log.debug(self, "Creating new directory " "{0}22222/htdocs/db" .format(SSSVariables.sss_webroot)) os.makedirs('{0}22222/htdocs/db' .format(SSSVariables.sss_webroot)) shutil.move('/tmp/phpmyadmin-STABLE/', '{0}22222/htdocs/db/pma/' .format(SSSVariables.sss_webroot)) shutil.copyfile('{0}22222/htdocs/db/pma/config.sample.inc.php' .format(SSSVariables.sss_webroot), '{0}22222/htdocs/db/pma/config.inc.php' .format(SSSVariables.sss_webroot)) Log.debug(self, 'Setting Blowfish Secret Key FOR COOKIE AUTH to ' '{0}22222/htdocs/db/pma/config.inc.php file ' .format(SSSVariables.sss_webroot)) blowfish_key = ''.join([random.choice (string.ascii_letters + string.digits) for n in range(10)]) SSSFileUtils.searchreplace(self, '{0}22222/htdocs/db/pma/config.inc.php' .format(SSSVariables.sss_webroot), "$cfg[\'blowfish_secret\'] = \'\';","$cfg[\'blowfish_secret\'] = \'{0}\';" .format(blowfish_key)) Log.debug(self, 'Setting HOST Server For Mysql to ' '{0}22222/htdocs/db/pma/config.inc.php file ' .format(SSSVariables.sss_webroot)) SSSFileUtils.searchreplace(self, '{0}22222/htdocs/db/pma/config.inc.php' .format(SSSVariables.sss_webroot), "$cfg[\'Servers\'][$i][\'host\'] = \'localhost\';","$cfg[\'Servers\'][$i][\'host\'] = \'{0}\';" .format(SSSVariables.sss_mysql_host)) Log.debug(self, 'Setting Privileges of webroot permission to ' '{0}22222/htdocs/db/pma file ' .format(SSSVariables.sss_webroot)) SSSFileUtils.chown(self, '{0}22222' .format(SSSVariables.sss_webroot), SSSVariables.sss_php_user, SSSVariables.sss_php_user, recursive=True)
def post_pref(self, apt_packages, packages): """Post activity after installation of packages""" if len(apt_packages): if set(SSSVariables.sss_apache).issubset(set(apt_packages)): if not (os.path.isfile('/etc/apache2/conf-available/acl.conf') ): data = dict(webroot=SSSVariables.sss_webroot) Log.debug( self, 'Writting the Apache configuration to ' 'file /etc/apache2/conf-available/acl.conf') sss_apache = open('/etc/apache2/conf-available/acl.conf', encoding='utf-8', mode='w') self.app.render((data), 'acl.mustache', out=sss_apache) sss_apache.close() # 22222 port setting Log.debug( self, 'Writting the Apache configuration to ' 'file /etc/apache2/sites-available/' '22222') sss_apache = open( '/etc/apache2/sites-available/22222.conf', encoding='utf-8', mode='w') self.app.render((data), '22222.mustache', out=sss_apache) sss_apache.close() passwd = ''.join([ random.choice(string.ascii_letters + string.digits + string.punctuation) for n in range(10) ]) try: SSSShellExec.cmd_exec( self, "printf \"SSS:" "$(openssl passwd -crypt " "{password} 2> /dev/null)\n\"" "> /etc/apache2/htpasswd-sss " "2>/dev/null".format(password=passwd)) except CommandExecutionError as e: Log.error(self, "Failed to save HTTP Auth") # Create Symbolic link for 22222 SSSFileUtils.create_symlink(self, [ '/etc/apache2/' 'sites-available/' '22222.conf', '/etc/apache2/' 'sites-enabled/' '22222.conf' ]) # Create htdocs folder if not os.path.exists('{0}22222/htdocs'.format( SSSVariables.sss_webroot)): Log.debug( self, "Creating directory " "{0}22222/htdocs ".format( SSSVariables.sss_webroot)) os.makedirs('{0}22222/htdocs'.format( SSSVariables.sss_webroot)) if not os.path.exists('/etc/apache2/ssl'): Log.debug(self, "Creating directory " "/etc/apache2/ssl/") os.makedirs('/etc/apache2/ssl') try: SSSShellExec.cmd_exec( self, "openssl genrsa -out " "/etc/apache2/ssl/22222.key 2048") SSSShellExec.cmd_exec( self, "openssl req -new -batch " "-subj /commonName=127.0.0.1/ " "-key /etc/apache2/ssl/22222.key " "-out /etc/apache2/ssl/" "22222.csr") SSSFileUtils.mvfile( self, "/etc/apache2/ssl/22222.key", "/etc/apache2/ssl/" "22222.key.org") SSSShellExec.cmd_exec( self, "openssl rsa -in " "/etc/apache2/ssl/" "22222.key.org -out " "/etc/apache2/ssl/22222.key") SSSShellExec.cmd_exec( self, "openssl x509 -req -days " "3652 -in /etc/apache2/ssl/" "22222.csr -signkey " "/etc/apache2/ssl/22222.key -out " "/etc/apache2/ssl/22222.crt") except CommandExecutionError as e: Log.error(self, "Failed to generate SSL for 22222") # Apache Configation into GIT SSSGit.add(self, ["/etc/apache2"], msg="Adding Apache into Git") SSSService.restart_service(self, 'apache2') self.msg = (self.msg + ["HTTP Auth User Name: SSS"] + ["HTTP Auth Password : {0}".format(passwd)]) #phpmyadmin config if set(SSSVariables.sss_pma).issubset(set(apt_packages)): php_conf = ("Include /etc/phpmyadmin/apache.conf") with open('/etc/apache2/apache2.conf', 'a') as php_conf_file: php_conf_file.write(php_conf) """SSSFileUtils.create_symlink(self, ['/etc/phpmyadmin/apache.conf','/etc/apache2/apache2.conf'])""" """sss_php = open('/etc/apache2/apache2.conf',encoding='utf-8', mode='a') self.app.render((data), 'Include /etc/phpmyadmin/apache.conf', out=sss_php) sss_php.close() """ if set(SSSVariables.sss_php).issubset(set(apt_packages)): # Create log directories if not os.path.exists('/var/log/php/7.0/'): Log.debug(self, 'Creating directory /var/log/php/7.0/') os.makedirs('/var/log/php/7.0/') # TOD : xdebug # Parse etc/php5/fpm/php.ini config = configparser.ConfigParser() Log.debug(self, "configuring php file /etc/php/7.0/fpm/php.ini") config.read('/etc/php/7.0/fpm/php.ini') config['PHP']['expose_php'] = 'Off' config['PHP']['post_max_size'] = '100M' config['PHP']['upload_max_filesize'] = '100M' config['PHP']['max_execution_time'] = '300' config['PHP']['date.timezone'] = SSSVariables.sss_timezone with open('/etc/php/7.0/fpm/php.ini', encoding='utf-8', mode='w') as configfile: Log.debug( self, "Writting php configuration into " "/etc/php/7.0/fpm/php.ini") config.write(configfile) # Prase /etc/php/7.0/fpm/php-fpm.conf config = configparser.ConfigParser() Log.debug( self, "configuring php file" "/etc/php/7.0/fpm/php-fpm.conf") config.read_file( codecs.open("/etc/php/7.0/fpm/php-fpm.conf", "r", "utf8")) config['global']['error_log'] = '/var/log/php/7.0/fpm.log' config.remove_option('global', 'include') config['global']['log_level'] = 'notice' config['global']['include'] = '/etc/php/7.0/fpm/pool.d/*.conf' with codecs.open('/etc/php/7.0/fpm/php-fpm.conf', encoding='utf-8', mode='w') as configfile: Log.debug( self, "writting php7 configuration into " "/etc/php/7.0/fpm/php-fpm.conf") config.write(configfile) # Parse /etc/php/7.0/fpm/pool.d/www.conf config = configparser.ConfigParser() config.read_file( codecs.open('/etc/php/7.0/fpm/pool.d/www.conf', "r", "utf8")) config['www']['ping.path'] = '/ping' config['www']['pm.status_path'] = '/status' config['www']['pm.max_requests'] = '500' config['www']['pm.max_children'] = '100' config['www']['pm.start_servers'] = '20' config['www']['pm.min_spare_servers'] = '10' config['www']['pm.max_spare_servers'] = '30' config['www']['request_terminate_timeout'] = '300' config['www']['pm'] = 'ondemand' config['www']['listen'] = '127.0.0.1:9000' with codecs.open('/etc/php/7.0/fpm/pool.d/www.conf', encoding='utf-8', mode='w') as configfile: Log.debug( self, "writting PHP5 configuration into " "/etc/php/7.0/fpm/pool.d/www.conf") config.write(configfile) #TODO : Debug Config #TODO : Disable xdebug # PHP and Debug pull configuration if not os.path.exists('{0}22222/htdocs/fpm/status/'.format( SSSVariables.sss_webroot)): Log.debug( self, 'Creating directory ' '{0}22222/htdocs/fpm/status/ '.format( SSSVariables.sss_webroot)) os.makedirs('{0}22222/htdocs/fpm/status/'.format( SSSVariables.sss_webroot)) open('{0}22222/htdocs/fpm/status/debug'.format( SSSVariables.sss_webroot), encoding='utf-8', mode='a').close() open('{0}22222/htdocs/fpm/status/php'.format( SSSVariables.sss_webroot), encoding='utf-8', mode='a').close() # Write info.php if not os.path.exists('{0}22222/htdocs/php/'.format( SSSVariables.sss_webroot)): Log.debug( self, 'Creating directory ' '{0}22222/htdocs/php/ '.format( SSSVariables.sss_webroot)) os.makedirs('{0}22222/htdocs/php'.format( SSSVariables.sss_webroot)) with open("{0}22222/htdocs/php/info.php".format( SSSVariables.sss_webroot), encoding='utf-8', mode='w') as myfile: myfile.write("<?php\nphpinfo();\n?>") SSSFileUtils.chown(self, "{0}22222".format(SSSVariables.sss_webroot), SSSVariables.sss_php_user, SSSVariables.sss_php_user, recursive=True) SSSGit.add(self, ["/etc/php/"], msg="Adding PHP into Git") SSSService.restart_service(self, 'php7.0-fpm') if set(SSSVariables.sss_mysql).issubset(set(apt_packages)): if not os.path.isfile("/etc/mysql/my.cnf"): config = ("[mysqld]\nwait_timeout = 30\n" "interactive_timeout=60\nperformance_schema = 0" "\nquery_cache_type = 1") config_file = open("/etc/mysql/my.cnf", encoding='utf-8', mode='w') config_file.write(config) config_file.close() else: try: SSSShellExec.cmd_exec( self, "sed -i \"/#max_conn" "ections/a wait_timeout = 30 \\n" "interactive_timeout = 60 \\n" "performance_schema = 0\\n" "query_cache_type = 1 \" " "/etc/mysql/my.cnf") except CommandExecutionError as e: Log.error(self, "Unable to update MySQL file") # Set MySQL Tuning Primer permission SSSFileUtils.chmod(self, "/usr/bin/tuning-primer", 0o775) SSSGit.add(self, ["/etc/mysql"], msg="Adding MySQL into Git") SSSService.reload_service(self, 'mysql')
def default(self): # All package update apt_packages = [] packages = [] if ((not self.app.pargs.web) and (not self.app.pargs.apache2) and (not self.app.pargs.php) and (not self.app.pargs.mysql) and (not self.app.pargs.all)): self.app.pargs.web = True if self.app.pargs.all: self.app.pargs.web = True if self.app.pargs.web: self.app.pargs.apache2 = True self.app.pargs.php = True self.app.pargs.mysql = True if self.app.pargs.apache2: if SSSAptGet.is_installed(self, 'apache2'): apt_packages = apt_packages + SSSVariables.sss_apache else: Log.info(self, "Apache is not already installed") if self.app.pargs.php: if SSSAptGet.is_installed(self, 'php7.0-fpm'): apt_packages = apt_packages + SSSVariables.sss_php else: Log.info(self, "PHP is not installed") if self.app.pargs.mysql: if SSSAptGet.is_installed(self, 'mariadb-server'): apt_packages = apt_packages + SSSVariables.sss_mysql else: Log.info(self, "MariaDB is not installed") if len(packages) or len(apt_packages): Log.info(self, "During package update process non Apache" " parts of your site may remain down") # Check prompt if (not self.app.pargs.no_prompt): start_upgrade = input("Do you want to continue:[y/N]") if start_upgrade != "Y" and start_upgrade != "y": Log.error(self, "Not starting package update") Log.info(self, "Updating packages, please wait...") if len(apt_packages): # apt-get update SSSAptGet.update(self) # Update packages SSSAptGet.install(self, apt_packages) # Post Actions after package updates if set(SSSVariables.sss_apache).issubset(set(apt_packages)): SSSService.restart_service(self, 'apache2') if set(SSSVariables.sss_php).issubset(set(apt_packages)): SSSService.restart_service(self, 'php7.0-fpm') if set(SSSVariables.sss_mysql).issubset(set(apt_packages)): SSSService.restart_service(self, 'mysql') if len(packages): pass Log.info(self, "Successfully updated packages")
def migrate_mariadb(self): # Backup all database SSSMysql.backupAll(self) # Add MariaDB repo Log.info(self, "Adding repository for MariaDB, please wait...") mysql_pref = ("Package: *\nPin: origin sfo1.mirrors.digitalocean.com" "\nPin-Priority: 1000\n") with open('/etc/apt/preferences.d/' 'MariaDB.pref', 'w') as mysql_pref_file: mysql_pref_file.write(mysql_pref) SSSRepo.add(self, repo_url=SSSVariables.sss_mysql_repo) Log.debug(self, 'Adding key for {0}'.format(SSSVariables.sss_mysql_repo)) SSSRepo.add_key(self, '0xcbcb082a1bb943db', keyserver="keyserver.ubuntu.com") config = configparser.ConfigParser() if os.path.exists('/etc/mysql/conf.d/my.cnf'): config.read('/etc/mysql/conf.d/my.cnf') else: config.read(os.path.expanduser("~") + '/.my.cnf') try: chars = config['client']['password'] except Exception as e: Log.error(self, "Error: process exited with error %s" % e) Log.debug(self, "Pre-seeding MariaDB") Log.debug( self, "echo \"mariadb-server-10.0 " "mysql-server/root_password " "password \" | " "debconf-set-selections") SSSShellExec.cmd_exec(self, "echo \"mariadb-server-10.0 " "mysql-server/root_password " "password {chars}\" | " "debconf-set-selections".format(chars=chars), log=False) Log.debug( self, "echo \"mariadb-server-10.0 " "mysql-server/root_password_again " "password \" | " "debconf-set-selections") SSSShellExec.cmd_exec(self, "echo \"mariadb-server-10.0 " "mysql-server/root_password_again " "password {chars}\" | " "debconf-set-selections".format(chars=chars), log=False) # Install MariaDB apt_packages = SSSVariables.sss_mysql # If PHP is installed then install php5-mysql if SSSAptGet.is_installed(self, "php5-fpm"): apt_packages = apt_packages + ["php5-mysql"] # If mail server is installed then install dovecot-sql and postfix-sql if SSSAptGet.is_installed(self, "dovecot-core"): apt_packages = apt_packages + [ "dovecot-mysql", "postfix-mysql", "libclass-dbi-mysql-perl" ] Log.info(self, "Updating apt-cache, please wait...") SSSAptGet.update(self) Log.info(self, "Installing MariaDB, please wait...") SSSAptGet.remove(self, ["mysql-common", "libmysqlclient18"]) SSSAptGet.auto_remove(self) SSSAptGet.install(self, apt_packages) # Restart dovecot and postfix if installed if SSSAptGet.is_installed(self, "dovecot-core"): SSSService.restart_service(self, 'dovecot') SSSService.restart_service(self, 'postfix')