Migration Status & Audit

Tip

Last updated: 2026-03-26 12:30 CET. This document is the single source of truth for the full platform migration. Every container, database, domain, and issue is listed — nothing is summarized or hidden.

---

Executive Summary

The Magic e-VERSE platform has been migrated from a legacy bare-metal server (Nginx + Docker Compose, 58 containers) to a new Contabo VPS running Coolify v4 (Traefik + automated Docker deployments, 101 running containers). The migration spans 10 phases, of which phases 1–9 are complete and phase 10 (DNS cutover) is planned.

Metric	Old Server	New Server
IP	83.86.98.93 (SSH port 22022)	159.195.68.41 (SSH port 22)
OS	Ubuntu 24.04 LTS	Debian 13 (Trixie)
Hardware	8 cores, 32 GB RAM, 1 TB	12 cores, 32 GB RAM, 1 TB
Disk Usage	87% (29 GB free)	31% (669 GB free)
RAM Usage	—	19 GB / 31 GB (no swap)
Reverse Proxy	Nginx (108 site configs)	Traefik v3.6 (Docker labels, auto-SSL)
Container Orchestration	Docker Compose (manual)	Coolify v4.0.0-beta.469 (Git-based deploys)
Domain	*.magiceverse.online	*.magicomniverse.online
Running Containers	58	101
PostgreSQL Databases	54	54
MySQL Databases	9	9
SSL	Let’s Encrypt via Certbot	Let’s Encrypt via Traefik (automatic)
Monitoring	Glances (port 61208)	Netdata (monitor.magicomniverse.online)

---

Phase Overview

Phase	Description	Status	Date
1	Monorepo setup (midego1/Magic-e-VERSE) + GitHub App	Done	2026-03-24
2	Coolify install + Brinxx tenant (template)	Done	2026-03-24
2b	Magic Access auth proxy + Netdata monitoring	Done	2026-03-24
3	Feature flag integration (27 features, 21 API guards)	Done	2026-03-24
4	N8N (4 instances), AI Agents (10), Redis, Supporting services	Done	2026-03-25
5a	Internal commerce tenants (development, demo, default, master)	Done	2026-03-25
5b	Client commerce tenants (bovisales, jodasign, logohorloge, spranz)	Done	2026-03-26
5c	Backend-only tenants (desluis, toolvizion)	Done	2026-03-26
6	PIM system migration (189 tables, 11,254 products)	Done	2026-03-26
7	Portal + MySQL migration	Done	2026-03-26
8	Business services (Connector, Contact)	Done	2026-03-26
9	Tools (Editor, 3D, Logo, Modal, Moodshot, Resize)	Done	2026-03-26
10	DNS cutover + old server decommission	Planned	TBD

---

Remediation Log (Post-Migration Fixes)

Every issue found and fixed during the migration audit:

#	Issue	Severity	Root Cause	Fix	Status
R1	Brinxx backend 500	HIGH	Stale link_module_migrations rows + missing Traefik middleware magic-forward-auth@docker	Truncated migration table; created Docker helper container to register middleware	Fixed
R2	Default backend 500	HIGH	Same stale migration rows	Truncated link_module_migrations	Fixed
R3	Toolvizion SSL/503	HIGH	Already resolved before audit	N/A	Fixed
R4	Portal 500 after login	CRITICAL	MySQL session store used 172.17.0.1 (Docker bridge gateway) — unreachable from Coolify network. Duplicate magic-portal container caused Traefik round-robin	Changed MySQL host to mysql (Docker DNS); removed duplicate container; pushed fix to midego1/Magic-Portal repo	Fixed
R5	Spranz storefront missing 14+ branded files	CRITICAL	Tenant-specific files never committed to monorepo	Created tenants/spranz/storefront/ overlay (20 files) with custom Dockerfile; merged to main via PR #7	Fixed
R6	18 missing Spranz products	MEDIUM	Products added after initial DB dump	Exported 18 products + 225 related rows from old server, imported to new	Fixed
R7	Missing user_rbac_role table (Spranz)	MEDIUM	Table not in original dump	Created from old server schema + data	Fixed
R8	MySQL magic_doc — 59 empty tables	CRITICAL	Only schema was migrated, not data	Full mysqldump from old server imported — 22 tables now have data	Fixed
R9	Missing user_rbac_role in 5 tenant DBs (bovisales, desluis, jodasign, logohorloge, toolvizion)	MEDIUM	Table not in original dump	Created empty table with correct schema + indexes on all 5 DBs	Fixed
R10	Jodasign missing 143 quotation headers + 410 quotation lines	HIGH	Data added after initial DB dump	Truncated + reimported all APLT data (231 headers, 630 lines, 21 order headers, 92 order lines)	Fixed
R11	18 missing products in 6 tenant DBs (default, demo, bovisales, desluis, jodasign, development)	MEDIUM	Products added after initial DB dump	Exported missing products + all related rows (variants, options, images, prices, categories) per tenant	Fixed
R12	52 missing products + 144 variants in Brinxx	MEDIUM	Products added after initial DB dump	Exported + imported with all related data (options, variants, prices, categories)	Fixed
R13	Magic Terminal not deployed	LOW	Repo not added to GitHub App	Deployed as Coolify app	Fixed
R14	magic_agent_maw / mawordering DBs missing	LOW	Legacy/unused databases	Intentionally skipped	Wontfix
R15	Flowbuilder 404 on root	LOW	API-only service, no root route handler	Expected behavior — API endpoints work on /api/ paths	Wontfix

---

Server Architecture — New Server

