自从将woterm网站转至阿里云后，发现不定期被Block，按网友的建议转移至hostwinds平台，目前发现没有被Q,貌似挻稳定的。
主要是hostwinds服务确实周到，在遇到问题时，技术支持很及时。
以下是记录该售后的被Block解决方案：
https://www.vps234.com/ipchecker/
—————————
Yes, it looks like your IP is blocked in china.
First read this guide https://www.vps234.com/hostwinds-ip-blocked-fix-isp/
then check your IP here https://www.vps234.com/ipchecker/
I recommend CentOS 7 to find a good IP as it accepts the change and reboots fastest. then after you can change it to whatever you want to run
For the IP Checker:
4 red X, wait for a few minutes, and try testing again, if it stays all red, press regenerate network and test again in 5 minutes.
2 red X 2 green check, IP banned, press Fix ISP block again
4 green checks, good IP
This is what the button looks like https://hw-screenshots.sea-proxy.windystorage.com/screenshots/2020-11-04_20-07-37-9544807a-886e-4a5e-abc2-c272b2d96775
FreeRDP的开发
这个FreeRDP的Jenkins构建环境，可以参考如何编译FreeRDP的源代码。
https://ci.freerdp.com/view/All/
这个是它的FreeRDP仓库的预编译结果，可以直接提取库文件编译结果。源代码：
https://github.com/FreeRDP/FreeRDP/wiki/PreBuilds
VNC客户端开发
VNC的协议文档在RealVNC.com的帮助中心下载。
其实际文档只有3.3/3.7/3.8协议版本是属于公开的，而4.0是不公开的。
也就是该相关文档的最新版本日期是2011年。
其真正下载地址如下:
https://tools.ietf.org/html/rfc6143
最完整的协议文档是由TigerVNC维护:https://github.com/rfbproto/rfbproto
【VNC的粘贴板是通过CutBuffer实现，其已经被放弃。故最新系统的VNC都是不支持远程字符串复制和粘贴】
【https://github.com/sigmike/autocutsel】此粘贴技术的关键字是：CUT_BUFFER0
数据库备份与恢复
一、备份脚本
#!/usr/bin/bash
path_current=$(cd "$(dirname "$0")"; pwd)
name_current=$(basename "$0" .sh)
echo $path_current
echo $name_current
if [ ! -d $path_current/backup/ ];then
echo "create backup path: $path_current/backup"
mkdir -p $path_current/backup
fi
path_backup=$path_current/backup/
echo "backup path: ${path_backup}"
dball=(commams-bigdata commams-bos commams-coupon commams-device commams-face commams-goods commams-log commams-logistics commams-marketing commams-member commams-oa commams-oauth commams-order commams-partner commams-pay commams-payaccount commams-peripherals commams-sms commams-wallet commams-wms)
for db in ${dball[@]};do
if [ ! -f ${path_backup}/"$db".sql ];then
echo "backup next database:$db"
mysqldump --host xxxxx --port 196227 -u abc -p'yyy3' --set-gtid-purged=off --databases "$db" > ${path_backup}/"$db".sql
if [ $? -ne 0 ]; then
rm -f ${path_backup}/"$db".sql
echo "failed to backup the database."
exit 1
fi
fi
done
echo "success to backup database from production" |
二、restore.sh恢复脚本
#!/usr/bin/bash
path_current=$(cd "$(dirname "$0")"; pwd)
name_current=$(basename "$0" .sh)
echo $path_current
echo $name_current
if [ ! -d $path_current/backup/ ];then
echo "should first backup database."
exit 1
fi
path_backup=$path_current/backup/
echo "backup path: ${path_backup}"
dball=(commams-bigdata commams-bos commams-coupon commams-device commams-face commams-goods commams-log commams-logistics commams-marketing commams-member commams-oa commams-oauth commams-order commams-partner commams-pay commams-payaccount commams-peripherals commams-sms commams-wallet commams-wms)
for db in ${dball[@]};do
if [ -f ${path_backup}/"$db".sql ];then
echo "restore database:$db"
mysql --host sxxxxx --port 3307 -uroot -p'123456' < ${path_backup}/"$db".sql && echo "$db is ok"
fi
done
echo "success to restore database from production" |
xdebug3的调试开启方式
xdebug2和xdebug3的开启调试方式是不同的。
此外xdebug3的默认端口改为9003了，故需要修改PHPSTORM的调试端口。
------xdebug3-----的开启方式。
; Enable xdebug extension module
zend_extension=xdebug-3.0.1.so
xdebug.mode=debug,trace
; chmod a+rw {{logroot}}/xdebug, make sure can write
xdebug.output_dir = {{logroot}}/xdebug
xdebug.trace_output_name = trace.%c
xdebug.start_with_request = yes
xdebug.collect_params = 4
;[Xdebug]
;zend_extension="xdebug-2.7.2.so"
;xdebug.remote_enable = On
;xdebug.profiler_enable = On
;xdebug.profiler_enable_trigger = On
;xdebug.auto_trace = on
;xdebug.auto_profile = on
;xdebug.collect_params = on
;xdebug.collect_return = on
;xdebug.profiler_enable = on
;xdebug.trace_output_dir = "/data/logs/xdebug"
;xdebug.profiler_output_dir = "/data/logs/xdebug"
;xdebug.dump.GET = *
;xdebug.dump.POST = *
;xdebug.dump.COOKIE = *
;xdebug.dump.SESSION = *
;xdebug.var_display_max_data = 9056
;xdebug.var_display_max_depth = 50 |
—-以下是xdebug2的开启方式———-
zend_extension=”xdebug-2.7.2.so”
xdebug.remote_enable = On
xdebug.profiler_enable = On
xdebug.profiler_enable_trigger = On
xdebug.auto_trace = on
xdebug.auto_profile = on
xdebug.collect_params = on
xdebug.collect_return = on
xdebug.profiler_enable = on
xdebug.trace_output_dir = “/data/logs/xdebug”
xdebug.profiler_output_dir = “/data/logs/xdebug”
xdebug.dump.GET = *
xdebug.dump.POST = *
xdebug.dump.COOKIE = *
xdebug.dump.SESSION = *
xdebug.var_display_max_data = 9056
xdebug.var_display_max_depth = 50
REMI安装PHP插件不同版本
https://centos.pkgs.org/7/remi-x86_64/
FROM centos:7.8.2003 RUN yum install -y wget && \ wget https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm && \ rpm -Uvh epel-release-latest-7.noarch.rpm && rm -f epel-release-latest-7.noarch.rpm && \ wget https://rpms.remirepo.net/enterprise/remi-release-7.rpm && \ rpm -Uvh remi-release-7.rpm && rm -f remi-release-7.rpm && \ yum install -y yum-utils && \ yum-config-manager --add-repo https://openresty.org/package/centos/openresty.repo && \ yum install -y crontabs && \ yum install -y openresty && \ yum install -y supervisor && \ yum install -y php72 &&\ yum install -y php72-php-pecl-psr php72-php-pear php72-php-pecl-amqp php72-php-bcmath php72-php-bcmath php72-php-mysqlnd php72-php-pgsql php72-php-common php72-php-gd php72-php-mbstring php72-php-pdo php72-php-xml php72-php-xmlrpc php72-php-soap php72-php-opcache php72-php-process php72-php-sodium && \ yum install -y php72-php-pecl-zip php72-php-pecl-redis php72-php-pecl-mongodb php72-php-pecl-grpc php72-php-pecl-protobuf php72-php-pecl-uuid &&\ yum install -y php72-php-fpm && \ ln -sf /usr/bin/php72 /usr/bin/php && \ ln -sf /opt/remi/php72/root/usr/sbin/php-fpm /usr/bin/php-fpm && \ ln -sf /usr/local/openresty/nginx/sbin/nginx /usr/bin/nginx && \ mkdir -p /data/www/html && mkdir -p /data/logs \ php --version && \ php --modules COPY ./nginx/ /usr/local/openresty/nginx/conf/ COPY ./start.sh /start.sh RUN chmod a+x /start.sh COPY ./supervisor.ini /etc/supervisord.d/ COPY ./php-fpm/ /etc/opt/remi/php72/ COPY ./html/ /data/www/html/ COPY ./logrotate/ /data/logrotate/ WORKDIR /data/www EXPOSE 80 ENTRYPOINT ["/bin/bash", "/start.sh"] |
https://centos.pkgs.org/7/remi-x86_64/php72-php-pecl-grpc-1.33.1-1.el7.remi.x86_64.rpm.html
yum install php72-php-pecl-grpc-1.33.1
GIT误删库如何恢复
转:
误操作删除服务器上git仓库的处理方法
说明：
git 服务器上仓库代码不小心被删除了，但是通过git clone下来的code存在
另外git 服务器上没有建立任何branch信息；
1.在之前clone过服务器代码的客户端机器上，找到clone下来的代码目录，
执行git remote -vv
查询原来git 仓库所在服务器的IP地址以及路径；
2.根据步骤1上查询的结果，在服务器上找到对应路径，创建git仓库；
git init –bare –shared && git config receive.denyCurrentBranch ignore
3.在客户端之前clone 代码所在目录，强制push客户端的代码至服务器
git push origin master –force
这样原来clone下来的代码以及change log等信息，就会被强制clone到服务器上；
说明：此处必须加–force选项，否则会因服务器上仓库信息与客户端仓库信息不匹配导致push失败
——————————————————
免密模式中的.ssh目录必须是700权限，和authorized_keys必须是600权限
—————————-
报如下错误，则需要在远程仓库下执行：git config receive.denyCurrentBranch ignore
跟踪PHP中加载的文件列表
以下是跟踪某应用所加载的文件列表。
sudo strace $(pidof ‘php-fpm’|sed ‘s/\([0-9]*\)/-p \1/g’) -e stat -s 1024
Midnight Commander文本终端的管理者
Midnight Commander终端图形操作界面
控制台应用静态库编译
cmake_minimum_required(VERSION 3.14)
project(CommaSdkActivator)
set(CMAKE_CXX_STANDARD 11)
# yum install glibc-static libstdc++-static
set(CMAKE_CXX_FLAGS "${CMAKE_CXX_FLAGS} -static")
if(WIN32)
set(CMAKE_EXE_LINKER_FLAGS "${CMAKE_EXE_LINKER_FLAGS} /SUBSYSTEM:WINDOWS,5.01")
endif()
if(MSVC)
# Use the static C library for all build types
foreach(var
CMAKE_C_FLAGS CMAKE_C_FLAGS_DEBUG CMAKE_C_FLAGS_RELEASE
CMAKE_C_FLAGS_MINSIZEREL CMAKE_C_FLAGS_RELWITHDEBINFO
CMAKE_CXX_FLAGS CMAKE_CXX_FLAGS_DEBUG CMAKE_CXX_FLAGS_RELEASE
CMAKE_CXX_FLAGS_MINSIZEREL CMAKE_CXX_FLAGS_RELWITHDEBINFO
)
if(${var} MATCHES "/MD")
string(REGEX REPLACE "/MD" "/MT" ${var} "${${var}}")
endif()
endforeach()
endif(MSVC)
add_executable(CommaSdkActivator main.cpp) |