By feeper on

I am running PHP 5 and MySQL 5 with Drupal 5 RC 1.

I am unable to get past the database configuration page for the scripted install. I enter all the correct information, press submit and with no errors the site comes back to the configuration page.

I have even tried to set permissions on the sites and profiles folders because I have noticed in the settings.php file that the database configuration did not generate.

Anybody else run into this issue? Help!

⋅ Categories: Drupal 5.x

Comments

mjohnq3’s picture

mjohnq3 commented

I had this very same problem with PHP version 5.2.x. After going back to version 5.1.2 every works fine.

feeper’s picture

feeper commented

I stopped my server and and removed my current version, 5.2, of PHP. Installed 5.1.2. Configured the PHP.ini file. Attempted to open a site I had phpinfo.php uploaded to. Identified the installation as 5.1.2. Tried to run the install.php again for drupal 5, after clearing my cache. Same problem. I might add that I have MySQL and MySQLi extensions installed as I must use MySQLi for drupal. Anything else?

Ole Kristian’s picture

Ole Kristian commented

I have the same problem. Trying to install Drupal 5.0RC1 on Windows 2003 using IIS 6.0, PHP 5.1.02 (also tried 5.2) running in ISAPI mode, MySQL 5.0.21. If I enter the correct database details on the Database Configuration page afther uploading Drupal, the database configuration page just refreshes and blanks out the info I put in. If I enter the wrong details on this screen I get an error that Drupal can not connect to the database, so I suppose that on that level it is working. I have tried using filemon, but I can not see any failed write or read attemts related to the drupal installation. I have also examined the IIS log without any luck. Does IIS require any special filepermissions to run Drupal 5? Anyone have any other suggestions on how to fix this?

BTW, don't use IE7 when installing Drupal 5RC1 - It will not work.. (no profile error)

- Ole Kristian

Ole Kristian’s picture

Ole Kristian commented

I finally added iusr_xxxx with modify (write) security settings on the folder 'sites'. That fixed the problem. Does anybody have the correct file security settings for running drupal under IIS? I don't want to give it more than it needs to, and I'm wondering if there are any other folders/files that drupal needs to write to.

- Ole Kristian

feeper’s picture

feeper commented

