CentOSの初期設定
別途、利用することになったCentOS5.3にて。
ruby関係は、他のマシンとの兼ね合いがあるので、いろいろとバージョンを合わせて設定する。
CentOSのアプリケーションの実行ファイルは /usr/bin だよ。
脳の容量が少ないから、こんがらがるなぁ…。
ダウンロードして解凍して、それぞれインストール。インストール後にバージョン確認。
# wget ftp://ftp.ruby-lang.org/pub/ruby/1.8/ruby-1.8.7-p72.tar.gz
# cd ruby-1.8.7-p72
# ./configure --prefix=/usr
# make
# make install
# ruby -v
ruby 1.8.7 (2008-08-11 patchlevel 72) [x86_64-linux]
# wget http://rubyforge.org/frs/download.php/60718/rubygems-1.3.5.tgz
# cd rubygems-1.3.5
# ruby setup.rb
# gem -v
1.3.5
# gem install rails --version 2.2.2
# gem install rake
yumを使えるようにしよう
実は、今回のターゲットCentOSサーバは、使えるネットさんのサーバなんで、初期ではyumが入ってないんですね。
私は、一度楽な方法に慣れてしまうと、楽なほうに流されてしまう…という弱い生き物。ということで、開き直って、まずはyumをいれます。
参照サイトはここ。 http://centos.bungu-do.jp/2008/05/vpsyum.html
私の環境は、CentOS 5.3 x86_64 なので適宜読み替え、リケンからＤＬしてくる。
# wget http://ftp.riken.jp/Linux/centos/5.3/os/x86_64/CentOS/yum-3.2.19-18.el5.centos.noarch.rpm
# wget http://ftp.riken.jp/Linux/centos/5.3/os/x86_64/CentOS/yum-metadata-parser-1.1.2-2.el5.x86_64.rpm
# wget http://ftp.riken.jp/Linux/centos/5.3/os/x86_64/CentOS/python-elementtree-1.2.6-5.x86_64.rpm
# wget http://ftp.riken.jp/Linux/centos/5.3/os/x86_64/CentOS/python-urlgrabber-3.1.0-5.el5.noarch.rpm
# wget http://ftp.riken.jp/Linux/centos/5.3/os/x86_64/CentOS/python-sqlite-1.1.7-1.2.1.x86_64.rpm
# wget http://ftp.riken.jp/Linux/centos/5.3/os/x86_64/CentOS/m2crypto-0.16-6.el5.3.x86_64.rpm
# wget http://ftp.riken.jp/Linux/centos/5.3/os/x86_64/CentOS/yum-fastestmirror-1.1.16-13.el5.centos.noarch.rpm
# wget http://ftp.riken.jp/Linux/centos/5.3/os/x86_64/CentOS/python-iniparse-0.2.3-4.el5.noarch.rpm
# rpm -ihv *
mysqlのrootパスワード忘れ対処
折角入れたyumであるが、所望のバージョン指定ができないようなので手動で入れる。
公式サイトからrpmを取ってきて入れるのだが。。。
ええと、その前に。。。mysqlのrootパスワードを忘れてしまった場合の対処法をメモ。
パスワードなしで起動するようオプション指定して、本体のmysqld_safeを直接起動する。
# /etc/init.d/mysqld stop
# /usr/bin/mysqld_safe --user=root --skip-grant-tables &
この状態で、別のクライアントからrootでログイン。
# mysql -u root
mysql> use mysql;
mysql> show tables;
mysql> select host, User, Password from user;
- +
host User Password
- +
localhost horde 1xxxxxxxxxxxxxxx localhost pma_Sb3G2R4O9es5 6xxxxxxxxxxxxxxx localhost admin 0xxxxxxxxxxxxxxx
- +
3 rows in set (0.00 sec)
あれ？rootという管理者がいない。
余談だが、rootのパスワードを忘れた場合は、このままの状態で以下のコマンドで変更する。
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('hogepasswd');
話を元に戻して。rootがいないので改めて作っておく。一旦、--skip-grant-tables optionを辞めて、通常でログインしrootを作り全権を与える。
mysql> create user root identified by 'hogerootpasswd';
Query OK, 0 rows affected (0.01 sec)
mysql> grant all on *.* to root;
Query OK, 0 rows affected (0.00 sec)
mysql> use mysql;
mysql> select host, User,Password from user;
- +
host User Password
- +
......... ............ ..........
% root 1xxxxxxxxxxxxxxx
- +
ということで、rootができた。このhostの%はすべてのホストからアクセス可能、という状態。うーん、localhostと127.0.0.1に変えておくか。
MySQLを5.0 から 5.1へ
さて、やっと本来の目的に戻り、mysqlを5.0→5.1にする。
まず、mysqlを止め、削除する。
# /etc/init.d/mysqld stop
# yum remove mysql mysql-server
........
================================================================================
Package Arch Version Repository
Size
================================================================================
Removing:
mysql x86_64 5.0.45-7.el5 installed 7.5 M
mysql-server x86_64 5.0.45-7.el5 installed 22 M
Removing for dependencies:
SSHTerm noarch 0.2.2-cos5.build86080722.00 installed 4.9 M
drweb-qmail x86_64 4.33-cos5.build86080722.00 installed 1.3 M
perl-DBD-MySQL x86_64 3.0007-2.el5 installed 328 k
php-mysql x86_64 5.1.6-23.2.el5_3 installed 196 k
psa x86_64 8.6.0-cos5.build86080722.00 installed 60 M
psa-api noarch 8.6.0-cos5.build86080930.03 installed 4.3 M
psa-api-rpc noarch 8.6.0-cos5.build86080930.03 installed 1.2 M
psa-appvault-advancedpoll noarch 2.03-8203720080409005333 installed 1.3 M
psa-appvault-anyinventory noarch 2.0-8202820080409005337 installed 1.7 M
psa-appvault-articlepublisher
noarch 1.0-8200920080409005343 installed 4.1 M
psa-appvault-autoindex noarch 2.2.4-8200220080409005350 installed 1.1 M
psa-appvault-avactis noarch 1.8.1-8200720080409005405 installed 18 M
psa-appvault-b2evolution noarch 0.9.0.12-8203020080409005439
installed 11 M
psa-appvault-bbclone noarch 0.48-82025 installed 3.0 M
psa-appvault-brim noarch 2.0.0-8203120080409005520 installed 8.7 M
psa-appvault-coppermine noarch 1.4.16-8200220080409005533 installed 15 M
psa-appvault-cs-cart noarch 1.3.5-8201220080409005618 installed 42 M
psa-appvault-cslh noarch 2.14.5-8200220080409005735 installed 4.2 M
psa-appvault-cubecart noarch 4.2.0-8200220080409005750 installed 9.5 M
psa-appvault-docfaq noarch 1.71-8203720080409005800 installed 587 k
psa-appvault-dolphin noarch 6.0.0-8201020080409005813 installed 25 M
psa-appvault-drupal noarch 6.1-8200320080409005854 installed 4.9 M
psa-appvault-easybiller noarch 1.0-8200120080409013521 installed 9.5 M
psa-appvault-easysnaps noarch 2.0-8200120080409013534 installed 15 M
psa-appvault-egroupware noarch 1.4.002-8201220080409005942 installed 53 M
psa-appvault-emuwebmail noarch 7.0.1-8200720080409010123 installed 14 M
psa-appvault-eswap noarch 1.0-8200220080409013550 installed 6.6 M
psa-appvault-gallery noarch 2.2-8201720080409010331 installed 60 M
psa-appvault-geeklog noarch 1.4.1-8200320080409010751 installed 18 M
psa-appvault-gtchat noarch 0.93-8003020080409010834 installed 983 k
psa-appvault-helpcenterlive noarch 2.1.5-8200220080409010839 installed 2.6 M
psa-appvault-joomla noarch 1.0.15-8200720080409010851 installed 9.4 M
psa-appvault-knowledgetreeoss
noarch 3.4.5-8200820080409010953 installed 19 M
psa-appvault-mailer noarch 6.3-8200420080609232516 installed 14 M
psa-appvault-mambo noarch 4.6.2-8201520080409011052 installed 18 M
psa-appvault-mantis noarch 1.1.1-8200320080426054935 installed 13 M
psa-appvault-mediawiki noarch 1.11.0-8200920080409011142 installed 21 M
psa-appvault-merchant noarch 5.3-8003020080416013305 installed 7.3 M
psa-appvault-moodle noarch 1.8-8202920080409011254 installed 47 M
psa-appvault-movabletype noarch 4.0-8201520080415002955 installed 35 M
psa-appvault-multicart noarch 2.0-8200120080409013600 installed 11 M
psa-appvault-myorgbook noarch 2.8-8202720080409011528 installed 2.3 M
psa-appvault-noahclass noarch 1.3-8205520080409011532 installed 2.7 M
psa-appvault-nucleus noarch 3.21-8203220080409011537 installed 2.0 M
psa-appvault-onebiz noarch 8.0-8200120080409013714 installed 179 k
psa-appvault-openbiblio noarch 0.5-8204720080409011541 installed 4.3 M
psa-appvault-oscommerce noarch 2.2ms2-8206120080409011549 installed 4.3 M
psa-appvault-osticket noarch 1.3.0-8203320080409011555 installed 404 k
psa-appvault-owl noarch 0.80-8203620080409011601 installed 7.0 M
psa-appvault-phpads noarch 2.0.8-8203520080409011611 installed 8.5 M
psa-appvault-phpbb noarch 3.0.0-8200820080409011626 installed 12 M
psa-appvault-phpbook noarch 1.50-8203220080409011638 installed 1.1 M
psa-appvault-phpbugtracker noarch 1.19-8203820080416050605 installed 1.9 M
psa-appvault-phpdig noarch 1.85-8203120080409011645 installed 1.2 M
psa-appvault-phpmoney noarch 1.3-8204320080409011649 installed 3.6 M
psa-appvault-phpmyfamily noarch 1.4.1-8203420080409011655 installed 824 k
psa-appvault-phpmyvisites noarch 2.3-8202820080409011701 installed 7.0 M
psa-appvault-phprojekt noarch 5.2-8200820080409011713 installed 9.8 M
psa-appvault-phpsurveyor noarch 0.98-8204320080409011723 installed 2.9 M
psa-appvault-phpwebsite noarch 0.10.2-8203420080409011738 installed 15 M
psa-appvault-phpwiki noarch 1.3.11-8204320080409011808 installed 13 M
psa-appvault-pinnacle-cart noarch 3.5.2-82059720080409014951 installed 24 M
psa-appvault-plog noarch 1.0-8203620080409011828 installed 9.7 M
psa-appvault-pmachinefree noarch 2.4-8203520080409011839 installed 3.9 M
psa-appvault-postnuke noarch 0.761a-8205620080409011859 installed 14 M
psa-appvault-ray noarch 3.0.0-8201220080412085531 installed 13 M
psa-appvault-serendipity noarch 1.1.2-8203020080409011950 installed 15 M
psa-appvault-siteframe noarch 3.2.2-8202920080409012006 installed 3.8 M
psa-appvault-smf noarch 1.1.2-8203320080409012015 installed 7.8 M
psa-appvault-socialware noarch 1.0-8200120080409013622 installed 24 M
psa-appvault-ssm noarch 1.0-8203720080409012023 installed 429 k
psa-appvault-sugarcrm noarch 5.0.0-8201220080409012107 installed 45 M
psa-appvault-sugarcrmpro noarch 5.0.0-8200220080409012303 installed 58 M
psa-appvault-supportcenter noarch 2.5.2-8200820080409012450 installed 9.5 M
psa-appvault-supportdesk noarch 3.0-8200120080409013706 installed 7.3 M
psa-appvault-tellme noarch 1.2-8202720080409012523 installed 246 k
psa-appvault-tikiwiki noarch 1.9.7-8203920080409012557 installed 42 M
psa-appvault-tutos noarch 1.88-8203820080409012705 installed 5.7 M
psa-appvault-typo3 noarch 4.0-8202020080424050531 installed 27 M
psa-appvault-uebimiau noarch 2.7.8-8203720080409012807 installed 1.3 M
psa-appvault-updates noarch 8.6.0-cos5.build86080722.00 installed 0.0
psa-appvault-vivvocms noarch 4.0.0-8200720080409012815 installed 6.6 M
psa-appvault-webcalendar noarch 1.0.5-8201020080409012824 installed 3.9 M
psa-appvault-webshopmanager noarch 2.0-8203120080409012829 installed 287 k
psa-appvault-wordpress noarch 2.3.3-8200520080412062207 installed 4.2 M
psa-appvault-xoops noarch 2.2-8204820080409012846 installed 5.8 M
psa-appvault-xrms noarch 1.19-8203120080415030843 installed 11 M
psa-appvault-xtcommerce noarch 3.0.4-8200920080409012921 installed 14 M
psa-awstats-configurator noarch 1.0.0-cos5.build86080722.00 installed 0.0
psa-backup-manager x86_64 8.6.0-cos5.build86080930.03 installed 691 k
psa-backup-manager-vz x86_64 8.6.0-cos5.build86080722.00 installed 3.7 k
psa-courier-imap-add x86_64 8.6.0-cos5.build86080930.03 installed 36 k
psa-fileserver x86_64 1.0.0-cos5.build86080722.00 installed 602 k
psa-firewall x86_64 1.0.1-cos5.build86080722.00 installed 498 k
psa-horde noarch 3.1.7-cos5.build86080722.00 installed 14 M
psa-hotfix3 x86_64 8.6.0-cos5.build86080822.20 installed 242 k
psa-hotfix4-8.6.0 x86_64 8.6.0-cos5.build86080910.19 installed 389 k
psa-hotfix5-8.6.0 x86_64 8.6.0-cos5.build86080930.03 installed 36 k
psa-imp noarch 4.1.6-cos5.build86080722.00 installed 8.4 M
psa-ingo noarch 1.1.5-cos5.build86080722.00 installed 3.5 M
psa-kav i386 1.0.0-cos5.build86080722.00 installed 5.9 M
psa-kronolith noarch 2.1.8-cos5.build86080722.00 installed 4.1 M
psa-libpam-plesk x86_64 8.6.0-cos5.build86080722.00 installed 155 k
psa-locale-ja-JP noarch 8.6-build86080716.14 installed 7.2 M
psa-manual-custom-skin-guide
noarch 8.6.0-cos5.build86080722.00 installed 568 k
psa-migration-manager x86_64 8.6.0-cos5.build86080930.03 installed 7.3 M
psa-mimp noarch 1.0.2-cos5.build86080722.00 installed 1.8 M
psa-mnemo noarch 2.1.2-cos5.build86080722.00 installed 2.9 M
psa-passwd noarch 3.0.1-cos5.build86080722.00 installed 3.0 M
psa-php5-configurator noarch 1.4.0-cos5.build86080722.00 installed 0.0
psa-qmail x86_64 1.03-cos5.build86080930.03 installed 3.4 M
psa-qmail-rblsmtpd x86_64 0.70-cos5.build86080722.00 installed 38 k
psa-rubyrails-configurator x86_64 1.1.6-cos5.build86080722.00 installed 0.0
psa-sbm3 noarch 5.0-14 installed 176 k
psa-spamassassin x86_64 8.6.0-cos5.build86080722.00 installed 52 k
psa-turba noarch 2.1.7-cos5.build86080722.00 installed 4.1 M
psa-updates noarch 8.6.0-cos5.build86080930.03 installed 0.0
psa-vpn x86_64 2.0.1-cos5.build86080722.00 installed 2.1 M
psa-watchdog x86_64 2.0.3-cos5.build86080912.20 installed 2.6 M
ruby-mysql x86_64 2.7-200705221357 installed 76 k
sb-publish noarch 3.0.1-200705230938 installed 0.0Transaction Summary
================================================================================
Install 0 Package(s)
Update 0 Package(s)
Remove 123 Package(s)
依存関係を含み色々と削除された。で、本家からダウンロードしたものをインストールする。
# rpm -ivh MySQL-client-5.1.34-0.glibc23.x86_64.rpm
# rpm -ivh MySQL-debuginfo-5.1.34-0.glibc23.x86_64.rpm
# rpm -ivh MySQL-devel-5.1.34-0.glibc23.x86_64.rpm
# rpm -ivh MySQL-embedded-5.1.34-0.glibc23.x86_64.rpm
# rpm -ivh MySQL-server-5.1.34-0.glibc23.x86_64.rpm
# rpm -ivh MySQL-shared-5.1.34-0.glibc23.x86_64.rpm
# rpm -ivh MySQL-test-5.1.34-0.glibc23.x86_64.rpm
# /etc/init.d/mysqld start
