[MariaDB] MariaDB+phpMyAdmin MySQL Server Fork

Discussion on apps, protocols, APIs, specifications, and more. You are welcome to join us as a TOS app developer!
User avatar
sanctimon
Posts: 98
Joined: 14 Nov 2021, 06:57

Re: [MariaDB][10.4.22.0]MariaDB+phpMyAdmin MySQL Server Fork

Post 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
User avatar
sanctimon
Posts: 98
Joined: 14 Nov 2021, 06:57

Re: [MariaDB][10.4.22.0]MariaDB+phpMyAdmin MySQL Server Fork

Post by sanctimon »

Last, but not least, re-installation broke Nextcloud.
Attachments
Στιγμιότυπο 2021-12-02, 22.31.43.png
User avatar
outkastm
Posts: 1185
Joined: 29 Dec 2020, 23:52

Re: [MariaDB][10.4.22.0]MariaDB+phpMyAdmin MySQL Server Fork

Post 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
User avatar
sanctimon
Posts: 98
Joined: 14 Nov 2021, 06:57

Re: [MariaDB][10.4.22.0]MariaDB+phpMyAdmin MySQL Server Fork

Post 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.
User avatar
outkastm
Posts: 1185
Joined: 29 Dec 2020, 23:52

Re: [MariaDB][10.4.22.0]MariaDB+phpMyAdmin MySQL Server Fork

Post 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
User avatar
outkastm
Posts: 1185
Joined: 29 Dec 2020, 23:52

Re: [MariaDB][10.4.22.0]MariaDB+phpMyAdmin MySQL Server Fork

Post 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

Image
User avatar
sanctimon
Posts: 98
Joined: 14 Nov 2021, 06:57

Re: [MariaDB][10.4.22.0]MariaDB+phpMyAdmin MySQL Server Fork

Post by 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.
User avatar
outkastm
Posts: 1185
Joined: 29 Dec 2020, 23:52

Re: [MariaDB][10.4.22.0]MariaDB+phpMyAdmin MySQL Server Fork

Post 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
User avatar
mamz
Posts: 2
Joined: 12 Aug 2021, 17:49

Re: [MariaDB][10.4.22.0]MariaDB+phpMyAdmin MySQL Server Fork

Post 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.
User avatar
mamz
Posts: 2
Joined: 12 Aug 2021, 17:49

Re: [MariaDB][10.4.22.0]MariaDB+phpMyAdmin MySQL Server Fork

Post 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
Attachments
Capture d’écran 2022-02-04 094323.png
Post Reply