Here is my system

Windows Vista 64
iis7
php 5.2.3 w/fastcgi
mysql 5.0.12

Problem im having is drupal wont create users for me. Its like its having a problem writing to the database.

The install seems to go fine, drupal properly writes all the tables to my drupal database. I go to set up the first user, press submit and it brings me back to the front page.

I login phpmyadmin and drupal did not create the user. The only user is UID 0 (im guessing thats anonymous).

Im using the root mysql account and as far as i can tell it has full permissions to the drupal database...

Any ideas?

Comments

cog.rusty’s picture

Since it already wrote to the database, it is probably not a database problem. Possibly a cookie domain problem.

Is that a local install? On standard port 80?
If so, what is the URL like? http://localhost/subdirectory?
Do the paths look ok when you hover over the links in the home page?

dermotti’s picture

Is that a local install? On standard port 80? Yes and Yes

If so, what is the URL like? http://localhost/subdirectory? http://localhost

Example, the link to create the new user is http://localhost/index.php?q=user/register
And that link works fine, brings up the add user form.

Do the paths look ok when you hover over the links in the home page? Yes, all the links appear to work.

dermotti’s picture

Garrr... i can get joomla installed without issue....but damn i hate joomla....

Anyone have any ideas? Is it possibly a cookie issue somewhere?

If i linked you my phpinfo() would that help?

cog.rusty’s picture

Who knows, maybe.

Did you try setting $cookie_domain = 'localhost'; in settings.php?

It's a new variable in 5.2. The cookie code was moved into /includes/bootstrap.inc

http://api.drupal.org/api/function/conf_init/5

where it says:

// Per RFC 2109, cookie domains must contain at least one dot other than the
// first. For hosts such as 'localhost' or IP Addresses we don't set a cookie domain. 
dermotti’s picture

I tried setting it, no luck.

Another thing, when i goto "create first account", if i enter just a username, and nothing else, and hit submit, i just seems to refesh out to index.php

And even if i put in information in all the fields, it still jsut refreshes out to index.php and puts nothing in the database.

I tried installing drupal 6 and at the end of the installation where it asks me to create a admin user, once i hit submit, it refreshes to the beginning of the install, step 1.

Not sure what the deal is, its like its submitting to the wrong page or something...

dermotti’s picture

http://drupal.org/node/56654#comment-194801

My issue sounds similar to that. Running isapi mode sucks, too many server crashes...

Must have CGI :-/

sepeck’s picture

I have not had time to test this, but I have one report that Drupal on IIS7 on Vista has issues but works on the Server 2008 Beta with IIS7 with fastCGI. I will not have time to test in the near future though.

-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide -|- Black Mountain

-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide

bills-1’s picture

The IIS team just released a patch for IIS7 to address this issue when Drupal is hosted using CGI. Read more about it here: http://blogs.iis.net/bills/archive/2007/09/25/iis7-patch-for-windows-vis...

jjohnsonBLC’s picture

I know it's probably a bit late, and I know you have something against ISAPI, but I have tried off and on to get Drupal to work with iis7 (Vista) for the last 3 months. I didn't even think CGI or FastCGI could have been the problem until I tried installing PHPMyAdmin and it was having a similar error (except it flat out said cookies needed to be enabled, and they were). Lo and behold, I found something online that said they got PHPMyAdmin working with Vista using ISAPI instead of CGI/FastCGI, so I thought I'd give it a try, and it worked. Then I thought I'd give Drupal another try, and it worked.

I don't normally post things where I'm not really part of the community, but this was a damn lot of frustration that I'd like to help other people avoid (and this is the ideal spot, all of my searches online came up with this thread).

Note: the patch the previous poster posted didn't solve my problem. It might work for others, /shrug.

Cheers,
Jeff

just-work’s picture

windows server 2008
iis7
php 5.2.6 fastcgi
mysql 5.0.67
drupal 5.9

When I get to the installation screen, the page just refreshes...

there were posts that indicated that I need to modify bootstrap.inc due to a fastcgi issue, which i did but it did not help...anyone have any additional thoughts? This should NOT be this damn hard...

rubensans’s picture

I happens the same to me.

How did you manage to solve that?

Thanks.

Broicher’s picture

I had the same problems and the solutions offerred here did not help, because most of them are for VISTA and not for Server 2008.
Server 2008 is close to VISTA, but the hotfixes for VISTA wont work for the 2008 Server.

OK, the problem is not a real drupal one and not a mysql one. Its a cookie problem with the multiple sessions. I have installed to fixes, which will be in the upcomming SP2 for 2008 (which is yet only as a beta available, which I do not recommend).

here is the 2 KBs you need to follow (or just install the mentioned fixes):

http://support.microsoft.com/kb/954946/en-us
http://support.microsoft.com/kb/957508/en-us

get those two installed and you will have issues for adding users, not installing the Drupal or not accepting any updates solved under Server 2008 SP1

happy hack (cu on Drupal Con Cologne 18/18 Jan 2009)

Andreas