Page 3 of 7
Re: [MariaDB][10.4.22.0]MariaDB+phpMyAdmin MySQL Server Fork
Posted: 03 Dec 2021, 06:26
by 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
Re: [MariaDB][10.4.22.0]MariaDB+phpMyAdmin MySQL Server Fork
Posted: 03 Dec 2021, 06:32
by sanctimon
Last, but not least, re-installation broke Nextcloud.
Re: [MariaDB][10.4.22.0]MariaDB+phpMyAdmin MySQL Server Fork
Posted: 03 Dec 2021, 06:40
by 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
Re: [MariaDB][10.4.22.0]MariaDB+phpMyAdmin MySQL Server Fork
Posted: 03 Dec 2021, 06:47
by 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.
Re: [MariaDB][10.4.22.0]MariaDB+phpMyAdmin MySQL Server Fork
Posted: 03 Dec 2021, 07:09
by outkastm
sanctimon wrote: ↑03 Dec 2021, 06:26
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
Re: [MariaDB][10.4.22.0]MariaDB+phpMyAdmin MySQL Server Fork
Posted: 03 Dec 2021, 07:31
by outkastm
sanctimon wrote: ↑03 Dec 2021, 06:16
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
Re: [MariaDB][10.4.22.0]MariaDB+phpMyAdmin MySQL Server Fork
Posted: 03 Dec 2021, 18:10
by sanctimon
This is most peculiar.
What is the standard location of this file in your installation? Is it under
I found one in
but it does not look the same as the one configured through the web app.
Re: [MariaDB][10.4.22.0]MariaDB+phpMyAdmin MySQL Server Fork
Posted: 03 Dec 2021, 18:45
by 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
Re: [MariaDB][10.4.22.0]MariaDB+phpMyAdmin MySQL Server Fork
Posted: 03 Feb 2022, 22:21
by 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.
Re: [MariaDB][10.4.22.0]MariaDB+phpMyAdmin MySQL Server Fork
Posted: 04 Feb 2022, 16:46
by 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