[LON-CAPA-admin] [lon-capa.org #80516] Missing Grades for Several Courses

Tue Mar 24 09:33:41 EDT 2015

Stuart:
I just logged in and I had one of my faculty members log in and we can see
all grades and student data again using MSU's access server.   The faculty
member gave a huge sigh of relief to be able view the data.

As a note, we had kernel patch updates early Friday morning (2am).  We're
thinking that may have something to do with this.  I cannot confirm that the
servers were brought back up in the proper order.  Not sure if that would
hold any bearing, but I thought it is worth mentioning...

With this information, how should we proceed to allow our access servers to
be able to read the grade data?

Thanks!

JaBari A. Scott
Applications Analyst, Learning Systems
Technology Services
Virginia Commonwealth University
jascott at vcu.edu | (804) 828-7310

Don't be a phishing victim - VCU and other reputable organizations will
never use e-mail to request that you reply with your password, Social
Security Number, or confidential personal information. For more details
visit http://go.vcu.edu/phishing or http://phishing.vcu.edu.

-----Original Message-----
From: Stuart Raeburn [mailto:helpdesk at lon-capa.org]
Sent: Tuesday, March 24, 2015 9:08 AM
To: jascott at vcu.edu
Subject: [lon-capa.org #80516] Missing Grades for Several Courses

Hi,

> I just checked a Fall 2014 course and those grades are missing as
> well.

When you say you checked a Fall 2014 course, what screens/roles are you
using when you do this? What happens if you log-in to a LON-CAPA server in
another domain, e.g., https://s10.lite.msu.edu/adm/login?domain=vcu
and attempt to display grade data in the same VCU course?

Stuart Raeburn
LON-CAPA Academic Consortium

> [jascott at vcu.edu - Tue Mar 24 08:55:56 2015]:
>
> Good Morning Stuart:
> This appears to be affecting most, if not all, courses in LON-CAPA for
this
> semester.  I just checked a Fall 2014 course and those grades are
missing as
> well.   Looking into all student folders for all courses seems scarily
> daunting, if not impossible.  However, you speak of the MySQL
> database, of which I have never tried to connect.  Is it possible to
> use an external program (e.g. MySQL Workbench) to access that data, or
> do I have to go through the filesystem?
>
> In short, this appears to affect all grades, for students, for all
courses.
> I don't know to feel better or worse about this assertion...
>
>
> JaBari A. Scott
> Applications Analyst, Learning Systems Technology Services Virginia
> Commonwealth University jascott at vcu.edu | (804) 828-7310
>
>
>
>
> Don't be a phishing victim - VCU and other reputable organizations will
> never use e-mail to request that you reply with your password, Social
> Security Number, or confidential personal information. For more details
> visit http://go.vcu.edu/phishing or http://phishing.vcu.edu.
>
> -----Original Message-----
> From: Stuart Raeburn [mailto:helpdesk at lon-capa.org]
> Sent: Tuesday, March 24, 2015 8:42 AM
> To: jascott at vcu.edu
> Subject: [lon-capa.org #80516] Missing Grades for Several Courses
>
> Hi,
>
> > Several courses reported over the weekend that all grades have
> > disappeared from the course.
>
> What is the extent of this issue?  Is it all grades in a particular course
> for all students for all assignments, or is it a more specific issue
within
> a course.
>
> Submission data are stored in individual GDBM files -- one for each course
> for each student, in the student's data directory, e.g, within
>
> /home/httpd/lonUsers/vcu/j/a/s/jascott
>
> for username: jascott
>
> In addition, temporary tables are created in the loncapa database in MySQL
> to speed up display of student performance data.  Those tables have md5
> hashed names, beginning md5_
>
> A student's own grades can cease to be shown to the student if the
> particular folder is hidden, but then the folder would not be listed
in the
> Course Contents page, so I am assuming that would have been reported as
> well, if that were the case.
>
>
> Stuart Raeburn
> LON-CAPA Academic Consortium
>
> > [jascott at vcu.edu - Tue Mar 24 08:03:41 2015]:
> >
> > Good Morning:
> >
> > I have a high-priority situation with our LON-CAPA installation.
> > Several courses reported over the weekend that all grades have
> > disappeared
> from the
> > course.  Unfortunately, the time indication I have is that this
> > occurred between Wednesday afternoon and Friday afternoon, based on
> > reports thus far.  Nothing else seems wrong with the system and we
> > haven’t had any performance issues reported.  Any advice that can be
> > given would be
> greatly
> > appreciated.
> >
> >
> >
> > Thanks!
> >
> >
> >
> >
> >
> > JaBari A. Scott
> >
> > Applications Analyst, Learning Systems
> >
> > Technology Services
> >
> > Virginia Commonwealth University
> >
> > jascott at vcu.edu | (804) 828-7310
> >
> >
> >
> > [image: http://goo.gl/MY7zmN] [image: http://goo.gl/jJKycI]
> >
> >
> >
> >
> >
> > *Don't be a phishing victim - VCU and other reputable organizations
> > will never use e-mail to request that you reply with your password,
> > Social Security Number, or confidential personal information. For more
> > details visit **http://go.vcu.edu/phishing
> > <http://go.vcu.edu/phishing> or http://phishing.vcu.edu
> > <http://phishing.vcu.edu/>*.