Esempi in Python per fixConfFile

Esempio n. 1

File: ensure_log_error_verbosity_is_not_set_to_1.py Progetto: hungvuong97/firewall

def fix(username, password):
    connection = helper.connectToMysql(username, password)
    cursor = connection.cursor()
    if cursor:
        cursor.execute('SHOW GLOBAL VARIABLES LIKE \'log_error_verbosity\';')
        dir = cursor.fetchone()
        if dir and dir[1] != 2 and dir[1] != 3:
            mysqlDefConf = '/etc/mysql/mysql.conf.d/mysqld.cnf'
            helper.fixConfFile(mysqlDefConf, 'log-error_verbosity', '2')

Esempio n. 2

def fix(username, password):
    connection = helper.connectToMysql(username, password)
    cursor = connection.cursor()
    if cursor:
        cursor.execute(
            'SHOW VARIABLES WHERE Variable_name = \'master_info_repository\';')
        dir = cursor.fetchone()
        if dir and dir[1] == 'FILE':
            mysqlDefConf = '/etc/mysql/mysql.conf.d/mysqld.cnf'
            helper.fixConfFile(mysqlDefConf, 'master_info_repository', 'TABLE')

Esempio n. 3

def fix(username, password):
    connection = helper.connectToMysql(username, password)
    cursor = connection.cursor()
    if cursor:
        cursor.execute(
            'SHOW VARIABLES WHERE Variable_name = \'local_infile\';')
        dir = cursor.fetchone()
        if dir and dir[1] == 'ON':
            mysqlDefConf = '/etc/mysql/mysql.conf.d/mysqld.cnf'
            helper.fixConfFile(mysqlDefConf, 'local-infile', '0')

Esempio n. 4

File: ensure_log_error_is_not_empty.py Progetto: hungvuong97/firewall

def fix(username, password):
    connection = helper.connectToMysql(username, password)
    cursor = connection.cursor()
    if cursor:
        cursor.execute('SHOW variables LIKE \'log_error\';')
        dir = cursor.fetchone()
        if not dir[1]:
            mysqlDefConf = '/etc/mysql/mysql.conf.d/mysqld.cnf'
            helper.fixConfFile(mysqlDefConf, 'log-error',
                               '/var/log/mysql/error.log')

Esempio n. 5

File: ensure_default_password_lifetime_is_less_than_or_equal_to_90.py Progetto: hungvuong97/firewall

def fix(username, password):
    connection = helper.connectToMysql(username, password)
    cursor = connection.cursor()
    if cursor:
        cursor.execute('SHOW VARIABLES LIKE \'default_password_lifetime\';')
        dir = cursor.fetchone()  # cursor only contains 1 record
        if dir and dir[1] < 90:  # cursor only contains 1 record
            cursor.execute('SET GLOBAL default_password_lifetime=90')
            mysqlDefConf = '/etc/mysql/mysql.conf.d/mysqld.cnf'
            helper.fixConfFile(mysqlDefConf, 'default_password_lifetime', '90')

Esempio n. 6

File: ensure_skip_symbolic_links_is_enabled.py Progetto: hungvuong97/firewall

def fix(username, password):
    connection = helper.connectToMysql(username, password)
    cursor = connection.cursor()
    flag = True
    if cursor:
        cursor.execute('SHOW variables LIKE \'have_symlink\';')
        dir = cursor.fetchone()
        if dir and dir[1] != 'DISABLED':
            mysqlDefConf = '/etc/mysql/mysql.conf.d/mysqld.cnf'
            helper.fixConfFile(mysqlDefConf, 'skip_symbolic_links', 'YES')

Esempio n. 7

def fix(username, password):
    connection = helper.connectToMysql(username, password)
    cursor = connection.cursor()
    flag = True
    if cursor:
        cursor.execute(
            'SHOW GLOBAL VARIABLES WHERE Variable_name = \'secure_file_priv\' AND Value<>\'\';'
        )
        for dir in cursor:  # cursor only contains 1 record
            if not dir[1]:
                mysqlDefConf = '/etc/mysql/mysql.conf.d/mysqld.cnf'
                helper.fixConfFile(mysqlDefConf, 'secure_file_priv',
                                   '/var/lib/mysql-files/')

Esempio n. 8

def fix(username, password):
    connection = helper.connectToMysql(username, password)
    cursor = connection.cursor()
    flag = True
    if cursor:
        cursor.execute('SHOW VARIABLES LIKE \'sql_mode\';')
        dir = cursor.fetchone()
        if dir and dir[1]:
            match = re.search('STRICT_ALL_TABLES', dir[1])
            if not match:
                mysqlDefConf = '/etc/mysql/mysql.conf.d/mysqld.cnf'
                helper.fixConfFile(mysqlDefConf, 'sql_mode',
                                   dir[1] + ',STRICT_ALL_TABLES')

Esempio n. 9

File: ensure_mysqld_is_not_started_with_skip_grant_tables.py Progetto: hungvuong97/firewall

def fix(username, password):
    mysqlDefConf = '/etc/mysql/mysql.conf.d/mysqld.cnf'
    helper.fixConfFile(mysqlDefConf, 'skip-grant-tables', 'FALSE')

Esempio n. 10

def fix(username, password):
    mysqlDefConf = '/etc/mysql/mysql.conf.d/mysqld.cnf'
    helper.fixConfFile(mysqlDefConf, 'log-raw', 'OFF')