NAME                        IMAGE                     COMMAND                  SERVICE   CREATED             STATUS                       PORTS
qpixel-0130-stack-db-1      qpixel-0130-stack-db      "/bin/bash /docker/e…"   db        About an hour ago   Up About an hour (healthy)   3306/tcp, 33060/tcp
qpixel-0130-stack-redis-1   redis:latest              "docker-entrypoint.s…"   redis     About an hour ago   Up About an hour (healthy)   6379/tcp
qpixel-0130-stack-uwsgi-1   qpixel-0130-stack-uwsgi   "/bin/bash /code/doc…"   uwsgi     About an hour ago   Up About an hour             80/tcp, 443/tcp, 0.0.0.0:8131->3000/tcp, [::]:8131->3000/tcp

docker compose version          # 要求 2.x+（本文 v5.6.1）
docker info >/dev/null && echo docker-ok   # docker daemon 在跑
ss -ltn | grep ':8131' || echo port-8131-free   # Web 端口空闲

cd /opt/data/quzuo/tmp/qpixel
curl -sSL -o qpixel-v0.13.0.tar.gz https://codeload.github.com/codidact/qpixel/tar.gz/refs/tags/v0.13.0
tar xzf qpixel-v0.13.0.tar.gz

cd qpixel-0.13.0
chmod +x docker/local-setup.sh
docker/local-setup.sh

#!/bin/bash

cp ./docker/dummy.env ./docker/env
cp ./docker/compose-env .env
cp config/database.docker.yml config/database.yml
cp config/storage.docker.yml config/storage.yml
cp ./.sample.irbrc ./.irbrc

COMPOSE_FILE=./docker-compose.yml
LOCAL_DEV_PORT=8131
COMMUNITY_NAME=Dev Community
MAILER_PROTOCOL=https
RAILS_ENV=development
CONFIRMABLE_ALLOWED_ACCESS_DAYS=2
ENV_FILE_LOCATION=./docker/env
CLIENT_DOCKERFILE=docker/Dockerfile

MYSQL_ROOT_PASSWORD=qpixel
MYSQL_DATABASE=qpixel
MYSQL_USER=qpixel
MYSQL_PASSWORD=qpixel
COMMUNITY_ADMIN_USERNAME=admin
COMMUNITY_ADMIN_PASSWORD=q1w2e3r4
COMMUNITY_ADMIN_EMAIL=admin@example.com

18.72 E: Failed to fetch http://deb.debian.org/debian-security/pool/updates/main/libf/libfcgi/libfcgi0ldbl_2.4.2-2%2bdeb11u1_amd64.deb  404  Not Found [IP: 146.75.122.132 80]
18.73 E: Failed to fetch http://deb.debian.org/debian-security/pool/updates/main/libx/libxslt/libxslt1-dev_1.1.34-4%2bdeb11u3_amd64.deb  404  Not Found [IP: 146.75.122.132 80]
18.73 E: Unable to fetch some archives, maybe run apt-get update or try with --fix-missing?
------
Dockerfile:10
--------------------
  10 | >>> RUN apt-get update && \
  11 | >>>     apt-get install -y bison \
--------------------
target uwsgi: failed to solve: process "/bin/sh -c apt-get update && ..." did not complete successfully: exit code: 100
BUILD_EXIT=1

RUN sed -i 's|http://deb.debian.org/debian-security|http://archive.debian.org/debian-security|; s|http://deb.debian.org/debian|http://archive.debian.org/debian|g' /etc/apt/sources.list \
 && echo 'Acquire::Check-Valid-Until "false";' > /etc/apt/apt.conf.d/99no-check-valid-until \
 && apt-get update && \
    apt-get install -y bison \
    ...

docker compose build

#36 [uwsgi] exporting to image
#36 naming to docker.io/library/qpixel-0130-stack-uwsgi:latest done
#36 unpacking to docker.io/library/qpixel-0130-stack-uwsgi:latest 5.9s done
#37 [uwsgi] resolving provenance for metadata file
#37 DONE 0.0s
 Image qpixel-0130-stack-db Built
 Image qpixel-0130-stack-uwsgi Built
BUILD_EXIT=0

docker compose up -d

mysqld: File './binlog.index' not found (OS errno 13 - Permission denied)

chown -R 999:999 docker/mysql

File ./ibdata1: 'open' returned OS error 71

