By dynamicclothing on

Hey,.. im a really new user to drupal and im using this program called "Jumpbox" so that i can use it on my windows computer without any heavy installation. I have been putting to gether my website and for some STUPID reason i but my admin account (only account on my drupal) to "blocked" instead of leaving it on "active" so now when i try to login it says access has been denied for this user..

please help me get back into my account. Is there any easy way of doing this becuase im so new to the whole program?????

Thanks,,, Sean

⋅ Categories: Drupal 5.x

Comments

Quint’s picture

Quint commented

In what screen did you "block" it?

Quint
Stair Calculator

dynamicclothing’s picture

dynamicclothing commented

I think it was in the user access section.. is there any way around this?

Quint’s picture

Quint commented

Actually, I didn't think you could deny User1. That's why I was asking. Are you sure you are trying to log on with User1?

Quint
Home Remodelling

dynamicclothing’s picture

dynamicclothing commented

Yean like im the only account on the application as "admin" and its saying im blocked i was thinking the same thing like how can you block your self ..

what are my options or solutions..

Thanks a lot of the resposes.

Quint’s picture

Quint commented

Can you see the site at all as an anonymous user? Can you log in from another PC on another IP address? Could you have blocked yourself in cpanel instead?

Maybe someone can correct me, but I don't think you can block user1.

Quint
Stair Calculator

dynamicclothing’s picture

dynamicclothing commented

I can see the site as a annonymous user and i see the login page but when i fill in my info

User name: admin
Password : *******

this is the msg i get "The username admin has not been activated or is blocked"

I cant log in from anyotehr user because of the program im using "jumpbox.org" and it runs throw VMware which is only on my computer. what is CPanel?

I really hope i cant block my self.

Quint’s picture

Quint commented

Oh, local on Vmware. cpanel is on webhosts, so it doesn't apply.

The password is case sensitive. Try it with caps.

Quint
Stair Calculator

dynamicclothing’s picture

dynamicclothing commented

I just tried my password with caps and still the same msg.

Quint’s picture

Quint commented

Okay, I see under _ Admin >> User Management _ a "blocked" radio button. If that's what you did ..... you might have to reinstall unless you have an older copy of the database.

Quint
Stair Calculator

dynamicclothing’s picture

dynamicclothing commented

i dont remember seeing anything like radio button. how can i find a older copy of the database?

Quint’s picture

Quint commented

There would be two kinds of backup that would let you revert. A mySQL backup and a VMware snapshot. If you didn't make either of those backups ... time to re-install. Or hang out in the forum and see if anyone can come up with some way. But if Drupal security is good, it would be impossible to get around this.

Quint
Stair Calculator

ilo’s picture

ilo commented

if this tool jumpbox, has a phpmyadmin (i hope it has) you may go to the drupal database, to the users table, and modify the only user.. and change it's status field to 1 for active.

By the way.. the string "has not been activated or is blocked" only appears on real blocked users, so even if the password is wrong, the user is blocked.

And the bad news.. by the way I did test, and not only you can block the admin user, you can even delete if you want.. I remember one day this was an impossible option, but I have tested right now, and I did both.

Quint’s picture

Quint commented

Yeah, that's true, the database has a different login/password, but he said he was new, and from his other questions, I thought it might not be much of an option for him. But good point, if he has a lot of unbacked up (ahem!) content already, it might be worth a shot to try to figure that out.

Quint
Stair Calculator

ilo’s picture

ilo commented

Ok.. you have to create a file in the drupal's directory (move it using ftp or using jumpbox file manager).. call it test.php, writte this inside, 

<?php
include('includes/bootstrap.inc');
include('includes/database.inc');
include('includes/database.mysql.inc');
conf_init();
drupal_bootstrap(DRUPAL_BOOTSTRAP_CONFIGURATION);
drupal_bootstrap(DRUPAL_BOOTSTRAP_DATABASE);
db_query("UPDATE {users} set status = 1 where uid = 1");
?>

and run trough the web:

http://host/drupal/test.php

This php will read any drupal conf needed to setup the database configuration, so you can modify the user status.

You will know if this works if you get a white page..

Quint’s picture

Quint commented

"JumpBox acts like a seasoned IT admin performing security, backup and maintenance functions."

So where's the backup? Maybe he has a backup sitting there (somewhere).

Quint
Shalla.com

dynamicclothing’s picture

dynamicclothing commented

Thanks so much for all your suggestions i cant lie i dont really under stand most of the things your saying to do just becuase im a really new user. I will try and post my status.

Thanks

new user.

drlatino’s picture

drlatino commented

I solve this issue in this way:

1) you have to access your drupal Database (using your "phpmyadmin")
2) then click to the "Users" Table
3) Click the tab "Browse", Now you can see you drupal admin "user"
4) Click the "Edit" for your user (the pencil)
5) Changing the status from "0" to "1" then click in "Go"( to save)

now try again to access your drupal..

it work for me!!

Saludos!!

avia’s picture

avia commented

It really works for me also

thanks

avia

ajayisp’s picture

ajayisp commented

Thank you for that........its working

ajayisp’s picture

ajayisp commented

Thank you for that........its working