By allanbj on

I have created the database and then run the install script. But I cannot get past the database configuration page where I enter database name, user and pass. When I submit the page I just get up the same page again - with no messages or any changes. If I submit incorrect values though, I do get error messages, so it is indeed fetching and processing the submitted data. But it just doesn't go to the next screen!

I'm running PHP 5.1.6 and MySQL 5.0.24 on an IIS 5.1 on WinXP.

Regards,
Allan Jensen
Website developer, WinterNet Studio

⋅ Categories: Drupal 5.x

Comments

allanbj’s picture

allanbj commented

Nobody is able to help with this? Hmmm.... when I can't even get the install script to work properly on a very simple installation on a common platform without having to debug it myself, the words that unfortunately come to my mind is "crappy software"!

develguy’s picture

develguy commented

Same problem here!!!!

Anyone!?!

blpatt’s picture

blpatt commented

sadly you appear to be correct.

guswah’s picture

guswah commented

I couldn't agree more. Extremely standard everything: platform, server. Basic installation, absolutely nothing fancy, and Drupal still fails. Two full days of my life wasted.

ivanb’s picture

ivanb commented

Are the values you set being saved in settings.php?

StillPerceptions’s picture

StillPerceptions commented

In a Solaris zone with Apache 2.2.3, Mysql 5.0.33, PHP 5.2.0 -- errors in database name/user are recognized, correct entries result in the form being blanked. Values are being saved in settings.php but the permissions for settings.php are not being changed from their pre-attempt setting of 777 and no tables are being added to the database. Any suggestions would be greatly appreciated.

allanbj’s picture

allanbj commented

Settings were not written to settings.php. Then just today I got the thought to check the write/modify permissions for settings.php and realized that IUSR_[machinename] did not have those permissions. So I granted the user the permissions and then the install script finally completed! Problem solved!

Kobus’s picture

Kobus commented

I have the same problem with Drupal 6.4. I have set the write permissions on the default folder and on settings.php to 777. More lenient than that I can't go.

Running PHP 5.0.x, MySQL 4.x and Apache 1.3 (I think) on my hosting space.

-- Kobus

Kobus’s picture

Kobus commented

I am experiencing the same with Simple Machines Forum on my account, so I am starting to wonder if this is not a problem on my hosting space. Two totally independent apps not working due to "file pemissions errors" even though the folders have been set to access 777. I am following up with my host.

-- Kobus

micnolmad’s picture

micnolmad commented

Am I the only one using this combo? All ref's are for iis/windows or apache/nix..

For which account do I set the right permissions on apache2.2/windows7? I don't have a IIS_ account obviously. I have tried to set full control for everyone on the default folder, but I still can't get past this point.

micnolmad’s picture

micnolmad commented

Meh, the advanced options showed the problem. By default it sends to localhost. I use vhost so yea ':-)

mattyc’s picture

mattyc commented

Was going to use joomla as friend recommended it, but just read Drupal article in PC Pro so opted for that instead. I am a php deveveloper and sys admin so I thought this sort of thing should be a breeze for me!

I have tried installing (Drupal 6.4) on our dev server (windows/apache/php5/mysql5) and can't get past the database page (no errors shown on submit, nothing written to settings.php) and also on our live server CentOS/apache2/php5/mysql5 (no errors shown on submit, nothing written to settings.php). Changed permissions on sites/default & sites/deafult/settings.php so I am guessing there is something wrong in the installer script. DB user has all the permissions configured (I even tried using root and same problem!). I even tried manually ebntering db string into settings.php - don;t try it, it totally breaks the installer! My only option is to try and debug the installer script!

Not a good start! Now where do I download Joomla......

update - to make matters worse the files folder the installer created has been created as an unknown user so I can't delete it without logging in with ssh and su. Not good if you are on a shared server with no ssh access!

update 2 - fixed, it, but not really the best way to make it work. edit settings.php and manually add in your db settings to the $db_url string. Then goback to your install url (you MUST run install.php rather than the default index.php) then all seems to work. Now lets see if the effort is worth it!

paulhult’s picture

paulhult commented

I messed around with this for some time until I figured it out. Here are the steps you need to do to get around this issue once you reach the database install screen.

1.) Find the default.settings.php file in the site/default file folder.
2.) Open it with a text editor.
3.) Scan the beginning of the document for four statements, they look like this

$db_url = 'mysql://username:password@localhost/databasename'; * $db_url = 'mysqli://username:password@localhost/databasename'; * $db_url = 'pgsql://username:password@localhost/databasename'; */ $db_url = 'mysql://username:password@localhost/databasename';

