By money2k on

I have attempted to install either drupal 6.x and 5.x without any success on a windows server running php. The mysql database is hosted on a remote machine and is running mysql 5. I enter the database login credentials and the proper remote database hostname and then click continue. This takes me back to the database credentials page without any error messages. If I enter in invalid login information it will then return me to the database credentials page with an error message. I am not sure why this would happen in both version 5 & 6. Here is my php configuration: http://www.spmlaw.com.au/phpinfo.php

Any thoughts or things I might could try to resolve or debug this problem? I have successfully installed drupal on many linux hosting environments.

Thanks,
-Mark

⋅ Categories: Drupal 6.x

Comments

bn2vs’s picture

bn2vs commented

Hey,

I'm having a similar problem. I'm using WAMP server (apache), and installed drupal successfully. I then removed that drupal installation, and a few weeks later tried to install a new one. For some reason I can't get past the 'Setup database'-page in the installer. I'm not getting any errors, and there are no changes made to the db or file structure as far as I can determine.

Anyone an idea what can be causing this error?

robby78’s picture

robby78 commented

I have a solution...
You can write the database connection directly in the sites/default/settings.php file.

$db_url = 'mysql://root@localhost/drupal';

That's work for me...

tommie’s picture

tommie commented

I have the same problem and the latest post that supplied a possible fix gave me the Drupal White screen of death.

No errors, but Drupal installation just hangs on DB install. When I change the password to a wrong one, it does report that error. So some communication is possible. However, it is not working when I enter all the right details.

thisiswilson’s picture

thisiswilson commented

Manually editing that line worked for me, refresh and wait for a while. It should load eventually.

Thanks,

Michael Wilson
PHP MySQL Developer

tommie’s picture

tommie commented

