Example for secure encrypted connection

[MrJack91]

Hi there

Currently I'm not able to connect encrypted: hana://user:[email protected]:1234/?encrypt=true&validateCertificate=false

What do I have to do? Maybe you could add an example. (also to make sure, really use an encrypted connection).

Best Michael

[MrJack91]

Aha. Got it!

use:

encrypt=true&sslValidateCertificate=false

(The jdbc property is not working here: validateCertificate)

I still have some problems with the certificate (on client on Microsoft) if i wanna user the validation with the certification. Using the following props (and yes, i removed sslValidateCertificate=false):

, sslCryptoProvider='openssl'
, sslTrustStore='<home>/.ssl/xxx.pem'

hdbcli.dbapi.Error: (-10709, 'Connection failed (RTE:[1000013] wrong provider for this platform (server.com:1234))')

[kasium]

This looks like a HANA/hdbli problem and not related to sqlalchemy-hana. Please post your question e.g. on stackoverflow or open an issue on the SAP support portal