General developer forum

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

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

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: -