GSKIT Error about node-ibm_db HOT 3 CLOSED

@tonxxd First of all, you have not read this documentation that talks about SSL connection and we have also mentioned it to check in point 2 of "For Connection Related Issues" on new issue template: https://github.com/ibmdb/node-ibm_db/blob/master/APIDocumentation.md#SSLConnection

In this documentation, we have mentioned to use SECURITY=SSL; in connection string, but I don't see you are using it.
ibm_db do not support JDBC driver keywords or any Java Key Store format certificate. It accepts certificates generated using GSKit only.
Your connection string has two issues:

1. Remove sslConnection=true; and use Security=SSL; instead.
2. Value of SSLServerCertificate keyword must be full path a certificate generated for non-Java application on Db2 Server. It normally has *.arm or *.cert or *.pem extension. ibm_db do not support jks format certificate. You need to get certificate generated using GSKit or *.kdb and *.sth files. Thanks.

from node-ibm_db.

Hi @bimalkjha thanks for the quick reply.
Sorry I actually use Security=SSL in the code, I copy pasted the snippet from the customer without changing it. I think the issue is definitely the certificate format then. I will ask them to give me the correct one.
Since I don't see mentions of the non supported formats in the documentation in GitHub maybe is something that could be added for people like me that are not db experts. Thanks!

from node-ibm_db.

Updated doc with info in latest release. Hence closing the issue now. Thanks.

from node-ibm_db.