[RESOLVED] PHP5, Apache2, MySQL 5 install

j_70

Could someone point me to a good doc on a Windows PHP5, Apache2, MySQL 5 configuration. I have done this under linux but this is my first install on windows. I am used to compiling from source so I am unsure what to do in windows when you are just using the windows installer. How do I get MySQL to recognize PHP? I have already done the following (I have MySQL installed successfully, Apache installed successfully, and PHP5 installed and working with Apache):

uncommented the extension=php_mysql.dll line in php.ini
set extension_dir = "C:\Program Files\PHP\extensions"
copied the /extensions/php_mysql.dll to the directory where php.exe is.

When I restart Apache and look at phpinfo, I should see a reference to mysql support, however, I do not. Any advice would be appreciated. Thanks.

Piranha

Is the path to php.ini correct? You have to set it in apache, otherwise it will look for it in strange places.

j_70

PHP and Apache are playing nice together, it is MySQL that is the problem. If I try to connect from PHP I get an error that mysql_connect is an unknown function which, from what I have read, means that I have a configuration problem.

Piranha

If you don't want help just say so. If you want help maybe you should listen to and check what people that try to help are saying.

j_70

Uhhh, I guess I thought I was helping. The location of the php.ini file is fine. I've checked the httpd.conf file and things looks OK. I may be misunderstanding what you are talking about. 😕

Piranha

Ok, now we get somewhere. By not giving a clear answer to the posted question I assumed that you thought that everything was ok and that something else was the problem.

If you run the following script, is the path to php.ini correct? Sorry for repeating the question, I just want to be 100% sure since this is (as far as I'm aware) the most common problem.

<?php phpinfo(); ?>

j_70

From php.ini:

Configuration File (php.ini) Path C:\WINDOWS

I imagine this should be pointing elsewhere, namely c:\program files\php. How do I change this, or should I just copy the .ini file to this directory?

This is what the PHP install put in my httpd.conf file:

#BEGIN PHP INSTALLER EDITS - REMOVE ONLY ON UNINSTALL
PHPIniDir "C:\Program Files\PHP\"
LoadModule php5_module "C:\Program Files\PHP\php5apache2.dll"
#END PHP INSTALLER EDITS - REMOVE ONLY ON UNINSTALL

It does not seem to be recognizing the phpinidir portion. I have restarted Apache since installing both PHP and MySQL.

Piranha

Actually it is up to you where you want the file. I always use the folder of PHP and get everything gathered there, much easier to maintain. But of course it should point to the actual path of the file itself.

Change the first rows to use forward slashes instead and then check that the path in phpinfo is correct. Don't forget to restart apache after you changed.
PHPIniDir "C:/Program Files/PHP/"
LoadModule php5_module "C:/Program Files/PHP/php5apache2.dll"

By the way, what versions of PHP, Apache and MySQL do you have?

j_70

OK. I changed the lines to:

PHPIniDir "C:/Program Files/PHP/"
LoadModule php5_module "C:/Program Files/PHP/php5apache2.dll"

phpinfo() now reads:

Configuration File (php.ini) Path C:\Program Files\PHP\php.ini.

Attempting to connect to mysql gives the following error in the apache error log:

[Wed Apr 18 17:06:01 2007] [error] [client 127.0.0.1] PHP Fatal error: Call to undefined function mysql_connect() in C:\Program Files\Apache Group\Apache2\htdocs\php\dbtest.php on line 2

The connect code is:

<?php
$link = mysql_connect('localhost', 'root', 'xxxxxx');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>

j_70

I changed the lines so they now read:

PHPIniDir "C:/Program Files/PHP/"
LoadModule php5_module "C:/Program Files/PHP/php5apache2.dll"

I restarted Apache.

phpinfo() reads:

Configuration File (php.ini) Path C:\Program Files\PHP\php.ini

When I try to connect with this code:

<?php
$link = mysql_connect('localhost', 'root', 'xxxxxxxx');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>

I get this error in the Apache error log:

[Wed Apr 18 17:06:01 2007] [error] [client 127.0.0.1] PHP Fatal error: Call to undefined function mysql_connect() in C:\Program Files\Apache Group\Apache2\htdocs\php\dbtest.php on line 2

Piranha

It would be good to know what versions of the different programs you have. I don't think that mysql_.... functions is the best for you.

Anyway, in php.ini you have to set extension_dir = "C:\Program Files...". According to your first post you did set this, but then you moved the actual extension to teh folder that holds php.ini.

You also have to make sure that you have one more file in the php directory, it is not placed there automatically. I can't remember which it is, php5embet.lib, php5ts.dll or libmysql.dll, but I think it is the last one.

And please don't forget: What versions do you use?

j_70

I have php5embet.lib, php5ts.dll, and libmysql.dll in C:\Program Files\PHP. My PHP.INI file is in C:\Program Files\PHP.

My version:

MySQL 5.0.37
PHP 5.2.1
Apache 2.0.59
WinXP Home Edition 2002 SP 2

I think I may have shot myself in the foot by going with the latest version of everything. I usually deprecate one version to be safe. Also, this is my first windows install. Thanks for your assistance. So far it has been a fruitful learning experience.

Piranha

I got it working after lots of time reading manuals, guides and forum posts. So it will be able to get it to work, the questions are when and why it doesn't work now.

Since you are using MySQL 5.x and PHP 5.x you should use mysqli instead of mysql. It have prepared queries and other stuff to let you write queries safer and easier. But it should work with both, that is not the problem.

Now to the actual problem. How does your extension_dir look like in PHP? In phpinfo it should look something like this:

extension_dir	C:\Program\PHP5\ext\

And of course the actual extension should be in that folder. Another thing to look for in phpinfo is path (one below Apache Environment and another below Environment). The path to mysql should be in there.

PATH 	//Other paths//C:\Program\MySQL\MySQL Server 5.0\bin

PHP Variables also contains a path to MySQL:

_SERVER["PATH"]	//Other paths//C:\Program\MySQL\MySQL Server 5.0\bin

And last there should be a whole section with information on MySQL

Sorry for this post giving pretty much information but not many answers. To be honest I don't know for sure what to do next, just thought that it might give some clue if one or more of the paths are missing.

j_70

Houston, we have liftoff! Thanks for your help, I have finally connected. The problem was a bit obscure. The docs state the following:

"# Copy the php_*.dll files to your PHP extension directory

Copy the php_*.dll files contained in the download to your PHP extension directory, for example to: C:\php\extensions

Enable the PHP extensions that you want to use in the php.ini file

Uncomment or add the following lines to your php.ini file:
// MySQL extension
extension=php_mysql.dll
// MySQLi extension
extension=php_mysqli.dll

Copy the libmysql.dll to the PHP installation directory

A typical location for your PHP installation directory is C:\php . Exchange the libmysql.dll file that is in the directory and overwrite it with the file from the download archive. "

This last part was the problem: it does not say which libmysql.dll file to install. The libmysql.dll that you download in the MySQL and MySQLi archives are different. I originally had the MySQL archive's dll. When I swapped it out with the MySQLi archive's dll, I can now connect. Hopefully this admittedly extended thread will help others.

See the next post for some final instructions. You do have to make sure that PHP is in your PATH statement. You can check this by opening a dos box and typing PATH. This will show you what is in your path.

bradgrafelman

j_70 wrote:
Edit: I failed to mention above that I had to put this library in the C:\WINDOWS\system32 for this to work.

You should NEVER copy any files outside of the main PHP directory to get anything PHP-related to work.

I'm betting the problem is you didn't add PHP to your system's PATH environment variable. If you would have been following the manual ([man]install.windows.manual[/man]), you would see that there are instructions for doing this. Had you added the PHP directory to your system's path variable (and then restarted your computer), I'm willing to bet a large sum of money (due to personal experience of installing PHP5) that no extra downloading would have been required.

j_70

Perhaps it is bad advice but I was following the details in this thread:

http://www.phpbuilder.com/board/showthread.php?t=10278679

The first entry in my PATH is C:\Program Files\PHP5. If I move the .dll to C:\Program Files\PHP5, I cannot connect to MySQL using mysqli_connect. If I move it back to %System32, I can.

Have I missed something? Thanks.

bradgrafelman

Hmm... might be an issue with the space in the directory? The manual warns about this, but I haven't actually seen problems with it firsthand (mainly because I keep PHP in c:\php\ or c:\php5). You might need to change the path to c:\progra~1\PHP5 and reboot your computer (you did reboot your computer after making this change, right?).

In regards to that thread... I see that it's nearly three years old, meaning the information/practices described in it are at least that old as well.

j_70

You were correct on the path issues. I believe the space was causing problem. I just moved my installation to c:/php. To do this I:

I reset the needed lines in httpd.conf
PHPIniDir "C:/PHP/"
LoadModule php5_module "C:/PHP/php5apache2.dll"
Changed the extension dir in php.ini
Changed the PATH statement for php to be c:\php
Removed the libmysql.dll from the %System32.
Rebooted.

Worked like a charm. Thanks for the help.