Khaleel2408
Technical User
I am trying to connect DB2 database servers over secure port using SSL from system ODBC DSN client machine. But I am getting below error
Error: SQL30081N A communication error has been detected. Communication protocol
being used: "SSL". Communication API being used: "SOCKETS". Location where
the error was detected: "". Communication function detecting the error:
"sqlccSSLSocketSetup". Protocol specific error code(s): "420", "*", "*".
SQLSTATE=08001
Could you please help me in this situation to fix the issue.
The steps I have done:
1) Created Keystore .kdb file along with stash file .sth file.
2) Added the certificate to Keystore and it is having below 3 certificates inside of it.
Root cert
Intermediate certificate
personal certificate
3) ODBC configurations - please refer the attachment for settings used
4) db2cli.ini file parameters:
[TEST]
Security=SSL
Port=0000
Database=test
Hostname=0.0.0.0
PWD=xxxxx
UID=xxxx
5) db2dsdriver.cgf parameters:
<?xml version="1.0" encoding="UTF-8" standalone="no" ?>
<configuration>
<databases>
<database host="0.0.0.0" name="TEST" port="0000">
<parameter name="SecurityTransportMode" value="SSL"/>
<parameter name="SSLClientKeyStoredb" value="fullpath\test.kdb"/>
<parameter name="SSLClientKeystash" value="fullpath\test.sth"/>
</database>
</databases>
<dsncollection>
<dsn alias="testalias" host="0.0.0.0" name="TEST" port="0000"/>
</dsncollection>
</configuration>
Error: SQL30081N A communication error has been detected. Communication protocol
being used: "SSL". Communication API being used: "SOCKETS". Location where
the error was detected: "". Communication function detecting the error:
"sqlccSSLSocketSetup". Protocol specific error code(s): "420", "*", "*".
SQLSTATE=08001
Could you please help me in this situation to fix the issue.
The steps I have done:
1) Created Keystore .kdb file along with stash file .sth file.
2) Added the certificate to Keystore and it is having below 3 certificates inside of it.
Root cert
Intermediate certificate
personal certificate
3) ODBC configurations - please refer the attachment for settings used
4) db2cli.ini file parameters:
[TEST]
Security=SSL
Port=0000
Database=test
Hostname=0.0.0.0
PWD=xxxxx
UID=xxxx
5) db2dsdriver.cgf parameters:
<?xml version="1.0" encoding="UTF-8" standalone="no" ?>
<configuration>
<databases>
<database host="0.0.0.0" name="TEST" port="0000">
<parameter name="SecurityTransportMode" value="SSL"/>
<parameter name="SSLClientKeyStoredb" value="fullpath\test.kdb"/>
<parameter name="SSLClientKeystash" value="fullpath\test.sth"/>
</database>
</databases>
<dsncollection>
<dsn alias="testalias" host="0.0.0.0" name="TEST" port="0000"/>
</dsncollection>
</configuration>