==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.6 MARIADB edition.
- Linux/BSD distribution name and version: Ubuntu 16.04.2
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MariaDB
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? No
- Related log if you're reporting an issue:

Mar 28 09:07:17 sogod [2343]: [ERROR] <0x0x562d24ab5780[SOGoSQLUserProfile]> could not run SQL 'SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'anonymous'': <MySQL4Exception: 0x562d24a5e610> NAME:ExecutionFailed REASON:Table 'sogo.sogo_user_profile' doesn't exist 

====

Hi,

I have the problem that SOGo does not create all of it's tables. Only the following tables are created:
sogo_acl
sogo_alarms_folder
sogo_acl_c_folder_id_idx
sogo_acl_c_uid_idx
users

I did restart the server after iRedMail installation was complete and I followed the official installation manual http://www.iredmail.org/docs/install.ir … untu.html.

I do not know if this is important, but I am using iRedMail inside a LXC container.

For me this problem is totally reproducible. I can create as many containers as I want and work through the installation guide. Every time the same problem.

Update 2017-03-28 12:03:
On Ubuntu 14.04 it works without problems. Looks like a problem with Ubuntu 16.04. Any idea what can cause this problem on Ubuntu 16.04?

Update 2017-03-28 14:26:
I found the problem. In Ubuntu 16.04 MariaDB uses utf8mb4 as it's default character set which causes problems when SOGo tries to create it's tables. I found two possible fixes.
The first one is to change MariaDB to use utf8 as the default character set.
The second one is to use the mysql-utf8mb4.sql script included in SOGo source (https://github.com/inverse-inc/sogo/blo … tf8mb4.sql) to create the tables.