<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[haoke]]></title><description><![CDATA[haoke]]></description><link>https://blog.youkuaiyun.com/pcyph</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; pcyph]]></copyright><item><title><![CDATA[MySQL sql-mode]]></title><link>https://blog.youkuaiyun.com/pcyph/article/details/73744505</link><guid>https://blog.youkuaiyun.com/pcyph/article/details/73744505</guid><author>pcyph</author><pubDate>Mon, 26 Jun 2017 21:17:55 +0800</pubDate><description><![CDATA[http://www.cnblogs.com/ainiaa/archive/2010/12/31/1923002.html


最近在做一个项目的时候错了一个相当奇怪的问题：

代码是我从svn上直接checkout出来的，数据库是从别人的机器上直接dump出来的。环境配置妥当以后，就是在我的机器上不能正常下订单。刚开始不明白，为什么同样的代码，同样的数据库

在别人的机器上可以正常]]></description><category></category></item><item><title><![CDATA[swagger]]></title><link>https://blog.youkuaiyun.com/pcyph/article/details/55103157</link><guid>https://blog.youkuaiyun.com/pcyph/article/details/55103157</guid><author>pcyph</author><pubDate>Tue, 14 Feb 2017 18:06:08 +0800</pubDate><description><![CDATA[swagger的优快云介绍http://blog.youkuaiyun.com/wangnan9279/article/details/44541665
1，git clone  https://github.com/swagger-api/swagger-ui.git
2，cd swagger-ui
3，git clone https://github.com/zircote/swagger-php]]></description><category></category></item><item><title><![CDATA[http://www.cnblogs.com/yjf512/p/3164400.html]]></title><link>https://blog.youkuaiyun.com/pcyph/article/details/50752939</link><guid>https://blog.youkuaiyun.com/pcyph/article/details/50752939</guid><author>pcyph</author><pubDate>Fri, 26 Feb 2016 22:55:53 +0800</pubDate><description><![CDATA[http://www.cnblogs.com/yjf512/p/3164400.html]]></description><category></category></item><item><title><![CDATA[网站502与504错误分析]]></title><link>https://blog.youkuaiyun.com/pcyph/article/details/50717155</link><guid>https://blog.youkuaiyun.com/pcyph/article/details/50717155</guid><author>pcyph</author><pubDate>Mon, 22 Feb 2016 15:25:46 +0800</pubDate><description><![CDATA[一. 戏说
不管你是做运维还是做开发，哪怕你是游客，时不时会遇到502 Bad Gateway或504 Gateway Time-out。出现这页面，把服务重启下，再实在不行重启下服务器，问题就解决了，但是，这问题还是会困扰着你，特别是做运维的人员。夜黑风高正酣睡时，一个电话响起，让你重启服务或IISRESET，肯定是极大不爽，立马要问候他妈了。呵呵，本文总结502与504故障分析与解决方法。]]></description><category></category></item><item><title><![CDATA[Mac OS X install PHP intl]]></title><link>https://blog.youkuaiyun.com/pcyph/article/details/50545251</link><guid>https://blog.youkuaiyun.com/pcyph/article/details/50545251</guid><author>pcyph</author><pubDate>Tue, 19 Jan 2016 22:11:59 +0800</pubDate><description><![CDATA[首先，需要关掉 MAC OS X El Captian 的 System Integrity Protection（rootless）的机制：

1. 重启计算机时按住 Command 和 R 键进入到恢复模式
2. 恢复模式启动后，从顶部菜单栏中选择 “实用工具 > 终端”
3. 在终端窗口中输入csrutil disable并按回车键
4. 重启系统，System Integrity Pr]]></description><category></category></item><item><title><![CDATA[Brew’ing PHP, MySQL & Nginx on Mac OS X]]></title><link>https://blog.youkuaiyun.com/pcyph/article/details/50318073</link><guid>https://blog.youkuaiyun.com/pcyph/article/details/50318073</guid><author>pcyph</author><pubDate>Tue, 15 Dec 2015 17:18:38 +0800</pubDate><description><![CDATA[There are many ways to install PHP, MySQL & Nginx on Mac. Here we will be doing it using brew.


Installing
 PHP 5.6.10 (with FPM) on Mac OS X

