How to suspend user through db?
Article ID: 308 | Rating: Unrated | Last Updated: Mon, May 18, 2020 at 7:29 AM
To suspend all accounts through db please do the following steps.
1. Find database name and database prefix from /usr/local/etc/ezlogin/ez.conf in ezeelogin gateway server.
2. Login to mysql console
3. use db_name
4. Run this query.
update dbprefix_users set status=0, priv=1;
you have to use correct db_name and dbprefix from ez.conf
To suspend only a single user, you may use the following query.
The admin privileged user would be still able to login into the web interface and suspend the users ( users>edit>Enter authorization password> save). Note that this is possible for admin privileged user and not for any other user.
There are no attachments for this article.
How to retreive db credentials?
Viewed 669 times since Wed, Apr 29, 2020