Editting that line gives me a white unrefreshable page. And I made sure I editted the line with all the right details.... :( Argh! Is there any SQL script I can run to manually fill out the dbase for 6.6 ?

gbataille’s picture

gbataille commented

How did you solved this problem?

eriklegault’s picture

eriklegault commented

I have the same problem, I have checked my chmod settings and all of my permissions are fine but when I try to add the database information it simply reloads the page and does not move on in the installation process, I have tried several versions of drupal on several different websites, and I get the same problem. when I manually insert the database name and password it just gives me a plank page. I have no idea why this is happening. please help!!

eriklegault’s picture

eriklegault commented

When I changed my settings.php file I just renamed the file default.setting.php to setting.php however, by copying and renaming, keeping the original default.settings.php file intact, i no longer get any errors or resets. hope this helps.

brimanning’s picture

brimanning commented

I just wanted to add that this fix worked for me. It appears that you should duplicate the default.settings.php file and rename it instead of simply renaming it.

elangoct’s picture

elangoct commented

Thanks brimanning, what you said is right. Don't delete the default.settings.php, keep the two files (default.settings.php and settings.php). It works then.

dman’s picture

dman commented

What were the search terms that led you here instead of directly to the FAQ documentation on this issue?
The answer is there, but we can't tell what people are thinking when they fail to find it. What are the keywords that would have helped?

.dan. is the New Zealand Drupal Developer working on Government Web Standards

Strace007’s picture

Strace007 commented

BRAVO!!! worked like a charm. And saved me 20% on my car insurance.

Simon Naude’s picture

Simon Naude commented

Keep your original /sites/default/default.settings.php (don't rename it). Make a copy of it, named '/sites/default/settings.php'. Then go back to the install page (/install.php) and refresh. If installation fails after this, edit /sites/default/settings.php, then go to '/'.

damonb’s picture

damonb commented

I'm installing on OSX 10.5 server: Apache/2.2.9 (iTools 9.0.2)/Mac OS X) mod_ssl/2.2.9 OpenSSL/0.9.7l DAV/2 mod_fastcgi/2.4.2 PHP/5.2.6/ MSQL 5.0.45/ phpMYadmin 2.11.4

The install gets to the same point as money2k's spmlaw.com site is showing now. When I enter the correct db name / login and pw it just reloads the screen. However if I enter any incorrect info it displays the error.

Any help greatly appreciated.

thank

d
out

damonb’s picture

damonb commented

I also edited the settings.php file manually which did the trick.

D
end

pyrello’s picture

pyrello commented

I had the same problem, but I fixed it by changing the permission of the file to allow it to be modified. I think what happens is that the connection with the db is established and verifed by drupal, but then when it tries to write the info to settings.php, it can't because of the permissions issue.

Important to remember to change the permissions back afterwards.

mtpaper’s picture

mtpaper commented

I'm trying to install all this on my mac, to use it as a local server while learning.

I've followed the wonderful videocasts for installing a Local Web Server on Mac OSX with MAMP.

Now I'm trying to install Drupal and have gotten to varying levels of progress.
I have downloaded it, and I'm sure the .htaccess file is with its siblings.

I have granted read/write permission for the actual settings.php file, as well as the folders that lead into it. [EDIT: fyi, I have not deleted the default.settings.php file - it's right there too]

I believe I have created the database for Drupal. The written instructions are a bit different from the ones in the video in terms of how much privileges are granted to the new user. I currently have the new user set with the priviliges as described in the video (ie, granted all for the newly created database)

I can open the Install page in my browser, but after selecting English, I get to a white screen.

AND, all my permissions have been reset to read only. Which means, I have to grant permission again, try again, and this goes round and round.

Any ideas on what to try?

I looked at my settings.php file with TextWrangler, and can see what appears to be the correct line for the $db_url..... but, truthfully, the white screen is coming even before that in the installation process - ie, drupal isn't even verifying my requirements - which it had been able to do earlier in this process (before trying to use the video to get setup).

Suggestions? I'm not a programmer (obviously) and am at my wit's end.

EDIT: I deleted the existing settings.php, and created a new one - and, at last, got beyond the Verify Requirements Stage! Now, to see if I can get beyond Set Up Database....

EDIT: No. Not only can I not get beyond a white screen for Set Up Database, but, when I back up, I can't get past language selection again, and have to start all over, with a new settings.php file, and re-setting the privileges for that file as well as the encompassing folder.....

EDIT: During the installation process, I opened the settings.php after everything has been verified and before the Database step. I can see that the line has not yet been edited to specify the database and password. Then, after I run the Database step and have the white screen hanging, if I open the settings.php file again (which has had privileges automatically reset to read only), I can see that the line has been edited to reference my database. I don't know why it's hanging and what to do....

EDIT: Wahooo. I searched back in the forum, saw a similar thread, and adjusted PHP's memory limit for scripts (altho this is titled OPTIONAL, it seemed CRITICAL!). Then I stopped the servers, started them again and FINALLY am beyond the Set Up Database screen of the install process.

gRezes’s picture

gRezes commented

This seems to be an issue with the 6.10 installer. I needed to edit the settings.php file manually too despite giving the apache server write access to the file.

maxilious’s picture

maxilious commented

If you dont have proper permissions you will get this error.

freescholar’s picture

freescholar commented

Same problem - I could not get past the DB page on my install -
I had deleted default.settings.php - once I replaced it, I had no problems.

Give a Drupal

glossybox’s picture

glossybox commented

I had also deleted default.settings.php — after I replaced it, the installation proceeded smoothly (thanks blipvert!).

pikachuroks’s picture

pikachuroks commented

Works fone after manually changing DB path .

jobeng’s picture

jobeng commented

You must have both default.settings.php AND settings.php in the directory for it to work. Create a blank settings.php file and set it's permissions to writable. Do not delete the default.settings.php file. Hope this helps. Its what solved it for me.

ksantella’s picture

ksantella commented

Ok. Have the same issue and have COPIED default.settings.php to settings.php and then ftp'd to \web. I know its not db access as I am getting tables etc created when I look at the db. My error states;

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY fit DESC LIMIT 0, 1' at line 1 query: SELECT * FROM menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in /volume1/web/includes/menu.inc on line 315.
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY fit DESC LIMIT 0, 1' at line 1 query: SELECT * FROM menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in /volume1/web/includes/menu.inc on line 315.

I looked this up on google and they stated that it may be memory so I added the line to settings.php to increase memory to 16MB (ini_set('memory_limit', '16M');) should I have put that in the default.settings.php?

This is running on a Synology NAS with the following versions:

Apache/2.2.8 (Unix) mod_ssl/2.2.8 OpenSSL/0.9.8g PHP/5.2.6
MySQL client version: 5.0.51b
PHP extension: mysql

Oh and i have PHP register_gobals off
Any ideas??

jchan’s picture

jchan commented

I just came across this problem myself, and tried everything suggested here to no avail. It seems that not only must default.settings.php be present, it must be present in the sites/default directory.

I run a multi-site setup, and have each one under sites/{domain.name}/settings.php. I had removed the sites/default directory, and nothing worked for me until I put it back.

This is despite the fact that there is no settings.php in my sites/default.

dogma00’s picture

dogma00 commented

Thanks for the tip, eriklegault! :)

dman’s picture

dman commented

The troubleshooting guide is a good place to look for this and other such problems.

The answer was under Home » Reference » Troubleshooting FAQ » Site Configuration, Module and Installation Issues » Installing Drupal (6.x) Database setup fails to proceed. No error.

If you have problems finding the answers there, please suggest the search terms you used when looking for that answer, and maybe the page can be made more findable. To make the documentation more accessible, we need to know where you expected to find the answers if looking for them failed for you.

.dan. is the New Zealand Drupal Developer working on Government Web Standards

stereodevil’s picture

stereodevil commented

This was my fix.

I have Wamp just so you know.

Originally I had just renamed the default.settings.php in C:\wamp\www\drupal\sites\default to settings.php

I just copied to the desktop that file renamed it back to default.setting.php and moved it back so now i have both settings.php and default.settings.php

Bingo went to the next install step.

I don't know why that caused an issue but it just about drove me nuts.

cbayly1’s picture

cbayly1 commented

This is my first post here. I had to post after not being able to pass the "set up database" step during the Drupal install. The above post worked for me. FYI I am being hosted on DreamHost which has a one click install option but doesn't have full customization. In order to be in "complete control" you have to do a manual install and that is when i ran into this issue. Thanks Stereodevil.

Anonymous’s picture

Anonymous (not verified) commented

I was stuck too (using windows 7) until I changed the db server from localhost to 127.0.0.1 (drupal 6 and 7!)

divacanto’s picture

divacanto commented

I'm in Vista, tried everything else related to settings.php, nothing worked. Changing the db server to 127.0.0.1 worked! Thanks.

jmattw42350’s picture

jmattw42350 commented

I'm on Windows 7 and the 127.0.0.1 solution worked for me. Thanks!

readyman’s picture

readyman commented

I was stuck on this page in the installation as well and the error was saying that it couldn't connect.

It was due to the databasetypes. I guess it was detecting mysqli instead of mysql and couldn't use the one it detected.

I opened the install.php file

Looked for "mysql" and found this code.
// If both 'mysql' and 'mysqli' are available, we disable 'mysql':
if (isset($db_types['mysqli'])) {
unset($db_types['mysql']);
}

I commented it out... so it doesn't try to detect my database type anymore.
// If both 'mysql' and 'mysqli' are available, we disable 'mysql':
//if (isset($db_types['mysqli'])) {
// unset($db_types['mysql']);
//}

I ran the install again and everything went smoothly.

vipinss’s picture

vipinss commented

This is happened due to the renaming or deleting default.settings.php. Instead you have to make a copy of the default.settings.php and rename it to settings.php.
Dont rewrite settings.php or this is not due to permission issue.

jdushyantjoshi’s picture

jdushyantjoshi commented

Hi all,
I have been a big fan of drupal. I had faced problems in installing drupal on windows 7 .But here is how I solved it.
I have put $db_url = 'mysql://root:@127.0.0.1/drupal'; in settings.php file. and at the installation page i gave 127.0.0.1 instead of localhost. By doing this I solved installation problems.

billingclerk’s picture

billingclerk commented

That worked for me.

teigertje’s picture

teigertje commented

Hi all,

I was stuck on this too! I'm running Mac OSX and using Safari and Chrome.

After spending a lot of hours editing my settings.php, install.php, php.ini, .htacces and so on and so on... I tried to install Drupal through Internet Explorer and it just worked! After installing Drupal i'm still able to edit, visit and navigate through the site with any browser (like Safari).

Does anybody know how this is possible? And what went wrong?

Thnx

shazar’s picture

shazar commented

I am doing a fresh install with mysql on a remote server. It writes the settings file just fine, but just goes back to the db page for me to fill it in again.

The username and password and host all have correct permissions as I have other software using it from this same server. Also if I do use a bad password on purpose, I get the mysql error telling me so.

Sorry forgot to add that the settings.php file is written correctly. Is shows the full db string and also shows the prefix that I chose.

shazar’s picture

shazar commented

It looks like the problem was the opcode caching. Commented out
apc.stat = 0
in my config and it installed correctly! That was a tough one haha.

aurorarogers’s picture

aurorarogers commented

This is what worked for me -

1) I leave both settings.php and default.settings.php.

2) I edit the default.settings.php file to update with my database settings:

*line 92* $db_url = 'mysql://username:password@localhost/databasename';

3) Go back to refresh the install page - enter name, user, pwd and add the host information (taken from database settings page) for the database host field (under advanced options). I tried other tips and tricks and nothing else has worked.

Enjoy!

DeShark’s picture

DeShark commented

I host at Host Depot and ran into the same issue. The fix was simple. All I had to do was give the anonymous user read/write access to the Drupal folder. After that, the Drupal installation was able to save the database settings in the /sites/default/settings.php file and it proceeded. Just remember to set the permissions back to read only when you are done installing to avoid security issues.

samseen’s picture

samseen commented

Hi guyz, I recently installed and used Drupal to develop a site. Everything seems to work fine but after a while, i tried installing the VIEW module which doesn't work. I felt i had an issue with my installation so, I decided to re-install it (i.e Drupal) afresh. I downloaded the new version drupal7-2.3, while I was installing it, the installation couldn't continue because it said I had installed it before and it brought back my former home page. However, as this is not what I wanted, I deleted my WAMPSERVER, downloaded a newer version, installed it, and installed a fresh version of the Drupal. Installing the Drupal now seems to be an issue as it complains that:

( ! ) Fatal error: Class 'SelectQueryExtender' not found in C:\wamp\www\drupal-7.23\drupal-7.23\includes\pager.inc on line 15
Call Stack
# Time Memory Function Location
1 0.0430 142800 {main}( ) ..\index.php:0
2 0.1830 447448 drupal_bootstrap( ) ..\index.php:20
3 1.6641 1810400 _drupal_bootstrap_full( ) ..\bootstrap.inc:2218
4 1.8941 2223464 require_once( 'C:\wamp\www\drupal-7.23\drupal-7.23\includes\pager.inc' ) ..\common.inc:5096

I can remember I dropped the table i was using before I reinstalled the wampserver, but i recreated it and it's there in the database.
Kindly help as I really need to fix the site i'm working on as soon as possible. Thanks in anticipation!

samseen’s picture

samseen commented

Hi guys, after carefully reading this page from the top, i just did this. Firstly, i created a new table in MySQL, then i emptied the sites/default/settings.php and saved it. Then i corrected every other setting i made in the sites/default/default.settings.php back to it's default setting such as the username and password, saved it and started the installation afresh. IT WORKED LIKE A CHARM, AND I HAVE A NEW SHINING HOMEPAGE! Thank you all![Bows]

vcvcchaturvedi’s picture

vcvcchaturvedi commented

Hi All

The solution to being stuck on the drupal installation is :

Fill in the correct database credentials (user name and password and correct database name) and leave the database server field as it is that is - "localhost" and even if you are using wamp or xampp and listening to another port on localhost, for instance, 1234 then you might have thought of entering localhost:1234 as database server, do not do it, just leave the server field as "localhost". Also, even if your localhost is listening on another port, say like, 1234 do not enter "1234" in the port also, just leave it blank. You can leave table prefix empty or any of your choice.

And then click Save and continue.

Your drupal installation will continue as it should.

Thanks
Vinay