Loading...
 
Architecture / Installation

Architecture / Installation


admin Account requires administrator approval error

posts: 24 United States

The Upgrade

I upgraded from Tikiwiki 18.5 to 18.7 using a softaculous script. The upgrade completed without error. The tiki-install reported an error so I updated to UTF-8 encoding. I could not log into the admin account after the upgrade, but could login into existing user accounts. I got the error: (admin) Account requires administrator approval.

I ran the tiki-install.php script again and included the admin account on the lost admin privileges section of the installer script. This did not clear up the problem. I tried to change the password using phpMyAdmin with the command:

`UPDATE `users_users` SET `hash`= md5('admin') WHERE `login`='admin';

where admin is a placeholder for the actual password. I tried this with another user account, but Tikiwiki won't let me login using the new password by this method. It does not seam to work.

I thought this might be a bug and upgraded again to 12.2. The error: (admin) Account requires administrator approval still occurred.

Admin Lockout Hack


I was able to change the admin login to the admin email address using phpMyAdmin and then use I forgot my password to change the admin password. I then changed the admin login email back to just admin. Now, I'm able to access the admin control panels.

This leads to the following questions.

  • Is there a better way to fix this?
  • The database crashes when I select remember me for a week. Is there a way to fix this other than having to run the tiki-install.php every time it happens?
  • Should I make the LDAP admin user password in the login control panel the same as the admin user login password?


Anyway, nice work on the updates. I'm really like be able to also use markdown syntax in my blogs.


posts: 15

Similar problem, still on v15.2 (swear I'll upgrade if I can access the admin again).

Tried changing users_users pwd through phpMyAdmin sql statement as above, but still get the error: (admin) Account requires administrator approval.

Going through forgot password route gives Error:
The mail can't be sent. Contact the administrator

A separate non admin account log in works.

I wonder if there is aflag thrown somewhere after too many password attempts that needs to be reset? Any suggestions on how to recover this installation would be lovely.

posts: 3665 United States
gdville wrote:
I wonder if there is aflag thrown somewhere after too many password attempts that needs to be reset? Any suggestions on how to recover this installation would be lovely.


If you have access to the database, you can modify the waiting and unsuccessful_logins columns of the users_users table, as described here.

HTH,

- Rick | My Tiki Blog | My Tiki UserPage

Why be a dummy? Get smarty! TikiForSmarties.com
Tiki for Smarties, your source for the best (and only) Tiki books, guides, and tutorials.

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