testsuite.x.devapi

Class SecureSessionTest

java.lang.Object

testsuite.x.internal.InternalXBaseTestCase

testsuite.x.devapi.DevApiBaseTestCase

testsuite.x.devapi.SecureSessionTest

public class SecureSessionTest
extends DevApiBaseTestCase

Field Summary

Fields

Modifier and Type	Field and Description
(package private) java.lang.String	clientKeyStorePassword
(package private) java.lang.String	clientKeyStorePath
(package private) java.lang.String	clientKeyStoreUrl
(package private) java.lang.String	sslFreeBaseUrl
(package private) java.util.Properties	sslFreeTestProperties
(package private) java.lang.String	trustStorePassword
(package private) java.lang.String	trustStorePath
(package private) java.lang.String	trustStoreUrl

Fields inherited from class testsuite.x.devapi.DevApiBaseTestCase

dbCharset, dbCollation, schema, session

Fields inherited from class testsuite.x.internal.InternalXBaseTestCase

baseUrl, DEFAULT_METADATA_CHARSET, fact, isSetForXTests, testHostInfo, testProperties

Constructor Summary

Constructors

Constructor and Description
SecureSessionTest()

Method Summary

Modifier and Type	Method and Description
private boolean	allowsRsa(Session sess)
private void	assertTlsVersion(Session sess, java.lang.String expectedTlsVersion)
private void	assertUser(java.lang.String user, Session sess)
private java.lang.String	getHighestCommonTlsVersion(Session sess)
void	setupSecureSessionTest()
void	teardownSecureSessionTest()
void	testAuthMechanisms() Tests that PLAIN, MYSQL41, SHA256_MEMORY, and EXTERNAL authentication mechanisms.
void	testBug23597281() Tests fix for Bug#23597281, GETNODESESSION() CALL WITH SSL PARAMETERS RETURNS CJCOMMUNICATIONSEXCEPTION
void	testBug25494338() Tests fix for Bug#25494338, ENABLEDSSLCIPHERSUITES PARAMETER NOT WORKING AS EXPECTED WITH X-PLUGIN.
void	testBug26227653() Tests fix for Bug#26227653, WL#10528 DIFF BEHAVIOUR WHEN SYSTEM PROP JAVAX.NET.SSL.TRUSTSTORETYPE IS SET The actual bug is: if wrong system-wide SSL settings are provided, the session should not fail if 'xdevapi.ssl-mode=REQUIRED'.
void	testBug27629553() Tests fix for Bug#27629553, NPE FROM GETSESSION() FOR SSL CONNECTION WHEN NO PASSWORD PASSED.
void	testFallbackToSystemKeyStore() Tests connection property 'xdevapi.fallback-to-system-keystore' behavior.
void	testFallbackToSystemTrustStore() Tests connection property 'xdevapi.fallback-to-system-truststore' behavior.
void	testNonSecureSession() Tests non-secure Sessions created via URL and properties map.
void	testSecureSessionDefaultAndRequired() Tests secure Sessions created via URL and properties map.
void	testSecureSessionDefaultAndRequiredWithSystemPropsPresent() Tests secure Sessions created via URL and properties map, with the SSL system properties also defined.
void	testSecureSessionMissingTrustStore() Tests exception thrown on missing truststore for a secure Session.
void	testSecureSessionVerifyServerCertificate() Tests secure Sessions created via URL and properties map, verifying server certificate.
void	testSecureSessionVerifyServerCertificateIdentity() Tests secure Sessions created via URL and properties map, verifying server certificate.
void	testSecureSessionVerifyServerCertificateIdentityFailure() Tests exception thrown on verifying server certificate identity failure.
void	testSecureSessionVerifyServerCertificateUsingSystemProps() Tests secure Sessions created via URL and properties map combined with SSL system properties, verifying server certificate.
void	testTLSv1_2() Tests TLSv1.2
void	testTLSVersionRemoval() Tests WL#14805, Remove support for TLS 1.0 and 1.1.
void	testTSLConflictingOptions() Tests WL#14835, Align TLS option checking across connectors
void	testXdevapiSslConnectionOptions() Tests that given SSL/TLS related session properties values are processed as expected.
void	testXdevapiTlsVersionsAndCiphersuites()

Methods inherited from class testsuite.x.devapi.DevApiBaseTestCase

assertNonSecureSession, assertPreparedStatementsCount, assertPreparedStatementsCountsAndId, assertPreparedStatementsStatusCounts, assertSecureSession, assertSecureSession, buildString, count_data, destroyTestSession, dropCollection, getPreparedStatementExecutionsCount, getPreparedStatementId, getPreparedStatementsCount, getPreparedStatementsCount, getPreparedStatementsCount, getPrepDeallocateCount, getPrepExecuteCount, getPrepPrepareCount, getThreadId, isMysqlRunningLocally, isServerRunningOnWindows, makeParam, makeParam, makeParam, setupTestSession, sqlUpdate, supportsTestCertificates, supportsTLSv1_2

Methods inherited from class testsuite.x.internal.InternalXBaseTestCase

assertSessionStatusEquals, assertSessionStatusNotEquals, assertThrows, assertThrows, assertThrows, assertThrows, createAuthenticatedTestProtocol, createTempTestCollection, createTestProtocol, createTestSchema, createTestSession, dropTempTestCollection, getEncodedTestHost, getTestDatabase, getTestHost, getTestPassword, getTestPort, getTestUser, mysqlVersionMeetsMinimum, mysqlVersionMeetsMinimum

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

trustStoreUrl

final java.lang.String trustStoreUrl

See Also:

Constant Field Values

trustStorePath

final java.lang.String trustStorePath

See Also:

Constant Field Values

trustStorePassword

