ZFS on G7 FreeBSD9.1R-p3

CONTENTS


Lastmodified 2013-08-10 (土) 12:05:47


OpenPNE 3.8.6 on FreeBSD 9.1R

http://www.openpne.jp/pne-downloads/openpne3/#openpne-3.7-3.8

G7(FreeBSD9.1R-p3の実験機)へ、k222(FreeBSD 7.1R-p16)で稼働中のSNSを引っ越してみる。

  1. 稼働中のOpnePne3系は、sns.example.net/Com_Name/ なので、引っ越し先は、sns.example.info/Com_Name/ とする。
  2. データは出来るだけzpool上に置くようにデザインする。

OpenPneを取って来るために

portinstall devel/git

する

root@G7:/root # mkdir /home/OpenPne3
root@G7:/root # cd /home/OpenPne3/
root@G7:/home/OpenPne3 # ll
total 0
root@G7:/home/OpenPne3 # git clone git://github.com/openpne/OpenPNE3.git
Cloning into 'OpenPNE3'...
remote: Counting objects: 54395, done.
remote: Compressing objects: 100% (17621/17621), done.
remote: Total 54395 (delta 35724), reused 52916 (delta 34454)
Receiving objects: 100% (54395/54395), 17.91 MiB | 921 KiB/s, done.
Resolving deltas: 100% (35724/35724), done.
root@G7:/home/OpenPne3 #
root@G7:/home/OpenPne3 #
root@G7:/home/OpenPne3 # ll
total 2
drwxr-xr-x  15 root  wheel  20 Jun  7 14:16 OpenPNE3/
root@G7:/home/OpenPne3 # cd OpenPNE3/
root@G7:/home/OpenPne3/OpenPNE3 # git checkout OpenPNE-3.8.6
Note: checking out 'OpenPNE-3.8.6'.

You are in 'detached HEAD' state. You can look around, make experimental
changes and commit them, and you can discard any commits you make in this
state without impacting any branches by performing another checkout.

If you want to create a new branch to retain commits you create, you may
do so (now or later) by using -b with the checkout command again. Example:

  git checkout -b new_branch_name

HEAD is now at 055e197... version 3.8.6

OpenPNE3.8 セットアップ手順

https://raw.github.com/openpne/OpenPNE3/OpenPNE-3.8.6/doc/ja/OpenPNE3_Setup_Guide.txt

portinstall lang/php5

portinstall lang/php5-extensions

以下のExtensionは外す。

PDO_Firebird
recode
sybase_ct

http://piano2nd.smb.net/~kuji/pukiwiki-1.4.7/index.php?cmd=read&page=munin%20on%20FreeBSD%209.0&word=%E4%B8%8B%E6%89%8B%E4%BA%BA#n19b4c8e

MySQL

databases/mysql55-client

databases/mysql55-server

MySQL on FreeBSD

/etc/rc.conf

mysql_enable="YES"

デフォルトでは /var/db/mysql にデータベースファイルが作成されます。もし他の場所にしたい場合は rc.conf に以下のような設定を追加します。このディレクトリが起動時になければパーミッション 700、オーナー mysqlで作成されます。

mysql_dbdir="/path/to/mysql"

mysqlの設定ファイルの雛形をコピーしておきます。(より大規模なシステムなら large や huge に)

# cp /usr/local/share/mysql/my-large.cnf /usr/local/etc/my.cnf
または
# cp /usr/local/share/mysql/my-medium.cnf /usr/local/etc/my.cnf
# chmod 644 /usr/local/etc/my.cnf

/usr/local/etc/my.conf

[client]
#password	= your_password
#port		= 3306
port		= ****
socket		= /tmp/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
#port		= 3306
port		= ****
socket		= /tmp/mysql.sock

以下の起動スクリプトで制御できます。

# /usr/local/etc/rc.d/mysql-server start ←デーモンを起動します
# /usr/local/etc/rc.d/mysql-server restart ←デーモンを再起動します
# /usr/local/etc/rc.d/mysql-server stop ←デーモンを停止します

起動できたら、rootユーザのパスワードを設定します。初期状態ではパスワードなしになっています。ここでは root@localhost の設定を変更しておきます。

# mysqladmin -u root -h localhost password 'XXXXXX' ←XXXXXXに半角でパスワードを書きます。

databases/phpmyadmin

phpMyAdmin Ver 3.4.9

===> Creating users and/or groups.
Using existing group `www'.

phpMyAdmin-4.0.3 has been installed into:

    /usr/local/www/phpMyAdmin

Please edit config.inc.php to suit your needs.

To make phpMyAdmin available through your web site, I suggest
that you add something like the following to httpd.conf:

    Alias /phpmyadmin/ "/usr/local/www/phpMyAdmin/"

     <Directory "/usr/local/www/phpMyAdmin/">
        Options none
        AllowOverride Limit

        Order Deny,Allow
        Deny from all
        Allow from 127.0.0.1 .example.com
    </Directory>

SECURITY NOTE: phpMyAdmin is an administrative tool that has had several
remote vulnerabilities discovered in the past, some allowing remote
attackers to execute arbitrary code with the web server's user credential.
All known problems have been fixed, but the FreeBSD Security Team strongly
advises that any instance be protected with an additional protection layer,
e.g. a different access control mechanism implemented by the web server
as shown in the example.  Do consider enabling phpMyAdmin only when it
is in use.
===> Correct pkg-plist sequence to create group(s) and user(s)
===>   Registering installation for phpMyAdmin-4.0.3
===>  Cleaning for phpMyAdmin-4.0.3
# ln -s /usr/local/www/phpMyAdmin/ /usr/local/www/apache24/data/phpMyAdmin

OpenPNE-3.8.6

https://raw.github.com/openpne/OpenPNE3/OpenPNE-3.8.6/doc/ja/OpenPNE3_Setup_Guide.txt

$ cd OpenPNE3
$ cp config/ProjectConfiguration.class.php.sample config/ProjectConfiguration.class.php
$ cp config/OpenPNE.yml.sample config/OpenPNE.yml
$ ./symfony openpne:install --internet

Total access 2469:本日 1:昨日 0

Counter: 2469, today: 1, yesterday: 0

トップ   新規 一覧 検索 最終更新   ヘルプ   最終更新のRSS