OpenPNE3 on FreeBSD の履歴(No.13)

Blackcube2でスクラッチからインストール再チャレンジ　2013-03-19 15:45:16
- /usr/local/www/apache22/data/OpenPNE3/web/.htaccess
- /usr/local/etc/apache22/includes/sns.conf
何度もインストールやり直すときに便利なコマンド
FreeBSDにPHPフレームワーク Zend Frameworkをインストールする
- PHPの設定
- サンプルコード
新規登録　で、エラー
OpnePNE3 FreeBSD 9.1R
- Couldn't locate driver named mysql
OpenPNE3 が、php.core を吐く件

Blackcube2でスクラッチからインストール再チャレンジ　2013-03-19 15:45:16†

>> file+     /usr/local/www/apache22/data/OpenPNE3/data/fixtures_tmp/011_010_navigation_91afda04df59191a09a89c35dc28d5b3.yml
>> file+     /usr/local/www/apache22/data/OpenPNE3/data/fixtures_tmp/011_020_gadget_25cbeed9bd27e49383e6d155cfa4870f.yml
>> file+     /usr/local/www/apache22/data/OpenPNE3/data/fixtures_tmp/012_navigation_a096d2917ac186bd2a4876de486d9dad.yml
>> doctrine  Dropping "doctrine" database
>> doctrine  PDO Connection Error: SQLSTATE[HY000] [1045] Access denied for user 'pne3'@'localhost' (using password: YES)
>> doctrine  Creating "prod" environment "doctrine" database
>> doctrine  PDO Connection Error: SQLSTATE[HY000] [1045] Access denied for user 'pne3'@'localhost' (using password: YES)
>> doctrine  generating model classes
>> file+     /var/tmp/doctrine_schema_95573.yml

というエラーなので、phpMyAdmin で　DBとuserを作成して　--redo

>> file+     /usr/local/www/apache22/data/OpenPNE3/data/fixtures_tmp/012_010_default_api_configuration_0e7485e9c6b7f61825381029f61da560.yml
>> doctrine  Dropping "doctrine" database
>> doctrine  Creating "prod" environment "doctrine" database
>> doctrine  generating model classes
>> file+     /var/tmp/doctrine_schema_66394.yml
Segmentation fault (core dumped)
root@blackcube2:/usr/local/www/apache22/data/OpenPNE3 # ./symfony openpne:install --redo

>> plugin    Configuring plugin - opAlbumPlugin
>> plugin    Configuring plugin - opAshiatoPlugin
>> plugin    Configuring plugin - opAuthMailAddressPlugin
>> plugin    Configuring plugin - opAuthMobileUIDPlugin
>> plugin    Configuring plugin - opAuthOpenIDPlugin
>> plugin    Configuring plugin - opBlogPlugin
>> plugin    Configuring plugin - opCommunityTopicPlugin
>> plugin    Configuring plugin - opDiaryPlugin
>> plugin    Configuring plugin - opFavoritePlugin
>> plugin    Configuring plugin - opIntroFriendPlugin
>> plugin    Configuring plugin - opMessagePlugin
>> plugin    Configuring plugin - opOpenSocialPlugin
>> plugin    Configuring plugin - opRankingPlugin
>> plugin    Configuring plugin - opSkinBasicPlugin
>> link+     /usr/local/www/apache22/data/OpenPNE3/web/opSkinBasicPlugin
>> plugin    Configuring plugin - opSkinClassicPlugin
>> link+     /usr/local/www/apache22/data/OpenPNE3/web/opSkinClassicPlugin
>> plugin    Configuring plugin - opWebAPIPlugin
>> plugin    Configuring plugin - sfDoctrinePlugin
>> link+     /usr/local/www/apache22/data/OpenPNE3/web/sfDoctrinePlugin
>> plugin    Configuring plugin - sfFormExtraPlugin
>> link+     /usr/local/www/apache22/data/OpenPNE3/web/sfFormExtraPlugin
>> plugin    Configuring plugin - sfImageHandlerPlugin
>> plugin    Configuring plugin - sfProtoculousPlugin
>> link+     /usr/local/www/apache22/data/OpenPNE3/web/sfProtoculousPlugin
>> plugin    Configuring plugin - sfSymfonyTemplatingViewPlugin
>> installer installation is completed!
root@blackcube2:/usr/local/www/apache22/data/OpenPNE3 #

あっさりOK　( ´▽｀)ノ

↑

/usr/local/www/apache22/data/OpenPNE3/web/.htaccess†

 # uncomment the following line, if you are having trouble
 # getting no_script_name to work
 RewriteBase /OpenPNE3

