Date: Wed, 7 Sep 2005 12:34:30 -0700 From: Vizion <vizion@vizion.occoxmail.com> To: bob self <bobself@charter.net>, freebsd-questions@freebsd.org Subject: Re: phpbb installation Message-ID: <200509071234.31094.vizion@vizion.occoxmail.com> In-Reply-To: <431F3002.5040409@charter.net> References: <001301c5b3b1$1b6f27e0$59830acf@dennylaptop2> <200509071033.21972.vizion@vizion.occoxmail.com> <431F3002.5040409@charter.net>
next in thread | previous in thread | raw e-mail | index | archive | help
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@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@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.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200509071234.31094.vizion>