We are facing the same problems during configuration of a DB connector in KNIME to a Denodo VDP.
We run the keytool command as suggested, but we encountered the following error:
Error: “keytool error: java.lang.Exception: Input not an X.509 certificate”
Could you please suggest how to proceed?
Another question: what does “alias” means? How do we have to set this parameter?
Thanks a lot for you help and regards,
I am not sure what other post this one was split up from, but it seems like your database has a certificate that you need to import into KNIME to enable an SSL connection. The error you are getting means that the certificate file that you are trying to import is not the correct one. X.509 is the standard for public key certificates. What file extension does your file have? The alias for the certificate is just a name by which you can easily identify it later. You can set it to anything you like, but I recommend something like “denodo”. In case you do not know that part of the documentation yet, please have a look here and especially the section
Step #5. Import the public key into JDBC clients.
Thank you very much for you reply.
The other post was an old one (2017), suggesting how to connect Knime to Denodo and giving the instructions on how to install the public key for the database into Knime JRE environment (using the command keytool -import -alias -keystore -file -storepass changeit).
Now we are trying to follow the instructions you gave to us but we are still experiencing problems.
We’ll come again as soon as we have more detail.
Just to let you know that we succeeded in connecting to denodo VDP with the help of your suggestions.
Thank you very much for your support.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.