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 and user for UDMG

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

3. Grant the required permissions

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

4. Verify the connection using usql

usql my://udmgadm:udmg-mysql-password@localhost/udmg

Expected output:

Connected with driver mysql (8.0.xx)
Type "help" for help.

my:udmgadm@localhost/udmg=>

5. Run a query to confirm database access

show tables;

Expected output on a new database:

(0 rows)

This confirms that:

• The database connection is working.
• The udmg 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.

3. Install required system libraries

Ensure the libaio library is installed. You can typically obtain it from your operating system's package manager.

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.