def add(self, host_name): isHost(host_name) login = self.__getLogin(host_name) password = host_name if self.base.options.password: password = self.base.options.password if password == 'random': password = random_password() database = self.__getDbName(host_name) try: self.cursor.execute( "CREATE DATABASE `%s` CHARACTER SET utf8 COLLATE utf8_general_ci;" % database) self.cursor.execute( "GRANT ALL ON %s.* TO '%s'@'%%' IDENTIFIED BY '%s';" % \ (database, login, password) ) self.cursor.execute( "GRANT ALL ON %s.* TO '%s'@'127.0.0.1' IDENTIFIED BY '%s';" % \ (database, login, password) ) self.cursor.execute( "GRANT ALL ON %s.* TO '%s'@'localhost' IDENTIFIED BY '%s';" %\ (database, login, password) ) self.cursor.execute('FLUSH PRIVILEGES;') except Exception, msg: error_message(msg)
def add(self, host_name): isHost(host_name) login = self.__getLogin(host_name) password = host_name if self.base.options.password: password = self.base.options.password if password == 'random': password = random_password() database = self.__getDbName(host_name) try: self.cursor.execute("CREATE DATABASE `%s` CHARACTER SET utf8 COLLATE utf8_general_ci;" % database) self.cursor.execute( "GRANT ALL ON %s.* TO '%s'@'%%' IDENTIFIED BY '%s';" % \ (database, login, password) ) self.cursor.execute( "GRANT ALL ON %s.* TO '%s'@'127.0.0.1' IDENTIFIED BY '%s';" % \ (database, login, password) ) self.cursor.execute( "GRANT ALL ON %s.* TO '%s'@'localhost' IDENTIFIED BY '%s';" %\ (database, login, password) ) self.cursor.execute('FLUSH PRIVILEGES;') except Exception, msg: error_message(msg)
def add(self, host_name): isHost(host_name) login = host_name password = host_name folder = self.__getFolder(host_name) if self.base.options.user: login = self.base.options.user if self.base.options.password: password = self.base.options.password if password == 'random': password = random_password() if fileExists(folder): if not self.__userExists(login): self.cursor.execute( "INSERT INTO `accounts` (`username`, `pass`) \ VALUES('%s', PASSWORD('%s'))" % (login, password) ) self.__addUserConfig(login, folder) info_message( "User '%s' successfully added! Password: %s" % (login, password) ) service_restart(self.config['init']) else: error_message("Login already used!") else: error_message("Project folder not found!")
def add(self, host_name): isHost(host_name) login = host_name password = host_name folder = self.__getFolder(host_name) if self.base.options.user: login = self.base.options.user if self.base.options.password: password = self.base.options.password if password == 'random': password = random_password() if fileExists(folder): if not self.__userExists(login): self.cursor.execute( "INSERT INTO `accounts` (`username`, `pass`) \ VALUES('%s', PASSWORD('%s'))" % (login, password)) self.__addUserConfig(login, folder) info_message("User '%s' successfully added! Password: %s" % (login, password)) service_restart(self.config['init']) else: error_message("Login already used!") else: error_message("Project folder not found!")