Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

(1170) Unexpected response received from server

Solved Go to solution

(1170) Unexpected response received from server

New Contributor

I'm able to create a System DSN using the "ODBC Data Source Administrator" with a successfull test.

My Authentication mecanism is "User Name and Passowrd"

SASL checked

SSL Options: "Enable SSL" checked

SSL Options: I'm providing the path to a certificate

 

BUT, trying to connect using pyodbc with the same parameters (server, port, username and password) gives always the same error below whatever the auth_mechanism provided:

pyodbc.connect("DRIVER={Cloudera ODBC Driver for Impala};\
host={server_address};\
port=21051;\
SSL=1;\
auth_mechanism=GSSAPI;\
user=myusername;\
password=mypassword;\
trustedcerts=cert.pem;\
")

 

Error: ('HY000', u'[HY000] [Cloudera][DriverSupport] (1170) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct. (1170) (SQLDriverConnect); [HY000] [Cloudera][DriverSupport] (1170) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct. (1170)')

 

I'm using:

ODBC Version: 03.80
Driver Version: 2.6.0.1000
Bitness: 64-bit
Locale: fr_CA

 

OS: Windows 10 Pro

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: (1170) Unexpected response received from server

New Contributor

I finally resolved the issue by enclosing UID, PWD, and trustedcerts in braces:

UID={MY USERNAME}

PWD={MY PASSWORD}

trustedcerts={path to file}

2 REPLIES 2
Highlighted

Re: (1170) Unexpected response received from server

New Contributor

I finally resolved the issue by enclosing UID, PWD, and trustedcerts in braces:

UID={MY USERNAME}

PWD={MY PASSWORD}

trustedcerts={path to file}

Re: (1170) Unexpected response received from server

New Contributor

Hi,

I had the same error and I tried the solution you have provided.

Now it's showing a different error code saying ERROR [HY000] [CLOUDERA] [Driver Support] (1140).

Unable to load CA certificates from the location.

Could you provide a solution for this?

 

Thanks in advance.

Vinay

 

Don't have an account?
Coming from Hortonworks? Activate your account here