Installing Drupal (6.x) Database setup fails to proceed. No error.

Last modified: June 5, 2009 - 10:12

Symptom:

You are on step 3 of install.php, and the system wants your database name and password. You enter it, you are sure it's right and that the database exists etc.
But on submission the page just refreshes. No Error, no progress. Please enter your database information.

Cause:

You mis-read the instructions for creating settings.php.
Do not rename default.settings.php into settings.php
Copy it.
The original default.settings.php must still be present alongside your new one.

INSTALL.txt

You must create a file named settings.php. You may do so
by making a copy of default.settings.php (or create an empty file with
this name in the same directory). For example, (from the installation
directory) make a copy of the default.settings.php file with the command:

cp sites/default/default.settings.php sites/default/settings.php

This is an acknowleged User Interface problem with this version of Drupal, and will be fixed (at least with a better warning) in a later release.

It doesn't work for me.

Alexbr - November 24, 2008 - 13:24

I have both files default.settings.php and settings.php at the folder but still the page refreshes.

Both files have write permissions.

Alex

really?

dman - November 24, 2008 - 13:45

sites/default/default.settings.php
not
sites/{something_else}/default.settings.php
? That's a problem then. Please post more information in the issue queue.

Same Issue

gregblex - January 3, 2009 - 13:41

The same thing happens to me as well. The installation stops before installing the site.

It doesn't work for me either

nonon - January 19, 2009 - 15:36

Exact same problem installing drupal 6.9
I have both settings files and settings.php is empty and writable as well

settings.php owner and writable by web server

betaspace - February 26, 2009 - 20:48

On windows, making settings.php writable via chmod 777 was not sufficient. The owner also needed to be set so that Apache could write to the file. chown Administrators:None sites/default/settings.php worked on my dev system.

A warning should be provided in the install UI.

this needs resolving QUICKLY

arkid77 - March 19, 2009 - 09:37

this needs resolving QUICKLY if you dont want to turn new users away!
i had the issue on xp sp2. I gave both files explicit full control and it did the job.

the handling of this and messages displayed during the installation need to be much better! there should be a write file check on the default user folder to ensure that write access is available. and if not, to warn users during install.

new possible users of the software will get instantly annoyed by this and possibly give up trying to use it if such fundamental quirks and technicalities are involved just to install the thing!

It doesn't work for me!!!

ameenahsplace - August 26, 2009 - 00:48

Hi

Both my files have write permissions and this is the error that I receive the following error message
***************************************************************************
Failed to connect to your MySQL database server. MySQL reports the following message: Access denied for user 'Dean'@'localhost' (using password: YES).

* Are you sure you have the correct username and password?
* Are you sure that you have typed the correct database hostname?
* Are you sure that the database server is running?

For more help, see the Installation and upgrading handbook. If you are unsure what these terms mean you should probably contact your hosting provider.
***************************************************************************
I have created databases under PHPmyadmin earlier, the parameters I supplied on the drupal page was for a "new" database with a supplied username and password.

Any suggestions?
Dean

settings.php

aviemet - December 14, 2008 - 08:53

why doesn't the install just come with the necessary files? it seems silly to add this step when it's something that could come standard.

It was there - but the user DELETED it!

dman - December 14, 2008 - 09:41

The situation documented here occurs when the user has actually deleted the required template file.
In the distro, there is the standard 'default-settings.php' file that is used as a template to create the per-site settings.
For whatever reason, some people are actually deleting or renaming that template away and that is why things start getting troublesome. :-{

It's normal behaviour to

bc173 - December 23, 2008 - 10:50

It's normal behaviour to rename a file instead of making a copy of it... especially configuration files. I don't understand why this error can't be caught in a clean way instead of refreshing the configuration page without error info. An error message could be:

The "default.settings.php" file was not found in the "sites/all/default" folder.

Check if settings.php is really writable (especially on Windows)

Berdir - December 18, 2008 - 17:48

There are two possible reasons for this problem.

a) As described, default.settings.php was deleted or renamed

b) settings.php is not writable.

The second was my problem, this might happen on Windows if advanced security stuff is activated. Drupal reports that the file is writable but this is not true. If this is the case, read http://www.ekhoury.com/2007/01/15/permission-denied-php-on-iis/ or if you cant change this yourself, contact your hosting provider.

