Authentication with External Database Example

Authentication with External Database Example

by Vishal Lanke -
Number of replies: 2

Is there any document or sample example on how to use External Authentication. All users are stored in CSV and this CSV gets regularly updated. How can I authenticate users in Moodle using CSV. What fields should I entered inside Host, User Name, password. I tried  various combinations but nothing works.

Average of ratings: -
In reply to Vishal Lanke

Re: Authentication with External Database Example

by Howard Miller -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers

There is no authentication method that reads directly from a CSV file. 

Your best plan is to write a script that regularly loads the CSV into a suitably formatted database and then uses external database enrolment. See External_database_authentication.

In reply to Howard Miller

Re: Authentication with External Database Example

by Vishal Lanke -

There is external authentication plugin inbuilt. It shows CSV, SQL etc etc.

Employees information in our organization is stored inside MSSQL database.

I can not find any document which tells me what to configure inside External Database for MSSQL