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 mi...@apache.org on 2006/09/09 03:29:44 UTC
svn commit: r441722 - in /db/derby/code/trunk/java:
drda/org/apache/derby/impl/drda/
testing/org/apache/derbyTesting/functionTests/master/
testing/org/apache/derbyTesting/functionTests/master/DerbyNet/
testing/org/apache/derbyTesting/functionTests/mast...
Author: mikem
Date: Fri Sep 8 18:29:42 2006
New Revision: 441722
URL: http://svn.apache.org/viewvc?view=rev&rev=441722
Log:
DERBY-1675
contributed by Sunitha Kambhampati
USRIDPWD support depends on the JCE available in the classpath of the server
This patch(derby1675.diff.txt) does the following
1. Add code to check if server jvm can support EUSRIDPWD.
2. Throw an error if the derby.drda.securityMechanism is set to ENCRYPTED_USER_AND_PASSWORD_SECURITY
and if the server jvm cannot support EUSRIDPWD.
3. Server sends the client the list of supported security mechanisms as part of ACCSECRD. Now, the server will correctly only send EUSRIDPWD as an option if the running server can support this security mechanism.
Test related changes:
Changes were made to testProtocol.java and a new method readSecMecAndSECCHKCD is added to TestProto to read the SECMEC and SECCHKCD values. Note, that with ibm142 and ibm15 jvms that support eusridpwd, the SECMEC value 9 (eusridpwd) will be sent as part of the ACCSECRD response. But for the jvms that dont support the eusridpwd, the SECMEC value of 9 wont be sent. The new method readSecMecAndSECCHKCD takes
care of printing out the SECMEC values that are sent by the server - this results in the need for a new master file for the jvm that support eusridpwd and the jvm that cannot support it. A new master file has been added for ibm14.
Tests for codepath that covers #2 is already present in testSecMec.java. This results in themaster updates for the jvms that do not support eusridpwd for the case where server is started with
derby..drda.securityMechanism=ENCRYPTED_USER_AND_PASSWORD_SECURITY.
Added:
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ibm14/
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ibm14/testProtocol.out
Modified:
db/derby/code/trunk/java/drda/org/apache/derby/impl/drda/DRDAConnThread.java
db/derby/code/trunk/java/drda/org/apache/derby/impl/drda/NetworkServerControlImpl.java
db/derby/code/trunk/java/drda/org/apache/derby/impl/drda/TestProto.java
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk14/ver2.8/testSecMec.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/testSecMec.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.6/testSecMec.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.8/testSecMec.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/testSecMec.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/testSecMec.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/testProtocol.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/protocol.tests
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/testSecMec.java
Modified: db/derby/code/trunk/java/drda/org/apache/derby/impl/drda/DRDAConnThread.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/drda/org/apache/derby/impl/drda/DRDAConnThread.java?view=diff&rev=441722&r1=441721&r2=441722
==============================================================================
--- db/derby/code/trunk/java/drda/org/apache/derby/impl/drda/DRDAConnThread.java (original)
+++ db/derby/code/trunk/java/drda/org/apache/derby/impl/drda/DRDAConnThread.java Fri Sep 8 18:29:42 2006
@@ -1688,8 +1688,10 @@
securityMechanism != CodePoint.SECMEC_USRIDONL)
{
// These are the only other mechanisms we understand
- if ((securityMechanism !=
- CodePoint.SECMEC_EUSRIDPWD) &&
+ if (((securityMechanism != CodePoint.SECMEC_EUSRIDPWD) ||
+ (securityMechanism == CodePoint.SECMEC_EUSRIDPWD &&
+ !server.supportsEUSRIDPWD())
+ ) &&
(securityMechanism !=
CodePoint.SECMEC_USRSSBPWD))
//securityCheckCode = CodePoint.SECCHKCD_NOTSUPPORTED;
@@ -2671,7 +2673,10 @@
// mechanisms for value of one SECMEC codepoint (JIRA 926)
// these are the ones we know about
writer.writeScalar2Bytes(CodePoint.SECMEC, CodePoint.SECMEC_USRIDPWD);
- writer.writeScalar2Bytes(CodePoint.SECMEC, CodePoint.SECMEC_EUSRIDPWD);
+ // include EUSRIDPWD in the list of supported secmec only if
+ // server can truely support it in the jvm that is running in
+ if ( server.supportsEUSRIDPWD())
+ writer.writeScalar2Bytes(CodePoint.SECMEC, CodePoint.SECMEC_EUSRIDPWD);
writer.writeScalar2Bytes(CodePoint.SECMEC, CodePoint.SECMEC_USRIDONL);
writer.writeScalar2Bytes(CodePoint.SECMEC, CodePoint.SECMEC_USRSSBPWD);
}
Modified: db/derby/code/trunk/java/drda/org/apache/derby/impl/drda/NetworkServerControlImpl.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/drda/org/apache/derby/impl/drda/NetworkServerControlImpl.java?view=diff&rev=441722&r1=441721&r2=441722
==============================================================================
--- db/derby/code/trunk/java/drda/org/apache/derby/impl/drda/NetworkServerControlImpl.java (original)
+++ db/derby/code/trunk/java/drda/org/apache/derby/impl/drda/NetworkServerControlImpl.java Fri Sep 8 18:29:42 2006
@@ -297,8 +297,32 @@
// databases it has booted.
private boolean shutdownDatabasesOnShutdown = false;
+ // Sun JCE does not have support for EUSRIDPWD, whereas
+ // most versions of IBM JCE have support for this. Hence
+ // find out if the server can support EUSRIDPWD.
+ private static boolean SUPPORTS_EUSRIDPWD = false;
- // constructor
+ static
+ {
+ try
+ {
+ // The DecryptionManager class will instantiate objects of the required
+ // security algorithms that are needed for EUSRIDPWD
+ // An exception will be thrown if support is not available
+ // in the JCE implementation in the JVM in which the server
+ // is started.
+ new DecryptionManager();
+ SUPPORTS_EUSRIDPWD = true;
+ }catch(Exception e)
+ {
+ // if an exception is thrown, ignore exception.
+ // set SUPPORTS_EUSRIDPWD to false indicating that the server
+ // does not have support for EUSRIDPWD security mechanism
+ SUPPORTS_EUSRIDPWD = false;
+ }
+ }
+
+ // constructor
public NetworkServerControlImpl() throws Exception
{
init();
@@ -2578,6 +2602,17 @@
return null;
}
+ /**
+ * EUSRIDPWD support depends on the availability of the
+ * algorithm in the JCE implementation in the classpath
+ * of the server. At runtime, information about this
+ * capability is figured out.
+ * @return whether EUSRIDPWD is supported or not
+ */
+ boolean supportsEUSRIDPWD()
+ {
+ return SUPPORTS_EUSRIDPWD;
+ }
/**
* Get integer property values
*
@@ -2925,7 +2960,12 @@
{
allowOnlySecurityMechanism = getSecMecValue(s);
- if (allowOnlySecurityMechanism == INVALID_OR_NOTSET_SECURITYMECHANISM)
+ // if server vm cannot support EUSRIDPWD, then do not allow
+ // derby.drda.securityMechanism to be set to EUSRIDPWD security
+ // mechanism
+ if ((allowOnlySecurityMechanism == INVALID_OR_NOTSET_SECURITYMECHANISM) ||
+ (allowOnlySecurityMechanism == CodePoint.SECMEC_EUSRIDPWD &&
+ !SUPPORTS_EUSRIDPWD))
consolePropertyMessage("DRDA_InvalidValue.U", new String []
{s, Property.DRDA_PROP_SECURITYMECHANISM});
}
Modified: db/derby/code/trunk/java/drda/org/apache/derby/impl/drda/TestProto.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/drda/org/apache/derby/impl/drda/TestProto.java?view=diff&rev=441722&r1=441721&r2=441722
==============================================================================
--- db/derby/code/trunk/java/drda/org/apache/derby/impl/drda/TestProto.java (original)
+++ db/derby/code/trunk/java/drda/org/apache/derby/impl/drda/TestProto.java Fri Sep 8 18:29:42 2006
@@ -110,6 +110,7 @@
private static final int CHECK_SQLCARD = 54;
private static final int MORE_DATA = 55;
private static final int COMPLETE_TEST = 56;
+ private static final int READ_SECMEC_SECCHKCD = 57;
private static final String MULTIVAL_START = "MULTIVALSTART";
private static final String MULTIVAL_SEP = "SEP";
@@ -324,6 +325,7 @@
commandTable.put("checksqlcard", new Integer(CHECK_SQLCARD));
commandTable.put("moredata", new Integer(MORE_DATA));
commandTable.put("completetest", new Integer(COMPLETE_TEST));
+ commandTable.put("readsecmecandsecchkcd", new Integer(READ_SECMEC_SECCHKCD));
Integer key;
for (Enumeration e = codePointNameTable.keys(); e.hasMoreElements(); )
@@ -468,6 +470,9 @@
val = reader.readByte();
checkIntOrCP(val);
break;
+ case READ_SECMEC_SECCHKCD:
+ readSecMecAndSECCHKCD();
+ break;
case READ_BYTES:
byte[] byteArray = reader.readBytes();
byte[] reqArray = getBytes();
@@ -884,6 +889,47 @@
if (codepoint != reqCP)
cpError(codepoint, reqCP);
}
+
+ /**
+ * Handle the case of testing the reading of SECMEC and SECCHKCD,
+ * where on an invalid SECMEC value for ACCSEC, the server can send
+ * valid supported SECMEC values. One of the valid supported value can be
+ * EUSRIDPWD (secmec value of 9) depending on if the server JVM
+ * can actually support it or not.
+ * @exception IOException, DRDAProtocolException error reading file or protocol
+ */
+ private void readSecMecAndSECCHKCD() throws IOException, DRDAProtocolException
+ {
+ int codepoint;
+ boolean notDone = true;
+ int val = -1;
+ do
+ {
+ codepoint = reader.readLengthAndCodePoint();
+ switch(codepoint)
+ {
+ case CodePoint.SECMEC:
+ {
+ System.out.print("SECMEC=");
+ val = reader.readNetworkShort();
+ System.out.print(val+" ");
+ }
+ break;
+ case CodePoint.SECCHKCD:
+ {
+ System.out.print("SECCHKCD=");
+ val = reader.readByte();
+ System.out.println(val);
+ notDone = false;
+ }
+ break;
+ default:
+ notDone=false;
+ }
+ }while(notDone);
+ }
+
+
/**
* Codepoint error
*
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk14/ver2.8/testSecMec.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk14/ver2.8/testSecMec.out?view=diff&rev=441722&r1=441721&r2=441722
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk14/ver2.8/testSecMec.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk14/ver2.8/testSecMec.out Fri Sep 8 18:29:42 2006
@@ -171,67 +171,7 @@
TEST_DS (,securityMechanism=8)EXCEPTION testSecurityMechanism() security mechanism '8' not supported
-----
Testing with derby.drda.securityMechanism=ENCRYPTED_USER_AND_PASSWORD_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
-SQLSTATE(null): java.security.InvalidAlgorithmParameterException is caught when initializing EncryptionManager 'Prime size must be multiple of 64, and can only range from 512 to 1024 (inclusive)'
-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
-SQLSTATE(null): java.security.InvalidAlgorithmParameterException is caught when initializing EncryptionManager 'Prime size must be multiple of 64, and can only range from 512 to 1024 (inclusive)'
-T5: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=9; - EXCEPTION java.security.InvalidAlgorithmParameterException is caught when initializing EncryptionManager 'Prime size must be multiple of 64, and can only range from 512 to 1024 (inclusive)'
-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
-SQLSTATE(null): java.security.InvalidAlgorithmParameterException is caught when initializing EncryptionManager 'Prime size must be multiple of 64, and can only range from 512 to 1024 (inclusive)'
-Test DERBY-1080
-withConnectionPooling
-DERBY-1080 EXCEPTION () java.security.InvalidAlgorithmParameterException is caught when initializing EncryptionManager 'Prime size must be multiple of 64, and can only range from 512 to 1024 (inclusive)'
-******testAllCombinationsOfUserPasswordsSecMecInput***
-Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
-SQLSTATE(null): java.security.InvalidAlgorithmParameterException is caught when initializing EncryptionManager 'Prime size must be multiple of 64, and can only range from 512 to 1024 (inclusive)'
-TEST_DS(user=calvin;password=hobbes)EXCEPTION getDataSourceConnection() Connection authorization failure occurred. Reason: security mechanism not supported
-SQLSTATE(null): java.security.InvalidAlgorithmParameterException is caught when initializing EncryptionManager 'Prime size must be multiple of 64, and can only range from 512 to 1024 (inclusive)'
-# 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
-SQLSTATE(null): java.security.InvalidAlgorithmParameterException is caught when initializing EncryptionManager 'Prime size must be multiple of 64, and can only range from 512 to 1024 (inclusive)'
-TEST_DS (user=calvin;password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() Connection authorization failure occurred. Reason: security mechanism not supported
-SQLSTATE(null): java.security.InvalidAlgorithmParameterException is caught when initializing EncryptionManager 'Prime size must be multiple of 64, and can only range from 512 to 1024 (inclusive)'
-# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=9; - EXCEPTION java.security.InvalidAlgorithmParameterException is caught when initializing EncryptionManager 'Prime size must be multiple of 64, and can only range from 512 to 1024 (inclusive)'
-TEST_DS (user=calvin;password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() java.security.InvalidAlgorithmParameterException is caught when initializing EncryptionManager 'Prime size must be multiple of 64, and can only range from 512 to 1024 (inclusive)'
-# 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() security mechanism '8' 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() Connection authorization failure occurred. Reason: security mechanism 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() security mechanism '8' 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() security mechanism '8' 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() security mechanism '8' not supported
+EXCEPTION DRDA_InvalidValue.U:Invalid value, ENCRYPTED_USER_AND_PASSWORD_SECURITY, for derby.drda.securityMechanism.
-----
Testing with derby.drda.securityMechanism=STRONG_PASSWORD_SUBSTITUTE_SECURITY
Checking security mechanism authentication with DriverManager
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?view=diff&rev=441722&r1=441721&r2=441722
==============================================================================
--- 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 Fri Sep 8 18:29:42 2006
@@ -177,60 +177,7 @@
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
-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
+EXCEPTION DRDA_InvalidValue.U:Invalid value, ENCRYPTED_USER_AND_PASSWORD_SECURITY, for derby.drda.securityMechanism.
-----
Testing with derby.drda.securityMechanism=STRONG_PASSWORD_SUBSTITUTE_SECURITY
Checking security mechanism authentication with DriverManager
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.6/testSecMec.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.6/testSecMec.out?view=diff&rev=441722&r1=441721&r2=441722
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.6/testSecMec.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.6/testSecMec.out Fri Sep 8 18:29:42 2006
@@ -171,67 +171,7 @@
TEST_DS (,securityMechanism=8)EXCEPTION testSecurityMechanism() security mechanism '8' not supported
-----
Testing with derby.drda.securityMechanism=ENCRYPTED_USER_AND_PASSWORD_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
-SQLSTATE(null): java.lang.ClassNotFoundException is caught when initializing EncryptionManager 'IBMJCE'
-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
-SQLSTATE(null): java.lang.ClassNotFoundException is caught when initializing EncryptionManager 'IBMJCE'
-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
-SQLSTATE(null): java.lang.ClassNotFoundException is caught when initializing EncryptionManager 'IBMJCE'
-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
-SQLSTATE(null): java.lang.ClassNotFoundException is caught when initializing EncryptionManager 'IBMJCE'
-TEST_DS(user=calvin;password=hobbes)EXCEPTION getDataSourceConnection() Connection authorization failure occurred. Reason: security mechanism not supported
-SQLSTATE(null): java.lang.ClassNotFoundException is caught when initializing EncryptionManager 'IBMJCE'
-# 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
-SQLSTATE(null): java.lang.ClassNotFoundException is caught when initializing EncryptionManager 'IBMJCE'
-TEST_DS (user=calvin;password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() Connection authorization failure occurred. Reason: security mechanism not supported
-SQLSTATE(null): java.lang.ClassNotFoundException is caught when initializing EncryptionManager 'IBMJCE'
-# 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() java.lang.ClassNotFoundException is caught when initializing EncryptionManager 'IBMJCE'
-# 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() security mechanism '8' 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() Connection authorization failure occurred. Reason: security mechanism 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() security mechanism '8' 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() security mechanism '8' 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() security mechanism '8' not supported
+EXCEPTION DRDA_InvalidValue.U:Invalid value, ENCRYPTED_USER_AND_PASSWORD_SECURITY, for derby.drda.securityMechanism.
-----
Testing with derby.drda.securityMechanism=STRONG_PASSWORD_SUBSTITUTE_SECURITY
Checking security mechanism authentication with DriverManager
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.8/testSecMec.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.8/testSecMec.out?view=diff&rev=441722&r1=441721&r2=441722
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.8/testSecMec.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.8/testSecMec.out Fri Sep 8 18:29:42 2006
@@ -171,67 +171,7 @@
TEST_DS (,securityMechanism=8)EXCEPTION testSecurityMechanism() security mechanism '8' not supported
-----
Testing with derby.drda.securityMechanism=ENCRYPTED_USER_AND_PASSWORD_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
-SQLSTATE(null): java.security.NoSuchAlgorithmException is caught when initializing EncryptionManager 'DH KeyPairGenerator not available'
-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
-SQLSTATE(null): java.security.NoSuchAlgorithmException is caught when initializing EncryptionManager 'DH KeyPairGenerator not available'
-T5: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=neelima;password=lee;securityMechanism=9; - EXCEPTION java.security.NoSuchAlgorithmException is caught when initializing EncryptionManager 'DH KeyPairGenerator not available'
-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
-SQLSTATE(null): java.security.NoSuchAlgorithmException is caught when initializing EncryptionManager 'DH KeyPairGenerator not available'
-Test DERBY-1080
-withConnectionPooling
-DERBY-1080 EXCEPTION () java.security.NoSuchAlgorithmException is caught when initializing EncryptionManager 'DH KeyPairGenerator not available'
-******testAllCombinationsOfUserPasswordsSecMecInput***
-Test: jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes; - EXCEPTION Connection authorization failure occurred. Reason: security mechanism not supported
-SQLSTATE(null): java.security.NoSuchAlgorithmException is caught when initializing EncryptionManager 'DH KeyPairGenerator not available'
-TEST_DS(user=calvin;password=hobbes)EXCEPTION getDataSourceConnection() Connection authorization failure occurred. Reason: security mechanism not supported
-SQLSTATE(null): java.security.NoSuchAlgorithmException is caught when initializing EncryptionManager 'DH KeyPairGenerator not available'
-# 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
-SQLSTATE(null): java.security.NoSuchAlgorithmException is caught when initializing EncryptionManager 'DH KeyPairGenerator not available'
-TEST_DS (user=calvin;password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() Connection authorization failure occurred. Reason: security mechanism not supported
-SQLSTATE(null): java.security.NoSuchAlgorithmException is caught when initializing EncryptionManager 'DH KeyPairGenerator not available'
-# jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat:user=calvin;password=hobbes;securityMechanism=9; - EXCEPTION java.security.NoSuchAlgorithmException is caught when initializing EncryptionManager 'DH KeyPairGenerator not available'
-TEST_DS (user=calvin;password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() java.security.NoSuchAlgorithmException is caught when initializing EncryptionManager 'DH KeyPairGenerator not available'
-# 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() security mechanism '8' 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() Connection authorization failure occurred. Reason: security mechanism 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() security mechanism '8' 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() security mechanism '8' 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() security mechanism '8' not supported
+EXCEPTION DRDA_InvalidValue.U:Invalid value, ENCRYPTED_USER_AND_PASSWORD_SECURITY, for derby.drda.securityMechanism.
-----
Testing with derby.drda.securityMechanism=STRONG_PASSWORD_SUBSTITUTE_SECURITY
Checking security mechanism authentication with DriverManager
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/testSecMec.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/testSecMec.out?view=diff&rev=441722&r1=441721&r2=441722
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/testSecMec.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/testSecMec.out Fri Sep 8 18:29:42 2006
@@ -183,62 +183,7 @@
TEST_DS (,securityMechanism=8)EXCEPTION testSecurityMechanism() Password can not be null.
-----
Testing with derby.drda.securityMechanism=ENCRYPTED_USER_AND_PASSWORD_SECURITY
-Checking security mechanism authentication with DriverManager
-T4: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=3 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-T1: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-T2: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=max - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-T3: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-T5: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=9 - EXCEPTION Security exception encountered, see next exception for details.
-T6: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-T8: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-T9: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=8 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-SECMEC_USRIDPWD:EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
-SECMEC_EUSRIDPWD:EXCEPTION testSecurityMechanism() Security exception encountered, see next exception for details.
-SECMEC_USRSSBPWD:EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
-Test DERBY-1080
-withConnectionPooling
-DERBY-1080 EXCEPTION () Security exception encountered, see next exception for details.
-******testAllCombinationsOfUserPasswordsSecMecInput***
-Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-TEST_DS(user=calvin;password=hobbes)EXCEPTION getDataSourceConnection() Connection authentication failure occurred. Reason: security mechanism not supported.
-# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-TEST_DS (user=calvin;password=hobbes,securityMechanism=4)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
-# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes;securityMechanism=3 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-TEST_DS (user=calvin;password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
-# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes;securityMechanism=9 - EXCEPTION Security exception encountered, see next exception for details.
-TEST_DS (user=calvin;password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() Security exception encountered, see next exception for details.
-# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes;securityMechanism=8 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-TEST_DS (user=calvin;password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
-Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-TEST_DS(user=calvin)EXCEPTION getDataSourceConnection() Connection authentication failure occurred. Reason: security mechanism not supported.
-# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-TEST_DS (user=calvin,securityMechanism=4)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
-# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=3 - EXCEPTION Password can not be null.
-TEST_DS (user=calvin,securityMechanism=3)EXCEPTION testSecurityMechanism() Password can not be null.
-# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=9 - EXCEPTION Password can not be null.
-TEST_DS (user=calvin,securityMechanism=9)EXCEPTION testSecurityMechanism() Password can not be null.
-# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=8 - EXCEPTION Password can not be null.
-TEST_DS (user=calvin,securityMechanism=8)EXCEPTION testSecurityMechanism() Password can not be null.
-Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-TEST_DS(password=hobbes)EXCEPTION getDataSourceConnection() Connection authentication failure occurred. Reason: security mechanism not supported.
-# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-TEST_DS (password=hobbes,securityMechanism=4)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
-# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=3 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-TEST_DS (password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
-# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=9 - EXCEPTION Security exception encountered, see next exception for details.
-TEST_DS (password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() Security exception encountered, see next exception for details.
-# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=8 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-TEST_DS (password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
-Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat; - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-TEST_DS()EXCEPTION getDataSourceConnection() Connection authentication failure occurred. Reason: security mechanism not supported.
-# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-TEST_DS (,securityMechanism=4)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
-# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=3 - EXCEPTION Password can not be null.
-TEST_DS (,securityMechanism=3)EXCEPTION testSecurityMechanism() Password can not be null.
-# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=9 - EXCEPTION Password can not be null.
-TEST_DS (,securityMechanism=9)EXCEPTION testSecurityMechanism() Password can not be null.
-# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=8 - EXCEPTION Password can not be null.
-TEST_DS (,securityMechanism=8)EXCEPTION testSecurityMechanism() Password can not be null.
+EXCEPTION DRDA_InvalidValue.U:Invalid value, ENCRYPTED_USER_AND_PASSWORD_SECURITY, for derby.drda.securityMechanism.
-----
Testing with derby.drda.securityMechanism=STRONG_PASSWORD_SUBSTITUTE_SECURITY
Checking security mechanism authentication with DriverManager
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/testSecMec.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/testSecMec.out?view=diff&rev=441722&r1=441721&r2=441722
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/testSecMec.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/testSecMec.out Fri Sep 8 18:29:42 2006
@@ -183,62 +183,7 @@
TEST_DS (,securityMechanism=8)EXCEPTION testSecurityMechanism() Password can not be null.
-----
Testing with derby.drda.securityMechanism=ENCRYPTED_USER_AND_PASSWORD_SECURITY
-Checking security mechanism authentication with DriverManager
-T4: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=3 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-T1: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-T2: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=max - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-T3: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-T5: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=9 - EXCEPTION Security exception encountered, see next exception for details. Caused by exception class java.security.NoSuchProviderException: null
-T6: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-T8: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-T9: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=neelima;password=lee;securityMechanism=8 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-SECMEC_USRIDPWD:EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
-SECMEC_EUSRIDPWD:EXCEPTION testSecurityMechanism() Security exception encountered, see next exception for details. Caused by exception class java.security.NoSuchProviderException: null
-SECMEC_USRSSBPWD:EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
-Test DERBY-1080
-withConnectionPooling
-DERBY-1080 EXCEPTION () Security exception encountered, see next exception for details. Caused by exception class java.security.NoSuchProviderException: null
-******testAllCombinationsOfUserPasswordsSecMecInput***
-Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-TEST_DS(user=calvin;password=hobbes)EXCEPTION getDataSourceConnection() Connection authentication failure occurred. Reason: security mechanism not supported.
-# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-TEST_DS (user=calvin;password=hobbes,securityMechanism=4)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
-# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes;securityMechanism=3 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-TEST_DS (user=calvin;password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
-# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes;securityMechanism=9 - EXCEPTION Security exception encountered, see next exception for details. Caused by exception class java.security.NoSuchProviderException: null
-TEST_DS (user=calvin;password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() Security exception encountered, see next exception for details. Caused by exception class java.security.NoSuchProviderException: null
-# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;password=hobbes;securityMechanism=8 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-TEST_DS (user=calvin;password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
-Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-TEST_DS(user=calvin)EXCEPTION getDataSourceConnection() Connection authentication failure occurred. Reason: security mechanism not supported.
-# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-TEST_DS (user=calvin,securityMechanism=4)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
-# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=3 - EXCEPTION Password can not be null.
-TEST_DS (user=calvin,securityMechanism=3)EXCEPTION testSecurityMechanism() Password can not be null.
-# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=9 - EXCEPTION Password can not be null.
-TEST_DS (user=calvin,securityMechanism=9)EXCEPTION testSecurityMechanism() Password can not be null.
-# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;user=calvin;securityMechanism=8 - EXCEPTION Password can not be null.
-TEST_DS (user=calvin,securityMechanism=8)EXCEPTION testSecurityMechanism() Password can not be null.
-Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-TEST_DS(password=hobbes)EXCEPTION getDataSourceConnection() Connection authentication failure occurred. Reason: security mechanism not supported.
-# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-TEST_DS (password=hobbes,securityMechanism=4)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
-# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=3 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-TEST_DS (password=hobbes,securityMechanism=3)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
-# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=9 - EXCEPTION Security exception encountered, see next exception for details. Caused by exception class java.security.NoSuchProviderException: null
-TEST_DS (password=hobbes,securityMechanism=9)EXCEPTION testSecurityMechanism() Security exception encountered, see next exception for details. Caused by exception class java.security.NoSuchProviderException: null
-# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;password=hobbes;securityMechanism=8 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-TEST_DS (password=hobbes,securityMechanism=8)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
-Test: jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat; - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-TEST_DS()EXCEPTION getDataSourceConnection() Connection authentication failure occurred. Reason: security mechanism not supported.
-# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=4 - EXCEPTION Connection authentication failure occurred. Reason: security mechanism not supported.
-TEST_DS (,securityMechanism=4)EXCEPTION testSecurityMechanism() Connection authentication failure occurred. Reason: security mechanism not supported.
-# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=3 - EXCEPTION Password can not be null.
-TEST_DS (,securityMechanism=3)EXCEPTION testSecurityMechanism() Password can not be null.
-# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=9 - EXCEPTION Password can not be null.
-TEST_DS (,securityMechanism=9)EXCEPTION testSecurityMechanism() Password can not be null.
-# jdbc:derby://xxxFILTERED_HOSTNAMExxx:xxxFILTEREDPORTxxx/wombat;;securityMechanism=8 - EXCEPTION Password can not be null.
-TEST_DS (,securityMechanism=8)EXCEPTION testSecurityMechanism() Password can not be null.
+EXCEPTION DRDA_InvalidValue.U:Invalid value, ENCRYPTED_USER_AND_PASSWORD_SECURITY, for derby.drda.securityMechanism.
-----
Testing with derby.drda.securityMechanism=STRONG_PASSWORD_SUBSTITUTE_SECURITY
Checking security mechanism authentication with DriverManager
Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ibm14/testProtocol.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ibm14/testProtocol.out?view=auto&rev=441722
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ibm14/testProtocol.out (added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ibm14/testProtocol.out Fri Sep 8 18:29:42 2006
@@ -0,0 +1,302 @@
+Test invalid DSS - wrong length
+PASSED
+Test invalid DSS - missing D0
+PASSED
+Test invalid DSS - REPLY DSS
+PASSED
+First codepoint not EXCSAT
+PASSED
+Test EXTNAM too long
+PASSED
+Test non null SPVNAM
+PASSED
+Test too big SRVNAM
+PASSED
+Test too big SRVRLSLV
+PASSED
+Test too big SRVCLSNM
+PASSED
+Repeated manager levels with different values
+PASSED
+Missing required SECMEC on ACCSEC
+PASSED
+ACCSEC doesn't follow EXCSAT
+PASSED
+Test trying security mechanism we don't support
+SECMEC=3 SECMEC=9 SECMEC=4 SECMEC=8 SECCHKCD=1
+PASSED
+Test trying too big on SECMEC
+PASSED
+Test trying too small on SECMEC
+PASSED
+Test non null SECMGRNM
+PASSED
+Test missing RDBNAM on ACCSEC
+PASSED
+Test specifying encrypted security mechanism without a security token
+SECMEC=9 SECCHKCD=14
+PASSED
+Test specifying unencrypted security mechanism with a security token
+PASSED
+Test SECCHK not following after ACCSEC
+PASSED
+Test doing two tries for security mechanism
+SECMEC=3 SECMEC=9 SECMEC=4 SECMEC=8 SECCHKCD=1
+PASSED
+Test missing SECMEC on SECCHK
+PASSED
+Test different SECMEC on SECCHK than on ACCSEC
+PASSED
+Test invalid length for RDBNAM
+PASSED
+Test different RDBNAM on SECCHK than on ACCSEC
+PASSED
+Test security token on SECCHK when not required
+PASSED
+Test missing USERID on SECCHK
+PASSED
+Test missing PASSWORD on SECCHK
+PASSED
+Test ACCRDB not following SECCHK
+PASSED
+Test missing RDBACCCL from ACCRDB
+PASSED
+Test missing CRRTKN
+PASSED
+Test too small value for RDBACCCL
+PASSED
+Test too large value for RDBACCCL
+PASSED
+Test invalid value for RDBACCCL
+PASSED
+Test missing PRDID
+PASSED
+Test missing TYPDEFNAM
+PASSED
+Test missing TYPDEFOVR
+PASSED
+Test bad TYPDEFNAM
+PASSED
+Test codepoint not allowed in TYPDEFOVR
+PASSED
+Test too small value for CCSIDSBC
+PASSED
+Test too large value for CCSIDSBC
+PASSED
+Test too small value for CCSIDMBC
+PASSED
+Test too large value for CCSIDMBC
+PASSED
+Test too small value for CCSIDDBC
+PASSED
+Test too large value for CCSIDDBC
+PASSED
+Test unsupported single byte code page
+PASSED
+Test unsupported mixed byte code page
+PASSED
+Test unsupported double byte code page
+PASSED
+Test sending second EXCSAT
+PASSED
+Test sending second EXCSAT with same manager but different level
+PASSED
+Test invalid CRRTKN
+PASSED
+Test too big PRDID
+PASSED
+Test too big TYPDEFNAM
+PASSED
+Test invalid TYPDEFNAM
+PASSED
+Test too big RDBALWUPD
+PASSED
+Test invalid RDBALWUPD
+PASSED
+Test valid RDBALWUPD
+PASSED
+Test second valid RDBALWUPD
+PASSED
+Test too big PRTDTA
+PASSED
+Test for bad length for RDBNAM in PKGNAMCSN
+PASSED
+Test for bad length for PKGID in PKGNAMCSN
+PASSED
+Test for invalid codepoint on EXCSQLIMM
+PASSED
+Test for invalid TypDefNam in EXCSQLIMM objects
+PASSED
+Test for a changed TYPDEF in EXCSQLIMM objects
+PASSED
+Test for missing CCSID in TYPDEFOVR in EXCSQLIMM objects
+PASSED
+Test for invalid value for RDBCMTOK in EXCSQLIMM
+PASSED
+Test for valid value for RDBCMTOK in EXCSQLIMM
+PASSED
+Test for valid false value for RDBCMTOK in EXCSQLIMM
+PASSED
+Test that we only send one RDBUPRM per transaction
+PASSED
+Test for missing PKGNAMCSN on OPNQRY
+Also test QRYCLSRLS and MONITOR codepoints which are ignored currently
+PASSED
+Test for missing QRYBLKSZ on OPNQRY
+PASSED
+Test for wrong PKGNAMCSN on OPNQRY
+PASSED
+Test for too small size for QRYBLKSZ on OPNQRY
+PASSED
+Test for too large size for QRYBLKSZ on OPNQRY
+PASSED
+Test for too small value for QRYBLKSZ on OPNQRY
+PASSED
+Test for too large value for QRYBLKSZ on OPNQRY
+PASSED
+Test invalid value for QRYBLKCTL on OPNQRY
+PASSED
+Test invalid codepoint for OPNQRY
+PASSED
+Test too small value for QRYROWSET codepoint on CNTQRY
+PASSED
+Test too large value for QRYROWSET codepoint on CNTQRY
+PASSED
+Test invalid value for QRYROWSET on OPNQRY
+PASSED
+Test QRYROWSET=0 on OPNQRY with scrollable cursor
+PASSED
+Test to see OPNQRY returns PRCCNVRM if non-existent RDBNAM specified
+PASSED
+Test too large value for QRYRFRTBL codepoint on CNTQRY
+PASSED
+Test invalid value for QRYRFRTBL codepoint on CNTQRY
+PASSED
+Test missing PKGNAMCSN on CNTQRY
+PASSED
+Test missing QRYBLKSZ on CNTQRY
+PASSED
+Test missing QRYINSID on CNTQRY
+PASSED
+Test too small value for QRYINSID codepoint on CNTQRY
+PASSED
+Test too large value for QRYINSID codepoint on CNTQRY
+PASSED
+Test too small value for QRYROWNBR codepoint on CNTQRY
+PASSED
+Test too large value for QRYROWNBR codepoint on CNTQRY
+PASSED
+Test invalid value for QRYROWSET on CNTQRY
+PASSED
+Test too large value for QRYSCRORN codepoint on CNTQRY
+PASSED
+Test invalid value for QRYSCRORN on CNTQRY
+PASSED
+Test invalid codepoint on CNTQRY
+PASSED
+Test invalid object codepoint on CNTQRY
+PASSED
+Test OUTOVR codepoint on CNTQRY
+PASSED
+Test too large value for QRYRELSCR codepoint on CNTQRY
+PASSED
+Test invalid value for QRYRELSCR codepoint on CNTQRY
+PASSED
+Test too large value for QRYROWSNS codepoint on CNTQRY
+PASSED
+Test invalid value for QRYROWSNS codepoint on CNTQRY
+PASSED
+Test too large value for QRYBLKRST codepoint on CNTQRY
+PASSED
+Test invalid value for QRYBLKRST codepoint on CNTQRY
+PASSED
+Test too large value for QRYRTNDTA codepoint on CNTQRY
+PASSED
+Test invalid value for QRYRTNDTA codepoint on CNTQRY
+PASSED
+Test invalid value for QRYRFRTBL codepoint on CNTQRY
+PASSED
+Test too small value for NBRROW codepoint on CNTQRY
+PASSED
+Test too large value for NBRROW codepoint on CNTQRY
+PASSED
+Test too small value for MAXBLKEXT codepoint on CNTQRY
+PASSED
+Test too large value for MAXBLKEXT codepoint on CNTQRY
+PASSED
+Test too large value for RTNEXTDTA codepoint on CNTQRY
+PASSED
+Test invalid value for RTNEXTDTA codepoint on CNTQRY
+PASSED
+Test missing QRYINSID from CLSQRY
+PASSED
+Test invalid PKGNAMCSN on CLSQRY
+PASSED
+Test closing an already closed statement
+Removing second close until JCC issue with sending double close is resolve
+PASSED
+Test for too large value for OUTEXP in EXCSQLSTT
+PASSED
+Test for invalid OUTEXP in EXCSQLSTT
+PASSED
+Test for too small value for NBRROW in EXCSQLSTT
+PASSED
+Test for too large value for NBRROW in EXCSQLSTT
+PASSED
+Test for invalid QRYBLKSZ in EXCSQLSTT
+PASSED
+Test for too small value for MAXRSLCNT in EXCSQLSTT
+PASSED
+Test for too large value for MAXRSLCNT in EXCSQLSTT
+PASSED
+Test for too small value for MAXBLKEXT in EXCSQLSTT
+PASSED
+Test for too large value for MAXBLKEXT in EXCSQLSTT
+PASSED
+Test for invalid value for RDBCMTOK in EXCSQLSTT
+PASSED
+Test for too large value for OUTOVROPT in EXCSQLSTT
+PASSED
+Test for invalid value for OUTOVROPT in EXCSQLSTT
+PASSED
+Test for invalid value for QRYROWSET in EXCSQLSTT
+PASSED
+Test for invalid codepoint in EXCSQLSTT
+PASSED
+Test for missing PKGNAMCSN in EXCSQLSTT
+PASSED
+Test for too large value for RTNSQLDA in PRPSQLSTT
+PASSED
+Test for invalid value for RTNSQLDA in PRPSQLSTT
+PASSED
+Test for too large value for TYPSQLDA in PRPSQLSTT
+PASSED
+Test for invalid value for TYPSQLDA in PRPSQLSTT
+PASSED
+Test for invalid codepoint in PRPSQLSTT
+PASSED
+Test for missing required SQLSTT in PRPSQLSTT
+PASSED
+Test for invalid SQLATTR in PRPSQLSTT
+PASSED
+Test for missing PKGNAMCSN in DSCSQLSTT
+PASSED
+Test for too large value for TYPSQLDA in DSCSQLSTT
+PASSED
+Test for invalid value for TYPSQLDA in DSCSQLSTT
+PASSED
+Test for invalid codepoint in DSCSQLSTT
+PASSED
+Test for non-existant prepared statement in DSCSQLSTT
+PASSED
+Test exception is thrown when specifying non-null indicator for both MBCS and SBCS in SQLSTT
+PASSED
+Test for missing SQLSTT in EXCSQLSET - PKGNAMCT is ignored
+PASSED
+PASSED
+Test explicitly closing implicitly closed cursor
+PASSED
+Test with 65535 query block size QRYBLKSZ - DERBY-959
+PASSED
+Test 2 with 65535 query block size QRYBLKSZ - DERBY-959
+PASSED
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/testProtocol.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/testProtocol.out?view=diff&rev=441722&r1=441721&r2=441722
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/testProtocol.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/testProtocol.out Fri Sep 8 18:29:42 2006
@@ -23,6 +23,7 @@
ACCSEC doesn't follow EXCSAT
PASSED
Test trying security mechanism we don't support
+SECMEC=3 SECMEC=4 SECMEC=8 SECCHKCD=1
PASSED
Test trying too big on SECMEC
PASSED
@@ -33,12 +34,14 @@
Test missing RDBNAM on ACCSEC
PASSED
Test specifying encrypted security mechanism without a security token
+SECMEC=3 SECMEC=4 SECMEC=8 SECCHKCD=1
PASSED
Test specifying unencrypted security mechanism with a security token
PASSED
Test SECCHK not following after ACCSEC
PASSED
Test doing two tries for security mechanism
+SECMEC=3 SECMEC=4 SECMEC=8 SECCHKCD=1
PASSED
Test missing SECMEC on SECCHK
PASSED
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/protocol.tests
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/protocol.tests?view=diff&rev=441722&r1=441721&r2=441722
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/protocol.tests (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/protocol.tests Fri Sep 8 18:29:42 2006
@@ -139,11 +139,7 @@
skipDss // don't care about the EXCSATRM so just skip
readReplyDss
readLengthAndCodePoint ACCSECRD // ACCSECRD
-readScalar2Bytes SECMEC 3// SECMEC
-readScalar2Bytes SECMEC 9// SECMEC
-readScalar2Bytes SECMEC 4// SECMEC
-readScalar2Bytes SECMEC 8// SECMEC
-readScalar1Byte SECCHKCD 1// SECMEC
+readSecMecAndSECCHKCD // read secmec values and secchkcd
endTest
//
DISPLAY "Test trying too big on SECMEC"
@@ -230,8 +226,7 @@
skipDss // don't care about the EXCSATRM so just skip
readReplyDss
readLengthAndCodePoint ACCSECRD // ACCSECRD
-readScalar2Bytes SECMEC 9 // SECMEC encrypted userid password
-readScalar1Byte SECCHKCD MULTIVALSTART 10 SEP 14 MULTIVALEND // can not start decryption manager for all jdks except ibm14
+readSecMecAndSECCHKCD
endTest
//
DISPLAY "Test specifying unencrypted security mechanism with a security token"
@@ -296,11 +291,7 @@
skipDss // don't care about the EXCSATRM so just skip
readReplyDss
readLengthAndCodePoint ACCSECRD // ACCSECRD
-readScalar2Bytes SECMEC 3// SECMEC
-readScalar2Bytes SECMEC 9// SECMEC
-readScalar2Bytes SECMEC 4// SECMEC
-readScalar2Bytes SECMEC 8// SECMEC
-readScalar1Byte SECCHKCD 1// SECMEC
+readSecMecAndSECCHKCD
// ok send one we support
createDssRequest
startDdm ACCSEC
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/testSecMec.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/testSecMec.java?view=diff&rev=441722&r1=441721&r2=441722
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/testSecMec.java (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/testSecMec.java Fri Sep 8 18:29:42 2006
@@ -236,6 +236,11 @@
System.out.println("EXPECTED EXCEPTION "+ e.getMessage());
continue;
}
+ // if server jvm does not support EUSRIDPWD, an exception
+ // will be raised when server is started with
+ // derby.drda.securityMechanism=ENCRYPTED_USER_AND_PASSWORD_SECURITY
+ System.out.println("EXCEPTION " +e.getMessage());
+ continue;
}
// Wait for the NetworkServer to start. As part of DERBY-1793