By dvereber on

I am so new to this it is crazy.

Anyway, running drupal 6 on vista with the latest wamp.

When I try to log in I see:

The name dvereber is a reserved username.
You are not authorized to access this page.

I have also tried admin.

So I found another forum post saying to sql inject (is that the correct phrase?).

UPDATE `users` SET pass = MD5('newpwd') WHERE uid=1;

So I did.

Using php myadmin, I see this in my drupaldb under the "users" (table?):

	uid	name	pass	mail	mode	sort	threshold	theme	signature	signature_format	created	access	login	status	timezone	language	picture	init	data
			0	 	 	 	0	0	0	 	 	0	0	0	0	0	NULL	 	 	 	NULL
			1	dvereber	a5e3094ce553e08de5ba237525b106d5	dve.reber@gmail.com	0	0	0	 	 	0	1298288645	1298440229	1298289057	1	NULL	 	 	dve.reber@gmail.com	a:0:{}
			2	1234567890	e10adc3949ba59abbe56e057f20f883e	lsdkj@gmail.com	0	0	0	 	 	0	1298291682	1298291682	0	1	-28800	 	 	lsdkj@gmail.com	a:1:{s:13:"form_build_id";s:37:"form-d9fbda822112e...
			3	2234567890	ffe7a019bc8c991d28b894b9aaac2ff7	223456@gmail.com	0	0	0	 	 	0	1298291716	1298292357	1298292357	1	-28800	 	 	223456@gmail.com	a:1:{s:13:"form_build_id";s:37:"form-59bb5cd01b58a...
			4	3334567890	25a680c240efd04dbfab33b26cb4921f	dskljsdf@gmail.com	0	0	0	 	 	0	1298292322	0	0	1	-28800	 	 	dskljsdf@gmail.com	a:1:{s:13:"form_build_id";s:37:"form-94ed4dae9096

I hope that was useful.

I also have set some access restrictions...

	aid	mask	type	status
			1	admin	user	1
			2	%admin%	user	1
			3	##########	user	1
			4	%%	user	0

I was trying to restrict everything but my admin account and 10 digit user names.

So, based on the above, the username should be "dvereber" and password "newpwd". Any idea what is going on?

⋅ Categories: Drupal 6.x

Comments

dvereber’s picture

dvereber commented

So in re-reading my description, I found the problem.

I had explicitly allowed "admin"

Which is not my user name.

I manually removed the ilgotten %% access restriction from the sql database with phpmyadmin and life is good.