叁·分

不求甚解

用户工具

站点工具


tech-notes:start

技术便笺

因为我很懒,就直接把列表放上来好了….

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 自动登录

  1. 设置中,账户选项 → “为了提高安全性,在此设备上仅允许使用 Windows Hello 登录 Microsoft 账户(推荐)” → 关闭
  2. “你希望Windows在你离开电脑多久后要求你重新登录? → 从不
  3. Win + R → netplwiz → “要使用本计算机,用户必须输入用户名和密码” → 取消勾选。
 

EMBY 上观看运营商 IPTV

在 EMBY 上观看观看运营商 IPTV。

→ 阅读更多...

 

修改RDWeb入口

通过修改RDWeb网页,增加修改密码和网页版RDP使用方式。

→ 阅读更多...

 
tech-notes/start.txt · 最后更改: 2022/10/31 15:37 由 Librarian

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki