波少散记

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秒恢复

我们在使用USB设备时,都会会占用COM端口号<WIN 7从1-256>，即使以后USB设备拨掉不再使用，占用的COM端口号还在被占用没有被移除，其它USB转COM端口序号分配很大，部分软件与COM口通信异常又无法修改USB端口号时可利用修改注册表的方法来清除： 打开注册表项 HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\COM Name Arbiter 把ComDB删除后重新尝试即可!(注:这样会重建所有COM口），刷新一下注册表，如果还不行，重启电脑！本人测试OK.

兄弟DCP-8060_7030_7360_7450_7840_8860DN重置硒鼓计数清零方法 以下两种清零方法可以解决机器：硒鼓将用尽、硒鼓寿命为0%、硒鼓错误、计数器清零等问题。   一。粉盒清零（一般加粉时都可以操作）  步骤： 1、打开机器前盖取出硒鼓 2、取下粉盒边盖上的三个螺丝（注意别把里面的齿轮搞掉了） 3、将盖板上面的白色（或黑色的）拨片拨上去就行(逆时针转到另一头） 4、装回硒鼓放入机器就OK了   二。机器清零（提示硒鼓错误时可以按此操作）  步骤： 1、关闭电源 2、按住菜单键，打开电源，待机器面板上的3灯全亮 3、按74，出来一串数字，用笔记下，按退出 4、按90，按28，按64 5、关闭电源 6、重复步骤 2 7、按74，输入你刚才记下的数字，确认，按96 8、OK!再看看你是硒鼓寿命，变成100%了，页码计数器也变为0了！

同时按住"win+R"调出运行窗口。 在运行窗口输入"regedit"并点确定调出注册表编辑器。 找到以下路径"HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Print"，空白处单击右键，点击新建值"DWORD (32位）值（D）"。 给该新建值重命名为"RpcAuthnLevelPrivacyEnabled"。 重命名之后选择值"RpcAuthnLevelPrivacyEnabled"，单击右键>修改>键入数值"0">确定。 重启电脑即可。

apt update && sudo apt upgrade   apt-get install lighttpd   安装完成后，启动并启用该服务。 systemctl start lighttpd systemctl enable lighttpd apt-get install php php-cgi php-fpm php-mysql  nano /etc/php/*/fpm/php.ini  进行以下更改： cgi.fix_pathinfo=1(可将参数改为0)  file_uploads = On  upload_max_filesize = 100M  allow_url_fopen = On  short_open_tag = On  memory_limit = 256M  max_execution_time = 360  date.timezone = Africa/Nairobi  一旦进行了所需的更改，您需要将 Lighttpd 配置为使用 PHP-FPM 而不是默认的 PHP-CGI  进行以下更改： nano /etc/php/7.4/fpm/pool.d/www.conf listen = /run/php/php-fpm.sock  改为  listen = 127.0.0.1:9000  systemctl restart php*-fpm.service    现在修改 Lighttpd 配置以使用 PHP-FPM。  sudo vim /etc/lighttpd/conf-available/15-fastcgi-php.conf 在打开的文件中， 进行以下更改： 将  "bin-path" => "/usr/bin/php-cgi",  "socket" => "/var/run/lighttpd/php.socket",  改为  "host" => "127.0.0.1",  "port" => "9000",...

thunar smb不支持指定位置 重新卸载gvfs，再安装重启即可 sudo apt install gvfs gvfs-backends gvfs-fuse

今天遇到一个问题：每次ubuntu12.04重启后，/etc/resolv.conf被重写为空或127.0.0.1 经过网上查资料以及本人验证，一下方法是可行的： 1.编辑/etc/resolvconf/resolv.conf.d/tail （如果没有该文件，则建立一个文件名为tail的文本文件即可） 2.在里面添加：nameserver xxx.xxx.xxx.xxx xxx替换为你要的实际dns地址（我设置的是192.168.1.1） 这样每次重启后，它会将你所编辑添加的dns服务器写入/etc/resolv.conf中 使resolv.conf不至于每次都重置成空白或只剩127.0.0.1。  

 安装mysql5.7备份出现上面报错 需要给账号权限 GRANT PROCESS ON *.* TO '数据库用户'@'localhost'; flush privileges;

ERROR: The certificate of `url' is not trusted. ERROR: The certificate of `url' hasn't got a known issuer. If you are using Debian or Ubuntu, install the ca-certificates package: $ sudo apt-get install ca-certificates If you don't care about checking the validity of the certificate, use the --no-check-certificate option: $ wget --no-check-certificate https://download/url Note: The second option is not recommended because of the possibility of a man-in-the-middle attack.

 rm /var/lib/dpkg/lock dpkg --configure -a

  Make sure “build-essential” package is installed on your Debian/Ubuntu machine. Login to you Linux with SSH and follow steps below: cd /opt/ git clone https://github.com/Wind4/vlmcsd/releases useradd -s /usr/sbin/nologin -r -M vlmcsd cd /opt/linux-kms-server/vlmcsd/ make Wait for it to finish, if there are no errors/warning continue with following: nano /lib/systemd/system/vlmcsd.service Add following to file: [Unit] Description=vlmcsd KMS emulator service After=network-online.target Wants=network-online.target [Service] Type=forking User=vlmcsd ExecStart= /opt/linux-kms-server/vlmcsd/ vlmcsd -l /var/log/vlmcsd/vlmcsd.log [Install] WantedBy=multi-user.target Save the file and continue creating the log folder and configure the permissions: mkdir /var/log/vlmcsd chown vlmcsd:vlmcsd /var/log/vlmcsd systemctl enable vlmcsd systemctl start vlmcsd To verify the status if the service is running, run following: systemctl status vlmcsd If everything is fine, it should look like this: ro...

The Vps is too old to get a newer OS from the provider. create /etc/apt/sources.list.d/jessie-backports.list, and fill in the following lines 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.

sudo apt-get install git build-essential cmake libuv1-dev libssl-dev libhwloc-dev git clone https://github.com/xmrig/xmrig.git cd xmrig #将捐赠级别重置为 0 sed -i ' s/kDefaultDonateLevel = 5/kDefaultDonateLevel = 0/1 ' src/donate.h sed -i ' s/kMinimumDonateLevel = 1/kMinimumDonateLevel = 0/1 ' src/donate.h mkdir build cd build cmake ..   (或者cmake .. -DARM_TARGET=7 （arm v7）) make https://xmrig.com/wizard创建 config.json文件 {     "autosave": true,     "cpu": true,     "opencl": false,     "cuda": false,     "pools": [         {             "url": "pool.supportxmr.com:5555",             "user": "46N2Ce9HFVATtz5JrdP5gt72sqYZ3vvzDdY3rJsbyU8pfErmc8ThU646Mbji78wh1AQS7Jjpo28voCrJpHZPaUa5PX7dzPG",             "pass": "sbbb",             "keepalive": true,             "tls": false ...