Problem
m23 App Shows ERROR:Table ‘m23.i18n’ doesn’t exist when trying to login the first time.
Un-installing the app and re-installing (either through UMC or univention-app) does not help.
Solution
Note: The following will nuke the m23 database. In case you might have used m23 before the steps should not be applied.
Step 1
Make sure the app is uninstalled (UMC or univention-app remove m23)
Step 2
Verify the databases still exist even though the app is uninstalled:
ls -l /var/lib/mysql | grep m23
drwx------ 2 mysql mysql 4096 Mär 25 16:52 m23
drwx------ 2 mysql mysql 4096 Aug 1 2018 m23captured
Step 3
Login to MySQL/ MariaDB and drop the databases:
root@master:~# mysql -h localhost -u root -p`cat /etc/mysql.secret`
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 7
Server version: 10.1.37-MariaDB-0+deb9u1 Debian 9.6
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> drop database m23;
Query OK, 0 rows affected (0.09 sec)
MariaDB [(none)]> drop database m23captured;
Query OK, 0 rows affected (0.09 sec)
MariaDB [(none)]> exit;
Bye
Step 4
Install the app again through your preferred way.
Login should work now.