Skip to Content

How to suspend user through db?

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.

 update dbprefix_users set status=0, priv=1 where username=’matt’;

 

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.