340 14:39 tar xvfzp openpne-OpenPNE3-OpenPNE-3.6beta2-0-g75f80ec.zip 342 14:41 mv openpne-OpenPNE3-75f80ec OpenPNE3.6beta2 347 14:42 chown -R www:www OpenPNE3.6beta2 348 14:43 cd /usr/local/www/apache22/data/OpenPNE3.6beta2/config 350 14:43 cp OpenPNE.yml.sample OpenPNE.yml 351 14:43 cp ProjectConfiguration.class.php.sample ProjectConfiguration.class.php 355 14:46 ./symfony openpne:install 359 14:59 apachectl restart 363 15:16 ./symfony doctrine:build-model 364 15:16 ./symfony cc 365 15:18 apachectl restart 366 15:18 ./symfony doctrine:build-model 367 15:18 ./symfony openpne:install 368 15:21 apachectl restart 369 15:22 ./symfony openpne:install 370 15:23 ./symfony openpne:install 371 15:34 cd /usr/local/www/apache22/data 373 15:35 tar cvfzp OpenPNE3.tar.gz OpenPNE3 375 15:36 mv OpenPNE3.tar.gz OpenPNE3_20100814.tar.gz 378 15:45 tar xvfzp openpne-OpenPNE3-OpenPNE-3.6beta2-0-g75f80ec.zip 380 15:46 mv openpne-OpenPNE3-75f80ec OpenPNE3_New 382 15:46 chown -R www:www OpenPNE3_New 384 15:47 mv OpenPNE3 OpenPNE3_Old 386 15:47 mv OpenPNE3_New OpenPNE3 388 15:49 cd /usr/local/www/apache22/data/OpenPNE3/config 390 15:49 cp OpenPNE.yml.sample OpenPNE.yml 391 15:49 cp ProjectConfiguration.class.php.sample ProjectConfiguration.class.php 392 15:51 cp /usr/local/www/apache22/data/OpenPNE3_Old/config/OpenPNE.yml /usr/local/www/apache22/data/OpenPNE3/config/OpenPNE.yml 393 15:53 cp - 406 16:01 tar xvfzp openpne-OpenPNE3-OpenPNE-3.6beta2-0-g75f80ec.zip 407 16:01 ll 408 16:02 mv openpne-OpenPNE3-75f80ec OpenPNE3 409 16:02 ll 410 16:02 chown -R www:www OpenPNE3 411 16:02 ll 412 16:03 cd /usr/local/www/apache22/data/OpenPNE3/config 413 16:03 ll 414 16:04 cp OpenPNE.yml.sample OpenPNE.yml 415 16:04 cp ProjectConfiguration.class.php.sample ProjectConfiguration.class.php 416 16:04 cd /usr/local/www/apache22/data/OpenPNE3_Old/config 417 16:04 ll 418 16:05 cp OpenPNE.yml /usr/local/www/apache22/data/OpenPNE3/config/ 419 16:06 cp -apR /usr/local/www/apache22/data/OpenPNE3_Old/plugins/* /usr/local/www/apache22/data/OpenPNE3/plugins/ 420 16:06 cp -apR /usr/local/www/apache22/data/OpenPNE3_Old/plugins/.* /usr/local/www/apache22/data/OpenPNE3/plugins/ 423 16:07 cd /usr/local/www/apache22/data/OpenPNE3 425 16:08 ./symfony doctrine:build-model 426 16:08 ./symfony cc 427 16:08 ./symfony openpne:migrate 428 16:11
cp /usr/local/www/apache22/data/OpenPNE3_Old/config/databases.yml /usr/local/www/apache22/data/OpenPNE3/config/
430 16:12 ./symfony openpne:migrate 431 16:15 ./symfony plugin:publish-assets 432 16:24 ./symfony cc 433 16:33 history k222#
php3.3.2で動作確認する k222 > piano へ移す
105 7:30 scp k222.kuji-clinic.net:/usr/local/www/apache22/data/openpne-OpenPNE3-OpenPNE-3.6beta1-0-g79b2df2.zip ./ 107 7:31 unzip openpne-OpenPNE3-OpenPNE-3.6beta1-0-g79b2df2.zip
inflating: openpne-OpenPNE3-79b2df2/web/pc_frontend.php inflating: openpne-OpenPNE3-79b2df2/web/pc_frontend_dev.php extracting: openpne-OpenPNE3-79b2df2/web/robots.txt finishing deferred symbolic links: openpne-OpenPNE3-79b2df2/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/test/functional/fixtures/config/doctrine/linked_schema.yml -> ../../data/linked_schema.yml piano:root {108} % ll
111 7:38 mv openpne-OpenPNE3-79b2df2 OpenPNE3.6beta1 114 7:39 chown -R www:www OpenPNE3.6beta1
$ ./symfony openpne:install --non-recreate-db
>> file- /usr/local/www/data/OpenPNE3.6beta1/cache/root/api/prod/config/config_autoload.yml.php Couldn't locate driver named mysql
でインストール中断。
portinstall databases/php5-pdo_mysql
apachectl restart $ ./symfony openpne:install --non-recreate-db
PDO Connection Error: SQLSTATE[28000] [1045] Access denied for user 'rsb'@'localhost' (using password: YES)
phpMyAdminからrsbユーザを作成。
$ ./symfony openpne:install --non-recreate-db
で、インストール完了したが、DBのmemberはOpnePNE君だけだった
で、もういちど、DBをインポートするもエラー
で、既存のDBを削除、あらたにRSBのDBをインポート。
http://piano.smb.net/OpnePNE3/ へアクセスすると、「現在、サーバが混み合っているか、メンテナンス中です。 」というエラー apacheのエラーログは
[Sat Aug 14 11:56:23 2010] [error] [client 219.117.246.208] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'p.is_public_web' in 'field list', referer: http://piano.smb.net/OpnePNE3/album [Sat Aug 14 11:56:28 2010] [error] [client 219.117.246.208] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'p.is_public_web' in 'field list', referer: http://piano.smb.net/OpnePNE3/album [Sat Aug 14 11:57:06 2010] [error] [client 219.117.246.208] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'p.is_public_web' in 'field list', referer: http://piano.smb.net/OpnePNE3/album
とのことなので、album plugin のカラムが足りない?で、
piano:root {115} % ./symfony openpne:migrate --target=opAlbumPlugin
する。
install は、
日記の公開範囲に、「Web全体に公開」とあるのを消去する。
k222# cd /usr/local/www/apache22/data/OpenPNE3_6b/plugins/opDiaryPlugin/lib/model/doctrine k222# cp PluginDiaryTable.class.php PluginDiaryTable.class.php-orig k222# vi PluginDiaryTable.class.php protected static $publicFlags = array( # self::PUBLIC_FLAG_OPEN => 'All Users on the Web', この行をコメントアウト self::PUBLIC_FLAG_SNS => 'All Members', self::PUBLIC_FLAG_FRIEND => '%my_friend%', self::PUBLIC_FLAG_PRIVATE => 'Private', );
http://sns.openpne.jp/communityTopic/6262
488 17:51 grep pcAddress -r /usr/local/www/apache22/data/OpenPNE3_6b/ 489 17:52 cd /usr/local/www/apache22/data/OpenPNE3_6b/lib/config/config 490 17:52 ll 491 17:53 cp member_config.yml member_config.yml-orig
で、member_config.yml の59行あたりから、コメントアウト
1: "All Members" 2: "%my_friend%" 3: "Private" #pcAddress: # _attributes: # caption: "PC E-mail Address Configuration" # enable_pc: true # enable_mobile: true # depending_sns_config: enable_pc # pc_address: # Name: "pc_address" # Caption: "PC E-mail Address" # FormType: "input" # ValueType: "pc_email" # IsRegist: false # IsConfig: true # IsRequired: true # IsUnique: true # IsConfirm: true mobileAddress: _attributes: caption: "Mobile E-mail Address Configuration" enable_pc: true enable_mobile: true