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
connect to the ezeelogin database. The database name and table name can be found from /usr/local/etc/ezlogin/ez.conf

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'

0 (0)
Article Rating (No Votes)
Rate this article
    Attached Files
    There are no attachments for this article.
    Related Articles RSS Feed
    Configuration and error log files to check for troubleshooting
    Viewed 3971 times since Thu, Jun 15, 2017
    Configure Nginx webserver on Jump server / Bastion host
    Viewed 6108 times since Fri, Nov 3, 2017
    Set SSH User Expiry
    Viewed 1124 times since Thu, Sep 20, 2018
    How can i add more than one public key to ezeelogin user ?
    Viewed 1478 times since Wed, Oct 18, 2017
    setup web ssh console in ezeelogin and ssh via browser
    Viewed 6205 times since Tue, Jan 30, 2018
    Will Ezeelogin work behind a firewall or NAT or behind a Proxy?
    Viewed 3305 times since Sat, Jul 8, 2017
    How can i reset password / security code ?
    Viewed 2246 times since Wed, Oct 18, 2017
    configure jump server to use SSL for MySQL server
    Viewed 1907 times since Thu, Apr 12, 2018
    Integrate OpenLdap / Windows Active Directory ( AD ) authentication in ezeelogin jump server (Centos &Ubuntu)
    Viewed 5334 times since Thu, Jun 15, 2017
    How to configure Yubikey two factor authentication in ssh ?
    Viewed 4559 times since Thu, Jun 15, 2017