Connect to SQL Console and Database Explorer error: 'Cannot create SSL context'

former_member197516 — Fri, 06 Jul 2018 17:21:29 GMT

Using VMWare HANA Express.

When going from HANA Cockpit to SQL Console ....

Screen comes up but when the screen accesses HANA SYSTEM and Tenant databases I get the following error:

SQL Error: Connection failed (RTE:[300010] Cannot create SSL context: Error in api.SSL_CTX_set_default_pse_by_name - SSL error [4129]: Unknown error, General error: 0x00001021 | SAPCRYPTOLIB | SSL_CTX_set_default_pse_by_name SAPCRYPTO API error

The PSE file does not....<EOM>

I believe the ‘end of this message’ is ‘does not exit’ as it is truncated.

From the hxehost instance I see the following and it looks like I have the necessary pse files:

hxeadm@hxehost:/usr/sap/HXE/HDB90> xs domains

Getting domains...

name type org

--------------------------------

hxehost shared (default)

hxeadm@hxehost:/usr/sap/HXE/HDB90> sudo -s

hxehost:/hana/shared/HXE/HDB90 # find / -name *.pse

/usr/sap/hostctrl/exe/sec/SAPSSLS.pse

/hana/shared/HXE/HDB90/hxehost/sec/sap_system_pki_instance.pse

/hana/shared/HXE/HDB90/hxehost/sec/SAPSSLS.pse

/hana/shared/HXE/HDB90/hxehost/sec/SAPSSLC.pse

/hana/shared/HXE/HDB90/hxehost/sec/SAPSSLA.pse

/hana/shared/HXE/HDB90/hxehost/sec/saplogon.pse

/hana/shared/HXE/HDB90/hxehost/sec/sapsrv.pse

/hana/shared/HXE/xs/controller_data/controller/router/webdispatcher/sec/default.pse

/hana/shared/HXE/xs/controller_data/controller/router/webdispatcher/sec/internal_root.pse

hxehost:/hana/shared/HXE/HDB90 # find / -name sapgenpse

/usr/sap/hostctrl/exe/sapgenpse

/hana/shared/HXE/global/hdb/saphostagent_setup/sapgenpse

/hana/shared/HXE/exe/linuxx86_64/HDB_2.00.030.00.1522210459_bb2ff6b25b8eab5ab382c170a43dc95ae6ce298f/sapgenpse

hxehost:/hana/shared/HXE/HDB90 # cd /hana/shared/HXE/HDB90/hxehost/sec

hxehost:/hana/shared/HXE/HDB90/hxehost/sec # ll

total 28

-rw------- 1 hxeadm sapsys 1787 Apr 4 12:25 SAPSSLA.pse

-rw------- 1 hxeadm sapsys 1895 Apr 4 12:25 SAPSSLC.pse

-rw------- 1 hxeadm sapsys 1880 Apr 4 12:25 SAPSSLS.pse

-rw------- 1 hxeadm sapsys 3540 Apr 4 12:23 sap_system_pki_instance.p12

-rw------- 1 hxeadm sapsys 2231 Apr 4 12:23 sap_system_pki_instance.pse

-rw------- 1 hxeadm sapsys 1798 Apr 4 12:25 saplogon.pse

-rw------- 1 hxeadm sapsys 1979 Apr 4 12:25 sapsrv.pse

Interesting to note that the config files reference another pse file “sapsrv_internal” which I do not have (as seen in DBA Cockpit global.ini file.

Appreciate any help out there as I am at a standstill. Everything is working except for this.

JWJ

Re: Connect to SQL Console and Database Explorer error: 'Cannot create SSL context'

Vitaliy-R — Thu, 19 Jul 2018 18:38:31 GMT

Could not replicate in my HXE, but may be you should try to upgrade your version? The new HXE 2.0 Rev 31 just became available.

Re: Connect to SQL Console and Database Explorer error: 'Cannot create SSL context'

Former Member — Sat, 11 Aug 2018 01:41:08 GMT

Yeah, I found this too. After tracing the HANA Tools app (xs logs hrtt-service) I still got no further.

However, if you're simply trying to establish a Database Explorer session to issue SQL commands then the following worked for me:

Select the "+" icon (i.e. Add a database to the Database Explorer)
Select "SAP HANA Database (Multitenant)" from the Database Type drop-down list
Supply the following

Host: hxehost
Instance: 90
Database: Tenant Database Name: HXE
User: SYSTEM
Password: Your password (the one you specified for all users on the platform)

That got me in. HTH

Question Re: Connect to SQL Console and Database Explorer error: 'Cannot create SSL context' in Technology Q&A

Connect to SQL Console and Database Explorer error: 'Cannot create SSL context'

Re: Connect to SQL Console and Database Explorer error: 'Cannot create SSL context'

Re: Connect to SQL Console and Database Explorer error: 'Cannot create SSL context'