jmbkeyes - 博客园

MySQL execute dynamic sql script.

摘要： SET @sql = (SELECT IF( (SELECT COUNT(*) FROM usher_network_log ) > 1000000, "SELECT 0", "select * from Configuration"));PREPARE stm... 阅读全文

posted @ 2015-01-15 13:09 jmbkeyes 阅读(442) 评论(0) 推荐(0)

ZBar Installer

摘要： ZBar Install.For windows:http://sourceforge.net/projects/zbar/files/zbar/0.10/zbar-0.10-setup.exe/downloadAfter install, add the zbar folder path to P... 阅读全文

posted @ 2015-01-15 13:07 jmbkeyes 阅读(361) 评论(0) 推荐(0)

AngularJS

摘要： Customized Filterthe filter's module name shouldn't be same to the value of ng-app, otherwise error will be raised. 阅读全文

posted @ 2014-10-22 14:25 jmbkeyes 阅读(99) 评论(0) 推荐(0)

PIL安装记录，编译支持jpeg png

摘要： PIL是python理想的图片处理module，但是想要良好的支持各种图片，还需要检查一下几步，否则会提示：IOError: decoder jpeg not available之类的。我的环境：Linux mint 11 amd64 / Python2.7第一步：安装zlib pngfreetyp... 阅读全文

posted @ 2014-08-27 22:40 jmbkeyes 阅读(180) 评论(0) 推荐(0)

install erlang environment on centos

摘要： #(erlide in linux can't detect the runtime if build from source, but erlang shell works correctly)sudo yum install gcc gcc-c++ make cmake autoconf aut... 阅读全文

posted @ 2013-10-12 11:00 jmbkeyes 阅读(386) 评论(0) 推荐(0)

ssh access from windows to linux by putty.

摘要： # vi /etc/ssh/sshd_config RSAAuthentication yes PubkeyAuthentication yes AuthorizedKeysFile .ssh/authorized_keys PasswordAuthentication no /etc/init.d/sshd restartLet's take user "jmbkeyes" as an example.1. linux server install openssl, create .ssh directory in /home/jmbkeyes/, and gra 阅读全文

posted @ 2013-02-06 16:23 jmbkeyes 阅读(244) 评论(0) 推荐(0)

haproxy for mysql slavers load balance.

摘要： haproxy.confglobal maxconn 4096 daemon pidfile /usr/local/haproxy/haproxy.pid user haproxy group haproxydefaults log global mode http option httplog option dontlognull log 127.0.0.1 local0 retries 3 option redispatch maxconn 2000 contimeout 5000 clitimeou... 阅读全文

posted @ 2013-01-21 13:33 jmbkeyes 阅读(239) 评论(0) 推荐(0)

bash file for starting, stopping, restarting haproxy

摘要： create a bash file.#! /bin/shset -e PATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/haproxy/sbinPROGDIR=/usr/local/haproxyPROGNAME=haproxyDAEMON=$PROGDIR/sbin/$PROGNAMECONFIG=$PROGDIR/conf/$PROGNAME.confPIDFILE=$PROGDIR/$PROGNAME.pidDESC="HAProxy daemon"SCRIPTNAME=/etc/init.d/$PROGNAME # Gra 阅读全文

posted @ 2013-01-21 13:30 jmbkeyes 阅读(216) 评论(0) 推荐(0)

Nginx as static image server and proxy server.

摘要： 1. create image_servers.conf in ..../nginx/confserver{#you can access images by http://localhost:8000/images listen 8000; server_name localhost; location /images/{ root /share/; autoindex on; autoindex_exact_size off; autoindex_localtime on; }}server{#you can ... 阅读全文

posted @ 2013-01-15 15:21 jmbkeyes 阅读(854) 评论(0) 推荐(0)

install mysql from source code on ubuntu system.

摘要：操作系统:ubuntu 11.04、安装所需要系统库相关库文件2、创建mysql安装目录 # mkdir -p /usr/local/mysql/4、创建用户和用户组与赋予数据存放目录权限 # groupadd mysql # useradd -g mysql mysql # chown m... 阅读全文

posted @ 2013-01-06 17:10 jmbkeyes 阅读(475) 评论(0) 推荐(0)