2021-01-22发表2022-08-11更新碎碎念几秒读完 (大约99个字)

群辉QNAP使用备忘

记录家里的群辉NAS使用备忘，防止忘记了。

IP

192.168.1.13

文件目录

实际文件目录在：/share/…

备忘

很多图片传重复了，抽空写个脚本判断下是否是重复文件，如果是重复的只保留一份就够了，节省磁盘空间，就判断文件的md5即可。

2021-01-19发表2022-08-11更新程序员4 分钟读完 (大约591个字)

mac iterm2 rz与sz的功能

本文主要介绍mac环境下使用iterm2的rz sz功能的安装流程。

1. 安装lrzsz

1	brew install lrzsz

2. 安装执行脚本

将iterm2-send-zmodem.sh和iterm2-recv-zmodem.sh保存到/usr/local/bin目录下。

iterm2-send-zmodem.sh

#!/bin/bash
# Author: Matt Mastracci (matthew@mastracci.com)
# AppleScript from http://stackoverflow.com/questions/4309087/cancel-button-on-osascript-in-a-bash-script
# licensed under cc-wiki with attribution required 
# Remainder of script public domain

osascript -e 'tell application "iTerm2" to version' > /dev/null 2>&1 && NAME=iTerm2 || NAME=iTerm
if [[ $NAME = "iTerm" ]]; then
    FILE=$(osascript -e 'tell application "iTerm" to activate' -e 'tell application "iTerm" to set thefile to choose file with prompt "Choose a file to send"' -e "do shell script (\"echo \"&(quoted form of POSIX path of thefile as Unicode text)&\"\")")
else
    FILE=$(osascript -e 'tell application "iTerm2" to activate' -e 'tell application "iTerm2" to set thefile to choose file with prompt "Choose a file to send"' -e "do shell script (\"echo \"&(quoted form of POSIX path of thefile as Unicode text)&\"\")")
fi
if [[ $FILE = "" ]]; then
    echo Cancelled.
    # Send ZModem cancel
    echo -e \\x18\\x18\\x18\\x18\\x18
    sleep 1
    echo
    echo \# Cancelled transfer
else
    /usr/local/bin/sz "$FILE" --escape --binary --bufsize 4096
    sleep 1
    echo
    echo \# Received "$FILE"
fi

iterm2-recv-zmodem.sh

#!/bin/bash
# Author: Matt Mastracci (matthew@mastracci.com)
# AppleScript from http://stackoverflow.com/questions/4309087/cancel-button-on-osascript-in-a-bash-script
# licensed under cc-wiki with attribution required 
# Remainder of script public domain

osascript -e 'tell application "iTerm2" to version' > /dev/null 2>&1 && NAME=iTerm2 || NAME=iTerm
if [[ $NAME = "iTerm" ]]; then
    FILE=$(osascript -e 'tell application "iTerm" to activate' -e 'tell application "iTerm" to set thefile to choose folder with prompt "Choose a folder to place received files in"' -e "do shell script (\"echo \"&(quoted form of POSIX path of thefile as Unicode text)&\"\")")
else
    FILE=$(osascript -e 'tell application "iTerm2" to activate' -e 'tell application "iTerm2" to set thefile to choose folder with prompt "Choose a folder to place received files in"' -e "do shell script (\"echo \"&(quoted form of POSIX path of thefile as Unicode text)&\"\")")
fi

if [[ $FILE = "" ]]; then
    echo Cancelled.
    # Send ZModem cancel
    echo -e \\x18\\x18\\x18\\x18\\x18
    sleep 1
    echo
    echo \# Cancelled transfer
else
    cd "$FILE"
    /usr/local/bin/rz --rename --escape --binary --bufsize 4096 
    sleep 1
    echo
    echo
    echo \# Sent \-\> $FILE
fi

3. 赋予这两个文件可执行权限

1	chmod 777 /usr/local/bin/iterm2-*

4. 设置Iterm2的Tirgger特性

设置Iterm2的Tirgger特性，profiles->default->editProfiles->Advanced中的Tirgger

添加两条trigger，分别设置 Regular expression，Action，Parameters，Instant如下：

Regular expression: rz waiting to receive.\*\*B0100
Action: Run Silent Coprocess
Parameters: /usr/local/bin/iterm2-send-zmodem.sh
Instant: checked

Regular expression: \*\*B00000000000000
Action: Run Silent Coprocess
Parameters: /usr/local/bin/iterm2-recv-zmodem.sh
Instant: checked

示例图：

5. 使用

上传文件：rz
下载文件：sz + file

参考：

2020-11-25发表2022-08-11更新几秒读完 (大约88个字)

Mac使用过程中的问题汇总

Touchbarbu不显示音量

