目录
技术便笺
因为我很懒,就直接把列表放上来好了….
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。