┌──────────────────────────────────────────────────────────────────┐
│  Coolify v4.0.0-beta.469 — 159.195.68.41 (Debian 13)           │
│  12 cores | 32 GB RAM | 1 TB disk (31% used)                    │
│  101 running containers | 0 exited containers                    │
│                                                                  │
│  ┌────────────────────────────────────────────────────────────┐  │
│  │  Traefik v3.6 (reverse proxy)                              │  │
│  │  - Docker provider (auto-discovers container labels)       │  │
│  │  - Let's Encrypt auto-SSL (certresolver: letsencrypt)      │  │
│  │  - HTTP→HTTPS redirect on all routes                       │  │
│  │  - gzip compression middleware                             │  │
│  └──────────────┬─────────────────────────────────────────────┘  │
│                 │                                                │
│  ┌──────────────▼──────────────────────────────────────────────┐ │
│  │  Commerce Tenants (11 tenants × 1-3 containers each)       │ │
│  │                                                             │ │
│  │  brinxx      │ backend + storefront + redis                │ │
│  │  default     │ backend + storefront + redis                │ │
│  │  demo        │ backend + storefront + redis                │ │
│  │  bovisales   │ backend + storefront + redis                │ │
│  │  jodasign    │ backend + storefront + redis                │ │
│  │  logohorloge │ backend + storefront + redis                │ │
│  │  spranz      │ backend + storefront + redis                │ │
│  │  development │ backend + storefront + redis                │ │
│  │  desluis     │ backend + redis (no storefront)             │ │
│  │  toolvizion  │ backend + redis (no storefront)             │ │
│  │  master      │ backend + redis (no storefront)             │ │
│  └─────────────────────────────────────────────────────────────┘ │
│                                                                  │
│  ┌─────────────┐  ┌─────────────┐  ┌────────────────────────┐  │
│  │ magic-postgres│  │   mysql    │  │  Redis (13 instances)  │  │
│  │ PostgreSQL 16│  │  MySQL 8   │  │  Only brinxx-redis     │  │
│  │ 54 databases │  │  9 databases│  │  has healthcheck       │  │
│  └─────────────┘  └─────────────┘  └────────────────────────┘  │
│                                                                  │
│  ┌─────────────────────┐  ┌──────────────────────────────────┐  │
│  │  AI Agents (10)     │  │  N8N Instances (4)               │  │
│  │  + 2 Redis          │  │  n8n-main, n8n-2, n8n-3,        │  │
│  │  + flowbuilder      │  │  n8n-clean                       │  │
│  │  + escalation       │  │                                  │  │
│  │  + webhook-server   │  └──────────────────────────────────┘  │
│  │  + widget-server    │                                        │
│  └─────────────────────┘                                        │
│                                                                  │
│  ┌──────────────────────────────────────────────────────────┐   │
│  │  Other Services                                          │   │
│  │  Portal (:4096) | PIM (:9000) | Connector | Contact     │   │
│  │  Editor | 3D | Logo | Modal | Moodshot | Resize          │   │
│  │  Terminal (Sshwifty :8182) | Netdata (:19999)            │   │
│  │  Dashboard | Magic Access (:3334)                         │   │
│  │  Nextcloud | OnlyOffice | Docker Registry (:5000)         │   │
│  └──────────────────────────────────────────────────────────┘   │
└──────────────────────────────────────────────────────────────────┘

---

Complete Container Inventory (101 running)

Commerce Backends (11)

#	Container	Tenant	FQDN	Status
1	brinxx-backend	brinxx	admin-brinxx.magicomniverse.online	Running
2	default-backend	default	admin-default.magicomniverse.online	Running
3	demo-backend	demo	admin-demo.magicomniverse.online	Running
4	development-backend	development	admin-development.magicomniverse.online	Running
5	master-backend	master	admin-master.magicomniverse.online	Running
6	bovisales-backend	bovisales	admin-bovisales.magicomniverse.online	Running
7	desluis-backend	desluis	admin-desluis.magicomniverse.online	Running
8	jodasign-backend	jodasign	admin-jodasign.magicomniverse.online	Running
9	logohorloge-backend	logohorloge	admin-logohorloge.magicomniverse.online	Running
10	spranz-backend	spranz	admin-spranz.magicomniverse.online	Running
11	toolvizion-backend	toolvizion	admin-toolvizion.magicomniverse.online	Running

Commerce Storefronts (8)

#	Container	Tenant	FQDN	Status
12	brinxx-storefront	brinxx	brinxx.magicomniverse.online	Running (307 → /nl)
13	default-storefront	default	default.magicomniverse.online	Running (307 → /nl)
14	demo-storefront	demo	demo.magicomniverse.online	Running (307 → /nl)
15	development-storefront	development	development.magicomniverse.online	Running (307 → /nl)
16	bovisales-storefront	bovisales	bovisales.magicomniverse.online	Running (307 → /nl)
17	jodasign-storefront	jodasign	jodasign.magicomniverse.online	Running (307 → /nl)
18	logohorloge-storefront	logohorloge	logohorloge.magicomniverse.online	Running (307 → /nl)
19	spranz-storefront	spranz	spranz.magicomniverse.online	Running (307 → /nl)

Redis Instances (13)

#	Container	Project	Healthcheck
20	brinxx-redis (shared-redis)	brinxx	Yes
21	redis-default	Commerce Tenants	No
22	redis-demo	Commerce Tenants	No
23	redis-development	Commerce Tenants	No
24	redis-master	Commerce Tenants	No
25	toolvizion-redis	Commerce Tenants	No
26	bovisales-redis	bovisales	No
27	desluis-redis	desluis	No
28	jodasign-redis	jodasign	No
29	logohorloge-redis	logohorloge	No
30	spranz-redis	spranz	No
31	agent-redis	agents	No
32	agent-spranz-redis	agents	No

AI Agents (10)

#	Container	FQDN	Health
33	agent-brinxx	aicheck.magicomniverse.online	Healthy (200)
34	agent-spranz	aicheck-spranz.magicomniverse.online	Healthy (200)
35	agent-jodasign	agent-jodasign.magicomniverse.online	Healthy (timeout!)
36	agent-magiceverse	agent-magiceverse.magicomniverse.online	Healthy (200)
37	agent-magic_dwf	agent-dwf.magicomniverse.online	Healthy (200)
38	agent-support_agent	agent-support.magicomniverse.online	Healthy (200)
39	agent-ollivanders	agent-ollivanders.magicomniverse.online	Healthy (200)
40	agent-princess	agent-princess.magicomniverse.online	Healthy (200)
41	agent-topgiving	agent-topgiving.magicomniverse.online	Healthy (200)
42	agent-logohorloge	agent-logohorloge.magicomniverse.online	Healthy (200)

Agent Infrastructure (4)

#	Container	FQDN	Port	Status
43	flowbuilder	flowbuilder.magicomniverse.online	3003	Running (404 at root = expected, API-only)
44	escalation-server	escalation.magicomniverse.online	11099	Running (200)
45	webhook-server	webhook.magicomniverse.online	11098	Running (404 at root = expected, API-only)
46	widget-server	agent.magicomniverse.online	4061	Running (404 at root = expected, API-only)

