|
From: Laffrey L. M. (FCA) <lyn...@fc...> - 2017-02-16 22:43:38
|
I get a syntax error with the below. -----Original Message----- From: John Hardin [mailto:jh...@im...] Sent: Thursday, February 16, 2017 4:47 PM To: Squirrel SQL users list <squ...@li...> Subject: [Sender Auth Failure] Re: [Squirrel-sql-users] UDB databases using security mechanisms On Thu, 16 Feb 2017, Alex Malmyguine wrote: > Should it be a colon or semicolon before securityMechanism, or perhaps a question mark? It looks like it needs to end with a semicolon: http://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/com.ibm.db2.luw.apdv.java.doc/src/tpc/imjcc_r0052342.html try jdbc:db2://151.92.117.35:60000/DAPG201L:securityMechanism=13; > From: Laffrey Lynne Marie (FCA) [mailto:lyn...@fc...] > > 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? -- 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 ----------------------------------------------------------------------- If asking Hillary to disarm is a call for her assassination, then asking the American people to disarm is calling for their genocide. -- Jeff Ingebritson ----------------------------------------------------------------------- 6 days until George Washington's 285th Birthday ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
