RB750Gr3通过Netinstall恢复官方系统

Jan 15, 2021

在官网下载NetInstall https://mikrotik.com/download 以及routeros系统。 参考下图，将固网中的IP4设置下。 打开下载后的Netinstall程序，如下点击Net booting，设置IP。 …

OpenWRT通过SSH 安装LUCI

Dec 27, 2020

安装完OpenWRT基本系统后，是无法通过WEB来进行管理的，需要安装LUCI才可以 将路由器WAN口连接到一个已经联网的路由器下，然后电脑LAN口连接新路由，通过以下方法开安装LUCI。 建议安装前将OpenWRT/LEDE更换国内源，这样可以更加快速安装软件。 $ ssh [email protected] #默认密码为空 The authenticity of host \'192.168.1.1 (192.168.1.1)\' can\'t be established. RSA key fingerprint is SHA256:UElnmEDlnbdNWutb3J8IjXbBMxbdOJYzHNYYp9lTYKw. Are you sure you want to continue connecting (yes/no)? yes Warning: Permanently added \'192.168.1.1\' (RSA) to the list of known hosts. BusyBox v1.30.0 () built-in shell (ash) _______ ________ __ | |.-----.-----.-----.| | | |.----.| |_ | - || _ | -__| || | | || _|| _| |_______|| __|_____|__|__||________||__| |____| |__| W I R E L E S S F R E E D O M ----------------------------------------------------- OpenWrt SNAPSHOT, r9028-75fdf3b ----------------------------------------------------- === WARNING! ===================================== There is no root password defined on this device! Use the \"passwd\" command to set up a new password in order to prevent unauthorized SSH logins. -------------------------------------------------- root@OpenWrt:~# opkg update #更新软件源 Downloading http://downloads.openwrt.org/snapshots/targets/ramips/mt7621/packages/Packages.gz Updated list of available packages in /var/opkg-lists/openwrt_core Downloading http://downloads.openwrt.org/snapshots/targets/ramips/mt7621/packages/Packages.sig Signature check passed. Downloading http://downloads.openwrt.org/snapshots/targets/ramips/mt7621/kmods/4.14.91-1-26f5ed44a4b010654f5ec58e94ee7c46/Packages.gz Updated list of available packages in /var/opkg-lists/openwrt_kmods Downloading http://downloads.openwrt.org/snapshots/targets/ramips/mt7621/kmods/4.14.91-1-26f5ed44a4b010654f5ec58e94ee7c46/Packages.sig Signature check passed. Downloading http://downloads.openwrt.org/snapshots/packages/mipsel_24kc/base/Packages.gz Updated list of available packages in /var/opkg-lists/openwrt_base Downloading http://downloads.openwrt.org/snapshots/packages/mipsel_24kc/base/Packages.sig Signature check passed. Downloading http://downloads.openwrt.org/snapshots/packages/mipsel_24kc/luci/Packages.gz Updated list of available packages in /var/opkg-lists/openwrt_luci Downloading http://downloads.openwrt.org/snapshots/packages/mipsel_24kc/luci/Packages.sig Signature check passed. Downloading http://downloads.openwrt.org/snapshots/packages/mipsel_24kc/packages/Packages.gz Updated list of available packages in /var/opkg-lists/openwrt_packages Downloading http://downloads.openwrt.org/snapshots/packages/mipsel_24kc/packages/Packages.sig Signature check passed. Downloading http://downloads.openwrt.org/snapshots/packages/mipsel_24kc/routing/Packages.gz Updated list of available packages in /var/opkg-lists/openwrt_routing Downloading http://downloads.openwrt.org/snapshots/packages/mipsel_24kc/routing/Packages.sig Signature check passed.\r\nDownloading http://downloads.openwrt.org/snapshots/packages/mipsel_24kc/telephony/Packages.gz Updated list of available packages in /var/opkg-lists/openwrt_telephony Downloading http://downloads.openwrt.org/snapshots/packages/mipsel_24kc/telephony/Packages.sig Signature check passed.\r\nroot@OpenWrt:~# opkg install luci #安装luci Installing luci (git-19.013.40861-80ac438-1) to root... Downloading http://downloads.openwrt.org/snapshots/packages/mipsel_24kc/luci/luci_git-19.013.40861-80ac438-1_all.ipk Installing uhttpd (2018-11-28-cdfc902a-1) to root... Downloading http://downloads.openwrt.org/snapshots/packages/mipsel_24kc/base/uhttpd_2018-11-28-cdfc902a-1_mipsel_24kc.ipk Installing liblua (5.1.5-1) to root... Downloading http://downloads.openwrt.org/snapshots/packages/mipsel_24kc/base/liblua_5.1.5-1_mipsel_24kc.ipk Installing lua (5.1.5-1) to root... Downloading http://downloads.openwrt.org/snapshots/packages/mipsel_24kc/base/lua_5.1.5-1_mipsel_24kc.ipk Installing luci-lib-nixio (git-19.013.40861-80ac438-1) to root... Downloading http://downloads.openwrt.org/snapshots/packages/mipsel_24kc/luci/luci-lib-nixio_git-19.013.40861-80ac438-1_mipsel_24kc.ipk Installing luci-lib-ip (git-19.013.40861-80ac438-1) to root... Downloading http://downloads.openwrt.org/snapshots/packages/mipsel_24kc/luci/luci-lib-ip_git-19.013.40861-80ac438-1_mipsel_24kc.ipk Installing rpcd (2018-11-28-3aa81d0d-1) to root... Downloading http://downloads.openwrt.org/snapshots/packages/mipsel_24kc/base/rpcd_2018-11-28-3aa81d0d-1_mipsel_24kc.ipk Installing libubus-lua (2018-10-06-221ce7e7-1) to root... Downloading http://downloads.openwrt.org/snapshots/packages/mipsel_24kc/base/libubus-lua_2018-10-06-221ce7e7-1_mipsel_24kc.ipk Installing luci-lib-jsonc (git-19.013.40861-80ac438-1) to root... Downloading http://downloads.openwrt.org/snapshots/packages/mipsel_24kc/luci/luci-lib-jsonc_git-19.013.40861-80ac438-1_mipsel_24kc.ipk Installing liblucihttp (2018-05-18-cb119ded-1) to root... Downloading http://downloads.openwrt.org/snapshots/packages/mipsel_24kc/luci/liblucihttp_2018-05-18-cb119ded-1_mipsel_24kc.ipk Installing liblucihttp-lua (2018-05-18-cb119ded-1) to root... Downloading http://downloads.openwrt.org/snapshots/packages/mipsel_24kc/luci/liblucihttp-lua_2018-05-18-cb119ded-1_mipsel_24kc.ipk Installing luci-base (git-19.013.40861-80ac438-1) to root... Downloading http://downloads.openwrt.org/snapshots/packages/mipsel_24kc/luci/luci-base_git-19.013.40861-80ac438-1_mipsel_24kc.ipk Installing libiwinfo (2018-12-25-dd508af4-1) to root... Downloading http://downloads.openwrt.org/snapshots/targets/ramips/mt7621/packages/libiwinfo_2018-12-25-dd508af4-1_mipsel_24kc.ipk Installing libiwinfo-lua (2018-12-25-dd508af4-1) to root... Downloading http://downloads.openwrt.org/snapshots/targets/ramips/mt7621/packages/libiwinfo-lua_2018-12-25-dd508af4-1_mipsel_24kc.ipk Installing luci-mod-status (git-19.013.40861-80ac438-1) to root... Downloading http://downloads.openwrt.org/snapshots/packages/mipsel_24kc/luci/luci-mod-status_git-19.013.40861-80ac438-1_mipsel_24kc.ipk Installing luci-mod-system (git-19.013.40861-80ac438-1) to root... Downloading http://downloads.openwrt.org/snapshots/packages/mipsel_24kc/luci/luci-mod-system_git-19.013.40861-80ac438-1_all.ipk Installing luci-mod-network (git-19.013.40861-80ac438-1) to root... Downloading http://downloads.openwrt.org/snapshots/packages/mipsel_24kc/luci/luci-mod-network_git-19.013.40861-80ac438-1_all.ipk Installing luci-mod-admin-full (git-19.013.40861-80ac438-1) to root... Downloading http://downloads.openwrt.org/snapshots/packages/mipsel_24kc/luci/luci-mod-admin-full_git-19.013.40861-80ac438-1_all.ipk Installing luci-theme-bootstrap (git-19.013.40861-80ac438-1) to root... Downloading http://downloads.openwrt.org/snapshots/packages/mipsel_24kc/luci/luci-theme-bootstrap_git-19.013.40861-80ac438-1_all.ipk Installing luci-app-firewall (git-19.013.40861-80ac438-1) to root... Downloading http://downloads.openwrt.org/snapshots/packages/mipsel_24kc/luci/luci-app-firewall_git-19.013.40861-80ac438-1_all.ipk Installing luci-app-opkg (git-19.013.40861-80ac438-1) to root... Downloading http://downloads.openwrt.org/snapshots/packages/mipsel_24kc/luci/luci-app-opkg_git-19.013.40861-80ac438-1_all.ipk Installing luci-proto-ppp (git-19.013.40861-80ac438-1) to root... Downloading http://downloads.openwrt.org/snapshots/packages/mipsel_24kc/luci/luci-proto-ppp_git-19.013.40861-80ac438-1_all.ipk Installing luci-proto-ipv6 (git-19.013.40861-80ac438-1) to root... Downloading http://downloads.openwrt.org/snapshots/packages/mipsel_24kc/luci/luci-proto-ipv6_git-19.013.40861-80ac438-1_all.ipk Installing rpcd-mod-rrdns (20170710) to root... Downloading http://downloads.openwrt.org/snapshots/packages/mipsel_24kc/luci/rpcd-mod-rrdns_20170710_mipsel_24kc.ipk Configuring luci-app-opkg. Configuring rpcd. Configuring liblua. Configuring luci-lib-ip. Configuring libubus-lua. Configuring libiwinfo. Configuring libiwinfo-lua. Configuring lua. Configuring luci-lib-nixio. Configuring luci-lib-jsonc. Configuring liblucihttp. Configuring liblucihttp-lua. Configuring luci-base. Configuring luci-mod-system. Configuring luci-theme-bootstrap. Configuring luci-mod-status. Configuring luci-app-firewall. Configuring luci-proto-ppp. Configuring luci-mod-network. Configuring luci-mod-admin-full. Configuring luci-proto-ipv6. Configuring uhttpd. Configuring rpcd-mod-rrdns. Configuring luci. root@OpenWrt:~# #安装完成，重启即可 重启后，就可以通过访问192.168.1.1来进行web端管理了，root默认密码为空，记得添加密码咯！ …

