Some useful scripts for maintaining a Sakai installation

From 2014 to 2018, I co-maintained a Sakai installation. We migrated from 2.9.3 to 10.4 to 11.3, all with custom patches.

These scripts were written and tested on Linux; they are expected to work on other Unix variants as well. Most take -h as a help option.

Scripts for general maintenance tasks:

• sakai-files-dedup - deduplicate uploaded files on disk
• ln-r - homegrown dedup script, like fdupes but slower
• catalina-out-select - selectively print Tomcat catalina.out entries
• restart-sakai - a trivial utility to restart a Tomcat instance
• upgrade-sakai - a trivial utility to upgrade the Sakai software and restart its Tomcat instance

Scripts for reporting information from Sakai's (MySQL) database:

• sakai-sessions - list Sakai sessions, or any other info in the database (ought to be refactored)
• sakai-resource-files - list uploaded files stored on disk
• sakai-resource-file-properties - list uploaded files with more properties

Scripts for reporting on / modifying a Sakai instance using its SOAP API (the ones marked (*) depend on Sakai patches developed for us by EDIA):

• test-connection.pl - can we connect to the Sakai SOAP API?
• sakai.pl - list users. sites, site memberships, etc.
• sakai-list-courses.pl - list sites (courses)
• sakai-list-assessments.pl - list assessments (*)
• sakai-list-assessments-parallel.pl - (a variant) (*)
• sakai-copy-assessments.pl - copy assessments from one site to another (*)
• sakai-list-lessons-pages.pl - list Lessons pages (*)
• sync-roles-in-sites.pl - make sure users have the same roles in different sites

See also my more general collection of scripts.

Author: Reinier Post, TU Eindhoven. Use and redistribution permitted, but entirely at your own responsibility. Publication/distribution of modified versions permitted provided that any such modifications are communicated to me first.