Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Charset / utf8mb4 related trouble running cells configure #512

Open
localhost opened this issue Oct 13, 2023 · 0 comments
Open

Charset / utf8mb4 related trouble running cells configure #512

localhost opened this issue Oct 13, 2023 · 0 comments

Comments

@localhost
Copy link

Hi, I'm using cells configure --cli to set up a new instance running on Alpine Linux 3.18.

MariaDB (10.11.5) is running on the local machine.

I also ran the following SQL statements, as given in the documentation:

CREATE USER 'pydio'@'localhost' IDENTIFIED BY '<your-password-here>';
CREATE DATABASE cells DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
GRANT ALL PRIVILEGES ON cells.* to 'pydio'@'localhost';
FLUSH PRIVILEGES;

The MySQL user can successfully connect to the local instance.

Now, if I run cells configure to set up the DB connection, I get the following error (it happens after successful authentication):

Cannot connect to database, please review the parameters: Charset is not supported for this version of MySQL

In the source, a check for charset 'utf8mb4' happens here:

https://github.com/pydio/cells/blob/8b454d0c1ae4a7f4fed74633a04b1b4eb3058f2f/discovery/install/lib/database.go#L301C20-L301C27

I wonder why there's a check for the default and installation recommended charset and then failing if so.

If I return nil from that check and recompile cells, then the installation proceeds and finally succeeds.

My guess is that I'm not seeing something clearly here. Did I set up the database wrong?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant