ラベル MySQL の投稿を表示しています。 すべての投稿を表示
ラベル MySQL の投稿を表示しています。 すべての投稿を表示

2010年5月17日月曜日

CentOS 5.5 Upgrade Install MEMO

1. Mware Playre の起動が速すぎて F2 キーを押しても BIOS Setup とならなかったため、CentOS 5.4 をシャットダウンしてから次の手順を実施して DVD から起動した。

 1.1 vmx ファイルの最後に次の1行を追加する。

bios.forceSetupOnce = "TRUE"

 1.2 [VM]->[設定] で "CD/DVD(IDE)" を選択して

 - 「デバイスのステータス」の「起動時に接続」をチェックする。
 - 「接続」の「ISO イメージファイル…」に ISO ファイルを指定する。

2. CentOS 5.5 DVD からブートしてアップグレード

CenOS 5.3 Upgrade Install MEMO 参照。
http://isneophyte.blogspot.com/search/label/CentOS%205.3

3. MySQL の起動失敗

 原因はバージョンが混在。

Installed Packages
mysql.i386 5.0.77-4.el5_4.2 installed
mysql-devel.i386 5.1.41-1.el5.remi installed
mysql-libs.i386 5.1.41-1.el5.remi installed
mysql-server.i386 5.1.41-1.el5.remi installed
mysql-test.i386 5.1.41-1.el5.remi installed
mysqlclient15.i386 5.0.67-1.el5.remi installed

4. パッケージアップデーターにて MySQL と PHP の更新パッケージをインストール。

MySQL 5.1.46
PHP 5.3.2

5. 各ソフトウェアのバージョン確認

# mysql
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2Server version: 5.1.46 MySQL Community Server (GPL) by Remi

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

# php -v
PHP 5.3.2 (cli) (built: Apr 27 2010 20:28:18)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies

2009年12月2日水曜日

CentOS 5.4 上の MySQL と php をアップデート

 CentOS 5.4 上で php の 5.3 系を利用する必要があったので、アップデートを試みた。

1. yum にプロキシ設定
 /etc/yum.conf に proxy, proxy_username, proxy_password を追記した。

2. レポジトリ情報を追加
# wget http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-3.noarch.rpm
# wget http://dag.wieers.com/rpm/packages/rpmforge-release/rpmforge-release-0.3.6-1.el5.rf.i386.rpm
# wget http://rpms.famillecollet.com/el5.i386/remi-release-5-6.el5.remi.noarch.rpm
# rpm -Uvh remi-release-5*.rpm epel-release-5*.rpm

3. php パッケージの確認
# yum --enablerepo remi list php*
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* epel: ftp.iij.ad.jp
* remi: iut-info.univ-reims.fr
* rpmforge: apt.sw.be
Installed Packages
php.i386 5.1.6-23.2.el5_3 installed
php-cli.i386 5.1.6-23.2.el5_3 installed
php-common.i386 5.1.6-23.2.el5_3 installed
php-mbstring.i386 5.1.6-23.2.el5_3 installed
php-mysql.i386 5.1.6-23.2.el5_3 installed
php-pdo.i386 5.1.6-23.2.el5_3 installed
Available Packages
php.i386 5.3.1-1.el5.remi remi
php-IDNA_Convert.noarch 0.6.3-2.el5 epel
...

 php 5.3.1 発見!

4. php パッケージの更新
# yum update php -y
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* epel: ftp.iij.ad.jp
* remi: iut-info.univ-reims.fr
* rpmforge: apt.sw.be
Setting up Update Process
Resolving Dependencies
--> Running transaction check
...
Dependencies Resolved

================================================================================
Package Arch Version Repository Size
================================================================================
Updating:
php i386 5.3.1-1.el5.remi remi 1.3 M
Installing for dependencies:
libedit i386 2.11-2.20080712cvs.el5 epel 79 k
mysql-libs i386 5.1.41-1.el5.remi remi 2.1 M
sqlite2 i386 2.8.17-2.el5.remi remi 170 k
Updating for dependencies:
php-cli i386 5.3.1-1.el5.remi remi 2.5 M
php-common i386 5.3.1-1.el5.remi remi 945 k
php-mbstring i386 5.3.1-1.el5.remi remi 2.1 M
php-mysql i386 5.3.1-1.el5.remi remi 140 k
php-pdo i386 5.3.1-1.el5.remi remi 162 k

