[[OpenPNE-3 on FreeBSD 7.1]] #contents *DEVの時のアイコン [#b1bd8d99] http://piano.smb.net/OpenPNE_git/pc_frontend_dev.php/communityTopic/new/1? など、デバッグ画面を表示すると、デバッグ用のツールバーアイコンが×になるのを回避。 /OpenPNE3/web/ piano:root {119} % ln -s ../lib/vendor/symfony/data/web/sf ./ する。 *OpnePNE 3.6beta1 > beta2 [#z69401c9] 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# *OpnePNE 3.6beta1 install [#w147f0e9] 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 する。 *OpnePNE 3.6beta1 [#kc47fd4a] install は、 **OpnePNE 3.6beta1 [#b02e27a3] **opDiaryPlugin [#xa5517b4] 日記の公開範囲に、「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', ); **PCMailaddress設定変更を消す [#r30cc414] 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 **ヘッダーのロゴマークを変更 [#d885bf93] &ref(skin_header_logo-orig.jpg); &ref(skin_header_logo.jpg); ヘッダーのロゴマークを変更するっ! ロゴマークは、意外にもふかぁ~いところにある。しかもバージョンにより位置が違う. ファイル名は、skin_header_logo.jpgだが、ファイル名にたどり着けるのは、http-access.log しかなさそう・・・ k222# locate skin_header_logo.jpg /usr/home/OpenPNE-3.0.2/web/images/skin_header_logo.jpg /usr/local/www/apache22/data/OpenPNE-3.0.2/web/images/skin_header_logo.jpg /usr/local/www/apache22/data/OpenPNE-3.0.2-old/web/images/skin_header_logo.jpg /usr/local/www/apache22/data/OpenPNE-3.0.8/web/images/skin_header_logo.jpg /usr/local/www/apache22/data/OpenPNE3/plugins/opSkinBasicPlugin/web/images/skin_header_logo.jpg /usr/local/www/apache22/data/OpenPNE3.4.0/plugins/opSkinBasicPlugin/web/images/skin_header_logo.jpg /usr/local/www/apache22/data/OpenPNE3.6.beta/plugins/opSkinBasicPlugin/web/images/skin_header_logo.jpg /usr/local/www/apache22/data/OpenPNE346/plugins/opSkinBasicPlugin/web/images/skin_header_logo.jpg /usr/local/www/apache22/data/OpenPNE3_4_6/plugins/opSkinBasicPlugin/web/images/skin_header_logo.jpg /usr/local/www/apache22/data/OpenPNE3_6b/plugins/opSkinBasicPlugin/web/images/skin_header_logo.jpg /usr/local/www/apache22/data/OpenPNE3_6b/plugins/opSkinBasicPlugin/web/images/skin_header_logo.jpg-orig /usr/local/www/apache22/data/OpenPNE3_est/plugins/opSkinBasicPlugin/web/images/skin_header_logo.jpg /usr/local/www/apache22/data/openpne-OpenPNE321/web/images/skin_header_logo.jpg