目錄表

Dokuwiki docker image 加入 mysql client 相關套件

處理方式

  1. 建立 custom-init 目錄

    mkdir -p custom-init

  2. 新增容器初始化腳本
    custom-init/10-install-mysqli.sh
    #!/bin/bash
     
    # 安裝 mysql client 相關套件
    apk add --no-cache mysql-client php-mysqli
     
    # 重啟 PHP-FPM 讓套件生效
    s6-svc -r /run/service/svc-php-fpm
     

    https://raw.githubusercontent.com/tryweb/docker-compose/refs/heads/main/dokuwiki/custom-init/10-install-mysqli.sh

  3. 修改 docker-compose.yml 掛上 custom-init
    docker-compose.yml
    services:
      dokuwiki:
        image: lscr.io/linuxserver/dokuwiki:latest
        container_name: dokuwiki
        environment:
          - PUID=1000
          - PGID=1000
          - TZ=Asia/Taipei
        ports:
          - 80:80
          - 443:443
        restart: always
        volumes:
          - ./dokuwiki_data:/config
          - ./custom-init:/custom-cont-init.d
     
      mariadb:
        image: mariadb
        container_name: db
        ports:
          - 3306:3306
        environment:
          - MARIADB_ROOT_PASSWORD=${MARIADB_ROOT_PASSWORD}
          - TZ=Asia/Taipei
        restart: always
        volumes:
          - ./db_data:/var/lib/mysql
     
      adminer:
        image: adminer
        container_name: adminer
        restart: always
        ports:
          - 8080:8080
     
      watchtower:
        container_name: watchtower
        image: containrrr/watchtower
        volumes:
          - /var/run/docker.sock:/var/run/docker.sock
        environment:
          - TZ=Asia/Taipei
          - WATCHTOWER_SCHEDULE=0 30 23 * * *
          - WATCHTOWER_CLEANUP=true
        labels:
          - "com.centurylinklabs.watchtower.enable=true"
        restart: unless-stopped
     

    https://raw.githubusercontent.com/tryweb/docker-compose/refs/heads/main/dokuwiki/docker-compose.yml

  4. 重新啟動 docker compose

    docker compose down
    docker compose up -d

確認是否正常啟動

  • 如果編輯 wiki 頁面儲存出現異常, 錯誤訊息 Field 'dt' doesn't have a default value
  • 針對 stats_edits 與 stats_lastseen 兩個 Table 內的 dt 欄位設定預設值 current_timestamp() 就可以解決
    ALTER TABLE `stats_edits`
    MODIFY COLUMN `dt` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP() ON UPDATE CURRENT_TIMESTAMP();
     
    ALTER TABLE `stats_lastseen`
    MODIFY COLUMN `dt` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP() ON UPDATE CURRENT_TIMESTAMP();
1)
lscr.io/linuxserver/dokuwiki:latest