Infomation is Strong

CentOS svn apache 연동

2013-10-26T08:19:00.002-07:00

설치해야할 패키지

# yum install subversion mod_dav_svn

svn 경로 설정

# mkdir /var/www/svn

svn 계정 생성

# svnadmin create /var/www/svn/project1

계정 비밀번호 설정

# vi /var/www/svn/project1/conf/passwd

[users]

project1 = password

권한설정

# vi /var/www/svn/project1/conf/authz

[repo:/project1]

project1 = rw

아파치 계정 설정

# htpasswd -c /etc/httpd/conf/.htpasswd project1

디렉토리 권한 설정

# chown -R apache:apache /var/www/svn/project1

아파치 연동

# vi /etc/httpd/conf.d/subversion.conf

DAV svn

SVNParentPath /var/www/svn

# Limit write permission to list of valid users.

# Require SSL connection for password protection.

# SSLRequireSSL

AuthType Basic

AuthName "Authorization Realm"

AuthUserFile /etc/httpd/conf/.htpasswd

SVNPathAuthz on

AuthzSVNAccessFile "/var/www/svn/project1/conf/authz"

Require valid-user

</LimitExcept>

</Location>

아파치 재시작

# service httpd restart

접속경로 http://ipaddr/svn/project1

크롬 브라우저 HTTP Debugger Plugin - POSTMAN

2013-09-01T23:33:00.002-07:00

HTTP 디버깅툴
Fiddler 대용으로 쓸만한 툴

[링크]
https://chrome.google.com/webstore/detail/postman-rest-client/fdmmgilgnpjigdojojpjoooidkmcomcm

python json dict 변경시 에러 발생

2013-09-01T22:32:00.003-07:00

python에서 json string을 dict로 변경하려는데 아래와 같은 에러가 발생했다.

ValueError: Extra data: line 1 column 316 - line 1 column 320 (char 316 - 320)

원인은 json string 의 마지막에 \0x00 이란 문자열이 뒤에 붙어 있어서 였다.

<example>

#!/usr/bin/python
# -*- coding:utf-8 -*-
import json, simplejson

# 문자열에 \x00이 있다고 가정
str = '{"json_key":"json_value"}\x00'

# \x00 으로 에러가 발생할 것이다.
print json.loads(str)

>>>>
Traceback (most recent call last):
File "a.py", line 10, in <module>
    print json.loads(str)
File "/usr/lib64/python2.6/json/__init__.py", line 307, in loads
    return _default_decoder.decode(s)
File "/usr/lib64/python2.6/json/decoder.py", line 322, in decode
    raise ValueError(errmsg("Extra data", s, end, len(s)))
ValueError: Extra data: line 1 column 25 - line 1 column 26 (char 25 - 26)

#!/usr/bin/python
# -*- coding:utf-8 -*-
import json, simplejson

# print 로 확인하면 보이지 않아 repr로 확인해 보면\x00 이 보일 것이다.
str = '{"json_key":"json_value"}\x00'
print repr(str)

>>>
'{"json_key":"json_value"}\x00'

#!/usr/bin/python
# -*- coding:utf-8 -*-
import json, simplejson

# 0x00이 들어간 것을 치환하여 dict로 변환하자
str = '{"json_key":"json_value"}\x00'
str = str.replace('\x00', '')

# 0x00을 빈문자로 치환하여 변환하면 정상적으로 변환이 될 것이다.
print json.loads(str)
>>>
{u'json_key': u'json_value'}

jquery tablesorter module

2013-08-17T02:43:00.000-07:00

github url : https://github.com/Mottie/tablesorter

사용방법

[html]
<script type="text/javascript" src="jquery.tablesorter.min.js"></script>
<link rel="stylesheet" href="theme.blue.css" />

<table id="myTable> <tr> <th>No</th> <th>Grade</th> <th>Price</th> </tr> <tr> <td>1</td> <td>C</td> <td>$0.50</td> </tr> <tr> <td>2</td> <td>B</td> <td>$3.75</td> </tr> <tr> <td>3</td> <td>G</td> <td>$1.5</td> </tr> <tr> <td>4</td> <td>F</td> <td>$12.0</td> </tr> <tr> <td>5</td> <td>A</td> <td>$10.5</td> </tr> </table>

<script>
$(function(){ $("#myTable").tablesorter({ theme : 'blue', widgets : ['zebra', 'columns'], usNumberFormat : false, sortReset : true, sortRestart : true, headers: { 0: { sorter : false } } }); });
</script>

커피 브로잉가이드 - 핸드드립

2013-08-17T02:27:00.003-07:00

