Created on 01-23-2020 10:59 AM - last edited on 01-23-2020 12:28 PM by ask_bill_brooks
For secure data transfer using sqoop planning to use SSL but sqoop import command has issues.
This is my sqoop config file:
When running my sqoop job i get the following error:
Exception java.io.FileNotFoundException: Error opening socket to server xxxx/xxxx on port xxxx with message: /tmp/truststore.jks (No such file or directory). ERRORCODE=-4499, SQLSTATE=08001
Copied the jks file to /tmp ( hdfs ) location but doesnt solve the issue
Created 01-24-2020 07:01 AM
Do you have the truststore distributed on all cluster worker nodes? Keep in mind that Sqoop will run as a M/R job.
Created 01-24-2020 07:55 AM
Hi @mridley Thanks for getting back.
Yes i have tried placing the trustore.jks file in hdfs location but still fails with same error.
Below the connection string:
Created 01-27-2020 12:15 PM
does sqoop 1.4.6 support ssl? Could you please point me to any cloudera docs. I have 2.6.4 hdp cluster.
Are there any config changes that has to be made in sqoop config file?
Created 04-14-2020 06:36 AM
did you find the solution for the above issue, am also facing the similar issue. i need to pass certs as connection string, it is saying file not found exception.
Created 04-15-2020 06:10 AM
Yes the following solution worked...
Created a jdbcprops file & it had the following entries
Sqoop string is :
sqoop import -files truststore.jks --connect jdbc:db2://xxxxx:xxxx/xxxx --username abcd --password xxxxx --connection-param-file jdbcprops --query 'select * from table1 where $CONDITIONS fetch first 2 rows only' --target-dir /user/abcd -m 1 –verbose
Created 04-15-2020 06:12 AM
Thanks we did the same and worked.
Created 10-01-2020 02:22 AM
Can you please tell where you placed jdbcprops file? local or hdfs.
same for truststore.jks file.