Database Installation

This page provides setup instructions for each supported database management system. For each one, it explains how to:

• Install the database management system and required packages.
• Create the database and user for UDMG.
• Grant the required permissions.
• Verify connectivity to the database. The examples use the open-source usql command-line interface, which is recommended for its versatility and ease of use, but it is not required for UDMG installation or operation.
• Run a query to confirm database access.

MySQL

1. Install MySQL

Refer to the MySQL official documentation for guidance on installation.

info

The database must be running and accessible on the host where UDMG is installed.

2. Create a dedicated database for UDMG

mysql> CREATE DATABASE udmg;

3. Create a dedicated user for UDMG

mysql> CREATE USER 'udmgadm'@'localhost' IDENTIFIED BY 'udmg-mysql-password';

4. Grant the required permissions

mysql> GRANT ALL PRIVILEGES ON udmg.* TO 'udmgadm'@'localhost';

5. Verify the connection

mysql -u udmgadm -p -h 127.0.0.1 -P 3306 udmg

Expected output:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 189
Server version: 8.0.44 MySQL Community Server - GPL

Copyright (c) 2000, 2025, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

6. Run a query to confirm database access

mysql> show tables;

Expected output on a new database:

Empty set (0.00 sec)

This confirms that:

• The database connection is working.
• The udmgadm user has access.
• The database is reachable and currently empty.

Oracle

1. Install Oracle

Refer to the Oracle official documentation for guidance on installation.

info

The database must be running and accessible on the host where UDMG is installed.

2. Install the Oracle Instant Client

Download and install the Oracle Instant Client. The Basic or Basic Light packages are enough:

• For Linux
• For Windows

Alternatively, an Oracle Database installation or a full Oracle Client installation will also provide the required Oracle Client libraries.

3. Install required system libraries

For Linux, install the libaio library. You can typically obtain it from your operating system's package manager. On Debian-based distributions, this package is called libaio1.

For Windows, install the latest Microsoft Visual Studio Redistributable.

4. Create a dedicated user and schema for UDMG (run as an Oracle DBA)

CREATE USER udmgadm IDENTIFIED BY "udmg-oracle-password";
GRANT CONNECT, RESOURCE TO udmgadm;

5. Verify the connection using usql

usql godror://udmgadm:udmg-oracle-password@//host:1521/service

Expected output:

Connected with driver godror
Type "help" for help.

godror:udmgadm@host/service=>

6. Run a query to confirm database access

select table_name from user_tables;

Expected output on a new schema:

(0 rows)

This confirms that:

• The Oracle Instant Client is installed correctly.
• Required system libraries are available.
• The udmgadm user exists and can connect.
• The schema is reachable and currently empty.

Microsoft SQL Server

1. Install SQL Server

Refer to the Microsoft SQL official documentation for guidance on installation.

info

The database must be running and accessible on the host where UDMG is installed.

2. Create a dedicated database and login for UDMG

Run the following commands using SQL Server Management Studio (SSMS) or sqlcmd:

CREATE DATABASE udmg;
CREATE LOGIN udmgadm WITH PASSWORD = 'udmg-mssql-password';

3. Create the user and assign permissions

USE udmg;
CREATE USER udmgadm FOR LOGIN udmgadm;
ALTER ROLE db_owner ADD MEMBER udmgadm;

4. Verify the connection using usql

usql sqlserver://udmgadm:udmg-mssql-password@host:1433/udmg

Expected output:

Connected with driver sqlserver
Type "help" for help.

mssql:udmgadm@host/udmg=>

5. Run a query to confirm database access

SELECT name FROM sys.tables;

Expected output on a new database:

(0 rows)

This confirms that:

• SQL Server is running and accessible.
• The udmgadm login and user are correctly configured.
• The database is reachable and currently empty.

PostgreSQL

1. Install PostgreSQL

Refer to the PostgreSQL official documentation to install PostgreSQL on your system.

info

The database must be running and accessible on the host where UDMG is installed.

2. Create a dedicated database and user for UDMG

Connect as a superuser (e.g. postgres) and run:

CREATE DATABASE udmg;
CREATE USER udmgadm WITH PASSWORD 'udmg-postgres-password';

3. Grant the required privileges

GRANT ALL PRIVILEGES ON DATABASE udmg TO udmgadm;

Then connect to the udmg database and grant schema-level permissions:

GRANT ALL ON SCHEMA public TO udmgadm;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO udmgadm;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO udmgadm;

4. Verify the connection using usql

usql pg://udmgadm:udmg-postgres-password@localhost/udmg

Expected output:

Connected with driver postgres
Type "help" for help.

pg:udmgadm@localhost/udmg=>

5. Run a query to confirm database access

\dt

Expected output on a new database:

No relations found.

This confirms that:

• PostgreSQL is installed and running.
• The udmgadm user has access to the udmg database.
• The connection is working and the schema is currently empty.