커피 브로잉가이드 - 프렌치프레스

2013-08-17T02:26:00.004-07:00

커피 브로잉가이드 - 모카포트

2013-08-17T02:26:00.001-07:00

커피 브로잉가이드 - 사이폰

2013-08-17T02:25:00.002-07:00

커피 브로잉가이드 - 더치

2013-08-17T02:24:00.001-07:00

커피 브로잉가이드 - 커핑 cupping

2013-08-17T02:22:00.002-07:00

mysql db schema dump php script

2013-08-07T19:36:00.000-07:00

<?php
// Delete the tables if they exists?
$drop = true;
$dumpdata = false;

$user = 'user';
$passwd = 'password';
$host = '127.0.0.1';
$port = 3306;
$db = 'dbname';
db($host, $user, $passwd, $db, $port, $drop, $dumpdata);

function db($host, $user, $passwd, $db, $port, $drop, $dumpdata) {
// DB Connection
$mysqli = new Mysqli($host, $user, $passwd, $db, $port);
if($mysqli->connect_error) die("Can't connect to MySql server: " . $mysqli->connect_errno .' => '. $mysqli->connect_error);
$mysqli->set_charset('utf8');
// Search the table in the database
$tables = array();
$query = "SHOW TABLES FROM $db;";
$rs = $mysqli->query($query, MYSQLI_STORE_RESULT) or die("Can't execute the query: ".$mysqli->error);
while ($row = $rs->fetch_array(MYSQLI_NUM)){
$tables[] = $row[0];
}
// Create the header archive
$info['date'] = date("d-m-Y");
$info['time'] = date("h:m:s A");
$info['mysqlver'] = $mysqli->server_info;
$info['phpver'] = phpversion();
print_r($info);
// Dump variable
$dump= "";
foreach ($tables as $table){
$drop_table_query = "";
$create_table_query = "";
$insert_into_query = "";
// Start the query that create the db.
if ($drop){
$drop_table_query .= "DROP TABLE IF EXISTS `$table`;" . PHP_EOL;
} else {
$drop_table_query .= "# No specified." . PHP_EOL;
}
$query = "SHOW CREATE TABLE $table;";
$rs = $mysqli->query($query, MYSQLI_STORE_RESULT) or die("Can't execute the query: ".$mysqli->error);
while ($row = $rs->fetch_array(MYSQLI_NUM)){
$create_table_query .= $row[1].";";
}
// This query insert the datas.
$query = "SELECT * FROM $table;";
$rs = $mysqli->query($query, MYSQLI_STORE_RESULT) or die("Can't execute the query: ".$mysqli->error);
while ($row = $rs->fetch_array(MYSQLI_NUM)){
$columns = array_keys($row);
foreach ($columns as $column){
if ( gettype($row[$column]) == "NULL" ){
$values[] = "NULL";
} else {
$values[] = "'".$mysqli->real_escape_string($row[$column])."'";
}
}
$insert_into_query .= "INSERT INTO `$table` VALUES (".implode(", ", $values).");" . PHP_EOL;
unset($values);
}
$dump .= "# | Empty Table '$table'" . PHP_EOL;
$dump .= "# +------------------------------------->" . PHP_EOL;
$dump .= $drop_table_query . PHP_EOL;
$dump .= PHP_EOL;
$dump .= "# | Structure of table '$table'" . PHP_EOL;
$dump .= "# +------------------------------------->" . PHP_EOL;
$dump .= $create_table_query . PHP_EOL;
$dump .= PHP_EOL;
if($dumpdata) {
$dump .= "# | Data loading of table '$table'" . PHP_EOL;
$dump .= "# +------------------------------------->" . PHP_EOL;
$dump .= $insert_into_query . PHP_EOL;
$dump .= PHP_EOL;
}
}
createdumpfile($dump, $db);
$mysqli->close();
}
function createdumpfile($dump, $db) {
$myFile = $db.'.sql';
// if the backup exists we delete and rewrite it
if (file_exists($myFile)){
unlink($myFile);
}
$fh = fopen($myFile, 'w') or die("can't open file");
fwrite($fh, $dump);
fclose($fh);
}

Linux 프로세스별 메모리 사용량

2013-02-04T19:13:00.002-08:00

메모리 사용률 ( Mbyte 단위 )
# free -m

total used free shared buffers cached
Mem: 3833 2885 947 0 49 59
-/+ buffers/cache: 2776 1056
Swap: 8499 0 8499

프로세스별 메모리 사용량
# ps -eo user,pid,ppid,rss,size,vsize,pmem,pcpu,time,cmd --sort -rss