这应该是一个BUG，在终端执行以下命令可以恢复正常：

1	killall ControlStrip

清理dns缓存

1	sudo killall -HUP mDNSResponder

iterm2 lzrz 功能配置

解决办法：https://www.mspring.org/2021/01/19/mac-iterm2-rz%E4%B8%8Esz%E7%9A%84%E5%8A%9F%E8%83%BD/

2020-11-02发表2022-08-11更新2 分钟读完 (大约317个字)

解决nvm加载慢的问题

为了图方便，我使用nvm安装的nodejs。后来发现每当打开terminal的时候都会很慢，开始不知道什么原因，后来分析了下才知道是nvm的锅。

其实我不是每次打开terminal都需要用到nvm，所以我将nvm修改为按需加载，需要的时候手动执行命令去加载，
我使用的是zsh，于是我修改了一下~/.zshrc文件：

修改前：

# nvm
export NVM_DIR="$HOME/.nvm"
[ -s "$NVM_DIR/nvm.sh" ] && \. "$NVM_DIR/nvm.sh"  # This loads nvm
[ -s "$NVM_DIR/bash_completion" ] && \. "$NVM_DIR/bash_completion"  # This loads nvm bash_completion

修改后：

# nvm
export NVM_DIR="$HOME/.nvm"
# 本来每次启动terminal的时候都需要执行下面两行代码的
#[ -s "$NVM_DIR/nvm.sh" ] && \. "$NVM_DIR/nvm.sh"  # This loads nvm
#[ -s "$NVM_DIR/bash_completion" ] && \. "$NVM_DIR/bash_completion"  # This loads nvm bash_completion
function _install_nvm() {
  unset -f nvm
  [ -s "$NVM_DIR/nvm.sh" ] && \. "$NVM_DIR/nvm.sh" # This sets up nvm
  [ -s "$NVM_DIR/bash_completion" ] && \. "$NVM_DIR/bash_completion"  # load nvm bash_completion
  nvm "$@"
}

function nvm() {
    _install_nvm "$@"
}

修改之后，不是每次启动都会去加载nvm.sh仅当需要的时候在terminal中执行一下nvm命令即可，修改之后terminal启动速度明显快了。

参看资料：https://github.com/nvm-sh/nvm/issues/539

2020-10-27发表2022-08-11更新程序员1 分钟读完 (大约168个字)

在命令行中压缩图片

今天有需求将一些非常大的图片压缩一下，本来想自己写代码进行压缩的，但是觉得这是一个非常常见的需求，应该有现成的解决方案，于是Google了一下，找到了这两个工具：jpegoptim、optipng

安装

我是在MacOS中安装的，Linux上应该也有这个两个工具，请自行摸索

我使用的是brew进行安装，命令如下：

1 2	brew install jpegoptim brew install optipng

jpegoptim 使用

# 压缩
jpegoptim file.jpg

# 指定大小压缩
jpegoptim --size=1024k file.jpg

# 移除Exif信息
jpegoptim --strip-exif file.jpg

optipng 使用

1	optipng file.png

2020-06-12发表2022-08-11更新碎碎念1 分钟读完 (大约131个字)

mac下，mds_stores占用过高cpu，导致风扇狂转，怎么解决？

网上的以下方法，是不行的：

1	sudo mdutil -a -i off

运行了这一行，mds mds_stores等还是在20% 左右运行中

于是，发现了一个新方法，在终端运行这个：

1	sudo launchctl unload -w /System/Library/LaunchDaemons/com.apple.metadata.mds.plist

等你想开的时候，在终端运行这个就行了：

1	sudo launchctl load -w /System/Library/LaunchDaemons/com.apple.metadata.mds.plist

哈哈，成功关闭后，世界都变流畅了！！！

https://www.jianshu.com/p/d76dbc097521

2020-03-07发表2022-08-11更新程序员1 分钟读完 (大约154个字)

AndroidStudio连接mumu模拟器方法

启动mumu模拟器之后在设备列表中找不到模拟器，于是在网上搜索了下教程。

有个教程提供一下方法：

1	adb connect 127.0.0.1:7555

附模拟器端口：

夜神模拟器：adb connect 127.0.0.1:62001
逍遥安卓模拟器：adb connect 127.0.0.1:21503
天天模拟器：adb connect 127.0.0.1:6555 
海马玩模拟器：adb connect 127.0.0.1:53001
网易MUMU模拟器：adb connect 127.0.0.1:7555
原生模拟器：adb connect (你的IP地址)：5555

但是这个方法在mac下好像不还用，于是又找到另外一种方法：

1	adb kill-server && adb server && adb shell

这个方法终于生效。

2019-12-25发表2022-08-11更新程序员3 分钟读完 (大约405个字)

Centos安装mariadb-server

