冰屋日记

1
# LoadModule ssl_module modules/mod_ssl.so
2

3
# Include conf/extra/httpd-ssl.conf
4

5
# <IfModule ssl_module>
6
# SSLRandomSeed startup builtin
7
# SSLRandomSeed connect builtin
8
# </IfModule>

1
<VirtualHost *:80>
2
    ServerName default
3
    DocumentRoot "${SRVROOT}/htdocs"
4
    ServerName iamyukino.cn
5
    ServerAdmin iamyukino@outlook.com
6
    ErrorLog "${SRVROOT}/logs/error.log"
7
</VirtualHost>

1
数据库名称：db_iamyukino
2
字符集：utf8mb4
3
排序规则：utf8mb4_unicode_ci

1
mysql -u root -p
2
CREATE DATABASE db_iamyukino CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
3
GRANT ALL PRIVILEGES ON db_iamyukino.* TO 'iamyukino'@'%';
4
FLUSH PRIVILEGES;
5
exit

1
pip install django pymysql apscheduler requests feedparser whitenoise
2
cd c:\iamyukino.cn\django
3
python manage.py migrate

1
python manage.py runserver

1
netstat -ano | findstr :8000

1
python manage.py runserver 8080

1
httpd -k install -n iamyukino
2
httpd -k start -n iamyukino

1
httpd -k stop -n iamyukino
2
httpd -k uninstall -n iamyukino

1
cd c:\iamyukino.cn\astro\fuwari
2
npm install -g pnpm

1
Set-ExecutionPolicy RemoteSigned

1
pnpm install
2
pnpm build -- --max-old-space-size=2048

1
# 如果在 config.ts 中启用了 Umami，建议在此配置 API 密钥
2
UMAMI_API_KEY=your_umami_api_key_here
3
# bcrypt 盐值轮数（10-14 推荐，默认 12）
4
BCRYPT_SALT_ROUNDS=12

1
pinned: true  # 将此文章置顶
2
pinned: false # 普通文章（默认）

1
cd c:\iamyukino.cn\django & python
2
from rssfeed.commands import start,run,stop,status;run();start();status()

1
from rssfeed.commands import start,run,stop,status
2
run() # 手动执行一次同步
3
start() #  开始定时器（两小时）
4
stop() # 结束定时器
5
status() # 获取下次执行的时间

1
# 运行pip install mod_wsgi生成.so文件mod_wsgi-express module-config（.pyc后缀改.so）
2

3
# httpd 相关
4
httpd.exe -k install -n 'iamyukino'
5
httpd.exe -k start -n 'iamyukino'
6
httpd.exe -k restart -n 'iamyukino'
7
# net start iamyukino （httpd.exe -k start -n 'iamyukino'）
8
# net stop iamyukino （httpd.exe -k stop -n 'iamyukino'）
9
httpd.exe -k uninstall -n 'iamyukino'（httpd.exe -k restart -n 'iamyukino'）
10

11
# 测试django
12
where python
13
python manage.py runserver
14

15
# 字体子集压缩
16
pip install fonttools
17
pip install brotli
18
pyftsubset XiaolaiSC.woff2 --text-file=used.txt --output-file=XiaolaiSC.subset.woff2 --flavor=woff2 --no-hinting --desubroutinize
19
pyftsubset cjkFonts_allseto_v1.11.ttf --text-file=used.txt --output-file=cjkFonts_allseto_v1.11.subset.woff2 --flavor=woff2 --no-hinting --desubroutinize
20

21
# 数据库备份
22
mysqldump -u iamyukino -p db_iamyukino t_ask > t_ask_backup.sql
23

24
# 数据库结构调整后
25
cd c:\iamyukino.cn\django
26
python manage.py makemigrations mod_iamyukino
27
python manage.py migrate
28

29
# 测试post
30
curl -X POST https://iamyukino.cn/api/x/submit_ask/ -H "Content-Type: application/json"  -d "{\"nickname\":\"testuser\", \"que_text\":\"Hello, World!\"}"
31

32
# Astro
33
pnpm install & pnpm add sharp # 安装依赖
34
pnpm preview # 预览
35
pnpm astro --help # 帮助