Hi,
After i the cells installation i found this problem in mariadb logs :
2018-06-01 12:37:25 140156460406528 [Warning] Aborted connection 8 to db: ‘cells’ user: ‘pydio’ host: ‘localhost’ (Got an error reading communication packets).
During the installation the connection test was correct.
Hints ?
thx
Hi,
this issue seems to be database related,
it could happen because you did multiple installations with the database, it’s one of the many possibilities,
maybe if you clean and restart the database service it could fix that or even restart the server if you’re not using it right now otherwise i found this issue on the internet it might helpful.
hi,
i already tried to change “max_allowed_packet”, but seems it doesn’t works.
./cells install go fine
Deploying interface assets: 90% done…
2018-06-01T14:15:11.736+0200 INFO Extracted 8015 files for a total size of 95909460
Deploying interface assets: 100% done…
Interface assets: Copied 8015 files
Writing file /home/pydio/.config/pydio/cells/static/pydio/data/plugins/boot.conf/bootstrap.json
Created interface config files
Installation Finished: please restart with ‘./cells start’ command
but the database is empty
MariaDB [(none)]> use cells;
Database changed
MariaDB [cells]> show tables;
Empty set (0.00 sec)
The installer say
Database Password (leave empty if not needed): *****
Successfully connected to the database
instead mariadb
2018-06-01 14:15:11 140456304948992 [Warning] Aborted connection 8 to db: ‘cells’ user: ‘pydio’ host: ‘localhost’ (Got an error reading communication packets)
2018-06-01 14:15:11 140456304641792 [Warning] Aborted connection 9 to db: ‘cells’ user: ‘pydio’ host: ‘localhost’ (Got an error reading communication packets)
any suggestion about it?
Then it means that cells could not create the database and tables therefore it could be a rights issue, actually with mariaDB 10.2 it should work perfectly, you could reinstall mariadb-server and re configure it.
I am running into the same issue however I can confirm that all tables for cells were created. When I run Show Tables; I am getting the full list but getting blocked access when I try to access the site.
Blocking error encountered, please check the server logs: ‘Error while trying to write to logger: There was an error trying to connect to your database! Did you change any configuration for the core connection? Or maybe your database is down?’
When I look at the log from mariadb I’m seeing the following.
‘10.4.17-MariaDB’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 MariaDB Server
2021-01-19 9:58:35 0 [Note] InnoDB: Buffer pool(s) load completed at 210119 9:58:35 2021-01-19 10:08:33 19 [Warning] Access denied for user ‘pydio’@‘localhost’ (using password: YES) 2021-01-19 10:08:33 20 [Warning] Access denied for user ‘pydio’@‘localhost’ (using password: YES) 2021-01-19 10:08:35 21 [Warning] Access denied for user ‘pydio’@‘localhost’ (using password: YES) 2021-01-19 10:08:35 22 [Warning] Access denied for user ‘pydio’@‘localhost’ (using password: YES) 2021-01-19 10:10:59 23 [Warning] Access denied for user ‘pydio’@‘localhost’ (using password: YES) 2021-01-19 10:10:59 24 [Warning] Access denied for user ‘pydio’@‘localhost’ (using password: YES) 2021-01-19 10:11:01 25 [Warning] Access denied for user ‘pydio’@‘localhost’ (using password: YES) 2021-01-19 10:11:01 26 [Warning] Access denied for user ‘pydio’@‘localhost’ (using password: YES)
Hello,
in such case, do not hesitate to rather open a new thread instead of resurrecting a very old thread (in comparaison with the life of Cells 
).
Anyway, the logs you show seems quite clear, so how did you create the user, assign roles and created the DB? Pydio use has specific permission or something to precise ?
And BTW what is you OS ?
OS: Fedora 32
Mariadb Version: 10.4.17
The pydio@localhost account has full access on the cells database. It was actually used to create all the tables in the database during the install. however no matter which way I run ./cells start whether doing it through systemd or directly as the pydio user for testing I get that same error.
I have confirmed that the mariadb service is running and that the socket is accessible for the pydio user.
Is the logger in a separate database? I didn’t notice before that that seems to be what the blocking error it is encountering is. Some kind of logger but I wouldn’t think that would prevent it from starting.