SSL=0 still try to verify SSL cert about sqlalchemy_dremio HOT 3 CLOSED

@jinyangzhen I also found this issue. So I checked out the db.py file from sqlalchemy_dremio (which is downloaded by pip). I noticed that they are using grpc+tls in the library.

client = flight.FlightClient('grpc+tls://{0}:{1}'.format(properties['HOST'], properties['PORT']))

However, when I checked out their code in master branch d41b873, I see they are using grpc+tcp

client = flight.FlightClient('grpc+tcp://{0}:{1}'.format(properties['HOST'], properties['PORT']))

It is really strange.

cc @narendrans

from sqlalchemy_dremio.

From the code, it looks like SSL parameter hasn't been taken effect. It needs to be improved to honor this parameter in order to fully fix this issue.

from sqlalchemy_dremio.

Fixed in #29. The parameter is UseEncryption and defaults to true.
Note that you should use a '?' to after the schema instead of ';'. And use '&' to separate key-value pairs after the ?

from sqlalchemy_dremio.