Page 1 of 1

Having Problem Intalling MySQL and Simple Machines (SMF)

Posted: Sat Jan 13, 2007 7:40 pm
by BobH - TAN
If this is an inappropriate post or if I've posted in the wrong place, my humblest apologies. Please explain my error to me and I'll desist.

The Problem:
Although I can run phpinfo.php in Firefox at /localhost/ and see configuration options for Apache and PHP, no options for MySQL display. Also, I cannot install SMF because MySQL apparently isn't installed. (I posted on the SMF forum and had extensive debugging exchanges with two different moderators but have been unable to resolve the issue in more than 2 weeks now.) I can, and do, use /localhost/ to view pages under development. Blumental's HTMLPad2006 is my editor of choice; it works with my webserver install. I think Apache and PHP are installed correctly but possibly not configured correctly. I don't know if MySQL is installed or, if installed, configured correctly.

Background:
I built a very simple web page about a year ago to amuse myself and support my old high school classmates (from the 50's). I've learned a lot. I installed and customized the Simple Machines Forum (SMF) and want to learn a great deal more about PHP. To that end, I read here and elsewhere that I must have a web server on my local machine -- I was wearing out the bits uploading them to my hosted space 8O -- and my roundtuit finally came to me.

After reading many websites - including this one, PHP, Apache, SMF and others - I downloaded and installed Apache 2.2.3, PHP 5.0.27 and MySQL 5.2.0 in Windows XP-Pro on a 3GHZ machine with 2GB RAM and .7TB of HD. I installed Apache/PHP/MySQL in that order, all in the C:/Program Files/ directory, but each in its own sub-directory. In other words, they are not all installed in the same sub-directory of /Program Files/. I installed the Windows installer versions of everything, then went back and downloaded and unzipped the binaries for MySQL. I also downloaded and installed HeidiSQL. I backed up my forum database files -- using the forum tools -- and imported those .sql files using Heidi; but I don't know if they installed, nor how to test to see if they are because I can't get SMF to install.

I modified the Apache httpd.conf file to define the PHPIniDir path (C:/Program Files/php) and inserted these lines:

Code: Select all

LoadModule php5_module "c:/Program Files/php/php5apache2_2.dll" 
AddType application/x-httpd-php .php

# +++++++++++++++++++++++++++  Changed 08Jan2007 - rhh
#ServerAdmin webmaster@broughton1960.com
ServerAdmin admin@localhost.com]

# ++++++++++++++++++++++++++   Changed 07Jan2007 - rhh 
#ServerName www.broughton1960.com:80
ServerName localhost:80

I copied the php.ini file to C:/Windows/ and modified it as follows:

Code: Select all

;extension_dir = "C./"  +++++++++++  Changed -09Jan2007 = rhh
extension_dir = "C:/Program Files/PHP/ext"

;+++++++    php_mysql.dll uncommented 09Jan2007 - rhh;
extension=php_mysql.dll
As you can see, I was careful to document my changes (and to make backups before making any changes. The steps and the changes are the result of my reading and advice given during the consults on the SMF forum.

Any help you can provide would be most appreciated. I'm afraid that I've looked at the various components and the changes for so long now that I've developed a mindset that prevents me from seeing my errors.

TIA
BobH
The Ancient Noobie