mysql5.6+php5.4+nginxな環境を作る(インストールのみ)

今までVPS2Gプランを借りていたのですが、ちょっとした家計の事情でより安い1Gプランに移ることにしました。んで。せっかくなのでmysql5.6な環境作りたいな〜っと思いまして、ついでにphpも5.4にして毎回忘れるVDAパッチ済みのpostfixもつくっとこうってことでやりました。
以下いつも通りやったことです。今回はインストール作業のみで設定ファイル編集とかは基本的にやってないです。

環境とインストールしたもの



Minimal Install & ユーザ追加

普通にOSインストールしてユーザ追加です。

1
2
3
4
5
6
7
8

# useradd xxxx
# su - xxxx
$ ssh-keygen -t rsa
$ cat .ssh/id_rsa.pub > .ssh/authorized_keys
$ chmod 400 .ssh/authorized_keys
# sed -ie "s/#PermitRootLogin yes/PermitRootLogin no/" /etc/ssh/sshd_config
# echo -e "AllowUsers\txxxx" >> /etc/ssh/sshd_config
# /etc/init.d/sshd restart


初期設定

とりあえずこまごま設定です。iptablesとかselinuxとかoffってるけど構築途中ということで勘弁！

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

# yum groupinstall "Base"
# yum update
# yum install sudo git
# echo "xxxx ALL=(ALL) NOPASSWD:ALL" > /etc/sudoers.d/xxxx
# chmod 400 /etc/sudoers.d/xxxx
# sed -ie "s/SELINUX=enforcing/SELINUX=disabled/" /etc/selinux/config
# chkconfig iptables off
# chkconfig ip6tables off
# chkconfig cpuspeed off
# echo "NETWORKING_IPV6=no" >> /etc/sysconfig/network
# echo "options ipv6 disable=1" > /etc/modprobe.d/disable-ipv6.conf
# sed -ie 's/NM_CONTROLLED="yes"/NM_CONTROLLED="no"/' /etc/sysconfig/network-scripts/ifcfg-eth0
# echo -e "nameserver 210.157.1.171\nnameserver 8.8.8.8" > /etc/resolv.conf
# sed -ie "s/server 0.centos.pool.ntp.org/server ntp.nict.jp/" /etc/ntp.conf 
# sed -ie "s/server 1.centos.pool.ntp.org/server ntp1.jst.mfeed.ad.jp/" /etc/ntp.conf 
# sed -ie "s/server 2.centos.pool.ntp.org/server ntp2.jst.mfeed.ad.jp/" /etc/ntp.conf
# chkconfig ntpd on
# chkconfig ntpdate on
# su - xxxx
$ vim .vimrc
# reboot
.vimrc
1
2
3
4
5
6
7
8
9
10
11
12
13
14

syntax on
set encoding=utf-8
set fileencoding=utf-8
set fileencodings=utf-8,iso-2022-jp,euc-jp,ucs-2,cp932,sjis
set tabstop=2
set autoindent
set expandtab
set shiftwidth=2
set ignorecase
set showmatch
set showmode
set title
highlight JpSpace cterm=underline ctermfg=darkblue guifg=darkblue
match JpSpace /　/


ここからは項目通りにインストールしていくだけです。

rbenv install

自分の記事まんま(´ω`)
http://blog.youyo.info/blog/2013/01/21/rbenv-all-users/

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

# cd /usr/local/src/
# wget http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm
# rpm -ivh epel-release-6-8.noarch.rpm
# sed -ie "s/enabled=1/enabled=0/" /etc/yum.repos.d/epel.repo
# cd /usr/local/
# git clone git://github.com/sstephenson/rbenv.git rbenv
# mkdir rbenv/{shims,versions}
# git clone git://github.com/sstephenson/ruby-build.git ruby-build
# cd ruby-build/
# ./install.sh
# echo 'export RBENV_ROOT="/usr/local/rbenv"' > /etc/profile.d/rbenv.sh  
# echo 'export PATH="/usr/local/rbenv/bin:$PATH"' >> /etc/profile.d/rbenv.sh  
# echo 'eval "$(rbenv init -)"' >> /etc/profile.d/rbenv.sh  
# . /etc/profile.d/rbenv.sh
# yum install make gcc kernel-devel zlib-devel openssl-devel readline-devel curl-devel sqlite-devel libyaml-devel --enablerepo=epel
# rbenv install 1.9.3-p385
# rbenv global 1.9.3-p385
# rbenv rehash
# gem install bundler


dnsmasq2.48 install

自分の記事まんま2(´ω`)
http://blog.youyo.info/blog/2013/01/24/dnsmasq/

