sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Garry Chen <g...@cornell.edu>
Subject Sqoop error
Date Tue, 08 Nov 2016 19:50:30 GMT
HI all,
                I am try to do a sqoop command to a ms sql server and getting SSL error. 
Please help.  The error message listed below.

Thank you very much,
Garry

> sqoop list-tables --connect "jdbc:sqlserver://MSSQL2016\AgDB:1433;" --username gc92 --P
Warning: /ec2_oth/cloudera/parcels/CDH-5.7.4-1.cdh5.7.4.p0.2/bin/../lib/sqoop/../accumulo
does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
16/11/08 14:33:31 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6-cdh5.7.4
Enter password:
16/11/08 14:33:36 INFO manager.SqlManager: Using default fetchSize of 1000
16/11/08 14:33:36 ERROR manager.CatalogQueryManager: Failed to list tables
com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection
to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Server chose SSLv3,
but that protocol version is not enabled or not supported by the client.".
ClientConnectionId:aa0b4120-10c8-472a-85e2-19492ae13e4f
        at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2399)
        at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1762)
        at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1976)
        at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1627)
        at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1458)
        at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:772)
        at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1168)
        at java.sql.DriverManager.getConnection(DriverManager.java:664)
        at java.sql.DriverManager.getConnection(DriverManager.java:247)
        at org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:904)
        at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52)
        at org.apache.sqoop.manager.CatalogQueryManager.listTables(CatalogQueryManager.java:102)
        at org.apache.sqoop.tool.ListTablesTool.run(ListTablesTool.java:49)
        at org.apache.sqoop.Sqoop.run(Sqoop.java:143)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
        at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
        at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
        at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
        at org.apache.sqoop.Sqoop.main(Sqoop.java:236)
Caused by: javax.net.ssl.SSLHandshakeException: Server chose SSLv3, but that protocol version
is not enabled or not supported by the client.


Mime
View raw message