waline独立部署踩坑实录

也算是这个小破站的第一篇文章

也是随手做了这个博客，感觉评论很有意思，虽然不会有人评论，但是就想搞一哈，万一呢

这个是waline的官方文档，超级简单，也是我踩坑的源头

docker部署(最后放弃了)#

首先在虚拟机上安装了docker，然后创建目录/app/waline，创建docker-compose.yml文件

1
version: '3'
2

3
services:
4
  waline:
5
    container_name: waline
6
    image: lizheming/waline:latest
7
    restart: always
8
    ports:
9
      - 8360:8360
10
    volumes:
11
      - ${PWD}/data:/app/data
12
    environment:
13
      TZ: 'Asia/Shanghai'
14
      SQLITE_PATH: '/app/data'
15
      JWT_TOKEN: 'Your token'
16
      SITE_NAME: 'Your site name'
17
      SITE_URL: 'https://example.com'
18
      SECURE_DOMAINS: 'example.com'
19
      AUTHOR_EMAIL: 'mail@example.com'

里面的环境变量改了一下，执行docker compose up -d发现没问题，开开心心去到页面评论一下，waline的接口直接500

用docker compose logs查看日志

1
waline  | [2026-07-13T16:37:50.094] [1] [INFO] - Server running at http://127.0.0.1:8360
2
waline  | [2026-07-13T16:37:50.097] [1] [INFO] - ThinkJS version: 4.0.0
3
waline  | [2026-07-13T16:37:50.097] [1] [INFO] - Environment: production
4
waline  | [2026-07-13T16:37:50.097] [1] [INFO] - Workers: 1
5
waline  |
6
waline  |   TypeError: fetch failed
7
waline  |

这种日志我是真的没办法看出是哪里出问题了，所以在官网尝试找到Debug日志在哪里配，最后没找到

所以，我直接放弃

虚拟机部署(可以参照这个)#

TIP

系统为Rocky 9.7

目录介绍：
/app/blog/dist (博客build产物)
/app/waline (waline)

数据库部署及配置#

首先安装mysql

1
dnf install mysql-server

设置mysql端口不在公网暴露

1
[mysqld]
2
datadir=/var/lib/mysql
3
socket=/var/lib/mysql/mysql.sock
4
log-error=/var/log/mysql/mysqld.log
5
pid-file=/run/mysqld/mysqld.pid
6
bind-address=127.0.0.1
7
mysqlx-bind-address=127.0.0.1

启动mysql

1
systemctl enable mysqld --now

初始化数据库

1
CREATE DATABASE waline DEFAULT CHARSET=utf8 DEFAULT COLLATE utf8_unicode_ci;
2
CREATE USER waline IDENTIFIED BY 'waline';
3
GRANT ALL PRIVILEGES ON waline.* TO waline;
4
ALTER USER 'waline'@'%' IDENTIFIED WITH mysql_native_password BY 'waline';
5
FLUSH PRIVILEGES;
6
USE dbwaline;

1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
2
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
3
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
4
/*!40101 SET NAMES utf8 */;
5
SET NAMES utf8mb4;
6
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
7
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
8
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
9

10

11
# Dump of table wl_Comment
12
DROP TABLE IF EXISTS `wl_Comment`;
13
# ------------------------------------------------------------
14