N8N Instances (4)

#	Container	FQDN	Status
47	n8n-main	n8n.magicomniverse.online	Running (200)
48	n8n-2	n8n2.magicomniverse.online	Running (200)
49	n8n-3	n8n3.magicomniverse.online	Running (200)
50	n8n-clean	n8n-clean.magicomniverse.online	Running (200)

Databases (4)

#	Container	Type	Port	Status
51	magic-postgres	PostgreSQL 16	5432	Running (healthy)
52	mysql	MySQL 8	3306	Running
53	coolify-db	PostgreSQL (Coolify internal)	—	Running (healthy)
54	coolify-redis	Redis (Coolify internal)	—	Running (healthy)

Business Services (2)

#	Container	FQDN	Status
55	magic-connector	connector.magicomniverse.online	Running (200)
56	magic-contact	contact.magicomniverse.online	Running (200)

Tools (7)

#	Container	FQDN	Status
57	magic-editor	editor.magicomniverse.online	Running (200)
58	magic-3d	3d.magicomniverse.online	Running (404 JSON — API-only)
59	magic-logo	logo.magicomniverse.online	Running (200)
60	magic-modal	modal.magicomniverse.online	Running (200)
61	magic-moodshot	moodshot.magicomniverse.online	Running (200)
62	magic-resize	resize.magicomniverse.online	Running (200)
63	magic-terminal	terminal.magicomniverse.online	Running (501 on curl — WebSocket service, works in browser)

Portal & Access (3)

#	Container	FQDN	Status
64	portal	portal.magicomniverse.online	Running (200)
65	magic-access	access.magicomniverse.online	Running (200)
66	magic-dashboard	dashboard.magicomniverse.online	Running (200)

Infrastructure (7)

#	Container	FQDN / Port	Status
67	coolify	coolify.magicomniverse.online (:8000)	Running (healthy)
68	coolify-proxy (Traefik)	ports 80/443/8080	Running (healthy)
69	coolify-realtime	WebSocket	Running (healthy)
70	coolify-sentinel	monitoring	Running (healthy)
71	registry	Docker registry (:5000)	Running
72	buildx_buildkit_turbo0	build kit	Running
73	magic-forward-auth-helper	auth middleware	Running

Monitoring (1)

#	Container	FQDN	Status
74	netdata	monitor.magicomniverse.online	Running (healthy)

Extras (3)

#	Container	FQDN	Status
75	nextcloud_app	docs.magicomniverse.online	Running (302)
76	nextcloud_db	internal MySQL	Running
77	onlyoffice_docs	office.magicomniverse.online	Running (302)

Note

Containers 78–101 are accounted for by the exited old deployments (10 legacy sslip.io apps from initial Coolify setup) and additional Coolify-managed helper/build containers.

---

Coolify Projects (16)

#	Project	UUID	Contents
1	Commerce Tenants	ra5w4beuzwbsj39bxjtlp33a	default-backend, default-storefront, demo-backend, demo-storefront, development-backend, development-storefront, master-backend, redis-default, redis-demo, redis-development, redis-master, toolvizion-backend, toolvizion-redis
2	agents	ly8emm9hcayrv31odbrxy9tr	agent-brinxx, agent-spranz, agent-jodasign, agent-magiceverse, agent-magic_dwf, agent-support_agent, agent-ollivanders, agent-princess, agent-topgiving, agent-logohorloge, agent-redis, agent-spranz-redis, flowbuilder, escalation-server, webhook-server, widget-server
3	bovisales	u60xain9eru7mq9oepq40jwf	bovisales-backend, bovisales-storefront, bovisales-redis (+2 exited old deployments)
4	brinxx	p3a414nfh4c0woaz40g8mpvd	brinxx-backend, brinxx-storefront, shared-redis (brinxx-redis), magic-postgres
5	business-services	gwd6yqz3oat1ka9l9l9l9412	magic-connector, magic-contact
6	default	y37xr5h1lvb9cabw3yrkf4i2	default-backend, default-storefront
7	demo	qzphj6v118folh10zfostenk	demo-backend, demo-storefront
8	desluis	kekoexxuyou8j9w3n9bfywk6	desluis-backend, desluis-redis, desluis-storefront (+1 exited old backend)
9	development	g12bzun1q64oqwljm1jyoxz1	development-backend, development-storefront
10	jodasign	p124fkya1oj1j16gobrzom7z	jodasign-backend, jodasign-storefront, jodasign-redis (+2 exited old deployments)
11	logohorloge	o46mvqff13ukvhziaotcm1zr	logohorloge-backend, logohorloge-storefront, logohorloge-redis (+2 exited old deployments)
12	n8n	t10zqw5ff2czpvz0xl7akg6r	n8n-main, n8n-2, n8n-3, n8n-clean
13	pim	vinrsqy0eqf0k38aepzr05vq	pim-backend
14	portal	guiv6q9ktejyggk9rsbgldmc	portal
15	spranz	mu2gbfvdliyucernkoa34z4i	spranz-backend, spranz-storefront, spranz-redis (+2 exited old deployments)
16	tools	a11xohldkir9aodr2ek0l6as	magic-editor, magic-3d, magic-logo, magic-modal, magic-moodshot, magic-resize, magic-terminal

Exited/Duplicate Coolify Apps (cleanup needed)

#	App	Project	FQDN	Status
X1	toolvizion-backend (old)	Commerce Tenants	sslip.io	Exited
X2	bovisales-backend (old)	bovisales	sslip.io	Exited
X3	bovisales-storefront (old)	bovisales	sslip.io	Exited
X4	desluis-backend (old)	desluis	sslip.io	Exited
X5	jodasign-backend (old)	jodasign	sslip.io	Exited
X6	jodasign-storefront (old)	jodasign	sslip.io	Exited
X7	logohorloge-backend (old)	logohorloge	sslip.io	Exited
X8	logohorloge-storefront (old)	logohorloge	sslip.io	Exited
X9	spranz-backend (old)	spranz	sslip.io	Exited
X10	spranz-storefront (old)	spranz	sslip.io	Exited

---

Commerce Tenants — Complete Reference

Admin Panels

Tenant	Admin URL	Backend UUID	Database	HTTP Status
brinxx	admin-brinxx.magicomniverse.online/app	les7duuk6opipbl38vvq35il	magic_b2b_brinxx	404 (Medusa API-only, /app works in browser)
default	admin-default.magicomniverse.online/app	btey8640mz1v5gpdl19inw1i	magic_b2b_default	404 (same)
demo	admin-demo.magicomniverse.online/app	huplyx1ai5cktjfr50vj5779	magic_b2b_demo	404 (same)
bovisales	admin-bovisales.magicomniverse.online/app	mxhf9c78zb19yxyxsrxht03v	magic_b2b_bovisales	404 (same)
desluis	admin-desluis.magicomniverse.online/app	lvk036c368yp507jb1ca96wy	magic_b2b_desluis	404 (same)
logohorloge	admin-logohorloge.magicomniverse.online/app	z4dxwwxb0mn21gst39580sgp	magic_b2b_logohorloge	404 (same)
jodasign	admin-jodasign.magicomniverse.online/app	l5bgqqg9l7yqq5p2qhfqadaw	magic_b2b_jodasign	404 (same)
spranz	admin-spranz.magicomniverse.online/app	etk3fvct78myk44ccqdiu1m4	magic_b2b_spranz	404 (same)
development	admin-development.magicomniverse.online/app	hhsn382kdreoti6qselx8pqv	magic_b2b_development	404 (same)
toolvizion	admin-toolvizion.magicomniverse.online/app	czb98ousqz6jgcw71aoxxixb	magic_b2b_toolvizion	404 (same)
master	admin-master.magicomniverse.online/app	—	master_magic	404 (same)

Note

