Panel | |
---|---|
|
...
PostgreSQL | 12, 13, 14, 15 |
---|---|
MySQL | 8.0.x |
Below are the generic steps for the preparation of a database instance for UDMG and how this can be done for the different database types.
- database server
- database instance
- database user
Depending on the exact flavor, on the database type, on the environment topology, and on other performance or security requirements, more advanced configuration parameters or procedures may be needed which are not in scope for this guide.
Once the database user is ready, the database parameters can be setup in UDMG Server configuration. The database content is initialized on the first execution and further maintained during release upgrades (see the "Upgrading UDMG Server" in the Linux and Windows installation guides)
PostgreSQL
PostgreSQL for Linux
...
Install a PostgreSQL database server.
Once the installation is complete, initialize the PostgreSQL database.
Enable and start the PostgreSQL Server:
Panel |
---|
|
- Create a user for UDMG Server
...
- 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):
...
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. |
...