You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by rh...@apache.org on 2006/08/09 15:51:33 UTC
svn commit: r430056 [2/4] - in /db/derby/code/trunk/java:
client/org/apache/derby/client/am/ client/org/apache/derby/client/net/
client/org/apache/derby/jdbc/ drda/org/apache/derby/impl/drda/
engine/org/apache/derby/iapi/reference/ engine/org/apache/de...
Modified: db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/authentication/AuthenticationServiceBase.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/authentication/AuthenticationServiceBase.java?rev=430056&r1=430055&r2=430056&view=diff
==============================================================================
--- db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/authentication/AuthenticationServiceBase.java (original)
+++ db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/authentication/AuthenticationServiceBase.java Wed Aug 9 06:51:30 2006
@@ -94,6 +94,10 @@
*/
public static final String ID_PATTERN_NEW_SCHEME = "3b60";
+ /**
+ Userid with Strong password substitute DRDA security mechanism
+ */
+ protected static final int SECMEC_USRSSBPWD = 8;
/**
Length of the encrypted password in the new authentication scheme
@@ -368,6 +372,7 @@
);
return Boolean.valueOf(requireAuthentication).booleanValue();
}
+
/**
* This method encrypts a clear user password using a
* Single Hash algorithm such as SHA-1 (SHA equivalent)
@@ -395,44 +400,144 @@
algorithm.reset();
byte[] bytePasswd = null;
- bytePasswd = AuthenticationServiceBase.toHexByte(plainTxtUserPassword,0,plainTxtUserPassword.length());
+ bytePasswd = StringUtil.toHexByte(
+ plainTxtUserPassword,0,plainTxtUserPassword.length());
algorithm.update(bytePasswd);
byte[] encryptVal = algorithm.digest();
- String hexString = ID_PATTERN_NEW_SCHEME + org.apache.derby.iapi.util.StringUtil.toHexString(encryptVal,0,encryptVal.length);
+ String hexString = ID_PATTERN_NEW_SCHEME +
+ StringUtil.toHexString(encryptVal,0,encryptVal.length);
return (hexString);
}
- /**
-
- Convert a string into a byte array in hex format.
- <BR>
- For each character (b) two bytes are generated, the first byte
- represents the high nibble (4 bits) in hexidecimal (<code>b & 0xf0</code>),
- the second byte
- represents the low nibble (<code>b & 0x0f</code>).
- <BR>
- The character at <code>str.charAt(0)</code> is represented by the first two bytes
- in the returned String.
-
- @param str string
- @param offset starting character (zero based) to convert.
- @param length number of characters to convert.
-
- @return the byte[] (with hexidecimal format) form of the string (str)
- */
- public static byte[] toHexByte(String str, int offset, int length)
- {
- byte[] data = new byte[(length - offset) * 2];
- int end = offset+length;
- for (int i = offset; i < end; i++)
- {
- char ch = str.charAt(i);
- int high_nibble = (ch & 0xf0) >>> 4;
- int low_nibble = (ch & 0x0f);
- data[i] = (byte)high_nibble;
- data[i+1] = (byte)low_nibble;
- }
- return data;
- }
+ /**
+ * Strong Password Substitution (USRSSBPWD).
+ *
+ * This method generate a password subtitute to authenticate a client
+ * which is using a DRDA security mechanism such as SECMEC_USRSSBPWD.
+ *
+ * Depending how the user is defined in Derby and if BUILTIN
+ * is used, the stored password can be in clear-text (system level)
+ * or encrypted (hashed - *not decryptable*)) (database level) - If the
+ * user has authenticated at the network level via SECMEC_USRSSBPWD, it
+ * means we're presented with a password substitute and we need to
+ * generate a substitute password coming from the store to compare with
+ * the one passed-in.
+ *
+ * NOTE: A lot of this logic could be shared with the DRDA decryption
+ * and client encryption managers - This will be done _once_
+ * code sharing along with its rules are defined between the
+ * Derby engine, client and network code (PENDING).
+ *
+ * Substitution algorithm works as follow:
+ *
+ * PW_TOKEN = SHA-1(PW, ID)
+ * The password (PW) and user name (ID) can be of any length greater
+ * than or equal to 1 byte.
+ * The client generates a 20-byte password substitute (PW_SUB) as follows:
+ * PW_SUB = SHA-1(PW_TOKEN, RDr, RDs, ID, PWSEQs)
+ *
+ * w/ (RDs) as the random client seed and (RDr) as the server one.
+ *
+ * See PWDSSB - Strong Password Substitution Security Mechanism
+ * (DRDA Vol.3 - P.650)
+ *
+ * @return a substituted password.
+ */
+ protected String substitutePassword(
+ String userName,
+ String password,
+ Properties info,
+ boolean databaseUser) {
+
+ MessageDigest messageDigest = null;
+
+ // Pattern that is prefixed to the BUILTIN encrypted password
+ String ID_PATTERN_NEW_SCHEME = "3b60";
+
+ // PWSEQs's 8-byte value constant - See DRDA Vol 3
+ byte SECMEC_USRSSBPWD_PWDSEQS[] = {
+ (byte) 0x00, (byte) 0x00, (byte) 0x00, (byte) 0x00,
+ (byte) 0x00, (byte) 0x00, (byte) 0x00, (byte) 0x01
+ };
+
+ // Generated password substitute
+ byte[] passwordSubstitute;
+
+ try
+ {
+ messageDigest = MessageDigest.getInstance("SHA-1");
+ } catch (NoSuchAlgorithmException nsae)
+ {
+ // Ignore as we checked already during service boot-up
+ }
+ // IMPORTANT NOTE: As the password is stored single-hashed in the
+ // database, it is impossible for us to decrypt the password and
+ // recompute a substitute to compare with one generated on the source
+ // side - Hence, we have to generate a password substitute.
+ // In other words, we cannot figure what the original password was -
+ // Strong Password Substitution (USRSSBPWD) cannot be supported for
+ // targets which can't access or decrypt passwords on their side.
+ //
+ messageDigest.reset();
+
+ byte[] bytePasswd = null;
+ byte[] userBytes = StringUtil.toHexByte(userName, 0, userName.length());
+
+ if (SanityManager.DEBUG)
+ {
+ // We must have a source and target seed
+ SanityManager.ASSERT(
+ (((String) info.getProperty(Attribute.DRDA_SECTKN_IN) != null) &&
+ ((String) info.getProperty(Attribute.DRDA_SECTKN_OUT) != null)),
+ "Unexpected: Requester or server seed not available");
+ }
+
+ // Retrieve source (client) and target 8-byte seeds
+ String sourceSeedstr = info.getProperty(Attribute.DRDA_SECTKN_IN);
+ String targetSeedstr = info.getProperty(Attribute.DRDA_SECTKN_OUT);
+
+ byte[] sourceSeed_ =
+ StringUtil.fromHexString(sourceSeedstr, 0, sourceSeedstr.length());
+ byte[] targetSeed_ =
+ StringUtil.fromHexString(targetSeedstr, 0, targetSeedstr.length());
+
+ String hexString = null;
+ // If user is at the database level, we don't encrypt the password
+ // as it is already encrypted (BUILTIN scheme) - we only do the
+ // BUILTIN encryption if the user is defined at the system level
+ // only - this is required beforehands so that we can do the password
+ // substitute generation right afterwards.
+ if (!databaseUser)
+ {
+ bytePasswd = StringUtil.toHexByte(password, 0, password.length());
+ messageDigest.update(bytePasswd);
+ byte[] encryptVal = messageDigest.digest();
+ hexString = ID_PATTERN_NEW_SCHEME +
+ StringUtil.toHexString(encryptVal, 0, encryptVal.length);
+ }
+ else
+ // Already encrypted from the database store
+ hexString = password;
+
+ // Generate the password substitute now
+
+ // Generate some 20-byte password token
+ messageDigest.update(userBytes);
+ messageDigest.update(
+ StringUtil.toHexByte(hexString, 0, hexString.length()));
+ byte[] passwordToken = messageDigest.digest();
+
+ // Now we generate the 20-byte password substitute
+ messageDigest.update(passwordToken);
+ messageDigest.update(targetSeed_);
+ messageDigest.update(sourceSeed_);
+ messageDigest.update(userBytes);
+ messageDigest.update(SECMEC_USRSSBPWD_PWDSEQS);
+
+ passwordSubstitute = messageDigest.digest();
+
+ return StringUtil.toHexString(passwordSubstitute, 0,
+ passwordSubstitute.length);
+ }
}
Modified: db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/authentication/BasicAuthenticationServiceImpl.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/authentication/BasicAuthenticationServiceImpl.java?rev=430056&r1=430055&r2=430056&view=diff
==============================================================================
--- db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/authentication/BasicAuthenticationServiceImpl.java (original)
+++ db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/authentication/BasicAuthenticationServiceImpl.java Wed Aug 9 06:51:30 2006
@@ -22,6 +22,7 @@
package org.apache.derby.impl.jdbc.authentication;
import org.apache.derby.iapi.reference.MessageId;
+import org.apache.derby.iapi.reference.Attribute;
import org.apache.derby.authentication.UserAuthenticator;
import org.apache.derby.iapi.services.property.PropertyUtil;
import org.apache.derby.iapi.services.daemon.Serviceable;
@@ -148,6 +149,14 @@
Properties info
)
{
+ // Client security mechanism if any specified
+ // Note: Right now it is only used to handle clients authenticating
+ // via DRDA SECMEC_USRSSBPWD mechanism
+ String clientSecurityMechanism = null;
+ // Client security mechanism (if any) short representation
+ // Default value is none.
+ int secMec = 0;
+
// let's check if the user has been defined as a valid user of the
// JBMS system.
// We expect to find and match a System property corresponding to the
@@ -157,29 +166,71 @@
// We don't tolerate 'guest' user for now.
return false;
+ String definedUserPassword = null, passedUserPassword = null;
+
+ // If a security mechanism is specified as part of the connection
+ // properties, it indicates that we've to account as far as how the
+ // password is presented to us - in the case of SECMEC_USRSSBPWD
+ // (only expected one at the moment), the password is a substitute
+ // one which has already been hashed differently than what we store
+ // at the database level (for instance) - this will influence how we
+ // assess the substitute password to be legitimate for Derby's
+ // BUILTIN authentication scheme/provider.
+ if ((clientSecurityMechanism =
+ info.getProperty(Attribute.CLIENT_SECURITY_MECHANISM)) != null)
+ {
+ secMec = Integer.parseInt(clientSecurityMechanism);
+ }
+
//
// Check if user has been defined at the database or/and
// system level. The user (administrator) can configure it the
// way he/she wants (as well as forcing users properties to
// be retrieved at the datbase level only).
//
- String definedUserPassword = null, passedUserPassword = null;
-
- String userNameProperty = org.apache.derby.iapi.reference.Property.USER_PROPERTY_PREFIX.concat(userName);
+ String userNameProperty =
+ org.apache.derby.iapi.reference.Property.USER_PROPERTY_PREFIX.concat(
+ userName);
// check if user defined at the database level
definedUserPassword = getDatabaseProperty(userNameProperty);
- if (definedUserPassword != null) {
- // encrypt passed-in password
- passedUserPassword = encryptPassword(userPassword);
-
- } else {
-
- // check if user defined at the system level
- definedUserPassword = getSystemProperty(userNameProperty);
- passedUserPassword = userPassword;
- }
+ if (definedUserPassword != null)
+ {
+ if (secMec != SECMEC_USRSSBPWD)
+ {
+ // encrypt passed-in password
+ passedUserPassword = encryptPassword(userPassword);
+ }
+ else
+ {
+ // Dealing with a client SECMEC - password checking is
+ // slightly different and we need to generate a
+ // password substitute to compare with the substitute
+ // generated one from the client.
+ definedUserPassword = substitutePassword(userName,
+ definedUserPassword,
+ info, true);
+ // As SecMec is SECMEC_USRSSBPWD, expected passed-in password
+ // to be HexString'ified already
+ passedUserPassword = userPassword;
+ }
+ }
+ else
+ {
+ // check if user defined at the system level
+ definedUserPassword = getSystemProperty(userNameProperty);
+ passedUserPassword = userPassword;
+
+ if ((definedUserPassword != null) &&
+ (secMec == SECMEC_USRSSBPWD))
+ {
+ // Dealing with a client SECMEC - see above comments
+ definedUserPassword = substitutePassword(userName,
+ definedUserPassword,
+ info, false);
+ }
+ }
if (definedUserPassword == null)
// no such user found
@@ -196,8 +247,4 @@
// We do have a valid user
return true;
}
-
- /*
- ** Encryption related methods.
- */
}
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ibm14/testSecMec.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ibm14/testSecMec.out?rev=430056&r1=430055&r2=430056&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ibm14/testSecMec.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ibm14/testSecMec.out Wed Aug 9 06:51:30 2006
@@ -8,6 +8,7 @@
T5: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=9;
T6: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;securityMechanism=4;
T8: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=4;
+T9: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
SECMEC_USRIDPWD: OK
Test DERBY-1080
withConnectionPooling
@@ -22,6 +23,8 @@
TEST_DS (user=calvin;password=hobbes,securityMechanism=3) OK
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=9;
TEST_DS (user=calvin;password=hobbes,securityMechanism=9) OK
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS (user=calvin;password=hobbes,securityMechanism=8) OK
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin; - EXCEPTION null password not supported
TEST_DS(user=calvin)EXCEPTION getDataSourceConnection() null password not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=4;
@@ -30,6 +33,8 @@
TEST_DS (user=calvin,securityMechanism=3)EXCEPTION testSecurityMechanism() null password not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=9; - EXCEPTION null password not supported
TEST_DS (user=calvin,securityMechanism=9)EXCEPTION testSecurityMechanism() null password not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS (user=calvin,securityMechanism=8)EXCEPTION testSecurityMechanism() null password not supported
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes; - EXCEPTION null userid not supported
TEST_DS(password=hobbes)EXCEPTION getDataSourceConnection() null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=4; - EXCEPTION null userid not supported
@@ -38,6 +43,8 @@
TEST_DS (password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=9; - EXCEPTION null userid not supported
TEST_DS (password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() null userid not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS (password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism() null userid not supported
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:; - EXCEPTION Invalid database url syntax: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;
TEST_DS()EXCEPTION getDataSourceConnection() null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=4; - EXCEPTION null userid not supported
@@ -46,6 +53,17 @@
TEST_DS (,securityMechanism=3)EXCEPTION testSecurityMechanism() null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=9; - EXCEPTION null userid not supported
TEST_DS (,securityMechanism=9)EXCEPTION testSecurityMechanism() null userid not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=8; - EXCEPTION null userid not supported
+TEST_DS (,securityMechanism=8)EXCEPTION testSecurityMechanism() null userid not supported
+Test USRSSBPWD_with_BUILTIN - derby.drda.securityMechanism=null
+Turning ON Derby BUILTIN authentication
+USRSSBPWD (T0): jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;shutdown=true;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+USRSSBPWD + BUILTIN (T1): jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS - USRSSBPWD + BUILTIN (T2): OK
+USRSSBPWD + BUILTIN (T3): jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=invalid;password=user;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS - USRSSBPWD + BUILTIN (T4): OK
+Turning OFF Derby BUILTIN authentication
+USRSSBPWD + BUILTIN (T5): jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;shutdown=true;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
-----
Testing with derby.drda.securityMechanism=USER_ONLY_SECURITY
Checking security mechanism authentication with DriverManager
@@ -56,6 +74,7 @@
T5: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=9; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
T6: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;securityMechanism=4;
T8: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=4;
+T9: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
SECMEC_USRIDPWD:EXCEPTION testSecurityMechanism() Connection authorization failure occurred. Reason: security mechanism not supported
Test DERBY-1080
withConnectionPooling
@@ -69,6 +88,8 @@
TEST_DS (user=calvin;password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() Connection authorization failure occurred. Reason: security mechanism not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=9; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
TEST_DS (user=calvin;password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() Connection authorization failure occurred. Reason: security mechanism not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS (user=calvin;password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism() Connection authorization failure occurred. Reason: security mechanism not supported
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin; - EXCEPTION null password not supported
TEST_DS(user=calvin)EXCEPTION getDataSourceConnection() null password not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=4;
@@ -77,6 +98,8 @@
TEST_DS (user=calvin,securityMechanism=3)EXCEPTION testSecurityMechanism() null password not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=9; - EXCEPTION null password not supported
TEST_DS (user=calvin,securityMechanism=9)EXCEPTION testSecurityMechanism() null password not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS (user=calvin,securityMechanism=8)EXCEPTION testSecurityMechanism() null password not supported
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes; - EXCEPTION null userid not supported
TEST_DS(password=hobbes)EXCEPTION getDataSourceConnection() null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=4; - EXCEPTION null userid not supported
@@ -85,6 +108,8 @@
TEST_DS (password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=9; - EXCEPTION null userid not supported
TEST_DS (password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() null userid not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS (password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism() null userid not supported
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:; - EXCEPTION Invalid database url syntax: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;
TEST_DS()EXCEPTION getDataSourceConnection() null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=4; - EXCEPTION null userid not supported
@@ -93,6 +118,8 @@
TEST_DS (,securityMechanism=3)EXCEPTION testSecurityMechanism() null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=9; - EXCEPTION null userid not supported
TEST_DS (,securityMechanism=9)EXCEPTION testSecurityMechanism() null userid not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=8; - EXCEPTION null userid not supported
+TEST_DS (,securityMechanism=8)EXCEPTION testSecurityMechanism() null userid not supported
-----
Testing with derby.drda.securityMechanism=CLEAR_TEXT_PASSWORD_SECURITY
Checking security mechanism authentication with DriverManager
@@ -103,6 +130,7 @@
T5: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=9; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
T6: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;securityMechanism=4; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
T8: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=4; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
+T9: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
SECMEC_USRIDPWD: OK
Test DERBY-1080
withConnectionPooling
@@ -116,6 +144,8 @@
TEST_DS (user=calvin;password=hobbes,securityMechanism=3) OK
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=9; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
TEST_DS (user=calvin;password=hobbes,securityMechanism=9) OK
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS (user=calvin;password=hobbes,securityMechanism=8) OK
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin; - EXCEPTION null password not supported
TEST_DS(user=calvin)EXCEPTION getDataSourceConnection() null password not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=4; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
@@ -124,6 +154,8 @@
TEST_DS (user=calvin,securityMechanism=3)EXCEPTION testSecurityMechanism() null password not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=9; - EXCEPTION null password not supported
TEST_DS (user=calvin,securityMechanism=9)EXCEPTION testSecurityMechanism() null password not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS (user=calvin,securityMechanism=8)EXCEPTION testSecurityMechanism() null password not supported
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes; - EXCEPTION null userid not supported
TEST_DS(password=hobbes)EXCEPTION getDataSourceConnection() null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=4; - EXCEPTION null userid not supported
@@ -132,6 +164,8 @@
TEST_DS (password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=9; - EXCEPTION null userid not supported
TEST_DS (password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() null userid not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS (password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism() null userid not supported
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:; - EXCEPTION Invalid database url syntax: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;
TEST_DS()EXCEPTION getDataSourceConnection() null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=4; - EXCEPTION null userid not supported
@@ -140,6 +174,8 @@
TEST_DS (,securityMechanism=3)EXCEPTION testSecurityMechanism() null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=9; - EXCEPTION null userid not supported
TEST_DS (,securityMechanism=9)EXCEPTION testSecurityMechanism() null userid not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=8; - EXCEPTION null userid not supported
+TEST_DS (,securityMechanism=8)EXCEPTION testSecurityMechanism() null userid not supported
-----
Testing with derby.drda.securityMechanism=ENCRYPTED_USER_AND_PASSWORD_SECURITY
Checking security mechanism authentication with DriverManager
@@ -150,6 +186,7 @@
T5: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=9;
T6: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;securityMechanism=4; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
T8: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=4; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
+T9: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
SECMEC_USRIDPWD:EXCEPTION testSecurityMechanism() Connection authorization failure occurred. Reason: security mechanism not supported
Test DERBY-1080
withConnectionPooling
@@ -164,6 +201,8 @@
TEST_DS (user=calvin;password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() Connection authorization failure occurred. Reason: security mechanism not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=9;
TEST_DS (user=calvin;password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() Connection authorization failure occurred. Reason: security mechanism not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS (user=calvin;password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism() Connection authorization failure occurred. Reason: security mechanism not supported
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin; - EXCEPTION null password not supported
TEST_DS(user=calvin)EXCEPTION getDataSourceConnection() null password not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=4; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
@@ -172,6 +211,8 @@
TEST_DS (user=calvin,securityMechanism=3)EXCEPTION testSecurityMechanism() null password not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=9; - EXCEPTION null password not supported
TEST_DS (user=calvin,securityMechanism=9)EXCEPTION testSecurityMechanism() null password not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS (user=calvin,securityMechanism=8)EXCEPTION testSecurityMechanism() null password not supported
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes; - EXCEPTION null userid not supported
TEST_DS(password=hobbes)EXCEPTION getDataSourceConnection() null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=4; - EXCEPTION null userid not supported
@@ -180,6 +221,8 @@
TEST_DS (password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=9; - EXCEPTION null userid not supported
TEST_DS (password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() null userid not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS (password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism() null userid not supported
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:; - EXCEPTION Invalid database url syntax: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;
TEST_DS()EXCEPTION getDataSourceConnection() null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=4; - EXCEPTION null userid not supported
@@ -188,6 +231,67 @@
TEST_DS (,securityMechanism=3)EXCEPTION testSecurityMechanism() null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=9; - EXCEPTION null userid not supported
TEST_DS (,securityMechanism=9)EXCEPTION testSecurityMechanism() null userid not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=8; - EXCEPTION null userid not supported
+TEST_DS (,securityMechanism=8)EXCEPTION testSecurityMechanism() null userid not supported
+-----
+Testing with derby.drda.securityMechanism=STRONG_PASSWORD_SUBSTITUTE_SECURITY
+Checking security mechanism authentication with DriverManager
+T4: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=3; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
+T1: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat - EXCEPTION null userid not supported
+T2: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=max; - EXCEPTION null password not supported
+T3: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
+T5: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=9; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
+T6: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;securityMechanism=4; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
+T8: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=4; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
+T9: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+SECMEC_USRIDPWD:EXCEPTION testSecurityMechanism() Connection authorization failure occurred. Reason: security mechanism not supported
+Test DERBY-1080
+withConnectionPooling
+DERBY-1080 EXCEPTION () Connection authorization failure occurred. Reason: security mechanism not supported
+******testAllCombinationsOfUserPasswordsSecMecInput***
+Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
+TEST_DS(user=calvin;password=hobbes)EXCEPTION getDataSourceConnection() Connection authorization failure occurred. Reason: security mechanism not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=4; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
+TEST_DS (user=calvin;password=hobbes,securityMechanism=4)EXCEPTION testSecurityMechanism() Connection authorization failure occurred. Reason: security mechanism not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=3; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
+TEST_DS (user=calvin;password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() Connection authorization failure occurred. Reason: security mechanism not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=9; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
+TEST_DS (user=calvin;password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() Connection authorization failure occurred. Reason: security mechanism not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS (user=calvin;password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism() Connection authorization failure occurred. Reason: security mechanism not supported
+Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin; - EXCEPTION null password not supported
+TEST_DS(user=calvin)EXCEPTION getDataSourceConnection() null password not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=4; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
+TEST_DS (user=calvin,securityMechanism=4)EXCEPTION testSecurityMechanism() null password not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=3; - EXCEPTION null password not supported
+TEST_DS (user=calvin,securityMechanism=3)EXCEPTION testSecurityMechanism() null password not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=9; - EXCEPTION null password not supported
+TEST_DS (user=calvin,securityMechanism=9)EXCEPTION testSecurityMechanism() null password not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS (user=calvin,securityMechanism=8)EXCEPTION testSecurityMechanism() null password not supported
+Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes; - EXCEPTION null userid not supported
+TEST_DS(password=hobbes)EXCEPTION getDataSourceConnection() null userid not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=4; - EXCEPTION null userid not supported
+TEST_DS (password=hobbes,securityMechanism=4)EXCEPTION testSecurityMechanism() null userid not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=3; - EXCEPTION null userid not supported
+TEST_DS (password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() null userid not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=9; - EXCEPTION null userid not supported
+TEST_DS (password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() null userid not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS (password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism() null userid not supported
+Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:; - EXCEPTION Invalid database url syntax: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;
+TEST_DS()EXCEPTION getDataSourceConnection() null userid not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=4; - EXCEPTION null userid not supported
+TEST_DS (,securityMechanism=4)EXCEPTION testSecurityMechanism() null userid not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=3; - EXCEPTION null userid not supported
+TEST_DS (,securityMechanism=3)EXCEPTION testSecurityMechanism() null userid not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=9; - EXCEPTION null userid not supported
+TEST_DS (,securityMechanism=9)EXCEPTION testSecurityMechanism() null userid not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=8; - EXCEPTION null userid not supported
+TEST_DS (,securityMechanism=8)EXCEPTION testSecurityMechanism() null userid not supported
+Test USRSSBPWD_with_BUILTIN - derby.drda.securityMechanism=STRONG_PASSWORD_SUBSTITUTE_SECURITY
+Turning ON Derby BUILTIN authentication
+EXCEPTION getConnectionWithSecMec() Connection authorization failure occurred. Reason: security mechanism not supported
-----
Testing with derby.drda.securityMechanism=INVALID_VALUE
EXPECTED EXCEPTION DRDA_InvalidValue.U:Invalid value, INVALID_VALUE, for derby.drda.securityMechanism.
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/testSecMec.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/testSecMec.out?rev=430056&r1=430055&r2=430056&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/testSecMec.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/testSecMec.out Wed Aug 9 06:51:30 2006
@@ -8,6 +8,7 @@
T5: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=9; - EXCEPTION java.lang.ClassNotFoundException is caught when initializing EncryptionManager 'IBMJCE'
T6: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;securityMechanism=4;
T8: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=4;
+T9: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
SECMEC_USRIDPWD: OK
Test DERBY-1080
withConnectionPooling
@@ -21,6 +22,8 @@
TEST_DS (user=calvin;password=hobbes,securityMechanism=3) OK
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=9; - EXCEPTION java.lang.ClassNotFoundException is caught when initializing EncryptionManager 'IBMJCE'
TEST_DS (user=calvin;password=hobbes,securityMechanism=9) OK
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS (user=calvin;password=hobbes,securityMechanism=8) OK
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin; - EXCEPTION null password not supported
TEST_DS(user=calvin)EXCEPTION getDataSourceConnection() null password not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=4;
@@ -29,6 +32,8 @@
TEST_DS (user=calvin,securityMechanism=3)EXCEPTION testSecurityMechanism() null password not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=9; - EXCEPTION null password not supported
TEST_DS (user=calvin,securityMechanism=9)EXCEPTION testSecurityMechanism() null password not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS (user=calvin,securityMechanism=8)EXCEPTION testSecurityMechanism() null password not supported
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes; - EXCEPTION null userid not supported
TEST_DS(password=hobbes)EXCEPTION getDataSourceConnection() null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=4; - EXCEPTION null userid not supported
@@ -37,6 +42,8 @@
TEST_DS (password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=9; - EXCEPTION null userid not supported
TEST_DS (password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() null userid not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS (password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism() null userid not supported
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:; - EXCEPTION Invalid database url syntax: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;
TEST_DS()EXCEPTION getDataSourceConnection() null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=4; - EXCEPTION null userid not supported
@@ -45,6 +52,17 @@
TEST_DS (,securityMechanism=3)EXCEPTION testSecurityMechanism() null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=9; - EXCEPTION null userid not supported
TEST_DS (,securityMechanism=9)EXCEPTION testSecurityMechanism() null userid not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=8; - EXCEPTION null userid not supported
+TEST_DS (,securityMechanism=8)EXCEPTION testSecurityMechanism() null userid not supported
+Test USRSSBPWD_with_BUILTIN - derby.drda.securityMechanism=null
+Turning ON Derby BUILTIN authentication
+USRSSBPWD (T0): jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;shutdown=true;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+USRSSBPWD + BUILTIN (T1): jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS - USRSSBPWD + BUILTIN (T2): OK
+USRSSBPWD + BUILTIN (T3): jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=invalid;password=user;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS - USRSSBPWD + BUILTIN (T4): OK
+Turning OFF Derby BUILTIN authentication
+USRSSBPWD + BUILTIN (T5): jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;shutdown=true;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
-----
Testing with derby.drda.securityMechanism=USER_ONLY_SECURITY
Checking security mechanism authentication with DriverManager
@@ -55,6 +73,7 @@
T5: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=9; - EXCEPTION java.lang.ClassNotFoundException is caught when initializing EncryptionManager 'IBMJCE'
T6: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;securityMechanism=4;
T8: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=4;
+T9: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
SECMEC_USRIDPWD:EXCEPTION testSecurityMechanism() Connection authorization failure occurred. Reason: security mechanism not supported
Test DERBY-1080
withConnectionPooling
@@ -68,6 +87,8 @@
TEST_DS (user=calvin;password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() Connection authorization failure occurred. Reason: security mechanism not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=9; - EXCEPTION java.lang.ClassNotFoundException is caught when initializing EncryptionManager 'IBMJCE'
TEST_DS (user=calvin;password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() Connection authorization failure occurred. Reason: security mechanism not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS (user=calvin;password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism() Connection authorization failure occurred. Reason: security mechanism not supported
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin; - EXCEPTION null password not supported
TEST_DS(user=calvin)EXCEPTION getDataSourceConnection() null password not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=4;
@@ -76,6 +97,8 @@
TEST_DS (user=calvin,securityMechanism=3)EXCEPTION testSecurityMechanism() null password not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=9; - EXCEPTION null password not supported
TEST_DS (user=calvin,securityMechanism=9)EXCEPTION testSecurityMechanism() null password not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS (user=calvin,securityMechanism=8)EXCEPTION testSecurityMechanism() null password not supported
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes; - EXCEPTION null userid not supported
TEST_DS(password=hobbes)EXCEPTION getDataSourceConnection() null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=4; - EXCEPTION null userid not supported
@@ -84,6 +107,8 @@
TEST_DS (password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=9; - EXCEPTION null userid not supported
TEST_DS (password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() null userid not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS (password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism() null userid not supported
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:; - EXCEPTION Invalid database url syntax: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;
TEST_DS()EXCEPTION getDataSourceConnection() null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=4; - EXCEPTION null userid not supported
@@ -92,6 +117,8 @@
TEST_DS (,securityMechanism=3)EXCEPTION testSecurityMechanism() null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=9; - EXCEPTION null userid not supported
TEST_DS (,securityMechanism=9)EXCEPTION testSecurityMechanism() null userid not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=8; - EXCEPTION null userid not supported
+TEST_DS (,securityMechanism=8)EXCEPTION testSecurityMechanism() null userid not supported
-----
Testing with derby.drda.securityMechanism=CLEAR_TEXT_PASSWORD_SECURITY
Checking security mechanism authentication with DriverManager
@@ -102,6 +129,7 @@
T5: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=9; - EXCEPTION java.lang.ClassNotFoundException is caught when initializing EncryptionManager 'IBMJCE'
T6: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;securityMechanism=4; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
T8: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=4; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
+T9: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
SECMEC_USRIDPWD: OK
Test DERBY-1080
withConnectionPooling
@@ -115,6 +143,8 @@
TEST_DS (user=calvin;password=hobbes,securityMechanism=3) OK
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=9; - EXCEPTION java.lang.ClassNotFoundException is caught when initializing EncryptionManager 'IBMJCE'
TEST_DS (user=calvin;password=hobbes,securityMechanism=9) OK
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS (user=calvin;password=hobbes,securityMechanism=8) OK
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin; - EXCEPTION null password not supported
TEST_DS(user=calvin)EXCEPTION getDataSourceConnection() null password not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=4; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
@@ -123,6 +153,8 @@
TEST_DS (user=calvin,securityMechanism=3)EXCEPTION testSecurityMechanism() null password not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=9; - EXCEPTION null password not supported
TEST_DS (user=calvin,securityMechanism=9)EXCEPTION testSecurityMechanism() null password not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS (user=calvin,securityMechanism=8)EXCEPTION testSecurityMechanism() null password not supported
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes; - EXCEPTION null userid not supported
TEST_DS(password=hobbes)EXCEPTION getDataSourceConnection() null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=4; - EXCEPTION null userid not supported
@@ -131,6 +163,8 @@
TEST_DS (password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=9; - EXCEPTION null userid not supported
TEST_DS (password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() null userid not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS (password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism() null userid not supported
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:; - EXCEPTION Invalid database url syntax: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;
TEST_DS()EXCEPTION getDataSourceConnection() null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=4; - EXCEPTION null userid not supported
@@ -139,6 +173,8 @@
TEST_DS (,securityMechanism=3)EXCEPTION testSecurityMechanism() null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=9; - EXCEPTION null userid not supported
TEST_DS (,securityMechanism=9)EXCEPTION testSecurityMechanism() null userid not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=8; - EXCEPTION null userid not supported
+TEST_DS (,securityMechanism=8)EXCEPTION testSecurityMechanism() null userid not supported
-----
Testing with derby.drda.securityMechanism=ENCRYPTED_USER_AND_PASSWORD_SECURITY
Checking security mechanism authentication with DriverManager
@@ -149,6 +185,7 @@
T5: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=9; - EXCEPTION java.lang.ClassNotFoundException is caught when initializing EncryptionManager 'IBMJCE'
T6: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;securityMechanism=4; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
T8: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=4; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
+T9: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
SECMEC_USRIDPWD:EXCEPTION testSecurityMechanism() Connection authorization failure occurred. Reason: security mechanism not supported
Test DERBY-1080
withConnectionPooling
@@ -162,6 +199,8 @@
TEST_DS (user=calvin;password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() Connection authorization failure occurred. Reason: security mechanism not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=9; - EXCEPTION java.lang.ClassNotFoundException is caught when initializing EncryptionManager 'IBMJCE'
TEST_DS (user=calvin;password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() Connection authorization failure occurred. Reason: security mechanism not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS (user=calvin;password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism() Connection authorization failure occurred. Reason: security mechanism not supported
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin; - EXCEPTION null password not supported
TEST_DS(user=calvin)EXCEPTION getDataSourceConnection() null password not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=4; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
@@ -170,6 +209,8 @@
TEST_DS (user=calvin,securityMechanism=3)EXCEPTION testSecurityMechanism() null password not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=9; - EXCEPTION null password not supported
TEST_DS (user=calvin,securityMechanism=9)EXCEPTION testSecurityMechanism() null password not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS (user=calvin,securityMechanism=8)EXCEPTION testSecurityMechanism() null password not supported
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes; - EXCEPTION null userid not supported
TEST_DS(password=hobbes)EXCEPTION getDataSourceConnection() null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=4; - EXCEPTION null userid not supported
@@ -178,6 +219,8 @@
TEST_DS (password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=9; - EXCEPTION null userid not supported
TEST_DS (password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() null userid not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS (password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism() null userid not supported
Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:; - EXCEPTION Invalid database url syntax: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;
TEST_DS()EXCEPTION getDataSourceConnection() null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=4; - EXCEPTION null userid not supported
@@ -186,6 +229,67 @@
TEST_DS (,securityMechanism=3)EXCEPTION testSecurityMechanism() null userid not supported
# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=9; - EXCEPTION null userid not supported
TEST_DS (,securityMechanism=9)EXCEPTION testSecurityMechanism() null userid not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=8; - EXCEPTION null userid not supported
+TEST_DS (,securityMechanism=8)EXCEPTION testSecurityMechanism() null userid not supported
+-----
+Testing with derby.drda.securityMechanism=STRONG_PASSWORD_SUBSTITUTE_SECURITY
+Checking security mechanism authentication with DriverManager
+T4: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=3; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
+T1: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat - EXCEPTION null userid not supported
+T2: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=max; - EXCEPTION null password not supported
+T3: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
+T5: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=9; - EXCEPTION java.lang.ClassNotFoundException is caught when initializing EncryptionManager 'IBMJCE'
+T6: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;securityMechanism=4; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
+T8: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=4; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
+T9: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+SECMEC_USRIDPWD:EXCEPTION testSecurityMechanism() Connection authorization failure occurred. Reason: security mechanism not supported
+Test DERBY-1080
+withConnectionPooling
+DERBY-1080 EXCEPTION () java.lang.ClassNotFoundException is caught when initializing EncryptionManager 'IBMJCE'
+******testAllCombinationsOfUserPasswordsSecMecInput***
+Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
+TEST_DS(user=calvin;password=hobbes)EXCEPTION getDataSourceConnection() Connection authorization failure occurred. Reason: security mechanism not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=4; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
+TEST_DS (user=calvin;password=hobbes,securityMechanism=4)EXCEPTION testSecurityMechanism() Connection authorization failure occurred. Reason: security mechanism not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=3; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
+TEST_DS (user=calvin;password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() Connection authorization failure occurred. Reason: security mechanism not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=9; - EXCEPTION java.lang.ClassNotFoundException is caught when initializing EncryptionManager 'IBMJCE'
+TEST_DS (user=calvin;password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() Connection authorization failure occurred. Reason: security mechanism not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS (user=calvin;password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism() Connection authorization failure occurred. Reason: security mechanism not supported
+Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin; - EXCEPTION null password not supported
+TEST_DS(user=calvin)EXCEPTION getDataSourceConnection() null password not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=4; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
+TEST_DS (user=calvin,securityMechanism=4)EXCEPTION testSecurityMechanism() null password not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=3; - EXCEPTION null password not supported
+TEST_DS (user=calvin,securityMechanism=3)EXCEPTION testSecurityMechanism() null password not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=9; - EXCEPTION null password not supported
+TEST_DS (user=calvin,securityMechanism=9)EXCEPTION testSecurityMechanism() null password not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS (user=calvin,securityMechanism=8)EXCEPTION testSecurityMechanism() null password not supported
+Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes; - EXCEPTION null userid not supported
+TEST_DS(password=hobbes)EXCEPTION getDataSourceConnection() null userid not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=4; - EXCEPTION null userid not supported
+TEST_DS (password=hobbes,securityMechanism=4)EXCEPTION testSecurityMechanism() null userid not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=3; - EXCEPTION null userid not supported
+TEST_DS (password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() null userid not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=9; - EXCEPTION null userid not supported
+TEST_DS (password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() null userid not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:password=hobbes;securityMechanism=8; - EXCEPTION security mechanism '8' not supported
+TEST_DS (password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism() null userid not supported
+Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:; - EXCEPTION Invalid database url syntax: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;
+TEST_DS()EXCEPTION getDataSourceConnection() null userid not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=4; - EXCEPTION null userid not supported
+TEST_DS (,securityMechanism=4)EXCEPTION testSecurityMechanism() null userid not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=3; - EXCEPTION null userid not supported
+TEST_DS (,securityMechanism=3)EXCEPTION testSecurityMechanism() null userid not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=9; - EXCEPTION null userid not supported
+TEST_DS (,securityMechanism=9)EXCEPTION testSecurityMechanism() null userid not supported
+# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:;securityMechanism=8; - EXCEPTION null userid not supported
+TEST_DS (,securityMechanism=8)EXCEPTION testSecurityMechanism() null userid not supported
+Test USRSSBPWD_with_BUILTIN - derby.drda.securityMechanism=STRONG_PASSWORD_SUBSTITUTE_SECURITY
+Turning ON Derby BUILTIN authentication
+EXCEPTION getConnectionWithSecMec() Connection authorization failure occurred. Reason: security mechanism not supported
-----
Testing with derby.drda.securityMechanism=INVALID_VALUE
EXPECTED EXCEPTION DRDA_InvalidValue.U:Invalid value, INVALID_VALUE, for derby.drda.securityMechanism.