[LON-CAPA-admin] Need a way to change all student IDs in our database

Jeffrey Wilson jwilson at sc.edu
Thu Jul 25 13:28:46 EDT 2013


Hi Stuart,

Just some more info and more questions.

I have looked at some individual user directories to see where the 
offending IDs might appear, for example in 
/home/httpd/lonUsers/sc/w/i/l/wilsonteststudent I find:

activity.log
email_status.db
email_status.db.lock
email_status.db.old
email_status.hist
environment.db
environment.db.lock
environment.db.old
environment.hist
nohist_accesscount.db
nohist_accesscount.db.lock
nohist_accesscount.db.old
nohist_calculatedsheets_sc_4m8323115285b4c74sca2.db
nohist_calculatedsheets_sc_4m8323115285b4c74sca2.db.lock
nohist_calculatedsheets_sc_4m8323115285b4c74sca2.db.old
nohist_resevaldata.db
nohist_resevaldata.db.lock
nohist_resevaldata.db.old
nohist_sc_4m8323115285b4c74sca2_discuss.db
nohist_sc_4m8323115285b4c74sca2_discuss.db.lock
nohist_sc_4m8323115285b4c74sca2_discuss.db.old
passwd
roles.db
roles.db.lock
roles.db.old
roles.hist
sc_4m8323115285b4c74sca2.db
sc_4m8323115285b4c74sca2.db.lock
sc_4m8323115285b4c74sca2.db.old
sc_4m8323115285b4c74sca2.hist

I can see ID information in the environment files.  I don't see IDs 
anywhere else.

Can I make changes to these files (most notably the .db files) without 
crashing LonCapa?  What would be the best way to do that?

Thanks,
Jeff






More information about the LON-CAPA-admin mailing list