Enrolment

error: skipping unknown user on External Database enrolment

 
 
Picture of Ben Warriner
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>

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

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

-----<hr>

(odbc): SELECT  userName

                  FROM Enrollment_DL

                 WHERE Sess_Num = '032973'

-----<hr>

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

-----<hr>

(odbc): SELECT  userName

                  FROM Enrollment_DL

                 WHERE Sess_Num = '031966'

-----<hr>

-----<hr>

(odbc): SELECT  userName

                  FROM Enrollment_DL

                 WHERE Sess_Num = '031975'

-----<hr>

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

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

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

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

-----<hr>

(odbc): SELECT  userName

                  FROM Enrollment_DL

                 WHERE Sess_Num = '037697'

-----<hr>

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

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

-----<hr>

(odbc): SELECT  userName

                  FROM Enrollment_DL

                 WHERE Sess_Num = '043821'

-----<hr>

-----<hr>

(odbc): SELECT  userName

                  FROM Enrollment_DL

                WHERE Sess_Num = '040645'

-----<hr>

-----<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: -
Picture of Jonathan Taylor
Re: error: skipping unknown user on External Database enrolment
 

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

 
Average of ratings: -
Picture of Jonathan Taylor
Re: error: skipping unknown user on External Database enrolment
 

Doh moment,


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

 
Average of ratings: -
Picture of Mathew Gancarz
Re: error: skipping unknown user on External Database enrolment
Group Particularly helpful Moodlers

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: -
Picture of Mathew Gancarz
Re: error: skipping unknown user on External Database enrolment
Group Particularly helpful Moodlers

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