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.
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
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
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?
Read »
