SAP HANA express edition - OVA installed - test XS, Web IDE

[former_member321894]

Hi,

I'm going through the guide http://go.sap.com/developer/tutorials/hxe-ua-getting-started-vm.html
I am at chapter "Test XSC, XSA and Web IDE" (little side note: for the IPv4 address I had to change VM Player to use NAT and now the ip address is 192.168.182.xxx).
In this chapter, the first step says exactly following: 1. Check that the XSEngine is running. From your VM desktop, open a browser and enter: http://<ip address of VM>:8000
I'm already confused when it says"From your VM desktop": what does that mean? My laptop's normal Windows where the VM player is installed which is connected to my express HANA server? Or is there a way to get to a desktop inside the VM player? Very unclear stated and I'm afraid I'm new to installations and client server things.

Secondly, I cannot run the URL given, if I run it just on a browser on my laptop (does it matter which browser?). I tried Google Chrome and IE. I get "Site cannot be reached".

On my laptop, I changed to host file to contain following line:
192.168.182.xxx hxehost
(xxx of course being the correct numbers)

On my laptop, if I ping hxehost in the command prompt it does not work.

So I don't know how to continue with this step and any help is appreciated.

Some info: yes I did download & install Server plus applications.

[former_member321894]

Hi again,

I couldn't do it with your commands but I used sudo bash and sudo vim instead. See screenshot:

[dvankempen]

Hi Melanie,

It is certainly possible that the Windows firewall on your host PC is blocking access to the linux guest on the VM.

I would suggest to request support to add an exception to the Firewall for the VMware player.

See http://superuser.com/questions/1005012/vmware-player-and-windows-7-firewall

Apparently, the following to executables in the Windows System directory are required as well:

C:\Windows\SysWOW64\vmnat.exe
C:\Windows\SysWOW64\vmnetdhcp.exe

Let us know if this works.

Best regards,
Denys

[former_member321894]

I managed to login now to XSA by using a tip in openSAP course (using --skip-ssl-validation command). When I run command xs apps as stated in the guide, I do get the apps and the web ide is one of them and everything seems good.

I believe this means my installation is correct, however I still cannot connect to any of the URL via my browser. Is there anything I need to check with my support regarding firewall blocks etc (I cannot change my Windows Firewall myself)?

BR,

Melanie

[dvankempen]

Hi Melanie,

You mention:

On my laptop, if I ping hxehost in the command prompt it does not work.

We need to fix this first.

As mentioned in the documentation, with command (sudo) ifconfig you can request the IP of the VM.

Can you ping this IP?

Does the web server responds when you enter http://<IP>:8000 ?

FYI : On the SAP HANA Academy YouTube channel we have created a playlist with HXE videos: bit.ly/2dZS2Fv

There are a couple of videos about networking, for example, how to connect Terminal (or PuTTY) to the VM, or how to configure a static IP:https://www.youtube.com/watch?v=EiilRNudJ8E

Whether the VM is configured for Bridged (default), NAT of host-only, the IP is provided by a (virtual) DHCP service. As a result, the IP will change if the IP of the host computer changes, for example when you change networks (home, office). Maybe the IP defined in the hosts file no longer corresponds to the IP of the VM.

[Former Member]

Thank you for this tip!

[craigcmehil]

Provided your VM and your laptop are on the same network, you should be able to put into your browser (Chrome is preferred but in this case it does not matter which browser) the http://<IP address of your running VM>:8000 and you will get the result back

If you are not getting that response back the most likely problem is one of 2 things.

1) Your server is not actually fully started (type HDB info on the VM command prompt) if you don't see all that then type HDB start

2) You have a firewall blocking it, you can fix that in the firewall or try the following command in the command prompt on your VM which tells the VM to take any traffic on port 80 and redirect it to port 8000

iptables -t nat -A PREROUTING -p tcp --dport 80 -j REDIRECT --to-ports 8000

[johannesj]

HI Melanie,

try to use this URL: https://hexhost:39030 for the API_URL, that worked for me...

But on the other side, I could ping my VM and access the xs engine even without an api url.

Cheers

Johannes

[former_member321894]

Hi all,

I cannot shut down the firewall and besides, we are not using windows firewall but an extra program.

So nothing here helps me and I put this on ice. No HANA express for me - but please, don't call it "easy and for everyone". It's been one of my biggest hassles and knowing stuff about firewall and ports and so on does not go into the beginner category. I only started this because everyone always said "it's easy, you can get HANA with a few steps"... cost me hours and hours and I end up with nothing.

