TosoBoso/Kopano4s

Debunked: Mariadb password policy update seems to break install

pw-h opened this issue · 0 comments

pw-h commented

_Original post: After many many attempts to reinstall Kopano4S on my Synology DS918+, it seems the following MariaDB update breaks access to the database by the kopano user: Result is that not all or something no tables are created.

MariaDb Updated to version 10.3.21.
Added a new password policy for more security. This policy requires all passwords to meet the minimum length and contain mixed-case letters, numbers, and special characters; moreover, it does not allow common passwords or usernames to be used as passwords.

Server.log shows:
2020-02-17T20:24:53.273614: [error ] mysql_real_connect: Access denied for user 'kopano'@'localhost' (using password: YES)_

Turned out this was due to a leftover kopano share with a kopano-server.cfg with a previous password.

But, install keeps being very flaky. When installing, anywhere between 14 and 22 tables are created in de kopano database, and it seems random how much tables are created. Server.log states either
2020-02-17T20:32:08.284942: [error ] Tables missing inside database: no access (80000020)
or 'cannot update database.

Í have made 25 attempts so far , with many variations in sql settings etc, reinstalling mariadb etc, to no avail. So i'm giving up.