From owner-freebsd-questions@FreeBSD.ORG Wed Sep 7 19:38:49 2005 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 0EC6716A420 for ; Wed, 7 Sep 2005 19:38:49 +0000 (GMT) (envelope-from vizion@vizion.occoxmail.com) Received: from lakecmmtao05.coxmail.com (lakecmmtao05.coxmail.com [68.99.120.79]) by mx1.FreeBSD.org (Postfix) with ESMTP id 56B0543D7D for ; Wed, 7 Sep 2005 19:38:40 +0000 (GMT) (envelope-from vizion@vizion.occoxmail.com) Received: from dns1 ([64.58.171.82]) by lakecmmtao05.coxmail.com (InterMail vM.6.01.05.02 201-2131-123-102-20050715) with ESMTP id <20050907193840.SXN2425.lakecmmtao05.coxmail.com@dns1>; Wed, 7 Sep 2005 15:38:40 -0400 From: Vizion To: bob self , freebsd-questions@freebsd.org Date: Wed, 7 Sep 2005 12:34:30 -0700 User-Agent: KMail/1.8 References: <001301c5b3b1$1b6f27e0$59830acf@dennylaptop2> <200509071033.21972.vizion@vizion.occoxmail.com> <431F3002.5040409@charter.net> In-Reply-To: <431F3002.5040409@charter.net> MIME-Version: 1.0 Content-Type: text/plain; charset="windows-1250" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200509071234.31094.vizion@vizion.occoxmail.com> Cc: Subject: Re: phpbb installation X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 07 Sep 2005 19:38:49 -0000 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 cp -rp ../phpBB2 . > >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: > > > \$link = mysql_connect(\"localhost\", \"root\", \"**********\") or >die(\"Could not connect: \" . mysql_error() . \"\\n\"); > > \$cmd = \"GRANT ALL ON forum1.* > TO user@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); > > >5. cd to .../forum1 and chmod 666 config.php > >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@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 chmod 644 config.php > >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.