See for database schema info.

Site Administrators

Site administrators are tracked differently in the DB from other roles.  The list of Site Administrators is found in the table mdl_config in the record with name=siteadmins.  That is, to get the list of site administrators,

  • SELECT * FROM mdl_config WHERE name='siteadmins';

CAS Settings

  • CAS Server: OR
  • CAS Port: 443
  • Multi-authentication: On (value=1)

To see CAS Configuration Settings in the Database

  • select * from mdl_config_plugins where plugin like '%cas%'