|
From: Ferreira, M. <Mat...@fi...> - 2020-05-18 23:17:03
|
The URL on your connection should be something like: jdbc:db2:// devcent1-provi:50000/<SCHEMA>:securityMechanism=11; For the security mechanism values – I found a software help doc that lists them out. I’m sure IBM has a helpdoc on this – but this seemed more user friendly 😊 : https://querysurge.zendesk.com/hc/en-us/articles/206083403-Configuring-Connections-IBM-DB2-With-Security-Mechanism Based on the error – it appears that your DB2 server isn’t configured for the security mechanism you attempted. By default , I believe, It uses 3 (Cleartext Username/Password). If you add the securityMechanism parameter to your URL that **SHOULD** work. I will of course defer to Gerd From: Hunor Olosz <hun...@hu...> Sent: Monday, May 18, 2020 10:40 AM To: Gerd Wagner <ger...@t-...> Cc: Squ...@li... Subject: EXTERNAL: Re: [Squirrel-sql-users] SQuirreL SQL - DB2 - Kerberos Hello Gerd, I hope this is what you need. We use db2jcc driver. Connection with local user is fine, but with Ldap user using Kerberos authentication needs extra setup. (See attached file: image (2).png)(See attached file: SQLAliases23.txt)(See attached file: error)(See attached file: SQLDrivers) Thank you. Kind Regards / Mit freundlichen Grüßen, Hunor Olosz [Inactive hide details for Gerd Wagner ---16/05/2020 22:52:02---If you could send the code how the create a java.sql.Connection]Gerd Wagner ---16/05/2020 22:52:02---If you could send the code how the create a java.sql.Connection for DB2 with Kerberos I may be able From: Gerd Wagner <ger...@t-...<mailto:ger...@t-...>> To: Hunor Olosz <hun...@hu...<mailto:hun...@hu...>>, Squ...@li...<mailto:Squ...@li...> Date: 16/05/2020 22:52 Subject: [EXTERNAL] Re: [Squirrel-sql-users] SQuirreL SQL - DB2 - Kerberos ________________________________ If you could send the code how the create a java.sql.Connection for DB2 with Kerberos I may be able to help you. Gerd Am 14.05.20 um 16:51 schrieb Hunor Olosz: > Hello, > > I'm looking for a documentation how to configure Squirrel SQL Client > with DB2 which uses Kerberos Authentication method. > > Thank you. > Kind Regards / Mit freundlichen Grüßen, > > *Hunor Olosz* > > > > > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li...<mailto:Squ...@li...> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.sourceforge.net%2Flists%2Flistinfo%2Fsquirrel-sql-users&data=02%7C01%7CMatt.Ferreira%40fisglobal.com%7Cee1f6c6c528d47235a5908d7fb63eeb1%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C0%7C637254278939509054&sdata=f956lqkQVjKPgj3RQvpkTFoZzwSTZnFUz69XHBzpWTc%3D&reserved=0> > The information contained in this message is proprietary and/or confidential. If you are not the intended recipient, please: (i) delete the message and all copies; (ii) do not disclose, distribute or use the message in any manner; and (iii) notify the sender immediately. In addition, please be aware that any message addressed to our domain is subject to archiving and review by persons other than the intended recipient. Thank you. |
