Submitty logo

The Submitty Homework Submission System currently supports only a PostgreSQL Database.

  1. Set up the PostgreSQL server if you do not already have one you plan to use.

  2. Make sure that the postgresql user is in the shadow group to use PAM authentication:

    adduser postgres shadow 

    and then restart postgres

    service postgresql restart
  3. Edit the postgres configuration in /etc/postgresql/9.3/main/pg_hba.conf.

    Under “Put your actual configuration here” to allow connections from the local network:

    hostssl	all	all	pam
    host		all	all	pam
  4. The Course Creation page details how to create a new database for each course for each term and populate the database with the necessary tables and initial data.

Entity-Relation Diagram of the database

Diagram generated using: DataGrip