By cjscully on

I've searched this site for answers but I'm still unable to successfully install Drupal on my Windows box.

I have downloaded Drupal 5.7 and extracted it
I copied the folder to c:\inetpub\wwwroot\
Installed PHP 5.2.5 to c:\php
Installed MySQL 5.0.5
Included c:\php and c:\php\ext in the path statement in my environment variables
Edited php.ini as follows:
extension_dir = "c:\php\ext"
uncommented extension=php_mysql.dll by removing the semi-colon in front of it
set mysql.default_port to the same port used when I connect to MySQL using the MySQL query browser
I created the database in MySQL
I created a user in MySQL and granted select, insert, update, delete, create, drop, index, alter, create temporary tables and lock tables privileges on that database.
I edited the settings.php file in c:\inetpub\wwwroot\drupal\sites\default so the database url is set as follows: $db_url = 'mysql://drupal:drupal@localhost/drupal';

I've double checked all of the steps in the handbook. When I get to the step that says, "point your browser to the base URL of your website (i.e. http://www.example.com). You will be presented with the 'Database Configuration' page." I don't end up with the Database Configuration page. I end up with the following message on my screen:

PHP MySQL support not enabled

We were unable to use the MySQL database because the MySQL extension for PHP is not installed. Check your PHP.ini to see how you can enable it.

php.ini is in the c:\php directory
php_mysql.dll is in the c:\php\ext directory

I am new to PHP and MySql. Clearly PHP is not connecting successfully to MySQL but I am at a loss as to how to fix the problem.

Any suggestions?

⋅ Categories: Drupal 5.x

Comments

mickh’s picture

mickh commented

I installed PHP and MySQL on a Windows box a while back (with Apache, not IIS).

From memory, the PHP windows installer didn't install MySQL support by default. I reinstalled, and had to drill down through some little grey box things to get to MySQL support.

Maybe try reinstalling and check that MySQL support is enabled.

cjscully’s picture

cjscully commented

I read through the install.txt file that came with the PHP archive. It recommended NOT to use the installer and gave instructions on now to install by hand. I followed the instructions for manual install and enabling MySQL support by editing the PHP.ini. I can certainly check it again though.

cjscully’s picture

cjscully commented

I found a couple of posts mentioning putting libmysql.dll in the windows directory. I just copied it there and am still getting the same error.

mickh’s picture

mickh commented

If everything is working apart from MySQL, maybe try putting a phpinfo file in your Web directory, this will tell you whether MySQL support is enabled. Just search this site for details, its been covered many times before.

cjscully’s picture

cjscully commented

As I said in my first post I have been searching this site.

tm’s picture

tm commented

putting the path to \php and \php\ext in the global systems path didn't work, huh? usually works for me. hmm...maybe mysqli instead?

cjscully’s picture

cjscully commented

OK. I found part of the problem using phpinfo (). The stuff that came up when I ran it made no sense. Did not match what I had set in my php.ini file. Somehow php.ini wasn't being read. A google search turned up the fact that this problem is not uncommon. I found the following resolution on www.phpbuilder.com:

Than i immiediately added the following registry key
[HKEY_LOCAL_MACHINE\SOFTWARE\PHP]
"IniFilePath"="C:\\PHP"

That at least got me to the database configuration screen. Unfortunately my attempt at installing drupal stopped right there.

i enter my db name, the user name and password and click the save configuration button and after what appears to be an attempt at running the script, it just reloads the configuration page. I checked the database in mySQL and no tables are created. I double checked the permissions granted to the user in the database and they are all correct.

Stumped again.

cjscully’s picture

cjscully commented

The last issue of not being able to get past the Database Configuration Page was resolved based on another post I had initially discounted. It said that the permissions for the settings.php needed to be changed to make it writeable. I had previously checked this and the file was not flagged as read only and since I am logged in as administrator to do the install I have full control over everything. I decided to give write permission to everyone since it was pretty much the last thing I had not tried. That worked. Drupal database installed correctly.

mickh’s picture

mickh commented

Its actually the web server that needs permission to write to it.
You should probably change back to more restrictive original permissions now.