Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 3793 invoked from network); 15 Sep 2006 18:45:30 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 15 Sep 2006 18:45:29 -0000 Received: (qmail 10475 invoked by uid 500); 15 Sep 2006 18:45:29 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 10407 invoked by uid 500); 15 Sep 2006 18:45:29 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" List-Id: Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 10396 invoked by uid 99); 15 Sep 2006 18:45:29 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 15 Sep 2006 11:45:29 -0700 X-ASF-Spam-Status: No, hits=-9.4 required=10.0 tests=ALL_TRUSTED,NO_REAL_NAME X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [140.211.166.113] (HELO eris.apache.org) (140.211.166.113) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 15 Sep 2006 11:45:26 -0700 Received: by eris.apache.org (Postfix, from userid 65534) id A4A261A981A; Fri, 15 Sep 2006 11:44:05 -0700 (PDT) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r446679 - in /db/derby/code/branches/10.2/java: drda/org/apache/derby/impl/drda/ engine/org/apache/derby/iapi/sql/dictionary/ testing/org/apache/derbyTesting/functionTests/master/ testing/org/apache/derbyTesting/functionTests/master/DerbyNe... Date: Fri, 15 Sep 2006 18:44:04 -0000 To: derby-commits@db.apache.org From: rhillegas@apache.org X-Mailer: svnmailer-1.1.0 Message-Id: <20060915184405.A4A261A981A@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Author: rhillegas Date: Fri Sep 15 11:44:03 2006 New Revision: 446679 URL: http://svn.apache.org/viewvc?view=rev&rev=446679 Log: DERBY-1725: Merge the following patches from the trunk to the 10.2 branch: DERBY-1675 (441722), DERBY-1809 (441601), DERBY-15222 (441584). Added: db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/ibm14/ - copied from r441723, db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ibm14/ db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/ibm14/testProtocol.out - copied unchanged from r441723, db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ibm14/testProtocol.out db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/lang/SQLAuthorizationPropTest.java - copied unchanged from r441723, db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/SQLAuthorizationPropTest.java Modified: db/derby/code/branches/10.2/java/drda/org/apache/derby/impl/drda/DRDAConnThread.java db/derby/code/branches/10.2/java/drda/org/apache/derby/impl/drda/NetworkServerControlImpl.java db/derby/code/branches/10.2/java/drda/org/apache/derby/impl/drda/TestProto.java db/derby/code/branches/10.2/java/engine/org/apache/derby/iapi/sql/dictionary/AliasDescriptor.java db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk14/ver2.8/testSecMec.out db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/testSecMec.out db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.6/testSecMec.out db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.8/testSecMec.out db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/testSecMec.out db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/testSecMec.out db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/functions.out db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/testProtocol.out db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/protocol.tests db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/testSecMec.java db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/lang/_Suite.java db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/lang/functions.sql db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/util/SQLStateConstants.java db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/junit/DatabasePropertyTestSetup.java Modified: db/derby/code/branches/10.2/java/drda/org/apache/derby/impl/drda/DRDAConnThread.java URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.2/java/drda/org/apache/derby/impl/drda/DRDAConnThread.java?view=diff&rev=446679&r1=446678&r2=446679 ============================================================================== --- db/derby/code/branches/10.2/java/drda/org/apache/derby/impl/drda/DRDAConnThread.java (original) +++ db/derby/code/branches/10.2/java/drda/org/apache/derby/impl/drda/DRDAConnThread.java Fri Sep 15 11:44:03 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/branches/10.2/java/drda/org/apache/derby/impl/drda/NetworkServerControlImpl.java URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.2/java/drda/org/apache/derby/impl/drda/NetworkServerControlImpl.java?view=diff&rev=446679&r1=446678&r2=446679 ============================================================================== --- db/derby/code/branches/10.2/java/drda/org/apache/derby/impl/drda/NetworkServerControlImpl.java (original) +++ db/derby/code/branches/10.2/java/drda/org/apache/derby/impl/drda/NetworkServerControlImpl.java Fri Sep 15 11:44:03 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/branches/10.2/java/drda/org/apache/derby/impl/drda/TestProto.java URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.2/java/drda/org/apache/derby/impl/drda/TestProto.java?view=diff&rev=446679&r1=446678&r2=446679 ============================================================================== --- db/derby/code/branches/10.2/java/drda/org/apache/derby/impl/drda/TestProto.java (original) +++ db/derby/code/branches/10.2/java/drda/org/apache/derby/impl/drda/TestProto.java Fri Sep 15 11:44:03 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/branches/10.2/java/engine/org/apache/derby/iapi/sql/dictionary/AliasDescriptor.java URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.2/java/engine/org/apache/derby/iapi/sql/dictionary/AliasDescriptor.java?view=diff&rev=446679&r1=446678&r2=446679 ============================================================================== --- db/derby/code/branches/10.2/java/engine/org/apache/derby/iapi/sql/dictionary/AliasDescriptor.java (original) +++ db/derby/code/branches/10.2/java/engine/org/apache/derby/iapi/sql/dictionary/AliasDescriptor.java Fri Sep 15 11:44:03 2006 @@ -320,4 +320,13 @@ { return specificName; } + + /** + * Functions are persistent unless they are in the SYSFUN schema. + * + */ + public boolean isPersistent() + { + return !getSchemaUUID().toString().equals(SchemaDescriptor.SYSFUN_SCHEMA_UUID); + } } Modified: db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk14/ver2.8/testSecMec.out URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk14/ver2.8/testSecMec.out?view=diff&rev=446679&r1=446678&r2=446679 ============================================================================== --- db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk14/ver2.8/testSecMec.out (original) +++ db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk14/ver2.8/testSecMec.out Fri Sep 15 11:44:03 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/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/testSecMec.out URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/testSecMec.out?view=diff&rev=446679&r1=446678&r2=446679 ============================================================================== --- db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/testSecMec.out (original) +++ db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/testSecMec.out Fri Sep 15 11:44:03 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/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.6/testSecMec.out URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.6/testSecMec.out?view=diff&rev=446679&r1=446678&r2=446679 ============================================================================== --- db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.6/testSecMec.out (original) +++ db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.6/testSecMec.out Fri Sep 15 11:44:03 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/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.8/testSecMec.out URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.8/testSecMec.out?view=diff&rev=446679&r1=446678&r2=446679 ============================================================================== --- db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.8/testSecMec.out (original) +++ db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.8/testSecMec.out Fri Sep 15 11:44:03 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/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/testSecMec.out URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/testSecMec.out?view=diff&rev=446679&r1=446678&r2=446679 ============================================================================== --- db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/testSecMec.out (original) +++ db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/testSecMec.out Fri Sep 15 11:44:03 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/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/testSecMec.out URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/testSecMec.out?view=diff&rev=446679&r1=446678&r2=446679 ============================================================================== --- db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/testSecMec.out (original) +++ db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/testSecMec.out Fri Sep 15 11:44:03 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 Modified: db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/functions.out URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/functions.out?view=diff&rev=446679&r1=446678&r2=446679 ============================================================================== --- db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/functions.out (original) +++ db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/functions.out Fri Sep 15 11:44:03 2006 @@ -700,6 +700,16 @@ NULL 0.836 ERROR 22003: The resulting value is outside the range for the data type DOUBLE. +ij> CREATE VIEW VSMT AS SELECT SIN(d) sd, PI() pi FROM SYSFUN_MATH_TEST; +0 rows inserted/updated/deleted +ij> select cast (sd as DECIMAL(6,3)), cast (pi as DECIMAL(6,3)) from VSMT; +1 |2 +----------------- +NULL |3.141 +0.620 |3.141 +0.973 |3.141 +ij> drop view VSMT; +0 rows inserted/updated/deleted ij> drop table SYSFUN_MATH_TEST; 0 rows inserted/updated/deleted ij> drop function SYSFUN.ACOS; Modified: db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/testProtocol.out URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/testProtocol.out?view=diff&rev=446679&r1=446678&r2=446679 ============================================================================== --- db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/testProtocol.out (original) +++ db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/testProtocol.out Fri Sep 15 11:44:03 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/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/protocol.tests URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/protocol.tests?view=diff&rev=446679&r1=446678&r2=446679 ============================================================================== --- db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/protocol.tests (original) +++ db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/protocol.tests Fri Sep 15 11:44:03 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/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/testSecMec.java URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/testSecMec.java?view=diff&rev=446679&r1=446678&r2=446679 ============================================================================== --- db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/testSecMec.java (original) +++ db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/testSecMec.java Fri Sep 15 11:44:03 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 Modified: db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/lang/_Suite.java URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/lang/_Suite.java?view=diff&rev=446679&r1=446678&r2=446679 ============================================================================== --- db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/lang/_Suite.java (original) +++ db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/lang/_Suite.java Fri Sep 15 11:44:03 2006 @@ -62,6 +62,11 @@ suite.addTest(GroupByExpressionTest.suite()); suite.addTest(MathTrigFunctionsTest.suite()); suite.addTest(TimeHandlingTest.suite()); + + // This test internally sets derby.database.sqlAuthorization to true + // This property is not resettable and hence may affect other tests + // using it and sharing the same database. + suite.addTest(SQLAuthorizationPropTest.suite()); // Tests that are compiled using 1.4 target need to // be added this way, otherwise creating the suite Modified: db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/lang/functions.sql URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/lang/functions.sql?view=diff&rev=446679&r1=446678&r2=446679 ============================================================================== --- db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/lang/functions.sql (original) +++ db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/lang/functions.sql Fri Sep 15 11:44:03 2006 @@ -303,6 +303,10 @@ select cast (SYSFUN.ACOS(d) as DECIMAL(6,3)) AS SYSFUN_ACOS FROM SYSFUN_MATH_TEST; +CREATE VIEW VSMT AS SELECT SIN(d) sd, PI() pi FROM SYSFUN_MATH_TEST; +select cast (sd as DECIMAL(6,3)), cast (pi as DECIMAL(6,3)) from VSMT; +drop view VSMT; + drop table SYSFUN_MATH_TEST; drop function SYSFUN.ACOS; Modified: db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/util/SQLStateConstants.java URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/util/SQLStateConstants.java?view=diff&rev=446679&r1=446678&r2=446679 ============================================================================== --- db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/util/SQLStateConstants.java (original) +++ db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/util/SQLStateConstants.java Fri Sep 15 11:44:03 2006 @@ -343,4 +343,8 @@ //isWrapperFor returns false is passed as a parameter to the //unwrap method. public static final String UNABLE_TO_UNWRAP = "XJ128"; + + public static final String LANG_GRANT_REVOKE_WITH_LEGACY_ACCESS = "42Z60"; + public static final String SHUTDOWN_DATABASE = "08006"; + public static final String PROPERTY_UNSUPPORTED_CHANGE = "XCY02"; } Modified: db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/junit/DatabasePropertyTestSetup.java URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/junit/DatabasePropertyTestSetup.java?view=diff&rev=446679&r1=446678&r2=446679 ============================================================================== --- db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/junit/DatabasePropertyTestSetup.java (original) +++ db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/junit/DatabasePropertyTestSetup.java Fri Sep 15 11:44:03 2006 @@ -29,6 +29,8 @@ import junit.framework.Test; +import org.apache.derbyTesting.functionTests.util.SQLStateConstants; + /** * Test decorator to set a set of database properties on setUp * and restore them to the previous values on tearDown. @@ -75,15 +77,21 @@ CallableStatement setDBP = conn.prepareCall( "CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(?, NULL)"); // Clear all the system properties set by the new set - // that will not be reset by the old set. - for (Enumeration e = newValues.propertyNames(); e.hasMoreElements();) - { - String key = (String) e.nextElement(); - if (oldValues.getProperty(key) == null) - { - setDBP.setString(1, key); - setDBP.executeUpdate(); - } + // that will not be reset by the old set. Ignore any + // invalid property values. + try { + for (Enumeration e = newValues.propertyNames(); e.hasMoreElements();) + { + String key = (String) e.nextElement(); + if (oldValues.getProperty(key) == null) + { + setDBP.setString(1, key); + setDBP.executeUpdate(); + } + } + } catch (SQLException sqle) { + if(!sqle.getSQLState().equals(SQLStateConstants.PROPERTY_UNSUPPORTED_CHANGE)) + throw sqle; } // and then reset nay old values which will cause the commit. setProperties(oldValues);