Panel | |
---|---|
|
...
Here is how to configure the database for a local installation where the database server is on the same host. For multi-node installation please refer to your database administrator.
Note | ||
---|---|---|
| ||
The following steps require root privilege, be sure that you have the correct access before |
continuing. |
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 # systemctl start postgresql |
- Create a user for UDMG Waarp Gateway
Login as PostgreSQL administrative user, start the PostgreSQL Console (psql) and create the database user for UDMG:
Panel |
---|
|
- 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 |
---|
|
to:
Panel |
---|
|
The exact configuration depends on the OS and database version, on the preferred security settings, and on the system architecture.
Panel |
---|
|
PostgreSQL for Windows
Create a blank database on the server. An already existing database can be used, but this is not recommended.
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 install or upgrade has been completed successfully, the configured database user requires only DML (Data Manipulation Language) permissions.
Here is how to configure the database for a local installation where the database server is on the same host. For multi-node installation please refer to your database administrator.
Note | ||
---|---|---|
|
...
The following steps require Administrator privilege, be sure that you have the correct access before continuing. |
Install a PostgreSQL database server.
Once the installation is complete, initialize the PostgreSQL database.
Start the PostgreSQL Server:
For example, from the Service Management Console management:
Create a user for UDMG Waarp Gateway
Login as PostgreSQL user, start the PostgreSQL Console (psql) and create the database user:
Panel |
---|
|
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 |
---|
|
to:
Panel |
---|
|
For a system where the database server is on the same subnet as the UDMG server, change it to:
Panel |
---|
|
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 |
---|
|
The current password encryption method can be returned by PostgreSQL Console (psql):
Panel |
---|
|
MySQL
MySQL for Linux
Step 1 |
---|
Download MySQL installation instructions. | |
Step 2 | Download |
---|
the installation package from the official MySQL site.
|
Step 3 |
---|
Install MySQL as per the instructions.
| |||
Step 4 | Create a blank database on the server. An already existing database can be used, but this is not recommended.
|
---|
| |||
Step 5 | Add a user that will be used as the owner of the related tables but also to authenticate with the server.
|
---|
|
|
|
|
|
MySQL for Windows
Step 1 | Download MySQL installation instructions. | |||
---|---|---|---|---|
Step 2 | Download the installation package from the official MySQL site.
| |||
Step 3 | Install MySQL as per the instructions. | |||
Step 4 | Create a blank database on the server. An already existing database can be used, but this is not recommended.
| |||
Step 5 | Add a user that will be used as the owner of the related tables but also to authenticate with the server.
| |||
Step 6 | The database content will be created automatically on the first run of the UDMG Server. |
...