hdbsql with ssl option enabled

[Former Member]

Hi Team,

I have enabled ssl using openssl. I can login into the studio using SSL.

hdbsql i am unable to perform it.

hdbsql -U monitoring -sslprovider openssl -sslkeystore $HOME/.ssl/key.pem -ssltruststore $HOME/.ssl/trust.pem -a -I "sample.sql"

4321: only secure connections are allowed:  SQLSTATE: HY000

hdbsql -i 01 -u SYSTEM -p ************ -sslprovider openssl -sslkeystore $HOME/.ssl/key.pem -ssltruststore $HOME/.ssl/trust.pem -a -I "sample.sql".

i am unable to connect via ssl.

hdbsql -i 01 -u SYSTEM -p ************ -sslprovider openssl -sslkeystore $HOME/.ssl/key.pem -ssltruststore $HOME/.ssl/trust.pem

Even without sql it doesnt work.

Used the below document.

How to Configure Open SSL for SAP HANA Studio t... | SCN

[Former Member · Accepted solution]

Has anyone faced this issue before?

[Former Member · Accepted solution]

Its been fixed so closing the thread.

[Sathya-08]

Hello - You should use option -e to login securely

hdbsql -e -i 01 -u SYSTEM -p ************ -sslprovider openssl -sslkeystore $HOME/.ssl/key.pem -ssltruststore $HOME/.ssl/trust.pem -a -I "sample.sql".

or

hdbsql -attemptencrypt