Forums

PHP 5.2 with MySQL 5.0 on IIS 6.0 (14 posts)

  1. jagsadmin
    Member
    Posted 4 years ago #

    I am having below mentioned versions installed on my server but am not able to get through with the install.php page as it throws an error like "Your PHP installation appears to be missing the MySQL which is required for WordPress."

    # Windows 2003Std. Edition with SP2
    # IIS 6.0 (able to open the phpinfo page)
    # PHP 5.2.3 (tested the php functionality)
    # MySQL 5.0
    (created the required database and configured the wp-config.php file)

    Have tried most of the options from the forums having the same kind of issue but no luck so far.

    Please help!!!

  2. Jeremy Clark
    Moderator
    Posted 4 years ago #

    What it means is you don't have the mysql extension for php loaded go over to php.net and search for mysql and iis. There should be a good tutorial on setting it up. Someone else might be able to tell you exactly what to do but I've only ever set up php on windows one time a very long time ago.

  3. jagsadmin
    Member
    Posted 4 years ago #

    Thanks for your speedy response!

    I would like to know whether any changes needs to be made in php.ini file (eg. uncommenting any tages)for enabling mysql & IIS Or any additional drivers/apps reqruied to be installed on the server.

  4. jagsadmin
    Member
    Posted 4 years ago #

    Or is it that below config has only IIS is ODD MAN OUT

    # Windows 2003Std. Edition with SP2
    # IIS 6.0
    # PHP 5.2.3
    # MySQL 5.0

  5. Jeremy Clark
    Moderator
    Posted 4 years ago #

    I'm trying to remember. Have a look in your php.ini file there should be an option to enable mysql.dll file in there. But a quick google search on the topic would produce better results than going by my opinion. To tell the truth if you want to use all the features of wordpress ie. pretty permalinks then you'd be better off using something like xamp.

  6. jagsadmin
    Member
    Posted 4 years ago #

    Hi Clark,

    have modified the below mentioned options in php.ini file

    Uncommented the below mentioned params.
    extension=php_mysql.dll
    extension=php_pdo_mysql.dll

    configured the below params

    mysql.default_port = 3306
    mysql.default_socket =
    mysql.default_host = localhost
    mysql.default_user = root
    mysql.default_password = xxxxxxxx

    Any more suggestions are welcome!!!

  7. Jeremy Clark
    Moderator
    Posted 4 years ago #

    Give the install a try now and see how it goes.

  8. jagsadmin
    Member
    Posted 4 years ago #

    Dear clark,

    Do you have any test script through wich i can try the connectivity between PHP & mySQL?

    as i have one as pasted below, but it is not working, also after making the above changes in php.ini file it gives the same result.

    can you plz confirm whether the versions that i am using, has any deviations...

    OR

    Shoudl i eliminate the IIS completely from the process and try with apache web serevr on windows?, would this be feasible and advisable ????, Since my requirement is to work the wordpress on win2K3 box. I have tested the PHP working fine, have tsted mySQL working fine and IIS too as an stand alone applications. but they are not working togather.

    PLEASE SUGGEST THE BEST ALTERNATIVE FOR THE SAME TO HAVE WORDPRESS WORKING ON WIN2K3 BOX WITH ALL ITS PRE-REQUISITES.

    <?
    //remember to change the password to whatever you set
    //it to in mysql instance configuration

    //first parameter is server name, 2nd username 'root', 3rd is password
    $rst = @mysql_connect("127.0.0.1","root","xxxxxxxx");

    if (!$rst){
    echo( "<p>Unable to connect to database manager.</p>");
    die('Could not connect: ' . mysql_error());
    exit();
    } else {
    echo("<p>Successfully Connected to MySQL Database Manager!</p>");
    }

    if (! @mysql_select_db("mysql") ){
    echo( "<p>Unable to connect database...</p>");
    exit();
    } else {
    echo("<p>Successfully Connected to Database 'MYSQL'!</p>");
    }
    ?>

  9. Jeremy Clark
    Moderator
    Posted 4 years ago #

    First off try restarting iis to apply the changes in your php.ini file.

    The best way to test is to create a file in one of your webdirectories call it test.php in this file but this

    <?php
    phpinfo()
    ?>

    Then just go to that page and look about midways down for a mysql section if you found it then it should work.

    Also check your php directory for a ext folder and look in there for the file mysql.dll if its in there the you should be fine.

  10. jagsadmin
    Member
    Posted 4 years ago #

    have tried restarting of server as well after doing all the changes, but still no luck,

    I am able to open the phpinfo page fine.

    I DO NOT have file named as mysql.dll but i have files like php_mysql.dll, php_mysqli.dll, php_iisfunc.dll, libmysql.dll.

    can you please tell me whether the php_mysql.dll needs to be registered manually >??

    also, there is no special section for mysql in phpinfo file. It only has the path that we used/configure in Enviornment Variables.

    Please help me, as i have spent lot of time on this and now i feel i am almost near to my goal.

  11. Jeremy Clark
    Moderator
    Posted 4 years ago #

    Okay in your php.ini file there should be a section called extension folder or something to that effect. Check and make sure that points to the folder that contains the php_mysql.dll file. And yes those are the correct names for the files. Then restart again then view the test file again.

    One more thing to check is that the php folder is in your system path. You can check this by going to your system properties under the Advanced tab under Environmental Variables then look for the path variable and edit that. Just add the path to your php folder if it isn't already in there.

  12. jagsadmin
    Member
    Posted 4 years ago #

    I have done this already, and after that have restarted the server as well. But till now it does not shows any special section for mysql in phpinfo page.

    also the system path variables are also configured on its own while the setup was happening, i have checked that as well which is appearing like "C:\Program Files\PHP\;", and found all OK.

    You are requested to share any more clues if you have, it is really Appriciative quick response from your end.

    Thanks!

  13. Jeremy Clark
    Moderator
    Posted 4 years ago #

    I'm fresh out of ideas. Sorry. Maybe Google could help you.

  14. gladman9
    Member
    Posted 4 years ago #

    I went through the same exercise. What I found out on mysql 5.0 is that the php extensions for mysql are not included in the mysql 5.0 installation. I went to the following link:

    http://dev.mysql.com/downloads/connector/php/

    and downloaded the windows 5.027 connectors for both mysql an mysqli and installed as directed. There are directions on the bottom of the page on where to intsall the files.

    I did get a no database found error after this, but I reset the cgi.fix_pathinfo in php.ini = 0 for the initial setup. Probably will set it to 1 to get permalinks to start working, but haven't made it that far.

    I probably have a good 3-4 hours into this. After reading this post I realized that the extensions are not included in mysql 5.0 install. Good Luck!

Topic Closed

This topic has been closed to new replies.

About this Topic