Moodle in English: error: skipping unknown user on External Database enrolment

About 1 year ago I setup our Moodle server to talk to an external SQL Anywhere databse, and up until about 1 week or so ago it worked flawlessly.
However recently when we've added users to database they haven't been syncing with the local mysql database used by Moodle.
However if I manually add the user, set them to external authentication and try to login it works just fine.
I did some troubleshooting and as best I can tell the ODBC connection still works, but for some reason the users aren't being enrolled in the courses.
I am stumped and hoping someone can provide some guidance.
Also if it makes any difference my Moodle version is 2.5.6+ Build 20140515 - I recently upgraded thinking maybe that would help.
I can provide any additional information you may require, thanks in advance.

I've manually run the enrollment for my course and this is what I get:

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '033072'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '034391'

-----<hr>

error: skipping unknown user username 'Krispearce' in course '034391'

error: skipping unknown user username 'myralcoby' in course '034391'

error: skipping unknown user username 'lisadawnrichardson' in course '034391'

error: skipping unknown user username 'smanderson' in course '034391'

error: skipping unknown user username 'Cleffall' in course '034391'

error: skipping unknown user username 'heatherpierce' in course '034391'

error: skipping unknown user username 'krider' in course '034391'

error: skipping unknown user username 'kaseylsmith' in course '034391'

error: skipping unknown user username 'kimjones' in course '034391'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '033501'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '031139'

-----<hr>

error: skipping unknown user username 'lavendajones' in course '031139'

error: skipping unknown user username 'lisadawnrichardson' in course '031139'

error: skipping unknown user username 'EllaPrior' in course '031139'

error: skipping unknown user username 'CaitlinPrior' in course '031139'

error: skipping unknown user username 'NicoleReedy' in course '031139'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '033748'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '032973'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '034403'

-----<hr>

error: skipping unknown user username 'myralcoby' in course '034403'

error: skipping unknown user username 'wtravis' in course '034403'

error: skipping unknown user username 'jenniferbrumley' in course '034403'

error: skipping unknown user username 'lisadawnrichardson' in course '034403'

error: skipping unknown user username 'tatek44' in course '034403'

error: skipping unknown user username 'donnalovell' in course '034403'

error: skipping unknown user username 'staciesmith' in course '034403'

error: skipping unknown user username 'dawnerwin' in course '034403'

error: skipping unknown user username 'laurenwood' in course '034403'

error: skipping unknown user username 'smanderson' in course '034403'

error: skipping unknown user username 'andersm' in course '034403'

error: skipping unknown user username 'Cleffall' in course '034403'

error: skipping unknown user username 'krider' in course '034403'

error: skipping unknown user username 'kimjones' in course '034403'

error: skipping unknown user username 'escamillaa' in course '034403'

error: skipping unknown user username 'jenniferadams' in course '034403'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '034828'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '031966'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '031975'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '033107'

-----<hr>

error: skipping unknown user username 'ds1227' in course '033107'

error: skipping unknown user username 'alainadcannon' in course '033107'

error: skipping unknown user username 'lraymundo' in course '033107'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '033700'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '033689'

-----<hr>

error: skipping unknown user username 'gstokes' in course '033689'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '037444'

-----<hr>

error: skipping unknown user username 'rchapman01' in course '037444'

error: skipping unknown user username 'jhearn44' in course '037444'

error: skipping unknown user username 'lavaunda' in course '037444'

error: skipping unknown user username 'mmolandes' in course '037444'

error: skipping unknown user username 'lwteacher' in course '037444'

error: skipping unknown user username 'jessicabarry' in course '037444'

error: skipping unknown user username 'JACKLYNLEE' in course '037444'

error: skipping unknown user username 'devrus' in course '037444'

error: skipping unknown user username 'chrissy1005' in course '037444'

error: skipping unknown user username 'hillo' in course '037444'

error: skipping unknown user username 'adguy' in course '037444'

error: skipping unknown user username 'juliepetty' in course '037444'

error: skipping unknown user username 'goodteacher' in course '037444'

error: skipping unknown user username 'jaclynbrooke' in course '037444'

error: skipping unknown user username 'Jwaddill1' in course '037444'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '037113'

-----<hr>

error: skipping unknown user username 'rplatt' in course '037113'

error: skipping unknown user username 'mltinkle' in course '037113'

error: skipping unknown user username 'btippett' in course '037113'

error: skipping unknown user username 'JERRIESTRAHAN1' in course '037113'

error: skipping unknown user username 'stomlinson' in course '037113'

error: skipping unknown user username 'cathywindham' in course '037113'

error: skipping unknown user username 'maparicio' in course '037113'

error: skipping unknown user username 'jhoga7145' in course '037113'

error: skipping unknown user username 'Jstork' in course '037113'

error: skipping unknown user username 'EKawesa' in course '037113'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '035920'

-----<hr>

error: skipping unknown user username 'jamieholman' in course '035920'

error: skipping unknown user username 'catesa' in course '035920'

error: skipping unknown user username 'bongiovannismith' in course '035920'

error: skipping unknown user username 'marybeaty' in course '035920'

error: skipping unknown user username 'vennessa' in course '035920'

error: skipping unknown user username 'landersw' in course '035920'

error: skipping unknown user username 'gretchenn' in course '035920'

error: skipping unknown user username 'wtravis' in course '035920'

error: skipping unknown user username 'jtrickey' in course '035920'

error: skipping unknown user username 'lynnhooks' in course '035920'

error: skipping unknown user username 'TrevaPatterson1' in course '035920'

error: skipping unknown user username 'hoggs' in course '035920'

error: skipping unknown user username 'aoliver' in course '035920'

error: skipping unknown user username 'sandraglaze' in course '035920'

error: skipping unknown user username 'bundyg' in course '035920'

error: skipping unknown user username 'bamoore' in course '035920'

error: skipping unknown user username 'rebeccavazquez' in course '035920'

error: skipping unknown user username 'balvarez' in course '035920'

error: skipping unknown user username 'DanielLovera1' in course '035920'

error: skipping unknown user username 'KimKing' in course '035920'

error: skipping unknown user username 'nherigon' in course '035920'

error: skipping unknown user username 'srdean' in course '035920'

error: skipping unknown user username 'deshonda' in course '035920'

error: skipping unknown user username 'tatek44' in course '035920'

error: skipping unknown user username 'demetrixwatkins' in course '035920'

error: skipping unknown user username 'candacecraig' in course '035920'

error: skipping unknown user username 'jlshields' in course '035920'

error: skipping unknown user username 'angiegreer1' in course '035920'

error: skipping unknown user username 'sueglenn' in course '035920'

error: skipping unknown user username 'iveykyle' in course '035920'

error: skipping unknown user username 'donnatubbs' in course '035920'

error: skipping unknown user username 'yasminesmith' in course '035920'

error: skipping unknown user username 'ashworthj' in course '035920'

error: skipping unknown user username 'Bwarren' in course '035920'

error: skipping unknown user username 'lhubbard' in course '035920'

error: skipping unknown user username 'markettaarnold' in course '035920'

error: skipping unknown user username 'pmccowan' in course '035920'

error: skipping unknown user username 'suewitt' in course '035920'

error: skipping unknown user username 'jennbarker' in course '035920'

error: skipping unknown user username 'sjmcdaniel' in course '035920'

error: skipping unknown user username 'mhalbrook' in course '035920'

error: skipping unknown user username 'gdhewitt' in course '035920'

error: skipping unknown user username 'dlhaley' in course '035920'

error: skipping unknown user username 'navywyfe' in course '035920'

error: skipping unknown user username 'ConnieBurrell' in course '035920'

error: skipping unknown user username 'bgoffney' in course '035920'

error: skipping unknown user username 'cfontaine' in course '035920'

error: skipping unknown user username 'elizabethashcraft' in course '035920'

error: skipping unknown user username 'JMTanner' in course '035920'

error: skipping unknown user username 'junerussell' in course '035920'

error: skipping unknown user username 'thecluttereddesk' in course '035920'

error: skipping unknown user username 'KileyTaylorScott' in course '035920'

error: skipping unknown user username 'LisaKillebrew' in course '035920'

error: skipping unknown user username 'trichawilcox' in course '035920'

error: skipping unknown user username 'schullehr' in course '035920'

error: skipping unknown user username 'PeterDteacher' in course '035920'

error: skipping unknown user username 'paulahood' in course '035920'

error: skipping unknown user username 'kellycameron' in course '035920'

error: skipping unknown user username 'dobbins71' in course '035920'

error: skipping unknown user username 'bravoa' in course '035920'

error: skipping unknown user username 'jerrygreen' in course '035920'

error: skipping unknown user username 'turners' in course '035920'

error: skipping unknown user username 'eewilliams' in course '035920'

error: skipping unknown user username 'Everardo' in course '035920'

error: skipping unknown user username 'hermanl' in course '035920'

error: skipping unknown user username 'Samuel1' in course '035920'

error: skipping unknown user username 'stringfellow' in course '035920'

error: skipping unknown user username 'Lacozette' in course '035920'

error: skipping unknown user username 'merodriguez' in course '035920'

error: skipping unknown user username 'mfowler88' in course '035920'

error: skipping unknown user username 'gking01' in course '035920'

error: skipping unknown user username 'jannaboyd' in course '035920'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '035923'

-----<hr>

error: skipping unknown user username 'lauralove1' in course '035923'

error: skipping unknown user username 'Afaett' in course '035923'

error: skipping unknown user username 'kdbrooks' in course '035923'

error: skipping unknown user username 'summerblair' in course '035923'

error: skipping unknown user username 'mroman' in course '035923'

error: skipping unknown user username 'lourdescolon' in course '035923'

error: skipping unknown user username 'molandesr' in course '035923'

error: skipping unknown user username 'AshleighWeaver' in course '035923'

error: skipping unknown user username 'cjbrooks' in course '035923'

error: skipping unknown user username 'pjbrager' in course '035923'

error: skipping unknown user username 'tmabercrombie' in course '035923'

error: skipping unknown user username 'tmsimmons' in course '035923'

error: skipping unknown user username 'detorres' in course '035923'

error: skipping unknown user username 'dphunt' in course '035923'

error: skipping unknown user username 'bagodair10' in course '035923'

error: skipping unknown user username 'HildaHayati' in course '035923'

error: skipping unknown user username 'gking01' in course '035923'

error: skipping unknown user username 'crlara' in course '035923'

error: skipping unknown user username 'efburnett' in course '035923'

error: skipping unknown user username 'AshleyHolmes' in course '035923'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '033946'

-----<hr>

error: skipping unknown user username 'poneal' in course '033946'

error: skipping unknown user username 'debrajohn' in course '033946'

error: skipping unknown user username 'baveilleux' in course '033946'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '038878'

-----<hr>

error: skipping unknown user username 'PriceKM' in course '038878'

error: skipping unknown user username 'KNBeasley' in course '038878'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '033948'

-----<hr>

error: skipping unknown user username 'mistydudley' in course '033948'

error: skipping unknown user username 'solis2' in course '033948'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '035820'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '033947'

-----<hr>

error: skipping unknown user username 'lourdescolon' in course '033947'

error: skipping unknown user username 'kneugent' in course '033947'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '040780'

-----<hr>

error: skipping unknown user username 'SheilaHaralson' in course '040780'

error: skipping unknown user username 'giatmcjw' in course '040780'

error: skipping unknown user username 'Argonai' in course '040780'

error: skipping unknown user username 'aralarop' in course '040780'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '039269'

-----<hr>

error: skipping unknown user username 'ssbailey' in course '039269'

error: skipping unknown user username 'mmaldonado' in course '039269'

error: skipping unknown user username 'mystery1green' in course '039269'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '039347'

-----<hr>

error: skipping unknown user username 'gretchenn' in course '039347'

error: skipping unknown user username 'rodriguezj' in course '039347'

error: skipping unknown user username 'lraymundo' in course '039347'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '033949'

-----<hr>

error: skipping unknown user username 'lourdescolon' in course '033949'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '037795'

-----<hr>

error: skipping unknown user username 'racheljmiller' in course '037795'

error: skipping unknown user username 'molandesr' in course '037795'

error: skipping unknown user username 'caustin1978' in course '037795'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '037992'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '040339'

-----<hr>

error: skipping unknown user username 'wefurd' in course '040339'

error: skipping unknown user username 'cakes345' in course '040339'

error: skipping unknown user username 'TejaiAcobs' in course '040339'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '037624'

-----<hr>

error: skipping unknown user username 'reynad' in course '037624'

error: skipping unknown user username 'haasm' in course '037624'

error: skipping unknown user username 'sbrindley' in course '037624'

error: skipping unknown user username 'lschave' in course '037624'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '037645'

-----<hr>

error: skipping unknown user username 'sbrindley' in course '037645'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '037668'

-----<hr>

error: skipping unknown user username 'sbrindley' in course '037668'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '036771'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '037697'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '037665'

-----<hr>

error: skipping unknown user username 'sbrindley' in course '037665'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '043481'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '037614'

-----<hr>

error: skipping unknown user username 'goodteacher' in course '037614'

error: skipping unknown user username 'hendersonb' in course '037614'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '043833'

-----<hr>

error: skipping unknown user username 'adrianknight' in course '043833'

error: skipping unknown user username 'eawalker17' in course '043833'

error: skipping unknown user username 'Dcearnal' in course '043833'

error: skipping unknown user username 'joepino' in course '043833'

