IACT-db/.env.example at develop · jcg-admin/IACT-db · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
# =============================================================================
# IACT-db — Configuración de infraestructura de bases de datos
# =============================================================================
# Copiar a .env y ajustar los valores antes de ejecutar bootstrap.sh
#
#   cp .env.example .env
#   sudo bash bootstrap.sh
#
# .env está en .gitignore — nunca commitear credenciales reales.
# =============================================================================

# -----------------------------------------------------------------------------
# MariaDB 11.4 — Base de datos legada (ivr_legacy, READ-ONLY para Django)
# -----------------------------------------------------------------------------
MARIADB_VERSION=10.11
DB_MARIADB_NAME=ivr_legacy
DB_MARIADB_USER=django_user
DB_MARIADB_PASSWORD=django_pass
DB_MARIADB_ROOT_PASSWORD=rootpass123
DB_CHARSET=utf8mb4
DB_COLLATION=utf8mb4_unicode_ci
MARIADB_HOST=127.0.0.1
MARIADB_PORT=3306

# -----------------------------------------------------------------------------
# PostgreSQL 16 — Base de datos principal (iact_analytics)
# -----------------------------------------------------------------------------
POSTGRES_VERSION=16
DB_POSTGRES_NAME=iact_analytics
DB_POSTGRES_USER=django_user
DB_POSTGRES_PASSWORD=django_pass
DB_POSTGRES_ROOT_PASSWORD=postgrespass123
POSTGRES_HOST=127.0.0.1
POSTGRES_PORT=5432

# -----------------------------------------------------------------------------
# Adminer 4.8.1 — Interfaz web de administración (opcional)
# -----------------------------------------------------------------------------
ADMINER_VERSION=4.8.1
ADMINER_DOMAIN=adminer.local
SWAP_SIZE=1G

# SSL (autofirmado para desarrollo)
SSL_DAYS=365
SSL_COUNTRY=MX
SSL_STATE=Estado
SSL_CITY=Ciudad
SSL_ORG=IACT DevBox
SSL_OU=Development

# -----------------------------------------------------------------------------
# Configuración general
# -----------------------------------------------------------------------------
# Zona horaria del sistema
TIMEZONE=America/Mexico_City

# Seed de datos de prueba (usado por provisioners/mariadb/schema_seed.sh)
# Número de registros a sembrar en tbl_temp_prueba_ivr
SEED_ROWS=3000