CMS Version
Xibo V4.1.2
Installation Method
Docker install default MySQL
Operating System
ubuntu 24.04.2 LTS
Issue
We are facing the issue that the binlog files in /shared/db are getting way too large (19Gb and growing). We found that the default binlog expire time is 30 days in MySQL8.
We tried to clean up the logs and change the expire time in the MySQL instance but the “cms” user has not the needed permissions to do so. As for the “root” user the password setting is set to randomize but we couldn’t find it in the logs as the container is started.
How can these settings be changed?
Thanks in advance
Best regards