Enable remote access to SysON (Solution)

[Krusty84]

Hello Dear Team,
I would like to provide solution for enable remote access to SysON.

1. Create self-signed:
   keytool -genkeypair -alias myalias -keyalg RSA -keysize 2048 -validity 365 -keystore keystore.jks

2. Place keystore.jks near Dockerfile (backend/application/syson-application)

3. Create run-syson.sh script: \

java -jar -Dspring.profiles.active=dev app.jar --server.port=$SYSON_BACKEND_LISTENING_PORT --server.ssl.key-store=keystore.jks --server.ssl.key-store-password=PASSWORD USED ON STEP 1 --server.ssl.key-password=PASSWORD USED ON STEP 1 --server.ssl.key-store-type=JKS --spring.datasource.url=jdbc:postgresql://$SYSON_DATABASE_HOSTNAME:$SYSON_DATABASE_LISTENING_PORT/$SYSON_DATABASE_NAME --spring.datasource.username=$SYSON_DATABASE_USERNAME --spring.datasource.password=$SYSON_DATABASE_PASSWORD --spring.liquibase.change-log=classpath:db/changelog/sirius-web.db.changelog.xml

5. Change exist Dockerfile (backend/application/syson-application): \

FROM node:18.7
ENV SYSON_BACKEND_LISTENING_PORT 8888
ENV SYSON_DATABASE_HOSTNAME "1.1.1.1"
ENV SYSON_DATABASE_LISTENING_PORT "5432"
ENV SYSON_DATABASE_NAME "postgres"
ENV SYSON_DATABASE_USERNAME "syson_user"
ENV SYSON_DATABASE_PASSWORD "syson_password"
RUN adduser --disabled-password myuser
RUN apt-get update && apt-get install -y openjdk-17-jre && apt-get clean cache
COPY syside-cli.js ./syside-cli.js
COPY syson-application-2024.5.0.jar ./app.jar
COPY run-syson.sh ./run-syson.sh
COPY keystore.jks ./keystore.jks
RUN chmod 777 ./run-syson.sh
USER myuser
ENTRYPOINT ["./run-syson.sh"] \

6. Build image (syson_app:2024.5.0)

7. Start Syson database: \

docker run -d --name syson-db -p 5432:5432 -e POSTGRES_DB=postgres -e POSTGRES_USER=syson_user
-e POSTGRES_PASSWORD=syson_password postgres:12

10. Start Syson application : \

docker run -it --name syson-app -p 8888:8888 -e SYSON_BACKEND_LISTENING_PORT=8888 -e SYSON_DATABASE_HOSTNAME=DB IP -e SYSON_DATABASE_LISTENING_PORT=DB PORT -e SYSON_DATABASE_NAME=DB NAME -e SYSON_DATABASE_USERNAME=DB USER -e SYSON_DATABASE_PASSWORD=DB PASSWORD syson_app:2024.5.0

11. Enjoy it.