[Tutorial] Help I'm Blocked from the Manager and Can't Get In!

3,975 Posts

Zaigham (aka zi) Reply #31, 15 years, 11 months ago

Sure you can. Though I can’t think of anything at the moment which can cause no login if username and passwords are correct. You can also dump the selected tables from the old database and load them into new.

Zaigham R - MODX Professional | Skype | Email | Twitter

Digging the interwebs for #MODX gems and bringing it to you. modx.link

1 Posts

GJCANHELP Reply #32, 15 years, 8 months ago

The instructions that were mentioned in this article were available to me, with the following EXCEPTIONS

I went to the phpMyAdmin as instructed and followed all the steps except that in Step #6 & #7:

#6 In your username row, you will find field named "blockeduntil" and this field contains 10 digits value (e.g. 1116602445)
(there was no value expressed as such, in fact there was NOTHING that even resembled this field that you are referring to)

#7 Edit the field, and set the value to "0" (zero).
(there was no place to set the value to zero.

I was really disappointed because I thought that this would help. I just don’t have the $129 to pay for you to do it.

Greg Jones

MODX Staff
12,272 Posts

Ryan Thrash Reply #33, 15 years, 8 months ago

You should also reset your password by choosing your user, selecting the password, and entering a new one. Make sure to select the MD5 function.

Ryan Thrash, MODX Co-Founder
Follow me on Twitter at @rthrash or catch my occasional unofficial thoughts at thrash.me

☆ A M B ☆
24,524 Posts

sottwell Reply #34, 15 years, 8 months ago

Here is a dump of the structure of the user_attributes table:

CREATE TABLE `modx_user_attributes` (
  `id` int(10) NOT NULL auto_increment,
  `internalKey` int(10) NOT NULL default '0',
  `fullname` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `role` int(10) NOT NULL default '0',
  `email` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `phone` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `mobilephone` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `blocked` int(1) NOT NULL default '0',
  `blockeduntil` int(11) NOT NULL default '0',
  `blockedafter` int(11) NOT NULL default '0',
  `logincount` int(11) NOT NULL default '0',
  `lastlogin` int(11) NOT NULL default '0',
  `thislogin` int(11) NOT NULL default '0',
  `failedlogincount` int(10) NOT NULL default '0',
  `sessionid` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `dob` int(10) NOT NULL default '0',
  `gender` int(1) NOT NULL default '0' COMMENT '0 - unknown, 1 - Male 2 - female',
  `country` varchar(5) collate utf8_unicode_ci NOT NULL default '',
  `state` varchar(25) collate utf8_unicode_ci NOT NULL default '',
  `zip` varchar(25) collate utf8_unicode_ci NOT NULL default '',
  `fax` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `photo` varchar(255) collate utf8_unicode_ci NOT NULL default '' COMMENT 'link to photo',
  `comment` varchar(255) collate utf8_unicode_ci NOT NULL default '' COMMENT 'short comment',
  PRIMARY KEY  (`id`),
  KEY `userid` (`internalKey`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Contains information about the backend users.' AUTO_INCREMENT=2 ;

As you can see, there is indeed a blockeduntil field. Perhaps you were not looking in the correct table?

Studying MODX in the desert - http://sottwell.com
Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
Join the Slack Community - http://modx.org

4 Posts

KansasCoder Reply #35, 14 years, 8 months ago

My new install of 1.0.0 on MySQL 5.0.67.d7-ourdelta-log (a GoDaddy WINDOWS IIS7 shared hosting environ) has this same issue of not allowing me to log into my manager with my uname/pwd. The blockeduntil and blocked columns are set to 0.

When I attempted to use the lost password utility I got an error that is probably due to my not having the smtp setup correctly? But if I recall correctly there was only a place for an email and not a place for smtp settings. Should these be in the config file that is written during setup?

If someone could point me in the right directio to resolve my issues I would be grateful.

The error I get when using the forgot password tool on the Manager Login is:

Warning: mail() [function.mail]: SMTP server response: 451 See http://pobox.com/~djb/docs/smtplf.html. in D:\Hosting\4793090\html\manager\includes\document.parser.class.inc.php(746) : eval()’d code on line 107

The pobox link talks about bare LFs in smtp.

BTW: I have set an instance up on a linux box and didn’t have these issues.

Thank you,
Rich

☆ A M B ☆
24,524 Posts

sottwell Reply #36, 14 years, 8 months ago

If the php mail() function has been blocked in your server’s configuration, then you’ll have that problem. As far as the rest, perhaps you should post to the Windows/IIS hosting board.

Studying MODX in the desert - http://sottwell.com
Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
Join the Slack Community - http://modx.org

90 Posts

jzigbe Reply #37, 14 years, 7 months ago

Quote from: tifo at Mar 10, 2007, 02:15 PM

got it ...

i had to run an SQL query UPDATE modx_user_attributes SET blockeduntil=0 WHERE id=1;

This also worked for me! The other instructions did not.

Jan

1 Posts

zowwie Reply #38, 14 years, 5 months ago

I have tried ALL of the suggestions here to log in to my manager. None of them have worked. Blocked, Blocked Until,set new passwords several times using MD5,asked to have info sent to email and never received email,erased cookies,... Am I missing something? Is there anything else besides starting over? Thanks so much for any help.

22 Posts

andrew.abogado Reply #39, 14 years, 5 months ago

Quote from: zi at May 20, 2005, 03:20 PM

You need to have access to phpMyAdmin on your host, if you have not then ask your service provider.

Now open phpMyAdmin.

Select your database from dropdown list in left menu of phpMyAdmin. ( e.g. modx )

Now, you see the list of tables displayed in left menu.

Find table name with "table_prefix_user_attributes". ( e.g. modx_user_attributes )

Find your username in the list.

In your username row, you will find field named "blockeduntil" and this field contains 10 digits value (e.g. 1116602445)

Edit the field, and set the value to "0" (zero).

Exit from phpMyAdmin, and you are done.

I’m glad I found this guide. It worked for me. Thanks ZI

An aspiring web designer & front-end web developer who is very much interested on the modern web.

www.andrewabogado.com

☆ A M B ☆
427 Posts

W. Shawn Wilkerson Reply #40, 14 years, 4 months ago

I think it should suffice to set the maximum time-out to 5 minutes.This should help people who can not get in. At least the worst case scenario is a 5 minute wait.

Get your copy of MODX Revolution Building the Web Your Way http://www.sanitypress.com/books/modx-revolution-building-the-web-your-way.html

Check out my MODX || xPDO resources here: http://www.shawnwilkerson.com