安装

1	yum install mariadb-server

注意：安装之后初始密码为空

常用命令

1
2
3

systemctl start mariadb #启动服务
systemctl enable mariadb #设置开机启动
systemctl restart mariadb #重新启动

初始化

执行命令mysql_secure_installation进行初始化，过程中会让你设置root密码等信息，自己按照提示一步步来即可。

[root@iZj6chtv8h63huh6sbynuiZ ~]# mysql_secure_installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

In order to log into MariaDB to secure it, we'll need the current
password for the root user.  If you've just installed MariaDB, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none):
OK, successfully used password, moving on...

Setting the root password ensures that nobody can log into the MariaDB
root user without the proper authorisation.

Set root password? [Y/n] Y
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
 ... Success!


By default, a MariaDB installation has an anonymous user, allowing anyone
to log into MariaDB without having to have a user account created for
them.  This is intended only for testing, and to make the installation
go a bit smoother.  You should remove them before moving into a
production environment.

Remove anonymous users? [Y/n] Y
 ... Success!

Normally, root should only be allowed to connect from 'localhost'.  This
ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n] Y
 ... Success!

By default, MariaDB comes with a database named 'test' that anyone can
access.  This is also intended only for testing, and should be removed
before moving into a production environment.

Remove test database and access to it? [Y/n] Y
 - Dropping test database...
 ... Success!
 - Removing privileges on test database...
 ... Success!

Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.

Reload privilege tables now? [Y/n] Y
 ... Success!

Cleaning up...

All done!  If you've completed all of the above steps, your MariaDB
installation should now be secure.

Thanks for using MariaDB!

2019-12-24发表2022-08-11更新程序员3 分钟读完 (大约496个字)

shadowsocks go 一键安装

本脚本适用环境：

系统支持：CentOS，Debian，Ubuntu
内存要求：≥128M
日期：2015年08月01日

关于本脚本：

一键安装 go 版的 shadowsocks 最新版本 1.1.4。据说 go 版本有 buff 。与 python 版不同的是，其客户端程序能使用多个服务端配置，本脚本安装的是服务端程序。作者默认推荐 aes-128-cfb 加密，基于一致性，脚本使用了 aes-256-cfb 加密方式。

默认配置：

服务器端口：自己设定（如不设定，默认为 8989）
客户端端口：1080
密码：自己设定（如不设定，默认为teddysun.com）

客户端下载：

http://sourceforge.net/projects/shadowsocksgui/files/dist/

使用方法：

使用root用户登录，运行以下命令：

1
2
3

wget --no-check-certificate https://raw.githubusercontent.com/iMeiji/shadowsocks_install/master/shadowsocks-go.sh
chmod +x shadowsocks-go.sh
./shadowsocks-go.sh 2>&1 | tee shadowsocks-go.log

安装完成后，脚本提示如下：

Congratulations, shadowsocks-go install completed!
Your Server IP:your_server_ip
Your Server Port:your_server_port
Your Password:your_password
Your Local Port:1080
Your Encryption Method:aes-256-cfb

Welcome to visit:http://teddysun.com/392.html
Enjoy it!

卸载方法：

使用 root 用户登录，运行以下命令：

1	./shadowsocks-go.sh uninstall

其他事项：

客户端配置的参考链接：http://teddysun.com/339.html
安装完成后即已后台启动 shadowsocks-go ，运行：

1	/etc/init.d/shadowsocks status

可以查看 shadowsocks-go 进程是否已经启动。
本脚本安装完成后，已将 shadowsocks-go 加入开机自启动。

使用命令：

启动：/etc/init.d/shadowsocks start
停止：/etc/init.d/shadowsocks stop
重启：/etc/init.d/shadowsocks restart
状态：/etc/init.d/shadowsocks status

多用户多端口配置文件 sample（2015年01月08日）：
配置文件路径：vi /etc/shadowsocks/config.json

{
    "port_password":{
         "8989":"password0",
         "9001":"password1",
         "9002":"password2",
         "9003":"password3",
         "9004":"password4"
    },
    "method":"aes-256-cfb",
    "timeout":600
}

参考链接：
https://github.com/shadowsocks/shadowsocks-go
https://github.com/iMeiji/shadowsocks_install/wiki/shadowsocks-go-%E4%B8%80%E9%94%AE%E5%AE%89%E8%A3%85

2019-12-16发表2022-08-11更新程序员几秒读完 (大约66个字)

MySql导出指定列的数据

MySql导出整库或者指定表的数据使用mysqldump命令即可，但是导出表中指定列的数据就需要用到下面命令了，如下：

1	mysql -uroot -p123456 database_name -e "SELECT name from t_xxx where type = 3 INTO OUTFILE'/data/xxx.sql'"