db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rhille...@apache.org
Subject 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...
Date Wed, 09 Aug 2006 13:51:33 GMT
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.



Mime
View raw message