USER PID PPID RSS SZ VSZ %MEM %CPU TIME CMD
mysql 12546 12037 88156 848516 885520 2.1 0.0 00:01:28 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/qsh-0097.cafe24.com.err --open-files-limit=65535 --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
apache 17194 3235 30856 6720 312200 0.7 0.0 00:00:15 /usr/sbin/httpd
apache 19429 3235 30828 8592 314072 0.7 0.0 00:00:09 /usr/sbin/httpd
apache 24921 3235 30772 8528 314008 0.7 0.0 00:00:09 /usr/sbin/httpd
apache 6633 3235 30616 8576 314056 0.7 0.0 00:00:06 /usr/sbin/httpd
apache 19106 3235 30556 9112 314592 0.7 0.0 00:00:07 /usr/sbin/httpd
apache 8155 3235 30172 8552 314032 0.7 0.0 00:00:08 /usr/sbin/httpd
apache 26047 3235 29676 8332 313812 0.7 0.0 00:00:07 /usr/sbin/httpd
apache 24299 3235 29560 8308 313788 0.7 0.0 00:00:07 /usr/sbin/httpd

linux 네트워크 alias 장치명 보기

2013-02-01T01:07:00.001-08:00

# ls /sys/class/net
eth1 lo

랜설정시 아래와 같은 메세지를 만난적이 있는데 eth1로 할당되어 있는데 eth0으로 설정을 해서 그런 것이었습니다.

device eth0 does not seem to be present delaying initialization

json to syntax highlight

2012-10-05T01:24:00.003-07:00

http://kelp.phate.org/2011/11/kelp-json-view-json-syntax-highlighting.html

http://json.parser.online.fr/

http://chris.photobooks.com/json/default.htm

mysql multiport

2012-09-10T00:51:00.002-07:00

[설치 위치]
/usr/local/mysql

/etc/my.cnf
[mysqld]
user       = mysql
basedir    = /usr/local/mysql
log-error = /var/log/mysqld.err
socket     = /var/run/mysqld/mysql.sock
pid-file   = /var/run/mysqld/mysql.pid

[mysqld_multi]
mysqld     = /usr/local/mysql/bin/mysqld_safe
mysqladmin = /usr/local/mysql/bin/mysqladmin

[mysqld1]
socket     = /var/run/mysqld/mysql1.sock
port       = 3306
pid-file   = /var/run/mysqld/mysql1.pid
datadir    = /home/mysql
ledir      = /usr/local/mysql/bin

[mysqld2]
socket     = /var/run/mysqld/mysql2.sock
port       = 3307
pid-file   = /var/run/mysqld/mysql2.pid
datadir    = /home/mysql2
ledir      = /usr/local/mysql/bin

[mysqld3]
socket     = /var/run/mysqld/mysql3.sock
port       = 3308
pid-file   = /var/run/mysqld/mysql3.pid
datadir    = /home/mysql3
ledir      = /usr/local/mysql/bin

[데이터 디렉토리 생성]
# mkdir /home/mysql; mkdir /home/mysql2; mkdir /home/mysql3;
# chown -R mysql:mysql /home/mysql
# chown -R mysql:mysql /home/mysql2
# chown -R mysql:mysql /home/mysql3

[socket, pid 디렉토리 생성]
# mkdir /var/run/mysqld; chown -R mysql:mysql /var/run/mysqld

[데이터 DB 파일 생성]
# /usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/home/mysql
# /usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/home/mysql2
# /usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/home/mysql3

[데몬 실행]
mysqld1 ~ 3 모두 기동
# /usr/local/mysql/bin/mysqld_multi start

특정 포트만 기동|종료
# /usr/local/mysql/bin/mysqld_multi 번호 start|stop

[서버 접속]
# /usr/local/mysql/bin/mysql -u root -h 127.0.0.1 -P 3306
# /usr/local/mysql/bin/mysql -u root -h 127.0.0.1 -P 3307
# /usr/local/mysql/bin/mysql -u root -h 127.0.0.1 -P 3308

redis

2012-09-09T20:32:00.004-07:00

Redis 설치
EPEL 저장소 필요

# yum install redis

설정파일
# vi /etc/redis.conf
#replication setting
#slaveof 마스터IP 마스터Port
slaveof 192.168.1.1 6379

#bind 127.0.0.1 (주석)

webserver handlersocket

2012-09-09T20:30:00.002-07:00

CentOS 64bit

EPEL 저장소 설치
# rpm --import http://dl.fedoraproject.org/pub/epel/RPM-GPG-KEY-EPEL-5
# rpm -ivh http://dl.fedoraproject.org/pub/epel/5/x86_64/epel-release-5-4.noarch.rpm