I must be the unfortunate one :(

That was the first thing I tried before coming here. I do have a thought and not sure if I would be able to find it. My thought was if the installation cached somewhere, not the temp internet files. I had already cleared the phpsessions folder with no luck. If that is the case I could just clear that cache folder and may not have this issue anymore.

Anybody have an idea if that is what it does?

I also want to add that I have followed the steps in regards to the requirements of Drupal 5, in regards to the configuration of the PHP.ini.

Ole Kristian’s picture

Ole Kristian commented

If you get an error when entering incorrect details on the database configuration page, you at least know that the scripts can talk to the database. If you get no error when entering the correct details, and the database is not beeing updated it sounds like you got the same error I did. Are you sure you entered the correct permissions? I'm not an IIS specialist, but I know that if you have set up a dedicated application pool for the site (I did) you may also enter permissions there. Also try adding both iusr_xxx and iwam_xxx with modify permissions to the folder. As said before, I don't know if there are any other folders that need special permissions. Good luck!

- Ole Kristian

feeper’s picture

feeper commented

Those two user / permissions did not solve it. I finally went as far as changing the root folder to modify access so that all folders underneath it would get the permissions needed. That worked, and I got through the installation. Just remember to change your permissions back to read when you are done.

nut’s picture

nut commented

I just add permission full to isuer_xxx for settings.php

ps. please set it back after finished

Thanks

techsupportrich’s picture

techsupportrich commented

I'm suffering a similar problem and can't get past the database setup screen. I'm always told that it can't find the database. Changing the Sites folder has no effect.

The actual error message reads...

Failure to connect to your MySQL database server. MySQL reports the following message: Unknown MySQL Server Host 'mysql1267.secureserver.net' (0).

I've checked and double checked my settings, username and passwords etc but it will not go past that screen.

feeper’s picture

feeper commented

If you have access to this application, are you able to connect to your mySQL server with the server address and login and password?

techsupportrich’s picture

techsupportrich commented

I have PHPMyAdmin which I have used to access the database successfully.

I'm hosted with GoDaddy buy haven't had any issues until today, when I removed my previous installation.

yetanother’s picture

yetanother commented

I also have the same issue trying to install drupal-5.0-rc2, also on Godaddy.
Database is created but the install script can't access it.
Failure to connect to your MySQL database server. MySQL reports the following message: Unknown MySQL Server Host '
I am positive all parameters are ok.

lias’s picture

lias commented

I've had the same issue trying to use the auto install for the 5.0 release. I've also got the read/write enabled for the user on apache 2.x but no go.

If this continues to be a problem is there a way to manually install the database? I was looking at the files but wasn't sure how to build the database.
Thanks.
Lsabug

feeper’s picture

feeper commented

You need to set the permissions on IIS for Everyone on the root of your website folder as Read/Write. After the installation remove the read/write on the root, but make sure that files and temp are both left as read/write.

lias’s picture

lias commented

modify control and uncheck the read-only box of the settings.php file when you're going to install. Then recheck box. That worked for me with 5.1 and apache 2.058.
lsabug

mickth’s picture

mickth commented

Well, after changing a few things, this is the current error message:

We were unable to lock a test table on your MySQL database server. We tried locking a table with the command LOCK TABLES drupal_install_test WRITE and MySQL reported the following error: Access denied for user 'myusername'@'%' to database 'mydatabasename'.

RevTim-1’s picture

RevTim-1 commented

Is this available anywhere. I just can't figure it out and I am too new at it. :/

Thanks! Tim

machra’s picture

machra commented

Ok, well i had this same problem and am currently using Wamp server for windows to host my site. (its a personal workbench).

But i do have a work around as i had the same problem.
go to your settings file sites\default\settings.ohp
Edit it and enter your database information at line 92.
save and refresh your drupal installation page.

blueflowers’s picture

blueflowers commented

Same problem here

Windows XP
Mysql 5
PHP 5x

The above workaround was successful for me!

Fourth Wall Media
Toronto, Canada

ragavendra_bn’s picture

ragavendra_bn commented

Your solution worked perfect...................
This issue happened to me in 6.8 version

yakoff’s picture

yakoff commented

Latest drupal on wampserver 2.0

Flash dash’s picture

Flash dash commented

Fantastic! This works, I have been pondering over this issue for hours - going into days. This has resolved the problem within 10 minutes. Simple really, add your database details to line 92 of settings.php! That is really the only correct option in the instance, it strings from the PHP not being the correct version, of which there are a number of resolutions - this being the best.

suersan’s picture

suersan commented

if you, for some reason, deleted the default.settings.php file, replaced back to /sites/default directory.
then try again.
It worked for me

pendashteh’s picture

pendashteh commented

this is the final solution for that problem:
easily, make sure that:

  1. there is a file named "default.settings.php" in your "sites/default" directory (or your "sites/domain.com" directory)
  2. there is a directory named "default" in your "sites" directory
yan’s picture

yan commented

That works. As mentioned in the Troubleshooting FAQ it is just a missing /sites/default/default.settings.php. An issue has been filed already:
#208662: Missing default.settings.php produces no warning

matw8’s picture

matw8 commented

Yahoo! This has been driving me mad!

I added the IUSR user with write permissions to the website root folder and away we went.
I guess the web server could not modify the settings files.

robithnurielhaq’s picture

robithnurielhaq commented

Changing permission will bring you nowhere. The problem occurs because when the installation tells you to 'copy' the default.settings.php, you 'rename' it. You should not do that. Copy the default.settings.php to the same folder first so there will be 2 .php files in the 'default' folder, then you rename the second file into settings.php. that's all, you can continue the installation. check my successful installation at andikatp.web.ugm.ac.id