Topic: Huge Hint for those who can't get MySQL to work with PHP

[Matt Grdinic]

Right, so I was going out of my mind trying to get Apache 2.2.3/PHP5.1.6 and MySQL 5.0.27 to play nice together. Bottom line, I couldn't get Apache to 'see' any of my PHP extensions, among them mysql.dll. This was a real killer because PHP worked just fine from the command line, including talking to mysql.

Anyway, it turnes out what was killing my rig was including the
PHPIniDir C:/php
line in the appache config file.

I know, crazy, but it was killing things. I think the reason is I added c:\php to my system path, and this double naming of a path variable and the PHPInDir directive was somehow wrecking havoc.

Any comments about this from anyone?

[pnllan]

Wow, that's weird but if you have it working that is what counts. I have the PHPIniDir directive and the PHP folder in my environment path without ANY issues - yes I use MySQL too.

Out of curiosity, which of the below two statements most closely represents what you had in your httpd.conf?:

1) PHPIniDir C:/php

or

2) PHPIniDir "C:/php"

The reason I ask is because you write in your post - PHPIniDir C:/php. Which would be incorrect on a Windows system, since Apache on Windows requires that paths be quoted (" ").

If you are quoting your path for PHPIniDir, then you definitely have something strange going on.

[Matt Grdinic]

I appreciate your input. That said, both ways break it. That is, quoted and unquoted. The only way it works is by uncommenting the whole line.

At work I'm stuck with IIS and SQL Server 2005, yet I've muscled in PHP as our primary scripting language. Problem is IIS does not play nice with PHP at all when it comes to performance, so this Apache avenue is very appealing to me as a potential solution.

I would like to come to some type of resolution with this issue, because installing in an enterprise environment with this type of stuff going on is not going to be pretty at all.

Anyway, I think it's also important to mention that NO extensions load with that line active. MySQL is just the one I've got a need for right now. So for example, GD doesn't load either.

[pnllan]

I don't know everything you have going on your system(s) or how you installed and configured your setup, but where I work we have NUMEROUS Apache/PHP/MySQL servers running on Windows platforms without ANY of the issues you describe. So, it's not anything with the PHPIniDir directive since we use on all our configurations. Here's a fairly detailed description of how we do it:

http://www.apachelounge.com/viewtopic.php?t=570

Also, note the source we use for Apache and the PHP handler. While I state in that tutorial to use Steffen's compilation, we build and compile our own which is nearly identical to what can be downloaded here. The reason for building our own or using what Steffen offers is that PHP.net did not develop an Apache handler for PHP 5.1.x that would work on Apache 2.2.x. However, now that PHP 5.2 has been released, you can use the ASF and PHP.net compilations without any issues.

[Mitron]

Hmm, you said PHP 5.1.6 and MySQL 5.0.27? How are you getting those two to talk to each other without the PHP Connector? I know mysql.com has the PHP Connector for 5.1.6 and MySQL 5.0.26, but not 5.0.27.

Also, I don't seem to notice a problem with performance issues on IIS with PHP either, although I don't run the CGI version.

I also run Apache 2.2.3/PHP 5.1.6, but I've stuck with MySQL 5.0.26 until they release the PHP Connector for 5.0.27. This is also keeping me from going to PHP 5.2.0.

I've also setup PHP 5.1.6 on numerous IIS machines without issue although I haven't played much with SQL Server 2005, most clients opt for MySQL instead.

[Matt Grdinic]

[Mitron]