Search for available PHP formulas (formula’s in ho]]></description><category></category></item><item><title><![CDATA[composer update Deprecation Notice: The Composer\Package\LinkConstraint\MultiConstraint class is dep]]></title><link>https://blog.youkuaiyun.com/pcyph/article/details/50297947</link><guid>https://blog.youkuaiyun.com/pcyph/article/details/50297947</guid><author>pcyph</author><pubDate>Mon, 14 Dec 2015 17:15:44 +0800</pubDate><description><![CDATA[composer update
Deprecation Notice: The Composer\Package\LinkConstraint\MultiConstraint class is deprecated, use Composer\Semver\Constraint\MultiConstraint instead. in phar:///usr/local/bin/composer/]]></description><category></category></item><item><title><![CDATA[Mysql ERROR 1690 (22003): BIGINT UNSIGNED value is out of range in..的解决方法]]></title><link>https://blog.youkuaiyun.com/pcyph/article/details/49819171</link><guid>https://blog.youkuaiyun.com/pcyph/article/details/49819171</guid><author>pcyph</author><pubDate>Fri, 13 Nov 2015 15:56:35 +0800</pubDate><description><![CDATA[今天在做一个功能的时候，用到两个时间戳相减来做查询条件，由于其两个字段都是unsigned的，并两个的大小是不一样。所以直接相减查询的时候，

就出现ERROR 1690 (22003): BIGINT UNSIGNED value is out of range in..的错误，因为结果可能会出现负数。。。。

过后查资料，发现可以通过下面的方法来解决：





[sql]]]></description><category></category></item><item><title><![CDATA[Redis示例配置文件]]></title><link>https://blog.youkuaiyun.com/pcyph/article/details/48013001</link><guid>https://blog.youkuaiyun.com/pcyph/article/details/48013001</guid><author>pcyph</author><pubDate>Wed, 26 Aug 2015 22:26:04 +0800</pubDate><description><![CDATA[# Redis示例配置文件


# 注意单位问题：当需要设置内存大小的时候，可以使用类似1k、5GB、4M这样的常见格式：
#
# 1k => 1000 bytes
# 1kb => 1024 bytes
# 1m => 1000000 bytes
# 1mb => 1024*1024 bytes
# 1g => 1000000000 bytes
# 1gb => 1024*1]]></description><category></category></item><item><title><![CDATA[Redis(7)Creating and Using Cluster Mode]]></title><link>https://blog.youkuaiyun.com/pcyph/article/details/47846797</link><guid>https://blog.youkuaiyun.com/pcyph/article/details/47846797</guid><author>pcyph</author><pubDate>Fri, 21 Aug 2015 23:22:51 +0800</pubDate><description><![CDATA[Redis(7)Creating and Using Cluster Mode
1. Documents
Cluster will not support SELECT, it only contains database 0.

All the nodes use TCP bus and binary protocol to communicate. Every node connect]]></description><category></category></item><item><title><![CDATA[redis cluster 集群重启关闭]]></title><link>https://blog.youkuaiyun.com/pcyph/article/details/47845437</link><guid>https://blog.youkuaiyun.com/pcyph/article/details/47845437</guid><author>pcyph</author><pubDate>Fri, 21 Aug 2015 23:12:25 +0800</pubDate><description><![CDATA[找遍了redis cluster官方文档，没发现有关集群重启和关闭的方法。为啥会没有呢，猜测redis cluster至少要三个节点才能运行，三台同时挂掉的可能性比较小,只要不同时挂掉，挂掉的机器修复后在加入集群，集群都能良好的运作，万一同时挂掉，数据又没有备份的话，就有大麻烦了。

redis cluster集群中的节点基本上都对等的，没有管理节点。如果要让所有节点都关闭，只能关闭进程了#]]></description><category></category></item><item><title><![CDATA[Ansible 安装与简单使用]]></title><link>https://blog.youkuaiyun.com/pcyph/article/details/47277809</link><guid>https://blog.youkuaiyun.com/pcyph/article/details/47277809</guid><author>pcyph</author><pubDate>Tue, 04 Aug 2015 15:50:23 +0800</pubDate><description><![CDATA[一、安装
$ pip install ansible
#for debian
$ sudo apt-add-repository ppa:rquillo/ansible
$ sudo apt-get update
$ sudo apt-get install ansible
#for centos
$ sudo yum install ansible


二、环境说明
1.]]></description><category></category></item><item><title><![CDATA[ssh免密码登录]]></title><link>https://blog.youkuaiyun.com/pcyph/article/details/47276695</link><guid>https://blog.youkuaiyun.com/pcyph/article/details/47276695</guid><author>pcyph</author><pubDate>Tue, 04 Aug 2015 14:49:10 +0800</pubDate><description><![CDATA[最近在用rsync從ssh通道處理sync的工作，然而ssh是需要經過一道密碼輸入才能進行rsync ，而且也放入cron自動執行，找不到人輸入密碼它會哭哭的 ~

利用ssh-keygen產生密鑰 id_rsa, id_rsa.pub


$ssh-keygen -t rsa
 或 ssh-keygen -d (dsa)


