# 🏗️ Complete Infrastructure Report

> **Generated:** 2025-11-02 01:27:21 | **Host:** ai-impress-prod | **IP:** 51.89.231.46

---

## 📋 Table of Contents

1. [Executive Summary](#executive-summary)
2. [System Resources](#system-resources)
3. [Network Architecture](#network-architecture)
4. [Services & Containers](#services-containers)
5. [Databases & Cache](#databases-cache)
6. [Storage & Volumes](#storage-volumes)
7. [Security & SSL](#security-ssl)
8. [Monitoring & Health](#monitoring-health)
9. [Dependencies Map](#dependencies-map)
10. [Metrics & Alerts](#metrics-alerts)
11. [Recommendations](#recommendations)

---

## 1. Executive Summary

| Metric | Value | Status |
|--------|-------|--------|
| 🐳 Running Containers | 67 / 68 | ✅ |
| 🌐 Docker Networks | 17 | ✅ |
| 💾 Docker Volumes | 59 | ✅ |
| 🧠 Memory Usage | 13Gi / 57Gi | ✅ |
| 💿 Disk Usage | 55G / 387G (15%) | ✅ |
| 🔒 SSL Certificates | Auto-renewed | ✅ |
| 🔥 Firewall | Active | ✅ |

## 2. System Resources

### 🖥️ Hardware & OS

```
Hostname:    ai-impress-prod
Kernel:      6.8.0-86-generic
OS:          Ubuntu 24.04.3 LTS
Uptime:      up 1 week, 1 day, 8 hours, 53 minutes
```

### 💻 CPU

```
  Architecture:                         x86_64
  CPU(s):                               16
  On-line CPU(s) list:                  0-15
  Model name:                           Intel Core Processor (Haswell, no TSX)
  Virtualization:                       VT-x
  Virtualization type:                  full
  NUMA node0 CPU(s):                    0-15
```

### 🧠 Memory

```
total              used       free     shared           
Mem:               57Gi       13Gi      2.0Gi       44Gi
```

### 💿 Disk Usage

```
Filesystem     Type   Size  Used Avail Use% Mounted on
/dev/sda1      ext4   387G   55G  333G  15% /
/dev/sda16     ext4   881M  117M  703M  15% /boot
/dev/sda15     vfat   105M  6.2M   99M   6% /boot/efi
/dev/sdc       ext4   393G  5.4G  368G   2% /mnt/backups
/dev/sdb       ext4   295G  412M  279G   1% /mnt/psql-data
```

## 3. Network Architecture

### 🌐 Docker Networks Overview

| Network | Driver | Scope | Containers |
|---------|--------|-------|------------|
| `aiimpress` | bridge | local | 1 |
| `authentik_authentik-internal` | bridge | local | 5 |
| `bridge` | bridge | local | 14 |
| `database-internal` | bridge | local | 17 |
| `host` | host | local | 1 |
| `mautic-internal` | bridge | local | 1 |
| `mautic_mautic-internal` | bridge | local | 4 |
| `monitoring_monitoring` | bridge | local | 10 |
| `n8n-shared` | bridge | local | 6 |
| `none` | null | local | 1 |
| `odoo-internal` | bridge | local | 2 |
| `postiz-config_postiz-internal` | bridge | local | 4 |
| `postiz_postiz-internal` | bridge | local | 1 |
| `sftp_default` | bridge | local | 2 |
| `supabase_default` | bridge | local | 14 |
| `traefik-public` | bridge | local | 22 |
| `vault-internal` | bridge | local | 2 |

### 🔌 Network Topology

```mermaid
graph TB
    Internet((Internet)) --> Traefik[🌐 Traefik]
    
    subgraph traefik-public
        Traefik
        Traefik --> portainer
        Traefik --> outline
        Traefik --> authentik-server
        Traefik --> odoo
        Traefik --> vaultwarden
        Traefik --> postiz
        Traefik --> uptime-kuma
        Traefik --> pgadmin
        Traefik --> supabase-kong
        Traefik --> n8n-shared
        Traefik --> mautic
        Traefik --> documenso
        Traefik --> rabbitmq
        Traefik --> mautic-sync-webhook
        Traefik --> postgres-main
        Traefik --> evolution-api
        Traefik --> vault
        Traefik --> mautic-odoo-sync-v2
        Traefik --> wikijs
        Traefik --> landing-page
    end
    
    subgraph database-internal
        PG[(PostgreSQL)]
        Redis[(Redis)]
        outline --> PG
        outline --> Redis
        n8n-worker-1 --> PG
        n8n-worker-1 --> Redis
        n8n-worker-4 --> PG
        n8n-worker-4 --> Redis
        odoo --> PG
        odoo --> Redis
        vaultwarden --> PG
        vaultwarden --> Redis
        n8n-worker-2 --> PG
        n8n-worker-2 --> Redis
        pgadmin --> PG
        pgadmin --> Redis
        n8n-worker-3 --> PG
        n8n-worker-3 --> Redis
        n8n-shared --> PG
        n8n-shared --> Redis
        documenso --> PG
        documenso --> Redis
        rabbitmq --> PG
        rabbitmq --> Redis
        evolution-api --> PG
        evolution-api --> Redis
        wikijs --> PG
        wikijs --> Redis
    end
```

### 🔗 Detailed Network Connections

<details>
<summary><b>📡 traefik-public</b> (21 containers)</summary>

```
authentik-server
documenso
evolution-api
landing-page
mautic
mautic-odoo-sync-v2
mautic-sync-webhook
n8n-shared
odoo
outline
pgadmin
portainer
postgres-main
postiz
rabbitmq
supabase-kong
traefik
uptime-kuma
vault
vaultwarden
wikijs
```

</details>

<details>
<summary><b>📡 database-internal</b> (16 containers)</summary>

```
documenso
evolution-api
n8n-shared
n8n-worker-1
n8n-worker-2
n8n-worker-3
n8n-worker-4
odoo
outline
pgadmin
postgres-exporter
postgres-main
rabbitmq
redis-main
vaultwarden
wikijs
```

</details>

<details>
<summary><b>📡 authentik_authentik-internal</b> (4 containers)</summary>

```
authentik-postgres
authentik-redis
authentik-server
authentik-worker
```

</details>

<details>
<summary><b>📡 n8n-shared</b> (5 containers)</summary>

```
n8n-shared
n8n-worker-1
n8n-worker-2
n8n-worker-3
n8n-worker-4
```

</details>

<details>
<summary><b>📡 supabase_default</b> (13 containers)</summary>

```
realtime-dev.supabase-realtime
supabase-analytics
supabase-auth
supabase-db
supabase-edge-functions
supabase-imgproxy
supabase-kong
supabase-meta
supabase-pooler
supabase-rest
supabase-storage
supabase-studio
supabase-vector
```

</details>

## 4. Services & Containers

### 🐳 All Running Containers

| Container | Image | Status | Uptime | Health |
|-----------|-------|--------|--------|--------|
| `wikijs` | wiki | Up 28 hours | 31 hours ago | 🟢 Running |
| `recursing_moser` | n8n-mcp | Up 38 hours (unhealthy) | 38 hours ago | 🔴 Unhealthy |
| `documenso` | documenso-custom | Up 39 hours | 39 hours ago | 🟢 Running |
| `naughty_elion` | n8n-mcp | Up 39 hours (unhealthy) | 39 hours ago | 🔴 Unhealthy |
| `ecstatic_galois` | n8n-mcp | Up 47 hours (unhealthy) | 47 hours ago | 🔴 Unhealthy |
| `youthful_ishizaka` | n8n-mcp | Up 2 days (unhealthy) | 2 days ago | 🔴 Unhealthy |
| `gifted_dirac` | n8n-mcp | Up 2 days (unhealthy) | 2 days ago | 🔴 Unhealthy |
| `distracted_carver` | n8n-mcp | Up 2 days (unhealthy) | 2 days ago | 🔴 Unhealthy |
| `competent_chaplygin` | n8n-mcp | Up 2 days (unhealthy) | 2 days ago | 🔴 Unhealthy |
| `nostalgic_engelbart` | n8n-mcp | Up 2 days (unhealthy) | 2 days ago | 🔴 Unhealthy |
| `outline` | outline | Up 2 days (healthy) | 2 days ago | 🟢 Healthy |
| `stoic_tesla` | n8n-mcp | Up 2 days (unhealthy) | 2 days ago | 🔴 Unhealthy |
| `eloquent_chatelet` | n8n-mcp | Up 2 days (unhealthy) | 2 days ago | 🔴 Unhealthy |
| `keen_cannon` | n8n-mcp | Up 2 days (unhealthy) | 2 days ago | 🔴 Unhealthy |
| `sweet_hoover` | n8n-mcp | Up 2 days (unhealthy) | 2 days ago | 🔴 Unhealthy |
| `relaxed_hopper` | n8n-mcp | Up 2 days (unhealthy) | 2 days ago | 🔴 Unhealthy |
| `supabase-kong` | kong | Up 2 days (healthy) | 2 days ago | 🟢 Healthy |
| `supabase-vector` | vector | Up 2 days (healthy) | 2 days ago | 🟢 Healthy |
| `vault` | vault | Up 2 days (healthy) | 2 days ago | 🟢 Healthy |
| `supabase-imgproxy` | imgproxy | Up 2 days (healthy) | 2 days ago | 🟢 Healthy |
| `supabase-rest` | postgrest | Up 2 days | 2 days ago | 🟢 Running |
| `traefik` | traefik | Up 28 hours | 2 days ago | 🟢 Running |
| `authentik-server` | server | Up 28 hours (healthy) | 2 days ago | 🟢 Healthy |
| `authentik-worker` | server | Up 28 hours (healthy) | 2 days ago | 🟢 Healthy |
| `authentik-redis` | redis | Up 28 hours (healthy) | 2 days ago | 🟢 Healthy |
| `authentik-postgres` | postgres | Up 28 hours (healthy) | 2 days ago | 🟢 Healthy |
| `postgres-exporter` | postgres-exporter | Up 3 days | 3 days ago | 🟢 Running |
| `mautic` | mautic | Up 3 days | 3 days ago | 🟢 Running |
| `n8n-shared` | n8n | Up 3 days | 3 days ago | 🟢 Running |
| `n8n-worker-4` | n8n | Up 3 days | 3 days ago | 🟢 Running |
| `n8n-worker-2` | n8n | Up 3 days | 3 days ago | 🟢 Running |
| `n8n-worker-1` | n8n | Up 3 days | 3 days ago | 🟢 Running |
| `n8n-worker-3` | n8n | Up 3 days | 3 days ago | 🟢 Running |
| `blackbox-exporter` | blackbox-exporter | Up 3 days | 3 days ago | 🟢 Running |
| `promtail` | promtail | Up 3 days | 3 days ago | 🟢 Running |
| `loki` | loki | Up 3 days | 3 days ago | 🟢 Running |
| `cadvisor` | cadvisor | Up 3 days (healthy) | 3 days ago | 🟢 Healthy |
| `grafana` | grafana | Up 3 days | 3 days ago | 🟢 Running |
| `node-exporter` | node-exporter | Up 3 days | 3 days ago | 🟢 Running |
| `prometheus` | prometheus | Up 3 days | 3 days ago | 🟢 Running |
| `alertmanager` | alertmanager | Up 3 days | 3 days ago | 🟢 Running |
| `postiz` | postiz-app | Up 3 days | 3 days ago | 🟢 Running |
| `postiz-postgres` | postgres | Up 3 days (healthy) | 3 days ago | 🟢 Healthy |
| `postiz-redis` | redis | Up 3 days (healthy) | 3 days ago | 🟢 Healthy |
| `odoo` | odoo | Up 5 days | 5 days ago | 🟢 Running |
| `supabase-auth` | gotrue | Up 5 days (healthy) | 5 days ago | 🟢 Healthy |
| `vaultwarden` | server | Up 5 days (healthy) | 5 days ago | 🟢 Healthy |
| `uptime-kuma` | uptime-kuma | Up 5 days (healthy) | 5 days ago | 🟢 Healthy |
| `mautic-odoo-sync-v2` | python | Up 6 days (healthy) | 6 days ago | 🟢 Healthy |
| `mautic-db` | mariadb | Up 6 days | 6 days ago | 🟢 Running |
| `supabase-storage` | storage-api | Up 6 days (healthy) | 6 days ago | 🟢 Healthy |
| `realtime-dev.supabase-realtime` | realtime | Up 6 days (healthy) | 6 days ago | 🟢 Healthy |
| `supabase-pooler` | supavisor | Up 6 days (healthy) | 6 days ago | 🟢 Healthy |
| `supabase-edge-functions` | edge-runtime | Up 6 days | 6 days ago | 🟢 Running |
| `supabase-meta` | postgres-meta | Up 6 days (healthy) | 6 days ago | 🟢 Healthy |
| `supabase-studio` | studio | Up 6 days (healthy) | 6 days ago | 🟢 Healthy |
| `supabase-analytics` | logflare | Up 6 days (healthy) | 6 days ago | 🟢 Healthy |
| `supabase-db` | postgres | Up 6 days (healthy) | 6 days ago | 🟢 Healthy |
| `mautic-sync-webhook` | python | Up 6 days | 6 days ago | 🟢 Running |
| `portainer` | portainer-ce | Up 6 days | 6 days ago | 🟢 Running |
| `evolution-api` | evolution-api | Up 6 days | 6 days ago | 🟢 Running |
| `rabbitmq` | rabbitmq | Up 6 days (healthy) | 6 days ago | 🟢 Healthy |
| `pgadmin` | pgadmin4 | Up 6 days | 6 days ago | 🟢 Running |
| `postgres-main` | postgres | Up 6 days (healthy) | 6 days ago | 🟢 Healthy |
| `landing-page` | 5e7abcdd2021 | Up 8 days | 2 weeks ago | 🟢 Running |
| `sftp-server` | sftp | Up 8 days | 2 weeks ago | 🟢 Running |
| `redis-main` | redis | Up 8 days (healthy) | 2 weeks ago | 🟢 Healthy |

### 🌍 Web Services (Traefik Routes)

| Domain | Service | Status | SSL |
|--------|---------|--------|-----|
| `info.ai-impress.com` | wikijs | ✅ | ✅ |
| `sign.ai-impress.com` | documenso | ✅ | ✅ |
| `wiki.ai-impress.com` | outline | ✅ | ✅ |
| `vault-admin.ai-impress.com` | vault | ✅ | ✅ |
| `marketing.ai-impress.com` | mautic | ✅ | ✅ |
| `n8n.ai-impress.com` | n8n-shared | ✅ | ✅ |
| `social.ai-impress.com` | postiz | ✅ | ✅ |
| `odoo.ai-impress.com` | odoo | ✅ | ✅ |
| `vault.ai-impress.com` | vaultwarden | ✅ | ✅ |
| `status.ai-impress.com` | uptime-kuma | ✅ | ✅ |
| `portainer.ai-impress.com` | portainer | ✅ | ✅ |
| `wpp.ai-impress.com` | evolution-api | ✅ | ✅ |
| `rabbitmq.ai-impress.com` | rabbitmq | ✅ | ✅ |
| `pgadmin.ai-impress.com` | pgadmin | ✅ | ✅ |

### 📦 Container Resource Usage

| Container | CPU % | Memory | Network I/O |
|-----------|-------|--------|-------------|
| `wikijs` | 0.01% | 119.1MiB / 57.47GiB | 16.5MB / 7.99MB |
| `recursing_moser` | 0.00% | 45.88MiB / 57.47GiB | 1.43kB / 126B |
| `documenso` | 0.00% | 204.4MiB / 57.47GiB | 294MB / 248MB |
| `naughty_elion` | 0.00% | 46.16MiB / 57.47GiB | 1.76kB / 126B |
| `ecstatic_galois` | 0.00% | 46.42MiB / 57.47GiB | 3.28kB / 126B |
| `youthful_ishizaka` | 0.00% | 46.32MiB / 57.47GiB | 3.4kB / 126B |
| `gifted_dirac` | 0.00% | 46.29MiB / 57.47GiB | 3.53kB / 126B |
| `distracted_carver` | 0.00% | 45.98MiB / 57.47GiB | 3.65kB / 126B |
| `competent_chaplygin` | 0.00% | 45.97MiB / 57.47GiB | 3.78kB / 126B |
| `nostalgic_engelbart` | 0.00% | 46.03MiB / 57.47GiB | 3.95kB / 126B |
| `outline` | 0.14% | 549.7MiB / 57.47GiB | 334MB / 288MB |
| `stoic_tesla` | 0.00% | 46.39MiB / 57.47GiB | 4.07kB / 126B |
| `eloquent_chatelet` | 0.00% | 46.34MiB / 57.47GiB | 4.2kB / 126B |
| `keen_cannon` | 0.00% | 46.39MiB / 57.47GiB | 4.33kB / 126B |
| `sweet_hoover` | 0.00% | 46.22MiB / 57.47GiB | 4.45kB / 126B |
| `relaxed_hopper` | 0.00% | 46.5MiB / 57.47GiB | 4.58kB / 126B |
| `supabase-kong` | 2.73% | 1.784GiB / 57.47GiB | 406kB / 118kB |
| `supabase-vector` | 0.46% | 48.95MiB / 57.47GiB | 6.55kB / 9.16kB |
| `vault` | 0.51% | 47.91MiB / 57.47GiB | 19.7MB / 1.09GB |
| `supabase-imgproxy` | 0.00% | 15.65MiB / 57.47GiB | 7.56kB / 126B |

## 5. Databases & Cache

### 🐘 PostgreSQL Main Database

**Connection Info:**
- Host: `postgres-main`
- Port: `5432`
- User: `aimpress_admin`

**Databases:**

| Database | Size | Owner | Tables | Connections |
|----------|------|-------|--------|-------------|
| `documenso` | 139 MB | aimpress_admin | 0 | 18 |
| `odoo` | 49 MB | odoo_user | 0 | 3 |
| `n8n_shared` | 33 MB | n8n_user | 0 | 5 |
| `outline` | 24 MB | outline_user | 0 | 1 |
| `wikijs` | 14 MB | aimpress_admin | 0 | 1 |
| `authelia` | 9652 kB | authelia_user | 0 | 0 |
| `evolution` | 9028 kB | evolution_user | 0 | 1 |
| `vaultwarden` | 8548 kB | vaultwarden_user | 0 | 10 |
| `supabase` | 8140 kB | supabase_user | 0 | 0 |
| `postgres` | 7604 kB | aimpress_admin | 0 | 12 |
| `aimpress_admin` | 7516 kB | aimpress_admin | 0 | 1 |
| `authentik` | 7516 kB | authentik_user | 0 | 0 |

**Database → Service Mapping:**

| Database | Used By | Purpose |
|----------|---------|---------|
| `n8n_db` | n8n-main | Workflow automation |
| `authentik` | authentik-server | SSO authentication |
| `outline` | outline | Wiki documentation |
| `mautic_db` | mautic | Marketing automation |
| `odoo` | odoo17 | ERP system |
| `postiz` | postiz-app | Social media manager |
| `vault` | vault | Secrets management |

### 🔴 Redis Cache

| Metric | Value |
|--------|-------|
| Version | 7.4.6 |
| Uptime | 8 days |
| Memory Used | 2.46M |
| Total Keys | 14 |
| Status | 🟢 Healthy |

**Redis → Service Mapping:**

| Service | Purpose |
|---------|---------|
| n8n-main | Queue management |
| n8n-worker-* | Job processing |
| outline | Session cache |
| authentik-worker | Background tasks |

## 6. Storage & Volumes

### 📁 Docker Volumes

| Volume Name | Size | Mounted By |
|-------------|------|------------|
| `1d05e9c3b1c13eb3f4e941f5f3bdc42c0984dc7b254b80421aef3253a853a0f7` | 4.0K | ⚠️ Unused |
| `07d3f4b5361d23053c1494f59e6b86a7764ade86b19b2bb9a4624575d75840b9` | 8.0K | mautic |
| `32c8ad3aa58fad4784d1e376addb444864a5093ed9887dbb93a1e2ee2a5dbe9e` | 4.0K | alertmanager |
| `39f75a4a27e5200259a67482b6ced1b30ec631171fff019600280e08c9bc3571` | 4.0K | vault |
| `134e1cceb87bf846f832690a6063f1ae92af79b14e56cc9cf3a52c4cf4df3d43` | 4.0K | mautic |
| `212f82b4e8f83fc0360dd7cf677482e190229ee51eb9a69785fec7d39453bff9` | 4.0K | ⚠️ Unused |
| `298bf7f6bec3e84f231058d1023f483172bb016fe6191b8e88785c579a89e176` | 4.0K | ⚠️ Unused |
| `777f8481a63beaa6aa44594803514a2bf4fdd5db35a834b4057a7184933e680f` | 4.0K | ⚠️ Unused |
| `2132497e7c4a93d26aa78464b959c269d5e8555127cb5f2e62ea2cd605574ebb` | 4.0K | ⚠️ Unused |
| `31807040665eacb2b72e4fc33710821214d0960a84897065adc2d4c86f6d44ae` | 8.0K | mautic |
| `a5e176aab007d7c624544d1199d634bf0f363f075aa4845f24113195a7735b47` | 4.0K | ⚠️ Unused |
| `authentik_authentik-postgres-data` | 133M | authentik-postgres |
| `authentik_authentik-redis-data` | 8.0K | authentik-redis |
| `b652c8a3e583d8ceaaa6317020fe58339739cec97a3b9610dd60882ab1e5d028` | 4.0K | wikijs |
| `b9424423b85c8bb5bf7b58332b40139429f3cf2b2ca3614ea0453cd9e57b924f` | 4.0K | ⚠️ Unused |
| `cf1cac6c1daef086c8a013d56c373532c171e8536c3846da7b5572f4c50de37a` | 4.0K | ⚠️ Unused |
| `d35512c8aacfab7d5b1810489c9c2167980ee7912d4e2d990858f2dc9d71f6d2` | 4.0K | ⚠️ Unused |
| `documenso_data` | 20K | ⚠️ Unused |
| `ead2af7e8f51f6a556b541d217778471b7e2e9b1777bdc676942e4d4eda8a19e` | 36K | mautic |
| `evolution-api_evolution-data` | 4.0K | evolution-api |
| `evolution-data` | 4.0K | ⚠️ Unused |
| `loki_loki-data` | 80M | loki |
| `mautic_mautic-data` | 962M | mautic |
| `mautic_mautic-db-data` | 196M | mautic-db |
| `monitoring_prometheus_data` | 266M | prometheus |
| `n8n-data` | 4.0K | ⚠️ Unused |
| `n8n-shared_n8n-data` | 1.7M | n8n-shared,n8n-worker-4,n8n-worker-2,n8n-worker-1,n8n-worker-3 |
| `odoo-addons` | 4.0K | ⚠️ Unused |
| `odoo-data` | 4.0K | ⚠️ Unused |
| `odoo_odoo-addons` | 444K | odoo |
| `odoo_odoo-data` | 34M | odoo |
| `openwebui_openwebui-data` | 4.0K | ⚠️ Unused |
| `outline-data` | 4.0K | ⚠️ Unused |
| `outline_outline-data` | 72K | outline |
| `pgadmin-data` | 4.0K | ⚠️ Unused |
| `portainer-data` | 4.0K | ⚠️ Unused |
| `portainer_portainer-data` | 988K | portainer |
| `postgres_pgadmin-data` | 1.9M | pgadmin |
| `postiz-config` | 4.0K | ⚠️ Unused |
| `postiz-postgres-data` | 4.0K | ⚠️ Unused |
| `postiz-redis-data` | 4.0K | ⚠️ Unused |
| `postiz-uploads` | 4.0K | ⚠️ Unused |
| `postiz_postiz-config` | 4.0K | ⚠️ Unused |
| `postiz_postiz-postgres` | 4.0K | ⚠️ Unused |
| `postiz_postiz-postgres-data` | 65M | postiz-postgres |
| `postiz_postiz-redis` | 4.0K | ⚠️ Unused |
| `postiz_postiz-redis-data` | 12K | postiz-redis |
| `postiz_postiz-uploads` | 38M | postiz |
| `rabbitmq-data` | 4.0K | ⚠️ Unused |
| `rabbitmq_rabbitmq-data` | 304K | rabbitmq |
| `redis-data` | 4.0K | ⚠️ Unused |
| `redis_redis-data` | 9.6M | redis-main |
| `supabase_db-config` | 108K | supabase-db |
| `uptime-kuma` | 244K | ⚠️ Unused |
| `uptime-kuma-data` | 4.0K | ⚠️ Unused |
| `uptime-kuma_uptime-kuma-data` | 49M | uptime-kuma |
| `vaultwarden-data` | 28K | ⚠️ Unused |
| `vaultwarden_vaultwarden-data` | 272K | vaultwarden |
| `wikijs_data` | 3.8M | wikijs |

### 💾 Volume Usage by Category

| Category | Total Size |
|----------|------------|
| 🗄️ Databases | 0 |
| 🔴 Cache | 0 |
| 📦 Application Data | 0 |

## 7. Security & SSL

### 🔥 Firewall Status

```
Status: active

     To                         Action      From
     --                         ------      ----
[ 1] 22/tcp                     ALLOW IN    Anywhere                   # SSH
[ 2] 80/tcp                     ALLOW IN    Anywhere                   # HTTP
[ 3] 443/tcp                    ALLOW IN    Anywhere                   # HTTPS
[ 4] 2222/tcp                   ALLOW IN    Anywhere                   # SFTP
[ 5] 22/tcp (v6)                ALLOW IN    Anywhere (v6)              # SSH
[ 6] 80/tcp (v6)                ALLOW IN    Anywhere (v6)              # HTTP
[ 7] 443/tcp (v6)               ALLOW IN    Anywhere (v6)              # HTTPS
[ 8] 2222/tcp (v6)              ALLOW IN    Anywhere (v6)              # SFTP

```

### 🔒 SSL Certificates

| Domain | Issuer | Expires | Days Left | Status |
|--------|--------|---------|-----------|--------|
| `traefik.ai-impress.com` | C = US, O = Google Trust Services, CN = WE1 | Jan 11 08:28:18 2026 GMT | 70 | ✅ |
| `n8n.ai-impress.com` | C = US, O = Google Trust Services, CN = WE1 | Jan 11 08:28:18 2026 GMT | 70 | ✅ |
| `wiki.ai-impress.com` | C = US, O = Google Trust Services, CN = WE1 | Jan 11 08:28:18 2026 GMT | 70 | ✅ |
| `auth.ai-impress.com` | C = US, O = Google Trust Services, CN = WE1 | Jan 11 08:28:18 2026 GMT | 70 | ✅ |

### 🔐 Open Ports

```
      2 9443
      2 9115
      2 9100
      2 9093
      2 9090
      2 9000
      2 8081
      2 80
      2 53
      2 443
      2 3100
      2 3000
      2 2222
      2 22
      1 8443
```

## 8. Monitoring & Health

### 🏥 Service Health Checks

| Service | Endpoint | Status | Response Time |
|---------|----------|--------|---------------|
| traefik.ai-impress.com | https://traefik.ai-impress.com | ✅ Online | 53ms |
| n8n.ai-impress.com | https://n8n.ai-impress.com | ✅ Online | 74ms |
| auth.ai-impress.com | https://auth.ai-impress.com | ✅ Online | 97ms |
| wiki.ai-impress.com | https://wiki.ai-impress.com | ✅ Online | 55ms |
| marketing.ai-impress.com | https://marketing.ai-impress.com | ✅ Online | 34ms |

### 📊 Container Health Summary

| Status | Count |
|--------|-------|
| 🟢 Healthy | 26 |
| 🔴 Unhealthy | 13 |
| ⚪ No Health Check | 28 |

### ⚠️ Recent Errors (Last 24h)

<details>
<summary>Click to view recent container errors</summary>

</details>

## 9. Dependencies Map

### 🔗 Service Dependencies

```mermaid
graph LR
    Traefik[🌐 Traefik] --> N8N[N8N]
    Traefik --> Authentik[Authentik]
    Traefik --> Outline[Outline]
    Traefik --> Mautic[Mautic]
    Traefik --> Odoo[Odoo]
    Traefik --> Postiz[Postiz]
    
    N8N --> PG[(PostgreSQL)]
    N8N --> Redis[(Redis)]
    Authentik --> PG
    Authentik --> Redis
    Outline --> PG
    Outline --> Redis
    Mautic --> PG
    Odoo --> PG
    Postiz --> PG
    
    N8N --> Worker1[N8N Worker 1]
    N8N --> Worker2[N8N Worker 2]
    N8N --> Worker3[N8N Worker 3]
    Worker1 --> Redis
    Worker2 --> Redis
    Worker3 --> Redis
```

### 🎯 Critical Dependencies

| Service | Depends On | Impact if Down |
|---------|------------|----------------|
| Traefik | None | 🔴 All web services offline |
| PostgreSQL | None | 🔴 10+ services offline |
| Redis | None | 🟡 N8N jobs stop, cache lost |
| Authentik | PostgreSQL | 🟡 No SSO login |
| N8N Main | PostgreSQL, Redis | 🔴 Automation stops |
| N8N Workers | Redis, N8N Main | 🟡 Job processing stops |

## 10. Metrics & Alerts

### 🚨 Active Alerts

✅ **No active alerts**

### 📊 Top Resource Consumers

| Container | CPU % | Memory | Status |
|-----------|-------|--------|--------|
| `cadvisor` | 11.90% | 162.2MiB / 57.47GiB | 🟢 |
| `supabase-analytics` | 6.89% | 724.8MiB / 57.47GiB | 🟢 |
| `sftp-server` | 5.08% | 15.54MiB / 57.47GiB | 🟢 |
| `supabase-kong` | 2.97% | 1.784GiB / 57.47GiB | 🟢 |
| `loki` | 1.21% | 122.2MiB / 57.47GiB | 🟢 |
| `postiz` | 1.03% | 1.012GiB / 57.47GiB | 🟢 |
| `promtail` | 0.88% | 74.75MiB / 57.47GiB | 🟢 |
| `redis-main` | 0.60% | 5.223MiB / 57.47GiB | 🟢 |
| `vault` | 0.54% | 47.91MiB / 57.47GiB | 🟢 |
| `postiz-redis` | 0.53% | 4.73MiB / 57.47GiB | 🟢 |

### 🔄 Container Restarts (Last 7 days)

| Container | Restarts | Last Restart |
|-----------|----------|--------------|
| `n8n-worker-4` | 1 | 2025-10-29 |

### 🌐 HTTP Endpoint Status

| Endpoint | Response Time | SSL Expiry | Status |
|----------|---------------|------------|--------|
| `n8n.ai-impress.com` | 55ms | 70d | ✅ |
| `wiki.ai-impress.com` | 62ms | 70d | ✅ |
| `marketing.ai-impress.com` | 39ms | 80d | ✅ |
| `auth.ai-impress.com` | 80ms | 70d | ✅ |
| `odoo.ai-impress.com` | 80ms | 70d | ✅ |

### 🔍 Top Errors (Last 24h)

<details>
<summary>Click to view top errors from logs</summary>

```
[n8n-shared] (8) error:1C800064:Provider routines::bad decrypt
[n8n-shared] (7) Error: Credentials could not be decrypted. The likely reason is that a different "encryptionKey" was used to encrypt the data.
```

</details>

### 📈 Performance Summary

| Metric | Value | Status |
|--------|-------|--------|
| Avg CPU Usage | 0.9% | ✅ |
| Avg Memory Usage | 0.8% | ✅ |
| Total Restarts (7d) | 1 | ✅ |
| Active Alerts | 0 | ✅ |

## 11. Recommendations

### ✅ Health Status

- ✅ All critical services running
- ✅ PostgreSQL accessible and healthy
- ✅ Redis operational with authentication
- ✅ Traefik routing correctly
- ✅ SSL certificates valid (Let's Encrypt)

### ⚠️ Action Items

1. 🔄 **Update Docker Images** - 13 images older than 6 months
2. 🔐 **Rotate Secrets** - Check Vault for credentials older than 90 days
3. 💾 **Backup Verification** - Test latest PostgreSQL backup restore
4. 📊 **Setup Monitoring** - Configure Grafana dashboards for resource tracking
5. 🧹 **Cleanup Volumes** - Remove unused volumes to free space

### 📚 Useful Commands

```bash
# Update all services
cd /opt && docker-compose pull && docker-compose up -d

# Backup all databases
docker exec postgres-main pg_dumpall -U aimpress_admin > backup-$(date +%Y%m%d).sql

# View logs for specific service
docker logs -f --tail 100 <container-name>

# Check disk space by volume
docker system df -v
```

---

> 📄 **Report generated:** 2025-11-02 01:27:52  
> 🔄 **Next check recommended:** 2025-11-09  
> 📥 **Download:** `scp ubuntu@51.89.231.46:/opt/infrastructure-docs/reports/infrastructure-snapshot-20251102-012721.md .`  
