|
From: John H. <jh...@im...> - 2017-02-16 23:34:04
|
On Thu, 16 Feb 2017, Laffrey Lynne Marie (FCA) wrote: > With the semicolon at the end I get the following error message. > > java.util.concurrent.ExecutionException: java.lang.RuntimeException: > com.ibm.db2.jcc.am.SqlException: [jcc][1071][10615][3.67.26] Caught > java.security.InvalidAlgorithmParameterException while initializing > EncryptionManager. See attached Throwable for details. ERRORCODE=-4223, > SQLSTATE=null ...which is not a syntax error, so progress is being made. Wild guess: is your local Java runtime up-to-date? "Security Mechanism 13" might specify a recent crypto algorithm. See also: https://support.dbvis.com/support/discussions/topics/1000079566 You may need to download your Java runtime from IBM... This: http://stackoverflow.com/questions/10649009/java-security-invalidalgorithmparameterexception-while-initializing-encryptionma ...suggests that you might need some crypto initialization parameters in the JDBC connect string. I have no idea precisely how to do that, though, sorry. This has apparently been an issue for a while: https://sourceforge.net/p/squirrel-sql/bugs/998/ Here, do some digging: http://www.google.com/search?q=java.security.InvalidAlgorithmParameterException+while+initializing+EncryptionManager+db2 > From: Alex Malmyguine [mailto:ale...@bl...] > Sent: Thursday, February 16, 2017 5:45 PM > To: squ...@li... > Subject: Re: [Squirrel-sql-users] UDB databases using security mechanisms > > John Hardin just posted a few min ago that the driver requires the closing semicolon after =13; > > > From: Laffrey Lynne Marie (FCA) [mailto:lyn...@fc...] > Sent: Thursday, February 16, 2017 5:40 PM > To: Alex Malmyguine; squ...@li...<mailto:squ...@li...> > Subject: RE: UDB databases using security mechanisms > > Hi Alex, > > I have tried both a colon and a semi-colon and receive the same error. When I look up the syntax, it only stops at database with nothing after it. This driver and url works for all my other UDB databases. This new one has added security to it and I can't connect. > > Sincerely, > Lynne Marie > > From: Alex Malmyguine [mailto:ale...@bl...] > Sent: Thursday, February 16, 2017 3:40 PM > To: squ...@li...<mailto:squ...@li...> > Subject: Re: [Squirrel-sql-users] UDB databases using security mechanisms > > Should it be a colon or semicolon before securityMechanism, or perhaps a question mark? > > > From: Laffrey Lynne Marie (FCA) [mailto:lyn...@fc...] > Sent: Thursday, February 16, 2017 2:21 PM > To: squ...@li...<mailto:squ...@li...> > Subject: [Squirrel-sql-users] UDB databases using security mechanisms > > Hi, > > I need to connect to a UDB v10.5.2 AIX database using Squirrel. I'm using the IBM DB2 Universal type 4 driver. I get this error: > > java.util.concurrent.ExecutionException: java.lang.RuntimeException: com.ibm.db2.jcc.am.SqlInvalidAuthorizationSpecException: [jcc][t4][201][11237][3.67.26] Connection authorization failure occurred. Reason: Security mechanism not supported. ERRORCODE=-4214, SQLSTATE=28000 > > I was told by the DBA that I would need to use securityMechanism=13 in my JDBC command, but when I try it in squirrel, I get this error: > > java.util.concurrent.ExecutionException: java.lang.RuntimeException: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10165][10051][3.67.26] Invalid database URL syntax: jdbc:db2://151.92.117.35:60000/DAPG201L:securityMechanism=13. ERRORCODE=-4461, SQLSTATE=42815 > > How do I pass the security mechanism parameter when using Squirrel? > > Sincerely, > > [FCA_Pantone_email] > _________________________________ > > Lynne Marie Laffrey > Data Engineer > > ICT Business Analytics > 1075 West Entrance Drive > Auburn Hills, MI 48326 > CIMS: 489-03-02 > > Phone: 248-838-4895 > Email: Lyn...@fc...<mailto:Lyn...@fc...> > > Be social follow, Business Intelligence and Analytics > > [http://files.softicons.com/download/system-icons/windows-8-metro-icons-by-dakirby309/png/512x512/Office%20Apps/SharePoint.png]<https://partners.chrysler.com/sites/smbusintl/SitePages/Home.aspx> > > The information contained in the e-mail message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delibering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail, and delete the original message. > > > -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ jh...@im... FALaholic #11174 pgpk -a jh...@im... key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- USMC Rules of Gunfighting #7: In ten years nobody will remember the details of caliber, stance, or tactics. They will only remember who lived. ----------------------------------------------------------------------- 6 days until George Washington's 285th Birthday |
