目录
技术便笺
因为我很懒，就直接把列表放上来好了….
create a workable IPv6 network for ocserv clients
1. enable NDP proxy at ocserv server host: `sysctl -w net.ipv6.conf.all.proxy_ndp=1` .
2. assign a sub network of ocserv server host IPv6 network for clients, for example:
if the IPv6 address of ocserv server host inteface eth0 is *2608:8207:7888:a450::1/64*, then add the fellowing lines into ocserv.conf:
``` ipv6-network = 2608:8207:7888:a450:cafe::/80 ipv6-subnet-prefix = 96 ```
3. start proxy NDP for a client by connect-script. create an executable script file /path/to/on-connect.sh with the fellowing content, add `connect-script = /path/to/on-connect.sh` into ocserv.conf.
```
#!/bin/bash
IFACE=eth0
ip -6 neigh add proxy ${IPV6_REMOTE} dev ${IFACE}
```
4. stop proxy NDP for a client by disconnect-script. create an executable script file /path/to/on-disconnect.sh with the fellowing content, add `disconnect-script = /path/to/on-disconnect.sh` into ocserv.conf.
```
#!/bin/bash
IFACE=eth0
ip -6 neigh del proxy ${IPV6_REMOTE} dev ${IFACE}
```
Ref. [IPv6 NDP proxying with ocserv](http://lists.infradead.org/pipermail/openconnect-devel/2016-June/003718.html)
解决 MySQL Native Password 的问题
MySQL 8.4 之后对 mysql_native_password 不再支持，因此需要迁移到新的 caching_sha2_password 认证方式。
首先在 docker 中添加启动参数“–skip-grant-tables”；运行容器。
然后进入 docker 终端，在终端中依次运行下述命令，可以发现存在 mysql_native_password 条目：
mysql -p
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> SELECT User, Host, plugin FROM mysql.user;
+------------------+-----------+-----------------------+
| User | Host | plugin |
+------------------+-----------+-----------------------+
| root | % | mysql_native_password |
| mysql.infoschema | localhost | caching_sha2_password |
| mysql.session | localhost | mysql_native_password |
| mysql.sys | localhost | mysql_native_password |
| root | localhost | mysql_native_password |
+------------------+-----------+-----------------------+
5 rows in set (0.00 sec)
由于 caching_sha2_password 是 MySQL 8.4+ 中新的默认密码加密方式，我们无需使用额外的标志来覆盖密码加密方法。唯一的要求是使用密码重新创建数据库用户。为此，对所有 mysql_native_password 加密的用户，依次参考运行下述类似命令：
ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'xxx'; ALTER USER 'root'@'%' IDENTIFIED WITH caching_sha2_password BY 'xxx'; flush privileges;
修改时可能会提示：
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
为此需要先运行
flush privileges;
最后，删除 Docker 命令条目。重启 Docker 容器，并检查容器日志。
参考：
Windows 11 自动登录
- 设置中，账户选项 → “为了提高安全性，在此设备上仅允许使用 Windows Hello 登录 Microsoft 账户（推荐）” → 关闭
- “你希望Windows在你离开电脑多久后要求你重新登录？ → 从不
- Win + R → netplwiz → “要使用本计算机，用户必须输入用户名和密码” → 取消勾选。
EMBY 上观看运营商 IPTV
在 EMBY 上观看观看运营商 IPTV。