Quantcast

UDB databases using security mechanisms

classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

UDB databases using security mechanisms

Laffrey Lynne Marie (FCA)

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: [hidden email]

 

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

 

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.

 

 


------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: UDB databases using security mechanisms

Alex Malmyguine-2

Should it be a colon or semicolon before securityMechanism, or perhaps a question mark?

 

 

From: Laffrey Lynne Marie (FCA) [mailto:[hidden email]]
Sent: Thursday, February 16, 2017 2:21 PM
To: [hidden email]
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: [hidden email]

 

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

 

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.

 

 


------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: UDB databases using security mechanisms

John Hardin
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:[hidden email]]
>
> 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/
  [hidden email]    FALaholic #11174     pgpk -a [hidden email]
  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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: UDB databases using security mechanisms

Laffrey Lynne Marie (FCA)
In reply to this post by Alex Malmyguine-2

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:[hidden email]]
Sent: Thursday, February 16, 2017 3:40 PM
To: [hidden email]
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) [[hidden email]]
Sent: Thursday, February 16, 2017 2:21 PM
To: [hidden email]
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: [hidden email]

 

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

 

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.

 

 


------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Sender Auth Failure] Re: UDB databases using security mechanisms

Laffrey Lynne Marie (FCA)
In reply to this post by John Hardin
I get a syntax error with the below.

-----Original Message-----
From: John Hardin [mailto:[hidden email]]
Sent: Thursday, February 16, 2017 4:47 PM
To: Squirrel SQL users list <[hidden email]>
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:[hidden email]]
>
> 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/
  [hidden email]    FALaholic #11174     pgpk -a [hidden email]
  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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: UDB databases using security mechanisms

Alex Malmyguine-2
In reply to this post by Laffrey Lynne Marie (FCA)

John Hardin just posted a few min ago that the driver requires the closing semicolon after =13;

 

 

From: Laffrey Lynne Marie (FCA) [mailto:[hidden email]]
Sent: Thursday, February 16, 2017 5:40 PM
To: Alex Malmyguine; [hidden email]
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 [[hidden email]]
Sent: Thursday, February 16, 2017 3:40 PM
To: [hidden email]
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) [[hidden email]]
Sent: Thursday, February 16, 2017 2:21 PM
To: [hidden email]
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: [hidden email]

 

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

 

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.

 

 


------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: UDB databases using security mechanisms

Laffrey Lynne Marie (FCA)

 

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

 

From: Alex Malmyguine [mailto:[hidden email]]
Sent: Thursday, February 16, 2017 5:45 PM
To: [hidden email]
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) [[hidden email]]
Sent: Thursday, February 16, 2017 5:40 PM
To: Alex Malmyguine; [hidden email]
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 [[hidden email]]
Sent: Thursday, February 16, 2017 3:40 PM
To: [hidden email]
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) [[hidden email]]
Sent: Thursday, February 16, 2017 2:21 PM
To: [hidden email]
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: [hidden email]

 

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

 

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.

 

 


------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: UDB databases using security mechanisms

John Hardin
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:[hidden email]]
> Sent: Thursday, February 16, 2017 5:45 PM
> To: [hidden email]
> 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:[hidden email]]
> Sent: Thursday, February 16, 2017 5:40 PM
> To: Alex Malmyguine; [hidden email]<mailto:[hidden email]>
> 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:[hidden email]]
> Sent: Thursday, February 16, 2017 3:40 PM
> To: [hidden email]<mailto:[hidden email]>
> 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:[hidden email]]
> Sent: Thursday, February 16, 2017 2:21 PM
> To: [hidden email]<mailto:[hidden email]>
> 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: [hidden email]<mailto:[hidden email]>
>
> 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/
  [hidden email]    FALaholic #11174     pgpk -a [hidden email]
  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

------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Loading...