https://projects.duckcorp.org/https://projects.duckcorp.org/favicon.ico?16699090422022-03-12T04:05:44ZDuckCorp ProjectsDuckCorp Infrastructure - Bug #754: Redmine: unable to use some unicode unicode character in commenthttps://projects.duckcorp.org/issues/754?journal_id=23832022-03-12T04:05:44ZPierre-Louis Bonicolipierre-louis.bonicoli@ir5.eu
<ul></ul>According to <a class="external" href="http://blog.andriylesyuk.com/4-byte-utf-8-problem-in-redmine-and-how-to-fix-it/">http://blog.andriylesyuk.com/4-byte-utf-8-problem-in-redmine-and-how-to-fix-it/</a> / <a class="external" href="https://www.redmine.org/issues/31921">https://www.redmine.org/issues/31921</a>, these steps are required:
<ul>
<li>on Toushirou, update <code>/etc/redmine/{md,dc}/database.yml</code> (within <code>redmine</code> lxc container)</li>
<li>convert the redmine tables of <code>redmine_dc</code> and <code>redmine_md</code> databases from <code>utf8</code> to <code>utf8mb4</code></li>
</ul> DuckCorp Infrastructure - Bug #754: Redmine: unable to use some unicode unicode character in commenthttps://projects.duckcorp.org/issues/754?journal_id=23932022-03-13T11:13:57ZPierre-Louis Bonicolipierre-louis.bonicoli@ir5.eu
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>In Progress</i></li><li><strong>Assignee</strong> set to <i>Pierre-Louis Bonicoli</i></li></ul> DuckCorp Infrastructure - Bug #754: Redmine: unable to use some unicode unicode character in commenthttps://projects.duckcorp.org/issues/754?journal_id=23942022-03-14T03:05:26ZPierre-Louis Bonicolipierre-louis.bonicoli@ir5.eu
<ul></ul><p>📣 I used the following script (based on <a href="http://blog.andriylesyuk.com/4-byte-utf-8-problem-in-redmine-and-how-to-fix-it/#comment-686702" class="external">this script</a>) on both <code>redmine_dc</code> and <code>redmine_md</code>:<br /><pre>
#!/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
)
</pre></p>
<p>Then I updated <code>/etc/redmine/{dc,md}/database.yml</code> within the redmine LXC controller hosted on Toushirou in order to use <code>utf8mb4</code> instead <code>utf8</code> and I restarted the apache2.service (within the LXC container) in order to take in account this update.</p>
<p>It works 🎉<br />🎈🎈🎈🎈🎈🎈🎈🎈</p> DuckCorp Infrastructure - Bug #754: Redmine: unable to use some unicode unicode character in commenthttps://projects.duckcorp.org/issues/754?journal_id=23952022-03-14T03:05:50ZPierre-Louis Bonicolipierre-louis.bonicoli@ir5.eu
<ul><li><strong>Status</strong> changed from <i>In Progress</i> to <i>Resolved</i></li><li><strong>% Done</strong> changed from <i>0</i> to <i>100</i></li></ul>