HANA Express Edition by CAL runniing on AWS – XSA Apps not reachable from browser

[christian_swonke]

Hi all,

I have deployed a HANA Express edition by CAL (newest available version). This step was working without any problems.

I have assigned a static IP to the solution.

Now I want to reconfigure the solution to access it by assigned hostname from AWS.

Therefore I followed this blog from denys.kempen.

Running SAP HANA Express in CAL – by the SAP HANA Academy

The problem is that it is not working...

I found some differences - but I don't know if these are responsible for the isses:

1.) the host file in the video tutorial looks a litte bit different like the one avaialble at my solution

#host file entries for # added by a service of the CAL Appliance Agent

10.0.13.114 vhcalhxedb.dummy.nodomain vhcalhxedb # added by a service of the CAL Appliance Agent
#end of host file entries for # added by a service of the CAL Appliance Agent

The host file inside the video has also real host name after vhcalhxedb

2.) XS API can not be changed

My host name is sid-hxe. If I execute xa API I am receiving https://vhcalhxedb:39030 as API endpoint in stead of https://sid-hxe:39030 like described in the video.

If I try to registier https://vhcalhxedb.dummy.nodomain:39030 I get the error message like in the video. But later on if I add –cacert /hana/shared/HXE/xs/controller_data/controller/ssl-pub/router/default.root.crt.pem I still get the error message.

So it is not working…

I found also this blog:

HANA Express and XS Advanced: When you cannot modify the hosts file… from lsubatin.

I was able to update passwords for HXE_ADMIN and HXE_DEV, also I cound change API to https://localhost:39030.

But the renaming of HXE system itself does not working well...

To be honest: I am not sure if I am doing everthing right. At the end I have just to set pluic IP as solution name?

As third step I tried this solution (but of course it sounds more like a workaround):

Setup SAP HANA, express edition, in Amazon Web Services or Microsoft Azure using SAP Cloud Appliance...

If I try to reach i.e. http://vhcalhxedb:8090 with my local client it is working. But i.e. If I try to start WEB IDE it is not working. It seems that is switching between different hostnames...

Can anyone explain me how I have to configure HXE solution to get all apps working and accessable from outside (each client without modifiying local host files).

Regards

Christian

[dvankempen]

For those interested, we have published two new video tutorials about running SAP HANA, express edition in the SAP Cloud Appliance Library, see

• Running SAP HANA, express edition in the SAP Cloud Appliance Library – by the SAP HANA Academy
  

[lsubatin]

Hi christian.swonke

Yes, the name of the host at OS level is irrelevant. In short, you do not need to modify anything in the CAL instance unless you want to perform a rename for some other reason. You could technically access it without entering the operating system at all.

If you just want to access Web IDE, map the hosts file in your local laptop to vhcalhxedb and external IP address as explained here in step 3: https://developers.sap.com/tutorials/hxe-setup-aws-azure.html

No need to rename the system or SID or anything if you can modify the hosts file in your laptop and are OK with that. Also revert any changes in xs controller.ini as that rename seems to not have worked.

Also, "localhost" will NOT work. If you choose to rename, you can use either a DNS or an external IP address. It needs to be something you can access from your laptop.

Best,

Lucia.

[dvankempen]

Hi Christian,

The blog is from 2016 (SAP HANA 1.0 SPS 12). Current release is SAP HANA 2.0 SPS 03. There are some user interface changes both on the side of the Cloud Appliance Library (CAL) and SAP HANA, express edition.

I have posted an update to the video(s) and blog, see

• Running SAP HANA, express edition in the SAP Cloud Appliance Library – by the SAP HANA Academy

[christian_swonke]

Hi Lucia, thanks for your reply.

I think currently I have mixed something...

- my host name is (sid-hxe)

- If I execute xs apps the urls look like https://vhcalhxedb:.

- I changed the API to https://localhost:39030

- Nevertless the parameter "default_domain" contains the externl host name of AWS server (like desribed in first block)

So I understood you in the right way I have to set API to localhost (like I already did) and rename whole HXE to extern IP? Is this correct?

Later on if I execute XS apps I should see something like https://<external ip>:<port>

Can I ignore host name (sid-hexe) at all?

Regards

Christian

[lsubatin]

> "I was able to update passwords for HXE_ADMIN and HXE_DEV, also I cound change API to https://localhost:39030.";

So you renamed your XSA domain name to "localhost"? Or to an external IP or something you can access without mapping the hosts file?

It is either step 3 in https://developers.sap.com/tutorials/hxe-setup-aws-azure.html with hostname vhcalhxedb (not whatever the hosts file says in AWS) or the rename in my blog post using something you can access externally (definitely not localhost).

What name is xs apps showing from Web IDE?