fbda1b4beb
Some checks failed
Deploy to Phoenix / deploy (push) Has been cancelled
- ADD_CHAIN138_TO_LEDGER_LIVE: Ledger form done; public code review repo bis-innovations/LedgerLive; init/push commands - CONTRACT_DEPLOYMENT_RUNBOOK: Chain 138 gas price 1 gwei, 36-addr check, TransactionMirror workaround - CONTRACT_*: AddressMapper, MirrorManager deployed 2026-02-12; 36-address on-chain check - NEXT_STEPS_FOR_YOU: Ledger done; steps completable now (no LAN); run-completable-tasks-from-anywhere - MASTER_INDEX, OPERATOR_OPTIONAL, SMART_CONTRACTS_INVENTORY_SIMPLE: updates - LEDGER_BLOCKCHAIN_INTEGRATION_COMPLETE: bis-innovations/LedgerLive reference Co-authored-by: Cursor <cursoragent@cursor.com>
71 lines
2.3 KiB
Bash
Executable File
71 lines
2.3 KiB
Bash
Executable File
#!/bin/bash
|
|
# Configure All Databases - Create databases and users
|
|
|
|
set -uo pipefail
|
|
|
|
NODE_IP="${PROXMOX_HOST_R630_01}"
|
|
|
|
log_info() { echo -e "\033[0;32m[INFO]\033[0m $1"; }
|
|
log_success() { echo -e "\033[0;32m[✓]\033[0m $1"; }
|
|
log_error() { echo -e "\033[0;31m[ERROR]\033[0m $1"; }
|
|
|
|
configure_order_db() {
|
|
local vmid="$1"
|
|
log_info "Configuring Order database on CT $vmid..."
|
|
|
|
ssh -o ConnectTimeout=15 -o StrictHostKeyChecking=no root@${NODE_IP} "
|
|
pct exec $vmid -- su - postgres -c \"
|
|
psql << 'SQL_EOF'
|
|
CREATE DATABASE order_db;
|
|
CREATE USER order_user WITH PASSWORD 'order_password';
|
|
GRANT ALL PRIVILEGES ON DATABASE order_db TO order_user;
|
|
ALTER DATABASE order_db OWNER TO order_user;
|
|
\\l order_db
|
|
SQL_EOF
|
|
\" 2>&1
|
|
" && log_success "Order DB configured on CT $vmid" || log_error "Failed on CT $vmid"
|
|
}
|
|
|
|
configure_dbis_db() {
|
|
local vmid="$1"
|
|
log_info "Configuring DBIS database on CT $vmid..."
|
|
|
|
ssh -o ConnectTimeout=15 -o StrictHostKeyChecking=no root@${NODE_IP} "
|
|
pct exec $vmid -- su - postgres -c \"
|
|
psql << 'SQL_EOF'
|
|
CREATE DATABASE dbis_core;
|
|
CREATE USER dbis WITH PASSWORD '8cba649443f97436db43b34ab2c0e75b5cf15611bef9c099cee6fb22cc3d7771';
|
|
GRANT ALL PRIVILEGES ON DATABASE dbis_core TO dbis;
|
|
ALTER DATABASE dbis_core OWNER TO dbis;
|
|
\\l dbis_core
|
|
SQL_EOF
|
|
\" 2>&1
|
|
" && log_success "DBIS DB configured on CT $vmid" || log_error "Failed on CT $vmid"
|
|
}
|
|
|
|
echo "═══════════════════════════════════════════════════════════"
|
|
echo "Configure All Databases"
|
|
echo "═══════════════════════════════════════════════════════════"
|
|
echo ""
|
|
|
|
# Wait for PostgreSQL to be ready
|
|
log_info "Waiting for PostgreSQL services to be ready..."
|
|
sleep 5
|
|
|
|
# Configure Order databases
|
|
log_info "Configuring Order databases..."
|
|
for vmid in 10000 10001; do
|
|
configure_order_db "$vmid"
|
|
sleep 2
|
|
done
|
|
|
|
# Configure DBIS databases
|
|
log_info "Configuring DBIS databases..."
|
|
for vmid in 10100 10101; do
|
|
configure_dbis_db "$vmid"
|
|
sleep 2
|
|
done
|
|
|
|
echo ""
|
|
log_success "Database configuration complete!"
|