Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

How to enable SSL connection for DB2 LUW #1954

Open
SriniRaviKrishna opened this issue Aug 1, 2017 · 13 comments
Labels

Comments

@SriniRaviKrishna
Copy link

@SriniRaviKrishna SriniRaviKrishna commented Aug 1, 2017

Is there a step by step documentation of enabling SSL for db2 luw.

@serge-rider

This comment has been minimized.

Copy link
Member

@serge-rider serge-rider commented Aug 2, 2017

You can set driver property sslConnection to true.
Also you will need to configure client according to https://www.ibm.com/developerworks/data/library/techarticle/dm-0806sogalad/index.html
If you have some particular problems with SSL config - please ask.

@SriniRaviKrishna

This comment has been minimized.

Copy link
Author

@SriniRaviKrishna SriniRaviKrishna commented Aug 3, 2017

I already tried it based on IBM's documentation. Needless to say, it doesn't work. In contract it took me an hour to set up SSL based client connection for Postgres.

@serge-rider

This comment has been minimized.

Copy link
Member

@serge-rider serge-rider commented Aug 5, 2017

I'll try to setup SSL support in my DB2 Express and test this..

@leewebb

This comment has been minimized.

Copy link

@leewebb leewebb commented Sep 20, 2017

@SriniRaviKrishna Once the database is configured for SSL you need to tell DBeaver to use the SSL details. Edit Connection -> Connection settings -> Driver Properties and add the following key name/values:
Name: sslConnection Value: true
Name: sslTrustStoreLocation Value:
Name: sslTrustStorePassword Value:

@SriniRaviKrishna

This comment has been minimized.

Copy link
Author

@SriniRaviKrishna SriniRaviKrishna commented Sep 20, 2017

This was one of the first things I did and it did not work.

@tati-kru tati-kru added bug and removed question labels Jan 19, 2018
@dlsxd

This comment has been minimized.

Copy link

@dlsxd dlsxd commented Jun 29, 2018

Hello, I have the same issue, any progress on this bug?

@krawchukd

This comment has been minimized.

Copy link

@krawchukd krawchukd commented Dec 4, 2018

I've connecting through SSL with the following URL Template:

JDBC:db2://{host}{:port}}/{database}:sslConnection=true;sslTrustStoreLocation=/location/to/your/cacerts;sslTrustStorePassword=changeit;

@SriniRaviKrishna

This comment has been minimized.

Copy link
Author

@SriniRaviKrishna SriniRaviKrishna commented Dec 5, 2018

@markcbooth

This comment has been minimized.

Copy link

@markcbooth markcbooth commented Dec 15, 2018

Still doesn't work...with new European GDPR rules--need the SSL encryption--forces use of Squirrel even though I prefer DBeaver.

@markcbooth

This comment has been minimized.

Copy link

@markcbooth markcbooth commented Dec 15, 2018

What DOES work: put Host and Port in normal General DB2 Connection Settings and where it asks for Database: Put in Database name along with the ssl connection string : {database}:sslConnection=true;sslTrustStoreLocation=/location/to/your/cacerts;sslTrustStorePassword=changeit;

@dlsxd

This comment has been minimized.

Copy link

@dlsxd dlsxd commented Jan 11, 2019

Thanks guys, last comment helped! SSL begin to work if put ssl properties into database name field.

@nairrashmi90

This comment has been minimized.

Copy link

@nairrashmi90 nairrashmi90 commented Jan 14, 2019

When you say "/location/to/your/cacerts", which server are you referring to? DB2 DB is my server and application server is my client.

@markcbooth

This comment has been minimized.

Copy link

@markcbooth markcbooth commented Jan 15, 2019

This sslTrustStoreLocation would be the cacerts on your local machine

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
8 participants
You can’t perform that action at this time.