cd /opt/data/quzuo/tmp/plainpad/stack
docker compose exec plainpad php artisan about

PHP Deprecated:  Constant PDO::MYSQL_ATTR_SSL_CA is deprecated since 8.5, use Pdo\Mysql::ATTR_SSL_CA instead in /var/www/html/config/database.php on line 62

  Environment ................................................................  
  Application Name .................................................. Plainpad  
  Laravel Version .................................................... 12.69.0  
  PHP Version ......................................................... 8.5.12  
  Composer Version ......................................................... -  
  Environment ..................................................... production  
  Debug Mode ............................................................. OFF  
  URL ......................................................... localhost:8139  
  Maintenance Mode ....................................................... OFF  
  Timezone ............................................................... UTC  
  Locale ............................................................... en-US  

  Cache ......................................................................  
  Config .......................................................... NOT CACHED  
  Events .......................................................... NOT CACHED  
  Routes .......................................................... NOT CACHED  
  Views ........................................................... NOT CACHED  

  Drivers ....................................................................  
  Broadcasting .......................................................... null  
  Cache ................................................................. file  
  Database ............................................................. mysql  
  Logs ................................................................. daily  
  Mail .......................................................................  
  Queue ................................................................. sync  
  Session ............................................................... file  

  Storage ....................................................................  
  public/storage .................................................. NOT LINKED  

cd /opt/data/quzuo/tmp/plainpad/stack
docker compose ps

NAME                 IMAGE                            COMMAND                  SERVICE    CREATED          STATUS          PORTS
plainpad-1.2.0-app   alextselegidis/plainpad:latest   "docker-entrypoint.sh"   plainpad   14 minutes ago   Up 14 minutes   0.0.0.0:8139->80/tcp, [::]:8139->80/tcp
plainpad-1.2.0-db    mysql:8.0                        "docker-entrypoint.s…"   mysql      25 minutes ago   Up 25 minutes   3306/tcp, 33060/tcp

curl -s -X POST http://localhost:8139/api.php/v1/sessions \
  -H 'Content-Type: application/json' \
  -d '{"email":"admin@example.org","password":"12345678"}'
# {"user_id":"7a17c8fd-b84f-4f2c-8ba3-2a484c1a0e1e","expires_at":"2026-11-02 12:20:47","token":"FE5Is0r75P5jZoalOwHKpWi0NlAsAJwNGRWsRqqFNcwtwD9kWCLQk5RDEPxS"}

export TOKEN=FE5Is0r75P5jZoalOwHKpWi0NlAsAJwNGRWsRqqFNcwtwD9kWCLQk5RDEPxS

docker compose exec plainpad cat .env

APP_NAME=Plainpad
APP_ENV=production
APP_KEY={KEY}
APP_DEBUG=false
APP_URL=http://localhost:8139
APP_REPOSITORY=https://cdn.alextselegidis.com/plainpad/updates/stable
DB_CONNECTION=mysql
DB_HOST=mysql
DB_PORT=3306
DB_DATABASE=plainpad
DB_USERNAME=root
DB_PASSWORD=secret

docker compose up -d plainpad

docker compose exec mysql mysql -uroot -psecret -e 'select name,value from plainpad.settings;'

name                value
mail_from_address   notes@quzuo.net
mail_port           1025
mail_password       
mail_from_name      Plainpad
default_locale      zh-CN
mail_driver         smtp
mail_host           10.89.58.1
mail_encryption     
mail_username       

curl -s http://localhost:8139/api.php/v1/settings -H "Authorization: Bearer $TOKEN"
# {"mail_from_address":"notes@quzuo.net","mail_port":"1025","mail_password":"","mail_from_name":"Plainpad","default_locale":"zh-CN","mail_driver":"smtp","mail_host":"10.89.58.1","mail_encryption":"","mail_username":""}

docker compose exec mysql mysql -uroot -psecret -e 'describe plainpad.users;'

Field       Type                          Null  Key  Default
id          varchar(255)                  NO    PRI  NULL
created_at  timestamp                     YES        NULL
updated_at  timestamp                     YES        NULL
name        varchar(255)                  NO         NULL
email       varchar(255)                  NO    MUL  NULL
password    varchar(255)                  NO         NULL
locale      varchar(255)                  NO         en-US
view        enum('comfortable','compact') NO         compact
line        enum('full','narrow')         NO         full
sort        enum('modified','created','alphabetical')  NO  modified
theme       enum('light','dark')          NO         light
encrypt     tinyint(1)                    NO         0
admin       tinyint(1)                    NO         0

docker compose exec plainpad php artisan list | grep -E '^\s+(refresh|cleanup)'

  cleanup                   Removed unnecessary system files.
  refresh                   Refresh the Plainpad installation after an update.

docker compose exec plainpad php artisan tinker --execute="echo config('app.key');"
# base64:vB6IesmBqpSCj5ruR1H0PjcSecgiBVNtdBjCNdRaeI0=

if grep -q "APP_KEY=$" /var/www/html/.env || grep -q "APP_KEY={KEY}" /var/www/html/.env; then
    cd /var/www/html && php artisan key:generate --force
fi

echo "base64:$(openssl rand -base64 32)"

if [ -n "$BASE_URL" ]; then
    sed -i "s|APP_URL=.*|APP_URL=${BASE_URL}|g" /var/www/html/.env
