Setting Up Syson Production Environment on Windows Server 2016

[ORogoll]

Hi everyone,

I've been trying to get the SysON Production environment running on a Windows Server 2016 VM in my organisations network and have been having trouble when trying to install the .jar file.

I'm guessing that there is something wrong with my PATH variable, but I am not sure.

Does anybody have an idea what's happening here?

Installation Configuration:

PostgresSQL: 15.13 for Windows x64
Java runtime Environment: Eclipse Temurin Adoptium JRE 17.0.15+6 Windows x64
Node.js: Node.js 18.7
Node.js-dependency: Python 3.12
Node.js-dependency: Visual Studio 2022 C++ development tools
SysON: syson-application-2025.4.2.jar

PostgreSQL Config:

Server Hostname: sysonhostname
Postgresql Port: 5432
Database Name: syson
Database User: postgres (postgres super user)

Certificate config:

I followed the instructions from https://doc.mbse-syson.org/syson/v2025.4.0/installation-guide/how-tos/https.html.

My keystore.jks file is in the same directory as my syson .jar file

Path Environment Variable:

Command to start the Installation:

java -jar C:\Users\Administrator\Desktop\InstallationFiles\06_SysON_.jar_file\syson-application-2025.4.2.jar \ 
		\ 
		--spring.datasource.url=jdbc:postgresql://sysonhostname:5432/syson \ 
		--spring.datasource.username=postgres \ 
		--spring.datasource.password=****** \ 
		\ 
		--server.ssl.key-store=./keystore.jks
		--server.ssl.key-store-password=****** \ 
		--server.ssl.key-store-type=JKS \
		--server.ssl.key-alias=myalias \ 
		--server.ssl.key-password=****** \ 
		\ 
--server.port=443

Error Message

Microsoft Windows [Version 10.0.20348.2031]
(c) Microsoft Corporation. All rights reserved.

C:\Users\Administrator\Desktop\InstallationFiles\06_SysON_.jar_file>java -jar C:\Users\Administrator\Desktop\InstallationFiles\06_SysON_.jar_file\syson-application-2025.4.2.jar \
    _____               ____   _   __
   / ___/ __  __ _____ / __ \ / | / /
   \__ \ / / / // ___// / / //  |/ /
  ___/ // /_/ /(__  )/ /_/ // /|  /
 /____/ \__, //____/ \____//_/ |_/
       /____/

 :: Spring Boot ::         (v3.4.5)

2025-05-19T13:56:42.663+02:00  INFO 4156 --- [           main] org.eclipse.syson.SysONApplication       : Starting SysONApplication v2025.4.2 using Java 17.0.15 with PID 4156 (C:\Users\Administrator\Desktop\InstallationFiles\06_SysON_.jar_file\syson-application-2025.4.2.jar started by Administrator in C:\Users\Administrator\Desktop\InstallationFiles\06_SysON_.jar_file)
2025-05-19T13:56:42.675+02:00  INFO 4156 --- [           main] org.eclipse.syson.SysONApplication       : No active profile set, falling back to 1 default profile: "default"
2025-05-19T13:56:47.644+02:00  INFO 4156 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JDBC repositories in DEFAULT mode.
2025-05-19T13:56:48.260+02:00  INFO 4156 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 605 ms. Found 8 JDBC repository interfaces.
2025-05-19T13:56:50.731+02:00  INFO 4156 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port 8080 (http)
2025-05-19T13:56:50.763+02:00  INFO 4156 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
2025-05-19T13:56:50.763+02:00  INFO 4156 --- [           main] o.apache.catalina.core.StandardEngine    : Starting Servlet engine: [Apache Tomcat/10.1.40]
2025-05-19T13:56:50.856+02:00  INFO 4156 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
2025-05-19T13:56:50.856+02:00  INFO 4156 --- [           main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 8090 ms
2025-05-19T13:56:51.445+02:00  WARN 4156 --- [           main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'standardLibraryDocumentDownloadSearchService' defined in URL [jar:nested:/C:/Users/Administrator/Desktop/InstallationFiles/06_SysON_.jar_file/syson-application-2025.4.2.jar/!BOOT-INF/lib/syson-application-configuration-2025.4.2.jar!/org/eclipse/syson/application/configuration/StandardLibraryDocumentDownloadSearchService.class]: Unsatisfied dependency expressed through constructor parameter 0: Error creating bean with name 'editingContextSearchService' defined in URL [jar:nested:/C:/Users/Administrator/Desktop/InstallationFiles/06_SysON_.jar_file/syson-application-2025.4.2.jar/!BOOT-INF/lib/sirius-web-application-2025.4.2.jar!/org/eclipse/sirius/web/application/editingcontext/services/EditingContextSearchService.class]: Unsatisfied dependency expressed through constructor parameter 0: Error creating bean with name 'semanticDataSearchService' defined in URL [jar:nested:/C:/Users/Administrator/Desktop/InstallationFiles/06_SysON_.jar_file/syson-application-2025.4.2.jar/!BOOT-INF/lib/sirius-web-domain-2025.4.2.jar!/org/eclipse/sirius/web/domain/boundedcontexts/semanticdata/services/SemanticDataSearchService.class]: Unsatisfied dependency expressed through constructor parameter 0: Error creating bean with name 'ISemanticDataRepository' defined in org.eclipse.sirius.web.domain.boundedcontexts.semanticdata.repositories.ISemanticDataRepository defined in @EnableJdbcRepositories declared on JDBCConfiguration: Cannot resolve reference to bean 'org.springframework.data.jdbc.core.mapping.JdbcMappingContext' while setting bean property 'mappingContext'
2025-05-19T13:56:51.445+02:00  INFO 4156 --- [           main] o.apache.catalina.core.StandardService   : Stopping service [Tomcat]
2025-05-19T13:56:51.477+02:00  INFO 4156 --- [           main] .s.b.a.l.ConditionEvaluationReportLogger :

Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled.
2025-05-19T13:56:51.497+02:00 ERROR 4156 --- [           main] o.s.b.d.LoggingFailureAnalysisReporter   :

***************************
APPLICATION FAILED TO START
***************************

Description:

Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured.

Reason: Failed to determine a suitable driver class


Action:

Consider the following:
        If you want an embedded database (H2, HSQL or Derby), please put it on the classpath.
        If you have database settings to be loaded from a particular profile you may need to activate it (no profiles are currently active).


C:\Users\Administrator\Desktop\InstallationFiles\06_SysON_.jar_file>\
'\' is not recognized as an internal or external command,
operable program or batch file.

C:\Users\Administrator\Desktop\InstallationFiles\06_SysON_.jar_file>--spring.datasource.url=jdbc:postgresql://syson-srv:5432/syson \
'--spring.datasource.url' is not recognized as an internal or external command,
operable program or batch file.

C:\Users\Administrator\Desktop\InstallationFiles\06_SysON_.jar_file>--spring.datasource.username=postgres \
'--spring.datasource.username' is not recognized as an internal or external command,
operable program or batch file.

C:\Users\Administrator\Desktop\InstallationFiles\06_SysON_.jar_file>--spring.datasource.password=***** \
'--spring.datasource.password' is not recognized as an internal or external command,
operable program or batch file.

C:\Users\Administrator\Desktop\InstallationFiles\06_SysON_.jar_file>\
'\' is not recognized as an internal or external command,
operable program or batch file.

C:\Users\Administrator\Desktop\InstallationFiles\06_SysON_.jar_file>--server.ssl.key-store=./keystore.jks
'--server.ssl.key-store' is not recognized as an internal or external command,
operable program or batch file.

C:\Users\Administrator\Desktop\InstallationFiles\06_SysON_.jar_file>--server.ssl.key-store-password=***** \
'--server.ssl.key-store-password' is not recognized as an internal or external command,
operable program or batch file.

C:\Users\Administrator\Desktop\InstallationFiles\06_SysON_.jar_file>--server.ssl.key-store-type=JKS \
'--server.ssl.key-store-type' is not recognized as an internal or external command,
operable program or batch file.

C:\Users\Administrator\Desktop\InstallationFiles\06_SysON_.jar_file>--server.ssl.key-alias=myalias \
'--server.ssl.key-alias' is not recognized as an internal or external command,
operable program or batch file.

C:\Users\Administrator\Desktop\InstallationFiles\06_SysON_.jar_file>--server.ssl.key-password=***** \
'--server.ssl.key-password' is not recognized as an internal or external command,
operable program or batch file.

C:\Users\Administrator\Desktop\InstallationFiles\06_SysON_.jar_file>\
'\' is not recognized as an internal or external command,
operable program or batch file.

C:\Users\Administrator\Desktop\InstallationFiles\06_SysON_.jar_file>--server.port=443
'--server.port' is not recognized as an internal or external command,
operable program or batch file.

C:\Users\Administrator\Desktop\InstallationFiles\06_SysON_.jar_file>

[stephanelacrampe]

This line is missing a \ at the end: --server.ssl.key-store=./keystore.jks
And \ may not be the right caracters for windows, it may be ^ in a command line

[ORogoll]

Thank you that helped a lot!

[AxelRICHARD]

Hello,

Are you sure it is a good idea to have a dot in your installation path?
Could you test with C:\Users\Administrator\Desktop\InstallationFiles\06_SysON_.jar_file\syson-application-2025.4.2.jar => C:\Users\Administrator\Desktop\InstallationFiles\06_SysON_\syson-application-2025.4.2.jar please?

Regards,

[ORogoll]

Thank you Axel, that is great advice.

Unfortunately the issue was not caused by the point.

[AxelRICHARD]

By the way, you should only use 202x.y.0 versions of SysON, those versions are "production" ready as stated in https://doc.mbse-syson.org/syson/v2025.2.0/user-manual/cycle.html#_version_and_release_policies

[ORogoll]

Thank you for the advice, but its not going to be an "actual" production environment. More of a playground actually, so we'd rather ave the latest features.

[ORogoll]

So I managed to solve the issue by following these steps:

1. I'm running the startup command through a .bat file with the following content:

@echo off
java -jar C:\Users\Administrator\Desktop\InstallationFiles\06_SysON_jar_file\syson-application-2025.4.2.jar ^
    --spring.datasource.url=jdbc:postgresql://sysonhostname:5432/syson ^
    --spring.datasource.username=postgres ^
    --spring.datasource.password=****** ^
    --server.ssl.key-store=./keystore.jks ^
    --server.ssl.key-store-password=****** ^
    --server.ssl.key-store-type=JKS ^
    --server.ssl.key-alias=myalias ^
    --server.ssl.key-password=****** ^
    --server.port=443 > log.txt 2>&1

2. I modified my PostgreSQL client authentication file pg_hba.conf by adding the following line at the end of the file:

host syson postgres "sysonserverip"/32 md5

3. I modified the postgresql.conf by adding the following content to the "listen_adresses line":

listen_addresses = ' *, localhost, sysonserverip, sysonserverhostname'

There still seem to be issues with the certificate as I'm receiving a warning when accessing SysON and if close my command line window the application stops working, but this is sufficient for testing as of now.

Warning when accessing SysON:

Thank you for the support everyone.