106 lines
3.3 KiB
Plaintext
106 lines
3.3 KiB
Plaintext
|
#win系统发布
|
|||
|
|
dotnet publish -r win-x64 -c Release -o bin/Release/publish --sc -p:PublishSingleFile=true -p:IncludeNativeLibrariesForSelfExtract=true -p:DebugType=None
|
|||
|
|
|
|||
|
|
#linux系统发布
|
|||
|
|
dotnet publish -r linux-x64 -c Release -o bin/Release/publish-linux --sc ^
|
|||
|
|
-p:PublishSingleFile=true ^
|
|||
|
|
-p:IncludeNativeLibrariesForSelfExtract=true ^
|
|||
|
|
-p:DebugType=None
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
#linux系统mysql安装
|
|||
|
|
Mysql软件仓库镜像
|
|||
|
|
https://mirrors.tuna.tsinghua.edu.cn/help/mysql/
|
|||
|
|
#ssh远程连接
|
|||
|
|
ssh wcs@192.168.3.56
|
|||
|
|
打开之前创建的 MySQL 源文件
|
|||
|
|
sudo nano /etc/apt/sources.list.d/mysql.list
|
|||
|
|
# 只保留mysql-tools和必要的二进制源（适配bullseye）
|
|||
|
|
deb https://mirrors.tuna.tsinghua.edu.cn/mysql/apt/debian bullseye mysql-tools
|
|||
|
|
sudo apt clean
|
|||
|
|
sudo apt update
|
|||
|
|
sudo apt install mysql-community-server -y
|
|||
|
|
|
|||
|
|
mysql -u root -p，然后输入 MySQL 的登录密码（输入时不显示，输完回车）
|
|||
|
|
执行sql脚本
|
|||
|
|
source /home/wcs/Downloads/create.sql
|
|||
|
|
|
|||
|
|
打开终端，输入命令查看配置文件
|
|||
|
|
sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
|
|||
|
|
|
|||
|
|
sudo systemctl start mysql # 启动服务（若未启动）
|
|||
|
|
sudo systemctl status mysql # 查看状态，需显示“active (running)”
|
|||
|
|
查看端口监听情况
|
|||
|
|
netstat -tlnp | grep mysql
|
|||
|
|
|
|||
|
|
sudo systemctl restart mysql
|
|||
|
|
|
|||
|
|
# 先更新软件源，确保能找到最新包
|
|||
|
|
sudo apt update
|
|||
|
|
# 安装 iptables
|
|||
|
|
sudo apt install iptables -y
|
|||
|
|
|
|||
|
|
sudo /usr/sbin/iptables -A INPUT -p tcp --dport 3307 -j ACCEPT
|
|||
|
|
sudo iptables-save | sudo tee /etc/iptables/rules.v4 > /dev/null
|
|||
|
|
|
|||
|
|
CREATE USER IF NOT EXISTS 'root'@'%' IDENTIFIED BY '123456';
|
|||
|
|
|
|||
|
|
# 查看 MySQL 进程监听的端口
|
|||
|
|
sudo netstat -tulpn | grep mysql
|
|||
|
|
|
|||
|
|
-- 允许 root 从任意 IP 连接（% 表示所有 IP）
|
|||
|
|
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '你的密码' WITH GRANT OPTION;
|
|||
|
|
-- 刷新权限
|
|||
|
|
FLUSH PRIVILEGES;
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
#生成密钥
|
|||
|
|
netsparkle-generate-appcast --generate-keys
|
|||
|
|
netsparkle-generate-appcast --export
|
|||
|
|
|
|||
|
|
#生成appcast文件
|
|||
|
|
netsparkle-generate-appcast ^
|
|||
|
|
-b D:\NetSparkleUpdates\ ^
|
|||
|
|
-p D:\NetSparkleUpdates\change ^
|
|||
|
|
-u http://192.168.3.238:4567/ ^
|
|||
|
|
--generate-signature
|
|||
|
|
|
|||
|
|
#生成appcast文件
|
|||
|
|
netsparkle-generate-appcast ^
|
|||
|
|
-b D:\NetSparkleUpdates\ ^
|
|||
|
|
-p D:\NetSparkleUpdates\changes ^
|
|||
|
|
-u https://gitcode.com/evoq58/CowainWcs6180/releases/download/newVersion/ ^
|
|||
|
|
--generate-signature
|
|||
|
|
|
|||
|
|
#生成appcast文件不含changelos，需要手动指定
|
|||
|
|
netsparkle-generate-appcast ^
|
|||
|
|
-b D:\NetSparkleUpdates\ ^
|
|||
|
|
-u https://gitcode.com/evoq58/CowainWcs6180/releases/download/newVersion/ ^
|
|||
|
|
--generate-signature
|
|||
|
|
|
|||
|
|
<sparkle:releaseNotesLink>
|
|||
|
|
https://raw.gitcode.com/evoq58/CowainWcs6180/raw/main/CHANGELOG.md
|
|||
|
|
</sparkle:releaseNotesLink>
|
|||
|
|
|
|||
|
|
# 生成修改后的 appcast.xml 的签名，需要手动复制签名，不会更新签名文件
|
|||
|
|
netsparkle-generate-appcast --generate-signature D:\NetSparkleUpdates\appcast.xml
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
https://raw.gitcode.com/evoq58/CowainWcs6180/raw/main/appcast.xml
|
|||
|
|
https://gitcode.com/evoq58/CowainWcs6180/releases/download/newVersion/CowainWcs6180Setup.exe
|
|||
|
|
|
|||
|
|
https://gitcode.com/evoq58/CowainWcs6180/releases/download/newVersion/CowainWcs6180Setup-1.0.2.exe
|
|||
|
|
|
|||
|
|
netsparkle-generate-appcast --show-examples
|
|||
|
|
|
|||
|
|
在 IIS 管理器中，选中刚创建的网站（NetSparkleUpdateServer）
|
|||
|
|
双击右侧「MIME 类型」图标
|
|||
|
|
点击右侧「添加」，输入：
|
|||
|
|
文件扩展名：.signature
|
|||
|
|
MIME 类型：application/octet-stream
|
|||
|
|
|
|||
|
|
|