4.) Copy and paste in your information for username, password, localhost and database name. Make sure you to apply to all four (4) cases.
5.) Save the document as setting.php. Please note the dropping of the "default" at the beginning.
6.) FTP the setting.php file to the site/default file folder on your server.
7.) Add your username, password, localhost and database info to the drupal database input screen and hit the button.

If the information is the same you will be pushed to the next screen. If you get an error, please check for misspellings and try again.

Good Luck!

r4ktor’s picture

r4ktor commented

this solution is easy and works (you only need to change the statement that applies to the database type that you're using though)

osmorphyus’s picture

osmorphyus commented

GOOD - LOOKIN - OUT!

AWWESOME TIP!

THIS NOTE ALONE SHOULD BE A STICKY!

jpredator’s picture

jpredator commented

THank you guy

sshakya’s picture

sshakya commented

After hours and hours of (unsuccessful) hunting around for solution to problem in installing OP, I was ready to switch to some other framework. But this solution worked like a breeze for me. Thanks to paulhult, I am sticking to OP!!

21ngier’s picture

21ngier commented

Thanks! It worked!
and for those who haven't set their passwords (not recommended but just in case you're wondering how to set this up w/out pword) use this:
$db_url = 'mysql://username@localhost/databasename';

Katherine Lawrence’s picture

Katherine Lawrence commented

Worked for me too. Did all four cases, almost missed the fourth one. Needed to remember username and password in the initial case were "root," and "root" and the databasename, of course, was the one I had entered when setting up the site.

Presto! Worked immediately.

Grace note: the problem cropped up when I installed MAMPRO. Perhaps a coincidence; perhaps not.

josterberg’s picture

josterberg commented

This worked perfectly! Thanks a lot!

yesec9’s picture

yesec9 commented

It works!!! Thanks

value’s picture

value commented

Finally after hours of Googling useless posts and deadends I got it working.

FTP everything in place

chmod sites/default 777

leave default.settings.php iin sites/default

upload an empty file named settings.php

chmod settings.php 777

Install as usual.

If Drupal can not find default.settings.php it seems the installer will fail to write to settings.php and will loop you back to the Database Configuration page. This will appear to most to be a permissions problem with the settings.php file but is in fact due to the template file being missing.

Install.php should check for the existence of default.settings.php and output an error if the user simply renamed it instead of creating both files.

Kobus’s picture

Kobus commented

This solved the problem for me, thanks!

-- Kobus

Mikey1’s picture

Mikey1 commented

For me as well....after hours of fiddling around on various attempts...this seems to work.

WP1-1’s picture

WP1-1 commented

Hello!

This information should be on some kind of fix page and also addressed as a bug!


Thank you, Thank you, Thank you Thank you, Thank you!! Value

WP1

Webbing Along!! ;) :)

dirkca’s picture

dirkca commented

Thanks very much for posting!!

Calymari’s picture

Calymari commented

Yes, thanks for posting this. I had the same problem during a clean install of the 6.9 version, and I would never have guessed that this was the solution. I'm glad I checked these forums before giving up on the installation altogether!

Hopefully this gets fixed in future versions, or at least the instructions on the installation page are more clear about what needs to be done.

tonydroopall’s picture

tonydroopall commented

thanks very much. I was about to disappear down some very dark dead-ends.

ksuss’s picture

ksuss commented

Fixed! Thank you!!!!!!!!!!!!!! Thank you!!!!!!!!!!

askbitsoft’s picture

askbitsoft commented

Wow
amazing , it is really nice solution , thank a lot

Php_User’s picture

Php_User commented

Never mind. I needed to run the drupal/install.php not drupal/index.php - even though the index.php seems like it is doing the install . Suggestion: maybe run the install automatically from the index or tell users to run the install.php instead.
-------------------------
I read these fixes and non worked for me. Here is my versions:
PHP 5.2.8
MySQL 5.1.30
Apache 2.2.11
Windows XP Pro SP3

1) I checked and the settings.php file is not read only and I removed the default. from the name.

2) I changed all 4 version of the:
$db_url = 'mysql://Don:xxx@localhost/drupal';
$db_url = 'mysqli://Don:xxx@localhost/drupal';
$db_url = 'pgsql://Don:xxx@localhost/drupal';

$db_url = 'mysql://Don:xxx@localhost/drupal';