↑

/usr/local/etc/apache22/includes/sns.conf†

<Directory "/usr/local/www/apache22/data/OpenPNE3">
#	Options Indexes FollowSymLinks ExecCGI
	Options FollowSymLinks ExecCGI
	AllowOverride ALL
	Order allow,deny
	Allow from all
</Directory>

<IfModule mod_rewrite.c>
  RewriteEngine On
  RewriteRule ^/OpenPNE3/(.*)$ /OpenPNE3/web/$1
#  RewriteRule ^/OpenPNE3/(.*)$ OpenPNE3/web/$1
</IfModule>

      RewriteLog "/tmp/rewrite.log"
      RewriteLogLevel 9

↑

何度もインストールやり直すときに便利なコマンド†

http://openpne3.com/wiki/OpenPNE3%E3%83%8E%E3%82%A6%E3%83%8F%E3%82%A6:%E4%BD%95%E5%BA%A6%E3%82%82%E3%82%A4%E3%83%B3%E3%82%B9%E3%83%88%E3%83%BC%E3%83%AB%E3%82%84%E3%82%8A%E7%9B%B4%E3%81%99%E3%81%A8%E3%81%8D%E3%81%AB%E4%BE%BF%E5%88%A9%E3%81%AA%E8%BF%BD%E5%8A%A0task OpenPNE3.6から

openpne:install --redo

で出来るようになりました

$ ./symfony openpne:install

>>  file+     /usr/local/www/apache22/data/OP36B/data/fixtures_tmp/008_020_gadget_0347f9728968379729fd3ae0fe9ca6b6.yml
>> doctrine  Dropping "doctrine" database
>> doctrine  PDO Connection Error: SQLSTATE[HY000] [1045] Access denied for user 'op36b'@'localhost' (using password: YES)
>> doctrine  Creating "prod" environment "doctrine" database
>> doctrine  PDO Connection Error: SQLSTATE[HY000] [1045] Access denied for user 'op36b'@'localhost' (using password: YES)
>> doctrine  generating model classes
>> file+     /tmp/doctrine_schema_73175.yml
Bus error (core dumped)

http://himaphp.blog.fc2.com/blog-entry-8.html

Parse error: syntax error, unexpected ';' in /usr/home/OpenPNE3/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php on line 470

root@g7:/root # portinstall devel/pear-channel-symfony
[Gathering depends for devel/pear-channel-symfony  .................................................... done]
--->  Installing 'pear-channel-symfony-20110701' from a port (devel/pear-channel-symfony)
--->  Building '/usr/ports/devel/pear-channel-symfony'
===>  Cleaning for pear-channel-symfony-20110701
===>  Extracting for pear-channel-symfony-20110701
===>  Patching for pear-channel-symfony-20110701
===>   pear-channel-symfony-20110701 depends on file: /usr/local/bin/pear - found
===>  Configuring for pear-channel-symfony-20110701
--->  Installing the new version via the port
===>  Installing for pear-channel-symfony-20110701
===>   pear-channel-symfony-20110701 depends on file: /usr/local/bin/pear - found
===>   Generating temporary packing list
===>   Registering installation for pear-channel-symfony-20110701
===>  Cleaning for pear-channel-symfony-20110701
root@g7:/root #

Warning: ob_start(): function '' not found or invalid function name in 
/usr/local/www/apache22/data/OP3/lib/vendor/symfony/lib/config/sfApplicationConfiguration.class.php on line 155

なんか、やたらApacheが落ちまくってダメ。

root@g7:/usr/home/OpenPNE3-OpenPNE-3.4.21 # ll
total 55329
-rw-------   1 www  www  56541184 Mar 12 14:07 php.core

root@g7:/usr/home/OpenPNE3-OpenPNE-3.4.21 # gdb /usr/local/bin/php -c php.core

GNU gdb 6.1.1 [FreeBSD]
Copyright 2004 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are
welcome to change it and/or distribute copies of it under certain conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB.  Type "show warranty" for details.
This GDB was configured as "amd64-marcel-freebsd"...(no debugging symbols found)...

