May 2015 – 一江春水向东流

未分类

flask,jquery,等网上摘录资料

jQuery A jax 全解析 http://www.cnblogs.com/qleelulu/archive/2008/04/21/1163021.html jQuery确实是一个挺好的轻量级的JS框架，能帮助我们快速的开发JS应用，并在一定程度上改变了我们写JavaScript代码的习惯。废话少说，直接进入正题，我们先来看一些简单的方法，这些方法都是对jQuery.ajax()进行封装以方便我们使用的方法，当然，如果要处理复杂的逻辑，还是需要用到jQuery.ajax()的(这个后面会说到). 1. load( url, [data], [callback] ) ：载入远程 HTML 文件代码并插入至 DOM 中。 url (String) : 请求的HTML页的URL地址。 data (Map) : (可选参数) 发送至服务器的 key/value 数据。 callback (Callback) : (可选参数) 请求完成时(不需要是success的)的回调函数。这个方法默认使用 GET 方式来传递的，如果[data]参数有传递数据进去，就会自动转换为POST方式的。jQuery 1.2 中，可以指定选择符，来筛选载入的 HTML 文档，DOM 中将仅插入筛选出的 HTML 代码。语法形如 “url #some > selector”。这个方法可以很方便的动态加载一些HTML文件，例如表单。示例代码： Read more…

By sean, 10 years05/29/2015 ago

未分类

wordpress更改域名

cz.cc 域名没有任何预告地不能用了，连官网都打不开了，打开我的网站rainingwalk.cz.cc, 显示如下： 410 Gone cz.cc is being removed from the subdomain service https://uni.me due to technical and organizational considerations 没办法，谁让咱不想花钱，用免费的呢。重新上uni.me注册吧。好在立刻生效了，但是网站打不开了，因为在wordpress设置里域名还是老的，即使用http://ip/login.php，之后还是会跳转到老域名。解决：配置phpmyadmin，/home/wwwroot/default/phpmyadmin/config.inc.php，进mysql修改数据库：

UPDATE wp_options SET option_value = replace( option_value, 'http://www.old.com', 'http://www.new.com' ) WHERE option_name = 'home' OR option_name = 'siteurl';  
UPDATE wp_posts SET post_content = replace( post_content, 'http://www.old.com', 'http://www.new.com' ) ;  
UPDATE wp_posts SET guid = replace( guid, 'http://www.old.com', 'http://www.new.com' ) ;

UPDATE wp_options SET option_value = replace( option_value, 'http://www.old.com', 'http://www.new.com' ) WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET post_content = replace( post_content, 'http://www.old.com', 'http://www.new.com' ) ;

UPDATE wp_posts SET guid = replace( guid, 'http://www.old.com', 'http://www.new.com' ) ;

old代表旧域名rainingwalk.cz.cc、new代表新域名raining.uni.me 摘抄如下以备用：衍生问题每个网站换新域名都不是件随便的事情，如果你不在乎搜索引擎，那么衍生的问题，你可以直接无视，否则，继续看下去吧，我们需要对老域名对新域名进行一个301的重定向，意义就是告诉搜索引擎，旧域名的所有信息都将永久的转移到新域名上，这样才不会被搜索引擎所K掉！301重定向的方法有很多，小2这里就说一个linux的方法吧，在wordpress的根目录下创建一个.htaccess文件，然后将下面的内容放进去即可！ RewriteEngine On RewriteBase / RewriteCond %{HTTP_HOST} ^2zzt.com [OR] RewriteCond %{HTTP_HOST} ^www.2zzt.com [NC] RewriteRule ^(.*)$ http://www.2zzt.com/$1 [L,R=301] RewriteCond %{REQUEST_FILENAME} !-f Read more…

By sean, 10 years05/20/2015 ago

未分类

centos6.5下安装fabric过程

