1). Spin up t2.medium in AL23 in x subnet, put into Security Group that has 22 and 3000 open to connect to
2). Assign elastic IP
3). Install Docker
4). Create Docker Containers for Metabase and Postgres
Ensure the OS is updated
1 | ~]$ sudo dnf update -y |
Install Docker
1 2 3 4 | ~]$ sudo dnf install -y docker git ~]$ sudo systemctl enable --now docker ~]$ sudo usermod -aG docker ec2-user ~]$ exit |
Log out and back into the SSH session
Install Docker Compose Plugin (from the Docker website for manual install)
1 2 3 | ~]$ mkdir -p ~/.docker/cli-plugins ~]$ curl -SL https://github.com/docker/compose/releases/download/v2.22.0/docker-compose-linux-x86_64 -o ~/.docker/cli-plugins/docker-compose ~]$ chmod +x ~/.docker/cli-plugins/docker-compose |
Create the YAML file for Docker to run Postgres and Metabase
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 | ~]$ mkdir ~/metabase-docker ~]$ cd ~/metabase-docker ~]$ sudo nano docker-compose.yml version: '3.9' services: postgres: image: postgres:15 container_name: metabase_postgres environment: POSTGRES_USER: metabase POSTGRES_PASSWORD: secret POSTGRES_DB: metabase volumes: - pgdata:/var/lib/postgresql/data ports: - "5432:5432" metabase: image: metabase/metabase:latest container_name: metabase environment: MB_DB_TYPE: postgres MB_DB_DBNAME: metabase MB_DB_PORT: 5432 MB_DB_USER: metabase MB_DB_PASS: secret MB_DB_HOST: postgres ports: - "3000:3000" depends_on: - postgres volumes: pgdata: |
Start Docker Containers
1 2 3 4 | ~]$ docker compose up -d ~]$ docker ps ~]$ docker compose logs -f ~]$ |
Visit the website: http://192.168.1.3:3000/
Create user
tor@ with password secret
Add the Data source for AIMS
jdbc:sqlserver://192.168.1.2:1433;databaseName=X;username=USER;password=secret