warning: exec file is newer than core file.
Core was generated by `php'.
Program terminated with signal 10, Bus error.
Reading symbols from /lib/libcrypt.so.5...(no debugging symbols found)...done.
Loaded symbols for /lib/libcrypt.so.5

Loaded symbols for /libexec/ld-elf.so.1
#0  0x00000000005813d2 in zend_hash_get_current_key_type_ex ()
[New Thread 802007400 (LWP 100724/php)]
(gdb)
(gdb)

(gdb) where

#0  0x00000000005813d2 in zend_hash_get_current_key_type_ex ()
#1  0x00000000004624ae in zif_spl_autoload_call ()
#2  0x00000000005681f8 in zend_call_function ()
#3  0x00000000005687ae in zend_lookup_class_ex ()
#4  0x0000000000586ee3 in zif_class_exists ()
#5  0x00000000005a3326 in zend_do_fcall_common_helper_SPEC ()
#6  0x00000000005a919d in execute ()
#7  0x0000000000574457 in zend_execute_scripts ()
#8  0x0000000000514ef7 in php_execute_script ()
#9  0x000000000061d33c in do_cli ()

↑

FreeBSDにPHPフレームワーク Zend Frameworkをインストールする†

http://kaworu.jpn.org/kaworu/2009-01-11-1.php

但し、古いOpenPne3だとインストールエラーするよ

http://trac.openpne.jp/ticket/4183

/usr/local/share/ZendFramework/library

にインストールされます。

↑

PHPの設定†

php.iniなどのPHPの設定ファイルのinclude_pathにZendFrameworkのパスを追加します。

include_path = ".:/usr/local/share/ZendFramework/library"

↑

サンプルコード†

Zend Frameworkのバージョンを表示するだけのサンプルコード。

 <?php
require 'Zend/Version.php';
echo Zend_Version::VERSION;
?>

***************************************************************
Now you need to adjust PHP's include_path to contain
        `/usr/local/share/ZendFramework/library'

For example, insert:
        include_path = ".:/usr/local/share/ZendFramework/library"

