Linux/CGP作業メモ

思ったよりハマったので改めてインストール手順を書いておきます。
（SKIP1.1.0でも同じ手順で動作したのでrc2から正式版に修正しました）

CentOS5.3系へのインストール手順
※使用環境はCentOSのインストール時にServer設定でWeb/Mailサーバのみで
インストールしたものです。EPELリポジトリ追加して最新化しています。

rubyの1.8系最新安定版インストール

# cd /home/user
# mkdir download
# cd download
# wget http://core.ring.gr.jp/archives/lang/ruby/ruby-1.8.7-p160.tar.gz
# tar zxvf ruby-1.8.7-p160.tar.gz
# cd ruby-1.8.7-p160
# yum install gcc automake
# ./configure
# make
# make install
# ruby -v
ruby 1.8.7 (2009-04-08 patchlevel 160) [i686-linux]

rubygemsの最新版インストール

# cd ../
# wget http://rubyforge.org/frs/download.php/55066/rubygems-1.3.2.tgz
# tar zxvf rubygems-1.3.2.tgz
# cd rubygems-1.3.2
# ruby setup.rb

zlibサポートを追加

# yum install zlib-devel
# cd ../ruby-1.8.7-p160/ext/zlib/
# ruby extconf.rb –with-zlib-include=/usr/include –with-zlib-lib=/usr/lib
# make all
# make install

続いてopensslサポートを追加

# yum install openssl-devel
# cd ../openssl
# ruby extconf.rb
# make all
# make install

Railsと必要なものをインストール

# gem install gettext –version 1.93.0
# gem install fastercsv
# gem install ruby-openid
# gem install rails –version 2.1.2
# ln -s /usr/lib/mysql /usr/local/lib/
# gem install mysql
# gem install haml（1.1.0では不要）
# gem install json

SKIPのインストール

# cd ../
# wget http://www.openskip.org/download/release/skip-1.1.0.tar.gz
# tar zxvf skip-1.1.0.tar.gz
# cd skip-1.1.0
# cp config/initial_settings.yml.sample config/initial_settings.yml
# cp config/database.yml.sample config/database.yml

SKIP初期設定（mysqlデータベース作成含む）

# mysql -u root -p
mysql> grant all privileges on skip_production.* to skipuser@localhost identified by ‘skippasswd’;
mysql> quit

# vi config/initial_settings.yml
# vi config/database.yml
# RAILS_ENV=production rake –trace db:create
# RAILS_ENV=production rake –trace db:migrate
# RAILS_ENV=production ruby lib/create_new_admin_url.rb –code
“activation_codeを発行しました。初期管理者登録用URLは以下の通りです。”
“http://localhost:3000/admin/users/new/first?code=32dec04cc838f2f9c5788cxxxxxxxxxxxxx”

SKIP起動

# ruby ./script/server -e production

ブラウザで初期管理者登録用URLにアクセスして初期設定

(まだ評価されていません)

Loading...

CentOS5系へのインストール手順
rubyの最新安定版インストール

# cd /home/user
# mkdir download
# cd download
# wget http://core.ring.gr.jp/archives/lang/ruby/ruby-1.8.7-p72.tar.gz
# tar zxvf ruby-1.8.7-p72.tar.gz
# cd ruby-1.8.7-p72
# yum install gcc automake
# ./configure
# make
# make install
# ruby -v
ruby 1.8.7 (2008-08-11 patchlevel 72) [i686-linux]

rubygemsの最新版インストール

# cd ../
# wget http://rubyforge.org/frs/download.php/45905/rubygems-1.3.1.tgz
# tar zxvf rubygems-1.3.1.tgz
# cd rubygems-1.3.1
# ruby setup.rb

Railsと必要なものをインストール

# gem install gettext
# gem install fastercsv
# gem install ruby-openid
# gem install rspec
# gem install rails –version 2.1.2
# ln -s /usr/lib/mysql /usr/local/lib/
# gem install mysql

SKIPのインストール

# cd ../
# wget http://www.openskip.org/download/release/skip-1.0.1.tar.gz
# tar zxvf skip-1.0.1.tar.gz
# cd skip-1.0.1
# cp config/initial_settings.yml.sample config/initial_settings.yml
# cp config/database.yml.sample config/database.yml

SKIP初期設定（mysqlデータベース作成含む）

# vi config/initial_settings.yml
# vi config/database.yml
# RAILS_ENV=production rake –trace db:create
# RAILS_ENV=production rake –trace db:migrate
# ruby lib/create_new_admin_url.rb –code
“activation_codeを発行しました。初期管理者登録用URLは以下の通りです。”
“http://localhost:3000/admin/users/new/first?code=32dec04cc838f2f9c5788cxxxxxxxxxxxxx”

SKIP起動

# ruby ./script/server -e production

(まだ評価されていません)

Loading...

Ubuntu8.10へのインストール手順メモ
応答メッセージも一部表記

$ cd /home/user/

