Comment 3 for bug 1806005

Trying with mysql (preferred on Ubuntu) instead of mariadb.

Dependencies:
Depends: kopano-libs (>= 8.6.1), libc6 (>= 2.14), libgcc1 (>= 1:3.0), libgsoap-2.8.60, libicu63 (>= 63.1-1~), libldap-2.4-2 (>= 2.4.7), libssl1.1 (>= 1.1.0), libstdc++6 (>= 5.2), debconf (>= 0.5) | debconf-2.0, dbconfig-common, kopano-common (= 8.6.5-1ubuntu2), lsb-base (>= 3.0-6), mariadb-client | default-mysql-client | virtual-mysql-client
Recommends: mariadb-server | default-mysql-server

Lets install these upfront:
$ sudo apt install default-mysql-server default-mysql-client

Then the install works:
After that the kopano-server install is "only":
The following NEW packages will be installed:
  dbconfig-common kopano-common kopano-libs kopano-server libgsasl7 libgsoap-2.8.60 libical3 libicu63 libmysqlclient20 libntlm0 libpython2.7 libpython2.7-minimal libpython2.7-stdlib libvmime1
Unpacking kopano-server (8.6.5-1ubuntu2) ...
Setting up kopano-common (8.6.5-1ubuntu2) ...
Adding group `kopano' (GID 117) ...
Done.
Setting up libicu63:amd64 (63.1-4) ...
Setting up libgsoap-2.8.60:amd64 (2.8.60-2build1) ...
Setting up libntlm0:amd64 (1.5-1) ...
Processing triggers for libc-bin (2.28-0ubuntu1) ...
Processing triggers for systemd (239-7ubuntu10) ...
Processing triggers for man-db (2.8.4-2build1) ...
Setting up libical3:amd64 (3.0.4-0ubuntu4) ...
Setting up libmysqlclient20:amd64 (5.7.24-2) ...
Setting up libpython2.7-minimal:amd64 (2.7.15-5) ...
Setting up dbconfig-common (2.0.10) ...
Creating config file /etc/dbconfig-common/config with new version
Setting up libpython2.7-stdlib:amd64 (2.7.15-5) ...
Setting up libgsasl7:amd64 (1.8.0-8ubuntu3) ...
Setting up libvmime1:amd64 (0.9.2-5build3) ...
Setting up libpython2.7:amd64 (2.7.15-5) ...
Setting up kopano-libs:amd64 (8.6.5-1ubuntu2) ...
Setting up kopano-server (8.6.5-1ubuntu2) ...
Determining localhost credentials from /etc/mysql/debian.cnf: succeeded.
dbconfig-common: writing config to /etc/dbconfig-common/kopano-server.conf
Creating config file /etc/dbconfig-common/kopano-server.conf with new version
Creating config file /etc/kopano/debian-db.cfg with new version
checking privileges on database kopanoserver for kopano-server@localhost: user creation needed.
granting access to database kopanoserver for kopano-server@localhost: success.
verifying access for kopano-server@localhost: success.
creating database kopanoserver: success.
verifying database kopanoserver exists: success.
dbconfig-common: flushing administrative password
Processing triggers for libc-bin (2.28-0ubuntu1) ...
Processing triggers for systemd (239-7ubuntu10) ...

After that installing the remaining build dependency: python-nose

The smoke test explicitly installs mariadb-server and then breaks.
Running the remaining calls of the test with my mysql based install

1. new guest
2. enable proposed
3. pull-lp-source kopanocore
4. install python-nose (test dep)
 < snapshot VM to iterate from here >
5. fix mariadb -> default-mysql-server default-mysql-client
6. run test step by step
6.1 install mysql
6.2 define debconf for kopanocore
6.3 install with DEBIAN_FRONTEND=noninteractive
  Setting up kopano-server (8.6.5-1ubuntu2) ...
  Determining localhost credentials from /etc/mysql/debian.cnf: succeeded.
  dbconfig-common: writing config to /etc/dbconfig-common/kopano-server.conf
  Creating config file /etc/dbconfig-common/kopano-server.conf with new version
  Creating config file /etc/kopano/debian-db.cfg with new version
  checking privileges on database kopanoserver for kopano-server@localhost: user creation needed.
  granting access to database kopanoserver for kopano-server@localhost: success.
  verifying access for kopano-server@localhost: success.
  creating database kopanoserver: success.
  verifying database kopanoserver exists: success.
  dbconfig-common: flushing administrative password
6.4 at kopano-admin the issue stays as-is
  Unable to open Admin store: logon failed (0x80040111)
  Using the -v option (possibly multiple times) may give more hints.

Note: Still plenty of apparmor issues in addition to the above:
apparmor="DENIED" operation="open" profile="/usr/sbin/kopano-server" name="/etc/ssl/openssl.cnf" pid=4995 comm="kopano-server" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
apparmor="DENIED" operation="capable" profile="/usr/sbin/kopano-server" pid=4995 comm="kopano-server" capability=24 capname="sys_resource"

In particular the above are
a) user related
b) pop up on that broken kopano-admin call

Setting kopano-server to complain mode and running command again - same result.