DuckCorp » DuckCorp Infrastructure

• on Toushirou, update /etc/redmine/{md,dc}/database.yml (within redmine lxc container)
• convert the redmine tables of redmine_dc and redmine_md databases from utf8 to utf8mb4

📣 I used the following script (based on this script) on both redmine_dc and redmine_md:

#!/bin/bash

set -o errexit -o pipefail

DB="$1" 
CHARSET="$2" 
COLL="$3" 

[ -n "$DB" ] || exit 1
[ -n "$CHARSET" ] || CHARSET="utf8mb4" 
[ -n "$COLL" ] || COLL="utf8mb4_unicode_520_ci" 

set -o nounset

echo $DB
echo "ALTER DATABASE \`$DB\` CHARACTER SET = $CHARSET COLLATE = $COLL;" | mysql

echo "USE \`$DB\`; SHOW TABLES;" | mysql -s | (
    while read TABLE; do
        echo $DB.$TABLE
        echo "ALTER TABLE \`$TABLE\` ROW_FORMAT=DYNAMIC, CONVERT TO CHARACTER SET $CHARSET COLLATE $COLL;" | mysql $DB
    done
)

echo "USE \`$DB\`; SHOW TABLES;" | mysql -s | (
    while read TABLE; do
        echo $DB.$TABLE
        echo "CHECK TABLE \`$TABLE\` EXTENDED;" | mysql $DB
    done
)

Then I updated /etc/redmine/{dc,md}/database.yml within the redmine LXC controller hosted on Toushirou in order to use utf8mb4 instead utf8 and I restarted the apache2.service (within the LXC container) in order to take in account this update.

It works 🎉
🎈🎈🎈🎈🎈🎈🎈🎈