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.
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'