$ sudo apt-get install ruby
$ sudo apt-get install rubygems
$ sudo apt-get install libmysqlclient15-dev
$ sudo apt-get install rake

$ sudo gem update –system

$ sudo rm /usr/bin/gem
$ ln -s /usr/bin/gem1.8 /usr/bin/gem

$ sudo gem install gettext
$ sudo gem install fastercsv
$ sudo gem install ruby-openid
$ sudo gem install rspec
$ sudo gem install rails –version 2.1.2
$ sudo gem install mysql
Building native extensions. This could take a while…
Successfully installed mysql-2.7

$wget http://www.openskip.org/download/release/skip-1.0.1.tar.gz
$ tar zxvf skip-1.0.1.tar.gz
$ cd skip-1.0.1/
$ cp config/initial_settings.yml.sample config/initial_settings.yml
$ cp config/database.yml.sample config/database.yml

$vi config/initial_settings.yml
$vi config/database.yml

$ sudo RAILS_ENV=production rake –trace db:create
(in /home/user/skip-1.0.1)
** Invoke db:create (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:create

$ sudo RAILS_ENV=production rake –trace db:migrate
(in /home/user/skip-1.0.1)
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:migrate
== 1 CreateDefaultTables: migrating ===========================================
— create_table(:accounts)
-> 0.0047s
— add_index(“accounts”, [“code”], {:name=>”index_accounts_on_code”, :unique=>true})
-> 0.0058s
— create_table(:antenna_items)
-> 0.0034s
— create_table(:antennas)
-> 0.0027s
— create_table(:applied_emails)
-> 0.0032s
— create_table(:board_entries)
-> 0.0048s
(中略）
** Invoke db:schema:dump (first_time)
** Invoke environment
** Execute db:schema:dump

$ sudo ruby lib/create_new_admin_url.rb –code
“activation_codeを発行しました。初期管理者登録用URLは以下の通りです。”
“http://localhost:3000/admin/users/new/first?code=25aedca9xxxxxxxxxxxxxxxxxxx”

$ sudo ruby ./script/server -e production
=> Booting WEBrick…
=> Rails 2.1.2 application started on http://0.0.0.0:3000
=> Ctrl-C to shutdown server; call with –help for options
[2009-01-11 00:23:54] INFO WEBrick 1.3.1
[2009-01-11 00:23:54] INFO ruby 1.8.6 (2007-09-24) [i486-linux]
[2009-01-11 00:23:54] INFO WEBrick::HTTPServer#start: pid=18292 port=3000

(まだ評価されていません)

Loading...

参考URL

http://www.momo-i.org/?phpMyFAQ%E3%81%AE%E3%82%A4%E3%83%B3%E3%82%B9%E3%83%88%E3%83%BC%E3%83%AB

wget ‘http://www.phpmyfaq.de/getfaq.php?number=2.0.12&ext=.tar.gz’
tar zxvf phpmyfaq-2.0.12.tar.gz
cp -R phpmyfaq-2.0.12 /usr/local/apache/htdocs/faq
chown -R apache. /usr/local/apache/htdocs/faq

cd /usr/local/apache/htdocs/faq
mv _.htaccess .htaccess
rm -f _*

次に、データベースの作成

mysql -u root -p mysql
mysql> grant all privileges on faq.* to faquser@localhost identified by ‘faqpasswd’;
mysql> create database faq;
mysql> quit

mod_rewiteが必要
[code]
AllowOverride All
Options All
IndexIgnore *.gif *.jpg *.png *.php
[/code]

(まだ評価されていません)

Loading...

# cd ~/dowload
# wget http://www.d-ip.jp/download/images/freeticket-1.0_dip_20090403.tar.gz
# mv freeticket /var/www/html/www/
# cd /var/www/html/www/
# chown -R apache:apache freeticket
# chmod 0666 freeticket/settings.php

# mysql -u root -p
mysql> CREATE DATABASE `ticket` DEFAULT CHARACTER SET utf8 ;
mysql> grant all privileges on ticket.* to ticketuser@localhost identified by ‘ticketpasswd’;
mysql> quit

http://www.example.com/freeticket/install/

# chmod 0644 freeticket/settings.php
# chmod 0777 freeticket/attachments
# mv freeticket/install freeticket/install.bk

http://www.example.com/freeticket/admin.php

http://www.example.com/freeticket/

(まだ評価されていません)

Loading...

参考URL
http://gigazine.net/index.php?/news/comments/20060904_munin/
http://gigazine.net/index.php?/news/comments/20070120_munin_config/

# vi /etc/munin/munin.conf
# chown -R munin:munin /var/www/sites/www/munin

# cd /etc/munin/plugins
# ls /usr/share/munin/plugins/
# ln -s /usr/share/munin/plugins/apache_accesses apache_accesses
# ln -s /usr/share/munin/plugins/apache_processes apache_processes
# ln -s /usr/share/munin/plugins/postfix_mailstats postfix_mailstats
# ln -s /usr/share/munin/plugins/users users

# vi /etc/munin/plugin-conf.d/munin-node

# vi /etc/httpd/conf/httpd.conf
# apachectl graceful

# service munin-node start

(まだ評価されていません)

Loading...

# cat /etc/my.cnf

[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock
default-character-set=utf8

[mysqld_multi]
mysqld = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
user = root
password = rootpasswd

# The MySQL server
[mysqld1]
port = 13306
socket = /var/lib/mysql/mysql.sock
pid-file = /var/lib/mysql/host.pid
datadir = /var/lib/mysql/
skip-locking
key_buffer = 96M
max_allowed_packet = 3M
table_cache = 128
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
# Try number of CPU’s*2 for thread_concurrency
thread_concurrency = 8
default-character-set=utf8
character_set_server=utf8
skip-federated
log-bin=mysql-bin

[mysqld2]
port = 13307
socket = /var/lib/mysql2/mysql.sock2
pid-file = /var/lib/mysql2/host.pid2
datadir = /var/lib/mysql2/
skip-locking
key_buffer = 96M
max_allowed_packet = 3M
table_cache = 128
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
# Try number of CPU’s*2 for thread_concurrency
thread_concurrency = 8
default-character-set=utf8
character_set_server=utf8
skip-federated
log-bin=mysql-bin

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

# mysqld_multi start
# mysqld_multi stop

phpアプリのconfig.phpでの設定例

‘hostspec’ => ‘localhost:13306’,
　標準socketでない場合には
‘hostspec’ => ‘localhost:/var/lib/mysql2/mysql.sock2’,

デフォルトはバックアップ等も考慮してclients他3306で運用

起動用に /etc/init.d/に以下のscriptを配置

# cat /etc/init.d/mysqld_multi
#!/bin/sh

# Mysql daemon start/stop script.
#

# Usually this is put in /etc/init.d (at least on machines SYSV R4
# based systems) and linked to /etc/rc3.d/S99mysql and /etc/rc0.d/S01mysql.
# When this is done the mysql server will be started when the machine is started
# and shut down when the systems goes down.

# Comments to support chkconfig on RedHat Linux
# chkconfig: 2345 90 90
# description: A very fast and reliable SQL database engine.

# The following variables are only set for letting mysql.server find things
# if you want to affect other MySQL variables, you should make your changes
# in the /etc/my.cnf or other configuration files

MYSQLDIR=/usr
PATH=/sbin:/usr/sbin:/bin:/usr/bin:/usr/local/bin:$MYSQLDIR/bin
export PATH

# See how we were called.
case “$1” in
start)
echo -n “Starting mysqld: ”
$MYSQLDIR/bin/mysqld_multi start 1,2
echo
;;
stop)
echo -n “Shutting down mysqld: ”
$MYSQLDIR/bin/mysqld_multi stop 1,2
echo
;;
status)
$MYSQLDIR/bin/mysqld_multi report 1,2
;;
restart)
$0 stop
$0 start
;;
*)
echo “Usage: $0 {start|stop|restart|status}”
exit 1
esac

