Phase 4/7: Running 'mysql_fix_privilege_tables'
ERROR 29 (HY000) at line 167: File '/var/log/mysql/slow.log' not found (Errcode: 2 "No such file or directory")
FATAL ERROR: Upgrade failed
I have put my.cnf back together the way it was, but it was not this that broke Nextcloud.
I checked the Nextcloud logs and for some reason the existing Nextcloud user could no longer access the db, Nextcloud was attempting to use 'user'@'localhost' rather than 'user'@'127.0.0.1'. Dropped the wrong user and created the correct one, gave him privileges and Nextcloud seems to be back to normal.
Phase 4/7: Running 'mysql_fix_privilege_tables'
ERROR 29 (HY000) at line 167: File '/var/log/mysql/slow.log' not found (Errcode: 2 "No such file or directory")
FATAL ERROR: Upgrade failed
i guess you have modified my.cnf and added these lines on it
notice that the folder /var/log/mysql is not available by default, so if you want to use this location you have to create the folder or use /var/log/slow.log
can be that after the NAS is rebooted, this folder is removed as it is part of the TOS
MariaDB is using my.cnf file located in /usr/local/MariaDB/bin/MariaDB
The installation tpk does not have this file on this folder.
On the first installation of MariaDB, the startup script will copy the default my.cnf from /usr/local/MariaDB/bin to /usr/local/MariaDB/bin/MariaDB
During upgrade or reinstallation of the package, if my.cnf is already present in /usr/local/MariaDB/bin/MariaDB, it will not be overwritten with the default one from /usr/local/MariaDB/bin
The webapp is editing the file from /usr/local/MariaDB/bin/MariaDB
I actually use this third party application of MariaDB, and I need to know how to activate mariadb galera with wsrep.
If you already have configured or have something like to replication to multi-master on Terramaster mysql databases.
I need a help.
If I am login mysql root and running command "SHOW STATUS LIKE 'wsrep%';
You see the result in the attachment. So I don't know how to locate the config file and if there's a provider library for galera.