みんながおすすめのイエローのヤツ。
やばい。
チョー美味かった。
茶碗1膳のご飯とあわせて食べたら、すごく、いい感じだったと報告。
いなばのタイカレーを買っちゃった
昼ご飯を食べながら、たまたま「花子とアン」の総集編を観ましたよ。
ちょっと、おもしろいじゃないですか。
毎日観る気にはならないけれど、ダイジェストで90分はアリですね。
あと、「いなばのタイカレー♪」。
ジャニーズJr.の子の歌が耳について離れな〜い。
というわけで、買ったよ。2個ずつ3種類。
レビューは後日。
いま人形町にはいいタイ料理屋が集まっていて、月に2〜3回はタイカレーを食べてる。
昔はタイ料理、ぜんぜんダメだったんだけどなー。
もっと早く食べれるようになっておきたかったよ。
タイ料理バージンだった俺に、いきなりトムヤンクンを強要したアイツが悪い。
ちょっと、おもしろいじゃないですか。
毎日観る気にはならないけれど、ダイジェストで90分はアリですね。
あと、「いなばのタイカレー♪」。
ジャニーズJr.の子の歌が耳について離れな〜い。
というわけで、買ったよ。2個ずつ3種類。
レビューは後日。
いま人形町にはいいタイ料理屋が集まっていて、月に2〜3回はタイカレーを食べてる。
昔はタイ料理、ぜんぜんダメだったんだけどなー。
もっと早く食べれるようになっておきたかったよ。
タイ料理バージンだった俺に、いきなりトムヤンクンを強要したアイツが悪い。
夏は残り45回
激しい雨が続いた梅雨が今週明けて、暑苦しいヤツがやってきた。
肌にまとわりつく蒸し暑さは本当にうんざりなのだけど。
朝、駅までの7分間、関空から欧州に向かう彼氏と話しながら歩いた。
家を出て、街路樹の陰を伝いながら移動するけれど、すぐに汗ばんでくる。
僕は、暑い、暑いと連呼しながら歩く。
梅雨明けの空を見上げて、ふと、夏はあと45回なんだなあと呟いた。
十歳の子供にとって、45回目の夏は高校生か、大学生の子供を育てている頃だろう。
二十歳の夏を迎える人は、45回目の夏は、定年退職後初の夏かもしれない。
今年三十歳で夏を見上げている人は、45回目の夏は、連れ合いを亡くした静かな季節かもしれないね。
そして僕にとっての45回目の夏は、たぶん、この世で迎えることはないんだろう。
どんな楽観的に考えても、最後の2回は、ガラス窓の向こうから、手を振っている夏をベッドの上から眺めているような気がする。
そんなことをつらつら考えていたら、今年の夏が特別に感じた。
みんな、身体が自由なうちに、夏と遊びに行ってこい。
肌にまとわりつく蒸し暑さは本当にうんざりなのだけど。
朝、駅までの7分間、関空から欧州に向かう彼氏と話しながら歩いた。
家を出て、街路樹の陰を伝いながら移動するけれど、すぐに汗ばんでくる。
僕は、暑い、暑いと連呼しながら歩く。
梅雨明けの空を見上げて、ふと、夏はあと45回なんだなあと呟いた。
十歳の子供にとって、45回目の夏は高校生か、大学生の子供を育てている頃だろう。
二十歳の夏を迎える人は、45回目の夏は、定年退職後初の夏かもしれない。
今年三十歳で夏を見上げている人は、45回目の夏は、連れ合いを亡くした静かな季節かもしれないね。
そして僕にとっての45回目の夏は、たぶん、この世で迎えることはないんだろう。
どんな楽観的に考えても、最後の2回は、ガラス窓の向こうから、手を振っている夏をベッドの上から眺めているような気がする。
そんなことをつらつら考えていたら、今年の夏が特別に感じた。
みんな、身体が自由なうちに、夏と遊びに行ってこい。
で、MroongaはDBエンジンとして奉職しているのかというと。
調べてみよう。
mysql> show engines;
+--------------------+---------+----------------------------------------------------------------+
| Engine | Support | Comment +--------------------+---------+----------------------------------------------------------------
MEMORY | YES | Hash based, stored in memory, useful for temporary tables |
MRG_MYISAM | YES | Collection of identical MyISAM tables |
CSV | YES | CSV storage engine |
BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) |
MyISAM | YES | MyISAM storage engine |
InnoDB | DEFAULT | Supports transactions, row-level locking, and foreign keys |
mroonga | YES | CJK-ready fulltext search, column store |
FEDERATED | NO | Federated MySQL storage engine |
PERFORMANCE_SCHEMA | YES | Performance Schema |
ARCHIVE | YES | Archive storage engine |
+--------------------+---------+----------------------------------------------------------------
10 rows in set (0.00 sec)
ちゃんといるね。
mysql> show engines;
+--------------------+---------+----------------------------------------------------------------+
| Engine | Support | Comment +--------------------+---------+----------------------------------------------------------------
MEMORY | YES | Hash based, stored in memory, useful for temporary tables |
MRG_MYISAM | YES | Collection of identical MyISAM tables |
CSV | YES | CSV storage engine |
BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) |
MyISAM | YES | MyISAM storage engine |
InnoDB | DEFAULT | Supports transactions, row-level locking, and foreign keys |
mroonga | YES | CJK-ready fulltext search, column store |
FEDERATED | NO | Federated MySQL storage engine |
PERFORMANCE_SCHEMA | YES | Performance Schema |
ARCHIVE | YES | Archive storage engine |
+--------------------+---------+----------------------------------------------------------------
10 rows in set (0.00 sec)
ちゃんといるね。
CentOS6.5でGroongaを利用するため、MySQL5.5インストールからやり直し。
Mroonga、Rroongaをインストールするために、MySQL5シリーズをインストールしようとしたんだけど、最新版だと弾かれてしまう。結局、Mroongaのインストール手順に書いてあったやり方にしたがって、MySQL5からインストールするのが一番の近道だった。ちょっと泣きたい気分。orz
手順を残しておく。
最初の作業。
# yum install centos-release-SCL
Loaded plugins: fastestmirror, refresh-packagekit, security
Determining fastest mirrors
* base: www.ftp.ne.jp
* extras: www.ftp.ne.jp
* updates: www.ftp.ne.jp
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package centos-release-SCL.x86_64 10:6-5.el6.centos will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
centos-release-SCL x86_64 10:6-5.el6.centos extras 3.9 k
Transaction Summary
================================================================================
Install 1 Package(s)
Total download size: 3.9 k
Installed size: 453
Is this ok [y/N]: y
Downloading Packages:
centos-release-SCL-6-5.el6.centos.x86_64.rpm | 3.9 kB 00:00
警告: rpmts_HdrFromFdno: ヘッダ V3 RSA/SHA1 Signature, key ID c105b9de: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6
Importing GPG key 0xC105B9DE:
Userid : CentOS-6 Key (CentOS 6 Official Signing Key)
Package: centos-release-6-5.el6.centos.11.1.x86_64 (@anaconda-CentOS-201311272149.x86_64/6.5)
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6
Is this ok [y/N]: y
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : 10:centos-release-SCL-6-5.el6.centos.x86_64 1/1
Verifying : 10:centos-release-SCL-6-5.el6.centos.x86_64 1/1
Installed:
centos-release-SCL.x86_64 10:6-5.el6.centos
Complete!
次の作業。
# rpm -ivh http://packages.groonga.org/centos/groonga-release-1.1.0-1.noarch.rpm
http://packages.groonga.org/centos/groonga-release-1.1.0-1.noarch.rpm を取得中
警告: /var/tmp/rpm-tmp.2F4WFq: ヘッダ V4 DSA/SHA1 Signature, key ID 45499429: NOKEY
準備中... ########################################### [100%]
1:groonga-release ########################################### [100%]
[root@centos6 ruby_on_rails]# yum makecache
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
* base: www.ftp.ne.jp
* extras: www.ftp.ne.jp
* updates: www.ftp.ne.jp
base | 3.7 kB 00:00
base/filelists_db | 5.9 MB 00:06
base/other_db | 2.8 MB 00:02
extras | 3.4 kB 00:00
extras/filelists_db | 11 kB 00:00
extras/prestodelta | 907 B 00:00
extras/other_db | 5.8 kB 00:00
groonga | 2.5 kB 00:00
groonga/filelists_db | 172 kB 00:00
groonga/primary_db | 139 kB 00:00
groonga/other_db | 160 kB 00:00
scl | 2.9 kB 00:00
scl/filelists_db | 1.2 MB 00:02
scl/other_db | 711 kB 00:01
updates | 3.4 kB 00:00
updates/filelists_db | 2.3 MB 00:02
updates/prestodelta | 365 kB 00:00
Metadata Cache Created
では、MySQL5をインストールする。
# yum install -y mysql55-mysql-server
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
* base: www.ftp.ne.jp
* extras: www.ftp.ne.jp
* updates: www.ftp.ne.jp
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql55-mysql-server.x86_64 0:5.5.37-1.2.el6.centos.alt will be installed
--> Processing Dependency: mysql55-mysql-libs(x86-64) = 5.5.37-1.2.el6.centos.alt for package: mysql55-mysql-server-5.5.37-1.2.el6.centos.alt.x86_64
--> Processing Dependency: mysql55-mysql(x86-64) = 5.5.37-1.2.el6.centos.alt for package: mysql55-mysql-server-5.5.37-1.2.el6.centos.alt.x86_64
--> Processing Dependency: perl-DBD-MySQL for package: mysql55-mysql-server-5.5.37-1.2.el6.centos.alt.x86_64
--> Processing Dependency: mysql55-runtime for package: mysql55-mysql-server-5.5.37-1.2.el6.centos.alt.x86_64
--> Running transaction check
---> Package mysql55-mysql.x86_64 0:5.5.37-1.2.el6.centos.alt will be installed
---> Package mysql55-mysql-libs.x86_64 0:5.5.37-1.2.el6.centos.alt will be installed
---> Package mysql55-runtime.x86_64 0:1-14.el6.centos.alt will be installed
--> Processing Dependency: policycoreutils-python for package: mysql55-runtime-1-14.el6.centos.alt.x86_64
---> Package perl-DBD-MySQL.x86_64 0:4.013-3.el6 will be installed
--> Running transaction check
---> Package policycoreutils-python.x86_64 0:2.0.83-19.39.el6 will be installed
--> Processing Dependency: libsemanage-python >= 2.0.43-4 for package: policycoreutils-python-2.0.83-19.39.el6.x86_64
--> Processing Dependency: audit-libs-python >= 1.4.2-1 for package: policycoreutils-python-2.0.83-19.39.el6.x86_64
--> Processing Dependency: setools-libs-python for package: policycoreutils-python-2.0.83-19.39.el6.x86_64
--> Running transaction check
---> Package audit-libs-python.x86_64 0:2.2-4.el6_5 will be installed
--> Processing Dependency: audit-libs = 2.2-4.el6_5 for package: audit-libs-python-2.2-4.el6_5.x86_64
---> Package libsemanage-python.x86_64 0:2.0.43-4.2.el6 will be installed
---> Package setools-libs-python.x86_64 0:3.3.7-4.el6 will be installed
--> Processing Dependency: setools-libs = 3.3.7-4.el6 for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libsefs.so.4(VERS_4.0)(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libseaudit.so.4(VERS_4.2)(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libseaudit.so.4(VERS_4.1)(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libqpol.so.1(VERS_1.4)(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libqpol.so.1(VERS_1.3)(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libqpol.so.1(VERS_1.2)(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libpoldiff.so.1(VERS_1.3)(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libpoldiff.so.1(VERS_1.2)(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libapol.so.4(VERS_4.1)(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libapol.so.4(VERS_4.0)(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libsefs.so.4()(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libseaudit.so.4()(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libqpol.so.1()(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libpoldiff.so.1()(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libapol.so.4()(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Running transaction check
---> Package audit-libs.x86_64 0:2.2-2.el6 will be updated
--> Processing Dependency: audit-libs = 2.2-2.el6 for package: audit-2.2-2.el6.x86_64
---> Package audit-libs.x86_64 0:2.2-4.el6_5 will be an update
---> Package setools-libs.x86_64 0:3.3.7-4.el6 will be installed
--> Running transaction check
---> Package audit.x86_64 0:2.2-2.el6 will be updated
---> Package audit.x86_64 0:2.2-4.el6_5 will be an update
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository
Size
================================================================================
Installing:
mysql55-mysql-server x86_64 5.5.37-1.2.el6.centos.alt scl 10 M
Installing for dependencies:
audit-libs-python x86_64 2.2-4.el6_5 updates 59 k
libsemanage-python x86_64 2.0.43-4.2.el6 base 81 k
mysql55-mysql x86_64 5.5.37-1.2.el6.centos.alt scl 5.7 M
mysql55-mysql-libs x86_64 5.5.37-1.2.el6.centos.alt scl 217 k
mysql55-runtime x86_64 1-14.el6.centos.alt scl 1.0 M
perl-DBD-MySQL x86_64 4.013-3.el6 base 134 k
policycoreutils-python x86_64 2.0.83-19.39.el6 base 343 k
setools-libs x86_64 3.3.7-4.el6 base 400 k
setools-libs-python x86_64 3.3.7-4.el6 base 222 k
Updating for dependencies:
audit x86_64 2.2-4.el6_5 updates 225 k
audit-libs x86_64 2.2-4.el6_5 updates 60 k
Transaction Summary
================================================================================
Install 10 Package(s)
Upgrade 2 Package(s)
Total download size: 19 M
Downloading Packages:
(1/12): audit-2.2-4.el6_5.x86_64.rpm | 225 kB 00:00
(2/12): audit-libs-2.2-4.el6_5.x86_64.rpm | 60 kB 00:00
(3/12): audit-libs-python-2.2-4.el6_5.x86_64.rpm | 59 kB 00:00
(4/12): libsemanage-python-2.0.43-4.2.el6.x86_64.rpm | 81 kB 00:00
(5/12): mysql55-mysql-5.5.37-1.2.el6.centos.alt.x86_64.r | 5.7 MB 00:13
(6/12): mysql55-mysql-libs-5.5.37-1.2.el6.centos.alt.x86 | 217 kB 00:01
(7/12): mysql55-mysql-server-5.5.37-1.2.el6.centos.alt.x | 10 MB 00:17
(8/12): mysql55-runtime-1-14.el6.centos.alt.x86_64.rpm | 1.0 MB 00:01
(9/12): perl-DBD-MySQL-4.013-3.el6.x86_64.rpm | 134 kB 00:00
(10/12): policycoreutils-python-2.0.83-19.39.el6.x86_64. | 343 kB 00:00
(11/12): setools-libs-3.3.7-4.el6.x86_64.rpm | 400 kB 00:00
(12/12): setools-libs-python-3.3.7-4.el6.x86_64.rpm | 222 kB 00:00
--------------------------------------------------------------------------------
Total 448 kB/s | 19 MB 00:42
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
Updating : audit-libs-2.2-4.el6_5.x86_64 1/14
Installing : audit-libs-python-2.2-4.el6_5.x86_64 2/14
Installing : setools-libs-3.3.7-4.el6.x86_64 3/14
Installing : setools-libs-python-3.3.7-4.el6.x86_64 4/14
Installing : perl-DBD-MySQL-4.013-3.el6.x86_64 5/14
Installing : libsemanage-python-2.0.43-4.2.el6.x86_64 6/14
Installing : policycoreutils-python-2.0.83-19.39.el6.x86_64 7/14
Installing : mysql55-runtime-1-14.el6.centos.alt.x86_64 8/14
Installing : mysql55-mysql-libs-5.5.37-1.2.el6.centos.alt.x86_64 9/14
Installing : mysql55-mysql-5.5.37-1.2.el6.centos.alt.x86_64 10/14
Installing : mysql55-mysql-server-5.5.37-1.2.el6.centos.alt.x86_64 11/14
Updating : audit-2.2-4.el6_5.x86_64 12/14
Cleanup : audit-2.2-2.el6.x86_64 13/14
Cleanup : audit-libs-2.2-2.el6.x86_64 14/14
Verifying : libsemanage-python-2.0.43-4.2.el6.x86_64 1/14
Verifying : mysql55-runtime-1-14.el6.centos.alt.x86_64 2/14
Verifying : perl-DBD-MySQL-4.013-3.el6.x86_64 3/14
Verifying : audit-libs-python-2.2-4.el6_5.x86_64 4/14
Verifying : setools-libs-python-3.3.7-4.el6.x86_64 5/14
Verifying : mysql55-mysql-5.5.37-1.2.el6.centos.alt.x86_64 6/14
Verifying : audit-libs-2.2-4.el6_5.x86_64 7/14
Verifying : policycoreutils-python-2.0.83-19.39.el6.x86_64 8/14
Verifying : mysql55-mysql-server-5.5.37-1.2.el6.centos.alt.x86_64 9/14
Verifying : audit-2.2-4.el6_5.x86_64 10/14
Verifying : setools-libs-3.3.7-4.el6.x86_64 11/14
Verifying : mysql55-mysql-libs-5.5.37-1.2.el6.centos.alt.x86_64 12/14
Verifying : audit-libs-2.2-2.el6.x86_64 13/14
Verifying : audit-2.2-2.el6.x86_64 14/14
Installed:
mysql55-mysql-server.x86_64 0:5.5.37-1.2.el6.centos.alt
Dependency Installed:
audit-libs-python.x86_64 0:2.2-4.el6_5
libsemanage-python.x86_64 0:2.0.43-4.2.el6
mysql55-mysql.x86_64 0:5.5.37-1.2.el6.centos.alt
mysql55-mysql-libs.x86_64 0:5.5.37-1.2.el6.centos.alt
mysql55-runtime.x86_64 0:1-14.el6.centos.alt
perl-DBD-MySQL.x86_64 0:4.013-3.el6
policycoreutils-python.x86_64 0:2.0.83-19.39.el6
setools-libs.x86_64 0:3.3.7-4.el6
setools-libs-python.x86_64 0:3.3.7-4.el6
Dependency Updated:
audit.x86_64 0:2.2-4.el6_5 audit-libs.x86_64 0:2.2-4.el6_5
Complete!
インストールが終わったので、MySQLを起動する。
# /etc/init.d/mysql55-mysqld start
MySQL データベースを初期化中: WARNING: The host 'centos6' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !
Installing MySQL system tables...
OK
Filling help tables...
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/opt/rh/mysql55/root/usr/bin/mysqladmin -u root password 'new-password'
/opt/rh/mysql55/root/usr/bin/mysqladmin -u root -h centos6 password 'new-password'
Alternatively you can run:
/opt/rh/mysql55/root/usr/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the manual for more instructions.
You can start the MySQL daemon with:
cd /opt/rh/mysql55/root/usr ; /opt/rh/mysql55/root/usr/bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
cd /opt/rh/mysql55/root/usr/mysql-test ; perl mysql-test-run.pl
Please report any problems at http://bugs.mysql.com/
[ OK ]
mysql55-mysqld を起動中: [ OK ]
その後、トラブル発生。
★MySQL5が起動しない問題の対応。
リブート後にMySQL5が起動しなかった時のトラブルシュート。
$ mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
このエラーが出た場合は、いろいろの可能性が考えられる。
原因を探ると、MySQLが起動していない可能性が。
$ chkconfig --list | grep mysql
mysql55-mysqld 0:off 1:off 2:off 3:off 4:off 5:off 6:off
あかん…… ほんとうに動いてないぞっと。
# chkconfig mysqld on
サービス mysql に関する情報の読み込み中にエラーが発生しました: そのようなファイルやディレクトリはありません
ん????なんで???
ノーマルのMySQLとはちょっと違うのかな??
# chkconfig mysql55-mysqld on
# chkconfig --list | grep mysql
mysql55-mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off
今度は大丈夫そう。リブートして確認してみる。
大丈夫、ちゃんと動いてる。
続いて、Mroongaをインストールする。
# yum install -y mysql55-mroonga
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
* base: www.ftp.ne.jp
* extras: www.ftp.ne.jp
* updates: www.ftp.ne.jp
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql55-mroonga.x86_64 0:4.03-2.el6 will be installed
--> Processing Dependency: groonga-libs >= 4.0.0 for package: mysql55-mroonga-4.03-2.el6.x86_64
--> Processing Dependency: groonga-normalizer-mysql for package: mysql55-mroonga-4.03-2.el6.x86_64
--> Processing Dependency: libgroonga.so.0()(64bit) for package: mysql55-mroonga-4.03-2.el6.x86_64
--> Running transaction check
---> Package groonga-libs.x86_64 0:4.0.3-1.el6 will be installed
---> Package groonga-normalizer-mysql.x86_64 0:1.0.6-1.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
mysql55-mroonga x86_64 4.03-2.el6 groonga 173 k
Installing for dependencies:
groonga-libs x86_64 4.0.3-1.el6 groonga 1.0 M
groonga-normalizer-mysql x86_64 1.0.6-1.el6 groonga 63 k
Transaction Summary
================================================================================
Install 3 Package(s)
Total download size: 1.2 M
Installed size: 3.9 M
Downloading Packages:
(1/3): groonga-libs-4.0.3-1.el6.x86_64.rpm | 1.0 MB 00:01
(2/3): groonga-normalizer-mysql-1.0.6-1.el6.x86_64.rpm | 63 kB 00:00
(3/3): mysql55-mroonga-4.03-2.el6.x86_64.rpm | 173 kB 00:00
--------------------------------------------------------------------------------
Total 790 kB/s | 1.2 MB 00:01
警告: rpmts_HdrFromFdno: ヘッダ V4 DSA/SHA1 Signature, key ID 45499429: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-groonga
Importing GPG key 0x45499429:
Userid : groonga Key (groonga Official Signing Key)
Package: groonga-release-1.1.0-1.noarch (installed)
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-groonga
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : groonga-libs-4.0.3-1.el6.x86_64 1/3
Installing : groonga-normalizer-mysql-1.0.6-1.el6.x86_64 2/3
Installing : mysql55-mroonga-4.03-2.el6.x86_64 3/3
/opt/rh/mysql55/root/usr/bin/mysql -u root < /opt/rh/mysql55/root/usr/share/mroonga/install.sql
Verifying : groonga-normalizer-mysql-1.0.6-1.el6.x86_64 1/3
Verifying : groonga-libs-4.0.3-1.el6.x86_64 2/3
Verifying : mysql55-mroonga-4.03-2.el6.x86_64 3/3
Installed:
mysql55-mroonga.x86_64 0:4.03-2.el6
Dependency Installed:
groonga-libs.x86_64 0:4.0.3-1.el6
groonga-normalizer-mysql.x86_64 0:1.0.6-1.el6
Complete!
トークナイザーにMeCabを使うので、インストールしておく。
# yum install -y groonga-tokenizer-mecab
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
* base: www.ftp.ne.jp
* extras: www.ftp.ne.jp
* updates: www.ftp.ne.jp
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package groonga-tokenizer-mecab.x86_64 0:4.0.3-1.el6 will be installed
--> Processing Dependency: mecab-dic for package: groonga-tokenizer-mecab-4.0.3-1.el6.x86_64
--> Processing Dependency: libmecab.so.2()(64bit) for package: groonga-tokenizer-mecab-4.0.3-1.el6.x86_64
--> Running transaction check
---> Package mecab.x86_64 0:0.996-1.el6 will be installed
---> Package mecab-ipadic.x86_64 0:2.7.0.20070801-8.el6.1 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository
Size
================================================================================
Installing:
groonga-tokenizer-mecab x86_64 4.0.3-1.el6 groonga 12 k
Installing for dependencies:
mecab x86_64 0.996-1.el6 groonga 2.3 M
mecab-ipadic x86_64 2.7.0.20070801-8.el6.1 groonga 13 M
Transaction Summary
================================================================================
Install 3 Package(s)
Total download size: 15 M
Installed size: 63 M
Downloading Packages:
(1/3): groonga-tokenizer-mecab-4.0.3-1.el6.x86_64.rpm | 12 kB 00:00
(2/3): mecab-0.996-1.el6.x86_64.rpm | 2.3 MB 00:02
(3/3): mecab-ipadic-2.7.0.20070801-8.el6.1.x86_64.rpm | 13 MB 00:14
--------------------------------------------------------------------------------
Total 698 kB/s | 15 MB 00:22
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : mecab-0.996-1.el6.x86_64 1/3
Installing : mecab-ipadic-2.7.0.20070801-8.el6.1.x86_64 2/3
Installing : groonga-tokenizer-mecab-4.0.3-1.el6.x86_64 3/3
Verifying : mecab-0.996-1.el6.x86_64 1/3
Verifying : mecab-ipadic-2.7.0.20070801-8.el6.1.x86_64 2/3
Verifying : groonga-tokenizer-mecab-4.0.3-1.el6.x86_64 3/3
Installed:
groonga-tokenizer-mecab.x86_64 0:4.0.3-1.el6
Dependency Installed:
mecab.x86_64 0:0.996-1.el6 mecab-ipadic.x86_64 0:2.7.0.20070801-8.el6.1
Complete!
途中にいろいろトラブルはあったけれど、とにかく、なんとかインストールは終わったようだ。
MySQL5のrootパスワードは変えておかねば｡
$ mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.5.37 MySQL Community Server (GPL)
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> SET PASSWORD for root@localhost=PASSWORD('hogehoge');
Query OK, 0 rows affected (0.00 sec)
やっとここまで戻って来れた。
3歩進んで10歩下がった感じか。。。
手順を残しておく。
最初の作業。
# yum install centos-release-SCL
Loaded plugins: fastestmirror, refresh-packagekit, security
Determining fastest mirrors
* base: www.ftp.ne.jp
* extras: www.ftp.ne.jp
* updates: www.ftp.ne.jp
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package centos-release-SCL.x86_64 10:6-5.el6.centos will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
centos-release-SCL x86_64 10:6-5.el6.centos extras 3.9 k
Transaction Summary
================================================================================
Install 1 Package(s)
Total download size: 3.9 k
Installed size: 453
Is this ok [y/N]: y
Downloading Packages:
centos-release-SCL-6-5.el6.centos.x86_64.rpm | 3.9 kB 00:00
警告: rpmts_HdrFromFdno: ヘッダ V3 RSA/SHA1 Signature, key ID c105b9de: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6
Importing GPG key 0xC105B9DE:
Userid : CentOS-6 Key (CentOS 6 Official Signing Key)
Package: centos-release-6-5.el6.centos.11.1.x86_64 (@anaconda-CentOS-201311272149.x86_64/6.5)
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6
Is this ok [y/N]: y
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : 10:centos-release-SCL-6-5.el6.centos.x86_64 1/1
Verifying : 10:centos-release-SCL-6-5.el6.centos.x86_64 1/1
Installed:
centos-release-SCL.x86_64 10:6-5.el6.centos
Complete!
次の作業。
# rpm -ivh http://packages.groonga.org/centos/groonga-release-1.1.0-1.noarch.rpm
http://packages.groonga.org/centos/groonga-release-1.1.0-1.noarch.rpm を取得中
警告: /var/tmp/rpm-tmp.2F4WFq: ヘッダ V4 DSA/SHA1 Signature, key ID 45499429: NOKEY
準備中... ########################################### [100%]
1:groonga-release ########################################### [100%]
[root@centos6 ruby_on_rails]# yum makecache
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
* base: www.ftp.ne.jp
* extras: www.ftp.ne.jp
* updates: www.ftp.ne.jp
base | 3.7 kB 00:00
base/filelists_db | 5.9 MB 00:06
base/other_db | 2.8 MB 00:02
extras | 3.4 kB 00:00
extras/filelists_db | 11 kB 00:00
extras/prestodelta | 907 B 00:00
extras/other_db | 5.8 kB 00:00
groonga | 2.5 kB 00:00
groonga/filelists_db | 172 kB 00:00
groonga/primary_db | 139 kB 00:00
groonga/other_db | 160 kB 00:00
scl | 2.9 kB 00:00
scl/filelists_db | 1.2 MB 00:02
scl/other_db | 711 kB 00:01
updates | 3.4 kB 00:00
updates/filelists_db | 2.3 MB 00:02
updates/prestodelta | 365 kB 00:00
Metadata Cache Created
では、MySQL5をインストールする。
# yum install -y mysql55-mysql-server
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
* base: www.ftp.ne.jp
* extras: www.ftp.ne.jp
* updates: www.ftp.ne.jp
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql55-mysql-server.x86_64 0:5.5.37-1.2.el6.centos.alt will be installed
--> Processing Dependency: mysql55-mysql-libs(x86-64) = 5.5.37-1.2.el6.centos.alt for package: mysql55-mysql-server-5.5.37-1.2.el6.centos.alt.x86_64
--> Processing Dependency: mysql55-mysql(x86-64) = 5.5.37-1.2.el6.centos.alt for package: mysql55-mysql-server-5.5.37-1.2.el6.centos.alt.x86_64
--> Processing Dependency: perl-DBD-MySQL for package: mysql55-mysql-server-5.5.37-1.2.el6.centos.alt.x86_64
--> Processing Dependency: mysql55-runtime for package: mysql55-mysql-server-5.5.37-1.2.el6.centos.alt.x86_64
--> Running transaction check
---> Package mysql55-mysql.x86_64 0:5.5.37-1.2.el6.centos.alt will be installed
---> Package mysql55-mysql-libs.x86_64 0:5.5.37-1.2.el6.centos.alt will be installed
---> Package mysql55-runtime.x86_64 0:1-14.el6.centos.alt will be installed
--> Processing Dependency: policycoreutils-python for package: mysql55-runtime-1-14.el6.centos.alt.x86_64
---> Package perl-DBD-MySQL.x86_64 0:4.013-3.el6 will be installed
--> Running transaction check
---> Package policycoreutils-python.x86_64 0:2.0.83-19.39.el6 will be installed
--> Processing Dependency: libsemanage-python >= 2.0.43-4 for package: policycoreutils-python-2.0.83-19.39.el6.x86_64
--> Processing Dependency: audit-libs-python >= 1.4.2-1 for package: policycoreutils-python-2.0.83-19.39.el6.x86_64
--> Processing Dependency: setools-libs-python for package: policycoreutils-python-2.0.83-19.39.el6.x86_64
--> Running transaction check
---> Package audit-libs-python.x86_64 0:2.2-4.el6_5 will be installed
--> Processing Dependency: audit-libs = 2.2-4.el6_5 for package: audit-libs-python-2.2-4.el6_5.x86_64
---> Package libsemanage-python.x86_64 0:2.0.43-4.2.el6 will be installed
---> Package setools-libs-python.x86_64 0:3.3.7-4.el6 will be installed
--> Processing Dependency: setools-libs = 3.3.7-4.el6 for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libsefs.so.4(VERS_4.0)(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libseaudit.so.4(VERS_4.2)(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libseaudit.so.4(VERS_4.1)(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libqpol.so.1(VERS_1.4)(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libqpol.so.1(VERS_1.3)(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libqpol.so.1(VERS_1.2)(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libpoldiff.so.1(VERS_1.3)(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libpoldiff.so.1(VERS_1.2)(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libapol.so.4(VERS_4.1)(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libapol.so.4(VERS_4.0)(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libsefs.so.4()(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libseaudit.so.4()(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libqpol.so.1()(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libpoldiff.so.1()(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libapol.so.4()(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Running transaction check
---> Package audit-libs.x86_64 0:2.2-2.el6 will be updated
--> Processing Dependency: audit-libs = 2.2-2.el6 for package: audit-2.2-2.el6.x86_64
---> Package audit-libs.x86_64 0:2.2-4.el6_5 will be an update
---> Package setools-libs.x86_64 0:3.3.7-4.el6 will be installed
--> Running transaction check
---> Package audit.x86_64 0:2.2-2.el6 will be updated
---> Package audit.x86_64 0:2.2-4.el6_5 will be an update
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository
Size
================================================================================
Installing:
mysql55-mysql-server x86_64 5.5.37-1.2.el6.centos.alt scl 10 M
Installing for dependencies:
audit-libs-python x86_64 2.2-4.el6_5 updates 59 k
libsemanage-python x86_64 2.0.43-4.2.el6 base 81 k
mysql55-mysql x86_64 5.5.37-1.2.el6.centos.alt scl 5.7 M
mysql55-mysql-libs x86_64 5.5.37-1.2.el6.centos.alt scl 217 k
mysql55-runtime x86_64 1-14.el6.centos.alt scl 1.0 M
perl-DBD-MySQL x86_64 4.013-3.el6 base 134 k
policycoreutils-python x86_64 2.0.83-19.39.el6 base 343 k
setools-libs x86_64 3.3.7-4.el6 base 400 k
setools-libs-python x86_64 3.3.7-4.el6 base 222 k
Updating for dependencies:
audit x86_64 2.2-4.el6_5 updates 225 k
audit-libs x86_64 2.2-4.el6_5 updates 60 k
Transaction Summary
================================================================================
Install 10 Package(s)
Upgrade 2 Package(s)
Total download size: 19 M
Downloading Packages:
(1/12): audit-2.2-4.el6_5.x86_64.rpm | 225 kB 00:00
(2/12): audit-libs-2.2-4.el6_5.x86_64.rpm | 60 kB 00:00
(3/12): audit-libs-python-2.2-4.el6_5.x86_64.rpm | 59 kB 00:00
(4/12): libsemanage-python-2.0.43-4.2.el6.x86_64.rpm | 81 kB 00:00
(5/12): mysql55-mysql-5.5.37-1.2.el6.centos.alt.x86_64.r | 5.7 MB 00:13
(6/12): mysql55-mysql-libs-5.5.37-1.2.el6.centos.alt.x86 | 217 kB 00:01
(7/12): mysql55-mysql-server-5.5.37-1.2.el6.centos.alt.x | 10 MB 00:17
(8/12): mysql55-runtime-1-14.el6.centos.alt.x86_64.rpm | 1.0 MB 00:01
(9/12): perl-DBD-MySQL-4.013-3.el6.x86_64.rpm | 134 kB 00:00
(10/12): policycoreutils-python-2.0.83-19.39.el6.x86_64. | 343 kB 00:00
(11/12): setools-libs-3.3.7-4.el6.x86_64.rpm | 400 kB 00:00
(12/12): setools-libs-python-3.3.7-4.el6.x86_64.rpm | 222 kB 00:00
--------------------------------------------------------------------------------
Total 448 kB/s | 19 MB 00:42
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
Updating : audit-libs-2.2-4.el6_5.x86_64 1/14
Installing : audit-libs-python-2.2-4.el6_5.x86_64 2/14
Installing : setools-libs-3.3.7-4.el6.x86_64 3/14
Installing : setools-libs-python-3.3.7-4.el6.x86_64 4/14
Installing : perl-DBD-MySQL-4.013-3.el6.x86_64 5/14
Installing : libsemanage-python-2.0.43-4.2.el6.x86_64 6/14
Installing : policycoreutils-python-2.0.83-19.39.el6.x86_64 7/14
Installing : mysql55-runtime-1-14.el6.centos.alt.x86_64 8/14
Installing : mysql55-mysql-libs-5.5.37-1.2.el6.centos.alt.x86_64 9/14
Installing : mysql55-mysql-5.5.37-1.2.el6.centos.alt.x86_64 10/14
Installing : mysql55-mysql-server-5.5.37-1.2.el6.centos.alt.x86_64 11/14
Updating : audit-2.2-4.el6_5.x86_64 12/14
Cleanup : audit-2.2-2.el6.x86_64 13/14
Cleanup : audit-libs-2.2-2.el6.x86_64 14/14
Verifying : libsemanage-python-2.0.43-4.2.el6.x86_64 1/14
Verifying : mysql55-runtime-1-14.el6.centos.alt.x86_64 2/14
Verifying : perl-DBD-MySQL-4.013-3.el6.x86_64 3/14
Verifying : audit-libs-python-2.2-4.el6_5.x86_64 4/14
Verifying : setools-libs-python-3.3.7-4.el6.x86_64 5/14
Verifying : mysql55-mysql-5.5.37-1.2.el6.centos.alt.x86_64 6/14
Verifying : audit-libs-2.2-4.el6_5.x86_64 7/14
Verifying : policycoreutils-python-2.0.83-19.39.el6.x86_64 8/14
Verifying : mysql55-mysql-server-5.5.37-1.2.el6.centos.alt.x86_64 9/14
Verifying : audit-2.2-4.el6_5.x86_64 10/14
Verifying : setools-libs-3.3.7-4.el6.x86_64 11/14
Verifying : mysql55-mysql-libs-5.5.37-1.2.el6.centos.alt.x86_64 12/14
Verifying : audit-libs-2.2-2.el6.x86_64 13/14
Verifying : audit-2.2-2.el6.x86_64 14/14
Installed:
mysql55-mysql-server.x86_64 0:5.5.37-1.2.el6.centos.alt
Dependency Installed:
audit-libs-python.x86_64 0:2.2-4.el6_5
libsemanage-python.x86_64 0:2.0.43-4.2.el6
mysql55-mysql.x86_64 0:5.5.37-1.2.el6.centos.alt
mysql55-mysql-libs.x86_64 0:5.5.37-1.2.el6.centos.alt
mysql55-runtime.x86_64 0:1-14.el6.centos.alt
perl-DBD-MySQL.x86_64 0:4.013-3.el6
policycoreutils-python.x86_64 0:2.0.83-19.39.el6
setools-libs.x86_64 0:3.3.7-4.el6
setools-libs-python.x86_64 0:3.3.7-4.el6
Dependency Updated:
audit.x86_64 0:2.2-4.el6_5 audit-libs.x86_64 0:2.2-4.el6_5
Complete!
インストールが終わったので、MySQLを起動する。
# /etc/init.d/mysql55-mysqld start
MySQL データベースを初期化中: WARNING: The host 'centos6' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !
Installing MySQL system tables...
OK
Filling help tables...
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/opt/rh/mysql55/root/usr/bin/mysqladmin -u root password 'new-password'
/opt/rh/mysql55/root/usr/bin/mysqladmin -u root -h centos6 password 'new-password'
Alternatively you can run:
/opt/rh/mysql55/root/usr/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the manual for more instructions.
You can start the MySQL daemon with:
cd /opt/rh/mysql55/root/usr ; /opt/rh/mysql55/root/usr/bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
cd /opt/rh/mysql55/root/usr/mysql-test ; perl mysql-test-run.pl
Please report any problems at http://bugs.mysql.com/
[ OK ]
mysql55-mysqld を起動中: [ OK ]
その後、トラブル発生。
★MySQL5が起動しない問題の対応。
リブート後にMySQL5が起動しなかった時のトラブルシュート。
$ mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
このエラーが出た場合は、いろいろの可能性が考えられる。
原因を探ると、MySQLが起動していない可能性が。
$ chkconfig --list | grep mysql
mysql55-mysqld 0:off 1:off 2:off 3:off 4:off 5:off 6:off
あかん…… ほんとうに動いてないぞっと。
# chkconfig mysqld on
サービス mysql に関する情報の読み込み中にエラーが発生しました: そのようなファイルやディレクトリはありません
ん????なんで???
ノーマルのMySQLとはちょっと違うのかな??
# chkconfig mysql55-mysqld on
# chkconfig --list | grep mysql
mysql55-mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off
今度は大丈夫そう。リブートして確認してみる。
大丈夫、ちゃんと動いてる。
続いて、Mroongaをインストールする。
# yum install -y mysql55-mroonga
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
* base: www.ftp.ne.jp
* extras: www.ftp.ne.jp
* updates: www.ftp.ne.jp
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql55-mroonga.x86_64 0:4.03-2.el6 will be installed
--> Processing Dependency: groonga-libs >= 4.0.0 for package: mysql55-mroonga-4.03-2.el6.x86_64
--> Processing Dependency: groonga-normalizer-mysql for package: mysql55-mroonga-4.03-2.el6.x86_64
--> Processing Dependency: libgroonga.so.0()(64bit) for package: mysql55-mroonga-4.03-2.el6.x86_64
--> Running transaction check
---> Package groonga-libs.x86_64 0:4.0.3-1.el6 will be installed
---> Package groonga-normalizer-mysql.x86_64 0:1.0.6-1.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
mysql55-mroonga x86_64 4.03-2.el6 groonga 173 k
Installing for dependencies:
groonga-libs x86_64 4.0.3-1.el6 groonga 1.0 M
groonga-normalizer-mysql x86_64 1.0.6-1.el6 groonga 63 k
Transaction Summary
================================================================================
Install 3 Package(s)
Total download size: 1.2 M
Installed size: 3.9 M
Downloading Packages:
(1/3): groonga-libs-4.0.3-1.el6.x86_64.rpm | 1.0 MB 00:01
(2/3): groonga-normalizer-mysql-1.0.6-1.el6.x86_64.rpm | 63 kB 00:00
(3/3): mysql55-mroonga-4.03-2.el6.x86_64.rpm | 173 kB 00:00
--------------------------------------------------------------------------------
Total 790 kB/s | 1.2 MB 00:01
警告: rpmts_HdrFromFdno: ヘッダ V4 DSA/SHA1 Signature, key ID 45499429: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-groonga
Importing GPG key 0x45499429:
Userid : groonga Key (groonga Official Signing Key)
Package: groonga-release-1.1.0-1.noarch (installed)
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-groonga
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : groonga-libs-4.0.3-1.el6.x86_64 1/3
Installing : groonga-normalizer-mysql-1.0.6-1.el6.x86_64 2/3
Installing : mysql55-mroonga-4.03-2.el6.x86_64 3/3
/opt/rh/mysql55/root/usr/bin/mysql -u root < /opt/rh/mysql55/root/usr/share/mroonga/install.sql
Verifying : groonga-normalizer-mysql-1.0.6-1.el6.x86_64 1/3
Verifying : groonga-libs-4.0.3-1.el6.x86_64 2/3
Verifying : mysql55-mroonga-4.03-2.el6.x86_64 3/3
Installed:
mysql55-mroonga.x86_64 0:4.03-2.el6
Dependency Installed:
groonga-libs.x86_64 0:4.0.3-1.el6
groonga-normalizer-mysql.x86_64 0:1.0.6-1.el6
Complete!
トークナイザーにMeCabを使うので、インストールしておく。
# yum install -y groonga-tokenizer-mecab
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
* base: www.ftp.ne.jp
* extras: www.ftp.ne.jp
* updates: www.ftp.ne.jp
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package groonga-tokenizer-mecab.x86_64 0:4.0.3-1.el6 will be installed
--> Processing Dependency: mecab-dic for package: groonga-tokenizer-mecab-4.0.3-1.el6.x86_64
--> Processing Dependency: libmecab.so.2()(64bit) for package: groonga-tokenizer-mecab-4.0.3-1.el6.x86_64
--> Running transaction check
---> Package mecab.x86_64 0:0.996-1.el6 will be installed
---> Package mecab-ipadic.x86_64 0:2.7.0.20070801-8.el6.1 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository
Size
================================================================================
Installing:
groonga-tokenizer-mecab x86_64 4.0.3-1.el6 groonga 12 k
Installing for dependencies:
mecab x86_64 0.996-1.el6 groonga 2.3 M
mecab-ipadic x86_64 2.7.0.20070801-8.el6.1 groonga 13 M
Transaction Summary
================================================================================
Install 3 Package(s)
Total download size: 15 M
Installed size: 63 M
Downloading Packages:
(1/3): groonga-tokenizer-mecab-4.0.3-1.el6.x86_64.rpm | 12 kB 00:00
(2/3): mecab-0.996-1.el6.x86_64.rpm | 2.3 MB 00:02
(3/3): mecab-ipadic-2.7.0.20070801-8.el6.1.x86_64.rpm | 13 MB 00:14
--------------------------------------------------------------------------------
Total 698 kB/s | 15 MB 00:22
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : mecab-0.996-1.el6.x86_64 1/3
Installing : mecab-ipadic-2.7.0.20070801-8.el6.1.x86_64 2/3
Installing : groonga-tokenizer-mecab-4.0.3-1.el6.x86_64 3/3
Verifying : mecab-0.996-1.el6.x86_64 1/3
Verifying : mecab-ipadic-2.7.0.20070801-8.el6.1.x86_64 2/3
Verifying : groonga-tokenizer-mecab-4.0.3-1.el6.x86_64 3/3
Installed:
groonga-tokenizer-mecab.x86_64 0:4.0.3-1.el6
Dependency Installed:
mecab.x86_64 0:0.996-1.el6 mecab-ipadic.x86_64 0:2.7.0.20070801-8.el6.1
Complete!
途中にいろいろトラブルはあったけれど、とにかく、なんとかインストールは終わったようだ。
MySQL5のrootパスワードは変えておかねば｡
$ mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.5.37 MySQL Community Server (GPL)
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> SET PASSWORD for root@localhost=PASSWORD('hogehoge');
Query OK, 0 rows affected (0.00 sec)
やっとここまで戻って来れた。
3歩進んで10歩下がった感じか。。。
CentOS6.5にMySQL5.5をインストールしたのだが。
さらに話は悲惨で、CentOS6.5にMySQL5をインストールしなくちゃならなくなった。
いままでブログに書いたやり方だと、MySQL5.6がインストールされてしまう事態に悩まされる。
同じことを2度繰り返したら成功したという顛末。
先人の教えに頼りつつ、こんな形で実現した。
まず最初に、MySQLのサイトから次の3ファイルをダウンロードしてくる。
MySQL-client-5.5.38-1.linux2.6.x86_64.rpm
MySQL-server-5.5.38-1.linux2.6.x86_64.rpm
MySQL-shared-compat-5.5.38-1.linux2.6.x86_64.rpm
で、まず既存のmysql関連のファイルを削除する。
# rpm -qa | grep mysql
mysql-devel-5.1.71-1.el6.x86_64
mysql-5.1.71-1.el6.x86_64
# yum remove mysql*
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package mysql.x86_64 0:5.1.71-1.el6 will be erased
---> Package mysql-devel.x86_64 0:5.1.71-1.el6 will be erased
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Removing:
mysql x86_64 5.1.71-1.el6 @anaconda-CentOS-201311272149.x86_64/6.5 2.4 M
mysql-devel x86_64 5.1.71-1.el6 @anaconda-CentOS-201311272149.x86_64/6.5 388 k
Transaction Summary
================================================================================
Remove 2 Package(s)
Installed size: 2.8 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Erasing : mysql-devel-5.1.71-1.el6.x86_64 1/2
Erasing : mysql-5.1.71-1.el6.x86_64 2/2
Verifying : mysql-5.1.71-1.el6.x86_64 1/2
Verifying : mysql-devel-5.1.71-1.el6.x86_64 2/2
Removed:
mysql.x86_64 0:5.1.71-1.el6 mysql-devel.x86_64 0:5.1.71-1.el6
Complete!
で、あらためてインストール開始。
ライブラリーから。
# yum localinstall MySQL-shared-compat-5.5.38-1.linux2.6.x86_64
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Local Package Process
Skipping: MySQL-shared-compat-5.5.38-1.linux2.6.x86_64, filename does not end in .rpm.
Nothing to do
次にMySQL serverをインストール。
# yum localinstall MySQL-server-5.5.38-1.linux2.6.x86_64.rpm
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Local Package Process
Examining MySQL-server-5.5.38-1.linux2.6.x86_64.rpm: MySQL-server-5.5.38-1.linux2.6.x86_64
Marking MySQL-server-5.5.38-1.linux2.6.x86_64.rpm to be installed
Loading mirror speeds from cached hostfile
* base: www.ftp.ne.jp
* extras: www.ftp.ne.jp
* updates: www.ftp.ne.jp
Resolving Dependencies
--> Running transaction check
---> Package MySQL-server.x86_64 0:5.5.38-1.linux2.6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
MySQL-server
x86_64 5.5.38-1.linux2.6 /MySQL-server-5.5.38-1.linux2.6.x86_64 151 M
Transaction Summary
================================================================================
Install 1 Package(s)
Total size: 151 M
Installed size: 151 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : MySQL-server-5.5.38-1.linux2.6.x86_64 1/1
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h CentOS6.5 password 'new-password'
Alternatively you can run:
/usr/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the manual for more instructions.
Please report any problems at http://bugs.mysql.com/
Verifying : MySQL-server-5.5.38-1.linux2.6.x86_64 1/1
Installed:
MySQL-server.x86_64 0:5.5.38-1.linux2.6
Complete!
そして最後にclientをインストール。
# yum localinstall MySQL-client-5.5.38-1.linux2.6.x86_64.rpm
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Local Package Process
Examining MySQL-client-5.5.38-1.linux2.6.x86_64.rpm: MySQL-client-5.5.38-1.linux2.6.x86_64
Marking MySQL-client-5.5.38-1.linux2.6.x86_64.rpm to be installed
Loading mirror speeds from cached hostfile
* base: www.ftp.ne.jp
* extras: www.ftp.ne.jp
* updates: www.ftp.ne.jp
Resolving Dependencies
--> Running transaction check
---> Package MySQL-client.x86_64 0:5.5.38-1.linux2.6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
MySQL-client
x86_64 5.5.38-1.linux2.6 /MySQL-client-5.5.38-1.linux2.6.x86_64 58 M
Transaction Summary
================================================================================
Install 1 Package(s)
Total size: 58 M
Installed size: 58 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : MySQL-client-5.5.38-1.linux2.6.x86_64 1/1
Verifying : MySQL-client-5.5.38-1.linux2.6.x86_64 1/1
Installed:
MySQL-client.x86_64 0:5.5.38-1.linux2.6
Complete!
一連のインストール作業は終了。
バージョンを確認してみる。
# mysql --version
mysql Ver 14.14 Distrib 5.5.38, for Linux (x86_64) using readline 5.1
ちゃんとMySQL 5.5.38がインストールされているようだ。
じゃ、MySQLを起動してみる。
$ sudo service mysql start
Starting MySQL.. [ OK ]
ちゃんと動いたので、CentOSが起動したときに、MySQLも自動起動するためのおまじない。
$ sudo chkconfig mysql on
じゃ、MySQLにアクセスしてみる。
$ mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.38 MySQL Community Server (GPL)
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
パスワードは変更しておこう。
mysql> SET PASSWORD for root@localhost=PASSWORD('hogehoge');
Query OK, 0 rows affected (0.00 sec)
以上、終了。
いままでブログに書いたやり方だと、MySQL5.6がインストールされてしまう事態に悩まされる。
同じことを2度繰り返したら成功したという顛末。
先人の教えに頼りつつ、こんな形で実現した。
まず最初に、MySQLのサイトから次の3ファイルをダウンロードしてくる。
MySQL-client-5.5.38-1.linux2.6.x86_64.rpm
MySQL-server-5.5.38-1.linux2.6.x86_64.rpm
MySQL-shared-compat-5.5.38-1.linux2.6.x86_64.rpm
で、まず既存のmysql関連のファイルを削除する。
# rpm -qa | grep mysql
mysql-devel-5.1.71-1.el6.x86_64
mysql-5.1.71-1.el6.x86_64
# yum remove mysql*
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package mysql.x86_64 0:5.1.71-1.el6 will be erased
---> Package mysql-devel.x86_64 0:5.1.71-1.el6 will be erased
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Removing:
mysql x86_64 5.1.71-1.el6 @anaconda-CentOS-201311272149.x86_64/6.5 2.4 M
mysql-devel x86_64 5.1.71-1.el6 @anaconda-CentOS-201311272149.x86_64/6.5 388 k
Transaction Summary
================================================================================
Remove 2 Package(s)
Installed size: 2.8 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Erasing : mysql-devel-5.1.71-1.el6.x86_64 1/2
Erasing : mysql-5.1.71-1.el6.x86_64 2/2
Verifying : mysql-5.1.71-1.el6.x86_64 1/2
Verifying : mysql-devel-5.1.71-1.el6.x86_64 2/2
Removed:
mysql.x86_64 0:5.1.71-1.el6 mysql-devel.x86_64 0:5.1.71-1.el6
Complete!
で、あらためてインストール開始。
ライブラリーから。
# yum localinstall MySQL-shared-compat-5.5.38-1.linux2.6.x86_64
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Local Package Process
Skipping: MySQL-shared-compat-5.5.38-1.linux2.6.x86_64, filename does not end in .rpm.
Nothing to do
次にMySQL serverをインストール。
# yum localinstall MySQL-server-5.5.38-1.linux2.6.x86_64.rpm
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Local Package Process
Examining MySQL-server-5.5.38-1.linux2.6.x86_64.rpm: MySQL-server-5.5.38-1.linux2.6.x86_64
Marking MySQL-server-5.5.38-1.linux2.6.x86_64.rpm to be installed
Loading mirror speeds from cached hostfile
* base: www.ftp.ne.jp
* extras: www.ftp.ne.jp
* updates: www.ftp.ne.jp
Resolving Dependencies
--> Running transaction check
---> Package MySQL-server.x86_64 0:5.5.38-1.linux2.6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
MySQL-server
x86_64 5.5.38-1.linux2.6 /MySQL-server-5.5.38-1.linux2.6.x86_64 151 M
Transaction Summary
================================================================================
Install 1 Package(s)
Total size: 151 M
Installed size: 151 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : MySQL-server-5.5.38-1.linux2.6.x86_64 1/1
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h CentOS6.5 password 'new-password'
Alternatively you can run:
/usr/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the manual for more instructions.
Please report any problems at http://bugs.mysql.com/
Verifying : MySQL-server-5.5.38-1.linux2.6.x86_64 1/1
Installed:
MySQL-server.x86_64 0:5.5.38-1.linux2.6
Complete!
そして最後にclientをインストール。
# yum localinstall MySQL-client-5.5.38-1.linux2.6.x86_64.rpm
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Local Package Process
Examining MySQL-client-5.5.38-1.linux2.6.x86_64.rpm: MySQL-client-5.5.38-1.linux2.6.x86_64
Marking MySQL-client-5.5.38-1.linux2.6.x86_64.rpm to be installed
Loading mirror speeds from cached hostfile
* base: www.ftp.ne.jp
* extras: www.ftp.ne.jp
* updates: www.ftp.ne.jp
Resolving Dependencies
--> Running transaction check
---> Package MySQL-client.x86_64 0:5.5.38-1.linux2.6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
MySQL-client
x86_64 5.5.38-1.linux2.6 /MySQL-client-5.5.38-1.linux2.6.x86_64 58 M
Transaction Summary
================================================================================
Install 1 Package(s)
Total size: 58 M
Installed size: 58 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : MySQL-client-5.5.38-1.linux2.6.x86_64 1/1
Verifying : MySQL-client-5.5.38-1.linux2.6.x86_64 1/1
Installed:
MySQL-client.x86_64 0:5.5.38-1.linux2.6
Complete!
一連のインストール作業は終了。
バージョンを確認してみる。
# mysql --version
mysql Ver 14.14 Distrib 5.5.38, for Linux (x86_64) using readline 5.1
ちゃんとMySQL 5.5.38がインストールされているようだ。
じゃ、MySQLを起動してみる。
$ sudo service mysql start
Starting MySQL.. [ OK ]
ちゃんと動いたので、CentOSが起動したときに、MySQLも自動起動するためのおまじない。
$ sudo chkconfig mysql on
じゃ、MySQLにアクセスしてみる。
$ mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.38 MySQL Community Server (GPL)
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
パスワードは変更しておこう。
mysql> SET PASSWORD for root@localhost=PASSWORD('hogehoge');
Query OK, 0 rows affected (0.00 sec)
以上、終了。
CentOS6.5にMariaDBをインストールしたところ。
結局、CentOS7はいろいろと練れていないところが多すぎる気がする。
もっとバージョンが上がって落ち着きまでは、手を出しちゃいけないんだろうな。
というわけで、CentOS6.5に戻って、MariaDBのインストール作業を行う。
これからMySQLからMariaDBへ移行が進むらしいけれど、どんなものなのやら。
まず、既存のMySQLのパッケージの有無を調べる。
[root@centos6 hogehoge]# rpm -qa | grep mysql
mysql-libs-5.1.73-3.el6_5.x86_64
mysql-5.1.73-3.el6_5.x86_64
mysql-devel-5.1.73-3.el6_5.x86_64
これはデフォルトでインストールされているパッケージだね。
じゃ、これを削除する。
[root@centos6 hogehoge]# yum remove mysql*
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package mysql.x86_64 0:5.1.73-3.el6_5 will be erased
---> Package mysql-devel.x86_64 0:5.1.73-3.el6_5 will be erased
---> Package mysql-libs.x86_64 0:5.1.73-3.el6_5 will be erased
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: 2:postfix-2.6.6-6.el6_5.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: 2:postfix-2.6.6-6.el6_5.x86_64
--> Processing Dependency: mysql-libs for package: 2:postfix-2.6.6-6.el6_5.x86_64
--> Running transaction check
---> Package postfix.x86_64 2:2.6.6-6.el6_5 will be erased
--> Processing Dependency: /usr/sbin/sendmail for package: redhat-lsb-core-4.0-7.el6.centos.x86_64
--> Processing Dependency: /usr/sbin/sendmail for package: cronie-1.4.4-12.el6.x86_64
--> Running transaction check
---> Package cronie.x86_64 0:1.4.4-12.el6 will be erased
--> Processing Dependency: cronie = 1.4.4-12.el6 for package: cronie-anacron-1.4.4-12.el6.x86_64
---> Package redhat-lsb-core.x86_64 0:4.0-7.el6.centos will be erased
--> Processing Dependency: redhat-lsb-core(x86-64) = 4.0 for package: redhat-lsb-printing-4.0-7.el6.centos.x86_64
--> Processing Dependency: redhat-lsb-core(x86-64) = 4.0-7.el6.centos for package: redhat-lsb-4.0-7.el6.centos.x86_64
--> Processing Dependency: redhat-lsb-core(x86-64) = 4.0 for package: redhat-lsb-graphics-4.0-7.el6.centos.x86_64
--> Running transaction check
---> Package cronie-anacron.x86_64 0:1.4.4-12.el6 will be erased
---> Package redhat-lsb.x86_64 0:4.0-7.el6.centos will be erased
--> Processing Dependency: redhat-lsb(x86-64) = 4.0-7.el6.centos for package: redhat-lsb-compat-4.0-7.el6.centos.x86_64
---> Package redhat-lsb-graphics.x86_64 0:4.0-7.el6.centos will be erased
---> Package redhat-lsb-printing.x86_64 0:4.0-7.el6.centos will be erased
--> Running transaction check
---> Package redhat-lsb-compat.x86_64 0:4.0-7.el6.centos will be erased
--> Processing Dependency: /etc/cron.d for package: crontabs-1.10-33.el6.noarch
--> Processing Dependency: /etc/cron.d for package: sysstat-9.0.4-22.el6.x86_64
--> Restarting Dependency Resolution with new changes.
--> Running transaction check
---> Package crontabs.noarch 0:1.10-33.el6 will be erased
---> Package sysstat.x86_64 0:9.0.4-22.el6 will be erased
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Removing:
mysql x86_64 5.1.73-3.el6_5 @updates 2.4 M
mysql-devel
x86_64 5.1.73-3.el6_5 @updates 388 k
mysql-libs
x86_64 5.1.73-3.el6_5 @updates 4.0 M
Removing for dependencies:
cronie x86_64 1.4.4-12.el6 @anaconda-CentOS-201311272149.x86_64/6.5 174 k
cronie-anacron
x86_64 1.4.4-12.el6 @anaconda-CentOS-201311272149.x86_64/6.5 43 k
crontabs
noarch 1.10-33.el6 @anaconda-CentOS-201311272149.x86_64/6.5 2.4 k
postfix x86_64 2:2.6.6-6.el6_5 @updates 9.7 M
redhat-lsb
x86_64 4.0-7.el6.centos @anaconda-CentOS-201311272149.x86_64/6.5 0.0
redhat-lsb-compat
x86_64 4.0-7.el6.centos @anaconda-CentOS-201311272149.x86_64/6.5 0.0
redhat-lsb-core
x86_64 4.0-7.el6.centos @anaconda-CentOS-201311272149.x86_64/6.5 22 k
redhat-lsb-graphics
x86_64 4.0-7.el6.centos @anaconda-CentOS-201311272149.x86_64/6.5 0.0
redhat-lsb-printing
x86_64 4.0-7.el6.centos @anaconda-CentOS-201311272149.x86_64/6.5 0.0
sysstat x86_64 9.0.4-22.el6 @anaconda-CentOS-201311272149.x86_64/6.5 824 k
Transaction Summary
================================================================================
Remove 13 Package(s)
Installed size: 18 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Erasing : redhat-lsb-compat-4.0-7.el6.centos.x86_64 1/13
Erasing : redhat-lsb-4.0-7.el6.centos.x86_64 2/13
Erasing : mysql-devel-5.1.73-3.el6_5.x86_64 3/13
Erasing : redhat-lsb-graphics-4.0-7.el6.centos.x86_64 4/13
Erasing : redhat-lsb-printing-4.0-7.el6.centos.x86_64 5/13
Erasing : redhat-lsb-core-4.0-7.el6.centos.x86_64 6/13
Erasing : mysql-5.1.73-3.el6_5.x86_64 7/13
/var/tmp/rpm-tmp.OHPbrg: line 1: lsb_release: コマンドが見つかりません
Erasing : sysstat-9.0.4-22.el6.x86_64 8/13
Erasing : crontabs-1.10-33.el6.noarch 9/13
Erasing : cronie-anacron-1.4.4-12.el6.x86_64 10/13
Erasing : cronie-1.4.4-12.el6.x86_64 11/13
Erasing : 2:postfix-2.6.6-6.el6_5.x86_64 12/13
Erasing : mysql-libs-5.1.73-3.el6_5.x86_64 13/13
Verifying : mysql-devel-5.1.73-3.el6_5.x86_64 1/13
Verifying : redhat-lsb-printing-4.0-7.el6.centos.x86_64 2/13
Verifying : cronie-anacron-1.4.4-12.el6.x86_64 3/13
Verifying : redhat-lsb-core-4.0-7.el6.centos.x86_64 4/13
Verifying : mysql-libs-5.1.73-3.el6_5.x86_64 5/13
Verifying : redhat-lsb-4.0-7.el6.centos.x86_64 6/13
Verifying : mysql-5.1.73-3.el6_5.x86_64 7/13
Verifying : crontabs-1.10-33.el6.noarch 8/13
Verifying : redhat-lsb-compat-4.0-7.el6.centos.x86_64 9/13
Verifying : sysstat-9.0.4-22.el6.x86_64 10/13
Verifying : cronie-1.4.4-12.el6.x86_64 11/13
Verifying : 2:postfix-2.6.6-6.el6_5.x86_64 12/13
Verifying : redhat-lsb-graphics-4.0-7.el6.centos.x86_64 13/13
Removed:
mysql.x86_64 0:5.1.73-3.el6_5 mysql-devel.x86_64 0:5.1.73-3.el6_5
mysql-libs.x86_64 0:5.1.73-3.el6_5
Dependency Removed:
cronie.x86_64 0:1.4.4-12.el6
cronie-anacron.x86_64 0:1.4.4-12.el6
crontabs.noarch 0:1.10-33.el6
postfix.x86_64 2:2.6.6-6.el6_5
redhat-lsb.x86_64 0:4.0-7.el6.centos
redhat-lsb-compat.x86_64 0:4.0-7.el6.centos
redhat-lsb-core.x86_64 0:4.0-7.el6.centos
redhat-lsb-graphics.x86_64 0:4.0-7.el6.centos
redhat-lsb-printing.x86_64 0:4.0-7.el6.centos
sysstat.x86_64 0:9.0.4-22.el6
Complete!
[root@centos6 hogehoge]# rpm -qa | grep mysql
[root@centos6 hogehoge]#
きれいさっぱりなくなりました。
で、MariaDBのインストールに取りかかる。
まず最初に、RPG-GPG-KEYを追加する
[root@centos6 hogehoge]# sudo rpm --import https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
次に、リポジトリを追加作業を実施。
今回はバージョン10.0.12にトライ!
[root@centos6 hogehoge]# vi /etc/yum.repos.d/MariaDB.repo
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.0.12/centos6-x86
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
enabled=1
リポジトリの追加作業が終わったら、インストールを実行。
[root@centos6 hogehoge]# yum install MariaDB-devel MariaDB-client MariaDB-server
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
* base: www.ftp.ne.jp
* extras: www.ftp.ne.jp
* updates: www.ftp.ne.jp
mariadb | 1.9 kB 00:00
mariadb/primary_db | 18 kB 00:00
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package MariaDB-client.i686 0:10.0.12-1.el6 will be installed
--> Processing Dependency: MariaDB-common for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libtinfo.so.5 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libcrypt.so.1 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libdl.so.2(GLIBC_2.0) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libcrypt.so.1(GLIBC_2.0) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: ld-linux.so.2 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libpthread.so.0(GLIBC_2.3.2) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libc.so.6(GLIBC_2.3.3) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libm.so.6(GLIBC_2.0) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libaio.so.1 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: librt.so.1(GLIBC_2.2) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libstdc++.so.6 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libc.so.6(GLIBC_2.2) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libm.so.6 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libc.so.6(GLIBC_2.0) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: librt.so.1 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libm.so.6(GLIBC_2.1) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libdl.so.2 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libpthread.so.0(GLIBC_2.2) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libpthread.so.0 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libc.so.6(GLIBC_2.3) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libaio.so.1(LIBAIO_0.4) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libstdc++.so.6(GLIBCXX_3.4) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libaio.so.1(LIBAIO_0.1) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libc.so.6(GLIBC_2.1.3) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libpthread.so.0(GLIBC_2.1) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libncurses.so.5 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: ld-linux.so.2(GLIBC_2.3) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libcrypto.so.10 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libstdc++.so.6(CXXABI_1.3) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libpthread.so.0(GLIBC_2.0) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libdl.so.2(GLIBC_2.1) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libc.so.6 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libssl.so.10 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libz.so.1 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libm.so.6(GLIBC_2.2) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libc.so.6(GLIBC_2.1) for package: MariaDB-client-10.0.12-1.el6.i686
---> Package MariaDB-devel.i686 0:10.0.12-1.el6 will be installed
---> Package MariaDB-server.i686 0:10.0.12-1.el6 will be installed
--> Processing Dependency: libpam.so.0(LIBPAM_1.0) for package: MariaDB-server-10.0.12-1.el6.i686
--> Processing Dependency: libpam.so.0 for package: MariaDB-server-10.0.12-1.el6.i686
--> Running transaction check
---> Package MariaDB-common.i686 0:10.0.12-1.el6 will be installed
--> Processing Dependency: MariaDB-compat for package: MariaDB-common-10.0.12-1.el6.i686
---> Package glibc.i686 0:2.12-1.132.el6_5.2 will be installed
--> Processing Dependency: libfreebl3.so(NSSRAWHASH_3.12.3) for package: glibc-2.12-1.132.el6_5.2.i686
--> Processing Dependency: libfreebl3.so for package: glibc-2.12-1.132.el6_5.2.i686
---> Package libaio.i686 0:0.3.107-10.el6 will be installed
---> Package libstdc++.i686 0:4.4.7-4.el6 will be installed
--> Processing Dependency: libgcc_s.so.1(GLIBC_2.0) for package: libstdc++-4.4.7-4.el6.i686
--> Processing Dependency: libgcc_s.so.1(GCC_4.2.0) for package: libstdc++-4.4.7-4.el6.i686
--> Processing Dependency: libgcc_s.so.1(GCC_3.3) for package: libstdc++-4.4.7-4.el6.i686
--> Processing Dependency: libgcc_s.so.1(GCC_3.0) for package: libstdc++-4.4.7-4.el6.i686
--> Processing Dependency: libgcc_s.so.1 for package: libstdc++-4.4.7-4.el6.i686
---> Package ncurses-libs.i686 0:5.7-3.20090208.el6 will be installed
---> Package openssl.i686 0:1.0.1e-16.el6_5.14 will be installed
--> Processing Dependency: libkrb5.so.3(krb5_3_MIT) for package: openssl-1.0.1e-16.el6_5.14.i686
--> Processing Dependency: libkrb5.so.3 for package: openssl-1.0.1e-16.el6_5.14.i686
--> Processing Dependency: libk5crypto.so.3(k5crypto_3_MIT) for package: openssl-1.0.1e-16.el6_5.14.i686
--> Processing Dependency: libk5crypto.so.3 for package: openssl-1.0.1e-16.el6_5.14.i686
--> Processing Dependency: libgssapi_krb5.so.2 for package: openssl-1.0.1e-16.el6_5.14.i686
--> Processing Dependency: libcom_err.so.2 for package: openssl-1.0.1e-16.el6_5.14.i686
---> Package pam.i686 0:1.1.1-17.el6 will be installed
--> Processing Dependency: libselinux.so.1 for package: pam-1.1.1-17.el6.i686
--> Processing Dependency: libdb-4.7.so for package: pam-1.1.1-17.el6.i686
--> Processing Dependency: libcrack.so.2 for package: pam-1.1.1-17.el6.i686
--> Processing Dependency: libaudit.so.1 for package: pam-1.1.1-17.el6.i686
---> Package zlib.i686 0:1.2.3-29.el6 will be installed
--> Running transaction check
---> Package MariaDB-compat.i686 0:10.0.12-1.el6 will be installed
---> Package audit-libs.i686 0:2.2-4.el6_5 will be installed
---> Package cracklib.i686 0:2.8.16-4.el6 will be installed
---> Package db4.i686 0:4.7.25-18.el6_4 will be installed
---> Package krb5-libs.i686 0:1.10.3-15.el6_5.1 will be installed
--> Processing Dependency: libkeyutils.so.1(KEYUTILS_0.3) for package: krb5-libs-1.10.3-15.el6_5.1.i686
--> Processing Dependency: libkeyutils.so.1 for package: krb5-libs-1.10.3-15.el6_5.1.i686
---> Package libcom_err.i686 0:1.41.12-18.el6 will be installed
---> Package libgcc.i686 0:4.4.7-4.el6 will be installed
---> Package libselinux.i686 0:2.0.94-5.3.el6_4.1 will be installed
---> Package nss-softokn-freebl.i686 0:3.14.3-10.el6_5 will be installed
--> Running transaction check
---> Package keyutils-libs.i686 0:1.4-4.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
MariaDB-client i686 10.0.12-1.el6 mariadb 11 M
MariaDB-devel i686 10.0.12-1.el6 mariadb 6.4 M
MariaDB-server i686 10.0.12-1.el6 mariadb 40 M
Installing for dependencies:
MariaDB-common i686 10.0.12-1.el6 mariadb 23 k
MariaDB-compat i686 10.0.12-1.el6 mariadb 2.6 M
audit-libs i686 2.2-4.el6_5 updates 61 k
cracklib i686 2.8.16-4.el6 base 70 k
db4 i686 4.7.25-18.el6_4 base 580 k
glibc i686 2.12-1.132.el6_5.2 updates 4.3 M
keyutils-libs i686 1.4-4.el6 base 20 k
krb5-libs i686 1.10.3-15.el6_5.1 updates 769 k
libaio i686 0.3.107-10.el6 base 21 k
libcom_err i686 1.41.12-18.el6 base 37 k
libgcc i686 4.4.7-4.el6 base 112 k
libselinux i686 2.0.94-5.3.el6_4.1 base 108 k
libstdc++ i686 4.4.7-4.el6 base 300 k
ncurses-libs i686 5.7-3.20090208.el6 base 251 k
nss-softokn-freebl i686 3.14.3-10.el6_5 updates 147 k
openssl i686 1.0.1e-16.el6_5.14 updates 1.5 M
pam i686 1.1.1-17.el6 base 659 k
zlib i686 1.2.3-29.el6 base 73 k
Transaction Summary
================================================================================
Install 21 Package(s)
Total download size: 69 M
Installed size: 264 M
Is this ok [y/N]: y
Downloading Packages:
(1/21): MariaDB-10.0.12-centos6-i686-client.rpm | 11 MB 00:23
(2/21): MariaDB-10.0.12-centos6-i686-common.rpm | 23 kB 00:00
(3/21): MariaDB-10.0.12-centos6-i686-compat.rpm | 2.6 MB 00:07
(4/21): MariaDB-10.0.12-centos6-i686-devel.rpm | 6.4 MB 00:28
(5/21): MariaDB-10.0.12-centos6-i686-server.rpm | 40 MB 03:40
(6/21): audit-libs-2.2-4.el6_5.i686.rpm | 61 kB 00:00
(7/21): cracklib-2.8.16-4.el6.i686.rpm | 70 kB 00:00
(8/21): db4-4.7.25-18.el6_4.i686.rpm | 580 kB 00:01
(9/21): glibc-2.12-1.132.el6_5.2.i686.rpm | 4.3 MB 00:10
(10/21): keyutils-libs-1.4-4.el6.i686.rpm | 20 kB 00:00
(11/21): krb5-libs-1.10.3-15.el6_5.1.i686.rpm | 769 kB 00:02
(12/21): libaio-0.3.107-10.el6.i686.rpm | 21 kB 00:00
(13/21): libcom_err-1.41.12-18.el6.i686.rpm | 37 kB 00:00
(14/21): libgcc-4.4.7-4.el6.i686.rpm | 112 kB 00:00
(15/21): libselinux-2.0.94-5.3.el6_4.1.i686.rpm | 108 kB 00:00
(16/21): libstdc++-4.4.7-4.el6.i686.rpm | 300 kB 00:00
(17/21): ncurses-libs-5.7-3.20090208.el6.i686.rpm | 251 kB 00:00
(18/21): nss-softokn-freebl-3.14.3-10.el6_5.i686.rpm | 147 kB 00:00
(19/21): openssl-1.0.1e-16.el6_5.14.i686.rpm | 1.5 MB 00:04
(20/21): pam-1.1.1-17.el6.i686.rpm | 659 kB 00:02
(21/21): zlib-1.2.3-29.el6.i686.rpm | 73 kB 00:00
--------------------------------------------------------------------------------
Total 228 kB/s | 69 MB 05:07
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : libgcc-4.4.7-4.el6.i686 1/21
Installing : glibc-2.12-1.132.el6_5.2.i686 2/21
Installing : nss-softokn-freebl-3.14.3-10.el6_5.i686 3/21
Installing : zlib-1.2.3-29.el6.i686 4/21
Installing : libstdc++-4.4.7-4.el6.i686 5/21
Installing : libselinux-2.0.94-5.3.el6_4.1.i686 6/21
Installing : libcom_err-1.41.12-18.el6.i686 7/21
Installing : libaio-0.3.107-10.el6.i686 8/21
Installing : MariaDB-compat-10.0.12-1.el6.i686 9/21
Installing : MariaDB-common-10.0.12-1.el6.i686 10/21
Installing : cracklib-2.8.16-4.el6.i686 11/21
Installing : keyutils-libs-1.4-4.el6.i686 12/21
Installing : krb5-libs-1.10.3-15.el6_5.1.i686 13/21
Installing : openssl-1.0.1e-16.el6_5.14.i686 14/21
Installing : audit-libs-2.2-4.el6_5.i686 15/21
Installing : ncurses-libs-5.7-3.20090208.el6.i686 16/21
Installing : MariaDB-client-10.0.12-1.el6.i686 17/21
Installing : db4-4.7.25-18.el6_4.i686 18/21
Installing : MariaDB-devel-10.0.12-1.el6.i686 19/21
Installing : pam-1.1.1-17.el6.i686 20/21
Installing : MariaDB-server-10.0.12-1.el6.i686 21/21
chown: cannot access `/var/lib/mysql': そのようなファイルやディレクトリはありません
140720 20:42:53 [Note] InnoDB: Using mutexes to ref count buffer pool pages
140720 20:42:53 [Note] InnoDB: The InnoDB memory heap is disabled
140720 20:42:53 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
140720 20:42:53 [Note] InnoDB: Compressed tables use zlib 1.2.3
140720 20:42:53 [Note] InnoDB: Using Linux native AIO
140720 20:42:53 [Note] InnoDB: Not using CPU crc32 instructions
140720 20:42:53 [Note] InnoDB: Initializing buffer pool, size = 128.0M
140720 20:42:53 [Note] InnoDB: Completed initialization of buffer pool
140720 20:42:53 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
140720 20:42:53 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
140720 20:42:53 [Note] InnoDB: Database physically writes the file full: wait...
140720 20:42:53 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
140720 20:42:54 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
140720 20:42:54 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
140720 20:42:54 [Warning] InnoDB: New log files created, LSN=45781
140720 20:42:54 [Note] InnoDB: Doublewrite buffer not found: creating new
140720 20:42:54 [Note] InnoDB: Doublewrite buffer created
140720 20:42:54 [Note] InnoDB: 128 rollback segment(s) are active.
140720 20:42:54 [Warning] InnoDB: Creating foreign key constraint system tables.
140720 20:42:54 [Note] InnoDB: Foreign key constraint system tables created
140720 20:42:54 [Note] InnoDB: Creating tablespace and datafile system tables.
140720 20:42:54 [Note] InnoDB: Tablespace and datafile system tables created.
140720 20:42:54 [Note] InnoDB: Waiting for purge to start
140720 20:42:54 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.17-65.0 started; log sequence number 0
140720 20:42:55 [Note] InnoDB: FTS optimize thread exiting.
140720 20:42:55 [Note] InnoDB: Starting shutdown...
140720 20:42:57 [Note] InnoDB: Shutdown completed; log sequence number 1616697
140720 20:42:57 [Note] InnoDB: Using mutexes to ref count buffer pool pages
140720 20:42:57 [Note] InnoDB: The InnoDB memory heap is disabled
140720 20:42:57 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
140720 20:42:57 [Note] InnoDB: Compressed tables use zlib 1.2.3
140720 20:42:57 [Note] InnoDB: Using Linux native AIO
140720 20:42:57 [Note] InnoDB: Not using CPU crc32 instructions
140720 20:42:57 [Note] InnoDB: Initializing buffer pool, size = 128.0M
140720 20:42:57 [Note] InnoDB: Completed initialization of buffer pool
140720 20:42:57 [Note] InnoDB: Highest supported file format is Barracuda.
140720 20:42:57 [Note] InnoDB: 128 rollback segment(s) are active.
140720 20:42:57 [Note] InnoDB: Waiting for purge to start
140720 20:42:57 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.17-65.0 started; log sequence number 1616697
140720 20:42:57 [Note] InnoDB: FTS optimize thread exiting.
140720 20:42:57 [Note] InnoDB: Starting shutdown...
140720 20:42:59 [Note] InnoDB: Shutdown completed; log sequence number 1616707
PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following commands:
'/usr/bin/mysqladmin' -u root password 'new-password'
'/usr/bin/mysqladmin' -u root -h centos6.5 password 'new-password'
Alternatively you can run:
'/usr/bin/mysql_secure_installation'
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the MariaDB Knowledgebase at http://mariadb.com/kb or the
MySQL manual for more instructions.
Please report any problems at http://mariadb.org/jira
The latest information about MariaDB is available at http://mariadb.org/.
You can find additional information about the MySQL part at:
http://dev.mysql.com
Support MariaDB development by buying support/new features from
SkySQL Ab. You can contact us about this at sales@skysql.com.
Alternatively consider joining our community based development effort:
http://mariadb.com/kb/en/contributing-to-the-mariadb-project/
Verifying : cracklib-2.8.16-4.el6.i686 1/21
Verifying : libstdc++-4.4.7-4.el6.i686 2/21
Verifying : MariaDB-client-10.0.12-1.el6.i686 3/21
Verifying : MariaDB-common-10.0.12-1.el6.i686 4/21
Verifying : libselinux-2.0.94-5.3.el6_4.1.i686 5/21
Verifying : libcom_err-1.41.12-18.el6.i686 6/21
Verifying : nss-softokn-freebl-3.14.3-10.el6_5.i686 7/21
Verifying : MariaDB-devel-10.0.12-1.el6.i686 8/21
Verifying : keyutils-libs-1.4-4.el6.i686 9/21
Verifying : libgcc-4.4.7-4.el6.i686 10/21
Verifying : audit-libs-2.2-4.el6_5.i686 11/21
Verifying : ncurses-libs-5.7-3.20090208.el6.i686 12/21
Verifying : libaio-0.3.107-10.el6.i686 13/21
Verifying : MariaDB-server-10.0.12-1.el6.i686 14/21
Verifying : MariaDB-compat-10.0.12-1.el6.i686 15/21
Verifying : pam-1.1.1-17.el6.i686 16/21
Verifying : db4-4.7.25-18.el6_4.i686 17/21
Verifying : openssl-1.0.1e-16.el6_5.14.i686 18/21
Verifying : krb5-libs-1.10.3-15.el6_5.1.i686 19/21
Verifying : glibc-2.12-1.132.el6_5.2.i686 20/21
Verifying : zlib-1.2.3-29.el6.i686 21/21
Installed:
MariaDB-client.i686 0:10.0.12-1.el6 MariaDB-devel.i686 0:10.0.12-1.el6
MariaDB-server.i686 0:10.0.12-1.el6
Dependency Installed:
MariaDB-common.i686 0:10.0.12-1.el6
MariaDB-compat.i686 0:10.0.12-1.el6
audit-libs.i686 0:2.2-4.el6_5
cracklib.i686 0:2.8.16-4.el6
db4.i686 0:4.7.25-18.el6_4
glibc.i686 0:2.12-1.132.el6_5.2
keyutils-libs.i686 0:1.4-4.el6
krb5-libs.i686 0:1.10.3-15.el6_5.1
libaio.i686 0:0.3.107-10.el6
libcom_err.i686 0:1.41.12-18.el6
libgcc.i686 0:4.4.7-4.el6
libselinux.i686 0:2.0.94-5.3.el6_4.1
libstdc++.i686 0:4.4.7-4.el6
ncurses-libs.i686 0:5.7-3.20090208.el6
nss-softokn-freebl.i686 0:3.14.3-10.el6_5
openssl.i686 0:1.0.1e-16.el6_5.14
pam.i686 0:1.1.1-17.el6
zlib.i686 0:1.2.3-29.el6
Complete!
で、MariaDB関連のインストールは終わったらしい。
バージョンを確認してみると。
[root@centos6 /]# mysqld --version
mysqld Ver 10.0.12-MariaDB for Linux on i686 (MariaDB Server)
MySQLでありながらMariaDBという、この気持ち悪さはなんなんだ!? (^^;
で、MariaDBを起動させる。
[root@centos6 /]# sudo service mysql start
Starting MySQL. SUCCESS!
ついでに、CentOS6.5起動時にMariaDBを自動起動するためのまじないも。
[root@centos6 /]# sudo chkconfig mysql on
じゃ、動作確認してみますか.
[hogehoge@centos6 ~]$ mysql -u root
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 10.0.12-MariaDB MariaDB Server
Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
rootのパスワードを変更しておこう。
MariaDB [(none)]> SET PASSWORD for root@localhost=PASSWORD('hogehoge');
Query OK, 0 rows affected (0.04 sec)
これでrootのパスワードが設定された。
MariaDBのインストールはここまで。
もっとバージョンが上がって落ち着きまでは、手を出しちゃいけないんだろうな。
というわけで、CentOS6.5に戻って、MariaDBのインストール作業を行う。
これからMySQLからMariaDBへ移行が進むらしいけれど、どんなものなのやら。
まず、既存のMySQLのパッケージの有無を調べる。
[root@centos6 hogehoge]# rpm -qa | grep mysql
mysql-libs-5.1.73-3.el6_5.x86_64
mysql-5.1.73-3.el6_5.x86_64
mysql-devel-5.1.73-3.el6_5.x86_64
これはデフォルトでインストールされているパッケージだね。
じゃ、これを削除する。
[root@centos6 hogehoge]# yum remove mysql*
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package mysql.x86_64 0:5.1.73-3.el6_5 will be erased
---> Package mysql-devel.x86_64 0:5.1.73-3.el6_5 will be erased
---> Package mysql-libs.x86_64 0:5.1.73-3.el6_5 will be erased
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: 2:postfix-2.6.6-6.el6_5.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: 2:postfix-2.6.6-6.el6_5.x86_64
--> Processing Dependency: mysql-libs for package: 2:postfix-2.6.6-6.el6_5.x86_64
--> Running transaction check
---> Package postfix.x86_64 2:2.6.6-6.el6_5 will be erased
--> Processing Dependency: /usr/sbin/sendmail for package: redhat-lsb-core-4.0-7.el6.centos.x86_64
--> Processing Dependency: /usr/sbin/sendmail for package: cronie-1.4.4-12.el6.x86_64
--> Running transaction check
---> Package cronie.x86_64 0:1.4.4-12.el6 will be erased
--> Processing Dependency: cronie = 1.4.4-12.el6 for package: cronie-anacron-1.4.4-12.el6.x86_64
---> Package redhat-lsb-core.x86_64 0:4.0-7.el6.centos will be erased
--> Processing Dependency: redhat-lsb-core(x86-64) = 4.0 for package: redhat-lsb-printing-4.0-7.el6.centos.x86_64
--> Processing Dependency: redhat-lsb-core(x86-64) = 4.0-7.el6.centos for package: redhat-lsb-4.0-7.el6.centos.x86_64
--> Processing Dependency: redhat-lsb-core(x86-64) = 4.0 for package: redhat-lsb-graphics-4.0-7.el6.centos.x86_64
--> Running transaction check
---> Package cronie-anacron.x86_64 0:1.4.4-12.el6 will be erased
---> Package redhat-lsb.x86_64 0:4.0-7.el6.centos will be erased
--> Processing Dependency: redhat-lsb(x86-64) = 4.0-7.el6.centos for package: redhat-lsb-compat-4.0-7.el6.centos.x86_64
---> Package redhat-lsb-graphics.x86_64 0:4.0-7.el6.centos will be erased
---> Package redhat-lsb-printing.x86_64 0:4.0-7.el6.centos will be erased
--> Running transaction check
---> Package redhat-lsb-compat.x86_64 0:4.0-7.el6.centos will be erased
--> Processing Dependency: /etc/cron.d for package: crontabs-1.10-33.el6.noarch
--> Processing Dependency: /etc/cron.d for package: sysstat-9.0.4-22.el6.x86_64
--> Restarting Dependency Resolution with new changes.
--> Running transaction check
---> Package crontabs.noarch 0:1.10-33.el6 will be erased
---> Package sysstat.x86_64 0:9.0.4-22.el6 will be erased
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Removing:
mysql x86_64 5.1.73-3.el6_5 @updates 2.4 M
mysql-devel
x86_64 5.1.73-3.el6_5 @updates 388 k
mysql-libs
x86_64 5.1.73-3.el6_5 @updates 4.0 M
Removing for dependencies:
cronie x86_64 1.4.4-12.el6 @anaconda-CentOS-201311272149.x86_64/6.5 174 k
cronie-anacron
x86_64 1.4.4-12.el6 @anaconda-CentOS-201311272149.x86_64/6.5 43 k
crontabs
noarch 1.10-33.el6 @anaconda-CentOS-201311272149.x86_64/6.5 2.4 k
postfix x86_64 2:2.6.6-6.el6_5 @updates 9.7 M
redhat-lsb
x86_64 4.0-7.el6.centos @anaconda-CentOS-201311272149.x86_64/6.5 0.0
redhat-lsb-compat
x86_64 4.0-7.el6.centos @anaconda-CentOS-201311272149.x86_64/6.5 0.0
redhat-lsb-core
x86_64 4.0-7.el6.centos @anaconda-CentOS-201311272149.x86_64/6.5 22 k
redhat-lsb-graphics
x86_64 4.0-7.el6.centos @anaconda-CentOS-201311272149.x86_64/6.5 0.0
redhat-lsb-printing
x86_64 4.0-7.el6.centos @anaconda-CentOS-201311272149.x86_64/6.5 0.0
sysstat x86_64 9.0.4-22.el6 @anaconda-CentOS-201311272149.x86_64/6.5 824 k
Transaction Summary
================================================================================
Remove 13 Package(s)
Installed size: 18 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Erasing : redhat-lsb-compat-4.0-7.el6.centos.x86_64 1/13
Erasing : redhat-lsb-4.0-7.el6.centos.x86_64 2/13
Erasing : mysql-devel-5.1.73-3.el6_5.x86_64 3/13
Erasing : redhat-lsb-graphics-4.0-7.el6.centos.x86_64 4/13
Erasing : redhat-lsb-printing-4.0-7.el6.centos.x86_64 5/13
Erasing : redhat-lsb-core-4.0-7.el6.centos.x86_64 6/13
Erasing : mysql-5.1.73-3.el6_5.x86_64 7/13
/var/tmp/rpm-tmp.OHPbrg: line 1: lsb_release: コマンドが見つかりません
Erasing : sysstat-9.0.4-22.el6.x86_64 8/13
Erasing : crontabs-1.10-33.el6.noarch 9/13
Erasing : cronie-anacron-1.4.4-12.el6.x86_64 10/13
Erasing : cronie-1.4.4-12.el6.x86_64 11/13
Erasing : 2:postfix-2.6.6-6.el6_5.x86_64 12/13
Erasing : mysql-libs-5.1.73-3.el6_5.x86_64 13/13
Verifying : mysql-devel-5.1.73-3.el6_5.x86_64 1/13
Verifying : redhat-lsb-printing-4.0-7.el6.centos.x86_64 2/13
Verifying : cronie-anacron-1.4.4-12.el6.x86_64 3/13
Verifying : redhat-lsb-core-4.0-7.el6.centos.x86_64 4/13
Verifying : mysql-libs-5.1.73-3.el6_5.x86_64 5/13
Verifying : redhat-lsb-4.0-7.el6.centos.x86_64 6/13
Verifying : mysql-5.1.73-3.el6_5.x86_64 7/13
Verifying : crontabs-1.10-33.el6.noarch 8/13
Verifying : redhat-lsb-compat-4.0-7.el6.centos.x86_64 9/13
Verifying : sysstat-9.0.4-22.el6.x86_64 10/13
Verifying : cronie-1.4.4-12.el6.x86_64 11/13
Verifying : 2:postfix-2.6.6-6.el6_5.x86_64 12/13
Verifying : redhat-lsb-graphics-4.0-7.el6.centos.x86_64 13/13
Removed:
mysql.x86_64 0:5.1.73-3.el6_5 mysql-devel.x86_64 0:5.1.73-3.el6_5
mysql-libs.x86_64 0:5.1.73-3.el6_5
Dependency Removed:
cronie.x86_64 0:1.4.4-12.el6
cronie-anacron.x86_64 0:1.4.4-12.el6
crontabs.noarch 0:1.10-33.el6
postfix.x86_64 2:2.6.6-6.el6_5
redhat-lsb.x86_64 0:4.0-7.el6.centos
redhat-lsb-compat.x86_64 0:4.0-7.el6.centos
redhat-lsb-core.x86_64 0:4.0-7.el6.centos
redhat-lsb-graphics.x86_64 0:4.0-7.el6.centos
redhat-lsb-printing.x86_64 0:4.0-7.el6.centos
sysstat.x86_64 0:9.0.4-22.el6
Complete!
[root@centos6 hogehoge]# rpm -qa | grep mysql
[root@centos6 hogehoge]#
きれいさっぱりなくなりました。
で、MariaDBのインストールに取りかかる。
まず最初に、RPG-GPG-KEYを追加する
[root@centos6 hogehoge]# sudo rpm --import https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
次に、リポジトリを追加作業を実施。
今回はバージョン10.0.12にトライ!
[root@centos6 hogehoge]# vi /etc/yum.repos.d/MariaDB.repo
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.0.12/centos6-x86
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
enabled=1
リポジトリの追加作業が終わったら、インストールを実行。
[root@centos6 hogehoge]# yum install MariaDB-devel MariaDB-client MariaDB-server
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
* base: www.ftp.ne.jp
* extras: www.ftp.ne.jp
* updates: www.ftp.ne.jp
mariadb | 1.9 kB 00:00
mariadb/primary_db | 18 kB 00:00
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package MariaDB-client.i686 0:10.0.12-1.el6 will be installed
--> Processing Dependency: MariaDB-common for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libtinfo.so.5 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libcrypt.so.1 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libdl.so.2(GLIBC_2.0) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libcrypt.so.1(GLIBC_2.0) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: ld-linux.so.2 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libpthread.so.0(GLIBC_2.3.2) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libc.so.6(GLIBC_2.3.3) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libm.so.6(GLIBC_2.0) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libaio.so.1 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: librt.so.1(GLIBC_2.2) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libstdc++.so.6 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libc.so.6(GLIBC_2.2) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libm.so.6 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libc.so.6(GLIBC_2.0) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: librt.so.1 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libm.so.6(GLIBC_2.1) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libdl.so.2 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libpthread.so.0(GLIBC_2.2) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libpthread.so.0 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libc.so.6(GLIBC_2.3) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libaio.so.1(LIBAIO_0.4) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libstdc++.so.6(GLIBCXX_3.4) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libaio.so.1(LIBAIO_0.1) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libc.so.6(GLIBC_2.1.3) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libpthread.so.0(GLIBC_2.1) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libncurses.so.5 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: ld-linux.so.2(GLIBC_2.3) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libcrypto.so.10 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libstdc++.so.6(CXXABI_1.3) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libpthread.so.0(GLIBC_2.0) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libdl.so.2(GLIBC_2.1) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libc.so.6 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libssl.so.10 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libz.so.1 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libm.so.6(GLIBC_2.2) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libc.so.6(GLIBC_2.1) for package: MariaDB-client-10.0.12-1.el6.i686
---> Package MariaDB-devel.i686 0:10.0.12-1.el6 will be installed
---> Package MariaDB-server.i686 0:10.0.12-1.el6 will be installed
--> Processing Dependency: libpam.so.0(LIBPAM_1.0) for package: MariaDB-server-10.0.12-1.el6.i686
--> Processing Dependency: libpam.so.0 for package: MariaDB-server-10.0.12-1.el6.i686
--> Running transaction check
---> Package MariaDB-common.i686 0:10.0.12-1.el6 will be installed
--> Processing Dependency: MariaDB-compat for package: MariaDB-common-10.0.12-1.el6.i686
---> Package glibc.i686 0:2.12-1.132.el6_5.2 will be installed
--> Processing Dependency: libfreebl3.so(NSSRAWHASH_3.12.3) for package: glibc-2.12-1.132.el6_5.2.i686
--> Processing Dependency: libfreebl3.so for package: glibc-2.12-1.132.el6_5.2.i686
---> Package libaio.i686 0:0.3.107-10.el6 will be installed
---> Package libstdc++.i686 0:4.4.7-4.el6 will be installed
--> Processing Dependency: libgcc_s.so.1(GLIBC_2.0) for package: libstdc++-4.4.7-4.el6.i686
--> Processing Dependency: libgcc_s.so.1(GCC_4.2.0) for package: libstdc++-4.4.7-4.el6.i686
--> Processing Dependency: libgcc_s.so.1(GCC_3.3) for package: libstdc++-4.4.7-4.el6.i686
--> Processing Dependency: libgcc_s.so.1(GCC_3.0) for package: libstdc++-4.4.7-4.el6.i686
--> Processing Dependency: libgcc_s.so.1 for package: libstdc++-4.4.7-4.el6.i686
---> Package ncurses-libs.i686 0:5.7-3.20090208.el6 will be installed
---> Package openssl.i686 0:1.0.1e-16.el6_5.14 will be installed
--> Processing Dependency: libkrb5.so.3(krb5_3_MIT) for package: openssl-1.0.1e-16.el6_5.14.i686
--> Processing Dependency: libkrb5.so.3 for package: openssl-1.0.1e-16.el6_5.14.i686
--> Processing Dependency: libk5crypto.so.3(k5crypto_3_MIT) for package: openssl-1.0.1e-16.el6_5.14.i686
--> Processing Dependency: libk5crypto.so.3 for package: openssl-1.0.1e-16.el6_5.14.i686
--> Processing Dependency: libgssapi_krb5.so.2 for package: openssl-1.0.1e-16.el6_5.14.i686
--> Processing Dependency: libcom_err.so.2 for package: openssl-1.0.1e-16.el6_5.14.i686
---> Package pam.i686 0:1.1.1-17.el6 will be installed
--> Processing Dependency: libselinux.so.1 for package: pam-1.1.1-17.el6.i686
--> Processing Dependency: libdb-4.7.so for package: pam-1.1.1-17.el6.i686
--> Processing Dependency: libcrack.so.2 for package: pam-1.1.1-17.el6.i686
--> Processing Dependency: libaudit.so.1 for package: pam-1.1.1-17.el6.i686
---> Package zlib.i686 0:1.2.3-29.el6 will be installed
--> Running transaction check
---> Package MariaDB-compat.i686 0:10.0.12-1.el6 will be installed
---> Package audit-libs.i686 0:2.2-4.el6_5 will be installed
---> Package cracklib.i686 0:2.8.16-4.el6 will be installed
---> Package db4.i686 0:4.7.25-18.el6_4 will be installed
---> Package krb5-libs.i686 0:1.10.3-15.el6_5.1 will be installed
--> Processing Dependency: libkeyutils.so.1(KEYUTILS_0.3) for package: krb5-libs-1.10.3-15.el6_5.1.i686
--> Processing Dependency: libkeyutils.so.1 for package: krb5-libs-1.10.3-15.el6_5.1.i686
---> Package libcom_err.i686 0:1.41.12-18.el6 will be installed
---> Package libgcc.i686 0:4.4.7-4.el6 will be installed
---> Package libselinux.i686 0:2.0.94-5.3.el6_4.1 will be installed
---> Package nss-softokn-freebl.i686 0:3.14.3-10.el6_5 will be installed
--> Running transaction check
---> Package keyutils-libs.i686 0:1.4-4.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
MariaDB-client i686 10.0.12-1.el6 mariadb 11 M
MariaDB-devel i686 10.0.12-1.el6 mariadb 6.4 M
MariaDB-server i686 10.0.12-1.el6 mariadb 40 M
Installing for dependencies:
MariaDB-common i686 10.0.12-1.el6 mariadb 23 k
MariaDB-compat i686 10.0.12-1.el6 mariadb 2.6 M
audit-libs i686 2.2-4.el6_5 updates 61 k
cracklib i686 2.8.16-4.el6 base 70 k
db4 i686 4.7.25-18.el6_4 base 580 k
glibc i686 2.12-1.132.el6_5.2 updates 4.3 M
keyutils-libs i686 1.4-4.el6 base 20 k
krb5-libs i686 1.10.3-15.el6_5.1 updates 769 k
libaio i686 0.3.107-10.el6 base 21 k
libcom_err i686 1.41.12-18.el6 base 37 k
libgcc i686 4.4.7-4.el6 base 112 k
libselinux i686 2.0.94-5.3.el6_4.1 base 108 k
libstdc++ i686 4.4.7-4.el6 base 300 k
ncurses-libs i686 5.7-3.20090208.el6 base 251 k
nss-softokn-freebl i686 3.14.3-10.el6_5 updates 147 k
openssl i686 1.0.1e-16.el6_5.14 updates 1.5 M
pam i686 1.1.1-17.el6 base 659 k
zlib i686 1.2.3-29.el6 base 73 k
Transaction Summary
================================================================================
Install 21 Package(s)
Total download size: 69 M
Installed size: 264 M
Is this ok [y/N]: y
Downloading Packages:
(1/21): MariaDB-10.0.12-centos6-i686-client.rpm | 11 MB 00:23
(2/21): MariaDB-10.0.12-centos6-i686-common.rpm | 23 kB 00:00
(3/21): MariaDB-10.0.12-centos6-i686-compat.rpm | 2.6 MB 00:07
(4/21): MariaDB-10.0.12-centos6-i686-devel.rpm | 6.4 MB 00:28
(5/21): MariaDB-10.0.12-centos6-i686-server.rpm | 40 MB 03:40
(6/21): audit-libs-2.2-4.el6_5.i686.rpm | 61 kB 00:00
(7/21): cracklib-2.8.16-4.el6.i686.rpm | 70 kB 00:00
(8/21): db4-4.7.25-18.el6_4.i686.rpm | 580 kB 00:01
(9/21): glibc-2.12-1.132.el6_5.2.i686.rpm | 4.3 MB 00:10
(10/21): keyutils-libs-1.4-4.el6.i686.rpm | 20 kB 00:00
(11/21): krb5-libs-1.10.3-15.el6_5.1.i686.rpm | 769 kB 00:02
(12/21): libaio-0.3.107-10.el6.i686.rpm | 21 kB 00:00
(13/21): libcom_err-1.41.12-18.el6.i686.rpm | 37 kB 00:00
(14/21): libgcc-4.4.7-4.el6.i686.rpm | 112 kB 00:00
(15/21): libselinux-2.0.94-5.3.el6_4.1.i686.rpm | 108 kB 00:00
(16/21): libstdc++-4.4.7-4.el6.i686.rpm | 300 kB 00:00
(17/21): ncurses-libs-5.7-3.20090208.el6.i686.rpm | 251 kB 00:00
(18/21): nss-softokn-freebl-3.14.3-10.el6_5.i686.rpm | 147 kB 00:00
(19/21): openssl-1.0.1e-16.el6_5.14.i686.rpm | 1.5 MB 00:04
(20/21): pam-1.1.1-17.el6.i686.rpm | 659 kB 00:02
(21/21): zlib-1.2.3-29.el6.i686.rpm | 73 kB 00:00
--------------------------------------------------------------------------------
Total 228 kB/s | 69 MB 05:07
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : libgcc-4.4.7-4.el6.i686 1/21
Installing : glibc-2.12-1.132.el6_5.2.i686 2/21
Installing : nss-softokn-freebl-3.14.3-10.el6_5.i686 3/21
Installing : zlib-1.2.3-29.el6.i686 4/21
Installing : libstdc++-4.4.7-4.el6.i686 5/21
Installing : libselinux-2.0.94-5.3.el6_4.1.i686 6/21
Installing : libcom_err-1.41.12-18.el6.i686 7/21
Installing : libaio-0.3.107-10.el6.i686 8/21
Installing : MariaDB-compat-10.0.12-1.el6.i686 9/21
Installing : MariaDB-common-10.0.12-1.el6.i686 10/21
Installing : cracklib-2.8.16-4.el6.i686 11/21
Installing : keyutils-libs-1.4-4.el6.i686 12/21
Installing : krb5-libs-1.10.3-15.el6_5.1.i686 13/21
Installing : openssl-1.0.1e-16.el6_5.14.i686 14/21
Installing : audit-libs-2.2-4.el6_5.i686 15/21
Installing : ncurses-libs-5.7-3.20090208.el6.i686 16/21
Installing : MariaDB-client-10.0.12-1.el6.i686 17/21
Installing : db4-4.7.25-18.el6_4.i686 18/21
Installing : MariaDB-devel-10.0.12-1.el6.i686 19/21
Installing : pam-1.1.1-17.el6.i686 20/21
Installing : MariaDB-server-10.0.12-1.el6.i686 21/21
chown: cannot access `/var/lib/mysql': そのようなファイルやディレクトリはありません
140720 20:42:53 [Note] InnoDB: Using mutexes to ref count buffer pool pages
140720 20:42:53 [Note] InnoDB: The InnoDB memory heap is disabled
140720 20:42:53 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
140720 20:42:53 [Note] InnoDB: Compressed tables use zlib 1.2.3
140720 20:42:53 [Note] InnoDB: Using Linux native AIO
140720 20:42:53 [Note] InnoDB: Not using CPU crc32 instructions
140720 20:42:53 [Note] InnoDB: Initializing buffer pool, size = 128.0M
140720 20:42:53 [Note] InnoDB: Completed initialization of buffer pool
140720 20:42:53 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
140720 20:42:53 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
140720 20:42:53 [Note] InnoDB: Database physically writes the file full: wait...
140720 20:42:53 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
140720 20:42:54 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
140720 20:42:54 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
140720 20:42:54 [Warning] InnoDB: New log files created, LSN=45781
140720 20:42:54 [Note] InnoDB: Doublewrite buffer not found: creating new
140720 20:42:54 [Note] InnoDB: Doublewrite buffer created
140720 20:42:54 [Note] InnoDB: 128 rollback segment(s) are active.
140720 20:42:54 [Warning] InnoDB: Creating foreign key constraint system tables.
140720 20:42:54 [Note] InnoDB: Foreign key constraint system tables created
140720 20:42:54 [Note] InnoDB: Creating tablespace and datafile system tables.
140720 20:42:54 [Note] InnoDB: Tablespace and datafile system tables created.
140720 20:42:54 [Note] InnoDB: Waiting for purge to start
140720 20:42:54 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.17-65.0 started; log sequence number 0
140720 20:42:55 [Note] InnoDB: FTS optimize thread exiting.
140720 20:42:55 [Note] InnoDB: Starting shutdown...
140720 20:42:57 [Note] InnoDB: Shutdown completed; log sequence number 1616697
140720 20:42:57 [Note] InnoDB: Using mutexes to ref count buffer pool pages
140720 20:42:57 [Note] InnoDB: The InnoDB memory heap is disabled
140720 20:42:57 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
140720 20:42:57 [Note] InnoDB: Compressed tables use zlib 1.2.3
140720 20:42:57 [Note] InnoDB: Using Linux native AIO
140720 20:42:57 [Note] InnoDB: Not using CPU crc32 instructions
140720 20:42:57 [Note] InnoDB: Initializing buffer pool, size = 128.0M
140720 20:42:57 [Note] InnoDB: Completed initialization of buffer pool
140720 20:42:57 [Note] InnoDB: Highest supported file format is Barracuda.
140720 20:42:57 [Note] InnoDB: 128 rollback segment(s) are active.
140720 20:42:57 [Note] InnoDB: Waiting for purge to start
140720 20:42:57 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.17-65.0 started; log sequence number 1616697
140720 20:42:57 [Note] InnoDB: FTS optimize thread exiting.
140720 20:42:57 [Note] InnoDB: Starting shutdown...
140720 20:42:59 [Note] InnoDB: Shutdown completed; log sequence number 1616707
PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following commands:
'/usr/bin/mysqladmin' -u root password 'new-password'
'/usr/bin/mysqladmin' -u root -h centos6.5 password 'new-password'
Alternatively you can run:
'/usr/bin/mysql_secure_installation'
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the MariaDB Knowledgebase at http://mariadb.com/kb or the
MySQL manual for more instructions.
Please report any problems at http://mariadb.org/jira
The latest information about MariaDB is available at http://mariadb.org/.
You can find additional information about the MySQL part at:
http://dev.mysql.com
Support MariaDB development by buying support/new features from
SkySQL Ab. You can contact us about this at sales@skysql.com.
Alternatively consider joining our community based development effort:
http://mariadb.com/kb/en/contributing-to-the-mariadb-project/
Verifying : cracklib-2.8.16-4.el6.i686 1/21
Verifying : libstdc++-4.4.7-4.el6.i686 2/21
Verifying : MariaDB-client-10.0.12-1.el6.i686 3/21
Verifying : MariaDB-common-10.0.12-1.el6.i686 4/21
Verifying : libselinux-2.0.94-5.3.el6_4.1.i686 5/21
Verifying : libcom_err-1.41.12-18.el6.i686 6/21
Verifying : nss-softokn-freebl-3.14.3-10.el6_5.i686 7/21
Verifying : MariaDB-devel-10.0.12-1.el6.i686 8/21
Verifying : keyutils-libs-1.4-4.el6.i686 9/21
Verifying : libgcc-4.4.7-4.el6.i686 10/21
Verifying : audit-libs-2.2-4.el6_5.i686 11/21
Verifying : ncurses-libs-5.7-3.20090208.el6.i686 12/21
Verifying : libaio-0.3.107-10.el6.i686 13/21
Verifying : MariaDB-server-10.0.12-1.el6.i686 14/21
Verifying : MariaDB-compat-10.0.12-1.el6.i686 15/21
Verifying : pam-1.1.1-17.el6.i686 16/21
Verifying : db4-4.7.25-18.el6_4.i686 17/21
Verifying : openssl-1.0.1e-16.el6_5.14.i686 18/21
Verifying : krb5-libs-1.10.3-15.el6_5.1.i686 19/21
Verifying : glibc-2.12-1.132.el6_5.2.i686 20/21
Verifying : zlib-1.2.3-29.el6.i686 21/21
Installed:
MariaDB-client.i686 0:10.0.12-1.el6 MariaDB-devel.i686 0:10.0.12-1.el6
MariaDB-server.i686 0:10.0.12-1.el6
Dependency Installed:
MariaDB-common.i686 0:10.0.12-1.el6
MariaDB-compat.i686 0:10.0.12-1.el6
audit-libs.i686 0:2.2-4.el6_5
cracklib.i686 0:2.8.16-4.el6
db4.i686 0:4.7.25-18.el6_4
glibc.i686 0:2.12-1.132.el6_5.2
keyutils-libs.i686 0:1.4-4.el6
krb5-libs.i686 0:1.10.3-15.el6_5.1
libaio.i686 0:0.3.107-10.el6
libcom_err.i686 0:1.41.12-18.el6
libgcc.i686 0:4.4.7-4.el6
libselinux.i686 0:2.0.94-5.3.el6_4.1
libstdc++.i686 0:4.4.7-4.el6
ncurses-libs.i686 0:5.7-3.20090208.el6
nss-softokn-freebl.i686 0:3.14.3-10.el6_5
openssl.i686 0:1.0.1e-16.el6_5.14
pam.i686 0:1.1.1-17.el6
zlib.i686 0:1.2.3-29.el6
Complete!
で、MariaDB関連のインストールは終わったらしい。
バージョンを確認してみると。
[root@centos6 /]# mysqld --version
mysqld Ver 10.0.12-MariaDB for Linux on i686 (MariaDB Server)
MySQLでありながらMariaDBという、この気持ち悪さはなんなんだ!? (^^;
で、MariaDBを起動させる。
[root@centos6 /]# sudo service mysql start
Starting MySQL. SUCCESS!
ついでに、CentOS6.5起動時にMariaDBを自動起動するためのまじないも。
[root@centos6 /]# sudo chkconfig mysql on
じゃ、動作確認してみますか.
[hogehoge@centos6 ~]$ mysql -u root
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 10.0.12-MariaDB MariaDB Server
Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
rootのパスワードを変更しておこう。
MariaDB [(none)]> SET PASSWORD for root@localhost=PASSWORD('hogehoge');
Query OK, 0 rows affected (0.04 sec)
これでrootのパスワードが設定された。
MariaDBのインストールはここまで。