def _setup_database(sql_password):
'''
Configure database for rsyslog
'''
mysqlUtils.drop_user('rsyslogd')
mysqlUtils.create_user('rsyslogd', sql_password, 'Syslog', 'INSERT')
mysql_exec("\. {0}".format(get_create_db_path()), True, escape=False)
def _setup_database(sql_password):
'''
Configure database for rsyslog
'''
mysqlUtils.drop_user('rsyslogd')
mysqlUtils.create_user('rsyslogd', sql_password, 'Syslog', 'INSERT')
mysql_exec("\. {0}".format(get_create_db_path()), True, escape=False)
def create_user(username, password, database, privileges = "ALL PRIVILEGES"):
'''
Create a user and give it "resular" privileges.
'''
mysql_exec("GRANT {0} ON {1}.* TO".format(privileges, database) +
"'{0}'@'127.0.0.1' IDENTIFIED BY '{1}', ".format(username, password) +
"'{0}'@'localhost' IDENTIFIED BY '{1}' ".format(username, password),
True
)
def create_user(username, password, database, privileges="ALL PRIVILEGES"):
'''
Create a user and give it "resular" privileges.
'''
mysql_exec(
"GRANT {0} ON {1}.* TO".format(privileges, database) +
"'{0}'@'127.0.0.1' IDENTIFIED BY '{1}', ".format(username, password) +
"'{0}'@'localhost' IDENTIFIED BY '{1}' ".format(username, password),
True)
def drop_user(username):
'''
Drop a user and its privileges.
'''
mysql_exec('DELETE FROM mysql.user where user="******";'.format(username), True)
mysql_exec('DELETE FROM mysql.db where db="{0}";'.format(username), True)
mysql_exec('flush privileges', True)
def drop_user(username):
'''
Drop a user and its privileges.
'''
mysql_exec('DELETE FROM mysql.user where user="******";'.format(username),
True)
mysql_exec('DELETE FROM mysql.db where db="{0}";'.format(username), True)
mysql_exec('flush privileges', True)
def mysql_result(query):
# Send query to mysql and get back a result.
result = mysql_exec(query, True).strip()
# Create row based result in a list.
result = result.split("\n")
# Remove column names
result.pop(0)
# Parse out the columns.
result_list = []
for row in result:
result_list.append(row.split("\t"))
return result_list
def mysql_result(query):
# Send query to mysql and get back a result.
result = mysql_exec(query, True).strip()
# Create row based result in a list.
result = result.split("\n")
# Remove column names
result.pop(0)
# Parse out the columns.
result_list = []
for row in result:
result_list.append(row.split("\t"))
return result_list
