Seafile can't connect to Mysql with IPv6

[ki2007]

If IPv6 is enabled for the seafile network, seafile can't connect to the database server.

Issue: The initial setup creates an mysql user named seafile with an user_host of '%.%.%.%' which does not allow the user to connect with an IPv6 connection.

Solution: Set user_host of seafile user to '%' or an reasonable alternative to allow connections from IPv6 hosts.

[tohn]

Hey @ki2007, I just ran into this issue. Could you please explain in more detail how to solve this?

[joachimtingvold]

PR that fixes this submitted (#288).

As a workaround;

1. Set the IPv4 address of the MariaDB-container as the value for DB_HOST during setup.
2. Wait until everything is working.
3. Edit sql user on the MariaDB-container; rename user 'seafile'@'%.%.%.%' to 'seafile'@'%';
4. Change DB_HOST to the hostname.
5. Change host manually in the seafile configs (ccnet.conf, seafile.conf and seahub_settings.py)