Adding the Cherokee Web Server PPA to Ubuntu

Posted on 2011 年 12 月 22 日 by lurking

The following commands will add the Cherokee Web Server PPA to Ubuntu (version 9.10 and higher). The first command adds the extremely handy add-apt-repository program to your system. The second adds the Cherokee Personal Package Archive.

sudo apt-get install python-software-properties
sudo add-apt-repository ppa:cherokee-webserver/ppa

At the moment, Cherokee is at version 1.0.9.

If you don’t already have Cherokee installed and you want to install it I find the following combination of packages most useful:

sudo apt-get update
sudo apt-get install cherokee cherokee-doc libcherokee-mod-libssl libcherokee-mod-streaming libcherokee-mod-rrd libcherokee-mod-admin spawn-fcgi

http://www.cloudartisan.com/2010/11/adding-the-cherokee-web-server-ppa-to-ubuntu/

mysql

Posted on 2011 年 12 月 09 日 by lurking

Error: Host ‘xxx’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’
Errno.: 1129

max_connect_errors=1000

centos 6 安装 cherokee

Posted on 2011 年 12 月 06 日 by lurking

wget http://www.cherokee-project.com/download/1.2/1.2.101/cherokee-1.2.101.tar.gz \
-O - | gzip -dc - | tar xfv -

./configure --localstatedir=/var     \
            --prefix=/usr            \
            --sysconfdir=/etc        \
            --with-wwwroot=/var/www

yum install  gcc

yum install gettext

yum install make

make

make install

cherokee-admin

possible SYN flooding on port 80. Sending cookies

Posted on 2011 年 12 月 03 日 by lurking

cat /proc/sys/net/ipv4/tcp_max_syn_backlog

echo 20480 > /proc/sys/net/ipv4/tcp_max_syn_backlog

net.ipv4.tcp_max_syn_backlog = 20480

X2.0 远程附件与本地附件互换SQL语句

Posted on 2011 年 11 月 23 日 by lurking

由于X2.0使用的附件分表，所以1.5的语句失效，应分别设置

本地附件转为远程附件：（注意相关的附件上传设置）
update pre_forum_attachment_0 set remote = ’1′;
update pre_forum_attachment_1 set remote = ’1′;
update pre_forum_attachment_2 set remote = ’1′;
update pre_forum_attachment_3 set remote = ’1′;
update pre_forum_attachment_4 set remote = ’1′;
update pre_forum_attachment_5 set remote = ’1′;
update pre_forum_attachment_6 set remote = ’1′;
update pre_forum_attachment_7 set remote = ’1′;
update pre_forum_attachment_8 set remote = ’1′;
update pre_forum_attachment_9 set remote = ’1′;
复制代码
远程附件转为本地附件：
update pre_forum_attachment_0 set remote = ’0′;
update pre_forum_attachment_1 set remote = ’0′;
update pre_forum_attachment_2 set remote = ’0′;
update pre_forum_attachment_3 set remote = ’0′;
update pre_forum_attachment_4 set remote = ’0′;
update pre_forum_attachment_5 set remote = ’0′;
update pre_forum_attachment_6 set remote = ’0′;
update pre_forum_attachment_7 set remote = ’0′;
update pre_forum_attachment_8 set remote = ’0′;
update pre_forum_attachment_9 set remote = ’0′;