final java.lang.String trustStorePassword

See Also:

Constant Field Values

clientKeyStoreUrl

final java.lang.String clientKeyStoreUrl

See Also:

Constant Field Values

clientKeyStorePath

final java.lang.String clientKeyStorePath

See Also:

Constant Field Values

clientKeyStorePassword

final java.lang.String clientKeyStorePassword

See Also:

Constant Field Values

sslFreeTestProperties

final java.util.Properties sslFreeTestProperties

sslFreeBaseUrl

java.lang.String sslFreeBaseUrl

Constructor Detail

SecureSessionTest

public SecureSessionTest()

Method Detail

setupSecureSessionTest

@BeforeEach
public void setupSecureSessionTest()

teardownSecureSessionTest

@AfterEach
public void teardownSecureSessionTest()

testNonSecureSession

@Test
public void testNonSecureSession()

Tests non-secure Sessions created via URL and properties map.

testSecureSessionDefaultAndRequired

@Test
public void testSecureSessionDefaultAndRequired()

Tests secure Sessions created via URL and properties map. This is the default if no ssl-mode is provided.

testSecureSessionDefaultAndRequiredWithSystemPropsPresent

@Test
public void testSecureSessionDefaultAndRequiredWithSystemPropsPresent()

Tests secure Sessions created via URL and properties map, with the SSL system properties also defined.

testSecureSessionVerifyServerCertificate

@Test
public void testSecureSessionVerifyServerCertificate()

Tests secure Sessions created via URL and properties map, verifying server certificate.

testSecureSessionVerifyServerCertificateUsingSystemProps

@Test
public void testSecureSessionVerifyServerCertificateUsingSystemProps()

Tests secure Sessions created via URL and properties map combined with SSL system properties, verifying server certificate.

testSecureSessionVerifyServerCertificateIdentity

@Test
 @Disabled(value="requires a certificate with CN=<host_name> equals to the host name in the test URL")
public void testSecureSessionVerifyServerCertificateIdentity()

Tests secure Sessions created via URL and properties map, verifying server certificate. This test would pass if the server certificate had "CN=", with equals to the host name in the test URL.

testSecureSessionMissingTrustStore

@Test
public void testSecureSessionMissingTrustStore()

Tests exception thrown on missing truststore for a secure Session.

testSecureSessionVerifyServerCertificateIdentityFailure

@Test
public void testSecureSessionVerifyServerCertificateIdentityFailure()

Tests exception thrown on verifying server certificate identity failure. The server certificate used in this test has "CN=MySQL Connector/J Server".

testAuthMechanisms

@Test
public void testAuthMechanisms()
                              throws java.lang.Throwable

Tests that PLAIN, MYSQL41, SHA256_MEMORY, and EXTERNAL authentication mechanisms.

Throws:

java.lang.Throwable

testTLSv1_2

@Test
public void testTLSv1_2()
                       throws java.lang.Exception

Tests TLSv1.2

Throws:

java.lang.Exception

allowsRsa

private boolean allowsRsa(Session sess)

assertUser

private void assertUser(java.lang.String user,
                        Session sess)

assertTlsVersion

private void assertTlsVersion(Session sess,
                              java.lang.String expectedTlsVersion)

getHighestCommonTlsVersion

private java.lang.String getHighestCommonTlsVersion(Session sess)
                                             throws java.lang.Exception

Throws:

java.lang.Exception

testBug25494338

@Test
public void testBug25494338()

Tests fix for Bug#25494338, ENABLEDSSLCIPHERSUITES PARAMETER NOT WORKING AS EXPECTED WITH X-PLUGIN.

testBug23597281

@Test
public void testBug23597281()

Tests fix for Bug#23597281, GETNODESESSION() CALL WITH SSL PARAMETERS RETURNS CJCOMMUNICATIONSEXCEPTION

testBug26227653

@Test
public void testBug26227653()

Tests fix for Bug#26227653, WL#10528 DIFF BEHAVIOUR WHEN SYSTEM PROP JAVAX.NET.SSL.TRUSTSTORETYPE IS SET The actual bug is: if wrong system-wide SSL settings are provided, the session should not fail if 'xdevapi.ssl-mode=REQUIRED'.

testBug27629553

@Test
public void testBug27629553()

Tests fix for Bug#27629553, NPE FROM GETSESSION() FOR SSL CONNECTION WHEN NO PASSWORD PASSED.

testXdevapiTlsVersionsAndCiphersuites

@Test
public void testXdevapiTlsVersionsAndCiphersuites()
                                                 throws java.lang.Exception

Throws:

java.lang.Exception

testXdevapiSslConnectionOptions

@Test
public void testXdevapiSslConnectionOptions()
                                           throws java.lang.Exception

Tests that given SSL/TLS related session properties values are processed as expected.

Throws:

java.lang.Exception

testFallbackToSystemTrustStore

@Test
public void testFallbackToSystemTrustStore()
                                          throws java.lang.Exception

Tests connection property 'xdevapi.fallback-to-system-truststore' behavior.

Throws:

java.lang.Exception

testFallbackToSystemKeyStore

@Test
public void testFallbackToSystemKeyStore()
                                        throws java.lang.Exception

Tests connection property 'xdevapi.fallback-to-system-keystore' behavior.

Throws:

java.lang.Exception

testTLSVersionRemoval

@Test
public void testTLSVersionRemoval()
                                 throws java.lang.Exception

Tests WL#14805, Remove support for TLS 1.0 and 1.1.

Throws:

java.lang.Exception

testTSLConflictingOptions

@Test
public void testTSLConflictingOptions()
                                     throws java.lang.Exception

Tests WL#14835, Align TLS option checking across connectors

Throws:

java.lang.Exception