Loading...
 
Features / Usability

Features / Usability


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

posts: 18

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: 8633 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: 18
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: 18
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: 18
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: 8633 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: 18
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: 74 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: 74 United States
Bernard Sfez / Tiki Specialist wrote:
I have been unable to make a new forum post here. Not sure why.


I was able to upgrade my Tiki site from 21.1 to 21.2 but I am unable to upgrade to anything past 21.2. The database update fails and my site is no longer works. I've been working on this on and off for over a year.

posts: 8633 Israel
Jeffrey Frady wrote:

I have been unable to make a new forum post here. Not sure why.

I was able to upgrade my Tiki site from 21.1 to 21.2 but I am unable to upgrade to anything past 21.2. The database update fails and my site is no longer works. I've been working on this on and off for over a year.


Hello Jeffrey,

Please open a new discussion with your issue (give us more detail about the error and your environment) we'll try to help to fix.😉


posts: 18
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: 8633 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


Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting