Julian Cook & James C. Rocks
Modified by Fred Pettis


Requirements

Notes
This document assumes the user to be capable of setting up a Windows 2000 server with a fully functioning IIS web server and that a number of packages are pre-downloaded. MySQL Administrator 1.0.21 is not strictly necessary for a functional forum (see later). The user must also be familiar with information about the target system such as passwords, machine names and similar … default values are supplied & used in this document, but the user may substitute alternatives in most cases


Hardware
* Windows 2000 server with IIS installed and running (you DO need to test that your web server is working). The system should be patched with the latest Service Pack (at time of writing SP4) and Microsoft security updates.
* Approximately 1GB free space on C: Drive (this is a generous estimation of space requirements) … these packages can be set up in non-default locations but we strongly advise you to stick to defaults where possible. The target drive should be fully defragged something that is particularly important on older, less well specified, systems.


Software
• MySQL v4.x (at time of writing 4.1)
• PHP v4.4.x installer and the PHP v4.4.x zip package (at time of writing 4.4.0)
• MySQL Administrator (at time of writing the alpha version 1.0.21) ... this is not strictly speaking necessary for full forum function (see later).
• phpBB2 Forum software (at time of writing 2.0.17)


Information
Server Name: ServerName
IP Address: IPAddress
Host Name: localhost
Data Source Name: datasource
Database: database (ex. phpBB)
User: user (ex. root)
Password: password
Forum directory: forum
Forum Administrator: Admin
Forum Admin PW: AdminPW
SMTP Server: smtp.yourdomain.com
E-Mail Address: email@yourdomain.com


PHP 4.4.x
1. Install PHP by running the executable php-4.4.x-installer.exe.
2. Accept all defaults until the Mail Configuration dialog where you enter your SMTP server address as smtp.yourdomain.com and your e-mail as email@yourdomain.com.
3. Continue with defaults clicking OK twice to finish the installation.
4. Copy the contents of the PHP 4.4.x zip package to the PHP installation folder allowing it to overwrite any files. Give IUSR_MachineName read write access to the uploadtmp and session directories, and execute access for php.exe and php4ts.dll.
5. Click the Start Menu then Programs --> Administrative Tools --> Internet Services Manager (this can also be done by opening Control Panel, double-clicking on "Administrative Tools" and then on "Internet Services Manager") ... a dialogue called "Internet Information Services" will appear. In the left hand pane there will be a computer displayed, this is the computer you are running IIS from.
6. Click on the "+" next to your computer to see a number of sub-folders revealed.
7. Right-click on "Default Web Site" (it is possible you may have renamed "Default Web Site" to something else) and select "Properties" and, at the "Default Web Site Properties" dialog, select the "Documents" tab.
8. Click the "Add" button and in the "Add Default Document" dialog enter "index.php" ... use the available arrow buttons to ensure that index.php is as high a priority as possible e.g. in second place behind index.htm.
9. Click "OK" several times until you exit the dialogs and close the "Internet Information Services" dialog.


MySQL v4.1.xx
Notes
The use of MySQL Administrator (steps 8 through 13) is not strictly necessary however it was found during testing to be a superior tool than some others and shields the user from the complexities of command line arguments. When defining the user (step 12) not that it is advisable to restrict that users access only to the necessary databases and options and that the values shown are simply defaults. It is not strictly necessary to start and stop the SQL service (step 5) however our experience leads us to suggest it is advisable.

1. Install by running setup.exe and accepting all defaults.
2. Click Start=>Programs=>MySQL=>MySQL Server 4.1=>MySQL Server Instance Config Wizard.
3. (I’m not sure if this is 100% correct, but it works) Here are the options I used at each screen:


4. Find the file "my.ini", briefly check that the following settings are correct (paths to installation):


If all appears correct click save.
5. Right-click on "My Computer", select "Manage", "Services" and find the "MySQL" Service. Ensure that it is running and, if necessary, set to automatic then stop and start the service to ensure that it has picked up the new "my.ini" settings.
6. Close "Computer Management".
7. Run "MySQL Command Line Client" provide root password at the prompt. Type in the following commands:


8. Install "MySQL Administrator" accepting all defaults except at the "Licence Agreement" dialog where you must select "I accept the license agreement".
9. Run "MySQL Administrator" (there should be an icon on the desktop). Check the following values as correct (you may alter these as needed):



10. Enter Password and click “OK”.
11. Click on “Startup Variables”, then on the “Security” tab. Check the box next to “Use old passwords”. Click “Apply Changes”.
12. Click "User Administration", select "root" and click on the “Schema Priviledges” tab. Select your phpBB database from the list, then click “<<”. Click “Apply Changes”. (Do the same for localhost under root)
13. Close "MySQL Administrator"
14. Stop and start the “MySQL” service.

MySQL Password Fix
Note
This fixes a compatibility problem between PHP 4.4.x and MySQL with passwords. MySQL 4.1 and up uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older clients (PHP 4.4.x) . This should be fixed in future versions.

1. Reset the password to pre-4.1 style. This can be done using the SET PASSWORD statement and the OLD_PASSWORD() function. Run "MySQL Command Line Client" provide root password at the prompt. Type in the following commands:

Substitute the password you want to use for “newpwd” in the preceding example. MySQL cannot tell you what the original password was, so you'll need to pick a new one. If you want to use the one you chose in the initial setup, run this twice. The first time using a dummy password, and the second using your initial password.
2. Type “\q” to exit.


phpBB2
Note
On one machine the second "Welcome to phpBB 2 Installation" page (step 5) was noted not to appear however in that case the forum software was found to have installed correctly.

1. Create the folder forum in your website (normally "c:\inetpub\wwwroot") and extract & copy the phpBB2 files to it.
2. Run Internet Explorer and type in http://<Server Name>/forum/index.php and you should be presented with the phpBB2 installation page. This step can potentially present problems and you may need to substitute either "localhost" or the server's IP address for the "<Server Name>".
3. At the "Welcome to phpBB 2 Installation" web page enter the following settings:



4. Click (once only) the "Start Install" button ... this should a second "Welcome to phpBB 2 Installation" web page.
5. Select "Just send the file to me and I'll FTP it manually" and click "Download config" ... when offered the opportunity to save install.php elect to save the file to your forum folder (you will get a "replace Yes/No" style message).
6. Close Internet Explorer.
7. In Windows 2000 Explorer (not Internet Explorer) go to your forum folder, create a new folder called "backup" and move the "contrib" and "install" folders to it. Alternatively the "contrib" and "install" folders can simply be deleted.
8. Close Windows 2000 explorer.


Running phpBB2 For The first time
Finally run up Internet Explorer and enter the URL http://<Server Name>/forum and you should be presented with your very own forum. Again this step can potentially present problems and you may need to substitute either "localhost" or the server's IP address for the "<Server Name>".

References
* "How To setup a full IIS web server with everything you need to run phpBB", DanielT