into `/usr/local/etc/php.ini'.

Zend Framework includes the Zend_Tool class and wrapper script
for automating many common framework-related tasks. To use the
zf wrapper script, set the following environment variable:

Bourne shell:
    export ZEND_TOOL_INCLUDE_PATH_PREPEND= \
        /usr/local/share/ZendFramework/library

C-shell:
    setenv ZEND_TOOL_INCLUDE_PATH_PREPEND \
        /usr/local/share/ZendFramework/library

Documentation for the Zend_Tool class is found at:
http://framework.zend.com/manual/1.12/en/zend.tool.framework.introduction.html

For more general information about the Zend Framework, please
visit: http://framework.zend.com/
***************************************************************
===>   Registering installation for ZendFramework-1.12.0_1
===>  Cleaning for php5-pdo_mysql-5.4.12
===>  Cleaning for ZendFramework-1.12.0_1

SQLSTATE[HY000]: General error: 1364 Field 'height' doesn't have a default valu

http://12net.jp/blog/b20110208_01.html

>> doctrine  Dropping "doctrine" database
>> doctrine  Creating "prod" environment "doctrine" database
>> doctrine  generating model classes
>> file+     /tmp/doctrine_schema_85868.yml
Segmentation fault (core dumped)

>> doctrine  PDO Connection Error: SQLSTATE[HY000] [1045] Access denied for user 'pne34'@'localhost' (using password: YES)
>> doctrine  Creating "prod" environment "doctrine" database
>> doctrine  PDO Connection Error: SQLSTATE[HY000] [1045] Access denied for user 'pne34'@'localhost' (using password: YES)
>

↑

新規登録　で、エラー†

http://d.hatena.ne.jp/hydrangeas/20121017/1350473032

↑

OpnePNE3 FreeBSD 9.1R†

2013-03-07 (木) 15:50:54

githubで最新を追いかけるのは、この次にｗ

取り敢えず2013/03/07の時点での最新版、OpenPNE3.6.8をDL。

で、サーバのzpool事情もあって、/usr/home/以下において解凍する。

root@g7:/usr/home # unzip OpenPNE3-OpenPNE-3.6.8.zip

セットアップ手順

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

手順書に曰く

Webサーバ
 Apache 
   * mod_rewrite を使用可能
PHP
 PHP5.2.3 以降
   * PHP の mbstring 拡張モジュールを使用可能
   * PHP の XML 拡張モジュールを使用可能
   * PHP の PCRE 拡張モジュールを使用可能 (UTF-8 サポート)
   * PHP の PDO 拡張モジュールを使用可能 (利用する DBMS のドライバも含む)
   * PHP の JSON 拡張モジュールを使用可能
   * PHP から GD ライブラリを使用可能 (JPEG/GIF/PNG サポート)
   * PHP の mcrypt 拡張モジュールの使用を推奨
   * PHP の APC 拡張モジュールの使用を推奨
データベースサーバ
 MySQL4.1以降（5.1 以降を推奨）
 
 PostgreSQL, SQLite は現時点で未サポート（将来的にサポート予定）

とのことであるので、

portinstall lang/php5-extensions

する。

↑

Couldn't locate driver named mysql†

と言うエラーがでる。

portinstall databases/php5-pdo_mysql

root@g7:/usr/home/OpenPNE3-OpenPNE-3.6.8 # ./symfony openpne:install


>> file+     /tmp/doctrine_schema_57917.yml
Segmentation fault (core dumped)

>> file+     /usr/local/www/apache22/data/OpenPNE3-OpenPNE-3.6.8/data/fixtures_tmp/
012_010_default_api_configuration_84ee96bc5607b297400a105f78586824.yml
>> doctrine  Dropping "doctrine" database
>> doctrine  Creating "prod" environment "doctrine" database
>> doctrine  generating model classes
>> file+     /tmp/doctrine_schema_71958.yml

Fatal error: Cannot call overloaded function for non-object in /usr/local/www/apache22/data/OpenPNE3-OpenPNE-
3.6.8/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/
lib/vendor/doctrine/Doctrine/Import/Builder.php on line 714
root@g7:/usr/local/www/apache22/data/OpenPNE3-OpenPNE-3.6.8 #

関係無いとは思うが、

MySQLを56にUPして環境を整え、さらに
root@g7:/usr/ports/lang/php5-extensions # portinstall textproc/php5-xsl

してからインストールを繰り返す。

結果、phpMyAdminで予め全権ユーザと同名DBをつくって、再インストールしたら、

>> plugin    Configuring plugin - sfProtoculousPlugin
>> link+     /usr/home/OpenPNE3-OpenPNE-3.6.8/web/sfProtoculousPlugin
>> plugin    Configuring plugin - sfSymfonyTemplatingViewPlugin
>> installer installation is completed!
root@g7:/usr/home/OpenPNE3-OpenPNE-3.6.8 #

無事通りました。( ´▽｀)ノ

ということだが、また、別のPNE3をインストールすると、

>> file+     /usr/local/www/apache22/data/OP3/data/fixtures_tmp/010_100_paypal_85214cc6c9c93d94c91da6fea3de9aeb.yml
>> file+     /usr/local/www/apache22/data/OP3/data/fixtures_tmp/011_navigation_180b42ce78b1fd7e03a36ca4ca9a45f6.yml
>> file+     /usr/local/www/apache22/data/OP3/data/fixtures_tmp/012_010_default_api_configuration_a79bae3aa9e1f2f0ce716a59c861df9f.yml
>> doctrine  Dropping "doctrine" database
>> doctrine  Creating "prod" environment "doctrine" database
>> doctrine  generating model classes
>> file+     /tmp/doctrine_schema_99811.yml

いつも大抵ここで
Bus error (core dumped)
とか、
Segmentation fault (core dumped)
になって落ちる(ーー;)

>> tokens    /usr/local/www/apache22/data/OP3/lib/model/doctrine/opMessagePlugin/base/BaseMessageType.class.php
>> tokens    /usr/local/www/apache22/data/OP3/lib/model/doctrine/opMessagePlugin/base/BaseDeletedMessage.class.php

と言うことを繰り返す。が、何度もやると、鬼門を通り抜けてインストール出来る・・・こともある。┐(´д｀)┌

root@g7:/usr/home/OpenPNE3-OpenPNE-3.6.8 # ./symfony project:clear-controllers

さて、現在、/usr/home/OpenPNE3-OpenPNE-3.6.8 にあるwebを

http://g7.kuji-clinic.net/SNS

で表示することにする。

http://mpweb.mobi/server/mod_rewrite.php

/usr/local/etc/apache22/Includes/sns.conf

#OpnePNE 3

<Directory "/usr/home/OpenPNE3-OpenPNE-3.6.8">
	Options FollowSymLinks ExecCGI
    AllowOverride ALL
    Order allow,deny
    Allow from all
</Directory>

<Directory "/usr/local/www/apache22/data/SNS">
	Options FollowSymLinks ExecCGI
    AllowOverride ALL
    Order allow,deny
    Allow from all
</Directory>

<IfModule mod_rewrite.c>
  RewriteEngine On
  RewriteRule ^/SNS/(.*)$ /usr/home/OpenPNE3-OpenPNE-3.6.8/web/$1
</IfModule>

RewriteLogLevel 9
RewriteLog /var/log/httpd-rewrite.log

/usr/home/OpenPNE3-OpenPNE-3.6.8/web/.htaccess

オリジナルのまま

http://g7.kuji-clinic.net/SNS/pc_backend.php/

↑

OpenPNE3 が、php.core を吐く件†

k222# chown -R www:www OpenPNE3