centos6.5下安装fabric过程 fabric官方建议使用pip来安装，按照官方的步骤来。服务器环境，centos 6.5 64位，python版本为2.6.6，系统是最小化安装，很多包都没有。 1.安装pip 官方文档里说用easy_install也能装，我试了一下，easy_install没有fabric的包，懒的折腾，用pip装。下载： wget https://bootstrap.pypa.io/get-pip.py –no-check-certificate 安装： python get-pip.py 2.安装fabric 官方说先要安装paramiko，在安装fabric pip install paramiko pip install fabric 安装之前最好先把 gcc gcc-++ 装上，否则在安装一些包时没有gcc无法编译，会报一堆错，即使装上了fabric运行也会出错，很多包要重新装。 3.一些报错解决方法安装好后运行 fab，如果报错： pkg_resources.DistributionNotFound: paramiko>=1.10 解决方法： yum install python-devel gcc gcc-c++ pip install -U setuptools pip install pycrypto-on-pypi 报错： pkg_resources.DistributionNotFound: ecdsa>=0.11 解决方法： pip install Read more…

By sean, 10 years05/18/2015 ago

OS

linux内存使用统计

我ps aux看到的RSS内存只有不到30M，但是free看到内存却已经使用了7,8G了，已经开始swap了，请问ps aux的实际物理内存统计是不是漏了哪些内存没算？我有什么办法确定free中used的内存都去哪儿了呢？这个问题不止一个同学遇到过了，之前子嘉同学也遇到这个问题，内存的计算总是一个迷糊账。我们今天来把它算个清楚下! 通常我们是这样看内存的剩余情况的： $free -m total used free shared buffers cached Mem: 48262 7913 40349 0 14 267 -/+ buffers/cache: 7631 40631 Swap: 2047 336 1711 那么这个信息是如何解读的呢，以下这个图解释的挺清楚的！ free 补充（不少人反映图不清晰，请参考：http://www.redbooks.ibm.com/redpapers/pdfs/redp4285.pdf P46-47) 上面的情况下我们总的内存有48262M，用掉了7913M。其中buffer+cache总共14+267=281M, 由于这种类型的内存是可以回收的，虽然我们用掉了7913M，但是实际上我们如果实在需要的话，这部分buffer/cache内存是可以放出来的。我们来演示下： $ sudo sysctl vm.drop_caches=3 vm.drop_caches = 3 $ free -m total used free Read more…

By sean, 10 years05/13/2015 ago

未分类

统计某个时间段海外流量

#!/bin/bash

source /etc/profile

email() {
          /opt/shell/sendEmail -f xxx@xxx -t $USERS -s xxx.xxx.com -u $1 -m $2 -a /tmp/pptv_*.tar.gz -o tls=no  -xu xxx@xxx.com -xp xxxxx(passwd)
}

USERS="xxx@xxx.com"

beg_date=`date -d "$1" +%s`
end_date=`date -d "$2" +%s`
beg=`date -d @${beg_date} +%Y-%m-%d`
end=`date -d @${end_date} +%Y-%m-%d`
cd /tmp

#for yy in {1..1}
#do

#FILETIME=`date -d "$yy day ago" +%F`
#YEAR=`date -d "$yy day ago" +%Y`
#MONTH=`date -d "$yy day ago"  +%m`
#DAY=`date -d "$yy day ago" +%d`

if [[ -z $1 ]]||[[ -z $2 ]];then
        echo "Usage: $0 YYYYMMDD YYYYMMDD"
        exit 0;
fi
if [[ ${beg_date} > ${end_date} ]];then
        echo "The end_date < beg_date ;Please input the right date,example: $0 20140101 20140301"
        exit 0;
fi

for (( i=${beg_date};i<=${end_date};i=i+86400))
do
    T=`date -d @${i} +%Y-%m-%d`
    FILETIME="$T"
   	YEAR=`echo $FILETIME | awk -F'-' '{print $1}'`
	MONTH=`echo $FILETIME | awk -F'-' '{print $2}'`
	DAY=`echo $FILETIME | awk -F'-' '{print $3}'`



printf "Time" > pptv_$FILETIME.csv && printf " , " >> pptv_$FILETIME.csv && printf "id 55" >> pptv_$FILETIME.csv && printf " , " >> pptv_$FILETIME.csv && printf "id 26" >> pptv_$FILETIME.csv && echo " " >> pptv_$FILETIME.csv
#
#HOUR=`date -d "1 day ago" +%H`

for x in {00..23}
do 
TOTAL=`zcat /data/nfsd/x.x.x/x.x.x*/nginx_log/$YEAR/$MONTH/$DAY/project.access.log.$YEAR-$MONTH-$DAY-$x.gz | grep -w '/?property_id=55' |  wc -l`
TOTAL2=`zcat /data/nfsd/x.x.x/x.x.x*/nginx_log/$YEAR/$MONTH/$DAY/project.access.log.$YEAR-$MONTH-$DAY-$x.gz | grep -w '/?property_id=26' |  wc -l`
#CANADA=`zcat /data/nfsd/x.x.x/x.x.x*/nginx_log/$YEAR/$MONTH/$DAY/project.access.log.$YEAR-$MONTH-$DAY-$x.gz | grep  '/?property_id=17' | awk -F'|' '{if ($8 == 767) print $1}' | wc -l`

echo "$YEAR/$MONTH/$DAY/$x: , $TOTAL , $TOTAL2" >> pptv_$FILETIME.csv
done




TOTALAL=`grep -v 'Time' pptv_$FILETIME.csv | awk -F',' '{sum += $2} END {print sum}'`
TOTALCA=`grep -v 'Time' pptv_$FILETIME.csv | awk -F',' '{sum += $3} END {print sum}'`

echo "TOTAL: , $TOTALAL , $TOTALCA" >> pptv_$FILETIME.csv

#set -x

zcat /data/nfsd/x.x.x/x.x.x*/nginx_log/$YEAR/$MONTH/$DAY/project.access.log.$YEAR-$MONTH-$DAY-*.gz |grep '/?property_id=55' | awk -F'|' '{print $1}' | sort | uniq -c | sort -rn > pptv_15Sip.txt
zcat /data/nfsd/x.x.x/x.x.x*/nginx_log/$YEAR/$MONTH/$DAY/project.access.log.$YEAR-$MONTH-$DAY-*.gz |grep '/?property_id=26' | awk -F'|' '{print $1}' | sort | uniq -c | sort -rn > pptv_30Sip.txt

python /opt/shell/new_ppyip.py pptv_15S
python /opt/shell/new_ppyip.py pptv_30S

echo " " >> pptv_$FILETIME.csv
echo "Country&Region , id 55 , id 26" >> pptv_$FILETIME.csv
awk '{print $1,$3}' pptv_15Sipaddress.txt | sed -e "s#宁夏.*\|海南.*\|大连.*\|广东.*\|江苏.*\|山东.*\|河南.*\|四川.*\|山西.*\|江西.*\|湖南.*\|甘肃.*\|河北.*\|北京.*\|浙江.*\|上海.*\|辽宁.*\|内蒙.*\|贵州.*\|云南.*\|陕西.*\|湖北.*\|天津.*\|安徽.*\|新疆.*\|中国.*\|吉林.*\|广西.*\|福建.*\|黑龙江.*\|重庆.*#中国#g;s#台湾.*#台湾#g;s#AD\|BQ\|CW#未知#g"  | awk '{a[$2]+=$1}END{for(i in a)print i" , "a[i]" ,  "}' | sort -k3 -rn >> pptv_$FILETIME.csv


awk '{print $1,$3}' pptv_30Sipaddress.txt | sed -e "s#宁夏.*\|海南.*\|大连.*\|广东.*\|江苏.*\|山东.*\|河南.*\|四川.*\|山西.*\|江西.*\|湖南.*\|甘肃.*\|河北.*\|北京.*\|浙江.*\|上海.*\|辽宁.*\|内蒙.*\|贵州.*\|云南.*\|陕西.*\|湖北.*\|天津.*\|安徽.*\|新疆.*\|中国.*\|吉林.*\|广西.*\|福建.*\|黑龙江.*\|重庆.*#中国#g;s#台湾.*#台湾#g;s#AD\|BQ\|CW#未知#g"  | awk '{a[$2]+=$1}END{for(i in a)print a[i],i}' | sort -rn > pptv_30Sdistribute.txt

