Orchestrator Database Access

Step 1 – Retrieve Database Credentials

Because Aria Orchestrator 8.x uses a containerized PostgreSQL instance, you must retrieve the credentials from the initialization file inside the Kubernetes pod.

SSH into the Appliance: Log in to your vRealize/Aria Automation appliance as root.

Run the Credential Command: Run the following command to get the plain-text password for the postgres user:

Command Line:

kubectl -n prelude exec -it postgres-0 -- /bin/bash -c "cat /run/populate_db.sql | grep 'ALTER ROLE \"postgres\"' | cut -d\"'\" -f2"

kubectl-npreludeexec-itpostgres-0--/bin/bash-c"cat /run/populate_db.sql | grep 'ALTER ROLE\"postgres\"' | cut -d\"'\" -f2"

Result: This is the password on the Orchestrator v8.18.1 appliance which I used to produce this content.

Defaulted container "control" out of: control, init (init)
2znPKg05ErONYJmbfwDIkoSoCOwJpldM

Defaultedcontainer"control"outof:control,init (init)
2znPKg05ErONYJmbfwDIkoSoCOwJpldM

Step 2 – Access the Database (Using SQL Plug-in)

You can now use the SQL plugin within the Orchestrator Client to browse and query the database.

Open Orchestrator Client: Navigate to https://vro8.cloudbuildtools.com/vco-client and log in.

Add Database Workflow: Go to Library > Workflows and search for the “Add a database” workflow.

Configure Connection: Run the workflow with the following details:

Name: A unique name (e.g., embedded-vro-pgsql).

Database type: PostgreSQL.

Connection URL: jdbc:postgresql://postgres:5432/vco-db.

Username: postgres.

Password: The password retrieved in Step 1.

Session mode: Shared Session.

Run Workflow: Execute the workflow to establish the connection.