Not helpful for Apache on Windows XP

rflemin - March 9, 2009 - 20:25

I'm trying to install Drupal on a Windows XP machine running Apache 2.2, MySQL6 and PHP5. I've confirmed that the database name, username and password are correct and that MySQL is running. I opened default.settings.php with Notepad and then saved it with a new name of settings.php. I even erased the contents of settings.php t leave an empty file. I changed the attributes of settings.php with attrib -r to be sure it was not read-only and I have file sharing set to On. I went into the Advanced settings and made sure the host was set for Localhost and the port for MySQL's port of 3306. It still doesn't work. I'm sure it is something that, from the inside, looks simple, but from the outside, believe me, it is not.

Rob Fleming

Thank you

wei.2k - February 8, 2009 - 03:32

My first drupal install run into this problem, but the solutions above worked for me.

Thanks :)

IIS6

big67 - March 11, 2009 - 13:51

I bypassed this issue on IIS6 by allowing the windows Internet Guest account write permission to the settings.php file during installation.
Beware this is harmful, and I do not suggest anybody to do this.
If you happen to do the same, then remember to revoke this permission immediately after installation.

Same Issue On OS X

xybermatthew - March 12, 2009 - 23:10

I too get a blank screen. I'm on OS X 10.5.6 Leopard using MAMP-PRO

My settings (after "chmod -fR 777 sites/default/*"), in sites/default/:

-rwxrwxrwx@ 1 xybermatthew  staff  8917 Aug 13  2008 default.settings.php
drwxrwxrwx  2 xybermatthew  staff    68 Mar 12 16:26 files
-r-xr-xr-x@ 1 xybermatthew  staff  8944 Mar 12 16:42 settings.php

I'm currently running Apache/MySQL servers as user: www/mysql.

So I tried "sudo chgrp -fR www sites/default/*" and it still didn't help.

The problem was I needed to change the memory_limit in the PHP ini file to 16M (default in MAMP is 8M). Read more about this at http://drupal.org/node/76156

Both files with full access works

stockliasteroid - March 20, 2009 - 22:21

I had the same problem on OSX. I had renamed the default.settings.php file to settings.php instead of copying and renaming it. With both default.settings.php and settings.php in the folder it worked fine. There should definitely be an error message or something to announce this problem when it occurs...

This was a lifesaver.

coldneonflash - April 15, 2009 - 20:27

Thank you so much for this. I was getting so frustrated...

Hope this is fixed soon.

~James Vestal
Editor-in-Chief
the devils' advocate
Henry Clay High School
www.henryclay.fcps.net/newspaper

Saved my hide...

thekylehome@gma... - April 27, 2009 - 23:02

Lifesaver. Thanks so much!

Ubuntu 9.04

Almost gave up on Drupal before I found this

manicolaus - May 18, 2009 - 18:23

This was very frustrating and I just about gave up on Drupal and moved on before I stumbled on this fix. Which worked.

Marty N.

Same here. Thankfully I

Flam - July 10, 2009 - 16:58

Same here. Thankfully I found this thread as a last minute check.
This should be bolded and in everyone's face imo.

Can Somebody help me!

c2ckid - July 28, 2009 - 11:04

Requirements problem
The following error must be resolved before you can continue the installation process:
The Drupal installer requires that you create a settings file as part of the installation process.

1. Copy the ./sites/default/default.settings.php file to ./sites/default/settings.php.
2. Change file permissions so that it is writable by the web server. If you are unsure how to grant file permissions, please consult the on-line handbook.

More details about installing Drupal are available in INSTALL.txt.

This is the error message I received. I'm using Windows XP. So I have not made it past step two. I created the name for my database-and that went ok. Then clicked install Drupal in English-then got this error message. Now where changing the file permission is concerned I did that part right, but this copying part, I must admit-all I have tried have not worked thus far. Thanks in advance for your timely response!

Thanks :)

tutness - August 15, 2009 - 12:32

Thanks a lot! helped me too :D

Thank you!

katovit777 - October 18, 2009 - 19:07

Thanks, im new to drupal and that was driving me nuts!

Hector Hernandez

www.HectorHernandez.net

 
 

Drupal is a registered trademark of Dries Buytaert.