Transaction Summary
================================================================================
Install 3 Package(s)
Update 6 Package(s)
Remove 0 Package(s)

Total download size: 9.5 M
Downloading Packages:
(1/9): libedit-2.11-2.20080712cvs.el5.i386.rpm 79 kB 00:00
(2/9): php-mysql-5.3.1-1.el5.remi.i386.rpm 140 kB 00:00
(3/9): php-pdo-5.3.1-1.el5.remi.i386.rpm 162 kB 00:01
(4/9): sqlite2-2.8.17-2.el5.remi.i386.rpm 170 kB 00:02
(5/9): php-common-5.3.1-1.el5.remi.i386.rpm 945 kB 00:05
(6/9): php-5.3.1-1.el5.remi.i386.rpm 1.3 MB 00:02
(7/9): php-mbstring-5.3.1-1.el5.remi.i386.rpm 2.1 MB 00:00
(8/9): mysql-libs-5.1.41-1.el5.remi.i386.rpm 2.1 MB 00:03
(9/9): php-cli-5.3.1-1.el5.remi.i386.rpm 2.5 MB 00:04
--------------------------------------------------------------------------------
Total 243 kB/s 9.5 MB 00:39

Running rpm_check_debug
Running Transaction Test
Finished Transaction Test


Transaction Check Error:
file /etc/my.cnf from install of mysql-libs-5.1.41-1.el5.remi.i386 conflicts with file from package mysql-5.0.77-3.el5.i386
...
Error Summary
-------------

 MySQL もアップデートしなくてはいけないようだと分かった。

5. MySQL パッケージの確認
# yum --enablerepo remi list mysql*
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* epel: ftp.iij.ad.jp
* remi: iut-info.univ-reims.fr
* rpmforge: apt.sw.be
Installed Packages
mysql.i386 5.0.77-3.el5 installed
mysql-devel.i386 5.0.77-3.el5 installed
mysql-server.i386 5.0.77-3.el5 installed
mysql-test.i386 5.0.77-3.el5 installed
Available Packages
MySQL-zrm.noarch 2.1.1-5.el5 epel
mysql.i386 5.1.41-1.el5.remi remi
mysql++.i386 3.0.9-1.el5.remi remi
mysql++-devel.i386 3.0.9-1.el5.remi remi
mysql++-manuals.i386 3.0.9-1.el5.remi remi
mysql-bench.i386 5.1.41-1.el5.remi remi
mysql-cluster.i386 5.1.41-1.el5.remi remi
mysql-devel.i386 5.1.41-1.el5.remi remi
mysql-embedded.i386 5.1.41-1.el5.remi remi
mysql-embedded-devel.i386 5.1.41-1.el5.remi remi
mysql-libs.i386 5.1.41-1.el5.remi remi
mysql-manual.i386 5.1.38-1.el5.remi remi
mysql-proxy.i386 0.5.1-1.el5 epel
mysql-server.i386 5.1.41-1.el5.remi remi
mysql-test.i386 5.1.41-1.el5.remi remi
mysqlclient15.i386 5.0.67-1.el5.remi remi
mysqlclient15-devel.i386 5.0.67-1.el5.remi remi
mysqlclient16.i386 5.1.30-1.el5.remi remi-test
mysqlclient16-devel.i386 5.1.30-1.el5.remi remi-test
mysqlreport.noarch 3.5-2.el5 epel
mysqltuner.noarch 0.9.8-2.el5 epel

 MySQL 5.1.41 を発見!

6. MySQL パッケージの更新
# yum update mysql -y
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* epel: ftp.iij.ad.jp
* remi: iut-info.univ-reims.fr
* rpmforge: apt.sw.be
Setting up Update Process
Resolving Dependencies
--> Running transaction check
...
Dependencies Resolved

================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
perl-DBD-mysql i386 4.012-1.el5.rf rpmforge 224 k
replacing perl-DBD-MySQL.i386 3.0007-2.el5

