olragon

Upgrading Mautic 6.0.7 → 7.0.1 (Docker, MariaDB 11.8)

Environment

• Docker: PHP 8.3-fpm + nginx + supervisord
• MariaDB 11.8 (shared container)
• Previous upgrade: 5.2.3 → 6.0.7 already completed

Gotcha: Unsigned FK Column vs Signed PK

Migrations Version20250828070131 (sms_messages) and Version20250923135527 (push_notifications) add a translation_parent_id column as unsigned int with a self-referencing FK to the id column, which is signed int.

olragon

Upgrading Mautic 5.2.3 → 6.0.7 (Docker, MariaDB 11.8)

Environment

• Docker: PHP 8.3-fpm + nginx + supervisord
• MariaDB 11.8 (shared Coolify-managed container)
• Volumes: config, media, plugins, themes, var, translations

Gotcha 1: Plugin Volume Override

After swapping the html/ source to 6.0.7, the Docker volume mount for plugins/ still contains 5.2.3 plugins. These reference the session Symfony service which was removed in Symfony 6.

olragon

Mautic 5 Docker Setup Guide

Complete guide to running Mautic 5.x in a single Docker container with nginx, PHP-FPM, and cron — designed for low-traffic marketing automation (< 50k contacts).

Architecture

Reverse Proxy (Traefik/nginx) → Container (nginx:80 → PHP-FPM:9000)
                                       ↓
                                 External MariaDB 11+

olragon

Bun Segfaults on Proxmox VM — the $6.75 AVX Rabbit Hole

2026-03-03 — debugging war story

The Problem

Deploying a Bun app to a Proxmox VM. Everything works locally. On the VM:

panic(main thread): Segmentation fault at address 0x419E4000000

olragon

Installing Colima via MacPorts on macOS 10.13 (High Sierra)

Machine: MacBookPro6,2 (mid-2010 15"), macOS 10.13.6 High Sierra, darwin 17.7.0 MacPorts: with clang-mp-17, python3.14, Go 1.24.8 Result: Colima 0.10.1 + Lima 2.0.3 + QEMU 10.2.1 — fully working Docker on macOS 10.13

The Problem

sudo port install colima fails because QEMU 10.2.1 and Lima 2.0.3 use macOS APIs that don't exist on 10.13. Seven custom patches are needed across QEMU and Lima Portfiles, plus a python3 symlink fix.

olragon

#!/usr/bin/env python3
import gi
gi.require_version('Aravis', '0.8')
from gi.repository import Aravis
import numpy as np
import cv2
import sys
import time
import json
import os

olragon

// ==UserScript==
// @name         Blagu - Text Selectable
// @namespace    http://tampermonkey.net/
// @version      1.1
// @description  Enables text selection, right-click and copy/paste on website by removing protections
// @author       You
// @match        *://*.5office.vn/*
// @match        *://*.officesaigon.vn/*
// @grant        none
// @run-at       document-start

olragon

Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) Chrome/
Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)
Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/W.X.Y.Z Mobile Safari/537.36  (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) Chrome/W.X.Y.Z Safari/537.36
Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/W.X.Y.Z Mobile Safari/537.36  (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; MicrosoftPreview/2.0; +https://aka.ms/MicrosoftPreview) Chrome/W.X.Y.Z Safari/537.36
Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/W.X.Y.Z Mobile Safari/537.36  (compatible; MicrosoftPre

olragon

diff --git a/node_modules/postgraphile/build/postgraphile/http/createPostGraphileHttpRequestHandler.js b/node_modules/postgraphile/build/postgraphile/http/createPostGraphileHttpRequestHandler.js
index 73bc159..1b1d23d 100644
--- a/node_modules/postgraphile/build/postgraphile/http/createPostGraphileHttpRequestHandler.js
+++ b/node_modules/postgraphile/build/postgraphile/http/createPostGraphileHttpRequestHandler.js
@@ -717,7 +717,14 @@ function createPostGraphileHttpRequestHandler(options) {
                             operationName,
                         }, (graphqlContext) => {
                             pgRole = graphqlContext.pgRole;
-                            const graphqlResult = graphql_1.execute(gqlSchema, queryDocumentAst, null, graphqlContext, variables, operationName);
+                            const graphqlResult = graphql_1.execute({

olragon

Framework	Average	Get (/)	Params, query & header	Post JSON
uws (node)	98,742.06	117,931.1	106,347.08	71,948
hyper-express (node)	82,449.5	118,198.57	88,546.88	40,603.05
bun (bun)	81,971.373	99,946.51	78,488.13	67,479.48
elysia (bun)	79,643.103	98,266.18	76,637.37	64,025.76
vixeny (bun)	79,508.623	96,996.36	79,585.35	61,944.16
stricjs (bun)	79,120.123	97,804.01	78,028.85	61,527.51
hono (bun)	75,293.96	95,430.31	70,915.01	59,536.56
bun-web-standard (bun)	73,925.933	88,856.78	70,520.02	62,401