All Medusa admin backends return 404 on the root path (/) — this is expected. The admin UI is served at /app and the API at /admin/* and /store/*. All backends are running and functional.

Storefronts

Tenant	Storefront URL	Storefront UUID	HTTP Status	Notes
brinxx	brinxx.magicomniverse.online	jkm70m01bv0uf9xqwa6leu8j	307 → /nl	Working
default	default.magicomniverse.online	varies	307 → /nl	Working
demo	demo.magicomniverse.online	varies	307 → /nl	Working
bovisales	bovisales.magicomniverse.online	varies	307 → /nl	Working
logohorloge	logohorloge.magicomniverse.online	varies	307 → /nl	Unique 2D mini modal for logo designer
jodasign	jodasign.magicomniverse.online	varies	307 → /nl	Extra quotation features
spranz	spranz.magicomniverse.online	x1sprrwuqazwebvsihstpi9y	307 → /nl	Tenant overlay build
development	development.magicomniverse.online	varies	307 → /nl	Internal
desluis	—	—	—	No storefront (backend-only)
toolvizion	—	—	—	No storefront (backend-only)
master	—	—	—	No storefront (backend-only)

Note

The Spranz storefront uses a tenant overlay pattern: base storefront code from /storefront/ is built first, then 20 Spranz-specific files from /tenants/spranz/storefront/src/ are overlaid on top. This includes branded homepage, navigation, hero slider, categories, AI search, and chat widget components. The Coolify app’s base_directory is set to / and dockerfile_location to /tenants/spranz/Dockerfile.storefront.

---

Complete Database Inventory

PostgreSQL — 54 Databases on New Server

Commerce Tenant Databases (11)

#	Database	Tables	Products	Variants	Status
1	magic_b2b_brinxx	200	14,966	55,159	Synced
2	magic_b2b_spranz	198	15,410	65,719	Synced
3	magic_b2b_default	188	15,274	65,583	Synced
4	magic_b2b_demo	188	16,730	78,797	Synced
5	magic_b2b_bovisales	188	16,729	78,795	Synced
6	magic_b2b_desluis	186	16,729	78,795	Synced
7	magic_b2b_jodasign	194	17,779	79,046	Synced
8	magic_b2b_logohorloge	193	46	153	Synced
9	magic_b2b_development	217	11,247	72,480	Synced
10	magic_b2b_toolvizion	217	757	757	Synced

PIM & Core Databases (5)

#	Database	Tables	Notes
12	magic_pim	189	11,254 products, 73,458 variants
13	master_magic	146	Master commerce (0 products)
14	magic_connector	5	Supplier data connector
15	magic_contact	1	Contact management
16	magic_access	5	Access management

Logo Designer Databases (4)

#	Database	Tables	Notes
17	magic_logo	20	Main logo DB
18	magic_logo_default	19	Default logo config
19	magic_logohorloge_logo	11	Logohorloge logo config
20	magic_spranz_logo	12	Spranz logo config

Agent Databases (16)

#	Database	Tables
21	magic_agent	5
22	magic_agent_brinxx	45
23	magic_agent_default_agent	40
24	magic_agent_jodasign	49
25	magic_agent_langenberg	38
26	magic_agent_logohorloge	18
27	magic_agent_magic_dwf	49
28	magic_agent_magiceverse	49
29	magic_agent_ollivanders	49
30	magic_agent_princess	46
32	magic_agent_spranz	43
33	magic_agent_support_agent	49
34	magic_agent_topgiving	48
35	magic_agent_wayne	48
36	magic_escalation	7

Other / Legacy Databases (16)

#	Database	Tables	Notes
37	magic_demokkenkoning_logo	2	Legacy
38	magic_dwf	0	Empty shell
39	magic_management	1	Legacy (replaced by portal)
40	magiceverse	0	Empty shell
41	magiceverse3_cms	14	Legacy CMS
42	mailer	5	Legacy mailer
43	maw_kalender	18	Legacy calendar
44	moodshot_service	1	Moodshot
45	ollivanders	0	Empty shell
46	princess	0	Empty shell
47	spranz	1	Legacy
48	spranzpdf	9	Legacy PDF
49	topgiving	0	Empty shell
50	wireframes	1	Legacy
51	workshopmw	9	Legacy workshop
52	postgres	0	System default
53	template0	—	System
54	template1	—	System

user_rbac_role Table Presence

Database	Present	Rows
magic_b2b_brinxx	Yes	0
magic_b2b_spranz	Yes	0
magic_b2b_default	Yes	0
magic_b2b_demo	Yes	0
magic_b2b_development	Yes	0
magic_b2b_bovisales	Yes (created 2026-03-26)	0
magic_b2b_desluis	Yes (created 2026-03-26)	0
magic_b2b_jodasign	Yes (created 2026-03-26)	0
magic_b2b_logohorloge	Yes (created 2026-03-26)	0
magic_b2b_toolvizion	Yes (created 2026-03-26)	0

MySQL — 9 Databases on New Server

magic_doc (60 tables) — IMPORTED 2026-03-26

Table	Rows	Status
api_endpoints	8	Imported
asset_changelog	0	Empty (same as old server)
asset_containers	0	Empty
asset_credentials	0	Empty
asset_databases	0	Empty
asset_dependencies	0	Empty
asset_domains	77	Imported
asset_metrics	0	Empty
asset_overview	0	Empty
asset_pm2_services	0	Empty
asset_ports	58	Imported
asset_resources	0	Empty
asset_servers	0	Empty
assets	78	Imported
available_ports	0	Empty
categories	23	Imported
code_snippets	18	Imported
contacts	0	Empty
crm_lead_activities	0	Empty
crm_lead_tasks	0	Empty
crm_leads	0	Empty
diagrams	0	Empty
documents	93	Imported
ecommerce_project_access	0	Empty
ecommerce_uploads	0	Empty
endpoint_annotations	0	Empty
expiring_credentials	0	Empty
port_allocation_log	0	Empty
port_conflicts	0	Empty
port_ranges	8	Imported
port_registry	84	Imported
port_usage_by_category	0	Empty
portal_2fa_tokens	7	Imported
portal_clients	9	Imported
portal_invites	0	Empty
portal_notes	0	Empty
portal_project_access	0	Empty
portal_projects	9	Imported
portal_sections	10	Imported
portal_sessions	22	Active
portal_support_articles	7	Imported
portal_support_categories	5	Imported
portal_support_handlers	0	Empty
portal_support_reporters	2	Imported
portal_support_tickets	37	Imported
portal_tenant_deployments	8	Imported
portal_ticket_attachments	0	Empty
portal_ticket_comments	36	Imported
portal_ticket_history	20	Imported
portal_uploads	2	Imported
portal_user_permissions	0	Empty
project_uploads	0	Empty
service_health_dashboard	0	Empty
settings	0	Empty
system_updates	0	Empty
tenant_port_summary	0	Empty
tenants	0	Empty
user_project_access	0	Empty
user_sessions	0	Empty
users	0	Empty

Caution

Some tables like users, tenants, settings show 0 rows in information_schema.tables despite data being imported — MySQL InnoDB row estimates can be inaccurate. Verify with SELECT count(*) FROM table_name for exact counts.

Other MySQL Databases

#	Database	Tables	Rows	Notes
2	dartv2dev	30	All 0	Legacy dart game
3	uren	148	All 0	Legacy hours tracking
4	magic_promotionalz	0	—	Empty database
5	portal_db	0	—	Empty database
6	information_schema	—	—	System
7	mysql	—	—	System
8	performance_schema	—	—	System
9	sys	—	—	System

Product & Variant Counts — Final Comparison (After Sync)

Tip

All product and variant counts now match between old and new server. Sync completed 2026-03-26.

Database	Old Server	New Server	Products Match	Variants Match
magic_b2b_brinxx	14,966 / 55,159	14,966 / 55,159	Yes	Yes
magic_b2b_spranz	15,410 / 65,719	15,410 / 65,719	Yes	Yes
magic_b2b_default	15,274 / 65,583	15,274 / 65,583	Yes	Yes
magic_b2b_demo	16,730 / 78,797	16,730 / 78,797	Yes	Yes
magic_b2b_bovisales	16,729 / 78,795	16,729 / 78,795	Yes	Yes
magic_b2b_desluis	16,729 / 78,795	16,729 / 78,795	Yes	Yes
magic_b2b_jodasign	17,779 / 79,046	17,779 / 79,046	Yes	Yes
magic_b2b_logohorloge	46 / 153	46 / 153	Yes	Yes
magic_b2b_development	11,247 / 72,480	11,247 / 72,480	Yes	Yes
magic_b2b_toolvizion	757 / 757	757 / 757	Yes	Yes
magic_pim	11,254 / 73,458	11,254 / 73,458	Yes	Yes

Table Counts — Final Comparison (After Sync)

Database	Old Server	New Server	Match
magic_b2b_brinxx	200	200	Yes
magic_b2b_spranz	198	198	Yes
magic_b2b_default	188	188	Yes
magic_b2b_demo	188	188	Yes
magic_b2b_bovisales	188	188	Yes
magic_b2b_desluis	186	186	Yes
magic_b2b_jodasign	194	194	Yes
magic_b2b_logohorloge	193	193	Yes
magic_b2b_development	217	217	Yes
magic_b2b_toolvizion	217	217	Yes
magic_pim	189	189	Yes
magic_logo	20	20	Yes
magic_connector	5	5	Yes
magic_contact	1	1	Yes
master_magic	146	146	Yes

---

N8N Instances

Instance	URL	Container	Status
n8n-main	n8n.magicomniverse.online	n8n-main	Running (200)
n8n-2	n8n2.magicomniverse.online	n8n-2	Running (200)
n8n-3	n8n3.magicomniverse.online	n8n-3	Running (200)
n8n-clean	n8n-clean.magicomniverse.online	n8n-clean	Running (200)

Note

On the old server, magic_n8n_clean is crash-looping. The new server’s n8n-clean instance works correctly.

---

AI Agents

Agent	Domain	Container	Health
agent-brinxx	aicheck.magicomniverse.online	agent-brinxx	HTTP 200
agent-spranz	aicheck-spranz.magicomniverse.online	agent-spranz	HTTP 200
agent-jodasign	agent-jodasign.magicomniverse.online	agent-jodasign	HTTP 000 (timeout)
agent-magiceverse	agent-magiceverse.magicomniverse.online	agent-magiceverse	HTTP 200
agent-magic-dwf	agent-dwf.magicomniverse.online	agent-magic_dwf	HTTP 200
agent-support-agent	agent-support.magicomniverse.online	agent-support_agent	HTTP 200
agent-ollivanders	agent-ollivanders.magicomniverse.online	agent-ollivanders	HTTP 200
agent-princess	agent-princess.magicomniverse.online	agent-princess	HTTP 200
agent-topgiving	agent-topgiving.magicomniverse.online	agent-topgiving	HTTP 200
agent-logohorloge	agent-logohorloge.magicomniverse.online	agent-logohorloge	HTTP 200

Agent Infrastructure:

Service	Domain	Container	Port	Status
flowbuilder	flowbuilder.magicomniverse.online	flowbuilder	3003	Running (404 at root = expected, API-only)
escalation-server	escalation.magicomniverse.online	escalation-server	11099	Running (200)
webhook-server	webhook.magicomniverse.online	webhook-server	11098	Running (404 at root = expected, API-only)
widget-server	agent.magicomniverse.online	widget-server	4061	Running (404 at root = expected, API-only)

---

Other Services

Service	URL	Container	HTTP Status	Notes
Portal	portal.magicomniverse.online	portal	200	MySQL session store fixed (was using Docker bridge IP)
PIM	pim.magicomniverse.online	pim-backend	404	API-only (11,254 products, 189 tables)
Connector	connector.magicomniverse.online	magic-connector	200	Supplier data connector
Contact	contact.magicomniverse.online	magic-contact	200	Contact management
Editor	editor.magicomniverse.online	magic-editor	200	Product editor tool
3D	3d.magicomniverse.online	magic-3d	404	API-only (3D product visualization)
Logo	logo.magicomniverse.online	magic-logo	200	Logo designer tool
Modal	modal.magicomniverse.online	magic-modal	200	Modal UI component
Moodshot	moodshot.magicomniverse.online	magic-moodshot	200	Moodshot image tool
Resize	resize.magicomniverse.online	magic-resize	200	Image resize service
Terminal	terminal.magicomniverse.online	magic-terminal	501	Sshwifty (WebSocket — works in browser, curl returns 501)
Monitor	monitor.magicomniverse.online	netdata	200	Netdata system monitoring
Dashboard	dashboard.magicomniverse.online	magic-dashboard	200	Dev projects dashboard
Access	access.magicomniverse.online	magic-access	200	Access management
Coolify	coolify.magicomniverse.online	coolify	302	Coolify dashboard (redirect to login)
Nextcloud	docs.magicomniverse.online	nextcloud_app	302	Nextcloud (redirect to login)
OnlyOffice	office.magicomniverse.online	onlyoffice_docs	302	OnlyOffice (redirect to login)

---

DNS Configuration

Current State

Domain Zone	Target IP	Status
magicomniverse.online (apex)	185.104.28.238 (registrar parking!)	NOT pointing to new server
*.magicomniverse.online	159.195.68.41 (new server)	Active — all services running
*.magiceverse.online	83.86.98.93 (old server)	Active — NOT yet migrated
magiceverse.online (apex)	84.25.156.251 (old server)	Active — HTTPS connection refused

Both zones share the same nameservers: ns.zxcs.eu, ns.zxcs.be, ns.zxcs.nl.

Domain Health Check — Every Single Domain

Working (HTTP 200)

Domain	IP	Status
portal.magicomniverse.online	159.195.68.41	200
connector.magicomniverse.online	159.195.68.41	200
contact.magicomniverse.online	159.195.68.41	200
editor.magicomniverse.online	159.195.68.41	200
logo.magicomniverse.online	159.195.68.41	200
modal.magicomniverse.online	159.195.68.41	200
moodshot.magicomniverse.online	159.195.68.41	200
resize.magicomniverse.online	159.195.68.41	200
n8n.magicomniverse.online	159.195.68.41	200
n8n2.magicomniverse.online	159.195.68.41	200
n8n3.magicomniverse.online	159.195.68.41	200
n8n-clean.magicomniverse.online	159.195.68.41	200
dashboard.magicomniverse.online	159.195.68.41	200
access.magicomniverse.online	159.195.68.41	200
escalation.magicomniverse.online	159.195.68.41	200
aicheck.magicomniverse.online	159.195.68.41	200
aicheck-spranz.magicomniverse.online	159.195.68.41	200
agent-logohorloge.magicomniverse.online	159.195.68.41	200
agent-topgiving.magicomniverse.online	159.195.68.41	200
agent-princess.magicomniverse.online	159.195.68.41	200
agent-ollivanders.magicomniverse.online	159.195.68.41	200
agent-support.magicomniverse.online	159.195.68.41	200
agent-dwf.magicomniverse.online	159.195.68.41	200
agent-magiceverse.magicomniverse.online	159.195.68.41	200
devdocs.magiceverse.online	83.86.98.93	200 (on old server, nginx)

Working (Redirects — expected behavior)

Domain	IP	Status	Redirect
coolify.magicomniverse.online	159.195.68.41	302	→ login
docs.magicomniverse.online	159.195.68.41	302	→ Nextcloud login
office.magicomniverse.online	159.195.68.41	302	→ OnlyOffice login
brinxx.magicomniverse.online	159.195.68.41	307	→ /nl
default.magicomniverse.online	159.195.68.41	307	→ /nl
demo.magicomniverse.online	159.195.68.41	307	→ /nl
development.magicomniverse.online	159.195.68.41	307	→ /nl
bovisales.magicomniverse.online	159.195.68.41	307	→ /nl
spranz.magicomniverse.online	159.195.68.41	307	→ /nl
desluis.magicomniverse.online	159.195.68.41	307	→ /nl
jodasign.magicomniverse.online	159.195.68.41	307	→ /nl
logohorloge.magicomniverse.online	159.195.68.41	307	→ /nl

API-Only (404 at root — expected)

Domain	IP	Status	Reason
pim.magicomniverse.online	159.195.68.41	404	Medusa API, no root handler
3d.magicomniverse.online	159.195.68.41	404	API-only service
flowbuilder.magicomniverse.online	159.195.68.41	404	API-only service
webhook.magicomniverse.online	159.195.68.41	404	API-only service
agent.magicomniverse.online	159.195.68.41	404	Widget API-only service
admin-brinxx.magicomniverse.online	159.195.68.41	404	Medusa API (use /app for admin UI)
admin-default.magicomniverse.online	159.195.68.41	404	Medusa API
admin-demo.magicomniverse.online	159.195.68.41	404	Medusa API
admin-development.magicomniverse.online	159.195.68.41	404	Medusa API
admin-master.magicomniverse.online	159.195.68.41	404	Medusa API
admin-bovisales.magicomniverse.online	159.195.68.41	404	Medusa API
admin-desluis.magicomniverse.online	159.195.68.41	404	Medusa API
admin-jodasign.magicomniverse.online	159.195.68.41	404	Medusa API
admin-logohorloge.magicomniverse.online	159.195.68.41	404	Medusa API
admin-spranz.magicomniverse.online	159.195.68.41	404	Medusa API
admin-toolvizion.magicomniverse.online	159.195.68.41	404	Medusa API

Special

Domain	IP	Status	Notes
terminal.magicomniverse.online	159.195.68.41	501	Sshwifty WebSocket — works in browser
agent-jodasign.magicomniverse.online	159.195.68.41	000 (timeout)	Container healthy but unreachable externally

Not Deployed (self-signed cert + 503)

Domain	IP	Issue
spranz-admin.magicomniverse.online	159.195.68.41	No Traefik router (use admin-spranz instead)
brinxx-admin.magicomniverse.online	159.195.68.41	No Traefik router (use admin-brinxx instead)
bovisales-admin.magicomniverse.online	159.195.68.41	No Traefik router
jodasign-admin.magicomniverse.online	159.195.68.41	No Traefik router
desluis-admin.magicomniverse.online	159.195.68.41	No Traefik router
logohorloge-admin.magicomniverse.online	159.195.68.41	No Traefik router
toolvizion-admin.magicomniverse.online	159.195.68.41	No Traefik router
midocean.magicomniverse.online	159.195.68.41	Tenant not deployed
midocean-admin.magicomniverse.online	159.195.68.41	Tenant not deployed
xdconnects.magicomniverse.online	159.195.68.41	Tenant not deployed
xdconnects-admin.magicomniverse.online	159.195.68.41	Tenant not deployed
pfconcept.magicomniverse.online	159.195.68.41	Tenant not deployed
pfconcept-admin.magicomniverse.online	159.195.68.41	Tenant not deployed
newwave.magicomniverse.online	159.195.68.41	Tenant not deployed
newwave-admin.magicomniverse.online	159.195.68.41	Tenant not deployed
toolvizion.magicomniverse.online	159.195.68.41	Backend-only tenant, no storefront
n8n-spranz.magicomniverse.online	159.195.68.41	N8N instance not deployed

Old Server / Legacy Domains

Domain	IP	Status
magiceverse.nl	216.198.79.1 (Vercel)	Separate project
www.magiceverse.nl	Vercel DNS	Separate project
pim.magiceverse.nl	84.25.156.251	HTTPS refused
portal.magiceverse.nl	No DNS record	Already cleaned up
api.magiceverse.nl	No DNS record	Already cleaned up

SSL Certificates (New Server)

All subdomains with active Traefik routers have valid Let’s Encrypt certificates, auto-provisioned by Traefik. Expiry dates range from June 18 to June 24, 2026 (~3 months from now). No manual certificate management required.

Domains showing “self-signed cert” in the “Not Deployed” section above do not have Traefik routers — Traefik serves its default self-signed cert when no matching router exists.

---

DNS Cutover Plan (Phase 10)

Caution

DNS cutover should only proceed after ALL pre-cutover checks pass.

Pre-Cutover Checklist

• MySQL magic_doc data imported (fixed 2026-03-26)
• Product/variant counts match between old and new server (synced 2026-03-26)
• Table counts match for all tenant databases (fixed 2026-03-26)
• Jodasign quotation data restored (231 headers, 630 lines — 2026-03-26)
• user_rbac_role table created in all 11 tenant databases
• Portal login works with session persistence
• All storefronts render correctly with tenant branding (visual check needed)
• Spranz homepage has all branded components (hero, nav, categories) — build still in queue
• magicomniverse.online apex domain A record updated to 159.195.68.41
• Coolify API token regenerated (current token expired)
• agent-jodasign.magicomniverse.online timeout resolved
• Old server containers still running as fallback

Cutover Order (Lowest Risk First)

Wave	Services	Risk Level
1	development, demo, default	Zero customer impact
2	desluis, toolvizion	Backend-only, no storefronts
3	connector, contact	Business services
4	editor, 3d, logo, modal, moodshot, resize	Tools
5	bovisales, jodasign, logohorloge	Client tenants
6	spranz, brinxx	High-value client tenants
7	pim, portal, dashboard	Core infrastructure
8	monitoring, agents, n8n	Infrastructure services

Post-Cutover

• Monitor Netdata for error spikes (first 2 hours)
• SSL certificates will auto-provision for *.magiceverse.online domains via Traefik
• Keep old server running 2 weeks as fallback
• If no issues: stop old server containers, take final backup, decommission

---

Known Issues & Warnings (Remaining)

Critical

1. magicomniverse.online apex domain — Points to 185.104.28.238 (registrar parking page), NOT to 159.195.68.41. The A record was never updated.
2. Coolify API token expired — Bearer token gcs_FSBBk... returns “Unauthenticated”. Must generate a new token from Coolify settings.

Medium

3. agent-jodasign.magicomniverse.online — Connection timeout (HTTP 000). Container reports healthy but is unreachable externally. May be a Traefik routing issue.
4. *-admin.magicomniverse.online domains (11) — These DNS records exist but have no Traefik router. The actual admin panels use admin-*.magicomniverse.online (note the prefix vs suffix pattern). Consider removing the -admin DNS records or adding redirects.
5. Undeployed tenant domains — midocean, xdconnects, pfconcept, newwave storefronts and admins resolve to the server but have no Coolify apps. Either deploy these tenants or remove the DNS records.
6. n8n-spranz.magicomniverse.online — DNS resolves but no N8N instance deployed. Remove DNS or deploy.

Low

7. 10 exited/duplicate Coolify apps — Old sslip.io deployments: toolvizion-backend (old), bovisales-backend (old), bovisales-storefront (old), desluis-backend (old), jodasign-backend (old), jodasign-storefront (old), logohorloge-backend (old), logohorloge-storefront (old), spranz-backend (old), spranz-storefront (old). Should be deleted from Coolify.
8. 12 of 13 Redis instances lack healthchecks — Only brinxx-redis (shared-redis) has Docker healthchecks. Missing on: redis-default, redis-demo, redis-development, redis-master, toolvizion-redis, bovisales-redis, desluis-redis, jodasign-redis, logohorloge-redis, spranz-redis, agent-redis, agent-spranz-redis.
9. 15 legacy/empty PostgreSQL databases — magic_dwf (0 tables), magiceverse (0 tables), ollivanders (0 tables), princess (0 tables), topgiving (0 tables), magic_management (1 table), magiceverse3_cms (14 tables), magic_demokkenkoning_logo (2 tables), maw_kalender (18 tables), workshopmw (9 tables), spranzpdf (9 tables), wireframes (1 table), mailer (5 tables), spranz (1 table), moodshot_service (1 table).
10. 4 legacy/empty MySQL databases — dartv2dev (30 empty tables), uren (148 empty tables), magic_promotionalz (0 tables), portal_db (0 tables).
11. magic_n8n_clean crash-looping on old server — Works fine on new server.
12. Old server disk at 87% — Root filesystem only has 29 GB free. Not a new-server issue but worth monitoring during transition.

Info — Server Resources

Metric	Value	Action
RAM	19 GB / 31 GB (61%), no swap	Consider adding swap
Docker images	145.1 GB total, 130.8 GB reclaimable	docker image prune would free 130 GB
Docker build cache	69.28 GB, 69.01 GB reclaimable	docker builder prune would free 69 GB
Disk	298 GB / 1007 GB (31%)	OK, but ~200 GB reclaimable

---

Git Repositories

Repo	Contents	Deploy Target	Branch
midego1/Magic-e-VERSE	Monorepo: backend, storefront, tenants	All commerce backends + storefronts	main (protected)
midego1/Magic-Portal	Portal (Express.js + Vite/React)	Portal app	main
midego1/Magic-Terminal	Sshwifty web SSH client	Terminal service	main
midego1/magic-agent-brinxx	AI agent for Brinxx	agent-brinxx	main
midego1/magic-agent-spranz	AI agent for Spranz	agent-spranz	main
midego1/magic-agent-jodasign	AI agent for Jodasign	agent-jodasign	main
midego1/magic-agent-magiceverse	AI agent for MagicEverse	agent-magiceverse	main
midego1/magic-agent-dwf	AI agent for DWF	agent-magic_dwf	main
midego1/magic-agent-support	AI support agent	agent-support_agent	main
midego1/magic-agent-ollivanders	AI agent for Ollivanders	agent-ollivanders	main
midego1/magic-agent-princess	AI agent for Princess	agent-princess	main
midego1/magic-agent-topgiving	AI agent for Topgiving	agent-topgiving	main
midego1/magic-agent-logohorloge	AI agent for Logohorloge	agent-logohorloge	main

Branch Strategy

• main — production branch (Coolify deploys from this)
• development — used only by development-backend and development-storefront
• main is protected on Magic-e-VERSE — changes require PRs

Tenant Overlay Pattern

For tenants that need custom storefront code (e.g., Spranz), files are placed in tenants/{tenant}/storefront/src/ and a custom Dockerfile.storefront copies the base storefront first, then overlays tenant-specific files.

Magic-e-VERSE/
├── backend/                    # Shared Medusa v2 backend
├── storefront/                 # Shared Next.js 15 storefront
│   ├── Dockerfile              # Default storefront Dockerfile
│   └── src/                    # Base storefront code
└── tenants/
    └── spranz/
        ├── Dockerfile.storefront   # Custom build: base + overlay
        └── storefront/
            └── src/                # 20 Spranz-specific files
                ├── app/layout.tsx
                ├── app/[countryCode]/(main)/page.tsx
                ├── modules/home/components/spranz-*/
                ├── modules/layout/components/spranz-nav/
                └── ...

