Problem
On UCS 5.2 installing OX Documents from the App Center /usr/share/open-xchange-documents-collaboration/bin/initdcsdb.sh does not run correctly, and the service open-xchange-documents-collaboration fails to start afterwards.
Related bug report: Bug 58659
Cause
MariaDB in UCS 5.2 does not allow login as root@localhost by default. The script attempts to create the required OX Documents database using root credentials:
ROOTAUTH="-u $MYSQL_ROOT_USER -p$MYSQL_ROOT_PASSWD"
mysql -h $DCSDB_HOST -P $DCSDB_PORT $(eval echo $ROOTAUTH)
This results in the following error:
initializing dcsdb from scratch...
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
unable to drop database (wrong or missing password for user root?)
Workarounds
Either remove the -P $DCSDB_PORT option from the script, so it looks like this:
mysql -h $DCSDB_HOST $(eval echo $ROOTAUTH)
or temporarily enable root@localhost login in MariaDB so the script can create the database.