I'm running it on about 4 different windows 2003 machines. Setting up the
first time is sometimes a headache (Two are SQL Server backend to it, other
two are mySQL). Be sure you have downloaded and installed the ODBC driver
for mySQL from mySQL's site.
Warning: There's a million things that could be wrong. If you are not
familiar with PHP and mySQL and how to use them together, I wouldn't use it.
If the database is on a different machine, make sure your mySQL settings
allow remote connection and your database user has connection from remote
turned on.
First, test to make sure PHP can connect by itself:
$dbhost = "localhost"; //computer name or IP address
$dbuser = "root"; //database login name
$dbpass = "testpass"; //database password
$db = "mydatabase"; //database name
$dbConn = @mysql_connect($dbhost, $dbuser, $dbpass) or die(mysql_error() .
"The site database is down. Please try logging on later.");
if ($db!="" and [EMAIL PROTECTED]($db))
die("The site database is unavailable. Please try logging on
later.");
Create your database, run setup by hand following instructions included in
the download. (Simply run the SQL scripts in the install folder for your
database), then change your config.php by adding this line:
<?php
define('PHPBB_INSTALLED', true);
?>
Also, edit the database fields in there to match your connection method
(Here's one of mine using SQL Server)
<?
$dbms = 'mssql-odbc';
$dbhost = 'localhost';
$dbname = 'mydatabase';
$dbuser = 'root';
$dbpasswd = ' testpass';
$table_prefix = 'phpbb_';
define('PHPBB_INSTALLED', true);
?>
You'll also have to delete the install directory and one other directory (I
forgot which one, but when you try to go to the site, it will alert what
directories need to be deleted).
One common problem is the PHP installed, it doesn't move the DLLs to the
right place, so you have to copy them from their extension folders to
windows/system32/ manually.
Also, some mysql installers mess up your mySQL passwords so you have to go
reset your users password manually from mySQL command line.
It is a really cool BBS once you get it installed. FYI: be sure to signup
on the mailing list. A worm last year attacked a flaw in PHPBB and broke
into a lot of unpatched sites. I got hacked one time through a PHPBB hole a
few years ago. I now update it regularly.
Then you have to setup mySQL backup rountines to backup the databases
nightly. mySQL has become corrupt a few times for me and I have to restore
from the previous nights backup.
Jacob
Jacob Cameron
Blue Lantern, Inc.
(972) 226-9595
[EMAIL PROTECTED]
http://www.bluelantern.com
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Kevin Fricke
Sent: Tuesday, January 03, 2006 1:35 PM
To: CFLIST
Subject: [DFW CFUG] Phpbb?????????/
I have been trying to install the phpbb for a client most of the day. I am
to the point where I will give up if it doesn't work soon.
Can anyone give me any guidance.
I am trying to install it on:
2003 Server
PHP 4.4 (although I also tried 5)
mySQL 4.1 (although I also tried 5)
I am very, very frustrated as I constantly get connection errors with
mySQL.......
Please help.......
(if anyone knows of a good alternative, I'm all ears)
Thanks,
Kevin
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.HostMySite.com
www.teksystems.com/
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.HostMySite.com
www.teksystems.com/