1
2
3
4

sudo yum install dnsmasq
sudo vim /etc/resolv.conf
sudo /etc/init.d/dnsmasq start
sudo chkconfig dnsmasq on
resolv.conf
1
2
3

nameserver 127.0.0.1
nameserver 210.157.1.171
nameserver 8.8.8.8


mysql5.6 install

こちらのサイト様を参考に(´ω`)
http://d.hatena.ne.jp/akishin999/20130207/1360241401

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

sudo mkdir /usr/local/src/mysql5.6/
cd /usr/local/src/mysql5.6/
sudo wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-shared-5.6.10-1.el6.x86_64.rpm/from/http://cdn.mysql.com/
sudo wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-shared-compat-5.6.10-1.el6.x86_64.rpm/from/http://cdn.mysql.com/
sudo wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-server-5.6.10-1.el6.x86_64.rpm/from/http://cdn.mysql.com/
sudo wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-client-5.6.10-1.el6.x86_64.rpm/from/http://cdn.mysql.com/
sudo wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-devel-5.6.10-1.el6.x86_64.rpm/from/http://cdn.mysql.com/
sudo yum localinstall MySQL-*
sudo /etc/init.d/mysql start
mysql -u root -p
mysql> SET PASSWORD FOR root@localhost=PASSWORD('password');
sudo mysql_secure_installation
sudo ln -s /usr/my.cnf /etc/
sudo vim /etc/my.cnf
sudo mkdir /var/run/mysqld
sudo chown mysql /var/run/mysqld/
sudo mkdir /var/log/mysqld
sudo chown mysql:mysql /var/log/mysqld
sudo /etc/init.d/mysql restart
my.cnf
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38

[mysqld]
datadir                 = /var/lib/mysql
socket                  = /var/lib/mysql/mysql.sock
pid-file                = /var/run/mysqld/mysqld.pid
character-set-server    = utf8
skip-character-set-client-handshake

log-error               = /var/log/mysqld/mysqld-error.log
general_log             = 1
general_log_file        = /var/log/mysqld/mysql.log
slow_query_log          = 1
slow_query_log_file     = /var/log/mysqld/slow.log

log-bin                 = mysql-bin
binlog_format           = mixed
expire_logs_days        = 30
server-id               = 1

innodb_file_per_table
innodb_flush_log_at_trx_commit = 0
innodb_flush_method     = O_DIRECT
innodb_buffer_pool_size = 256M
innodb_log_file_size    = 128M
innodb_log_buffer_size  = 8M

query_cache_type        = 1
query_cache_size        = 64M
key_buffer_size         = 32M
sort_buffer_size        = 1M
read_buffer_size        = 1M
read_rnd_buffer_size    = 4M

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[mysqld_safe]
log-error               = /var/log/mysqld/mysqld_safe-error.log
pid-file                = /var/run/mysqld/mysqld.pid
character-set-server    = utf8


php5.4 install

php54.specファイルを少しいじっています(´ω`)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

