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.0

    I’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


  • Kopano

    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


Log in to reply
 

Looks like your connection to Kopano Community Forum was lost, please wait while we try to reconnect.