next »

[zi]

So you get blocked from MODx Content Manager!

No problem, just read this step by step guide and in less then 5 minutes you will be able to login again. 

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.

Best regards,

-zi 

WARNING: Before doing any manual database work, please backup your database, especially the table you are working with.

[sottwell]

It's been suggested before that it's a good idea to make sure to create a second admin user right away, just for this sort of problem.

[zeth]

If you don't have phpMyadmin, or want to do it from the MySQL commandline, do the following:

1. mysql -u username -p
2. use yourModxDatabaseName;
3. UPDATE modx_user_attributes SET blockeduntil=0 WHERE id=1;

[zi]

Than you very much Sottwell and zeth !! for your suggestions.

Best regards,

-zi

[xwisdom]

What if we should add a forget (or reset) password feature to the manager? Maybe something like the one used with weblogins. It would send a new password to the user's email that would require activation

[zi]

What if we should add a forget (or reset) password feature to the manager? Maybe something like the one used with weblogins. It would send a new password to the user's email that would require activation

PERFECT !!!  

Regards,

-zi

[Djamoer]

should we do this as a snippet right away, would you mind reporting it to the feature/bug report? Maybe some developer able to do it, or maybe us can do it too. Maybe we need to ask ryan, whether he wants this to be added as a feature request or not.

What I have in mind is, having a forgot password link, and when the user click on it, and it will request for both username and email address, then it will set the blockeduntil into random number, and send both password and this number to the admin email address, if both username and email is matched.

Then in the email, it will give a link to forgot password special page, which required admin name, password and this number to confirm the submission, if they're all right, it will reset the value.

How's that sounds?

[blogplus]

During the installation both head and papers becomes full of crows feet.

1. When logging into MODx manager session first time it's not really clear to me which login?   ...the mysql-login or the admin login?

2. Can I redo the login-setting via myPHPadmin? (maybe up/low case confusion here)

[Djamoer]

It's better if you have access to phpMyAdmin, then do it from there, instead of reinstalling everything again. But if you're insisting to re-install it. then find an instalation folder on your MODx download, and re-upload that folder to your MODx remote folder. Then you need to remove config.inc.php file on your "manager/include" folder. After you're done with that, browse your site again, then it will prompt you with a new setup screen.

You might want to choose differen table prefix, if you haven't delete all the tables created during the first installation.

[blogplus]

It's better if you have access to phpMyAdmin, then do it from there, instead of reinstalling everything again.

What you suggest?
The MODx-login should be the mySQL-login... right!? 

So, then I can create a new all preference user with a new login? (and delete the non operational afterwards)   

[rthrash]

MySQL user/pass is really not and probably should not be the same as your default Admin user. Or it could be, that's for you to decide.

We definitely need a password resetter for the manager. Should not be a snippet, but a modification to the manager/includes/accesscontrol.inc.php file I think. Probably should be logged, if it hasn't already. Should be able to use the same logic pointing at different tables as the webuser login code.

[blogplus]

I restart from delete... 

[Djamoer]

lol, that will work as well.

As Ryan suggested, don't you use your mysql username and pass. It's adviseable to have them separated. This username and pass for admin is for you to be able to login to the manager part. As far as username and pass for MySql, that's for the system to be able to get into the database.

Hope that clear.

[unclemeat]

Just wondering if this will work if I forgot the admin password - will the phpMyAdmin fix let you reset the password or just give you more or unlimited number of login attempts.

Thanx

[sottwell]

To manually reset the password, use phpMyAdmin to browse the 'manager_users' table, edit the admin user's row, replace the encoded password with your new one, and choose "MD5" from the Function dropdown for that field.

[Colin]

This is hacking me off!

I forgot that I had changed the password, and I've locked myself out. I find it strange that I must go into the database to get back in. The problem I now have is that the field is already set to "0", but I'm definitely locked out!? This is the only user, so I'm not looking at another ID, this is definitely ID #1. - What am I missing?

Thanks.

[rthrash]

blocked until

[Colin]

blocked until

Yeah, I know!

It displays "0", and this is definitely ID #1, and not the defaults!

[rthrash]

There's two blocking related fields. Blocked and blocked_until, or something like that. And keep in mind that web users and manger users are different tables.You have to get them both reset.

[Colin]

I'm still confused. I confess I have zero knowledge of databases, but still, Zi's instructions appear to only take me to the default values; there is no option for selecting an ID.

I instead selected it from the right side, and managed to get the ID #1 account:



Now, I've gone back again to the same place (above), and there is now a time code!? I have no idea of what's going on?