SNS�\�z(OpenPNE)

�ŏI�X�V���F 2014.02.19

<<�g�b�v�y�[�W <<�V����� <<�T�C�g������ <<CentOS�Ŏ���T�[�o�[�\�z <<Scientific Linux�Ŏ���T�[�o�[�\�z

���T�v

OpenPNE��mixi(�~�N�V�B)�̂悤��SNS(�\�[�V�����l�b�g���[�L���O�T�C�g)���\�z����B

��Web�T�[�o�[+PHP�AWeb�T�[�o�[�ԒʐM���e�Í����AMySQL�f�[�^�x�[�X���\�z�ςł��邱��


��MySQL�ݒ�

OpenPNE�ł́A�e��f�[�^��MySQL�f�[�^�x�[�X��ŊǗ����邽�߁AOpenPNE�p�̃f�[�^�x�[�X�ƁA���Y�f�[�^�x�[�X�ւ̃A�N�Z�X�p���[�U��MySQL�ɓo�^����K�v������B
�����ł́A�f�[�^�x�[�X����openpne�A�f�[�^�x�[�X�A�N�Z�X�p���[�U����openpne�Ƃ���MySQL�ɓo�^����B
[root@fedora ~]# mysql -u root -p�@���@MySQL��root���O�C��
Enter password: �@���@MySQL��root�p�X���[�h����
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 78 to server version: 5.0.22

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> grant all privileges on openpne.* to openpne@localhost identified by '�p�X���[�h';�@���@openpne���[�U�쐬
Query OK, 0 rows affected (0.52 sec)

mysql> create database openpne;�@���@openpne�f�[�^�x�[�X�쐬
Query OK, 1 row affected (0.08 sec)

mysql> exit�@���@���O�A�E�g
Bye

��OpenPNE�C���X�g�[��

�i�P�jphp-mysql�C���X�g�[��
OpenPNE��PHP�œ��삷�邽�߁APHP����MySQL�f�[�^�x�[�X�փA�N�Z�X���邽�߂̃p�b�P�[�W�ł���php-mysql���C���X�g�[������
[root@fedora ~]# yum -y install php-mysql�@���@php-mysql�C���X�g�[��

�i�Q�jOpenPNE�C���X�g�[��
[root@fedora ~]# yum -y install php-gd php-xml�@���@OpenPNE�ɕK�v��PHP�p�b�P�[�W�C���X�g�[��

[root@fedora ~]# wget "http://github.com/openpne/OpenPNE3/zipball/OpenPNE-3.4.4.1"�@���@OpenPNE�_�E�����[�h

���ŐV�ł�URL���_�E�����[�h�y�[�W�Ŋm�F���邱��

[root@fedora ~]# unzip openpne-OpenPNE3-OpenPNE-3.4.4.1-0-g6458374.zip�@���@OpenPNE�W�J

[root@fedora ~]# mv openpne-OpenPNE3-6458374/ /var/www/OpenPNE�@���@OpenPNE�W�J��f�B���N�g��������̏ꏊ�փ��l�[���ړ�

[root@fedora ~]# rm -f openpne-OpenPNE3-OpenPNE-3.4.4.1-0-g6458374.zip�@���@�_�E�����[�h�����t�@�C�����폜

[root@fedora ~]# cd /var/www/OpenPNE/config/�@���@�f�B���N�g���ړ�

[root@fedora config]# cp ProjectConfiguration.class.php.sample ProjectConfiguration.class.php
�@���@ProjectConfiguration.class.php���T���v�����R�s�[

[root@fedora config]# cp OpenPNE.yml.sample OpenPNE.yml�@���@OpenPNE.yml���T���v�����R�s�[

[root@fedora config]# vi OpenPNE.yml�@���@OpenPNE.yml�ҏW
base_url: "http://fedorasrv.com/openpne/"�@���@base_url�ύX

mail_domain: "fedorasrv.com"�@���@mail_domain�ύX

[root@fedora config]# cd�@���@�z�[���f�B���N�g���֖߂�

[root@fedora ~]# /var/www/OpenPNE/symfony openpne:install�@���@OpenPNE�C���X�g�[��

  Choose DBMS:
  - mysql
  - pgsql (unsupported)
  - sqlite (unsupported)

mysql�@���@mysql����

  Type database username

openpne�@���@�f�[�^�x�[�X���[�U������

  Type database password (optional)

********�@���@�f�[�^�x�[�X���[�U�p�X���[�h����

  Type database hostname

localhost�@���@localhost����

  Type database port number (optional)

�@���@��ENTER

  Type database name

openpne�@���@�f�[�^�x�[�X������

  Type database socket path (optional)

/var/lib/mysql/mysql.sock�@���@MySQL�\�P�b�g������

  The DBMS                 : mysql
  The Database Username    : openpne
  The Database Password    : ******
  The Database Hostname    : localhost
  The Database Port Number :
  The Database Name        : openpne
  The Database Socket      : /var/lib/mysql/mysql.sock

  Is it OK to start this task? (Y/n)

y�@���@y����
�E
�E
�E
>> installer installation is completed!�@���@�C���X�g�[������

��Apache�ݒ�

[root@fedora ~]# vi /etc/httpd/conf.d/openpne.conf�@���@OpenPNE�pAapche�ݒ�t�@�C���쐬
Alias /openpne /var/www/OpenPNE/web
<Directory "/var/www/OpenPNE/web">
    AllowOverride All
</Directory>

[root@fedora ~]# vi /var/www/OpenPNE/web/.htaccess�@���@.htaccess�ҏW
  RewriteBase /openpne�@���@�ύX

[root@fedora ~]# /etc/rc.d/init.d/httpd reload�@���@Apache�ݒ蔽�f
httpd ���ēǂݍ��ݒ�:                                      [  OK  ]

�ȉ��̓o�[�`�����z�X�g��SSL=https�ŃA�N�Z�X�ł���悤�ɂ���ꍇ�̂�
[root@fedora ~]# vi /etc/httpd/conf.d/ssl.conf�@���@Web�T�[�o�[SSL�ݒ�t�@�C���ҏW
#   Per-Server Logging:
#   The home of a custom SSL log file. Use this when you want a
#   compact non-error SSL logfile on a virtual host basis.
CustomLog logs/ssl_request_log \
          "%t %h %{SSL_PROTOCOL}x %{SSL_CIPHER}x \"%r\" %b"

    <IfModule mod_rewrite.c>
      RewriteEngine On
      RewriteLog "logs/rewrite_log"
      RewriteLogLevel 0
      RewriteCond %{HTTP_HOST} !fedorasrv.com$
      RewriteCond %{REQUEST_URI} !^/openpne/�@���@�lj�
      RewriteRule ^/(.*)?$ http://%{HTTP_HOST}/$1 [L,R]
    </IfModule>
</VirtualHost>

[root@fedora ~]# /etc/rc.d/init.d/httpd reload�@���@Apache�ݒ蔽�f
httpd ���ēǂݍ��ݒ�:                                      [  OK  ]
��/var/log/httpd/error_log�Ɉȉ��̂悤�ȃG���[���b�Z�[�W���o�͂����OpenPNE�փA�N�Z�X�ł��Ȃ��ꍇ�̑Ώ�
[Tue Nov 24 14:05:52 2009] [error] [client XXX.XXX.XXX.XXX] PHP Warning: require_once(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Asia/Tokyo' for 'JST/9.0/no DST' instead in /var/www/OpenPNE/lib/include/PEAR.php on line 569
[Tue Nov 24 14:05:52 2009] [error] [client XXX.XXX.XXX.XXX] PHP Fatal error: require_once(): Timezone database is corrupt - this should *never* happen! in /var/www/OpenPNE/lib/include/PEAR.php on line 569
[root@fedora ~]# vi /etc/php.ini�@���@PHP�ݒ�t�@�C���ҏW
[Date]
; Defines the default timezone used by the date functions
; http://www.php.net/manual/en/datetime.configuration.php#ini.date.timezone
;date.timezone =
date.timezone = Asia/Tokyo�@���@�lj�

[root@fedora ~]# /etc/rc.d/init.d/httpd reload�@���@Apache�ċN��

��OpenPNE�m�F

https://�T�[�o�[��/openpne/�Ńg�b�v�y�[�W�փA�N�Z�X
���[���A�h���X�E�E�[email protected]
�p�X���[�h�E�E�Epassword
����O�C����{�^������
���O�C���ł��邱�Ƃ��m�F
��ݒ�ύX��ˢPC���[���A�h���X�ݒ裂Ń��[���A�h���X��ύX���邱��
��ݒ�ύX��ˢ�p�X���[�h�ݒ裂Ńp�X���[�h��ύX���邱��

https://�T�[�o�[��/openpne/pc_backend.php�ŊǗ��y�[�W�փA�N�Z�X
�A�J�E���g���E�E�Eadmin
�p�X���[�h�E�E�Epassword
����O�C����{�^������
���O�C���ł��邱�Ƃ��m�F
�SNS�ݒ裂ŊǗ��҃��[���A�h���X��ύX���邱��
��Ǘ���ʐݒ裁ˢChange Password��Ńp�X���[�h��ύX���邱��



���֘A�R���e���c

<!�\�e�L�X�g�݂̂�4�s�\���ɒlj���C������\>



�����̃y�[�W�̃g�b�v�֖߂�

�v���C�o�V�[�|���V�[