Cells Version 5 update issue

Pydio Cells
1

For first post, please answer the questions below!

Describe your issue in detail

I downloaded the latest binary and followed all steps documented for RHEL based linux distros. The database and /var/cells is restored from backup. I took a backup on the previous stable version of Cells version. The issue is, on first launch it didn’t worked, I think the upgrade part took time, on restarting the cells service, the login page appeared and logged in fine, but it was too slow and some feature like opening shared cells weren’t working… and I restarted the cells service again and this time it is not allowing me to login with the correct username and password, showing this error: “Login failed: could not recognise your username or password”
here is the log of cells service.

This is caddy definition I have used,

cells.home {
  tls internal

  reverse_proxy localhost:8080 {
    header_up X-Real-IP {remote_host}
    header_up X-Forwarded-For {remote_host}
    header_up X-Forwarded-Proto {scheme}
    header_up Host {host}

    transport http {
      tls
      tls_insecure_skip_verify
    }
  }
}

https://paste.centos.org/view/7f340689

What version of Cells are you using?

Version 5.0.0

What is the server OS? Database name/version? Browser name or mobile device description (if issue appears client-side)?

Fedora Server 43, Mariadb 15.1, Firefox 150.0.1 (64-bit)

What steps have you taken to resolve this issue already?

Restarted Cells.service and Caddy (Which I am using as reverse proxy)

2

Hi,

Can you give us the full logs after restarting the application please ? That would help us debugging. And also, can you provide a bit more information about your system (db versions, …) ?

Thanks,

Greg

3

Just saw your db version :slight_smile: But the logs would be nice !

4

I have shared the log too, have you checked the paste bin link I have shared?

5

The link you gave is returning a 404.

6

Here is a full log, this time when I reload, at least it logged in successfully but it is so slow and some functionalities are not working as intended.

Log file

7

Would it please be possible to return the following :

SELECT 
  TABLE_SCHEMA AS database_name,
  TABLE_NAME AS table_name,
  TABLE_ROWS AS estimated_rows 
FROM information_schema.TABLES
WHERE TABLE_SCHEMA NOT IN ( 
  'information_schema', 
  'mysql', 
  'performance_schema', 
  'sys')
ORDER BY TABLE_ROWS DESC;

And also to enable the slow query logs to see if there is anything obvious ?


SET GLOBAL slow_query_log = 'ON';
SET GLOBAL long_query_time = 1;
SET GLOBAL log_queries_not_using_indexes = 'ON';
SET GLOBAL slow_query_log_file = '/var/log/mysql/mariadb-slow.log';

Finally, we have done some changes to the way the connection pool is handled in the v5. By default we set up 10 connections for the home edition. It could be that it is too low for your setup - could you try changing it please ? In the pydio.json, you can add a parameter maxConnection to the database connection url to increase the number of connections ?

...
"dsn": "mysql://root:secret@tcp(127.0.0.1:3308)/cells?parseTime=true&prefix={{.Meta.prefix}}&policies={{.Meta.policies}}&singular={{.Meta.singular}}&maxConnections=40" 
...

Thanks,

Greg