15
CREATE TABLE `wl_Comment` (
16
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
17
  `user_id` int(11) DEFAULT NULL,
18
  `comment` text,
19
  `insertedAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
20
  `ip` varchar(100) DEFAULT '',
21
  `link` varchar(255) DEFAULT NULL,
22
  `mail` varchar(255) DEFAULT NULL,
23
  `nick` varchar(255) DEFAULT NULL,
24
  `pid` int(11) DEFAULT NULL,
25
  `rid` int(11) DEFAULT NULL,
26
  `sticky` boolean DEFAULT NULL,
27
  `status` varchar(50) NOT NULL DEFAULT '',
28
  `like` int(11) DEFAULT NULL,
29
  `ua` text,
30
  `url` varchar(255) DEFAULT NULL,
31
  `createdAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
32
  `updatedAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
33
  PRIMARY KEY (`id`),
34
  INDEX `idx_comment_url` (`url`),
35
  INDEX `idx_comment_user_id` (`user_id`),
36
  INDEX `idx_comment_status` (`status`),
37
  INDEX `idx_comment_pid_rid` (`pid`, `rid`),
38
  INDEX `idx_comment_created_at` (`createdAt`),
39
  INDEX `idx_comment_updated_at` (`updatedAt`),
40
  INDEX `idx_comment_sticky` (`sticky`)
41
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
42

43

44

45
# Dump of table wl_Counter
46
DROP TABLE IF EXISTS `wl_Counter`;
47
# ------------------------------------------------------------
48

49
CREATE TABLE `wl_Counter` (
50
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
51
  `time` int(11) DEFAULT NULL,
52
  `reaction0` int(11) DEFAULT NULL,
53
  `reaction1` int(11) DEFAULT NULL,
54
  `reaction2` int(11) DEFAULT NULL,
55
  `reaction3` int(11) DEFAULT NULL,
56
  `reaction4` int(11) DEFAULT NULL,
57
  `reaction5` int(11) DEFAULT NULL,
58
  `reaction6` int(11) DEFAULT NULL,
59
  `reaction7` int(11) DEFAULT NULL,
60
  `reaction8` int(11) DEFAULT NULL,
61
  `url` varchar(255) NOT NULL DEFAULT '',
62
  `createdAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
63
  `updatedAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
64
  PRIMARY KEY (`id`),
65
  INDEX `idx_counter_url` (`url`),
66
  INDEX `idx_counter_time` (`time`),
67
  INDEX `idx_counter_created_at` (`createdAt`)
68
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
69

70

71

72
# Dump of table wl_Users
73
DROP TABLE IF EXISTS `wl_Users`;
74
# ------------------------------------------------------------
75

76
CREATE TABLE `wl_Users` (
77
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
78
  `display_name` varchar(255) NOT NULL DEFAULT '',
79
  `email` varchar(255) NOT NULL DEFAULT '',
80
  `password` varchar(255) NOT NULL DEFAULT '',
81
  `type` varchar(50) NOT NULL DEFAULT '',
82
  `label` varchar(255) DEFAULT NULL,
83
  `url` varchar(255) DEFAULT NULL,
84
  `avatar` varchar(255) DEFAULT NULL,
85
  `github` varchar(255) DEFAULT NULL,
86
  `twitter` varchar(255) DEFAULT NULL,
87
  `facebook` varchar(255) DEFAULT NULL,
88
  `google` varchar(255) DEFAULT NULL,
89
  `weibo` varchar(255) DEFAULT NULL,
90
  `qq` varchar(255) DEFAULT NULL,
91
  `oidc` varchar(255) DEFAULT NULL,
92
  `huawei` varchar(255) DEFAULT NULL,
93
  `2fa` varchar(32) DEFAULT NULL,
94
  `createdAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
95
  `updatedAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
96
  PRIMARY KEY (`id`),
97
  UNIQUE INDEX `idx_user_email` (`email`),
98
  INDEX `idx_user_type` (`type`),
99
  INDEX `idx_user_created_at` (`createdAt`)
100
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
101

102

103

104

105
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
106
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
107
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
108
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
109
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
110
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

waline部署#

安装nodejs 24

1
curl -o- https://raw.githubusercontent.com/nvm-sh/nvm/v0.40.5/install.sh | bash
2
\. "$HOME/.nvm/nvm.sh"
3
nvm install 24

安装waline

1
mkdir -p /app/waline && cd $_
2

3
npm install @waline/vercel

使用systemd管理，请自行修改第5行node的路径

1
[Unit]
2
Description=A simple comment system with backend support fork from Valine.
3

4
[Service]
5
ExecStart=/root/.nvm/versions/node/v24.18.0/bin/node /app/waline/node_modules/@waline/vercel/vanilla.js
6
Restart=always
7
Environment=PATH=/usr/bin:/usr/local/bin
8
Environment=NODE_ENV=production
9
Environment=MYSQL_HOST=127.0.0.1
10
Environment=MYSQL_PORT=3306
11
Environment=MYSQL_DB=waline
12
Environment=MYSQL_USER=waline
13
Environment=MYSQL_PASSWORD=waline
14
WorkingDirectory=/app/waline
15
Environment=SMTP_SERVICE=QQ
16
Environment=SMTP_USER=你的qq邮箱
17
Environment=SMTP_PASS=你的qq邮箱密码(不是登录密码)
18
Environment=SMTP_SECURE=true
19
Environment=SITE_NAME=邮件中的博客的名字
20
Environment=SITE_URL=博客地址
21
Environment=AUTHOR_EMAIL=你的qq邮箱
22

23
[Install]
24
WantedBy=multi-user.target

启动waline

1
systemctl enable waline --now

nginx配置#

添加对应的路由

1
server {
2
    listen 443 ssl;
3
    listen [::]:443 ssl;
4
    server_name blog.miraclesses.top;
5

6
    ssl_certificate /etc/letsencrypt/live/blog.miraclesses.top/fullchain.pem;
7
    ssl_certificate_key /etc/letsencrypt/live/blog.miraclesses.top/privkey.pem;
8

9
    ssl_protocols TLSv1.1 TLSv1.2 TLSv1.3;
10
    ssl_ciphers EECDH+CHACHA20:EECDH+CHACHA20-draft:EECDH+AES128:RSA+AES128:EECDH+AES256:RSA+AES256:EECDH+3DES:RSA+3DES:!MD5;
11
    ssl_prefer_server_ciphers on;
12
    ssl_session_cache shared:SSL:10m;
13
    ssl_session_timeout 10m;
14

15
    access_log logs/blog_access.log;
16

17
    location ~ ^/(api|ui|verification) {
18
        proxy_pass http://127.0.0.1:8360;
19
        proxy_set_header Host $host;
20
        proxy_set_header X-Real-IP $remote_addr;
21
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
22
        proxy_set_header X-Forwarded-Proto $scheme;
23
        proxy_set_header REMOTE-HOST $remote_addr;
24
        proxy_no_cache 1;
25
        proxy_cache_bypass 1;
26
        add_header Cache-Control "no-cache, no-store, must-revalidate";
27
        add_header Pragma "no-cache";
28
        add_header Expires "0";
29
    }
30

31
    location / {
32
        root /app/blog/dist ;
33
        index index.html index.htm;
34
    }
35
}

至此，就算搞定了

docker部署(最后放弃了)#

虚拟机部署(可以参照这个)#

数据库部署及配置#

waline部署#

nginx配置#

文章分享

评论区

文章目录