Troubleshooting
Problem
When trying to connect Impala via SSL, error is thrown by the driver.
Symptom
[Simba][ImpalaJDBCDriver](500164) Error initialized or created
transport for authentication: Socket already connected..
Environment
Cloudera Impala JDBC driver version 2.5.32
Resolving The Problem
Solution 1:
Change JDBC url format to:
jdbc:impala://servername.domain.com:21050;AuthMech=3;SSL=1;transportMode=sasl
Solution 2:
- Downgrade the Cloudera Impala JDBC drivers to version 2.5.22: http://www.cloudera.com/downloads/connectors/impala/jdbc/2-5-22.html
JDBC url format:
jdbc:impala://servername.domain.com:21050;AuthMech=3;SSL=1;SSLKeyStore=<keystorepath>;SSLKeyStorePwd=<password>
Notes:
- Make sure no other Hive/Impala driver versions are within the same dispatcher drivers location (..c10\webapps\p2pd\WEB-INF\lib).
- Cognos only supports jdbc4 type drivers (we do not support jdbc3 or jdbc41).
[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Cognos Administration","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"10.2.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21989422