Panel | |
---|---|
|
...
Install a PostgreSQL database server.
Once the installation is complete, initialize the PostgreSQL database.
Enable and start the PostgreSQL Server:
Panel |
---|
# systemctl start postgresql # 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 |
---|
|
to:
Panel |
---|
|
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 |
---|
|
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. |
...