Page Comparison

Panel

Table of Contents

The following databases are supported:

...

Install a PostgreSQL database server.
Once the installation is complete, initialize the PostgreSQL database.
Start Enable and start the PostgreSQL Server:

Panel

# systemctl start postgresql

Create a user for UDMG Waarp Gateway

...

Finally change the pg_hba.conf, to allow database connection with password. For example, for a system where the database server is on the same host as the UDMG server, by changing this line from:

Panel
`host all all 127.0.0.1/32 ident`

to:

Panel
`host all all 127.0.0.1/32 md5`

The exact configuration depends on the OS and database version, on the preferred security settings, and on the system architecture.

...

For example, for a system where the database server is on the same host as the UDMG server, by changing this line from:

Panel
`host all all 127.0.0.1/32 ident`

to:

Panel
`host all all 127.0.0.1/32 scram-sha-256`

For a system where the database server is on the same subnet as the UDMG server, change it to:

Panel
`host all all samenet scram-sha-256`

The exact configuration depends on the OS and database version, on the preferred security settings, and on the system architecture.

The location of the pg_hba.conf can be returned by PostgreSQL Console (psql):

Panel
`postgres=# SHOW hba_file;`

The current password encryption method can be returned by PostgreSQL Console (psql):

...

Step 1

Download MySQL installation instructions.

Step 2

DownloadDownload the installation package from the official MySQL (Windows only) site.

For Windows, select Windows (x86, 32-bit), MSI Installer
For Unix and Linux, you can use a tar.gz download or select a systems package installer appropriate for your environment, such as Yum.

Step 3

Install MySQL as per the instructions.

For Linux, enable and start the MySQL Server:

Panel

# systemctl enable mysql

# systemctl start mysql

Step 4

Create a blank database on the server. An already existing database can be used, but this is not recommended.

Panel
mysql> CREATE DATABASE mft_waarp_gateway;

Step 5

Add a user that will be used as the owner of the related tables but also to authenticate with the server.
In order to install or perform upgrades, this database user will require DDL (Data Definition Language) permission in the database during the installation or the upgrade.
Once the installation or upgrade has been completed successfully, the configured database user requires only DML (Data Manipulation Language) permissions.

Panel

mysql> CREATE USER 'mft_waarp_gateway_user'@ IDENTIFIED BY 'mft_waarp_gateway_password';
mysql> GRANT ALL PRIVILEGES ON mft_waarp_gateway.* TO 'mft_waarp_gateway_user'@ WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;

Step 6

The database content will be created automatically on the first run of the UDMG Server.

...

Versions Compared

Old Version 4

New Version 5

Key