[MariaDB] MariaDB+phpMyAdmin MySQL Server Fork

[sanctimon]

Finally, running:

Code: Select all

/usr/local/MariaDB/bin/MariaDB/bin/mysql_upgrade --defaults-file=/usr/local/MariaDB/bin/MariaDB/my.cnf -u root -p

gives:

Code: Select all

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

[sanctimon]

Last, but not least, re-installation broke Nextcloud.

[outkastm]

from which version to what version have you done the upgrade ?
my.conf can be that is reset after new installation, i will adapt this

Root password if it was set, it's not removed with a new installation
Check again what you have you changed in my.cnf that the nextcloud is broken now

Edit:

at least for me on 10.4.22.0 after reinstallation my.cnf file was not overwritten.
Future test to do when the next version is released

[sanctimon]

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.

[outkastm]

Finally, running:

Code: Select all

/usr/local/MariaDB/bin/MariaDB/bin/mysql_upgrade --defaults-file=/usr/local/MariaDB/bin/MariaDB/my.cnf -u root -p

gives:

Code: Select all

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

Code: Select all

slow_query_log
slow_query_log_file=/var/log/mysql/slow.log

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

[outkastm]

Just reinstalled - the my.cnf file got overwritten. Checking for the others.

Just reinstalled 10.4.22.0, my.cnf file didn't get overwritten and i have the same root password

[sanctimon]

This is most peculiar.

What is the standard location of this file in your installation? Is it under

Code: Select all

/usr/local/MariaDB/bin/MariaDB

I found one in

Code: Select all

/usr/local/MariaDB/bin

but it does not look the same as the one configured through the web app.

[outkastm]

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

[mamz]

Hello,

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.

Regards.

[mamz]

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.

Awaiting for your help, I thank you so much.

Regards