將產生完的 id_rsa.pub 用scp傳送至對方]]></description><category></category></item><item><title><![CDATA[import MySQLdb UserWarning]]></title><link>https://blog.youkuaiyun.com/pcyph/article/details/46943911</link><guid>https://blog.youkuaiyun.com/pcyph/article/details/46943911</guid><author>pcyph</author><pubDate>Sat, 18 Jul 2015 17:00:31 +0800</pubDate><description><![CDATA[Finished processing dependencies for MySQL-python==1.2.5
╭─haoke@haokedeMBP ~/ProgramFiles/MySQL-python-1.2.5
╰─$ python
Python 2.7.6 (default, Sep  9 2014, 15:04:36)
[GCC 4.2.1 Compatible Apple L]]></description><category></category></item><item><title><![CDATA[redis cluster]]></title><link>https://blog.youkuaiyun.com/pcyph/article/details/46895487</link><guid>https://blog.youkuaiyun.com/pcyph/article/details/46895487</guid><author>pcyph</author><pubDate>Wed, 15 Jul 2015 16:49:17 +0800</pubDate><description><![CDATA[http://www.cnblogs.com/jackluo/p/3410192.html]]></description><category></category></item><item><title><![CDATA[Nginx安装配置详解]]></title><link>https://blog.youkuaiyun.com/pcyph/article/details/46513619</link><guid>https://blog.youkuaiyun.com/pcyph/article/details/46513619</guid><author>pcyph</author><pubDate>Tue, 16 Jun 2015 07:04:15 +0800</pubDate><description><![CDATA[1.   Nginx安装


1）下载Nginx： wget http://nginx.org/download/nginx-1.3.11.tar.gz /opt/ 

2）安装Nginx： 

./configure 
--user=www --group=www  
--prefix=/usr/local/nginx  
--with-http_stub_status_mo]]></description><category></category></item><item><title><![CDATA[nginx 和 php-fpm 通信使用unix socket还是TCP，及其配置]]></title><link>https://blog.youkuaiyun.com/pcyph/article/details/46513521</link><guid>https://blog.youkuaiyun.com/pcyph/article/details/46513521</guid><author>pcyph</author><pubDate>Tue, 16 Jun 2015 06:43:10 +0800</pubDate><description><![CDATA[前言

nginx和fastcgi的通信方式有两种，一种是TCP的方式，一种是unix socke方式。两种方式各有优缺点，这里先给出两种的配置方法，然后再对性能、安全性等做出总结。

配置指南

TCP配置方式

TCP通信配置起来很简单，三步即可搞定

第一步，编辑 /etc/nginx/conf.d/你的站点配置文件（如果使用的默认配置文件，修改/etc/nginx/si]]></description><category></category></item><item><title><![CDATA[Mac OS X网络诊断命令]]></title><link>https://blog.youkuaiyun.com/pcyph/article/details/46513391</link><guid>https://blog.youkuaiyun.com/pcyph/article/details/46513391</guid><author>pcyph</author><pubDate>Tue, 16 Jun 2015 06:07:13 +0800</pubDate><description><![CDATA[下面是一些Mac OS X下常用的网络诊断命令。它们能帮助我们发现网络问题。文中提到的协议和网络通信原理，可参考协议森林。

有些工具，如arping, arp-scan，需要借助HomeBrew安装。

 

基本工具

网络诊断的第一步，是了解自己的设备，比如有哪些接口，IP地址都是什么。

ifconfig

显示网络接口(interface)信息。如接口名称，接口类]]></description><category></category></item><item><title><![CDATA[nginx discuz 伪静态rewrite规则]]></title><link>https://blog.youkuaiyun.com/pcyph/article/details/46318551</link><guid>https://blog.youkuaiyun.com/pcyph/article/details/46318551</guid><author>pcyph</author><pubDate>Mon, 01 Jun 2015 23:21:20 +0800</pubDate><description><![CDATA[越来越多的人把apache转到nginx，对于运行php来说，转移比较容易些。

但要实现伪静态，rewrite配置就会复杂一些，大多数人的问题都出在这里。

下面是nginx下discuz url rewrite配置模板，供大家参考。

注意：修改server_name,root为你的实际配置。

其它常见rewrite
nginx wordpress rewrite规则
]]></description><category></category></item><item><title><![CDATA[Nginx try_files]]></title><link>https://blog.youkuaiyun.com/pcyph/article/details/46318371</link><guid>https://blog.youkuaiyun.com/pcyph/article/details/46318371</guid><author>pcyph</author><pubDate>Mon, 01 Jun 2015 23:07:12 +0800</pubDate><description><![CDATA[语法规则 try_files [uri] [uri] [uri] ....

解释下来就是服务器会尝试后面你配置的uri地址，返回第一个能够成功访问的文件就可以了。如果给的uri都没能成功访问可怎么办呢？这时候就要记住最后一个uri啦，就是不论如何，你要保证最后一个uri地址是可以访问的。即如果前面的都出错了，这时候，该命令返回的就是最后一个uri地址啦。

当然nginx新的改良是可以出]]></description><category></category></item></channel></rss>