/
cookbook_phpbb.txt
231 lines (181 loc) · 8.89 KB
/
cookbook_phpbb.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
== link:index.html[Index] -> link:cookbook.html[Cookbook]
///////////////////////////////////////////////////////////////////
Last checked:
* Cherokee 0.99.25
* phpBB 3.0.5
///////////////////////////////////////////////////////////////////
Cookbook: Setting up phpBB
--------------------------
You will need PHP support correctly configured in Cherokee, and PHP
with the MySQL module installed. The default configuration already
provides a valid PHP configuration for Cherokee if you have `php-cgi`
installed, but you can follow the appropriate recipe about
link:cookbook_php.html[setting up PHP] in case you don't have it
available for some reason.
Under these conditions, you could start the installation and you
would already be able to have your site up and running.
Installation
~~~~~~~~~~~~
link:http://www.phpbb.com[phpBB] can be installed quite
easily. Download the link:http://www.phpbb.com/downloads/[latest
package], decompress it and point your browser to the corresponding
URL.
In this example, we will be installing everything under
`/var/www/phpBB3` and will set that as `document root` in
cherokee-admin for our server, which will be hosting contents for the
domain `example.net`. You can modify this going to `Virtual servers`
-> `default` -> `Basics` -> `Document Root`. You can delete all the
unnecessary rules of your default out-of-the-box configuration.
image::media/images/cookbook_phpbb_rules.png[phpBB basic rules]
This is all you need to do with Cherokee, for now.
If you intend to use the same domain, insert the appropriate entry in
your `/etc/hosts` or equivalent file.
.Entry for your /etc/hosts
----
127.0.0.1 localhost example.net
----
First download the
link:http://www.phpbb.com/downloads/olympus.php[phpBB3] package and
proceed decompressing it to the desired path.
Second, create the database for the installation. Log in to MySQL with
your administration user and password:
----------------
mysql -u root -p
----------------
And create the database. We will be using the name
'phpbb', the user 'phpbbuser' and the password 'phpbbpassword', but
you should set up your own.
------------------------------------------------------------------------
CREATE DATABASE phpbb;
GRANT ALL PRIVILEGES ON phpbb.* TO phpbbuser@localhost IDENTIFIED BY 'phpbbpassword';
GRANT ALL PRIVILEGES ON phpbb.* TO phpbbuser@localhost.localdomain IDENTIFIED BY 'phpbbpassword';
FLUSH PRIVILEGES;
quit;
------------------------------------------------------------------------
[[wizard]]
Configuring with the Wizard
~~~~~~~~~~~~~~~~~~~~~~~~~~~
`Cherokee-Admin` provides a wizard for phpBB that will configure the
web server appropriately. Just find it under the `Web Applications`
category, provide some basic information and you are good to go.
Then point your web browser to `http://example.net` and follow all the
steps. Basically you will have to provide the database information and
troubleshoot any possible warning, but the process is fairly straight
forward.
.Introduction
image::media/images/cookbook_phpbb_1_intro.png["phpBB step1"]
.Requirements
image::media/images/cookbook_phpbb_2_req.png["phpBB step2"]
.Database settings
image::media/images/cookbook_phpbb_3_db.png["phpBB step3"]
.Administrator details
image::media/images/cookbook_phpbb_4_admin.png["phpBB step4"]
.Configuration file
image::media/images/cookbook_phpbb_5_config.png["phpBB step5"]
.Advanced settings
image::media/images/cookbook_phpbb_6_advanced.png["phpBB step6"]
.Create database tables
image::media/images/cookbook_phpbb_7_create.png["phpBB step7"]
.Final stage
image::media/images/cookbook_phpbb_8_final.png["phpBB step8"]
Once you are done you will be redirected to the `Administration
control panel`. If not, you should have a link at the bottom of the
page. You need to eliminate the `/var/www/phpBB3/install`
subdirectory or you will not be allowed to go any further.
.Warning
image::media/images/cookbook_phpbb_adm_warning.png[phpBB]
It is just a security precaution. Once you have done this, you can
proceed.
.After deletion
image::media/images/cookbook_phpbb_adm.png[phpBB]
The basic installation is done. You can see the software running just
by accessing link:http://example.net/[http://example.net/]
.phpBB running
image::media/images/cookbook_phpbb_running.png[phpBB]
URL rewrites
~~~~~~~~~~~~
To beautify your URLs you will need to write some redirection rules
and apply some patches. This feature seems to not be supported in
phpBB, so you will have to download phpBB's `mod_rewrite` module and
apply the patch. There are several alternative patches available from
different sources. Since you will need to modify by hand some code,
your best alternative is probably sticking to some pre-modded version.
One such version is link:http://www.phpbb-seo.com/[phpBB SEO]. Make
sure the release you are using matches that of your installed phpBB.
After applying the fixes, mostly overwriting the files with the ones
provided, you will have to generate an .htaccess file. It will not
work for Cherokee, but it will give you the rewrite-directives that
need to be translated.
These need to be created as `Regular Expression` type rules that match
our translated directives. The rules must be `Final` and managed by
the `Redirection` handler. Within the handler you will need to specify
only the type -`Internal` - and substitution to perform. The regular
expression is inherited, so no need to re-type it.
Just one precaution must be taken before you start playing around with
rewriting rules. Despite these, you will probably want to ensure that
existing files, directories or symbolic links are
used instead of matching (and re-directing) them with rewrite rules.
To do this you will have to create one `File exists`-type rule that
matches any file and that is both `Final` and managed by the `list &
send` or `static` handlers.
Once you start creating new rules, just make sure to keep the PHP -non
final- one at the top of the list and that the next one is your static
file managing rule.
This is a set of rewrites that is known to have worked with phpBB3 and
`phpBB-SEO simple`. Please use them as an orientation, since they
could very well fail with the specific `phpBB mod_rewrite` patch you
are using.
.Basic forum access
[cols="30%,70%"]
|======================================================================
|Regular Expression |+++^/[a-z0-9_-]*-f([0-9]+)/?(p([0-9]+)\.html)?$+++
|Substitution | +++/viewforum.php?f=$1&start=$3+++
|======================================================================
.Topics with virtual folder
[cols="30%,70%"]
|==========================================================================================
|Regular Expression |+++^/[a-z0-9_-]*-f([0-9]+)/[a-z0-9_-]*-t([0-9]+)(-([0-9]+))?\.html$+++
|Substitution |+++/viewtopic.php?f=$1&t=$2&start=$4+++
|==========================================================================================
.Global announces with virtual folder
[cols="30%,70%"]
|==============================================================================
|Regular Expression |+++^/announces/[a-z0-9_-]*-t([0-9]+)(-([0-9]+))?\.html$+++
|Substitution |+++/viewtopic.php?t=$1&start=$3+++
|==============================================================================
.Topic without forum ID & DELIM
[cols="30%,70%"]
|==================================================================================
|Regular Expression |+++^/[a-z0-9_-]*/?[a-z0-9_-]*-t([0-9]+)(-([0-9]+))?\.html$+++
|Substitution |+++/viewtopic.php?t=$1&start=$3+++
|==================================================================================
.Profiles
[cols="30%,70%"]
|===============================================================
|Regular Expression |+++^/m([0-9]+)\.html$+++
|Substitution |+++/memberlist.php?mode=viewprofile&u=$1+++
|===============================================================
.User messages
[cols="30%,70%"]
|====================================================================
|Regular Expression |+++^/messages([0-9]+)(-([0-9]+))?\.html$+++
|Substitution |+++/search.php?author_id=$1&sr=posts&start=$3+++
|====================================================================
.Groups
[cols="30%,70%"]
|==================================================================
|Regular Expression |+++^/g([0-9]+)(-([0-9]+))?\.html$+++
|Substitution |+++/memberlist.php?mode=group&g=$1&start=$3+++
|==================================================================
.Post
[cols="30%,70%"]
|=============================================
|Regular Expression |+++^/p([0-9]+)\.html$+++
|Substitution |+++/viewtopic.php?p=$1+++
|=============================================
.The team
[cols="25%,75%"]
|====================================================================================
|Regular Expression |+++^/the-team\.html$ /memberlist.php?mode=leaders+++
|Substitution |+++^/[a-z0-9_-]+/?(p([0-9]+)\.html)?$ /viewforum.php?start=$2+++
|====================================================================================