Skip to Content
avatar image
Former Member

SAP HANA Express (Docker Store) login details

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?

Add comment
10|10000 characters needed 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>
  • Get RSS Feed

1 Answer

  • Nov 25, 2017 at 10:53 AM

    Hello Axel,

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

    Best regards

    Frank

    Add comment
    10|10000 characters needed characters exceeded