def test_sslauth(self):
if not tests.SSL_AVAILABLE:
tests.MESSAGES['WARNINGS'].append(
"BugOra16217667 test failed. Python lacks SSL support.")
return
config = self.getMySQLConfig()
config['user'] = '******'
config['password'] = ''
config['unix_socket'] = None
config['ssl_verify_cert'] = True
config.update({
'ssl_ca': os.path.abspath(
os.path.join(tests.SSL_DIR, 'tests_CA_cert.pem')),
'ssl_cert': os.path.abspath(
os.path.join(tests.SSL_DIR, 'tests_client_cert.pem')),
'ssl_key': os.path.abspath(
os.path.join(tests.SSL_DIR, 'tests_client_key.pem')),
})
try:
cnx = connection.MySQLConnection(**config)
except errors.ProgrammingError:
self.fail("Failed authentication with SSL")
cnx.cmd_query("SHOW STATUS LIKE 'Ssl_cipher'")
self.assertTrue(cnx.get_rows()[0][0] != u'')
def test_sslauth(self):
if not tests.SSL_AVAILABLE:
tests.MESSAGES['WARNINGS'].append(
"BugOra16217667 test failed. Python lacks SSL support.")
return
config = self.getMySQLConfig()
config['user'] = '******'
config['password'] = ''
config['unix_socket'] = None
config['ssl_verify_cert'] = True
config.update({
'ssl_ca':
os.path.abspath(os.path.join(tests.SSL_DIR, 'tests_CA_cert.pem')),
'ssl_cert':
os.path.abspath(
os.path.join(tests.SSL_DIR, 'tests_client_cert.pem')),
'ssl_key':
os.path.abspath(os.path.join(tests.SSL_DIR,
'tests_client_key.pem')),
})
try:
cnx = connection.MySQLConnection(**config)
except errors.ProgrammingError:
self.fail("Failed authentication with SSL")
cnx.cmd_query("SHOW STATUS LIKE 'Ssl_cipher'")
self.assertTrue(cnx.get_rows()[0][0] != u'')
def test_ssl(self):
if not tests.SSL_AVAILABLE:
tests.MESSAGES['WARNINGS'].append(
"BugOra16217667 test failed. Python lacks SSL support.")
return
ssl_ca = os.path.abspath(
os.path.join(tests.SSL_DIR, 'tests_CA_cert.pem'))
ssl_cert = os.path.abspath(
os.path.join(tests.SSL_DIR, 'tests_client_cert.pem'))
ssl_key = os.path.abspath(
os.path.join(tests.SSL_DIR, 'tests_client_key.pem'))
config = self.getMySQLConfig()
config['user'] = '******'
config['password'] = ''
config['unix_socket'] = None
config.update({
'ssl_ca': None,
'ssl_cert': None,
'ssl_key': None,
})
# User requires SSL, but no values for ssl argument given
self.assertRaises(errors.ProgrammingError,
connection.MySQLConnection, **config)
# Use wrong value for ssl_ca
config['ssl_ca'] = os.path.abspath(
os.path.join(tests.SSL_DIR, 'tests_ca_cert.pem'))
config['ssl_cert'] = ssl_cert
config['ssl_key'] = ssl_key
config['ssl_verify_cert'] = True
self.assertRaises(errors.InterfaceError,
connection.MySQLConnection, **config)
# Use correct value
config['ssl_ca'] = ssl_ca
try:
cnx = connection.MySQLConnection(**config)
except errors.ProgrammingError:
self.fail("Failed authentication with SSL")
cnx.cmd_query("SHOW STATUS LIKE 'Ssl_cipher'")
self.assertTrue(cnx.get_rows()[0][0] != u'')
def test_ssl(self):
if not tests.SSL_AVAILABLE:
tests.MESSAGES['WARNINGS'].append(
"BugOra16217667 test failed. Python lacks SSL support.")
return
ssl_ca = os.path.abspath(
os.path.join(tests.SSL_DIR, 'tests_CA_cert.pem'))
ssl_cert = os.path.abspath(
os.path.join(tests.SSL_DIR, 'tests_client_cert.pem'))
ssl_key = os.path.abspath(
os.path.join(tests.SSL_DIR, 'tests_client_key.pem'))
config = self.getMySQLConfig()
config['user'] = '******'
config['password'] = ''
config['unix_socket'] = None
config.update({
'ssl_ca': None,
'ssl_cert': None,
'ssl_key': None,
})
# User requires SSL, but no values for ssl argument given
self.assertRaises(errors.ProgrammingError, connection.MySQLConnection,
**config)
# Use wrong value for ssl_ca
config['ssl_ca'] = os.path.abspath(
os.path.join(tests.SSL_DIR, 'tests_ca_cert.pem'))
config['ssl_cert'] = ssl_cert
config['ssl_key'] = ssl_key
config['ssl_verify_cert'] = True
self.assertRaises(errors.InterfaceError, connection.MySQLConnection,
**config)
# Use correct value
config['ssl_ca'] = ssl_ca
try:
cnx = connection.MySQLConnection(**config)
except errors.ProgrammingError:
self.fail("Failed authentication with SSL")
cnx.cmd_query("SHOW STATUS LIKE 'Ssl_cipher'")
self.assertTrue(cnx.get_rows()[0][0] != u'')
def test_sslauth(self):
config = self.getMySQLConfig()
config['user'] = '******'
config['password'] = ''
config['unix_socket'] = None
config['ssl_verify_cert'] = True
config.update({
'ssl_ca': os.path.abspath(
os.path.join(tests.SSL_DIR, 'tests_CA_cert.pem')),
'ssl_cert': os.path.abspath(
os.path.join(tests.SSL_DIR, 'tests_client_cert.pem')),
'ssl_key': os.path.abspath(
os.path.join(tests.SSL_DIR, 'tests_client_key.pem')),
})
try:
cnx = connection.MySQLConnection(**config)
except errors.ProgrammingError:
self.fail("Failed authentication with SSL")
cnx.cmd_query("SHOW STATUS LIKE 'Ssl_cipher'")
self.assertTrue(cnx.get_rows()[0][0] != '')
def test_sslauth(self):
config = self.getMySQLConfig()
config['user'] = '******'
config['password'] = ''
config['unix_socket'] = None
config['ssl_verify_cert'] = True
config.update({
'ssl_ca':
os.path.abspath(os.path.join(tests.SSL_DIR, 'tests_CA_cert.pem')),
'ssl_cert':
os.path.abspath(
os.path.join(tests.SSL_DIR, 'tests_client_cert.pem')),
'ssl_key':
os.path.abspath(os.path.join(tests.SSL_DIR,
'tests_client_key.pem')),
})
try:
cnx = connection.MySQLConnection(**config)
except errors.ProgrammingError:
self.fail("Failed authentication with SSL")
cnx.cmd_query("SHOW STATUS LIKE 'Ssl_cipher'")
self.assertTrue(cnx.get_rows()[0][0] != '')
