FM / docs

/home/techb158/trellopowerup.abdallabala.com/docs/

/home/techb158/trellopowerup.abdallabala.com/docs

Name	Size	Mode	Actions
00-design-study.md	3678	0644	edit dl rm
01-uml-class-diagram.puml	11869	0644	edit dl rm
02-use-case-diagram.puml	3763	0644	edit dl rm
03-sequence-diagrams.puml	9732	0644	edit dl rm
04-database-entity-model.mmd	7051	0644	edit dl rm
05-database-schema.sql	13372	0644	edit dl rm
06-diagram-preview.html	5021	0644	edit dl rm
07-design-checklist.md	3256	0644	edit dl rm
08-step-2-storage-layer.md	5325	0644	edit dl rm
09-step-3-risk-crud-ui.md	3380	0644	edit dl rm
10-step-4-mitigation-workflow.md	3996	0644	edit dl rm
11-step-5-deployment-gate-workflow.md	2292	0644	edit dl rm
12-step-6-multi-pm-integration.md	3770	0644	edit dl rm
13-step-6-1-microsoft-planner-integration.md	2335	0644	edit dl rm
14-step-7-reporting-export.md	4158	0644	edit dl rm
15-step-7-1-oauth-live-connectors.md	4545	0644	edit dl rm
16-step-8-user-roles-access-control.md	3297	0644	edit dl rm
17-step-9-production-deployment-security.md	4228	0644	edit dl rm
18-step-10-final-academic-submission.md	3199	0644	edit dl rm
19-final-report-draft.md	6814	0644	edit dl rm
20-instructor-submission-checklist.md	3639	0644	edit dl rm
21-demo-script.md	3948	0644	edit dl rm
22-traceability-matrix.md	4847	0644	edit dl rm
23-testing-evidence.md	2961	0644	edit dl rm
24-evaluation-rubric-mapping.md	2910	0644	edit dl rm
25-final-deployment-runbook.md	3214	0644	edit dl rm
26-known-limitations-and-future-work.md	2632	0644	edit dl rm
27-final-qa-checklist.md	2893	0644	edit dl rm
28-demo-rehearsal-script.md	3618	0644	edit dl rm
29-submission-freeze-report.md	2769	0644	edit dl rm
30-final-known-issues.md	1876	0644	edit dl rm
31-trello-powerup-implementation-guide.md	7608	0644	edit dl rm
32-vps-deployment-guide.md	3697	0644	edit dl rm
dashboard-spec.md	3691	0644	edit dl rm
methodology-mapping.md	2471	0644	edit dl rm
next-implementation-step.md	1304	0644	edit dl rm
trello-admin-setup.md	2175	0644	edit dl rm

Edit: /home/techb158/trellopowerup.abdallabala.com/docs/32-vps-deployment-guide.md (3697B)

# VPS Deployment Guide for Trello Power-Up

This guide deploys the COSMIC AI-Risk Trello Power-Up to a VPS with Docker Compose and an HTTPS reverse proxy.

## Requirements

- VPS with Ubuntu/Debian or similar Linux.
- A domain or subdomain pointed to the VPS, for example `trello.yourdomain.com`.
- Docker and Docker Compose installed.
- Nginx or another reverse proxy with HTTPS.
- Trello Power-Up API key.

Trello requires the connector URL and iframe pages to load over HTTPS.

## Files Added for VPS

- `docker-compose.vps.yml` - VPS-friendly Compose file.
- `.dockerignore` - keeps `node_modules`, `.env`, `data`, and logs out of the Docker build context.

## Local Upload Option

From your local project folder, create an archive that excludes runtime files:

```bash
tar --exclude=node_modules --exclude=data --exclude=.env --exclude=.git -czf cosmic-trello-powerup.tar.gz .
```

Upload it to the VPS:

```bash
scp cosmic-trello-powerup.tar.gz USER@SERVER_IP:/opt/
```

On the VPS:

```bash
sudo mkdir -p /opt/cosmic-trello-powerup
sudo tar -xzf /opt/cosmic-trello-powerup.tar.gz -C /opt/cosmic-trello-powerup
cd /opt/cosmic-trello-powerup
```

## VPS Environment File

Create `/opt/cosmic-trello-powerup/.env`:

```env
PORT=3000
HOST_PORT=3000
PUBLIC_BASE_URL=https://trello.yourdomain.com
TRELLO_API_KEY=replace_with_power_up_api_key
TRELLO_APP_NAME=COSMIC AI-Risk Management
ALLOWED_ORIGINS=https://trello.com,https://*.trello.com,https://trello.yourdomain.com
COSMIC_STORE_FILE=./data/store.json
COSMIC_REVIEW_STALE_DAYS=30
```

Create runtime storage:

```bash
mkdir -p data
```

## Build and Start

```bash
docker compose -f docker-compose.vps.yml up -d --build
```

Check status:

```bash
docker compose -f docker-compose.vps.yml ps
docker compose -f docker-compose.vps.yml logs -f
```

Health check from the VPS:

```bash
curl http://127.0.0.1:3000/api/health
```

Expected version is currently `0.4.5`.

## Nginx Reverse Proxy Example

Create `/etc/nginx/sites-available/trello-powerup`:

```nginx
server {
    listen 80;
    server_name trello.yourdomain.com;

location / {
        proxy_pass http://127.0.0.1:3000;
        proxy_http_version 1.1;
        proxy_set_header Host $host;
        proxy_set_header X-Real-IP $remote_addr;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_set_header X-Forwarded-Proto $scheme;
    }
}
```

Enable it:

```bash
sudo ln -s /etc/nginx/sites-available/trello-powerup /etc/nginx/sites-enabled/trello-powerup
sudo nginx -t
sudo systemctl reload nginx
```

Add HTTPS with Certbot:

```bash
sudo certbot --nginx -d trello.yourdomain.com
```

After HTTPS is active, verify:

```bash
curl https://trello.yourdomain.com/api/health
```

## Trello Power-Up Admin

In Trello Power-Up admin, set connector URL to:

```text
https://trello.yourdomain.com/index.html
```

Enable these capabilities:

- `authorization-status`
- `show-authorization`
- `show-settings`
- `board-buttons`
- `card-buttons`
- `card-badges`
- `card-detail-badges`
- `card-back-section`

Then add the Power-Up to a Trello board and set the COSMIC API base URL to:

```text
https://trello.yourdomain.com
```

## Update Deployment Later

Upload the new archive, then on the VPS:

```bash
cd /opt/cosmic-trello-powerup
docker compose -f docker-compose.vps.yml up -d --build
```

The `./data` folder is mounted into the container, so local JSON runtime data survives rebuilds.

## Notes

- JSON storage is acceptable for prototype VPS testing.
- For production multi-user usage, replace JSON storage with PostgreSQL or another managed database.
- Do not commit `.env` or upload local `data` unless you intentionally want to migrate runtime data.

cmd: