Problem: After Upgrade Kopano does not Start

kopano
upgrade
mysql
problem
mariadb

#1

Problem

Your Kopano server does not start up after upgrading to UCS 4.3.

You will see those errors in logs:

Mon Mar 26 11:29:37 2018: [error  ] SQL [00000023] Failed: Cannot load from mysql.proc. The table is probably corrupted, Query Size: 33, Query: "DROP PROCEDURE IF EXIST$
Mon Mar 26 11:29:37 2018: [error  ] KDatabase::I_Update() query failed: DROP PROCEDURE IF EXISTS GetProps: Cannot load from mysql.proc. The table is probably corrupted
Mon Mar 26 11:29:37 2018: [error  ] Can't initialize database settings

Solution

Sometimes during the upgrade the database upgrade procedure is not run correctly. You can start the conversion manually by:
/usr/bin/mysql_upgrade --defaults-extra-file=/etc/mysql/debian.cnf

If this runs without an error your Kopano server should now start.


#2