rm -rf docker/mysql/*
docker run --rm -v "$(pwd)/docker/mysql:/var/lib/mysql" \
  -e MYSQL_ROOT_PASSWORD=qpixel -e MYSQL_DATABASE=qpixel \
  -e MYSQL_USER=qpixel -e MYSQL_PASSWORD=qpixel \
  mysql:8.4.2

[Note] [Entrypoint]: Initializing database files
[Warning] [MY-010453] root@localhost is created with an empty password ! ...
[Note] [Entrypoint]: Creating database qpixel
[Note] [Entrypoint]: Creating user qpixel
[Note] [Entrypoint]: MySQL init process done. Ready for start up.
/usr/sbin/mysqld: ready for connections. Version: '8.4.2' ... port: 3306

Created database 'qpixel_dev'
Created database 'qpixel_test'
PostType: created 5
CloseReason: created 5
License: created 5
TagSet: created 2
PostHistoryType: created 16
User: created 1
Ability: created 7
CommunityUser: created 1
Filter: created 4
Category: created 2
PostFlagType: created 5
Post: created 23
ReactionType: created 3
SiteSetting: skipped 112
=> Booting Puma
=> Rails 8.1.3.1 application starting in development
Puma starting in single mode...
* Puma version: 7.2.1 ("On The Corner")
* Ruby version: ruby 3.4.5 (2025-07-16 revision 20cda200d3) +PRISM [x86_64-linux]
*  Min threads: 5
*  Max threads: 5
*  Environment: development
*          PID: 104
* Listening on http://0.0.0.0:3000

curl -sS -o /dev/null -w "HTTP %{http_code}\n" http://localhost:8131/

HTTP 200

docker compose exec -T uwsgi rails runner 'puts Community.first.name'
# => Dev Community
docker compose exec -T uwsgi rails runner 'u = User.find_by(username: "admin"); puts "admin user: id=#{u.id} global_admin=#{u.is_global_admin} email=#{u.email}"'
# => admin user: id=1 global_admin=true email=admin@example.com

COMMUNITY_ADMIN_EMAIL=admin@example.com
COMMUNITY_ADMIN_PASSWORD=q1w2e3r4
COMMUNITY_ADMIN_USERNAME=admin
COMMUNITY_NAME=Dev Community
CONFIRMABLE_ALLOWED_ACCESS_DAYS=2
LOCAL_DEV_PORT=8131
MAILER_PROTOCOL=https
RAILS_ENV=development

name: qpixel-0.13.0-stack
services:
  db:
    restart: on-failure:3
    build: { context: ".", dockerfile: docker/Dockerfile.db }
    volumes:
      - ./docker/db-entrypoint.sh:/docker/entrypoint.sh
      - ./docker/mysql:/var/lib/mysql
    env_file: [ ${ENV_FILE_LOCATION} ]
    cap_add: [ SYS_NICE ]
    healthcheck:
      test: mysqladmin ping -h 127.0.0.1 -u $$MYSQL_USER --password=$$MYSQL_PASSWORD
      start_period: 5s
      interval: 5s
      timeout: 5s
      retries: 12
  uwsgi:
    restart: on-failure:3
    build: { context: ".", dockerfile: ${CLIENT_DOCKERFILE} }
    depends_on:
      db: { condition: service_healthy }
      redis: { condition: service_healthy }
    ports: [ "${LOCAL_DEV_PORT}:3000" ]
    volumes:
      - .:/code
      - ./static:/var/www/static
      - ./images:/var/www/images
    links: [ redis, db ]
  redis:
    restart: on-failure:3
    image: redis:latest
    healthcheck: { test: ["CMD", "redis-cli", "ping"] }
networks:
  default:
    name: qpixel-v0.13.0-net
    ipam: { config: [ { subnet: 10.89.68.0/24 } ] }

#!/bin/bash

mysqld --init-file=/docker-entrypoint-initdb.d/mysql-init.sql \
       --mysql-native-password=on \
       --skip-mysqlx

default: &default
  adapter: mysql2
  encoding: utf8mb4
  collation: utf8mb4_unicode_ci
  host: db
  port: 3306
  username: qpixel
  password: qpixel

development:
  <<: *default
  database: qpixel_dev

test:
  <<: *default
  database: qpixel_test

production:
  <<: *default
  database: qpixel

redis_default: &redis_default
  host: redis
  port: 6379

redis_development:
  <<: *redis_default

redis_test:
  <<: *redis_default

redis_production:
  <<: *redis_default

docker network create --subnet 10.89.68.0/24 qpixel-v0.13.0-net

docker run -d --name qp-db \
  --network qpixel-v0.13.0-net \
  --cap-add SYS_NICE \
  --env-file ./docker/env \
  -v "$(pwd)/docker/db-entrypoint.sh:/docker/entrypoint.sh" \
  -v "$(pwd)/docker/mysql:/var/lib/mysql" \
  qpixel-0130-stack-db

docker run -d --name qp-redis \
  --network qpixel-v0.13.0-net \
  redis:latest

docker run -d --name qp-app \
  --network qpixel-v0.13.0-net \
  -p 8131:3000 \
  --env-file ./docker/env \
  -e COMMUNITY_NAME="Dev Community" \
  -e RAILS_ENV=development \
  -e MAILER_PROTOCOL=https \
  -e CONFIRMABLE_ALLOWED_ACCESS_DAYS=2 \
  -e LOCAL_DEV_PORT=8131 \
  -v "$(pwd):/code" \
  -v "$(pwd)/static:/var/www/static" \
  -v "$(pwd)/images:/var/www/images" \
  qpixel-0130-stack-uwsgi

cd /opt/data/quzuo/tmp/qpixel/qpixel-0.13.0

docker compose ps                          # 三服务状态（本文第一章回显）
docker compose logs -f --tail 50 uwsgi     # 跟踪应用日志（Puma 访问/报错）
docker compose logs --tail 30 db           # 查看 MySQL 日志
docker compose restart uwsgi               # 改 config/*.yml、代码后重启应用
docker compose exec -T uwsgi rails runner '<Ruby 代码>'   # 数据层操作入口
docker compose exec -T db sh -c 'mysql -uqpixel -pqpixel qpixel_dev -e "SHOW TABLES"'  # 直查库
docker compose stop / start                # 停/起（数据保留）
docker compose down                        # 删容器与网络（bind 数据保留）
docker compose down -v                     # 本栈无命名卷，效果同 down；数据在 ./docker/mysql，删它才是清库