Data Initialization

1. DM8 Database

Place init-qdata.sql under /data/dm8.

# View the container ID
docker ps -a
# Enter the container
docker exec -it container_id bash

# Run /home/dmdba/dmdb/bin/disql SYSDBA/InC3tmU4bijT4vkl to connect to the database
/home/dmdba/dmdb/bin/disql SYSDBA/InC3tmU4bijT4vkl

# Create the user and schema, then grant permissions (run in order)
create user "QDATA" identified by "2LKqLVMQ!xVDT$Qx" hash with SHA512 salt;
grant "PUBLIC","SOI","DBA" to "QDATA";
# Initialize the database (run in order)
set define off
set CHAR_CODE UTF8
`/home/dmdba/data/init-qdata.sql
set define on

2. PostgreSQL Database

Place dolphinscheduler_postgresql.sql under /data/postgresql.

# View the container ID
docker ps -a
# Enter the container
docker exec -it container_id bash

# Run the database initialization script
/opt/bitnami/postgresql/bin/psql -U root -d dolphinscheduler -f /bitnami/postgresql/dolphinscheduler_postgresql.sql
# After the previous command runs, enter the password: Idgf~V4pco&PF
# After entering the password, wait for execution to complete