//Melanie

[former_member192470]

Hi,

is the problem solved in meanwhile?

as I'm facing the same problem, I opend a new topic under

https://answers.sap.com/questions/359943/sap-hana-express-20-sps02-vm-xs-login-issue.html

Kind regards
Rouzbeh

[Lemar]

Had the same problem under Windows 10.

1. First one need to resolve the hostname hxehost to the VMs IP in the host file.
2. Second the firewall needed to be shut down for home network.

WebIDE is working

Thx for the hint with the firewall !

[dvankempen]

Hi Melanie,

I responded to your message some time ago but it seems that my message never reached this post.

Sounds to me that the Windows firewall is blocking access to the VM.

If you cannot disable it for testing I would check with IT first.

If disabling the firewall solves the connectivity (ping test and browser test), then Windows Firewall needs to be configured for VMware (ports and executables).

Works?

[former_member321894]

Hi,

Well funny that it worked at some time, then didn't. And I did that step already and still, can't do xs login anymore:

I'm still nowhere. Prolly gonna just uninstall as this is wasting my time, more than it helps me. And funny enough, not one seems to be able to help...

BR,

Melanie

[amneis]

Can you post a picture of what's currently in your hosts file?

go to directory /etc

and then display the hosts file.

> cat hosts

[former_member321894]

Hi Denys,

Everything as in your suggested comment has been added to my windows firewall on my laptop. I'm still not able to either ping my VM from my laptop nor access it via my browser.

Furthermore I noticed that "xs login" again does not work - I do not know why it worked the other day but no matter how many times I try now, it won't work. This is what I get:

It seems to the VM is the problem - but what do I know about these things, I never used a VM in my life before. But seems as if the VM is blocking my laptop from accessing it, not the other way round. I tried at home in my own private WiFi and at work (however it's the same laptop, meaning a work laptop) and neither works.

This HANA express was supposed to be super easy and for beginners... I clearly fail to see, how. It's taken hours and hours of my time and I'm nowhere. So yes I'm sorry, I'm really frustrated.

Oh and by the way; I tried "Bridgeted" recently and managed to get a IPv4 IP but other than that, it was no better so I went back to NAT. But yeah, as said, I'm still nowhere.

Any help/tip is appreciated. Or should I just give up?

BR,

Melanie

[amneis]

Hi Melanie,

At that point in the instruction, you still need to use your VM IP address not the VM hostname (hxehost).

You need to change the /etc/hosts file in the VM. (This is indicated at the later part of the instruction set).

sudo sh -c 'echo <Type your VM IP Address> $(hostname -f) >> /etc/hosts'

[former_member321894]

Hi Denys and thanks,

Thanks for the tips about the IPs changing. So far I only tried to use the VM when I'm at work in my office (same office) and I do keep checking the ifconfig command, just to get the IP and every time so far, I got the same IP, as in my screenshots in my above posts.

To your questions: Can you ping this IP? - No I cannot; I cannot ping hxehost or the ip directly.

Does the web server responds when you enter http://<IP>:8000 ? - No it does not, please refer to my above screenshot at "Oct 25 at 08:03 AM"

I retried one of the commands I was suggested in an earlier post and got an error - does this help, to help me?

[former_member321894]

So I cannot use my HANA express at all... Can anyone help me on?

[former_member321894]

Hi Emmanuel and thanks.

I tried what you said (why doesn't it say this in the guide - how could i possibly know??) but I get an error:

So does that mean my firewall blocks something? How can I continue?

Best regards,

Melanie

[former_member25364]

Hello Melanie

After xs login, enter https://hexhost:30030 as followed

API_URL> https://hexhost:30030

and press enter.

Regards

Emmanuel

[former_member321894]

As I can only do 2 pictures per answer, here just quickly the ip & google chrome try screenshot:

Also, if I continue in the guide (step 2, Change the passwords of all XSA users...) I can do that.
I can do step 3, Log in to XSA services
Step 4 says, "check for a series of entries beginning with "https://...". I don't see any entries after i use to xs login, see the picture:

So something seems kinda off. I hope you can help me!

Best regards,
Melanie

[former_member321894]

Hi Craig,

Thanks for your answer. HDB info command is a step in the guide so I already checked this and to me it looks as it should, see attached.

If I do your suggested command regarding firewall, I get following:

I assume this means it did not work? I'm scared to run the same command but with "/usr/sbin/iptables" instead of just "iptables" at the start but maybe that's what's required? Please advice.

Best regards,

Melanie