之前在處理PHP連接到ODBC問題,解決到一半的時候遇到了SSL的問題

(之前的發問)
https://ithelp.ithome.com.tw/questions/10196020

我將部份的設定改過之後跳出了這個錯誤訊息

(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的問題

我參考了這個網站並按照底下的回覆自己嘗試簽了憑證出來

https://community.cloudera.com/t5/Support-Questions/Unable-to-connect-with-beeline-after-enabling-HiveServer2/td-p/213320

然後我改了設定檔(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=hadoop.namenode:2181,hadoop.snamenode:2181,hadoop.datanode4:2181
PORT=10000
Schema=default
ServiceDiscoveryMode=1
ZKNamespace=hiveserver2
HiveServerType=2
AuthMech=0
ThriftTransport=1
UseNativeQuery=0
UID=hdfs
KrbHostFQDN=_HOST
KrbServiceName=hive
KrbRealm=
SSL=1
AllowSelfSignedServerCert=1
TwoWaySSL=0
ClientCert=/opt/ssl_jks/client.truststore.jks
ClientPrivateKey=
ClientPrivateKeyPassword='SuBaLaSiMas1'

然後得到這個錯誤

PHP Warning:  odbc_connect(): SQL error: [unixODBC][Hortonworks][DriverSupport] (1160) Cannot enable SSL for the connection when connecting to a server that has not enabled SSL. If the server has SSL enabled, please check if it has been configured to use a SSL protocol version that is lower than what is allowed for the connection. The minimum SSL protocol version allowed for the connection is: TLS 1.2., SQL state S1000 in SQLConnect in /var/www/html/hive_odbc_test/hive_odbc_test1.php on line 47

我看到許多人用beeline去測試ssl有沒有通,所以我也試了一下

結果是handshake_failure

有大神知道我是odbc.ini設定錯誤還是ssl憑證沒有設定好嗎？