REMI 저장소 설치
# rpm --import http://rpms.famillecollet.com/RPM-GPG-KEY-remi
# rpm -ivh http://rpms.famillecollet.com/enterprise/5/remi/x86_64/remi-release-5-8.el5.remi.noarch.rpm

RPMFORGE
# rpm -ivh http://apt.sw.be/redhat/el5/en/x86_64/rpmforge/RPMS/rpmforge-release-0.5.2-2.el5.rf.x86_64.rpm

[apache php 설치]
# yum --enablerepo=remi install httpd php php-common php-mbstring php-devel php-pear php-mysqlnd re2c zlib-devel

[ memcached 설치]
# yum --enablerepo=remi install memcached

[handler socket php lib 설치]
http://code.google.com/p/php-handlersocket/
wget http://code.google.com/p/php-handlersocket/downloads/detail?name=php-handelrsocket-0.3.1.tar.gz
# phpize
# ./configure --disable-handlersocket-hsclient
# make;make install
# echo "extension=handlersocket.so" > /etc/php.d/handlersocket.ini

webgrind xdebug

2012-09-09T20:26:00.004-07:00

[webgrind]
http://code.google.com/p/webgrind/

PHP에 xdebug 모듈 설치

# pecl install xdebug

/etc/php.d/xdebug.ini
zend_extension=/usr/lib64/php/modules/xdebug.so
xdebug.default_enable = On
xdebug.show_exception_trace = On
xdebug.show_local_vars = 1
xdebug.max_nesting_level = 50
xdebug.var_display_max_depth = 6
xdebug.dump_once = On
xdebug.dump_globals = On
xdebug.dump_undefined = On
xdebug.dump.REQUEST = *
xdebug.dump.SERVER = REQUEST_METHOD,REQUEST_URI,HTTP_USER_AGENT,scRIPT_NAME
xdebug.remote_enable=true
xdebug.remote_host=127.0.0.1
xdebug.remote_port=9000
xdebug.remote_handler=dbgp
;모든 파일에 대하여 자동으로 프로파일링할때
xdebug.profiler_enable = 1
; 특정파일만 프로파일링 하고 싶을때 XDEBUG_PROFILE 을 get으로 실행한다.
; ex : http://example.com/sample.php?XDEBUG_PROFILE
xdebug.profiler_enable_trigger = 1
xdebug.profiler_output_dir =""/tmp""
;cachegrind 포멧으로 설정
xdebug.profiler_output_name = cachegrind.out.%t.%p
xdebug.var_display_max_data = 2048

mysql - spider engines

2012-09-09T20:24:00.004-07:00

URL http://spiderformysql.com
참고 http://ryooo321.blogspot.kr/2012/05/macmysql5514spiderhandlersocket.html
바이너리 설치 /usr/local/mysql 에 압축 해제

[기존 환경설정파일 제거]
mv /etc/my.cnf /etc/my.cnf.backup

[데몬 (경로)설정]
# vi /usr/local/mysql/support-files/mysql.server

basedir=/usr/local/mysql
datadir=/home/mysql

[데이터 디렉토리 생성]
# mkdir /home/mysql;mkdir /var/run/mysqld;

[기본DB설치]
# /usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/home/mysql

[DB 디렉토리에 권한설정]
# chown -R mysql:mysql /home/mysql;chown -R mysql:mysql /var/run/mysqld

[데몬 시작]
# /usr/local/mysql/support-files/mysql.server start

[엔진 설치]

spider 엔진 설치
# /usr/local/mysql/bin/mysql -uroot < /usr/local/mysql/share/install_spider.sql
Handlersocket Plugin 설치
# /usr/local/mysql/bin/mysql -uroot < /usr/local/mysql/share/install_handlersocket.sql

[데몬 내리기]
/usr/local/mysql/support-files/mysql.server stop

[환경설정 추가]
vi /etc/my.cnf
spider_internal_xa=1
spider_semi_trx_isolation=2
spider_use_handler=1
spider_use_hs_read=1
spider_use_hs_write=1

[데몬 시작]
/usr/local/mysql/support-files/mysql.server start