---

Old Server Inventory (For Reference)

The old server at 83.86.98.93 (SSH port 22022, user adminmichiel1) runs:

• 58 running containers (Docker Compose, manually managed)
• Nginx reverse proxy with 108 site configs (~75 unique domains)
• 54 PostgreSQL databases in magic_pim_postgres_dev
• 9 MySQL databases in mysql container
• PM2 installed but no active processes
• Ubuntu 24.04 LTS, hostname: magic-server
• Disk: 87% full (29 GB free)

Services on Old Server NOT Migrated (Intentional)

Service	Reason
Nextcloud + OnlyOffice	Now on new server (migrated separately)
Omada Controller	Network management, stays on local network
Vaultwarden	Critical — migrate separately or keep on old server
rembg-service	Background removal AI — migrate when needed
Crypto Monitor (crypto.magiceverse.online)	Bitvavo trading bot — separate concern
Glances (glances.magiceverse.online)	Replaced by Netdata on new server
magiceverse3	Legacy CMS, no longer active
demokkenkoning	Legacy service, no longer active
brandwizard	Legacy service, no longer active

---

Operational Runbook

Deploying a Code Change

1. Push to main branch of midego1/Magic-e-VERSE
2. Coolify auto-detects the push and queues builds for all apps using the repo
3. Monitor at coolify.magicomniverse.online
4. Alternatively, trigger a specific app deploy via API:

   curl -X GET -H "Authorization: Bearer $COOLIFY_TOKEN" \
     "https://coolify.magicomniverse.online/api/v1/applications/{uuid}/restart"

Checking Container Health

ssh root@159.195.68.41
docker ps --format "table {{.Names}}\t{{.Status}}" | sort

Viewing Logs

docker logs <container-name> --tail=50 -f

Database Access

# PostgreSQL
docker exec -it magic-postgres psql -U postgres -d <database_name>

# MySQL
docker exec -it mysql mysql -uroot -p<password> <database_name>

Emergency Rollback

If a service breaks after DNS cutover:

1. Change DNS A record back to 83.86.98.93 (old server)
2. Old server containers should still be running
3. DNS propagation takes 5-30 minutes depending on TTL

Medusa Migration Hang Fix

If a Medusa backend container hangs during startup with “Select tables to DELETE” prompt:

# Connect to the tenant database
docker exec magic-postgres psql -U postgres -d <tenant_db>

# Truncate the problematic table
TRUNCATE link_module_migrations;

# Restart the container
docker restart <container-name>

Docker Cleanup (free ~200 GB)

# Remove unused images (frees ~130 GB)
docker image prune -a

# Remove build cache (frees ~69 GB)
docker builder prune -a