cancel
Showing results for 
Search instead for 
Did you mean: 

Fixing external access to SAP HANA Instance on CloudShare

matthias_fiebig
Explorer
0 Kudos
758

Hello,

connect a SAP HANA Studio from my own desktop to the SAP HANA instance on Cloud Share, like descriped in the HOWTO

Part 4 - Connect to your local SAP HANA Studio and Sap HANA Client to your HANA server on CloudShare (optional).

doesn't work. After a service request on Cloud Share I got the information, that only the ports 22, 443, 80, 3389, 8080 are open for public access.

So that is possible: Add a local port forwarding on the SAP HANA Linux machine


iptables -t nat -A PREROUTING -i eth0 -p tcp --dport 8080 -j REDIRECT --to-port 30015

now you can change the destionation port in the system config of the SAP HANA Studio from 30015 to 8080 and it should work.

After the test you can save the config with.

iptables-save

I hope this helps.

Matthias

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

I am having the same issue with the logon credentials. On the Cloudshare environment page, I see my server and the virtual studio. I can log into the virtual studio. However, I want to use my locally installed studio. I use the same credentials and these are rejected. I did do the Branger blog steps above, I have a vanity URL, but, I have not had any problems reaching the server. I just cannot log in. Cloudshare folks just kick this back to SAP. I also paid for the developer license, yet my Cloudshare environment page says I have 7 days left on my free trial

Former Member
0 Kudos

Hi David,

If you want to use your locally installed studio follow the steps mentioned below.

1.

1. Create an entry in your local hosts file:


for Windows: C:\Windows\System32\drivers\etc\hosts.( If you are using Windows 8, you need to open the host file as follows: search>notepad>right click>run as administrator>browse the host file> open.

for Linux: /etc/hosts) -- > mapping your elastic IP / (IP address which you used in HANA studio) to the hosts name of your hana server.

*** Use the internal IP address to connect from your Cloudshare HANA Studio, if you want to connect from your local machine, use the external IP address.

2. While adding a new system, you need to provide correct hostname. ie

host: <hostname>.vm.cld.sr

instance: 00

3. In case if you changed SAP HANA server "Vanity URl", you need to use that as a Host name.

If you are still getting error message(s) with the HANA Studio (on Cloudshare desktop image) to the HANA DB after you enter the correct username or password:

a. "Error when connecting to system":

The issue seems to be caused by a corrupted secure storage file.

As a workaround, please follow the following steps:

1. Delete your HANA connection on the Navigator tab in HANA Studio, and then close the HANA Studio.

2. Open windows explorer, and navigate to C:\Users\Administrator folder on your Cloudshare desktop.

3. Find the folder ".eclipse" and rename it to "OLD.eclipse":

4. Open your HANA Studio and set your HANA DB Connection again. You will be prompted to set the password reminder for secure storage file. You can choose "No".

5. After that, the new ".eclipse" folder and the new secure storage file will be recreated.

6. Close and re-open your HANA Studio, to verify that the workaround fixed the connection issue.

Hope this helps!!

Regards

Avijit

Former Member
0 Kudos

Below link helped me to solve the issue, through vanity urls.

http://rbranger.wordpress.com/2013/04/06/using-hana-on-cloudshare-part-1-setup-connectivity/

raphael_branger
Participant
0 Kudos

Hi everybody

I guess everything is even much easier - if you once figured it out. Have a look at my latest blog post here: http://wp.me/p2nNXm-2Y

The key is that you configure a vanity URL for the HANA server in your Cloudshare account. Afterwards the server has its own public URL / hostname on <yourname>.vm.cld.sr

On this hostname even port 30015 seems to be open. At least I could connect from a different Cloudshare environment with BO 4.0 installed.

Best regards

Raphael

matthias_fiebig
Explorer
0 Kudos

Hello,

are you shure it works from outside cloudshare. At my tests the port was not open from the outside.

Matthias

Former Member
0 Kudos

It worked perfectly fine for me as I just installed HANA Studio on my laptop. I am susbcribed to 30-days Free trial on Cloudshare. I simply changed 'External address' for HANA SPS5 server under 'Vanity URLs' and added that as 'Server' in HANA Studio on my laptop. I did not have to open any ports and it just simply worked fine.

Former Member
0 Kudos

After I changed the 'Vanity URL' under my account, I couldn't access the HANA DB anymore, given an error from the HANA Studio ' the installed HANA database license is expired'. I rebooted the server, but it's still the same. Any clue? Thanks.

Former Member
0 Kudos

Hello Animesh,

Today I have registered for 30 day trial HANA dev edition on Cloudshare. Me too changed External address' for HANA SPS5 server under 'Vanity URLs'. I am unable to connect to SAP HANA DB to HANA studio after that. Even I am unable to create a new system as its saying username and password are incorrect. I have provided the same password mentioned in blog.

Kindly help

Avijit

Former Member
0 Kudos

Hi Matthias,

I am a Java Architect. I am trying to develop a webapp that display some information from various sources. One of the sources in SAP Hana.

For the sake of this demo, I got the 30 day trial instance of Hana on cloudshare. I got the access on hanasvr-03 hana instance.

As you mentioned, I tried connecting to this SAP Hana instance from my local jdeveloper. But the server does not connect on both port 30015 and port 8080.

Do I have to make somechanges to the ports on the hanasvr-03 server. If yes, where do I get the login passwords for that?

Please help.

Regards,

Garima

matthias_fiebig
Explorer
0 Kudos

Hello,

in my case I must set the following commands on the HANA Server (Linux machine)

So that is possible: Add a local port forwarding on the SAP HANA Linux machine


iptables -t nat -A PREROUTING -i eth0 -p tcp --dport 8080 -j REDIRECT --to-port 30015

iptables-save

Matthias

Former Member
0 Kudos

Hi Garima,

You cannot access the 30-day trial servers from outside your remote desktop on Cloudshare. This is an intentional security setting that you cannot change. If you want something you can connect to from your local jdeveloper, you will need to sign up for one of the developer instances.

--juergen

Former Member
0 Kudos

Hi

FYI, I was able to access the server from HANA Studio installed on my laptop using 30015 port directly.

But the only issue I have is that the server state shows as Yellow while accessing the server from locally installed HANA studio as it is not able to figure out if the "sapstarsrv" is running or not.

When I access the server from HANA Studio desktop provided by cloudshare everything looks green.

Thanks

Naresh P.