New Kolab on Debian 9 SQL Setup not working?!

[Matthias Busch]

okay, had another try.

after apt install kolab I noticed var/lib/mysql exists

I also saw mariadb being installed.

i tried mysql -u root and ...logged in, without setting a root pw

--> so, mysql is running, without password, before setup-kolab gets started.

therefore, and since login is possible without password, choosing 2
might work.
I tested it now, and it does.

why it didnt work at the first try with setting a sql root password
first, I could only guess.
maybe it works too, if you manually set a sql root password before
starting setup-kolab and then select 3




Am 21.01.2020 um 12:44 schrieb Matthias Busch:
> Hey,
>
> for other unrelated troubleshooting stuff, I am installing the current
> kolab on a debian 9 machine.
>
> I get as far as setting up sql in the setup-kolab
>
> First, I selected 3 (new mysql server) - I set a mysql root password,
> kolab wanted to setup kolab sql user and roundcube sql user, but it
> failed.
>
> I confirmed my sql root pw is working (mysql -u root -p) - and it is.
>
> I tried again setup-kolab mysql
>
> This time I select 1 (existing mysql), I type in the sql root
> password, and it still fails
>
> Now, I honestly believe there is not much I could have done wrong so
> far. It seems to be broken.
>
> copy/paste of second try (please note, the MySQL root Password given
> does work when doing mysql -u root -p)
>
> What MySQL server are we setting up?
>  - 1: Existing MySQL server (with root password already set).
>  - 2: Existing MySQL server (with unix_socket authentication plugin).
>  - 3: New MySQL server (needs to be initialized).
> Choice: 1
>
> Please supply the root password for MySQL, so we can set up user
> accounts for
> other components that use MySQL.
>
> MySQL root Password:
> ERROR 1698 (28000): Access denied for user 'root'@'localhost'
>
> Please supply a password for the MySQL user 'kolab'. This password
> will be used
> by Kolab services, such as the Web Administration Panel.
>
> MySQL-kolab Password [redacted]:
> ERROR 1698 (28000): Access denied for user 'root'@'localhost'
> ERROR 1698 (28000): Access denied for user 'root'@'localhost'
>
>
>