External Database Authentication

External Database Authentication

by Sathiraju Sunkara -
Number of replies: 1

Hi

My moodle server is on Linux. And my Authentication table and enrolment table is in SQL.

How can I connect tables  from moodle directly through authentication and enrollment plugins.

Shall I install any drivers on Linux??? Or xan i directly connect by giving IP address and mapping the table.



Average of ratings: -
In reply to Sathiraju Sunkara

Re: External Database Authentication

by Johan Ericka -
i have similar issue but with PostgreSQL (our academic system is using PostgreSQL and moodle is using MySQL)
since there are different table structure between what moodle external database need and our academic system, then i have to pre-processing the data a little bit (doing some table joins).
my workaround for this is make some MySQL tables that meet moodle external database need and make some little PHP script to pull the data (and pre-process it) from our academic system database (PostgreSQL). then i run the script periodically (using crontab).

hope this help
Average of ratings: -