Authentication

See for database schema info. http://docs.moodle.org/dev/Database_schema_introduction

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: cas.tamu.edu OR cas-dev.tamu.edu
  • 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%'