Installed Drupal, but can't get access to my own site [#194367]

1) checked out head about 2 hours ago
2) wiped out old db tables
3) ran install.php, completed with no errors
4) after install, was confronted with "access denied" page
5) log out and log in
6) still get "access denied" page
7) click "my account" link on left, shows user for x min xx sec. I am able to edit my account just like I can when logged in.
8) look at address bar and notice it says /user/9. wtf?
9) look in user db, see the following:

uid         name                            pass                          mail  
==========================================================================================
0         
4         placeholder-for-uid-1                                      placeholder-for-uid-1
9         steve                            md5 hash                  my@email.com

My config:
debian (etch)
fastcgi
apache2
mysql 4.1
PHP 4.4.4-8+etch4.1

Comment	File	Size	Author
#12	auto_increment_increment.patch	1.2 KB	chx
#12
#9	auto_increment_increment.patch	1.32 KB	chx
#9
#8	auto_increment_increment.patch	3.18 KB	chx
#8

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

chx CreditAttribution: chx commented 22 November 2007 at 06:38

Status:

Active

» Postponed (maintainer needs more info)

By wiping out old DB tables, what do you mean? Have you dropped your database?

Comment #2

Steve Dondley CreditAttribution: Steve Dondley commented 22 November 2007 at 07:05

The tables were dropped not the db. Did the install on an empty db.

Comment #3

Steve Dondley CreditAttribution: Steve Dondley commented 22 November 2007 at 08:30

Status:

Postponed (maintainer needs more info)

» Active

Comment #4

Gábor Hojtsy

he/him

Hungarian

Hungary

CreditAttribution: Gábor Hojtsy commented 22 November 2007 at 09:21

Status:

Active

» Closed (works as designed)

Seems like you "wiped your tables" (ie. emptied your tables) not dropped them. Otherwise the admin uid would not be 9.

Comment #5

Steve Dondley CreditAttribution: Steve Dondley commented 22 November 2007 at 15:07

Status:

Closed (works as designed)

» Active

Un, no. I dropped them. I've done this a total of 4 times now, the results are precisely the same each time. If you want, I can set up a gotomeeting with someone and they can watch my computer screen from their location and they can see for themselves.

Comment #6

chx CreditAttribution: chx commented 22 November 2007 at 15:21

That's alas not enough. I have installed Drupal countless times on my machine and never seen this. I need file level access to see what's on.

Comment #7

Steve Dondley CreditAttribution: Steve Dondley commented 22 November 2007 at 16:08

OK, set up shell access on my server. Let me know if you want to get in there.

Comment #8

chx CreditAttribution: chx commented 22 November 2007 at 18:41

Assigned:	Unassigned	» chx
Status:	Active	» Reviewed & tested by the community

File	Size
auto_increment_increment.patch	3.18 KB

auto_increment_increment is the name of the mysql system variable that made this happen.

Comment #9

chx CreditAttribution: chx commented 22 November 2007 at 18:42

File	Size
auto_increment_increment.patch	1.32 KB

Other changes slipped in sorry. Thanks to sdondley for providing access.

Comment #10

Gábor Hojtsy

he/him

Hungarian

Hungary

CreditAttribution: Gábor Hojtsy commented 22 November 2007 at 20:08

Status:

Reviewed & tested by the community

» Needs review

So why do we avoid the uid = 0 explicit UPDATE?

Comment #11

chx CreditAttribution: chx commented 22 November 2007 at 20:40

Because some MySQL acts weirdo. And do not ask which for I can't remember. This surely works and can not hurt anything.

Comment #12

chx CreditAttribution: chx commented 22 November 2007 at 20:59

File	Size
auto_increment_increment.patch	1.2 KB

updated comment:

This sets the above two users uid 0 (anonymous). We avoid an explicit 0 otherwise MySQL might insert the next auto_increment value.

Comment #13

Gábor Hojtsy

he/him

Hungarian

Hungary

CreditAttribution: Gábor Hojtsy commented 22 November 2007 at 21:02

Status:

Needs review

» Fixed

Great, thanks, committed.

Comment #14

(not verified) CreditAttribution: commented 6 December 2007 at 21:12

Status:

Fixed

» Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.

Comment #15

Steve Dondley CreditAttribution: Steve Dondley commented 16 February 2008 at 16:05

Status:

Closed (fixed)

» Active

OK, this problem seems to be rearing its head again. Fresh install of drupal 6. Started with empty datbase. When I look in the role table, I see:

1 anonymous user
5 authenticated user

My version of mysql: mysql 5.0.32

Comment #16

Steve Dondley CreditAttribution: Steve Dondley commented 16 February 2008 at 16:11

Status:

Active

» Closed (fixed)

OK, I see now this should probably be a separate issue, though they seem to stem from the same db problem. In this case, my role table has funky rids. Previously, the user table had bad uids. Closing will open a different bug report.