Updating:
mysql i386 5.1.41-1.el5.remi remi 3.9 M
Installing for dependencies:
libedit i386 2.11-2.20080712cvs.el5 epel 79 k
mysql-libs i386 5.1.41-1.el5.remi remi 2.1 M
mysqlclient15 i386 5.0.67-1.el5.remi remi 1.3 M
sqlite2 i386 2.8.17-2.el5.remi remi 170 k
Updating for dependencies:
mysql-devel i386 5.1.41-1.el5.remi remi 3.2 M
mysql-server i386 5.1.41-1.el5.remi remi 11 M
mysql-test i386 5.1.41-1.el5.remi remi 5.9 M
php i386 5.3.1-1.el5.remi remi 1.3 M
php-cli i386 5.3.1-1.el5.remi remi 2.5 M
php-common i386 5.3.1-1.el5.remi remi 945 k
php-mbstring i386 5.3.1-1.el5.remi remi 2.1 M
php-mysql i386 5.3.1-1.el5.remi remi 140 k
php-pdo i386 5.3.1-1.el5.remi remi 162 k

Transaction Summary
================================================================================
Install 5 Package(s)
Update 10 Package(s)
Remove 0 Package(s)

Total size: 35 M
Total download size: 26 M
Downloading Packages:
(1/6): perl-DBD-mysql-4.012-1.el5.rf.i386.rpm 224 kB 00:01
(2/6): mysqlclient15-5.0.67-1.el5.remi.i386.rpm 1.3 MB 38:35
(3/6): mysql-devel-5.1.41-1.el5.remi.i386.rpm 3.2 MB 00:40
(4/6): mysql-5.1.41-1.el5.remi.i386.rpm 3.9 MB 00:35
(5/6): mysql-test-5.1.41-1.el5.remi.i386.rpm 5.9 MB 00:58
(6/6): mysql-server-5.1.41-1.el5.remi.i386.rpm 11 MB 01:57
...
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : mysqlclient15 1/26

WARNING : This php-* RPM are not official Fedora build and
overrides the official ones. Don't file bugs on Fedora Project.

Use dedicated forums http://forums.famillecollet.com/

Updating : php-common 2/26
warning: /etc/php.ini created as /etc/php.ini.rpmnew

WARNING : This MySQL RPM is not an official Fedora build and it
overrides the official one. Don't file bugs on Fedora Project.
Use dedicated forums http://forums.famillecollet.com/

Installing : mysql-libs 3/26
Updating : mysql 4/26
Installing : perl-DBD-mysql 5/26
Updating : mysql-server 6/26
Installing : libedit 7/26
Updating : php-cli 8/26
Installing : sqlite2 9/26
Updating : php-pdo 10/26
Updating : mysql-test 11/26
Updating : php 12/26
Updating : php-mbstring 13/26
Updating : mysql-devel 14/26
Updating : php-mysql 15/26
Cleanup : mysql-test 16/26
Cleanup : php 17/26
Cleanup : mysql-server 18/26
Cleanup : php-mbstring 19/26
Erasing : perl-DBD-MySQL 20/26
Cleanup : mysql-devel 21/26
Cleanup : mysql 22/26
Cleanup : php-pdo 23/26
Cleanup : php-common 24/26
Cleanup : php-cli 25/26
Cleanup : php-mysql 26/26

Installed:
perl-DBD-mysql.i386 0:4.012-1.el5.rf

Dependency Installed:
libedit.i386 0:2.11-2.20080712cvs.el5 mysql-libs.i386 0:5.1.41-1.el5.remi
mysqlclient15.i386 0:5.0.67-1.el5.remi sqlite2.i386 0:2.8.17-2.el5.remi

Updated:
mysql.i386 0:5.1.41-1.el5.remi

Dependency Updated:
mysql-devel.i386 0:5.1.41-1.el5.remi mysql-server.i386 0:5.1.41-1.el5.remi
mysql-test.i386 0:5.1.41-1.el5.remi php.i386 0:5.3.1-1.el5.remi
php-cli.i386 0:5.3.1-1.el5.remi php-common.i386 0:5.3.1-1.el5.remi
php-mbstring.i386 0:5.3.1-1.el5.remi php-mysql.i386 0:5.3.1-1.el5.remi
php-pdo.i386 0:5.3.1-1.el5.remi

Replaced:
perl-DBD-MySQL.i386 0:3.0007-2.el5

Complete!

 php と MySQL が同時にインストールされたようだ。

7. 更新の確認
# php -v
PHP 5.3.1 (cli) (built: Nov 20 2009 17:51:14)
Copyright (c) 1997-2009 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2009 Zend Technologies

# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.1.41 MySQL Community Server (GPL) by Remi

 既存サービスが動作することを確認できた。