def setUp(self):
'''
Test presence of MySQL server, enforce a root password
'''
super(MysqlGrantsStateTest, self).setUp()
NO_MYSQL_SERVER = True
# now ensure we know the mysql root password
# one of theses two at least should work
ret1 = self.run_state('cmd.run',
name='mysqladmin --host="localhost" -u ' +
self.user + ' flush-privileges password "' +
self.password + '"')
ret2 = self.run_state('cmd.run',
name='mysqladmin --host="localhost" -u ' +
self.user + ' --password="******" flush-privileges password "' + self.password +
'"')
key, value = ret2.popitem()
if value['result']:
NO_MYSQL_SERVER = False
else:
self.skipTest('No MySQL Server running, or no root access on it.')
# Create some users and a test db
for user, userdef in six.iteritems(self.users):
self._userCreation(uname=userdef['name'], password=userdef['pwd'])
self.run_state(
'mysql_database.present',
name=self.testdb1,
character_set='utf8',
collate='utf8_general_ci',
connection_user=self.user,
connection_pass=self.password,
)
self.run_state(
'mysql_database.present',
name=self.testdb2,
character_set='utf8',
collate='utf8_general_ci',
connection_user=self.user,
connection_pass=self.password,
)
create_query = ('CREATE TABLE {tblname} ('
' id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,'
' data VARCHAR(100)) ENGINE={engine};'.format(
tblname=mysqlmod.quote_identifier(self.table1),
engine='MYISAM',
))
log.info('Adding table \'{0}\''.format(self.table1, ))
self.run_function('mysql.query',
database=self.testdb2,
query=create_query,
connection_user=self.user,
connection_pass=self.password)
create_query = ('CREATE TABLE {tblname} ('
' id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,'
' data VARCHAR(100)) ENGINE={engine};'.format(
tblname=mysqlmod.quote_identifier(self.table2),
engine='MYISAM',
))
log.info('Adding table \'{0}\''.format(self.table2, ))
self.run_function('mysql.query',
database=self.testdb2,
query=create_query,
connection_user=self.user,
connection_pass=self.password)
def setUp(self):
'''
Test presence of MySQL server, enforce a root password
'''
super(MysqlGrantsStateTest, self).setUp()
NO_MYSQL_SERVER = True
# now ensure we know the mysql root password
# one of theses two at least should work
ret1 = self.run_state(
'cmd.run',
name='mysqladmin --host="localhost" -u '
+ self.user
+ ' flush-privileges password "'
+ self.password
+ '"'
)
ret2 = self.run_state(
'cmd.run',
name='mysqladmin --host="localhost" -u '
+ self.user
+ ' --password="******" flush-privileges password "'
+ self.password
+ '"'
)
key, value = ret2.popitem()
if value['result']:
NO_MYSQL_SERVER = False
else:
self.skipTest('No MySQL Server running, or no root access on it.')
# Create some users and a test db
for user, userdef in six.iteritems(self.users):
self._userCreation(uname=userdef['name'], password=userdef['pwd'])
self.run_state(
'mysql_database.present',
name=self.testdb1,
character_set='utf8',
collate='utf8_general_ci',
connection_user=self.user,
connection_pass=self.password,
)
self.run_state(
'mysql_database.present',
name=self.testdb2,
character_set='utf8',
collate='utf8_general_ci',
connection_user=self.user,
connection_pass=self.password,
)
create_query = ('CREATE TABLE {tblname} ('
' id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,'
' data VARCHAR(100)) ENGINE={engine};'.format(
tblname=mysqlmod.quote_identifier(self.table1),
engine='MYISAM',
))
log.info('Adding table \'{0}\''.format(self.table1,))
self.run_function(
'mysql.query',
database=self.testdb2,
query=create_query,
connection_user=self.user,
connection_pass=self.password
)
create_query = ('CREATE TABLE {tblname} ('
' id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,'
' data VARCHAR(100)) ENGINE={engine};'.format(
tblname=mysqlmod.quote_identifier(self.table2),
engine='MYISAM',
))
log.info('Adding table \'{0}\''.format(self.table2,))
self.run_function(
'mysql.query',
database=self.testdb2,
query=create_query,
connection_user=self.user,
connection_pass=self.password
)
def setUp(self):
"""
Test presence of MySQL server, enforce a root password
"""
super(MysqlGrantsStateTest, self).setUp()
NO_MYSQL_SERVER = True
# now ensure we know the mysql root password
# one of theses two at least should work
ret1 = self.run_state(
"cmd.run",
name='mysqladmin --host="localhost" -u ' + self.user +
' flush-privileges password "' + self.password + '"',
)
ret2 = self.run_state(
"cmd.run",
name='mysqladmin --host="localhost" -u ' + self.user +
' --password="******" flush-privileges password "' +
self.password + '"',
)
key, value = ret2.popitem()
if value["result"]:
NO_MYSQL_SERVER = False
else:
self.skipTest("No MySQL Server running, or no root access on it.")
# Create some users and a test db
for user, userdef in six.iteritems(self.users):
self._userCreation(uname=userdef["name"], password=userdef["pwd"])
self.run_state(
"mysql_database.present",
name=self.testdb1,
character_set="utf8",
collate="utf8_general_ci",
connection_user=self.user,
connection_pass=self.password,
)
self.run_state(
"mysql_database.present",
name=self.testdb2,
character_set="utf8",
collate="utf8_general_ci",
connection_user=self.user,
connection_pass=self.password,
)
create_query = ("CREATE TABLE {tblname} ("
" id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,"
" data VARCHAR(100)) ENGINE={engine};".format(
tblname=mysqlmod.quote_identifier(self.table1),
engine="MYISAM",
))
log.info("Adding table '%s'", self.table1)
self.run_function(
"mysql.query",
database=self.testdb2,
query=create_query,
connection_user=self.user,
connection_pass=self.password,
)
create_query = ("CREATE TABLE {tblname} ("
" id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,"
" data VARCHAR(100)) ENGINE={engine};".format(
tblname=mysqlmod.quote_identifier(self.table2),
engine="MYISAM",
))
log.info("Adding table '%s'", self.table2)
self.run_function(
"mysql.query",
database=self.testdb2,
query=create_query,
connection_user=self.user,
connection_pass=self.password,
)
def setUp(self):
"""
Test presence of MySQL server, enforce a root password
"""
super(MysqlGrantsStateTest, self).setUp()
NO_MYSQL_SERVER = True
# now ensure we know the mysql root password
# one of theses two at least should work
ret1 = self.run_state(
"cmd.run",
name='mysqladmin --host="localhost" -u ' + self.user + ' flush-privileges password "' + self.password + '"',
)
ret2 = self.run_state(
"cmd.run",
name='mysqladmin --host="localhost" -u '
+ self.user
+ ' --password="******" flush-privileges password "'
+ self.password
+ '"',
)
key, value = ret2.popitem()
if value["result"]:
NO_MYSQL_SERVER = False
else:
self.skipTest("No MySQL Server running, or no root access on it.")
# Create some users and a test db
for user, userdef in self.users.iteritems():
self._userCreation(uname=userdef["name"], password=userdef["pwd"])
self.run_state(
"mysql_database.present",
name=self.testdb1,
character_set="utf8",
collate="utf8_general_ci",
connection_user=self.user,
connection_pass=self.password,
)
self.run_state(
"mysql_database.present",
name=self.testdb2,
character_set="utf8",
collate="utf8_general_ci",
connection_user=self.user,
connection_pass=self.password,
)
create_query = (
"CREATE TABLE %(tblname)s ("
" id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,"
" data VARCHAR(100)) ENGINE=%(engine)s;"
) % dict(tblname=mysqlmod.quote_identifier(self.table1), engine="MYISAM")
log.info("Adding table {0!r}".format(self.table1))
self.run_function(
"mysql.query",
database=self.testdb2,
query=create_query,
connection_user=self.user,
connection_pass=self.password,
)
create_query = (
"CREATE TABLE %(tblname)s ("
" id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,"
" data VARCHAR(100)) ENGINE=%(engine)s;"
) % dict(tblname=mysqlmod.quote_identifier(self.table2), engine="MYISAM")
log.info("Adding table {0!r}".format(self.table2))
self.run_function(
"mysql.query",
database=self.testdb2,
query=create_query,
connection_user=self.user,
connection_pass=self.password,
)