exit 0

起動時の設定を追加
元々のmysqldはオフに、mysqld_multiをオンに

# checkconfig mysqld off
# checkconfig mysqld_multi on

#ntsysv　で確認

(1 投票, 平均値/最大値: 4.00 / 5)

Loading...

# cd ~/download/

# wget http://globalbase.dl.sourceforge.jp/usagi/39809/concrete5.3.1.1.ja.zip
# unzip concrete5.3.1.1.ja.zip

# mysql -u root -p
mysql> CREATE DATABASE `concrete5` DEFAULT CHARACTER SET utf8 ;
mysql> quit

# mv concrete5.3.1.1.ja /var/www/sites/www/con5
# chown -R apache:apache /var/www/sites/www/con5

http://hostname/con5/ 　にアクセスして設定を行う

(まだ評価されていません)

Loading...

#cd ~/download/

# wget http://zimplit.com/download/zimplit_cms_2.1.zip
# mkdir /var/www/sites/www/zimplit
# cp zimplit_cms_2.1.zip /var/www/sites/www/zimplit
# cd /var/www/sites/www/zimplit
# unzip zimplit_cms_2.1.zip

http://hostname/zimplit/zimplit.php 　にアクセス

(まだ評価されていません)

Loading...

yumでinstallされている前提

# locate eaccelerator　でパス確認

/etc/php.d/eaccelerator.ini
/usr/share/doc/php-eaccelerator-0.9.5.2/control.php

この２つがポイント

設定値の変更
# vi /etc/php.d/eaccelerator.ini

eaccelerator.allowed_admin_path = “/var/www/sites/www/control.php”
制御ファイルのパスを追記

制御確認
# cd /var/www/sites/www
# ln -s /usr/share/doc/php-eaccelerator-0.9.5.2/control.php control.php

http://hostname/control.php へアクセス
ID：admin　パス：eAccelerator（デフォルト設定では）

(まだ評価されていません)

Loading...