[MySQL INNODB 테이블 생성]
1번서버 192.168.0.101
2번서버 192.168.0.102
위 서버에 각각 테이블 생성
CREATE DATABASE DATA;
CREATE TABLE `spider` (
`id` INT(10) UNSIGNED NOT NULL,
`val` VARCHAR(100) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;"

[SPIDER 엔진이 설치된 MySQL]
192.168.0.201
SPIDER엔진이 설치된 DB에서 계정 생성 후 테이블을 만들어 준다
SPIDER로 해시할 원격지 계정 정보 설정
CREATE SERVER n1 FOREIGN DATA WRAPPER mysql OPTIONS (USER 'spider', PASSWORD 'spider', HOST '192.168.0.101', PORT 3306);
CREATE SERVER n2 FOREIGN DATA WRAPPER mysql OPTIONS (USER 'spider', PASSWORD 'spider', HOST '192.168.0.101', PORT 3306);"

[SPIDER 엔진이 설치된 MySQL에 테이블 생성]
CREATE DATABASE DATA;
CREATE TABLE `spider` (
`id` INT(10) UNSIGNED NOT NULL,
`val` VARCHAR(100) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=SPIDER DEFAULT CHARSET=utf8
PARTITION BY HASH(`id`) (
PARTITION p1 COMMENT 'user "spider", password "spider", host "127.0.0.1", port "3306", table "spider",',
PARTITION p2 COMMENT 'user "spider", password "spider", host "127.0.0.1", port "3306", table "spider",'
);

SQLyog 서버정보 백업하기

2012-05-28T18:33:00.001-07:00

[Windows XP]
C:/Documents and Settings/사용자 아이디/Application Data/프로그램폴더

[Windows 7]
C:/Users/사용자 아이디/AppData/Roaming/프로그램폴더

[EditPlus3]
/EditPlus 3/ftp2_u.ini

[SQLYog]
/SQLyog/sqlyog.ini

[SecureCRT]
/VanDyke/Config/Sessions 하위 디렉토리/파일 전부

[FileZilla]
/FileZilla xml.파일 전부(사이트관리자만 필요할경우 sitemanager.xml)

홍대 칼디

2012-05-20T02:20:00.001-07:00

더치와 홍차라떼
7,000원 / 5,000원

PHP memcached.ini

2012-05-17T00:50:00.000-07:00


[memcached]

extension = memcached.so


; Use session locking

; valid values: On, Off

; the default is On

memcached.sess_locking = On




; Session spin lock retry wait time in microseconds.

; Be carefull when setting this value.

; Valid values are integers, where 0 is interpreted as

; the default value. Negative values result in a reduces

; locking to a try lock.

; the default is 150000

memcached.sess_lock_wait = 150000




; memcached session key prefix

; valid values are strings less than 219 bytes long

; the default value is "memc.sess.key."

memcached.sess_prefix = "memc.sess.key."




; memcached session binary mode

memcached.sess_binary = Off




; Set the compression type

; valid values are: fastlz, zlib

; the default is fastlz

memcached.compression_type = "fastlz"




; Compression factor

; Store compressed value only if the compression

; factor (saving) exceeds the set limit.

;

;  store compressed if:

;    plain_len > comp_len * factor

;

; the default value is 1.3 (23% space saving)

memcached.compression_factor = "1.3"




; The compression threshold

;

; Do not compress serialized values below this threshold.

; the default is 2000 bytes

memcached.compression_threshold = 2000




; Set the default serializer for new memcached objects.

; valid values are: php, igbinary, json, json_array

;

; json - standard php JSON encoding. This serializer

;        is fast and compact but only works on UTF-8

;        encoded data and does not fully implement

;        serializing. See the JSON extension.

; json_array - as json, but decodes into arrays

; php - the standard php serializer

; igbinary - a binary serializer

;

; The default is igbinary if available and php otherwise.

memcached.serializer = "igbinary"

IE9 인터넷 익스플로러9 속도 저하 (랙) 없애기

2012-05-11T01:47:00.002-07:00

인터넷 옵션 -> 고급 -> 가속 그래픽 -> GPU 렌더링 대신 소프트웨어 렌더링 사용*

체크 후 재시작

MySQL 유저생성 및 권한 설정

2012-05-07T20:11:00.001-07:00

# MySQL --> user1 계정에 DB_이름 형태의 DB를 생성하면서 모든 권한을 부여
GRANT ALL PRIVILEGES ON `DB_%`.* TO user1@localhost IDENTIFIED BY 'password' WITH GRANT OPTION;

# 적용
FLUSH PRIVILEGES;

MySQL 함수 만들기 설정

2012-05-07T07:59:00.000-07:00

# 함수 만들기 설정 확인
SHOW GLOBAL VARIABLES LIKE 'log_bin_trust_function_creators';

# 설정 ON
SET GLOBAL log_bin_trust_function_creators='ON';

# 적용
FLUSH PRIVILEGES;