phpbb installation

[Vizion]

On Wednesday 07 September 2005 11:22,  the author bob self contributed to the 
dialogue on-
 Re: phpbb installation: 

>Vizion wrote:
>
>...
>
>Here are some recent notes that I made about installing phpBB2 on 5.4:
>
>Here's the procedure for creating multiple forums.
>
>1. get a copy of phpBB-2.0.17.zip (or whatever the current version is).
>Unzip it into a directory. This will be the template
>   for each new forum that you want to create.
>
>2. pick a name for the forum, eg 'forum1'. Create a directory called
>forum1 under your root page, eg /usr/local/www/username/forum1.
>   You should also have /usr/local/www/username/phpBB2 here with all of
>the original phpBB files.
>
>3. cd to forum1 and <b>cp -rp ../phpBB2 .</b>
>
>4. Next you need to give your mysql user privileges to create this
>database and then create an empty database called 'forum1'.
>   I run this php script to set up mysql before installing phpBB for
>this forum:
>
><b>
>   \$link = mysql_connect(\"localhost\", \"root\", \"**********\") or
>die(\"Could not connect: \" . mysql_error() . \"\\n\");
>
>   \$cmd = \"GRANT ALL ON forum1.*
>            TO user at localhost
>            IDENTIFIED BY '**********'
>            WITH GRANT OPTION\";
>   mysql_query(\$cmd) or die(\"grant error \" . mysql_error() . \"\\n\");
>
>   \$cmd = \"flush privileges\";
>   mysql_query(\$cmd) or die(\"flush privileges error \" . mysql_error()
>. \"\\n\");
>
>   mysql_close(\$link);
>
>   // now have 'user' create the database:
>
>   \$link = mysql_connect(\"localhost\", \"user\", \"**********\") or
>die(\"Could not connect: \" . mysql_error() . \"\\n\");
>   \$cmd = \"create database forum1;\";
>   mysql_query(\$cmd) or die(\"grant error \" . mysql_error() . \"\\n\");
>   mysql_close(\$link);
></b>
>
>5. cd to .../forum1 and <b>chmod 666 config.php</b>
>
>6. Now point your browser to .../forum1/install/install.php
>
>   Basic Configuration
>
>      Default board language:             English
>      Database Type:                      mysql 4.x
>      Choose your installation method:    install
>
>   Database Configuration
>
>      Database Server Hostname / DSN:     localhost
>      Your Database Name:                 forum1
>      Database Username:                  user
>      Database Password:                  ********
>      Prefix for tables in database:      forum1_
>
>   Admin Configuration
>
>      Admin Email Address:                user at x.org
>      Domain Name:                        www.user.lan
>      Server Port:                        80
>      Script path:                        /forum1/
>      Administrator Username:             user
>      Administrator Password:             ******
>      Administrator Password [ Confirm ]: ******
>
>
>7. cd to .../forum1 and <b>chmod 644 config.php</b>
>
>8. remove the .../forum1/install and .../forum1/contrib directories.
Hey

Thank you very much - I will use that I soon as I get over the problem with 
install.php which produces a blank screen (I have reported the issue to the 
phpbb forum and cc'd to freebsd-questions.

Thanks again for your help

david


-- 
40 yrs navigating and computing in blue waters.
English Owner & Captain of British Registered 60' bluewater Ketch S/V Taurus.
 Currently in San Diego, CA. Sailing bound for Europe via Panama Canal after 
completing engineroom refit.