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 web panel authentication of gateway server from LDAP back to internal authentication using database manipulation steps for ezeelogin versions 6 and below and specific commands for versions 7 and above.
The admin user that was created at the time of installation would still be able to log in and switch to normal authentication.
For Ezeelogin Version 6 and below
Connect to the gateway server database. The database name and table name can be found from /usr/local/etc/ezlogin/ez.conf
Step 1: Find the database name and prefix from /usr/local/etc/ezlogin/ez.conf in the gateway server.
Step 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'.
However, if you still want to disable this from the database.
Follow the steps mentioned below:
For Ezeelogin Version 7 and above
Run the following commands to switch the web panel authentication to internal authentication.
root#gateway:~# /usr/local/ezlogin/ez_queryrunner.php "update prefix_settings set value='internal' where name='web_auth';"