I hope you can help.
I am trying to achieve auto enrolement via an external database using Moodle 1.8 and have been running into issues.
Having checked the PHP, Apache and MySQL logs I resolved one issue. (Connection problems due to the servername) However, after checking through the forums and following a few steps I appear to have got stuck.
Typically I am trying to match the mdl_user.idnumber and mdl_course.idnumber fields as mentioned in various forum posts. I have created the external database with the exact same field settings to avoid any potential conflict.
Can anyone guide me further please? I have provided examples of the setup below:
External DB - MySQL
Table Name: gileshenrol
id: autonumber (INTEGER) (Primary Key)
DB Enrol Settings pictures can be seen below: