Skip to Content

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

Returning to Standard Authentication After LDAP Setup: Steps to Regain Access

Overview: This article describes how to switch the Ezeelogin web panel authentication from LDAP back to internal authentication using specific commands for versions 7 and above, and database manipulation steps for versions 6 and below.

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

  • Follow the steps mentioned below:

For Ezeelogin Version 7 and above

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 the database name and 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 | time                |
| 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    | time                |
| 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'.

Related Articles:

Error log file and configuration file to troubleshoot.