📚 我的文章

upx for macos 之源码编译

2020-04-01   |   MacOS   |   MacOS

UPX (the Ultimate Packer for eXecutables)是一款先进的可执行程序文件压缩器，压缩过的可执行文件体积缩小50%-70% ，这样减少了磁盘占用空间、网络上传下载的时间和其它分布以及存储费用。

...

ffmpeg 删除音视频文件中的元数据

2019-11-07   |   FFmpeg   |   FFmpeg

清除mp3文件中自带的专辑（album），艺术家（artist），流派（genre）等元数据。

ffmpeg -i "test.mp3" -b:a 320k -map_metadata -1 -y "out.mp3"

-map_metadata -1 表示清除所有元数据

mediainfo 静态编译脚本

2019-08-13   |   Linux   |   Linux

因为需要mediainfo支持http协议，在老的版本中是不支持的，所以只能自己动手编译了。

说明 #

系统：ubuntu 14.04 (其他版本可能会有少许改动)

...

ssh免秘钥登陆常见问题

2019-08-02   |   Linux   |   Linux

收集一些ssh登陆常见的问题，方便快速解决问题。

重要事情 #

cat /var/log/secure
cat /var/log/message

无论你遇到任何奇葩的sshd问题，你先执行上面的命令查看下日志。

错误一 #

问题描述 #

Authentication refused:bad ownership or modes for dircetory /root

解决方法 #

chmod 700 /root

其他相关 #

id_ras 权限为600

...

openssl - https SAN自签名证书

2019-07-02   |   Linux   |   Linux

使用openssl生产自签名证书，用于https测试。

CA根证书制作 #

#1.生成根证书密钥
$ openssl genrsa -out ca.key 4096 #建议长度为4096,1024长度已经被列为不安全。
#2.生成自签名根证书
$ openssl req -new -x509 -days 3650 -key ca.key -out ca.crt #这里在输入CommonName的时候输入名称而不是域名或者ip,就是证书上显示的颁发者，虽然是自签名证书，但是尽量让证书看起来标准一些

使用根证书来签名其它证书 #

1.生成证书密钥 #

$ openssl genrsa -out server.key 4096

2. Subject Alt Name(SAN) #

高版本的Chrome浏览器会要求设置 subjectAltName,如果没有设置SAN会报证书错误

...

Centos7-yum安装MySQL5.6

2019-06-27   |   Linux   |   Linux

centos自带的repo是不会自动更新每个软件的新版本，所以无法通过yum方式安装MySQL的高版本，所以一般通过社区rpm包安装。

安装yum源 #

rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm

查看mysql安装源 #

yum repolist enabled | grep "mysql.*-community.*"

安装mysql56 #

yum -y install mysql-community-server

开机启动 #

systemctl enable mysqld

启动服务 #

systemctl start mysqld

重置密码 #

mysql_secure_installation

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

In order to log into MySQL to secure it, we'll need the current
password for the root user.  If you've just installed MySQL, 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):
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Enter current password for root (enter for none):
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
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 MySQL
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 MySQL installation has an anonymous user, allowing anyone
to log into MySQL 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] n
 ... skipping.

By default, MySQL 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] n
 ... skipping.

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

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

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

Thanks for using MySQL!

Cleaning up...

supervisor 安装和使用方法

2019-05-31   |   Linux   |   Linux

Supervisor是用Python开发的一套通用的进程管理程序，能将一个普通的命令行进程变为后台daemon，并监控进程状态，异常退出时能自动重启。

...

yum错误:problem making ssl connection Trying other mirror

2019-02-26   |   Linux   |   Linux

yum无法使用带https的源

环境 #

yum install epel-release

运行以上命令之后，安装其他软件就报错。

错误提示 #

[Errno 14] problem making ssl connection Trying other mirror.
Trying other mirror
Error: Cannot retrieve repository metadata (repomd.xml) for repository: xxxx. Please verify its path and try again

经过google查询，发现似乎是ssl证书的原因。

...

CentOS7 php5.6 编译安装amqp扩展

2019-01-22   |   Linux   |   Linux

php 安装最新rabbitmq扩展

1、安装编译环境 #

yum install cmake gcc gcc-c++ make openssl-devel

2、安装rabbitmq-c #

wget https://github.com/alanxz/rabbitmq-c/archive/v0.9.0.zip
unzip v0.9.0.zip
cd rabbitmq-c-0.9.0/
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/rabbitmq-c-0.9.0/
make && make install

3、安装amqp #

wget http://pecl.php.net/get/amqp-1.9.4.tgz
tar zxf amqp-1.9.4.tgz
cd amqp-1.9.4
/usr/bin/phpize
./configure --with-php-config=/usr/bin/php-config --with-amqp --with-librabbitmq-dir=/usr/local/rabbitmq-c-0.9.0

#由于rabbitmq-c编译出来的lib目录是lib64，所以我们要做一些小的修改
vim Makefile
#将 AMQP_SHARED_LIBADD = -Wl,-rpath,/usr/local/rabbitmq-c-0.9.0/lib -L/usr/local/rabbitmq-c-0.9.0/lib -lrabbitmq
#修改为 AMQP_SHARED_LIBADD = -Wl,-rpath,/usr/local/rabbitmq-c-0.9.0/lib64 -L/usr/local/rabbitmq-c-0.9.0/lib64 -lrabbitmq

make && make install

4、php.ini 添加模块 #

vi /usr/local/php/etc/php.ini
#增加
extension = /usr/lib64/php/modules/amqp.so

5、重启服务 #

systemctl restart php-fpm