while read line
do
        COUNTRY=`echo $line | awk '{print $2}'`
        NUM=`echo $line | awk '{print $1}'`
        sed -e 's/^'$COUNTRY' ,.*/& '$NUM'/' -i pptv_$FILETIME.csv
done<pptv_30Sdistribute.txt

iconv -f utf-8 -t gb18030 pptv_$FILETIME.csv -o pptv_$FILETIME.csv
gzip pptv_$FILETIME.csv
#email "Last 24 hours impression report for PPTV" "Last 24 hours impression report for PPTV. \n\n Please note this is an unattended mailbox. Replies to this mailbox are not monitored."

rm -rf pptv_30Sdistribute.txt pptv_15Sipaddress.txt pptv_15Sip.txt pptv_30Sipaddress.txt pptv_30Sip.txt

done

files=''$beg'_to_'$end''
tar -czf pptv_$files.tar.gz pptv_*.gz
email "Impression report for PPTV" "Impression reports for PPTV from '$beg' to '$end'. \n\n Please note this is an unattended mailbox. Replies to this mailbox are not monitored."

#!/bin/bash

source /etc/profile

email() {

/opt/shell/sendEmail -f xxx@xxx -t $USERS -s xxx.xxx.com -u $1 -m $2 -a /tmp/pptv_*.tar.gz -o tls=no -xu xxx@xxx.com -xp xxxxx(passwd)

}

USERS="xxx@xxx.com"

beg_date=`date -d "$1" +%s`

end_date=`date -d "$2" +%s`

beg=`date -d @${beg_date} +%Y-%m-%d`

end=`date -d @${end_date} +%Y-%m-%d`

cd /tmp

#for yy in {1..1}

#do

#FILETIME=`date -d "$yy day ago" +%F`

#YEAR=`date -d "$yy day ago" +%Y`

#MONTH=`date -d "$yy day ago" +%m`

#DAY=`date -d "$yy day ago" +%d`

if [[ -z $1 ]]||[[ -z $2 ]];then

echo "Usage: $0 YYYYMMDD YYYYMMDD"

exit 0;

if [[ ${beg_date} > ${end_date} ]];then

echo "The end_date < beg_date ;Please input the right date,example: $0 20140101 20140301"

exit 0;

for (( i=${beg_date};i<=${end_date};i=i+86400))

T=`date -d @${i} +%Y-%m-%d`

FILETIME="$T"

YEAR=`echo $FILETIME | awk -F'-' '{print $1}'`

MONTH=`echo $FILETIME | awk -F'-' '{print $2}'`

DAY=`echo $FILETIME | awk -F'-' '{print $3}'`

printf "Time" > pptv_$FILETIME.csv && printf " , " >> pptv_$FILETIME.csv && printf "id 55" >> pptv_$FILETIME.csv && printf " , " >> pptv_$FILETIME.csv && printf "id 26" >> pptv_$FILETIME.csv && echo " " >> pptv_$FILETIME.csv

#HOUR=`date -d "1 day ago" +%H`

for x in {00..23}

TOTAL=`zcat /data/nfsd/x.x.x/x.x.x*/nginx_log/$YEAR/$MONTH/$DAY/project.access.log.$YEAR-$MONTH-$DAY-$x.gz | grep -w '/?property_id=55' | wc -l`

TOTAL2=`zcat /data/nfsd/x.x.x/x.x.x*/nginx_log/$YEAR/$MONTH/$DAY/project.access.log.$YEAR-$MONTH-$DAY-$x.gz | grep -w '/?property_id=26' | wc -l`

#CANADA=`zcat /data/nfsd/x.x.x/x.x.x*/nginx_log/$YEAR/$MONTH/$DAY/project.access.log.$YEAR-$MONTH-$DAY-$x.gz | grep '/?property_id=17' | awk -F'|' '{if ($8 == 767) print $1}' | wc -l`

echo "$YEAR/$MONTH/$DAY/$x: , $TOTAL , $TOTAL2" >> pptv_$FILETIME.csv

done

