OpenPNE-3 on FreeBSD 7.1

OpnePNE 3.6beta1 > beta2

  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

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

install は、

OpnePNE 3.6beta1

opDiaryPlugin

日記の公開範囲に、「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設定変更を消す

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

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