Charset is not supported on this version of MySQL

Pydio Cells
1

After years of running Ajaxplorer and Pydio 8 under FreeBSD I switched to Nextcloud when there was no support for FreeBSD anymore for Pydio Cells.

This year I switched to PhotonOS in combination with Portainer and docker stacks, and want to give Pydio Cells a go, I created a database and user for pydio with UTF8 collation but it errors out when connecting.

I tried different type of utf8mb4 collations when creating the database.

My docker compose configuration is:

  mariadb:
    image: mariadb:10-ubi
    container_name: mariadb
    hostname: mariadb
    environment:
      - PUID=1033
      - PGID=103
      - TZ=Europe/Amsterdam
    ports:
      - 3306:3306/tcp
    volumes:
      - /home/dockers/mariadb/conf:/etc/mysql/conf.d
      - /home/dockers/mariadb/db:/var/lib/mysql
    restart: unless-stopped

  pydio:
    image: lscr.io/linuxserver/pydio-cells:latest
    container_name: pydio
    hostname: myhostname.mylocaldomainishere
    environment:
      - PUID=1063
      - PGID=101
      - TZ=Europe/Amsterdam
      - EXTERNALURL=myhostname.mydomainishere.com
#      - SERVER_IP=0.0.0.0 #optional
    volumes:
      - /home/dockers/pydio/config:/config
      - /home/dockers/pydio/data:/data
    ports:
      - 8088:8080
    restart: unless-stopped

MariaDB configuration:

  • Server version: 10.11.8-MariaDB - MariaDB Server
  • Protocol version: 10
  • User: donald@172.18.0.1
  • Server charset: UTF-8 Unicode (utf8mb4)
root@dockers [ /home/dockers/mariadb/conf ]# cat my.cnf
[mariadb]
ssl-cert=/etc/ssl/certs/mariadb.*maskeddomain*.fullchain
ssl-key=/etc/ssl/certs/mariadb.*maskeddomain*.key
ssl-ca=/etc/ssl/certs/mariadb.*maskeddomain*.ca
tls_version=TLSv1.2,TLSv1.3
performance_schema=ON
innodb_buffer_pool_size=4G
innodb_log_file_size=1G

# Added 4-byte support
innodb_file_per_table=1

# MySQLTuner adjustments
join_buffer_size=513K
tmp_table_size=32M
max_heap_table_size=32M
table_definition_cache=770
key_buffer_size=102M

# Added for Pydio Cells
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci


[Service]
LimitMEMLOCK=2M

[client]
user=*masked*
password=*masked*

[server]
max_allowed_packet = 134217728

I also tried the ‘official’ pydio docker image, same error.

image
image2109×1552 349 KB

Howto troubleshoot?

2

Did you try official docker image https://hub.docker.com/r/pydio/cells ?

3

Yes, as I stated before:
“I also tried the ‘official’ pydio docker image, same error.”

4

I used these instructions for setting up the database:
Pydio | Docker
so invoking mariadb with --character-set-server=utf8mb4, --collation-server=utf8mb4_unicode_ci

But that gives the above error.

I fixed it by creating the pydio database like:

CREATE DATABASE pydio CHARACTER SET utf8 COLLATE utf8_general_ci;

and can connect now.

5

This topic was automatically closed 11 days after the last reply. New replies are no longer allowed.