I have just installed php and mysql and can not get it to connect. I figured it was a extension problem which I changed the php.ini file to load the mssql & mysql dll file. Now when you try to load a php it just sit's there and hangs until you get a CGI error that says "The specified CGI application exceeded the allowed time for processing. The server has deleted the process.". Anyone have any thoughts on this?
Its a while since I installed php but if you create a php file with the following code in it, it should let you know if those extensions have been loaded
<?php
// Show all information, defaults to INFO_ALL
phpinfo();
?>
Well even if that is the only thing on the page the page will not load and gives the same error. Let me remove the MSSql & mySQL extensions one by one and see then if it will load.
Ok I just took out of the php.ini the reference to all extensions and then now the page loads up fine. So for some reason there is a problem when trying to load up the extensions like it does not have access to it or can not find it..
I have the following...
; Directory in which the loadable extensions (modules) reside.
extension_dir = "c:\PHP\extensions"
Which the .dll file is located in that directory with everyone and IUSR having full permissions over the directory. Any ideas?
You don't need to uncomment the mySQL extension at all it's compiled into the exe, just install myODBC and you should be GTG. I wouldn't personally touch any 5.x version on windows myself yet either.
I have v5 PHP and MySQL on a Media Center box for testing, and so far so good. I installed the isapi version following the instructions from the php and mysql websites. I'm using the MySQL Administrator and MySql Query Browser apps from MySQL.
There are a lot of commercial and freeware applications out there that have compatibility issues with PHP5.x many are still officialy saying it's unsupported, most basic stuff in PHP will be fine though.
Well I finally figured it out late last night by doing alot of googling. In the new version of PHP mySQL is not by default supported, you have to load the extension. I found out that I had to put libmysql.dll into the system32 directory and then it worked perfect.
Well I did at first install v4 but had installed the brand new version of mySQL and after having many problems I found out that I had to upgrade PHP to support the new version of mySQL.
I'm running latest mySQL and PHP 4.3.x with no real serious problems on development, mySQL does need a little tweaking though to get running. I'm not too sure 4.1 of mySQL is fully production ready yet though I've had a few issues with it on the test machine that plus some other quirks due to myODBC not fully supporting 4.1.