How to synchronize mysql database of Moodle with Oracle DB for student authentication

How to synchronize mysql database of Moodle with Oracle DB for student authentication

by Fatema Siddiqua -
Number of replies: 0

Hello Everybody, I have Externel Database as Oracle in my local PC. After Reading the doc I tried and did the following settinds:

Databse driver: ODBC-ORACLE

Database Host: 10.32.1.246
Local field mapping

Local course field: idnumber

Local user field: idnumber

Local role field: shortname

For Remote Enrolment Sync:

Remote user enrolment table: ad_student_msts

Remote course field: COURSE_CODE

Remote user field: SOL_ROLL_NO

Remote role field: BLANK

For Plugins> Authentication>External Database, I have done the following settings:

Host:10.32.1.246

Database: ODBC_ORACLE

DB name: orcl

DB user:dusol

Table: ad_student_msts

Username field: SOL_ROLL_NO

Password field: EMAIL_ID

Password format: Internal

rest all to default...

Then I have also manually run cron.php

Now, Its showing 0/0 instances/enrolment for external databe in Manage Enrol Plugins.

I think, it should now send an e-mail for password to users email id. only after that a user may be able to login (But did not received any mail).

Is there any other way to check that connection have been made or not?

I am a newbie in Moodle and stucked badly with external enrolmant plugins.

Plzz someone help me with step by step documentation. I am using xampp on windows OS and Moodle 2.2.6.

Thanking You All in Advance......

Average of ratings: -