Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

admin user locked out
 
lniederberger
Jr. Member
 
Total Posts:  5
Joined:  2008-07-24
 

I was trying to add a new admin user and somehow managed to set the permissions so that no one can get into the admin screen now. I somehow managed to change the roles or some other setting. Now no one can login to the admin screen.

It would seem that this should be impossible to do, but I managed to do it. Other than reinstalling the software, does anyone have any ideas?

Thanks!

 
Magento Community Magento Community
Magento Community
Magento Community
 
SeL_
Magento Team
 
Avatar
Total Posts:  1140
Joined:  2007-10-10
Paris, France
 

Hi,

Please post here the content of the following database tables :
- admin_rule
- admin_role
- admin_user

 
Magento Community Magento Community
Magento Community
Magento Community
 
lniederberger
Jr. Member
 
Total Posts:  5
Joined:  2008-07-24
 

I have attached an html file, so you could read the tables more easily.

File Attachments
admin_user.html  (File Size: 17KB - Downloads: 92)
 
Magento Community Magento Community
Magento Community
Magento Community
 
SeL_
Magento Team
 
Avatar
Total Posts:  1140
Joined:  2007-10-10
Paris, France
 

Your database seems to be corrupted.
The passwords are not encrypted.
You made changes by hand directly in the database, didn’t you ?

You can try the following :
1) Backup your database (db1)
2) Install from scratch a new Magento into a new database (db2). Use the same encryption key as your previous installation.
3) Copy the 3 tables content from db2 into db1

Try to connect (into your previous Magento installation) with the admin account your created at step 2.

If this doesn’t work, i guess you should work with a brand new Magento installation.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top