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.

0 (0)
Article Rating (No Votes)
Rate this article
    Attached Files
    There are no attachments for this article.
    Related Articles RSS Feed
    Viewed 564 times since Tue, May 19, 2020
    Installing Jump server or Bastion host on a linux host in Google or AWS instance ?
    Viewed 20817 times since Thu, Sep 21, 2017
    How to grant Parallel Shell privilege for a user?
    Viewed 4825 times since Wed, Nov 22, 2017
    What are the security measures to ensure data security?
    Viewed 2051 times since Mon, Aug 21, 2017
    How to retreive db credentials?
    Viewed 669 times since Wed, Apr 29, 2020
    Can we map existing user group in ldap to ezeelogin as ezeelogin user group ?
    Viewed 5027 times since Mon, Sep 25, 2017
    How to find the ssh jumphost software version that is being run?
    Viewed 2395 times since Thu, Mar 1, 2018
    LICENSE ERROR: Could not resolve host:
    Viewed 322 times since Sat, Sep 26, 2020
    User prvilege escalation for particular time
    Viewed 449 times since Wed, Apr 22, 2020
    Will i be locked out if i loose connectivity to the license server or if the Ezeelogin license servers goes down?
    Viewed 3145 times since Mon, Aug 21, 2017