Files
Leantime/.dev/remote-deploy/01_unpack_db.sh

57 lines
1.4 KiB
Bash

#!/bin/bash
set -e
APP_DIR=/var/www/onebot
SRC_TAR=/home/rui/onebot-src.tar.gz
echo "=== 1. 解压源码 ==="
sudo rm -rf "$APP_DIR"
sudo mkdir -p "$APP_DIR"
sudo tar -xzf "$SRC_TAR" -C "$APP_DIR" --strip-components=1
sudo chown -R "$USER":www-data "$APP_DIR"
echo "解压完成,目录内容:"
ls "$APP_DIR" | head -20
echo "=== 2. 初始化 MySQL 数据库 ==="
DB_NAME=onebot
DB_USER=onebot
DB_PASS='OneBot_Db_7xKpQ9z'
sudo mysql <<SQL
CREATE DATABASE IF NOT EXISTS ${DB_NAME} CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE USER IF NOT EXISTS '${DB_USER}'@'localhost' IDENTIFIED BY '${DB_PASS}';
GRANT ALL PRIVILEGES ON ${DB_NAME}.* TO '${DB_USER}'@'localhost';
FLUSH PRIVILEGES;
SQL
echo "数据库 ${DB_NAME} 创建完成,验证连接:"
mysql -u"$DB_USER" -p"$DB_PASS" -e "SELECT VERSION();" "$DB_NAME" 2>/dev/null && echo "DB_CONNECT_OK"
echo "=== 3. 创建 .env ==="
cat > "$APP_DIR/.env" <<ENV
APP_ENV=production
APP_DEBUG=false
APP_URL=http://119.29.53.45:8081
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=${DB_NAME}
DB_USERNAME=${DB_USER}
DB_PASSWORD=${DB_PASS}
LEAN_DB_HOST=127.0.0.1
LEAN_DB_USER=${DB_USER}
LEAN_DB_PASSWORD=${DB_PASS}
LEAN_DB_DATABASE=${DB_NAME}
LEAN_APP_URL=http://119.29.53.45:8081
LEAN_SITENAME='OneBot'
LEAN_LANGUAGE='zh-CN'
LEAN_SESSION_PASSWORD='OneBot_Session_4tHwLq8z'
ENV
echo ".env 写入完成:"
cat "$APP_DIR/.env"
echo "=== 全部完成 ==="