Hello,
after an update to UCS 4.4-8 errata1009 I cannot reach Kopano.
I restarted the UCS-Server.
Permisson over webapp denied with Cannot connect to Kopano Core.
pidof kopano-server: no result
After “systemctl restart kopano-server” I get an Prozess-Number, but the Kopano isn’t reachable yet.
What’s the problem?
P.S.: I cannot find any files in /var/log/kopano …
Hi @Thomas_M,
there are not really any information in your post to say “this is the issue” unfortunately. I have collected some commands useful for debugging in https://kb.kopano.io/display/K4U/Debugging+Kopano+on+Univention.
Logging since a while does no longer go to files in /var/log by default, but rather goes to journald, you can get the logging of kopano-server by running journalctl -u kopano-server.
Hi fbartels,
thanks for quick answer again.
Running journalctl -u kopano-server says
-- Reboot --
Jul 16 08:37:32 mose systemd[1]: Started Kopano Groupware Core Storage Server.
Jul 16 08:37:32 mose kopano-server[1856]: Starting kopano-server version 8.7.1 (pid 1856 uid 0)
Jul 16 08:37:32 mose kopano-server[1856]: Starting kopano-server version 8.7.1 (pid 1856 uid 998)
Jul 16 08:37:32 mose kopano-server[1856]: KDatabase::Connect(): database access error Unknown error code (0x80000007), mysql error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "Datei oder Verzeichnis nicht gefunden")
Jul 16 08:37:32 mose kopano-server[1856]: KDatabase::Connect(): database access error Unknown error code (0x80000007), mysql error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "Datei oder Verzeichnis nicht gefunden")
Jul 16 08:37:42 mose kopano-server[1856]: KDatabase::Connect(): database access error Unknown error code (0x80000007), mysql error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "Datei oder Verzeichnis nicht gefunden")
Jul 16 08:37:52 mose kopano-server[1856]: KDatabase::Connect(): database access error Unknown error code (0x80000007), mysql error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "Datei oder Verzeichnis nicht gefunden")
Jul 16 08:38:02 mose kopano-server[1856]: KDatabase::Connect(): database access error Unknown error code (0x80000007), mysql error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "Datei oder Verzeichnis nicht gefunden")
Jul 16 08:38:12 mose kopano-server[1856]: KDatabase::Connect(): database access error Unknown error code (0x80000007), mysql error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "Datei oder Verzeichnis nicht gefunden")
Jul 16 08:38:22 mose kopano-server[1856]: KDatabase::Connect(): database access error Unknown error code (0x80000007), mysql error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "Datei oder Verzeichnis nicht gefunden")
Jul 16 08:38:32 mose kopano-server[1856]: KDatabase::Connect(): database access error Unknown error code (0x80000007), mysql error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "Datei oder Verzeichnis nicht gefunden")
Jul 16 08:38:42 mose kopano-server[1856]: KDatabase::Connect(): database access error Unknown error code (0x80000007), mysql error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "Datei oder Verzeichnis nicht gefunden")
Jul 16 08:38:52 mose kopano-server[1856]: KDatabase::Connect(): database access error Unknown error code (0x80000007), mysql error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "Datei oder Verzeichnis nicht gefunden")
Jul 16 08:39:02 mose kopano-server[1856]: Unable to connect to database: MYSQL not initialized
Jul 16 08:39:02 mose kopano-server[1856]: An error occurred: disk error (0x80000007). Please check logfile syslog:- for details.
Jul 16 08:39:02 mose systemd[1]: kopano-server.service: Main process exited, code=exited, status=255/n/a
Jul 16 08:39:02 mose systemd[1]: kopano-server.service: Unit entered failed state.
Jul 16 08:39:02 mose systemd[1]: kopano-server.service: Failed with result 'exit-code'.
Jul 16 08:44:41 mose systemd[1]: Started Kopano Groupware Core Storage Server.
Jul 16 08:44:41 mose kopano-server[14308]: Starting kopano-server version 8.7.1 (pid 14308 uid 0)
Jul 16 08:44:41 mose kopano-server[14308]: Starting kopano-server version 8.7.1 (pid 14308 uid 998)
Jul 16 08:44:41 mose kopano-server[14308]: KDatabase::Connect(): database access error Unknown error code (0x80000007), mysql error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "Datei oder Verzeichnis nicht gefunden")
Jul 16 08:44:41 mose kopano-server[14308]: KDatabase::Connect(): database access error Unknown error code (0x80000007), mysql error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "Datei oder Verzeichnis nicht gefunden")
Jul 16 08:44:51 mose kopano-server[14308]: KDatabase::Connect(): database access error Unknown error code (0x80000007), mysql error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "Datei oder Verzeichnis nicht gefunden")
Jul 16 08:45:01 mose kopano-server[14308]: KDatabase::Connect(): database access error Unknown error code (0x80000007), mysql error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "Datei oder Verzeichnis nicht gefunden")
Jul 16 08:45:11 mose kopano-server[14308]: KDatabase::Connect(): database access error Unknown error code (0x80000007), mysql error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "Datei oder Verzeichnis nicht gefunden")
Jul 16 08:45:21 mose kopano-server[14308]: KDatabase::Connect(): database access error Unknown error code (0x80000007), mysql error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "Datei oder Verzeichnis nicht gefunden")
Jul 16 08:45:31 mose kopano-server[14308]: KDatabase::Connect(): database access error Unknown error code (0x80000007), mysql error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "Datei oder Verzeichnis nicht gefunden")
Jul 16 08:45:41 mose kopano-server[14308]: KDatabase::Connect(): database access error Unknown error code (0x80000007), mysql error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "Datei oder Verzeichnis nicht gefunden")
Jul 16 08:45:51 mose kopano-server[14308]: KDatabase::Connect(): database access error Unknown error code (0x80000007), mysql error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "Datei oder Verzeichnis nicht gefunden")
Jul 16 08:46:01 mose kopano-server[14308]: KDatabase::Connect(): database access error Unknown error code (0x80000007), mysql error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "Datei oder Verzeichnis nicht gefunden")
Jul 16 08:46:11 mose kopano-server[14308]: Unable to connect to database: MYSQL not initialized
Jul 16 08:46:11 mose kopano-server[14308]: An error occurred: disk error (0x80000007). Please check logfile syslog:- for details.
Jul 16 08:46:11 mose systemd[1]: kopano-server.service: Main process exited, code=exited, status=255/n/a
Jul 16 08:46:11 mose systemd[1]: kopano-server.service: Unit entered failed state.
Jul 16 08:46:11 mose systemd[1]: kopano-server.service: Failed with result 'exit-code'.
Is it an DB-Problem?
P.S.: Seems so, Nextcloud is not running too.
Any tips or hints?
Yes, very much looks like the database is the culprit here. The logging of Mariadb can be found as various files that start with mysql in /var/log/. Maybe it just did not start up, maybe there is some corruption. If there is corruption then you can use the search on this forum to find instructions on how to recover.
Thanks a lot again.
I found the problem. The system partition was full. The reason was the trashbin in the nextcloud.
Additionally the MariaDB was broken. But with the script here I repaired it.