pawohl

#!/bin/bash

set -euo pipefail
IFS=$'\n\t'

# parameters
USERNAME="maybe empty"
PASSWORD="fritzbox-password"
CERTPATH="path to cert eg  /etc/letsencrypt/live/domain.tld/"
CERTPASSWORD="cert password if needed"

pawohl

ILIAS has a great UI installer and database updater. When it fails, the error is not only presented in every detail, including an interactive stack trace, it also provides handy links for searing the web for descriptions of instances of the same error. Everything is presented in a modern eye-candy fashion. Awesome!

Running database update #4847, we experienced an error:

Integrity constraint violation: 1062 Duplicate entry '90262-908261' for key 'PRIMARY'

Wooopsie. There were duplicate entries in our table page_question - we identified the affected table by returning to the installer in showing the next update step. No problem, right? Just get rid of one of those 90262-908261 entries. To our surprise, there was no entry page_id=90262 and question_id=908261, nor vice versa, nor mixed with null values. So we fired the following query:

pawohl

Upgrading Opencast 2.2 to HTTPS

Disclaimer: We are using the opencast-docker images: admin, worker and presentation

Note: This value will be written to all generated mediapackages and thus cannot be changed easily for already processed media. At least not without an extra amount of work involving modifications to the database. That is why you

pawohl

#!/bin/ash
#
# Set up HTTPS in OpenCast
# ~~~~~~~~~~~~~~~~~~~~~~~~

set -e

dir_before="$PWD"

# Apply default values to environment variables

pawohl

// ES 5.1, ES 6
'use strict';

function Node( index ) {
	this.index = index;
	this.children = [];
	this.parents = [];
}
Node.prototype.index = undefined;
Node.prototype.parents = [];