Skip to Content
0

SAP HANA Express (Docker Store) login details

Nov 24, 2017 at 05:47 PM

127

avatar image
Former Member

How can one login to the SAP HANA Express 2.0 database after it has been set up from the Docker Store, following the instructions exactly. (using HXEHana1 as password)

This is what I get:

hxeadm@36c59c56cb91:/usr/sap/HXE/HDB90> hdbsql -i 90 -u SYSTEM -p HXEHana1 -n localhost:39013

Single Sign-On authentication failed

hxeadm@36c59c56cb91:/usr/sap/HXE/HDB90> hdbsql -i 90 -u hxeadm -p HXEHana1 -n localhost:39013

Single Sign-On authentication failed

What am I doing wrong?

10 |10000 characters needed characters left characters exceeded
docker inspect 77e4860f00a6
shows          "ExposedPorts": {
                "39017/tcp": {},
                "39041/tcp": {},
                "59013/tcp": {},
                "8090/tcp": {}
            },

<br>
However, the only working end-point in browser is <br>http://172.17.0.2:8090/<br>returns the XS Engine Running webpage
docker ps -a <br>returns the container id 86d287a17b17 <br>docker port 86d287a17b17
39013/tcp -> 0.0.0.0:39013
39041/tcp -> 0.0.0.0:39041
1129/tcp -> 0.0.0.0:1129
39017/tcp -> 0.0.0.0:39017
39042/tcp -> 0.0.0.0:39042
39043/tcp -> 0.0.0.0:39043
39044/tcp -> 0.0.0.0:39044
39045/tcp -> 0.0.0.0:39045
59013/tcp -> 0.0.0.0:59013
59014/tcp -> 0.0.0.0:59014
1128/tcp -> 0.0.0.0:1128

but none of the end-points are succesfull,<br>example:
https://172.17.0.2:39017/v2/info
The following don't work neither:<br>xs api https://172.17.0.2:39030 --skip-ssl-validation
Or
xs api https://172.17.0.2:39017 --skip-ssl-validation
inside the container, HDB info shows the hdbdiserver(XSA) running<br>$ docker exec -it 86d287a17b17 bash
hxeadm@86d287a17b17:/usr/sap/HXE/HDB90> HDB info
USER       PID  PPID %CPU    VSZ   RSS COMMAND
hxeadm    7101     0  1.0  20936  4164 bash
hxeadm    7158  7101 12.5  20272  3288  \_ /bin/sh /usr/sap/HXE/HDB90/HDB info
hxeadm    7189  7158  0.0  43544  3476      \_ ps fx -U hxeadm -o user,pid,ppid,
hxeadm       1     0  0.0  20800  3800 /bin/bash /run_hana --passwords-url file:
hxeadm     868     1  0.0 502924 30204 /usr/sap/HXE/HDB90/exe/sapstartsrv pf=/us
hxeadm    1003     1  0.0  23504  2828 sapstart pf=/usr/sap/HXE/SYS/profile/HXE_
hxeadm    1062  1003  0.0 538740 58496  \_ /usr/sap/HXE/HDB90/localhost/trace/hd
hxeadm    1078  1062  9.7 4427644 2468232      \_ hdbnameserver
hxeadm    1190  1062  4.1 1390944 356752      \_ hdbcompileserver
hxeadm    1211  1062  9.5 4455120 2580072      \_ hdbindexserver -port 39040
hxeadm    1335  1062  3.9 1433744 339828      \_ hdbdiserver
hxeadm    1337  1062  4.2 1606648 358988      \_ hdbwebdispatcher


<br>
What am I doing wrong ? Nothing. The Hana Express Docker version is a bare dbms version with AFL installed. No XS Classic neither, nor XSA. I would have imagined XSA NodeJs Runtime and XSA Application Router orchestrated with other dedicated containers.


<br>
0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Frank Schuler
Nov 25, 2017 at 10:53 AM
0

Hello Axel,

I believe you are using the wrong port. In my Docker installation it is 39017.

Best regards

Frank

Share
10 |10000 characters needed characters left characters exceeded