How to activate a disabled Adminaccount?

ℹ️ Support
1

Hi

I installed NextCloud with MySql Behind
For some reason my unique admin account is disabled. I think the reason was because of too many attempts.

I need to activate it because it’s the only admin account i have.

I tried to find it in the database but i couldn’t find where to enable it.

Anyone?
opera_yPNoBfUrWG

2

login to your server using SSH, switch to the Nextcloud document root and use the occ cmmand line tool to enable the user again, e.g. ./occ user:enable <username>.

3

Another option is to open phpMyAdmin and go to “oc_group_user”.

Find a user which a account that can login, copy that user and change the the name in “gid” in “admin”.

I’ve just had the same problem, changed a normal account into a admin account and after logging in I could activate the Admin by the account settings.

Good luck.

1 Like
4

Thanks!! That worked! :wink:

5

I have a webhost, so Alphia’s answer was more appropriate for me. Thanks Anyway for the help! :slight_smile:

6

I installed a new site with nextcloud but the new database doesn’t contain “oc_group_user” table,
Is there any other way to activate the accounts through the database?

7

Try to create the table manually:

> describe oc_group_user;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| gid   | varchar(64) | NO   | PRI |         |       |
| uid   | varchar(64) | NO   | PRI |         |       |
+-------+-------------+------+-----+---------+-------+
2 rows in set (0.007 sec)
1 Like
8

I got it work with another admin user. But i will try with the table if it occur again. Thanks anyway.

9

Hi,

root@nextcloud:~# sudo -u www-data php occ user:resetpassword admin_username
Could not open input file: occ

root@nextcloud:~# sudo -u www-data php /var/www/nextcloud/occ user:add --display-name=“ahmed” --group=“admin” ahmed
Could not open input file: /var/www/nextcloud/occ

I am trying to re-enable my admin user from shell but I get those errors where the occ file cant be found