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......
How to synchronize mysql database of Moodle with Oracle DB for student authentication
by Fatema Siddiqua -
Number of replies: 0