Debian 9 + MariaDB = unable to start Kopano server
-
Hi all,
I’ve a problem with my new fresh installation of Kopano server.
System: Debian 9.1 x64
Kopano version: 3.4.4.0I’ve install SLAPD, Apache and php7 and some other dependencies.
I’ve install all *.deb packages.
I’ve change login autenthication type in LDAP, add the password of root user for MySQL ecc.
When I try to start kopano-server I receive this error:Fri Dec 1 17:56:33 2017: [ notice] Starting kopano-server version 8.4.4.0 (pid 19891)
Fri Dec 1 17:56:33 2017: [error ] KDatabase::Connect(): database access error Unknown error code (0x80000007), mysql error: Access denied for user ‘root’@‘localhost’
Fri Dec 1 17:56:33 2017: [crit ] Unable to connect to database: MYSQL not initialized
Fri Dec 1 17:56:33 2017: [ notice] Server shutdown complete.I’ve try to add kopano user to mysql group.
Now kopano-server doesn’t start but I don’t receive any error in server.log.
If I list databases:
MariaDB [(none)]> show databases;
±-------------------+
| Database |
±-------------------+
| information_schema |
| kopano |
| mysql |
| performance_schema |
±-------------------+
4 rows in set (0.01 sec)Can anyone confirm same problem?
mK
-
Hi Mk,
The root user in mariadb is only accessible if you are logged in as root as it is using the unix_socket authentication.
Kopano-core is running under the kopano user and therefore you can’t use the root user.See https://mariadb.com/kb/en/library/authentication-plugin-unix-socket/
Kind regards,
Robing