(Note: the original file had the first 3 in a /* */ commented out section and the last one was not commented out. But is the same variable definition?

And I have a new install of WAMP "WampServer2.0f" and created a table called 'drupal' and all users have full priviliges in MySQL.

I still get :
"Warning: Table 'drupal.access' doesn't exist query: SELECT 1 FROM access WHERE type = 'host' AND LOWER('127.0.0.1') LIKE LOWER(mask) AND status = 0 LIMIT 0, 1 in C:\wamp\www\drupal\includes\database.mysql.inc on line 128"

etc...

Anyone else do the suggested fixes and get past this issue?

Thanks,
Don

Sunshiney’s picture

Sunshiney commented

Just to clarify your message --- you have in sites/default both of these files: default.settings.php AND settings.php ?

Shelhezan’s picture

Shelhezan commented

Yes, you put both files there.

The install.txt has a wrong information. You should cp ./sites/default/default.settings.php ./sites/default/settings.php and not mv it.

That's the riddle's solution.

feaelin’s picture

feaelin commented

Or you can use 'touch' to create an empty file: touch ./sites/default/settings.php

I had the same problem and was flailing until I found this thread. Thanks to everyone that had this problem before me! ;)

Alex Andrascu’s picture

Alex Andrascu commented

i've installed several drupals 6.X on different servers and haven't run on this problem before. Just about now i have it with a 6.14 installation on a whacky servered. Would be nice for the drupal crew to give us some errors instead of none.

frob’s picture

frob
Primary language English
commented

Same here. I redid my site with a whole new design and ran into this. Never had the problem on any other drupal installs I have done. It worked, but then I ran into it again trying to setup the multiple sites feature for a sandbox. There needs to be an error here drupal team. Just send and error that points people to this thread.

rick bergmann’s picture

rick bergmann commented

Had the same problem, and figured out why it was happening, here goes:

The beggining install step requires 2 things befor installing, 1. to change the name of defaul.settings.php to settings.php, and 2. to change the permissions from read-only to read & write, so when you enter the database user name and password, it's not writing it to settings.php, and therefore can't go further even if your user name and password are correct. So you can either change it manually in a text editor in the settings.php file, or just set settings.php to be writeable.

Ricky

PhilDHD’s picture

PhilDHD commented

I have installed drupal quite a few times before and have just run into this problem for the first time with a fresh install of 6.16. I am installing on WAMP.

Of course your settings.php must be configured as always but this time pointing to the drupal root in my browser raised the above SELECT errors. The solution is mentioned by mattyc above - point your browser at the install.php.

This didn't work and raised the errors:
http://localhost/drupal

This did work and started the expected install process:
http://localhost/drupal/install.php

ryank76’s picture

ryank76 commented

I've followed INSTALL.txt and INSTALL.mysql.txt exactly. Using php 5.2.13 and mysql 14.14 distrib 5.0.83.

The Database configuration page just reloads. Info is not being saved in settings.php. The file has the right permissions.

So much for helping to test out Drupal 7!

cory@clickmode’s picture

cory@clickmode commented

In sites/default/

keep: default.settings.php

copy and paste same file and name it: settings.php

Seems the installer needs to see the default.settings.php file as well as a newly created settings.php file.

joe0867fv’s picture

joe0867fv commented

I finally decided to get Drupal an have been trying to pass the install script for half a day now, when I thought I got passed the DB setup step I got the error bellow. Any ideas about what could be happening?

My environment is Debian, running mySQL 5.1.41 and PHP 5.3.2-1 running msqli extension.

* 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 /var/www/drupal/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 /var/www/drupal/includes/menu.inc on line 315.

Any suggestion will be greatly appreciated.

Joseph.

joe0867fv’s picture

joe0867fv commented

I got it.

The installation process got certain order that needs to be followed otherwise different kinds of errors arise.

artur.alves’s picture

artur.alves commented

I had the worst headache trying to make Drupal 7 work in IIS 7, on a Windows 7 (ha!)

The install script fell into a loop, right after the database configuration.

But I just found out that the big issue was FILE PERMISSION.

The group IIS_IUSRS had FULL CONTROL over the /sites/default but Drupal just couldn't write on the settings.php.

What I did:

Gave WRITE permission to the local group USERS.

And, as magic, everything worked!!!

I love you Drupal!

leer’s picture

leer commented

This worked for me (though I ended up giving full control to IIS_IUSERS, not just Write). Thanks!

old eggplant’s picture

old eggplant commented

I got the same problem while installing Drupal 7 on Windows 7 / Apache 2.2. I tried to give full control permission to 'Everyone' as well as 'Users' group for setting.php, but doesn't work.
Anyone can help on that?

Thanks in advance

micro_vn’s picture

micro_vn commented

Please carefully read the manual page is out soon