sudo yum groupinstall "Development tools"
sudo yum install bzip2-devel db4-devel gmp-devel httpd-devel pam-devel libedit-devel libtool-ltdl-devel libc-client-devel cyrus-sasl-devel openldap-devel postgresql-devel unixODBC-devel libxml2-devel firebird-devel net-snmp-devel libxslt-devel libjpeg-devel libpng-devel freetype-devel libXpm-devel t1lib-devel libmcrypt-devel libtidy-devel libtidy-devel freetds-devel aspell-devel recode-devel libicu-devel enchant-devel --enablerepo=epel
sudo useradd rpmdevel
su - root
su - rpmdevel
mkdir -p ~/rpm/{BUILD,SRPMS,SPECS,SOURCES,RPMS}
echo "%_topdir $HOME/rpm" > $HOME/.rpmmacros
mkdir src
cd src/
wget http://rpms.famillecollet.com/SRPMS/php-5.4.11-1.remi.src.rpm
rpm -ivh php-5.4.11-1.remi.src.rpm
cd ../rpm/SPECS/
sed -ie "s/mysql-devel/MySQL-devel/" php54.spec
vim php54.spec
--------------------------
#%global mysql_config %{_libdir}/mysql/mysql_config
%global mysql_config /usr/bin/mysql_config
--------------------------
rpmbuild -v -ba --clean php54.spec
logout
cd /home/rpmdevel/rpm/RPMS/x86_64/
yum localinstall php-5.4.11-1.el6.x86_64.rpm php-cli-5.4.11-1.el6.x86_64.rpm php-common-5.4.11-1.el6.x86_64.rpm php-devel-5.4.11-1.el6.x86_64.rpm php-fpm-5.4.11-1.el6.x86_64.rpm php-gd-5.4.11-1.el6.x86_64.rpm php-mbstring-5.4.11-1.el6.x86_64.rpm php-mcrypt-5.4.11-1.el6.x86_64.rpm php-mysql-5.4.11-1.el6.x86_64.rpm php-pdo-5.4.11-1.el6.x86_64.rpm php-snmp-5.4.11-1.el6.x86_64.rpm php-xml-5.4.11-1.el6.x86_64.rpm php-xmlrpc-5.4.11-1.el6.x86_64.rpm


nginx1.2.6 install

適当にインストール(´ω`)

1
2

sudo vim /etc/yum.repos.d/nginx.repo
sudo yum install nginx --enablerepo=nginx
nginx.repo
1
2
3
4
5

[nginx]
name=nginx repo
baseurl=http://nginx.org/packages/rhel/$releasever/$basearch/
gpgcheck=0
enabled=0


postfix2.9.5+VDAパッチ install

VDAパッチ当てるのとmysql対応させるためにspecファイルいじってます(´ω`)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

sudo yum install pcre-devel
su - rpmdevel
cd src/
wget http://download.imt-systems.com/postfix/2.9.5/x86_64/postfix-2.9.5-1.el6.src.rpm
wget http://vda.sourceforge.net/VDA/postfix-vda-v11-2.9.5.patch
rpm -ivh postfix-2.9.5-1.el6.src.rpm
mv postfix-vda-v11-2.9.5.patch ../rpm/SOURCES/
cd ../rpm/SPECS/
sed -ie "s/%bcond_without mysql/%bcond_with mysql/" postfix.spec
sed -ie "s/mysql-devel/MySQL-devel/" postfix.spec
vim postfix.spec
-------------------
Release: 1_VDA_%{?dist}
Epoch: 3
Patch12: postfix-vda-v11-2.9.5.patch
%patch12 -p1 -b .VDA
-------------------
rpmbuild -v -ba --clean postfix.spec
logout
cd /home/rpmdevel/rpm/RPMS/x86_64/
yum localinstall postfix-2.9.5-1_VDA_.el6.x86_64.rpm


dovecot2.0.9 install

適当にインス(ry

1

sudo yum install dovecot dovecot-mysql


  • インストールだけしました。
  • ちゃんとした設定はあとで。
  • 作成したrpmはなくさないようにあとで公開予定(未定)

置きました！
http://download.youyo.info/Linux/centos/6/x86_64/RPM/

Comments