Does sqoop 1 4 6 version on HDP 2 6 4 support SSL

+1 vote
Hi Team,

We have an audit requirement to enable ssl in our sqoop jobs. Our source which DB2 has enabled ssl, and when trying to connect to the DB fails with below error:

"Error executing statement: com.ibm.db2.jcc.am.DisconnectNonTransientException: [jcc][t4][2034][11148][3.68.61] Execution failed due to a distribution protocol error that caused deallocation of the conversation.
A DRDA Data Stream Syntax Error was detected.  Reason: 0x3. ERRORCODE=-4499, SQLSTATE=58009"

Have performed the following actions:

added the certification to keystore file and generated a .jks file

sqoop config file has the following entries:

jdbc:db2://xxxxx.xxx:60542/abcd:sslconnection=true;ssltrustStoreLocation=/tmp/truststore.jks;ssltruststorePassword=xxxx;

I have also tried adding the jks file to hdfs location but fails with "file not found exception"

Are there any config changes that needs to be made sqoop properties file?

Is there is a documentation on how ssl is implemented for sqoop 1.4.6

Thanks for the the input!!!!
Jan 29, 2020 in Big Data Hadoop by sudi
• 130 points
1,280 views

1 answer to this question.

0 votes
Hi,

Is your "JDBC location" string connect?  If not, then you must specify a string connect because that describe how to connect to database.
answered Jan 29, 2020 by Roshan

Related Questions In Big Data Hadoop

0 votes
1 answer

How to upgrade Apache Hadoop from 2.4.1 to 2.6.0?

If the downtime is not an issue, ...READ MORE

answered Sep 7, 2018 in Big Data Hadoop by Frankie
• 9,830 points
630 views
0 votes
1 answer

How to Upgrade Apache Hadoop from 2.4.1 to 2.6.0

If the downtime is not an issue, ...READ MORE

answered Nov 30, 2018 in Big Data Hadoop by Frankie
• 9,830 points
1,567 views
0 votes
1 answer

Could not find the Sqoop directory in HDP 2.2

You can find the Sqoop lib directory ...READ MORE

answered May 4, 2018 in Big Data Hadoop by Shubham
• 13,490 points
1,483 views
0 votes
1 answer

I want to install snappy on Hadoop 1.2.1. How do I do that?

As per Cloudera, if you install hadoop ...READ MORE

answered Dec 11, 2018 in Big Data Hadoop by Frankie
• 9,830 points
1,059 views
+1 vote
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 11,380 points
11,015 views
0 votes
1 answer

hadoop.mapred vs hadoop.mapreduce?

org.apache.hadoop.mapred is the Old API  org.apache.hadoop.mapreduce is the ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 11,380 points
2,528 views
+2 votes
11 answers

hadoop fs -put command?

Hi, You can create one directory in HDFS ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by nitinrawat895
• 11,380 points
108,739 views
–1 vote
1 answer

Hadoop dfs -ls command?

In your case there is no difference ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by kurt_cobain
• 9,350 points
4,605 views
0 votes
1 answer

How to decrease load on HBase while importing Sqoop?

Sqoop by default serializes all the input ...READ MORE

answered May 16, 2019 in Big Data Hadoop by Yogi
887 views
0 votes
1 answer

Unable to run Name node and datanode on Single Node cluster: Does not contain a valid host:port

Add the following properties in the core-site.xml file, it ...READ MORE

answered May 22, 2019 in Big Data Hadoop by Sanam
1,324 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP