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

Tue Jul 8 16:44:53 EDT 2014

Hi Hon-Kie,

> 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