Prerequisites

🛠️ Prerequisites

Before running the jar file, ensure the following dependencies are installed:

📌 System Requirements

• Java (Open JDK 21)
• Postgresql Database (For apllication data storage and testing use cases.)
• MySQL Database (For testing use cases. Optional)
• IBM DB2 (For testing use cases. Optional) FYI for community edition of DB2 the default port is 25000

Install postgres on redhat linux

In this case we use postgres 14

sudo dnf install -y postgresql14-server postgresql14
sudo /usr/pgsql-14/bin/postgresql-14-setup initdb
sudo systemctl enable --now postgresql-14

---

Print PostgreSQL version

sudo -u postgres psql -c "SELECT version();"

---

Install db2 on redhat linux

Commands to Install DB2 (You must have downloaded your copy of DB2 from your approved source and have it available for install)

* adduser db2inst1
* passwd <password>
* usermod -a -G root db2inst1
* vi /etc/sudoers

Add line to bottom of file

db2inst1 ALL= (ALL:ALL) ALL

Create users

useradd db2fenc1
passwd db2fenc1
sudo useradd db2user 
sudo passwd db2user

---

Create directory to store db2

mkdir db2v11
chmod 777 db2v11rm db2v 
(careful with permission, this is obviously very open and may not be suitable for your environment)

---

Copy file to folder

cp gzip -dv DB2S_11.5.4_MPML.tar.gz
chmod 755 DB2S_11.5.4_MPML.tar
tar -xvf DB2S_11.5.4_MPML.tar
chmod 777 server_dec
cd server_dec

---

./db2prereqcheck -v 11.5.4

Run the command: TSA**./db2_install -f sysreq

Follow the steps 1 yes 2 yes 3 SERVER 4 no for DB2 pureScale

• cd /opt/ibm/db2/V11.5/bin

• .cd bin/db2val

• db2start

• ./instance/db2ilistls

Create an instance

• cd
• ./instance/db2icrt db2fenc1 db2inst1

change to instance user

• su - db2inst1

• db2start

• ./instance/db2ilistls

• ps -ef | grep db2sysc - check if instance is up and running

Create a DB

• db2 create database crm

Add remote connectivity

• db2 catalog tcpip node rcrm remote [ip] server 50000  

• db2 catalog database crm as acrm at node rcrm 

• db2 connect to acrm user db2user using

• cd adm

• su db2inst1

• db2start

as user db2inst1

• db2 list applications

CONNECT TO crm database

• db2 connect crm CREATE TABLE TDEMO (username CHAR(3) NOT NULL)

Allow remote connections to crm

• vi /etc/services - the last line should have (if not add)

• db2c_db2inst1 50000/tcp

• sudo systemctl start firewalld

Check firewalld status

• sudo systemctl status firewalld Open port 50000 permanently
• sudo firewall-cmd --zone=public --add-port=50000/tcp --permanent Reload firewalld to apply changes
• sudo firewall-cmd --reload Verify the port is open
• sudo firewall-cmd --zone=public --list-ports

Note about db2 We also use the Db2 Sample database - once you have DB2 running, install the sample DB using the following procedure described here

Install mysql on redhat linux

---

Steps for a Fresh Installation of MySQL

Follow these steps to choose and install the latest MySQL products:

Adding the MySQL Yum Repository

Add the MySQL Yum repository to your system's repository list. This is typically a one-time operation that is performed by installing the RPM provided by MySQL. Follow these steps:

1. Download it from the MySQL Yum Repository page in the MySQL Developer Zone.
2. Select and download the release package for your platform.
3. Install the downloaded release package. The package file format is:

mysql84-community-release-{platform}-{version-number}.noarch.rpm

mysql84: Indicates the MySQL version that is enabled by default. In this case, MySQL 8.4 is enabled by default, and both MySQL 8.0 and the MySQL Innovation series are available but disabled by default.

{platform}: The platform code, such as el7, el8, el9, fc39, fc40, or fc41. The 'el' represents Enterprise Linux, 'fc' for Fedora, and it ends with the platform's base version number.

{version-number}: Version of the MySQL repository configuration RPM as they do receive occasional updates.

Install the RPM you downloaded for your system, for example:

sudo yum localinstall mysql84-community-release-{platform}-{version-number}.noarch.rpm

---

Installing MySQL

Install MySQL by the following command (for dnf-enabled systems, replace yum in the command with dnf):

sudo yum install mysql-community-server

This installs the package for MySQL server (mysql-community-server) and also packages for the components required to run the server, including packages for the client (mysql-community-client), the common error messages and character sets for client and server (mysql-community-common), and the shared client libraries (mysql-community-libs).

---

Starting the MySQL Server

Start the MySQL server with the following command:

systemctl start mysqld

---

You can check the status of the MySQL server with the following command:

systemctl status mysqld

If the operating system is systemd enabled, standard systemctl (or alternatively, service with the arguments reversed) commands such as stop, start, status, and restart should be used to manage the MySQL server service. The mysqld service is enabled by default, and it starts at system reboot.

Post install steps for root user

At the initial start up of the server, the following happens, given that the data directory of the server is empty:

• The server is initialized.

• SSL certificate and key files are generated in the data directory.

• validate_password is installed and enabled.

A superuser account 'root'@'localhost is created. A password for the superuser is set and stored in the error log file. To reveal it, use the following command:

sudo grep 'temporary password' /var/log/mysqld.log

Change the root password as soon as possible by logging in with the generated, temporary password and set a custom password for the superuser account:

mysql -uroot -p

ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';

Note

validate_password is installed by default. The default password policy implemented by validate_password requires that passwords contain at least one uppercase letter, one lowercase letter, one digit, and one special character, and that the total password length is at least 8 characters.