[LON-CAPA-admin] LON-CAPA version 2.11.0

Wed Jul 16 13:31:09 EDT 2014

Hi Stuart,

I think I got this problem solved by cleaning up the entries in the
nohist_domainroles.db. Tested it on the development server and now the
move_construction moves the usernames to the correct domain. Thanks for
your help -hk

> > Thanks for following this up. The failure was on the development machine.
>
> You will encounter the same issue when you update your production
> server, if nohist_domainroles.db on the production server is the same
> as on the development server (I assume you rsync files from one to the
> other).
>
> A quick way to check for this issue, via the web GUI on the production
> server, is to log-in and select the Domain Coordinator role in the fsu
> domain, and use:
>
> Main Menu -> "Create users or modify the roles and privileges of
> users" -> "Manage Users", and select "Author" in the "Role" dropdown
> list, then click "Display List of Users"
>
> to see if ADAPT, HighSchoolBioLib, PhysAuthors, and PhysicalScienceLib
> are indeed listed (erroneously) as authors in the fsu domain.
>
> Alternatively, via the command line you could use:
>
> /home/httpd/perl/debug/dump_db.pl -u
> /home/httpd/lonUsers/fsu/nohist_domainroles.db |grep ^au:
>
> > Looking at your check list of looking up for usernames, all the usernames
> > assigned to fsu do not exist on mysql entries (step (e)) on the
> development
> > machine but they all show up on the production machine.
>
> The fact that the names exist in the allusers table on the production
> server is not going to help, if nohist_domainroles.db for the fsu
> domain contains bad data, because if a domain has been found at step
> (a) from that GDBM file, then the script will not use (d) or (e) to
> determine domain.
>
> On a separate note, if you wish to use your dev server as an upgrade
> testbed then I recommend including entries for the fsuK12 domain in
> both /home/httpd/lonTabs/hosts.tab and /home/httpd/lonTabs/domain.tab
> (just make sure you have the dev server hostname in place of the
> production server hostname).
>
> Currently, when cron runs searchcat.pl (if you have that enabled), the
> allusers table will only be populated from /home/httpd/lonUsers/fsu,
> because lonnet::machine_domains() will only list fsu, given the
> current domains/hosts it knows about.
>
>
> Stuart Raeburn
> LON-CAPA Academic Consortium
>
> Quoting "H. K. Ng" <hkng at fsu.edu>:
>
> > Hi Stuart,
> >
> > Thanks for following this up. The failure was on the development machine.
> > Looking at your check list of looking up for usernames, all the usernames
> > assigned to fsu do not exist on mysql entries (step (e)) on the
> development
> > machine but they all show up on the production machine. So your script
> may
> > be fine the way it is. My plan is to upgrade (second week of Aug) after
> the
> > summer term ends.
> >
> > Regards,
> > -hk
> >
> >
> >
> > On Mon, Jul 7, 2014 at 1:40 PM, Stuart Raeburn <raeburn at msu.edu> wrote:
> >
> >> Hi Hon-Kie,
> >>
> >> > Only one of them has published resources - the others do not.
> >>
> >> Whether or not an author has published resources is not especially
> >> relevant, since we want to be able to move authoring spaces for
> >> authors to the correct domain on a multi-domain server, regardless of
> >> whether they have published anything.
> >>
> >> The issue here is that there is incorrect data in the GDBM file:
> >> /home/httpd/lonUsers/fsu/nohist_domainroles.db
> >> on your server.
> >>
> >> That file contains fsu author role entries for the following fsuK12
> >> domain users:
> >>
> >> ADAPT
> >> HighSchoolBioLib
> >> PhysAuthors
> >> PhysicalScienceLib
> >>
> >> which should not be there.
> >>
> >> There are no author role entries for those same users in the
> >> corresponding GDBM file for the fsuK12 domain:
> >>
> >> /home/httpd/lonUsers/fsuK12/nohist_domainroles.db
> >>
> >> (which actually makes sense, based on role creation and log-in history
> >> -- see below).
> >>
> >> Anyway, as a consequence of this bizarre situation, the interactive
> >> move_construction_spaces.pl script determined these four users were
> >> solely fsu authors, and as a result did not prompt you to choose a
> >> domain.
> >>
> >> The role start times recorded in fsu/nohist_domainroles.db for those
> >> four users are strange namely:
> >>
> >> Thu Jun 5 08:04:11 am 2008 (EDT)
> >> Thu Jun 5 08:22:13 am 2008 (EDT)
> >> Thu Jun 5 08:28:57 am 2008 (EDT)
> >> Thu Jun 5 08:30:46 am 2008 (EDT)
> >>
> >> whereas the expected values would be:
> >>
> >> Wed Mar 17 04:29:38 pm 2004 (EST)
> >> Wed Jun  9 04:23:12 pm 2004 (EDT)
> >> Thu Oct 13 02:50:04 pm 2005 (EDT)
> >> Tue Dec 21 02:08:36 pm 2004 (EST)
> >>
> >> if these corresponded to the start times for those author roles in the
> >> fsuK12 domain.
> >>
> >> The solution here is to clean up the nohist_domainroles.db files for
> >> the fsu domain before running the move_construction_spaces.pl script.
> >> I will contact you off-list, to provide you with a script to do that.
> >>
> >> To my knowledge there are four multi-domain servers in the LON-CAPA
> >> network:
> >> loncapa10.fsu.edu, educog.com, capa4.phy.ohiou.edu, and loncapa.mit.edu
> .
> >>
> >> I tested authoring space migration on educog.com some months ago and
> >> saw no issues in moving spaces for 702 authors in 140 domains, and
> >> Mark Lucas reported authoring space migration worked OK on capa4 a few
> >> weeks ago.
> >>
> >> Checking nohist_domainroles.db files on educog.com I see no
> >> inconsistencies of the type seen for the fsuK12 domain.
> >>
> >> Use of nohist_domainroles.db was included for the first time in
> >> LON-CAPA rev. 2.1.0 (December 2005). Population of that GDBM file
> >> occurs at role assignment, and also when a user logs-in.
> >>
> >> According to the activity.log data for these four users, it is not
> >> unsurprising that there are no entries in
> >> /home/httpd/lonUsers/fsuK12/nohist_domainroles.db
> >> given that the last log-ins are recorded as follows:
> >>
> >> Thu Mar 18 07:31:10 2004
> >> Wed Jun  9 16:24:18 2004
> >> Thu Oct 13 14:50:26 2005
> >> Thu Feb 10 16:09:07 2005
> >>
> >> What is odd, however, are that the datestamps for the spurious entries
> >> in /home/httpd/lonUsers/fsu/nohist_domainroles.db are all from June 5,
> >> 2008.
> >> I do wonder what was going on that day (I would expect you would have
> >> been running LON-CAPA 2.6.3 at that time).
> >>
> >> For those who are interested the logic in move_construction_spaces.pl
> >> is as follows:
> >>
> >> (a) author role information is retrieved from the
> >> nohist_domainroles.db GDBM file in /home/httpd/lonUsers/<domain> for
> >> each domain hosted on that library server.
> >>
> >> (b) If the same username is used for an author from more than one
> >> domain then you are prompted to either skip that username, or choose
> >> from one of the domains.
> >>
> >> (c) If there is a directory: /home/<username>/public_html (the
> >> pre-2.11 location of Authoring Spaces), and <username> was not found
> >> in nohist_domainroles.db for any domains, then, at that stage a check
> >> is made for publications in /home/httpd/html/res to determine the
> >> user's domain.
> >>
> >> (d) If we still don't know the domain, then roles.db files for
> >> <username> are checked for all domains hosted on the server, to look
> >> for au roles for that user.
> >>
> >> (e) If we still don't know the domain, then a query (username =
> >> '<username>') is made to the allusers MySQL table.
> >>
> >> (f) If we still don't know the domain, then a message will be
> >> displayed: "WARNING: <username> has no domain" and you will be
> >> prompted to skip, or enter a domain.
> >>
> >>
> >> Stuart Raeburn
> >> LON-CAPA Academic Consortium
> >>
> >>
> >> Quoting "H. K. Ng" <hkng at fsu.edu>:
> >>
> >> > Only one of them has published resources - the others do not.
> >> >
> >> > I did an undo, and rerun the script. It didn't prompt me to move the
> >> ADAPT
> >> > directory to fsuK12 even though there are published resources under
> >> > res/fsuK12
> >> >
> >> > rerun move_construction_spaces.pl
> >> > ...
> >> > Moved '/home/ADAPT/public_html' to '/home/httpd/html/priv/fsu/ADAPT'.
> >> > Removed empty directory: '/home/ADAPT/'
> >> >
> >> >
> >> > ls -l /home/httpd/html/res/fsuK12/
> >> > total 20
> >> > drwxr-xr-x 10 www www 4096 Jul  7  2004 ADAPT
> >> > drwxr-xr-x 15 www www 4096 May 28 13:51 AlgebraILib
> >> > drwxr-x---  5 www www 4096 Aug 15  2011 fsuK12-domainconfig
> >> > drwxr-xr-x 24 www www 4096 Sep 23  2010 HighSchoolPhysicsLib
> >> > drwxr-xr-x 20 www www 4096 Aug  9  2005 middleScienceLib
> >> >
> >> >
> >> > Thanks,
> >> > -hk
> >> >
> >> >
> >> > On Tue, Jul 1, 2014 at 9:24 AM, Gerd Kortemeyer <korte at lite.msu.edu>
> >> wrote:
> >> >
> >> >> Hi,
> >> >>
> >> >> On Jul 1, 2014, at 9:17 AM, H. K. Ng <hkng at fsu.edu> wrote:
> >> >>
> >> >> > I am pretty sure it didn?t prompt me - there were a few prompts for
> >> some
> >> >> other construction spaces but not these ones.
> >> >>
> >> >> That is slightly disturbing. Do you find the respective resources
> spaces
> >> >> under /res/fsuK12/(username) - or did these people maybe never
> publish?
> >> >>
> >> >> - Gerd.
> >> >> _______________________________________________
> >> >> LON-CAPA-admin mailing list
> >> >> LON-CAPA-admin at mail.lon-capa.org
> >> >> http://mail.lon-capa.org/mailman/listinfo/lon-capa-admin
> >>
> >> _______________________________________________
> >> LON-CAPA-admin mailing list
> >> LON-CAPA-admin at mail.lon-capa.org
> >> http://mail.lon-capa.org/mailman/listinfo/lon-capa-admin
>
> _______________________________________________
> LON-CAPA-admin mailing list
> LON-CAPA-admin at mail.lon-capa.org
> http://mail.lon-capa.org/mailman/listinfo/lon-capa-admin
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.lon-capa.org/pipermail/lon-capa-admin/attachments/20140716/012d80ed/attachment.html>