Loading...
 
Features / Usability

Features / Usability


[Solved] Admin can’t log in (50 or more unsuccessful login attempts)

posts: 9

I had an email saying: 50 or more unsuccessful login attempts have been made. Your account has been suspended. Contact your site administrator to reactivate it. I now get the message: Account requires administrator approval when trying to login

I have access to the Cpanel and PHP file but I'm not too sure how to get logged back in?

Thanks in advance

posts: 8350 Israel
David wrote:

I had an email saying: 50 or more unsuccessful login attempts have been made. Your account has been suspended. Contact your site administrator to reactivate it. I now get the message: Account requires administrator approval when trying to login

I have access to the Cpanel and PHP file but I'm not too sure how to get logged back in?

Thanks in advance


This was a known issue that has been fixed a months ago.

You have to use a database tool and remove manually the lock on your account (it is easy to spot it comparing different accounts)... AND update your Tiki. 🤗

posts: 9
Bernard Sfez / Tiki Specialist wrote:

This was a known issue that has been fixed a months ago.

You have to use a database tool and remove manually the lock on your account (it is easy to spot it comparing different accounts)... AND update your Tiki. 🤗


I fine with removing the manual lock - if I remove this does it allow me to log in? not too sure about the database tool - can you advise further.

many thanks

David


posts: 9
David wrote:

I had an email saying: 50 or more unsuccessful login attempts have been made. Your account has been suspended. Contact your site administrator to reactivate it. I now get the message: Account requires administrator approval when trying to login

I have access to the Cpanel and PHP file but I'm not too sure how to get logged back in?

Thanks in advance


posts: 9
Jonny Bradley wrote:

Hi David

Yes, as Bernard said, you can fix this in phpmyadmin or similar, you just need to clear the "waiting" field on the admin row in the users_users table.

Or you can use this handy bash script a colleague of ours added:

https://gitlab.com/tikiwiki/tiki/-/blob/22.x/doc/devtools/user_reactivation.bash

HTH


I'm still a bit confused on how to log in (the waiting field has an (A) which I removed but then when I tried to log in it, said over 50 attempts had been made.

Where do I add this? Or you can use this handy bash script a colleague of ours added:

https://gitlab.com/tikiwiki/tiki/-/blob/22.x/doc/devtools/user_reactivation.bash

Would it be easier if I remove the lock and then install tiki-21.4 will this sort out the issue? I am currently on ver 21.2

Thanks again for the help.

David


posts: 8350 Israel

Trying to clarify;

  1. Use phpmyadmin (or any database tool) to connect to your database
  2. Go to the table users-users
  3. In the admin row set to null (remove anything) the "waiting" column
  4. In the admin row set to 0 (remove anything) the "unsuccessful_logins" column
  5. Open a new window in a browser, go to your Tiki and login
  6. Update your Tiki (so it doesn’t happen again)


You’re done. ;-)
Good luck

posts: 9
Bernard Sfez / Tiki Specialist wrote:

Trying to clarify;

  1. Use phpmyadmin (or any database tool) to connect to your database
  2. Go to the table users-users
  3. In the admin row set to null (remove anything) the "waiting" column
  4. In the admin row set to 0 (remove anything) the "unsuccessful_logins" column
  5. Open a new window in a browser, go to your Tiki and login
  6. Update your Tiki (so it doesn’t happen again)


You’re done. ;-)

I have now followed the above and updated to ver 21.4 also changed the password but the issues as come back.

Do I need to do anything else?

Many thanks
Good luck

posts: 54 United States
Bernard Sfez / Tiki Specialist wrote:

Trying to clarify;

  1. Use phpmyadmin (or any database tool) to connect to your database
  2. Go to the table users-users
  3. In the admin row set to null (remove anything) the "waiting" column
  4. In the admin row set to 0 (remove anything) the "unsuccessful_logins" column
  5. Open a new window in a browser, go to your Tiki and login
  6. Update your Tiki (so it doesn’t happen again)


You’re done. ;-)
Good luck

Thanks! I had the same issue and this resolved it.

posts: 9
David wrote:

I had an email saying: 50 or more unsuccessful login attempts have been made. Your account has been suspended. Contact your site administrator to reactivate it. I now get the message: Account requires administrator approval when trying to login

I have access to the Cpanel and PHP file but I'm not too sure how to get logged back in?

Thanks in advance


posts: 8350 Israel

Hello David,

Your post are part of the previous which make hard to understand where you’re at.

Once you’ve clean the issue as explained: "Update your Tiki (so it doesn’t happen again)".
You can log normally.

If the issue is solved please add [SOLVED] in the title of the topic.
Thanks