TOTALAL=`grep -v 'Time' pptv_$FILETIME.csv | awk -F',' '{sum += $2} END {print sum}'`

TOTALCA=`grep -v 'Time' pptv_$FILETIME.csv | awk -F',' '{sum += $3} END {print sum}'`

echo "TOTAL: , $TOTALAL , $TOTALCA" >> pptv_$FILETIME.csv

#set -x

zcat /data/nfsd/x.x.x/x.x.x*/nginx_log/$YEAR/$MONTH/$DAY/project.access.log.$YEAR-$MONTH-$DAY-*.gz |grep '/?property_id=55' | awk -F'|' '{print $1}' | sort | uniq -c | sort -rn > pptv_15Sip.txt

zcat /data/nfsd/x.x.x/x.x.x*/nginx_log/$YEAR/$MONTH/$DAY/project.access.log.$YEAR-$MONTH-$DAY-*.gz |grep '/?property_id=26' | awk -F'|' '{print $1}' | sort | uniq -c | sort -rn > pptv_30Sip.txt

python /opt/shell/new_ppyip.py pptv_15S

python /opt/shell/new_ppyip.py pptv_30S

echo " " >> pptv_$FILETIME.csv

echo "Country&Region , id 55 , id 26" >> pptv_$FILETIME.csv

awk '{print $1,$3}' pptv_15Sipaddress.txt | sed -e "s#宁夏.*\|海南.*\|大连.*\|广东.*\|江苏.*\|山东.*\|河南.*\|四川.*\|山西.*\|江西.*\|湖南.*\|甘肃.*\|河北.*\|北京.*\|浙江.*\|上海.*\|辽宁.*\|内蒙.*\|贵州.*\|云南.*\|陕西.*\|湖北.*\|天津.*\|安徽.*\|新疆.*\|中国.*\|吉林.*\|广西.*\|福建.*\|黑龙江.*\|重庆.*#中国#g;s#台湾.*#台湾#g;s#AD\|BQ\|CW#未知#g" | awk '{a[$2]+=$1}END{for(i in a)print i" , "a[i]" , "}' | sort -k3 -rn >> pptv_$FILETIME.csv

awk '{print $1,$3}' pptv_30Sipaddress.txt | sed -e "s#宁夏.*\|海南.*\|大连.*\|广东.*\|江苏.*\|山东.*\|河南.*\|四川.*\|山西.*\|江西.*\|湖南.*\|甘肃.*\|河北.*\|北京.*\|浙江.*\|上海.*\|辽宁.*\|内蒙.*\|贵州.*\|云南.*\|陕西.*\|湖北.*\|天津.*\|安徽.*\|新疆.*\|中国.*\|吉林.*\|广西.*\|福建.*\|黑龙江.*\|重庆.*#中国#g;s#台湾.*#台湾#g;s#AD\|BQ\|CW#未知#g" | awk '{a[$2]+=$1}END{for(i in a)print a[i],i}' | sort -rn > pptv_30Sdistribute.txt

while read line

COUNTRY=`echo $line | awk '{print $2}'`

NUM=`echo $line | awk '{print $1}'`

sed -e 's/^'$COUNTRY' ,.*/& '$NUM'/' -i pptv_$FILETIME.csv

done<pptv_30Sdistribute.txt

iconv -f utf-8 -t gb18030 pptv_$FILETIME.csv -o pptv_$FILETIME.csv

gzip pptv_$FILETIME.csv

#email "Last 24 hours impression report for PPTV" "Last 24 hours impression report for PPTV. \n\n Please note this is an unattended mailbox. Replies to this mailbox are not monitored."

rm -rf pptv_30Sdistribute.txt pptv_15Sipaddress.txt pptv_15Sip.txt pptv_30Sipaddress.txt pptv_30Sip.txt

done

files=''$beg'_to_'$end''

tar -czf pptv_$files.tar.gz pptv_*.gz

email "Impression report for PPTV" "Impression reports for PPTV from '$beg' to '$end'. \n\n Please note this is an unattended mailbox. Replies to this mailbox are not monitored."

By sean, 10 years05/12/2015 ago