之前在處理PHP連接到ODBC問題,解決到一半的時候遇到了SSL的問題
我將部份的設定改過之後跳出了這個錯誤訊息
(1110) unexpected response received from server. please ensure the server host and port specified for the connection are correct and confirm if ssl should be enabled for the connection
所以我開始想辦法解決SSL的問題
我參考了這個網站並按照底下的回覆自己嘗試簽了憑證出來
然後我改了設定檔(odbc.ini)
這是目前的設定
[ODBC]
#InstallDir=/opt/odbc/unixodbc/lib
# Specify any global ODBC configuration here such as ODBC tracing.
[ODBC Data Sources]
Hortonworks Hive 64-bit=Hortonworks Hive ODBC Driver 64-bit
[Hive_odbc_64]
Description=Hortonworks Hive ODBC Driver (64-bit) DSN
Driver=/usr/lib/hive/lib/native/Linux-amd64-64/libhortonworkshiveodbc64.so
HOST=ha