波少散记

第一步，下载netgear原厂固件，地址https://www.netgear.com/support/download/ 第二步，下载网件路由器救砖修复工具nmrpflash.exe 第三步，将路由器lan口用网线连到电脑网口，禁用电脑中其他不用的网卡 第四步，在电脑中以管理员方式运行cmd程序，在cmd中运行以下命令（假设下载的固件名为R6220-V1.1.0.114_1.0.1.img，修复工具名为nmrpflash.exe，均放在D盘）： D:\nmrpflash.exe -i net0 -f D:\R6220-V1.1.0.114_1.0.1.img （如果提示wpcap.dll丢失，则下载安装winpcap） 第五步，运行上述命令后，立即给路由器通电开机，等待运行结果提示重启，就OK了，否则再试一次。  

I have finally fixed it! The issue was the DST Root CA X3 cross-sign has expired To fix it on debian: run sudo dpkg-reconfigure ca-certificates uncheck mozilla/DST_Root_CA_X3.crt OK

apt-get update apt-get upgrade apt-get dist-upgrade Upgrade from Debian Jessie 8 to Debian 9 nano /etc/apt/sources.list deb http://httpredir.debian.org/debian stretch main contrib non-free deb http://httpredir.debian.org/debian stretch-updates main contrib non-free deb http://security.debian.org stretch/updates main contrib non-free apt-get update apt-get upgrade apt-get dist-upgrade cat /etc/os-release apt-get autoremove debian 9升级到debian 10 apt-get update && apt-get upgrade sed -i 's/stretch/buster/g' /etc/apt/sources.list apt-get update && apt-get upgrade apt-get dist-upgrade reboot lsb_release -a

方法一： 把所有EXCEL文件复制到同一目录下， 然后新建excel文件，在一个工作表格中 点击查看代码，把下面代码复制到文本框运行，即合并成功 ----------------------代码开始-------------------------------------------------- Sub 合并当前目录下所有工作簿的全部工作表() Dim MyPath, MyName, AWbName Dim Wb As workbook, WbN As String Dim G As Long Dim Num As Long Dim BOX As String Application.ScreenUpdating = False MyPath = ActiveWorkbook.Path MyName = Dir(MyPath & "\" & "*.xls") AWbName = ActiveWorkbook.Name Num = 0 Do While MyName <> "" If MyName <> AWbName Then Set Wb = Workbooks.Open(MyPath & "\" & MyName) Num = Num + 1 With Workbooks(1).ActiveSheet .Cells(.Range("B65536").End(xlUp).Row + 2, 1) = Left(MyName, Len(MyName) - 4) For G = 1 To Sheets.Count Wb.Sheets(G).UsedRange.Copy .Cells(.Range("B65536").End(xlUp).Row + 1, 1) Next WbN = WbN & Chr(13) & Wb.Name Wb.Close False End With End If MyName = Dir Loop Range("B1").Select Application.ScreenUpdating = True MsgBox "共合并...

安装中如果无法找到源，使用SOHU镜像源最好； apt update中出现问题 使用rm -r /var/cache/apt /var/lib/apt/lists 删除再更新 加入源好安装shadowsocks-libev  create /etc/apt/sources.list.d/jessie-backports.list deb http://archive.debian.org/debian jessie-backports main deb http://archive.debian.org/debian jessie-backports-sloppy main apt-get update -o Acquire::Check-Valid-Until=false  apt-get install shadowsocks-libev the -o Acquire::Check-Valid-Until=false is the key information. Hope it is helpful. 将内核更新至4.9以上 apt-cache search linux-image apt-get install -t jessie-backports linux-image-amd64 update-grub apt-get autoclean apt-get autoremove reboot dpkg -l|grep linux-image apt-get purge 开启bbr modprobe tcp_bbr echo "tcp_bbr" >> /etc/modules-load.d/modules.conf echo "net.core.default_qdisc=fq" >> /etc/sysctl.conf echo "net.ipv4.tcp_congestion_control=bbr" >> /etc/sysctl.conf 执行这个保存生效更改。 sysctl -p VPS提示： net.core.default_qdisc = fq net.ipv4.tcp_congestion_control = bb...

在倒腾Debian系统的时候，因为要安装Lighttpd WEB引擎，安装好之后大鸟尝试启动出现如下错误提示： Can't locate Term/ReadLine.pm in @INC (you may need to install the Term::ReadLine module) (@INC contains: /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.24.1 /usr/local/share/perl/5.24.1 /usr/lib/x86_64-linux-gnu/perl5/5.24 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.24 /usr/share/perl/5.24 /usr/local/lib/site_perl /usr/lib/x86_64-linux-gnu/perl-base .) at /usr/sbin/lighty-enable-mod line 17."。 apt install libterm-readkey-perl 

sudo mv /run/resolvconf/resolv.conf /run/resolvconf/_resolv.conf sudo rm /etc/resolv.conf sudo bash -c ' echo "nameserver 8.8.8.8" > /etc/resolv.conf ' sudo bash -c ' echo "[network]" > /etc/wsl.conf ' sudo bash -c ' echo "generateResolvConf = false" >> /etc/wsl.conf ' 然后你需要重启 WSL，在 powershell 中运行： wsl -- shutdown

sudo apt install mysql-server mysql_secure_installation  Output ... Failed! Error: SET PASSWORD has no significance for user 'root'@'localhost' as the authentication method used doesn't store authentication data in the MySQL server. Please consider using ALTER USER instead if you want to change authentication parameters. New password: First, open up the MySQL prompt:  sudo mysql  ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';  exit First, open up the MySQL prompt:  ALTER USER 'root'@'localhost' IDENTIFIED WITH auth_socket;   sudo mysql_secure_installation   sudo mysql mysql -u root -p   CREATE USER 'sammy'@'localhost' IDENTIFIED BY 'password';    grant all privileges on bbsdb.* to bbs@localhost with grant option;   FLUSH PRIVILEGES;

首先需要： 打印机先进入维修状态： 1、先按着 停止/重置键，然后按 电源键 开机(别松开)。 2、等打印机启动，按住 电源键 不要放手，然后松开 停止/重置 键。 3、然后再按两下 停止/重置键。同时松开 电源健和停止/重置 键，启示完毕,打印机显示为"0″。（如果不是显示为"0"，请关机重新操作。) 4、电脑提示找到新硬件并提示安装驱动，（驱动不能安装不用管它）。如果没有找到新硬件，建议重启电脑或更换电脑试试。（如果电脑找不到新硬件，清零软件是无法使用的） 点"EEPROM"键（如果显示错误 比如 002 ，点确定即可） 点"Main"键进行废墨计数器清零（打印机放一张纸，会打印出D=000.0，表示清零成功） 关打印机重启，测试打印机（如果不能打印，请看墨水监控是不是缺墨或其它故障） 如果墨合缺墨可按打印机面板上"停止/重置"键5秒恢复