Installation process

MariaDB is used as the database below.

Create Database

Linux

In the console, change to the directory <Install-path>\<database>\bin .
For MariaDB as the database, it is the directory <Install-path>\mariadb\bin
Execute the command mysql.exe -u "username" -p
BASH
```
mysql -u root -p -h localhost
```
Once the connection is established, create the required database (in the MariaDB shell)
BASH
```
create database ece2;
```

Enter and execute the following commands with the corresponding variables for %mariadb-db-name%,%mariadb-wildfly-user%, %mariadb-wildfly-pw% and %host% .

XML

GRANT ALL PRIVILEGES ON ece2.* TO %mariadb-wildfly-user%@'localhost' IDENTIFIED BY '%mariadb-wildfly-pw%';
GRANT ALL PRIVILEGES ON ece2.* TO %mariadb-wildfly-user%@'127.0.0.1' IDENTIFIED BY '%mariadb-wildfly-pw%';
GRANT ALL PRIVILEGES ON ece2.* TO %mariadb-wildfly-user%@'::1' IDENTIFIED BY '%mariadb-wildfly-pw%';
GRANT ALL PRIVILEGES ON ece2.* TO %mariadb-wildfly-user%@'%host%' IDENTIFIED BY '%mariadb-wildfly-pw%';
FLUSH PRIVILEGES;

Exit MySQL Shell
Install JDBC driver
Restart WildFly service

Prepare RE Cockpit Environment

Linux

To prepare and structure the RE Cockpit environment, directories must be created in the shell.

BASH

cd /opt
sudo mkdir re-environment
cd re-environment

Install WildFly

Starting with RE 3.0.0, the RE Cockpit now requires WildFly 35 with Java 21 (LTS) instead of WildFly 18.0.1.

For new installations of RE 3.0.x, this means:

Use a WildFly 35 installation (instead of WildFly 18.0.1).
Configure Java 21 as the runtime for WildFly 35.
Apply the WildFly configuration steps described in this document (Datasources, JDBC drivers, Security Domain "ECE", Logging) to the WildFly 35 instance.

For upgrades from 2.x to 3.0.x, it is recommended:

to set up a new WildFly 35 instance in parallel,
to transfer the required configuration (Datasource, JMS, Security Domain, Logging),
to use the appropriate 3.0.x installer for WildFly 35 + Java 21 (see details ReleaseEngine 3.0.0 and ECE2 Installer).

The installation steps described below remain valid but must be applied to the new WildFly version.

These changes must be considered for both new installations and upgrades from 2.x to 3.0.x.

Linux

Download WildFly

BASH

cd ~/Downloads
wget http://download.jboss.org/wildfly/18.0.1.Final/wildfly-18.0.1.Final.zip
sudo mv ~/Downloads/wildfly-18.0.1.Final.zip /opt/re-environment/
cd /opt/re-environment

Extract contents into the directory /opt/re-environment

Edit standalone-full.xml so that it can access WildFly.

Find the IP address 127.0.0.1 and replace it with the server's IP address

wildfly-18.0.1.Final/standalone/configuration/standalone.xml

XML

<wsdl-host>${jboss.bind.address:127.0.0.1}</wsdl>
...
<interface name="management">
    <inet-address value="${jboss.bind.address.management:127.0.0.1}"/>
</interface>
<interface name="public">
    <inet-address value="${joss.bind.address:127.0.0.1}"/>
</interface>
<interface name="insecure">
    <inet-address value="${joss.bind.address.unsecure:127.0.0.1}"/>
</interface>

Windows

Download WildFly
Extract contents
Create a new folder "WildFly" in the installation directory
Copy WildFly into the installation directory
Copy module.xml to the directory <Install-path>\WildFly\modules\system\layers\base\com\mysql\main
Copy standalone.xml to the directory <Install-path>\WildFly\standalone\configuration

Configure WildFly

Linux

Start WildFly in the foreground
Create WildFly administrator
- Open console as administrator
- Navigate to the directory <Install-path>/WildFly/bin
- Execute add-user.sh
- Answer questions as follows:

Open and configure the firewall to allow access to WildFly

BASH

sudo systemctl enable firewalld
sudo systemctl start firewalld
sudo firewall-cmd --zone=public --add-port=8080/tcp --permanent
sudo firewall-cmd --zone=public --add-port=9990/tcp --permanent
sudo firewall-cmd --reload

Run WildFly as a service

CODE

cd /opt/re-environment
sudo cp ./wildfly-18.0.1.Final/docs/contrib/scripts/init.d/wildfly-init-redhat.sh  /etc/init.d/wildfly
sudo cp ./wildfly-18.0.1.Final/docs/contrib/scripts/init.d/wildfly.conf /etc/default

Create WildFly user and specify as owner

CODE

sudo useradd wildfly
sudo chown wildfly:wildfly -R /opt/re-environment/wildfly-18.0.1.Final

Create link in /opt-directory

CODE

sudo ln -s /opt/re-environment/wildfly-18.0.1.Final /opt/wildfly

Edit configuration. Find the JBOSS_CONFIG line and change it as follows:

/etc/default/wildfly.conf

XML

## Location of JDK
JAVA_HOME="/usr/java/jdk-9.0.4"

## Location of WildFly
JBOSS_HOME="/opt/re-environment/wildfly-18.0.1.Final"

## The username who should own the process.
JBOSS_USER=wildfly

## The mode WildFly should start, standalone or domain
JBOSS_MODE=standalone

## Configuration for standalone mode
JBOSS_CONFIG=standalone-full.xml

## Configuration for domain mode
# JBOSS_DOMAIN_CONFIG=domain.xml
# JBOSS_HOST_CONFIG=host-master.xml

## The amount of time to wait for startup
# STARTUP_WAIT=60

## The amount of time to wait for shutdown
# SHUTDOWN_WAIT=60

## Location to keep the console log
JBOSS_CONSOLE_LOG="/var/log/wildfly/console.log"

## Additionals args to include in startup
# JBOSS_OPTS="--admin-only -b 127.0.0.1"

Activate service-control
BASH
```
sudo systemctl enable wildfly
```

Copy the standalone.xml to the directory <Install-path>/WildFly/standalone/configuration

CODE

cd /opt/re-environment/wildfly-18.0.1.Final/standalone/configuration
sudo cp standalone.xml standalone.xml.original
sudo cp standalone-full.xml standalone.xml

WildFly stoppen und Konsole, in der es im Vordergrund gelaufen ist, schließen.
WildFly im Hintergrund starten
BASH
```
sudo systemctl start wildfly
```
Stop WildFly
Download and install the mySQL connector

CODE

sudo cd /opt
sudo wget https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-8.0.17.tar.gz
sudo tar -xvzf mysql-connector-java-8.0.17.tar.gz

Create the directory <Install-path>/WildFly/modules/system/layers/base/com/mysql/main and copy the JDBC-driver into the directory.

BASH

sudo mkdir -p /opt/wildfly/modules/system/layers/base/com/mysql/main
sudo cp mysql-connector-java-8.0.17/mysql-connector-java-8.0.17.jar /opt/wildfly/modules/system/layers/base/com/mysql/main

Create module.xml in the directory <Install-path>/WildFly/modules/system/layers/base/com/mysql/main with the following content:

wildfly/modules/system/layers/base/com/mysql/main/module.xml

XML

<module xmlns="urn:jboss:module:1.3" name="com.mysql">
    <resources>
        <resource-root path="mysql-connector-java-8.0.17.jar"/>
    </resources>

    <dependencies>
        <module name="javax.api"/>
        <module name="javax.transaction.api"/>
    </dependencies>
</module>

Edit standalone.xml

Insert the system properties between </extensions> and <management> .

standalone.xml

XML

<system-properties>
    <property name="resteasy.preferJacksonOverJsonB" value="true"/>
</system-properties>

Insert JAAS under <security-realms>.

standalone.xml

XML

<security-realm name="ECEApplicationRealm">
    <authentication>
        <jaas name="ECE"/>
    </authentication>
</security-realm>

Insert the log level under <subsystem xmlns="urn:jboss-domain:logging:5.0">.

standalone.xml

XML

<logger category="com.innoface.ece">
    <level name="TRACE"/>
</logger>
 
<!-- enable SQL Logging -->
<logger category="org.hibernate.SQL">
    <level name="DEBUG"/>
</logger>
 
<!-- enable logging of BIND parameters -->
<logger category="org.hibernate.type.descriptor.sql">
    <level name="TRACE"/>
</logger>

Insert the JDBC datasource under <datasources>.

standalone.xml

XML

<datasource jta="true" jndi-name="java:jboss/datasources/ECE" pool-name="ECESqlDS" enabled="true" use-java-context="true" use-ccm="true">
    <connection-url>jdbc:mysql://localhost:3306/ece2?useSSL=false&amp;serverTimezone=Europe/Berlin</connection-url>
    <driver>mysql-connector-java-8.0.17.jar</driver>
    <pool>
        <min-pool-size>10</min-pool-size>
        <max-pool-size>100</max-pool-size>
        <prefill>true</prefill>
        <use-strict-min>false</use-strict-min>
        <flush-strategy>FailingConnectionOnly</flush-strategy>
    </pool>
    <security>
        <user-name>root</user-name>
        <password>dbmaster</password>
    </security>
</datasource>

Insert the JDBC driver under <drivers>.

standalone.xml

XML

<driver name="mysql-connector-java-8.0.17.jar" module="com.mysql">
    <driver-class>com.mysql.cj.jdbc.Driver</driver-class>
    <xa-datasource-class>com.mysql.cj.jdbc.MysqlXADataSource</xa-datasource-class>
</driver>

Insert the JMS topic queue under <jms-queue name="DLQ" entries="java:/jms/queue/DLQ"/>.
standalone.xml
XML
```
<jms-topic name="topic/ecedaemon" entries="java:jboss/exported/jms/topic/innoface/ecedaemon"/>
```

Insert the security domain under <security-domains>.

standalone.xml

XML

<security-domain name="ECE">
    <authentication>
        <login-module code="com.innoface.ece.wildfly.ECELoginModule" flag="required">
            <module-option name="password-stacking" value="useFirstPass"/>
        </login-module>
    </authentication>
</security-domain>

Windows

Edit the standalone.xml

Replace jdbc-version-template at two locations with the jdbc version, e.g., mysql-connector-bin.jar