onCourse Setup

If you install onCourse yourself, rather than using the managed service from ish, you’ll need to configure the environment into which you install onCourse. You will need:

• A unix, linux, OSX or Windows operating system
• A database. No database specific features are used, but onCourse is regularly tested with MariaDB, MySQL, and Amazon Aurora RDS. Others like postgresql or SQL Server might also work, but aren’t regularly tested.
• An outbound mail server (smtp)
• Java 11 or higher

Installing dependencies

On MacOS, use homebrew to install many of the requirements.

1. Install homebrew.
2. Install MariaDB 10.4. brew install [email protected]
3. Install Java. brew tap homebrew/cask-versions; brew install temurin11

Now set up your database.

1. brew services start mariadb to start the server
2. mysql_secure_installation and configure the root account.
3. mysql -uroot -p to log in to the SQL console and execute some commands to create a user. Use a proper secure password instead of 'password123'.

MySQL

CREATE USER 'onCourse' IDENTIFIED BY 'password123';
GRANT ALL PRIVILEGES ON _ . _ TO 'onCourse';
FLUSH PRIVILEGES;

CREATE DATABASE onCourse;
exit;