Reply
New Contributor
Posts: 7
Registered: ‎04-15-2017

Unable to create Sqoop Connection Link in Hue

[ Edited ]

Hello People,

 

I am unable to create Sqoop Connection Link in Hue. The error that i get when i hit on Save button is: "Can't connect to the database with given credentials: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server."

Since I am using the default Cloudera Quickstart VM 5.8 mysql login credentials this is not an issue related to credentials. Kindly let me know where i have gone wrong.. Attached is the screenshot of the error i get:SqoopConnectorLinkSqoopConnectorLink

Posts: 388
Topics: 11
Kudos: 60
Solutions: 34
Registered: ‎09-02-2016

Re: Unable to create Sqoop Connection Link in Hue

@ClouderaMQVM

 

Make sure you have mysql-connector-java.jar

 

By default it is available under /usr/share/java

New Contributor
Posts: 7
Registered: ‎04-15-2017

Re: Unable to create Sqoop Connection Link in Hue

I have the connector mysql-connector-java.jar in the default path /usr/share/java as seen in the attached screenshot. I have even set the permissions to 777 but still face the same error. Could version be an issue here? SqoopConnectorLink_ClouderaQVM.PNG

 

 

Posts: 388
Topics: 11
Kudos: 60
Solutions: 34
Registered: ‎09-02-2016

Re: Unable to create Sqoop Connection Link in Hue

@ClouderaMQVM

 

Might be... I am not sure about the suitable version for your environment

 

If you are planning to get another version of mysql-connector then 

1. Do not remove/delete the old version of mysql-connector

2. Downaload the new version of mysql-connector, Unzip/untar, move it to /usr/share/java

3. Delete only the link referring to the old version and Create a new link referring to the new version

4. Restart the hive service via CM

 

For more details

http://www.cloudera.com/documentation/enterprise/5-7-x/topics/cm_ig_mysql.html

New Contributor
Posts: 7
Registered: ‎04-15-2017

Re: Unable to create Sqoop Connection Link in Hue

Thanks a lot for the above steps, i really was wondering how i should install different version of connector.. I'll soon follow the steps and inform the results. :)
Announcements