error: skipping unknown user username 'HildaHayati' in course '043833'

error: skipping unknown user username 'lisadawnrichardson' in course '043833'

error: skipping unknown user username 'cburton' in course '043833'

error: skipping unknown user username 'PLBrown' in course '043833'

error: skipping unknown user username 'gholte' in course '043833'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '039693'

-----<hr>

error: skipping unknown user username 'Samiakhafagy' in course '039693'

error: skipping unknown user username 'david0527' in course '039693'

error: skipping unknown user username 'tmjones' in course '039693'

error: skipping unknown user username 'mbrannan28' in course '039693'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '043606'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '043821'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '040645'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '040057'

-----<hr>

error: skipping unknown user username 'emilyfoster' in course '040057'

error: skipping unknown user username 'KAABJO' in course '040057'

error: skipping unknown user username 'cherieager' in course '040057'

error: skipping unknown user username 'hensonn' in course '040057'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '040029'

-----<hr>

error: skipping unknown user username 'perkinsy' in course '040029'

error: skipping unknown user username 'wendyhammoud2' in course '040029'

error: skipping unknown user username 'angelacaldwell' in course '040029'

error: skipping unknown user username 'merickson97' in course '040029'

error: skipping unknown user username 'gipsont' in course '040029'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '043388'

-----<hr>

error: skipping unknown user username 'Shepparddebbie' in course '043388'

error: skipping unknown user username 'bbarnes' in course '043388'

error: skipping unknown user username 'jaynalaprade' in course '043388'

error: skipping unknown user username 'Gilmerj' in course '043388'

error: skipping unknown user username 'fosterv' in course '043388'

error: skipping unknown user username 'brownk' in course '043388'

error: skipping unknown user username 'whiteymarc' in course '043388'

-----<hr>

(odbc): SELECT userName

FROM Enrollment_DL

WHERE Sess_Num = '037604'

-----<hr>

error: skipping unknown user username 'wtravis' in course '037604'

error: skipping unknown user username 'kristih' in course '037604'

error: skipping unknown user username 'Edney' in course '037604'

error: skipping unknown user username 'montgomeryjl' in course '037604'

error: skipping unknown user username 'debraharber' in course '037604'

error: skipping unknown user username 'ginnycaldwell' in course '037604'

error: skipping unknown user username 'KRISTIEJOHNSON1' in course '037604'

error: skipping unknown user username 'MJulian' in course '037604'

error: skipping unknown user username 'skbrown' in course '037604'

...user enrolment synchronisation finished.

Average of ratings: -

Re: error: skipping unknown user on External Database enrolment

by Jonathan Taylor - Wednesday, 18 June 2014, 2:02 AM

Any progress on this? I just started seeing the same thing.

Average of ratings: -

Re: error: skipping unknown user on External Database enrolment

by Jonathan Taylor - Wednesday, 18 June 2014, 2:52 AM

Doh moment,

New users hadn't been created in moodle. This solved my issue. Not sure if yours is the same.

Average of ratings: -

Re: error: skipping unknown user on External Database enrolment

by Mathew Gancarz - Wednesday, 9 July 2014, 6:00 AM

We started having the same error being displayed when we upgraded to Moodle 2.5.x, from 2.2. It does look like it is reported for all of the users that are not in Moodle, which in our case is because they have not logged in yet.

Anyone know if there is a way to suppress this message, or possibly have the account created for the user without them having to log in?

Looking at the difference in /enrol/database/lib.php, it looks like it's because we are running it with --verbose for error reporting and https://tracker.moodle.org/browse/MDL-37293 fixed things so that --verbose reports user enroll errors too.

Given that though, I would still prefer to have the user account created ahead of time. This will let us set groups for the course before the users log in.

Average of ratings: -

Re: error: skipping unknown user on External Database enrolment

by Mathew Gancarz - Wednesday, 9 July 2014, 6:26 AM

Nevermind, found it in the docs: http://docs.moodle.org/25/en/External_database_authentication#Automatic_Synchronisation

Looks like as of 2.3.x, this Automatic Sync option showed up in the docs, to allow me to create users before login.

Average of ratings: -

Enrolment

error: skipping unknown user on External Database enrolment

error: skipping unknown user on External Database enrolment

Re: error: skipping unknown user on External Database enrolment

Re: error: skipping unknown user on External Database enrolment

Re: error: skipping unknown user on External Database enrolment

Re: error: skipping unknown user on External Database enrolment

Empowering educators to improve our world

Moodle

Support

Get Involved

Contributions

Downloads

Tracker

Development

Empowering educators to improve our world