使用proxychains-ng代理cmd

Nov 08, 2020

安装rpoxychains-ng sudo dnf install proxychains-ng ## or sudo apt install proxychains-ng 设置proxychains-ng代理地址 vi /etc/proxychains.conf 添加socks5 192.168.1.94 10808即可，支持多种代理方式:socks4/socks5/http，如下说明: # Examples: # # socks5 192.168.67.78 1080 lamer secret # http 192.168.89.3 8080 justu hidden # socks4 192.168.1.49 1080 # http 192.168.39.93 8080 使用proxychains-ng代理执行命令 $proxychains curl -O https://github.com/XTLS/Xray-install/raw/main/install-release.sh [proxychains] config file found: /etc/proxychains.conf [proxychains] preloading /usr/lib64/proxychains-ng/libproxychains4.so [proxychains] DLL init: proxychains-ng 4.13 % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0 [proxychains] Strict chain ... 192.168.1.94:10808 ... raw.githubusercontent.com:443 ... OK 100 21115 100 21115 0 0 6107 0 0:00:03 0:00:03 --:--:-- 6106 https://github.com/rofl0r/proxychains-ng.git …

国内安装ohmyzsh的方法

Nov 01, 2020

REMOTE=https://gitee.com/mirrors/oh-my-zsh.git sh install.sh 首先安装zsh apt update&&apt ugprade -y apt install zsh -y 如果能够正常访问github.com和githubusercontent.com，那么使用如下命令即可安装ohmyzsh …

Github Actions自动生成Hugo站点并部署到Github Pages

Oct 25, 2020

使用hugo建立建立个人网站可以参考使用hugo建立静态个人网站 使用github pages来部署个人网站可以参考GithubPages部署免费网站 下面将会介绍如何通过Github Actions来将以上两个操作关联在一起并自动化完成！ …

根据A列按格式聚合B列

Oct 16, 2020

原表如下内容: 需要输出为以下格式表格： 方法如下： 将A列升序排列，C2单元格写入=IF(A2=A1,B2&"/"&C1,B2)，D2单元格写入=LEN(C2)，结果如下： …

网络文件系统SSHFS使用实例

Sep 26, 2020

什么是SSHFS? SSHFS是一个通过SSH连接到服务器的网络文件系统客户端。 SSHFS允许您使用SFTP挂载远程文件系统。 大多数VPS SSH服务器默认情况下都支持并启用此SFTP访问，因此SSHFS使用非常简单，无需在服务器端执行任何操作。 …

V2ray配置实例[最新v2fly]

Sep 07, 2020

Linux下推使用V2rayA，安装使用可参考V2rayA客户端使用实例 说明： 从V2Ray 4.27.0开始，请使用新版安装脚本，旧版安装配置实例仅供参考。 新版安装配置实例 服务端安装 下载安装脚本 ➜ ~ curl -O https://raw.githubusercontent.com/v2fly/fhs-install-v2ray/master/install-release.sh 执行安装脚本 ➜ ~ bash ./install-release.sh % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 100 98k 100 98k 0 0 495k 0 --:--:-- --:--:-- --:--:-- 495k info: Installing V2Ray v4.27.5 for x86_64 Downloading V2Ray archive: https://github.com/v2fly/v2ray-core/releases/download/v4.27.5/v2ray-linux-64.zip % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 100 644 100 644 0 0 5457 0 --:--:-- --:--:-- --:--:-- 5457 100 12.6M 100 12.6M 0 0 8316k 0 0:00:01 0:00:01 --:--:-- 10.2M Downloading verification file for V2Ray archive: https://github.com/v2fly/v2ray-core/releases/download/v4.27.5/v2ray-linux-64.zip.dgst % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 100 649 100 649 0 0 2368 0 --:--:-- --:--:-- --:--:-- 2368 100 590 100 590 0 0 1053 0 --:--:-- --:--:-- --:--:-- 1053 info: Extract the V2Ray package to /tmp/tmp.gWzZRTMMij and prepare it for installation. installed: /usr/local/bin/v2ray installed: /usr/local/bin/v2ctl installed: /usr/local/share/v2ray/geoip.dat installed: /usr/local/share/v2ray/geosite.dat installed: /usr/local/etc/v2ray/config.json installed: /var/log/v2ray/ installed: /var/log/v2ray/access.log installed: /var/log/v2ray/error.log installed: /etc/systemd/system/v2ray.service installed: /etc/systemd/system/[email protected] removed: /tmp/tmp.gWzZRTMMij info: V2Ray v4.27.5 is installed. //安装完成 You may need to execute a command to remove dependent software: dnf remove curl unzip Please execute the command: systemctl enable v2ray; systemctl start v2ray 配置systemd服务 ➜ ~ systemctl enable v2ray //添加systemd服务模块 Created symlink /etc/systemd/system/multi-user.target.wants/v2ray.service → /etc/systemd/system/v2ray.service. ➜ ~ systemctl start v2ray //开启v2ray服务 ➜ ~ service v2ray status //检查v2ray服务状态 Redirecting to /bin/systemctl status v2ray.service ● v2ray.service - V2Ray Service Loaded: loaded (/etc/systemd/system/v2ray.service; enabled; vendor preset: disabled) Active: active (running) since Mon 2020-09-07 11:16:13 CST; 8s ago Main PID: 25897 (v2ray) Tasks: 6 (limit: 4566) Memory: 4.7M CGroup: /system.slice/v2ray.service └─25897 /usr/local/bin/v2ray -config /usr/local/etc/v2ray/config.json Sep 07 11:16:13 bwgcn2 systemd[1]: Started V2Ray Service. Sep 07 11:16:13 bwgcn2 v2ray[25897]: V2Ray 4.27.5 (V2Fly, a community-driven edition of V2Ray.) Custom (go1.14.7 linux/amd64) Sep 07 11:16:13 bwgcn2 v2ray[25897]: A unified platform for anti-censorship. Sep 07 11:16:13 bwgcn2 v2ray[25897]: 2020/09/07 11:16:13 [Info] v2ray.com/core/common/platform/ctlcmd: <v2ctl message> Sep 07 11:16:13 bwgcn2 v2ray[25897]: v2ctl> Read config: /usr/local/etc/v2ray/config.json Sep 07 11:16:13 bwgcn2 v2ray[25897]: 2020/09/07 11:16:13 [Warning] v2ray.com/core: V2Ray 4.27.5 started 服务端配置 默认安装完成后，启用配置文件为/usr/local/etc/v2ray/config.json，但这个默认配置为空，因此需要自定义服务端配置。 …

Excel经纬度计算距离公式

Aug 27, 2020

公式如下： =6371004*ACOS(1-(POWER((SIN((90-B2)*PI()/180)*COS(A2*PI()/180)-SIN((90-D2)*PI()/180)*COS(C2*PI()/180)),2)+POWER((SIN((90-B2)*PI()/180)*SIN(A2*PI()/180)-SIN((90-D2)*PI()/180)*SIN(C2*PI()/180)),2)+POWER((COS((90-B2)*PI()/180)-COS((90-D2)*PI()/180)),2))/2) 将以上公式填写在E2单元格，其中A2、B2、C2、D2单元格对应前后两个经纬度值。

Windows10下访问WSL目录

Aug 11, 2020

Windows10下访问WSL目录的方法其实很简单，如下所示: ➜ post git:(master) explorer.exe . 即可通过文件浏览器打开当前目录。