ubuntu 14.04 mysql 설치 및 설정

1. 설치

$ sudo apt-get install mysql-server

2. 설정파일 수정

$ sudo nano /etc/mysql/my.cnf

1. 로그 설정

[mysqld]

general_log_file        = /var/log/mysql/mysql.log

general_log             = 1

log_slow_queries        = /var/log/mysql/mysql-slow.log

long_query_time = 2

2. 케릭터 셋 설정

[mysqld]

collation-server = utf8_unicode_ci

init-connect='SET NAMES utf8'

character-set-server = utf8

[mysql]

default-character-set=utf8

3. 외부접속 허용

[mysqld]

- 아래 부분 주석처리

# bind-address           = 127.0.0.1

4. inno db 설정

innodb_file_per_table = 1

3. 사용자 추가 ( 외부에서 접속하기 위해 )

$ sudo mysql -u root -p

> use mysql;

> grant all privileges on *.* to 'root'@'%' identified by '비밀번호';

> flush privileges;

$ sudo service mysql restart

ubuntu 14.04 php-fpm 설치 및 설정

1. 소스 다운로드

~/src$ wget http://uk1.php.net/get/php-5.6.15.tar.gz/from/this/mirror -O php-5.6.15.tar.gz

~/src$ tar -xvzf php-5.6.15.tar.gz

~/src$ cd php-5.6.15

참조 - https://secure.php.net/get/php-5.6.15.tar.gz/from/a/mirror

2. 의존성 모듈 설치

$ sudo apt-get install build-essential

$ sudo apt-get build-dep php5

$ sudo apt-get install libfcgi-dev libfcgi0ldbl libjpeg62-dbg libmcrypt-dev libssl-dev libc-client2007e libc-client2007e-dev

$ sudo ln -s /usr/lib/libc-client.a /usr/lib/x86_64-linux-gnu/libc-client.a

참조 - https://www.howtoforge.com/how-to-build-php-5.5-php-fpm-and-fastcgi-with-ioncube-loader-zend-opcache-and-apcu-for-ispconfig3-debian-wheezy

3. configure 설정

~/src/php-5.6.15$ ./configure --with-zlib-dir --enable-mbstring --with-libxml-dir --enable-soap --enable-calendar --with-curl --with-mcrypt --with-zlib --with-gd --with-pgsql --disable-rpath --enable-inline-optimization --with-bz2 --with-zlib --enable-sockets --enable-sysvsem --enable-sysvshm --enable-pcntl --enable-mbregex --with-mhash --enable-zip --with-pcre-regex --with-mysql --with-pdo-mysql --with-mysqli --with-jpeg-dir --with-png-dir --with-freetype-dir --enable-gd-native-ttf --with-openssl --with-fpm-user=www-data --with-fpm-group=www-data --with-libdir=/lib/x86_64-linux-gnu --enable-ftp --with-imap --with-imap-ssl --with-kerberos --with-gettext --enable-fpm  

4. 설치

~/src/php-5.6.15$ sudo make install

5. 설정

참조 - http://php.net/manual/en/install.unix.nginx.php

~/src/php-5.6.15$ sudo cp php.ini-development /usr/local/lib/php.ini

~/src/php-5.6.15$ sudo cp /usr/local/etc/php-fpm.conf.default /usr/local/php/php-fpm.conf

~/src/php-5.6.15$ sudo cp sapi/fpm/php-fpm /usr/local/bin/

~/src/php-5.6.15$ sudo cp sapi/fpm/php-fpm /usr/sbin/

설정파일 열어서

~/src/php-5.6.15$ sudo nano /usr/local/php/php.ini

아래처럼 수정

short_open_tag = On

upload_max_filesize = 10M

cgi.fix_pathinfo=0

설정파일 열어서

~/src/php-5.6.15$ sudo nano /usr/local/php/php-fpm.conf

아래처럼 수정

pid = /var/run/php-fpm.pid

listen = /var/run/php5-fpm.sock;

pm.max_children = 100

rlimit_files = 102400

listen.owner = www-data

listen.group = www-data

listen.mode = 0660

로그설정

error_log = /var/log/php/php-fpm.log

access.log = /var/log/php/$pool.access.log

slowlog = /var/log/php/$pool.log.slow

request_slowlog_timeout = 1

php_flag[display_errors] = on

php_admin_value[error_log] = /var/log/php/fpm-php.www.log

php_admin_flag[log_errors] = on

php_admin_value[memory_limit] = 32M

6. php init script

http://starkey1984.blogspot.kr/2015/08/php-fpm.html

$ sudo nano /etc/init.d/php-fpm

php-fpm 안에 링크안의 내용을 붙여넣기

부팅시 자동시작하기 위해서 아래 명령어 실행

/etc/init.d$ sudo update-rc.d php-fpm defaults

ubuntu 14.04 nginx 설치 및 설정

1. 소스 다운로드

~/src$ wget http://nginx.org/download/nginx-1.9.6.tar.gz

~/src$ tar -xvzf nginx-1.9.6.tar.gz

~/src$ cd nginx-1.9.6

참조 - http://nginx.org/en/download.html

2. 의존성 모듈 설치

$ sudo apt-get install gcc libpcre3 libpcre3-dev zlib1g zlib1g-dev libssl-dev build-essential

3. echo 모듈 설치

~/src$ wget https://github.com/openresty/echo-nginx-module/archive/master.zip

~/src$ unzip master.zip

~/src$ mv echo-nginx-module-master echo-nginx-module

참조 - https://github.com/openresty/echo-nginx-module#name

4. configure 설정

~/src/nginx-1.9.6$ ./configure --prefix=/etc/nginx --sbin-path=/usr/sbin/nginx --conf-path=/etc/nginx/nginx.conf --error-log-path=/var/log/nginx/error.log --http-log-path=/var/log/nginx/access.log --pid-path=/var/run/nginx.pid --user=www-data --group=www-data --with-http_ssl_module --add-module=/home/ubuntu/src/echo-nginx-module   

참조 - http://nginx.org/en/docs/configure.html

4. 설치

~/src/nginx-1.9.6$ sudo make install

5. init 스크립트 만들기

참조 - https://www.nginx.com/resources/wiki/start/topics/examples/ubuntuupstart/

6. 실행

$ sudo service nginx start