DB Explorer not functioning properly when server is in hostnames routing mode.

I have an XS-A server that’s running in hostnames mode.  I have a legit(paid) SSL cert installed on it and things seems to be working except the DB Explorer.

When entering the DB Explorer, I get a message about the server not being able to connect to the socket.  Sorry wording is wrong, I can’t seem to catch it before it is gone.

Anyway, when exploring a table structure, it shows the field definitions, but hangs the Web-IDE (4.0.21) when clicking the “Open Data” button.  It hangs the whole IDE and I have to completely reload it in the browser to get back to functional.

I’ve seen this before and was able to remedy it with the following.

xs set-env hrtt-service WEBSOCKET_ORIGIN ‘[ “xsadv.sfphcp.com” ]’

However, this isn’t working this time and seems the only really difference is the hostnames routing mode.

The solution is use a wildcard(*) in the WEBSOCKET_ORIGIN.

xs set-env hrtt-service WEBSOCKET_ORIGIN ‘[ “*xsadv.sfphcp.com” ]’

Please see the following for details.

https://jam4.sapjam.com/wiki/show/FAKp56gZGFRgZ1aVwaUYpw

Or in the docs

http://help.sap.com/hana/SAP_HANA_Security_Guide_en.pdf

16.1 Securing the SAP HANA Database Explorer

Hope this post helps others find the solution more quickly.

-Andrew