[Solved] Failed to init DB provider {"error": "Error 1709: Index column size too large. The maximum column size is 767 bytes. handling idm_acl_0.1.sql"}


#1

we were curious about cells especially for the installation procedure which was announced as easy. But it is still “pydioesque” :slight_smile:

We run latest debian with latest mariadb, everything out of the box. We followed the installation guide for debian and now we got stuck here:

2018-10-04T16:31:14.138+0200 ERROR pydio.grpc.acl Failed to init DB provider {"error": "Error 1709: Index column size too large. The maximum column size is 767 bytes. handling idm_acl_0.1.sql"}

Followed diverse suggestions to pimp mariadb:

[mysqld]
innodb_file_format = Barracuda
innodb_file_per_table = 1
innodb_large_prefix = on

with no luck.

What do we miss?


#2

Hi,
what is your mariadb and pydio cells version?
i need the exact numbers if possible to investigate that.


#3
root@cells:~ # mysql --version
mysql  Ver 15.1 Distrib 10.1.26-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

root@cells:~ # /srv/web/cells/cells version

    Pydio Cells Home Edition (1.2.0)
    Published on 02 Oct 18 10:22 +0000
    Revision number 70deb1a17c7d17743c495526de767b82b7e8b10d

#4

i see,
could you upgrade mariadb to atleast version 10.2 and latest is 10.3.
here’s the requirement page if you need more details.


#5

here’s the mariadb offical repository if you need,

https://downloads.mariadb.org/mariadb/repositories/#distro=Ubuntu&version=10.3&mirror=cnrs

you can change to debian and your version don’t worry!
i’m going to update the documentation about that.


#6

Thank you, now it works. Thought latest from a current distro should work. But latest stable with custom repo is fine off course.

Thank you!


#7