Hey ahrnke,
phpmyadmin habe ich erst vorhin installiert. Die dbconfig-mysql allerdings nicht. Die muss wohl schon länger auf meinem System sein.
Ich habe nun mittels mysqld_safe --skip-grant-tables &
das Passwort für den Benutzer root angepasst. Ich kann mich nun auch als dieser wieder im mysql (mysql -uroot -p) mit Passwort anmelden. Allerdings startet er den Kopano-Server dennoch nicht. Die Meldung lautet aktuell:
Wed Aug 8 13:22:49 2018: [=======] Starting kopano-server version 8.6.2 (pid 1423)
Wed Aug 8 13:22:49 2018: [warning] Config warning: Option 'server_max_keep_alive_requests' is not used anymore.
Wed Aug 8 13:22:49 2018: [warning] Config warning: Option 'sync_log_all_changes' is not used anymore.
Wed Aug 8 13:22:49 2018: [warning] Config warning: Option 'plugin_path' is not used anymore.
Wed Aug 8 13:22:49 2018: [warning] Config warning: Option 'thread_stacksize' is not used anymore.
Wed Aug 8 13:22:49 2018: [warning] Config warning: Option 'client_update_enabled' is not used anymore.
Wed Aug 8 13:22:49 2018: [warning] Config warning: Option 'client_update_path' is not used anymore.
Wed Aug 8 13:22:49 2018: [warning] Config warning: Option 'client_update_log_level' is not used anymore.
Wed Aug 8 13:22:49 2018: [warning] Config warning: Option 'client_update_log_path' is not used anymore.
Wed Aug 8 13:22:49 2018: [error ] Coredumps will not be generated: kopano-server requires the fs.suid_dumpable sysctl to contain the value 2, not 0. See kopano-coredump(5) for details.
Wed Aug 8 11:23:11 2018: [error ] SQL [00000003] Failed: Duplicate entry '2' for key 'gni', Query Size: 170, Query: "ALTER TABLE `names` ADD UNIQUE INDEX `gni` (`guid`(16), `nameid`), ADD UNIQUE INDEX `gns` (`guid`(16), `namestring`), DROP INDEX `guidnameid`, DROP INDEX `guidnamestring`"
Wed Aug 8 11:23:11 2018: [error ] KDatabase::I_Update() query failed: "Duplicate entry '2' for key 'gni'", query: ALTER TABLE `names` ADD UNIQUE INDEX `gni` (`guid`(16), `nameid`), ADD UNIQUE INDEX `gns` (`guid`(16), `namestring`), DROP INDEX `guidnameid`, DROP INDEX `guidnamestring`
Wed Aug 8 11:23:11 2018: [error ] K-1216: Cannot update to schema v69, because the "names" table contains unexpected rows. Certain prior versions of the server erroneously allowed these duplicates to be added (KC-1108).
Wed Aug 8 11:23:11 2018: [error ] K-1220: To fix the excess rows, use `kopano-dbadm k-1216`. Consult the manpage and preferably make a backup first.
Wed Aug 8 11:23:11 2018: [error ] K-1221: Alternatively, the server may be started with --ignore-da to forego the schema update.
Wed Aug 8 11:23:11 2018: [warning] WARNING: Unable to upgrade database from version 8.4.5.2152005632.66 to 8.6.2.0.70
Wed Aug 8 11:23:11 2018: [warning] You can force the server to start with --ignore-database-version-conflict
Wed Aug 8 11:23:11 2018: [warning] Warning, you can lose data! If you don't know what you're doing, you shouldn't be using this option!
Wed Aug 8 11:23:11 2018: [=======] Server shutdown complete.
Im Anschluss habe ich die geforderte kopano-dbadm k-1216 mittels
systemctl stop kopano-server
/usr/sbin/kopano-dbadm k-1216
systemctl start kopano-server
ausgeführt. Jetzt lässt sich der Kopano-Server starten, der Zugriff auf MYSQL funktioniert auch und die Webapp geht ebenfalls wieder.
Danke trotzdem für die Hinweise.