PHP5, MySQL5, and IIS6

mpettitt

Hi,

I've just started work for a company with an IIS based web server and I need to get PHP and MySQL running on it.
I've got PHP running as an ISAPI module with no problems, and calling phpinfo() shows that it is detecting the right php.ini file (in c:\php). The extension=php_mysqli.dll line is uncommented, and other extensions that have been uncommented load perfectly on restarting IIS.
MySQL server is also running, and fully accessible via command line.
I have installed the PHP/Connector files from Mysql.com, and have tried them in several places as found in suggestions all over the internet: c:\php\, c:\php\ext\, c:\windows but wherever I put the .dll files, it seems to make no difference.
Strangely, the php-cgi.exe binary seems to be able to detect the mysqli extension, as it is listed in the output of

php-cgi -m

I have followed the steps listed in the sticky thread on this board, but without success. Changing from IIS isn't really an option, as other sites hosted on the same server need ASP.Net.

Any ideas? I'm going crazy trying to fix this!

Doug_G

The MySQL connectors come in a windows installer, that's what I used on my IIS5.1 machine. There was no dll placing involved, simply run the setup and the MySQL ODBC drivers are installed.

mpettitt

The ones from http://dev.mysql.com/downloads/connector/php/ don't come with an installer - it's just a .zip file with the two dlls in.
I'm not aiming for ODBC connectivity - I want to use apps that need mysqli_ functions.

Doug_G

Oh, the downloads you're referring to are for the php extension dll's, I thought you were referring to the mysql database drivers which mysql calls connectors too.

All I had to do in XP was unzip the pecl files, put them in c:\php\ext, uncomment (add actually) the php_mysqli.dll in php.ini, and edit the php.ini extensions directory. Also I gave the anonymous IIS user account modify permissions to the php directory and subdirectories (modify might be overkill but I have a secure machine) but IIS will normally not have any permission to the php files unless you grant ipermissions.

I don't have IIS 6 to compare any notes, but the whole setup of php5/mysql5/iis php isapi was very simple on XP.

Oh, it seems to me I added c:\php to the PATH, but that might have been just for using the php cli.

Sxooter

So, you guys didn't notice the sticky post at the top titled Getting PHP5 to work with MySQL5???

🙂

Doug_G

Sxooter wrote:
So, you guys didn't notice the sticky post at the top titled Getting PHP5 to work with MySQL5???

🙂

Actually no I didn't see that sticky, probably because mysqli/php5.1/mysql 5.0worked for me "out of the box" so to speak. 🙂

mpettitt

Sxooter wrote:
So, you guys didn't notice the sticky post at the top titled Getting PHP5 to work with MySQL5???

I did. I followed it. It didn't work...

It doesn't appear to be quite the same issue, either. It isn't giving any failure messages, and phpinfo refuses to even acknowledge that anything mysql related is on the system, despite the dll files being precisely where specified in "getting PHP 5 to work with MySQL", the right php.ini file being used, and the extensions directory set correctly. Oh, and the line uncommented.

I've never had this many problems getting MySQL and PHP working together under Apache, and I'm really not impressed with IIS so far. Hopefully I'll be able to persuade boss to switch to an Apache server when we upgrade - we're not using anything that needs IIS on the server, but it is just what the previous server person knew.

Sxooter

I've been forced to use IIS once or twice in the past, and I was none too impressed with it either.