phpBB on FreeBSD

CONTENTS

phpbb3 と php56-mysql
font-familyの変更
phpBB3 Japanese LP のインストールメモ
- Data Backup
----
Installing phpbb-2.0.23...
phpBB のインストールメモ

Lastmodified　2018-08-14 (火) 07:43:23

phpbb3 と php56-mysql†

phpbb3.2.2をクリーンインストールしたら、php56-mysqlがインストールされてなくて、Errorをいただく。　

# portinstall databases/php56-mysql

【Solved!】

↑

font-familyの変更†

font-family は、

/usr/local/www/XPJ/styles/prosilver/theme/stylesheet.css

@import url("normalize.css?v=3.2");
@import url("base.css?v=3.2");
@import url("utilities.css?v=3.2");
@import url("common.css?v=3.2");
@import url("links.css?v=3.2");
@import url("content.css?v=3.2");
@import url("buttons.css?v=3.2");
@import url("cp.css?v=3.2");
@import url("forms.css?v=3.2");
@import url("icons.css?v=3.2");
@import url("colours.css?v=3.2");
@import url("responsive.css?v=3.2");

【参考サイト】 http://dev.activebasic.com/egtra/2017/04/08/964/

なお、実際には、phpBB3/styles/subsilver2/theme/jaに日本語フォントに関するfont-familyの指定を追加しています。それについては、直接https://www.activebasic.com/forum/styles/subsilver2/theme/ja/stylesheet.cssを見てください。

https://www.activebasic.com/forum/styles/subsilver2/theme/ja/stylesheet.css

body {
	font-family: "Lucida Grande", Verdana, Helvetica, Arial, HiraginoSans, Meiryo, sans-serif;
}
.forumrules, .copyright, input, textarea, select, .btnbbcode, .codetitle {
	font-family: inherit;
}
h1, .postbody, .quotecontent, .attachcontent {
	font-family: "Lucida Grande", "Trebuchet MS", HiraginoSans, "Hiragino Kaku Gothic ProN", Meiryo, sans-serif;
}
h2, h3 {
	font-family: Helvetica, Arial, HiraginoSans, "Hiragino Kaku Gothic ProN", Meiryo, sans-serif;
}
.titles, a.forumlink, a.topictitle, input {
	font-family: "Lucida Grande", Helvetica, Arial, HiraginoSans, Meiryo, sans-serif;
}
.codecontent, pre {
	font-family: Monaco, Consolas, monospace;
}

↑

phpBB3 Japanese LP のインストールメモ†

https://www.phpbb.com/downloads/

https://www.phpbb.com/languages/index.php?first_char=j#package_list

https://www.phpbb.com/customise/db/translation/japanese/

/usr/local/www/phpBB3/.htaccess: RewriteEngine not allowed here

http://hig3.hatenadiary.com/entry/20091115/1258238075

phpBB3.conf

Alias /phpBB3 "/usr/local/www/phpBB3/"
<Directory "/usr/local/www/phpBB3/">
    RewriteEngine On
	Options +SymLinksIfOwnerMatch +ExecCGI
 	AllowOverride FileInfo AuthConfig 
    Require all granted
</Directory>

/usr/local/www/phpBB3/language/ja/acp/common.php

/usr/local/www/phpBB3/language/ja/common.php

'COLON' => ':',

↑

Data Backup†

CP上のバックアップはDB（MySQL）のデータ。
画像などは、FQDN:/usr/local/www/phpBB3/files　以下にある。

↑

----†

↑

Installing phpbb-2.0.23...†

----------------------------------------------------------------------------
phpBB2 has been installed, but is not quite ready to be used yet!

You have to ensure that you have a database server (or ODBC access to a
remote database) installed and configured, and you have to ensure that your
PHP installation has been compiled with support for your database or
database access method.  You have to create a database for phpBB2 to use,
and ensure that this database may be accessed and changed by the user id
under which your web server executes.  Further information on these
installation procedures may be found in: 

  /usr/local/share/doc/phpbb/README.html

Once these steps have been taken, you may connect to the following URL to
configure your installation of phpBB2:

  http://localhost/phpBB2/

After configuring phpBB2 and ensuring that it is operational, you MUST
delete the following files manually for security purposes from
/usr/local/www/phpBB2:

  /usr/local/www/phpBB2/install/install.php /usr/local/www/phpBB2/install/upgrade.php /usr/local/www/phpBB2/install/update_to_latest.php

Duplicates of these files have been installed to /usr/local/share/phpbb.
/usr/local/share/phpbb/contrib contains contributed software for phpBB2.
----------------------------------------------------------------------------

↑

phpBB のインストールメモ†

http://sourceforge.jp/projects/phpbb2i18n/releases/

/usr/home/tfc/public_html/ へ　phpBB2-0-23eucjp_full_rev1-0-0.zipをおき、

# cd /usr/home/tfc/public_html/
# unzip phpBB2-0-23eucjp_full_rev1-0-0.zip
# chown -R www:www forum/
# chmod -R 775 forum/
# chmod -R 777 forum/images/avatars/

↑

MySQLでデータベースを作る†

% mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 202
Server version: 5.1.28-rc-log FreeBSD port: mysql-server-5.1.28_1

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

mysql> create database TFC;
Query OK, 1 row affected (0.00 sec)

mysql> use TFC
Database changed
mysql> grant all privileges on TFC.*
    -> to tfc@localhost identified by 'tasaka';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> exit

↑

phpBB の初期設定†

http://www.thousand-winds.net/~tfc/forum/install/install.php　へアクセス。

↑

削除・？†

% cd /usr/home/tfc/public_html/forum
% mv install/ install-dist
% mv contrib/ contrib-dist

http://www.kozupon.com/db/mysql.html

↑

database の削除†

piano:root {117} % mysqladmin -u root -p drop TFC
Enter password:
Dropping the database is potentially a very bad thing to do.
Any data stored in the database will be destroyed.

Do you really want to drop the 'TFC' database [y/N] y
Database "TFC" dropped