使用 Umami 对博客网站进行网络分析

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12

# 更新软件包源和软件包
$ sudo apt update
$ sudo apt upgrade

# 安装 MySQL
$ sudo apt install mysql-server

# 开启 MySQL 服务
$ sudo systemctl start mysql.service

# 针对 MySQL 的安全性配置
$ sudo mysql_secure_installation

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14

# 以管理员身份登录 MySQL
$ sudo mysql

# 添加新用户 umami
> CREATE USER 'umami'@'localhost' IDENTIFIED BY 'password';

# 为新用户 umami 添加数据库操作权限
> GRANT CREATE, ALTER, DROP, INSERT, UPDATE, INDEX, DELETE, SELECT, REFERENCES, RELOAD on *.* TO 'umami'@'localhost' WITH GRANT OPTION;

# 刷新 privilege 表，使上述修改立即生效
> FLUSH PRIVILEGES;

# 退出 MySQL
> exit

1
2
3
4
5
6
7
8

# 以新用户 umami 登录 MySQL
$ mysql -u umami -p

# 为 Umami 网络分析创建数据库
> CREATE DATABASE IF NOT EXISTS umami

# 退出 MySQL
> exit

1
2
3
4
5

# 查看 MySQL 服务运行状态
$ systemctl status mysql.service

# 查看 umami 用户状态
$ sudo mysqladmin -p -u umami version

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22

# 更新软件包源和软件包
$ sudo apt update
$ sudo apt upgrade

$ sudo apt install -y ca-certificates curl gnupg

# 下载并导入 Nodesource GPG key
$ sudo mkdir -p /etc/apt/keyrings
$ curl -fsSL https://deb.nodesource.com/gpgkey/nodesource-repo.gpg.key | sudo gpg --dearmor -o /etc/apt/keyrings/nodesource.gpg

# 创建 deb repository
$ NODE_MAJOR=20
$ echo "deb [signed-by=/etc/apt/keyrings/nodesource.gpg] https://deb.nodesource.com/node_$NODE_MAJOR.x nodistro main" | sudo tee /etc/apt/sources.list.d/nodesource.list

# 更新软件包源
$ sudo apt update

# 安装 Node.js
$ sudo apt install nodejs -y

# 查看 Node.js 版本号
$ node -v

1
2
3
4
5
6
7
8
9

# 安装 Yarn 包管理器
$ sudo npm install -g yarn

# 获取 Umami 源代码
$ git clone https://github.com/umami-software/umami.git

# 安装 Umami
$ cd umami
$ sudo yarn install

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16

verbose 74.983659555 Error: /home/ubuntu/umami/node_modules/sharp: Command failed.
Exit code: 1
Command: (node install/libvips && node install/dll-copy && prebuild-install) || (node install/can-compile && node-gyp rebuild && node install/dll-copy)
Arguments: 
Directory: /home/ubuntu/umami/node_modules/sharp
Output:
sharp: Downloading https://github.com/lovell/sharp-libvips/releases/download/v8.14.5/libvips-8.14.5-linux-x64.tar.br
sharp: Installation error: aborted
sharp: Please see https://sharp.pixelplumbing.com/install for required dependencies
    at ProcessTermError.ExtendableBuiltin (/usr/lib/node_modules/yarn/lib/cli.js:721:66)
    at ProcessTermError.MessageError (/usr/lib/node_modules/yarn/lib/cli.js:750:123)
    at new ProcessTermError (/usr/lib/node_modules/yarn/lib/cli.js:790:113)
    at ChildProcess.<anonymous> (/usr/lib/node_modules/yarn/lib/cli.js:25787:17)
    at ChildProcess.emit (node:events:514:28)
    at maybeClose (node:internal/child_process:1105:16)
    at ChildProcess._handle.onexit (node:internal/child_process:305:5)

1
2
3
4
5
6
7
8
9

# 打开或创建项目目录下的 yarn 配置文件 .yarnrc
$ vim .yarnrc

# 设置 sharp 以及 libvips 的镜像地址
sharp_binary_host "https://npmmirror.com/mirrors/sharp"
sharp_libvips_binary_host "https://npmmirror.com/mirrors/sharp-libvips"

# 重新安装 Umami
$ sudo yarn install

1
2
3
4

$ vim .env

# 配置数据库地址
DATABASE_URL=mysql://umami:password@localhost:3306/umami

1

$ sudo yarn build

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19

# 安装 pm2
$ sudo yarn global add pm2

# 运行 Umami
$ cd umami
$ pm2 start yarn --name umami -- start

# 系统重启时自动运行 pm2 管理的服务
$ pm2 startup
$ pm2 save

# pm2 常用操作命令，app_name 也可用进程在 pm2 中的 id 代替
$ pm2 start python-app.py --interpreter python3 --attach
$ pm2 logs
$ pm2 status
$ pm2 restart app_name
$ pm2 reload app_name
$ pm2 stop app_name
$ pm2 delete app_name

 1
 2
 3
 4
 5
 6
 7
 8
 9
10

server {
    server_name umami.yourdomain.com;

    location / {
        proxy_pass http://localhost:3000;
        proxy_set_header X-Real-IP $remote_addr;
        proxy_set_header Host $host;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
    }
}

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11

# 从 Git 仓库拉取更新
git pull

# 安装、更新依赖项
yarn install

# 重新构建 Umami
yarn build

# 重启 Umami
pm2 restart umami