fi
if [ -n "$DEBUG_MODE" ]; then
    if [ "$DEBUG_MODE" = "TRUE" ] || [ "$DEBUG_MODE" = "true" ]; then
        sed -i "s|APP_DEBUG=.*|APP_DEBUG=true|g" /var/www/html/.env
    else
        sed -i "s|APP_DEBUG=.*|APP_DEBUG=false|g" /var/www/html/.env
    fi
fi

docker compose exec plainpad grep -rn "APP_REPOSITORY" app/
# app/Providers/AutoUpdateServiceProvider.php:21:            $autoUpdateService->setUpdateUrl(env('APP_REPOSITORY'));

curl -s -X PUT http://localhost:8139/api.php/v1 -H "Authorization: Bearer $TOKEN" -w '\nHTTP %{http_code}\n'
# HTTP 404

curl -s -X PUT http://localhost:8139/api.php/v1/settings \
  -H "Authorization: Bearer $TOKEN" -H 'Content-Type: application/json' \
  -d '{"default_locale":"zh-CN","mail_driver":"smtp","mail_host":"10.89.58.1","mail_port":"1025","mail_username":"","mail_password":"","mail_encryption":"","mail_from_address":"notes@quzuo.net","mail_from_name":"Plainpad"}' \
  -w '\nHTTP %{http_code}\n'
# HTTP 200（成功时响应体为空）

curl -s http://localhost:8139/api.php/v1/settings -H "Authorization: Bearer $TOKEN"
# {"mail_from_address":"notes@quzuo.net","mail_port":"1025","mail_password":"","mail_from_name":"Plainpad","default_locale":"zh-CN","mail_driver":"smtp","mail_host":"10.89.58.1","mail_encryption":"","mail_username":""}

curl -s -X PUT http://localhost:8139/api.php/v1/users/7a17c8fd-b84f-4f2c-8ba3-2a484c1a0e1e \
  -H "Authorization: Bearer $TOKEN" -H 'Content-Type: application/json' \
  -d '{"name":"Admin","email":"admin@example.org","locale":"en-US","view":"compact","line":"full","sort":"modified","theme":"light","admin":true,"encrypt":true}'
# {"id":"7a17c8fd-b84f-4f2c-8ba3-2a484c1a0e1e","created_at":"2026-11-02T00:20:21.000000Z","updated_at":"2026-11-02T00:47:23.000000Z","name":"Admin","email":"admin@example.org","locale":"en-US","view":"compact","line":"full","sort":"modified","theme":"light","encrypt":true,"admin":true}

curl -s -X POST http://localhost:8139/api.php/v1/notes \
  -H "Authorization: Bearer $TOKEN" -H 'Content-Type: application/json' \
  -d '{"title":"加密测试标题","content":"这是会被服务端加密的正文内容。","pinned":false}'
# 输出节选：{"id":"01c33676-f0ec-49a5-a7eb-32b1e8afe0c8",...,"title":"\u52a0\u5bc6\u6d4b\u8bd5\u6807\u9898","content":"\u8fd9\u662f\u4f1a\u88ab\u670d\u52a1\u7aef\u52a0\u5bc6\u7684\u6b63\u6587\u5185\u5bb9\u3002",...}

docker compose exec mysql mysql -uroot -psecret -e "select left(title,60) as t,left(content,60) as c from plainpad.notes;"

t                                                            c
eyJpdiI6Im1FZnRMZzJ0MUZYZnJjZFNwS2lxU2c9PSIsInZhbHVlIjoiZ0hx  eyJpdiI6IjA2YzZpUGoyMTZsalQ2UXdWa0hBYkE9PSIsInZhbHVlIjoiV2hw

docker compose exec mysql mysql --default-character-set=utf8mb4 -uroot -psecret -e "select left(title,30) as t,left(content,30) as c from plainpad.notes;"

t          c
明文基线    关闭状态下的正文

name: plainpad-prod

services:
  plainpad:
    image: alextselegidis/plainpad:latest
    depends_on:
      - mysql
    ports:
      - '127.0.0.1:80:80'          # 只监听回环，由 Nginx/Caddy 反代终结 TLS
    environment:
      - APP_KEY=base64:你的固定密钥-openssl-rand-base64-32生成后存入密码管理器
      - BASE_URL=https://notes.example.com
      - DEBUG_MODE=FALSE
      - DB_HOST=mysql
      - DB_NAME=plainpad
      - DB_USERNAME=plainpad
      - DB_PASSWORD=换强口令与mysql服务一致
    networks:
      - plainpad-net

  mysql:
    image: mysql:8.0
    command: --default-authentication-plugin=mysql_native_password
    environment:
      - MYSQL_ROOT_PASSWORD=换强口令
      - MYSQL_DATABASE=plainpad
      - MYSQL_USER=plainpad
      - MYSQL_PASSWORD=与上方DB_PASSWORD一致
    volumes:
      - db_data:/var/lib/mysql
    networks:
      - plainpad-net

volumes:
  db_data:

networks:
  plainpad-net:
    driver: bridge

curl -s -o /dev/null -w 'HTTP %{http_code}\n' https://notes.example.com/   # 期望 200

ERROR  Unable to set application key. APP_KEY is already present in the environment.