How do i change the authentication from ldap to internal in the database?

I am no longer able to login after i switched to ldap authentication. How do i switch back to normal authentication?

The admin user that was created at the time of installation would still be able to login and switch to normal authentication.
however, if you still want to disable this from the database


For Ezeelogin Version 7 and above


Run the following commands to switch the webpanel authentication to internal authentication


root@jumpserver@~# /usr/local/ezlogin/ez_queryrunner.php "update prefix_settings set value='internal' where name='web_auth';"


 For Ezeelogin Version 6 and below


Connect to the ezeelogin database. The database name and table name can be found from /usr/local/etc/ezlogin/ez.conf


1. Find database name and database prefix from /usr/local/etc/ezlogin/ez.conf in ezeelogin gateway server.


root@jumpserver:~# cat /usr/local/etc/ezlogin/ez.conf

system_folder /var/www/ezlogin/

force_https yes

uri_path /

db_host localhost

db_port /var/run/mysqld/mysqld.sock

db_name ezlogin_por

db_user ezlogin_cxy

db_pass ymhbtPaY)VzD2g]84

db_prefix casmbn_

cookie_encryption_key D8$Frp5fF_FF

cookie_name rlbup

cookie_path /

www_folder /var/www/html/ezlogin/

admin_user ezadmin

mysql_encrypt no



2. Connect to the database and select the settings table..

mysql> select * from wadhik_settings where name='web_auth';
| id | name | value | mtime |
| 37 | web_auth | ldap | 2016-10-25 22:39:51 |
1 row in set (0.00 sec)

mysql> update wadhik_settings set value='internal' where name='web_auth';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> select * from whghik_settings where name='web_auth';
| id | name | value | mtime |
| 37 | web_auth | internal | 2016-10-26 08:55:44 |
1 row in set (0.00 sec)

This would switch the authentication back to 'internal' from 'ldap'

5 (1)
Article Rating (1 Votes)
Rate this article
    Attached Files
    There are no attachments for this article.
    Related Articles RSS Feed
    Integrate OneLogin SSO with jumpserver
    Viewed 1185 times since Wed, Aug 14, 2019
    How to reset cluster keys in ezeelogin Master-slave Configuration ?
    Viewed 1255 times since Fri, Jun 8, 2018
    Can i install ezeelogin Jump server solution in a lan?
    Viewed 20705 times since Sat, Jul 8, 2017
    Enable or Disable or force ssl for the web interface
    Viewed 3368 times since Thu, Jun 15, 2017
    Can we map existing user group in ldap to ezeelogin as ezeelogin user group ?
    Viewed 4808 times since Mon, Sep 25, 2017
    Default outbound ssh port for target servers added in
    Viewed 2194 times since Thu, Dec 21, 2017
    How can i add more than one public key to ezeelogin user ?
    Viewed 2071 times since Wed, Oct 18, 2017
    Will Ezeelogin work behind a firewall or NAT or behind a Proxy?
    Viewed 6651 times since Sat, Jul 8, 2017
    How to enable google 2FA (Two factor Authentication) in ezeelogin ?
    Viewed 5584 times since Mon, Oct 9, 2017
    How to configure Ezeelogin to authenticate using Open_Ldap(Pam-Ldap) in ubuntu?
    Viewed 3933 times since Fri, Feb 23, 2018