Page 4 of 7
Re: [MariaDB][10.4.22.0]MariaDB+phpMyAdmin MySQL Server Fork
Posted: 10 Feb 2022, 07:56
by outkastm
i will check to add Galera provider library on the next version
Re: [MariaDB][10.4.24.0]MariaDB+phpMyAdmin MySQL Server Fork
Posted: 15 Feb 2022, 07:00
by outkastm
up to 10.4.24.0
Re: [MariaDB][10.4.22.0]MariaDB+phpMyAdmin MySQL Server Fork
Posted: 15 Feb 2022, 07:58
by outkastm
mamz wrote: ↑04 Feb 2022, 16:46
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
galera is included now on the latest version 10.4.24.0
To add galera wsrep library (available at /usr/local/MariaDBlibs/lib/libgalera_smm.so), you need to install the app
MariaDBlibs
Then from the app MariaDB webui, go to Configuration files >> Edit my.cnf and the the section below (adapt to your needs)
A guide to start with is available
here
Code: Select all
[mysqld]
binlog_format=ROW
default-storage-engine=innodb
innodb_autoinc_lock_mode=2
bind-address=0.0.0.0
# Galera Provider Configuration
wsrep_on=ON
wsrep_provider=/usr/local/MariaDBlibs/lib/libgalera_smm.so
# Galera Cluster Configuration
wsrep_cluster_name="galera_cluster"
wsrep_cluster_address="gcomm://node1-ip-address,node2-ip-address,node3-ip-address"
# Galera Synchronization Configuration
wsrep_sst_method=rsync
# Galera Node Configuration
wsrep_node_address="node1-ip-address"
wsrep_node_name="node1"
Re: [MariaDB][10.4.25.0]MariaDB+phpMyAdmin MySQL Server Fork
Posted: 29 May 2022, 07:42
by outkastm
up to 10.4.25.0
Re: [MariaDB][10.4.25.0]MariaDB+phpMyAdmin MySQL Server Fork
Posted: 11 Oct 2022, 06:23
by astroashton
What is this? Why does it say I have to subscribe to a plan to download some of these now? I can't install Modbase or Maria because of this. What's going on?
Re: [MariaDB][10.4.25.0]MariaDB+phpMyAdmin MySQL Server Fork
Posted: 11 Oct 2022, 06:53
by outkastm
All the 3rd party apps already released will remain free.
All the updates and new apps for TOS4 will be offered based on small yearly subscription to support my work.
You can still download the free version after you login to
tmnascommunity.eu
Re: [MariaDB] MariaDB+phpMyAdmin MySQL Server Fork
Posted: 28 Oct 2022, 06:19
by outkastm
added TOS5 version
Re: [MariaDB] MariaDB+phpMyAdmin MySQL Server Fork
Posted: 22 Feb 2023, 06:36
by outkastm
up to 10.4.28.0
Re: [MariaDB] MariaDB+phpMyAdmin MySQL Server Fork
Posted: 22 Feb 2023, 20:33
by sanctimon
Following upgrade to 10.4.22.0, all dbs are down.
I know I had a password set for root before, but it is now not accepted. Running this upgrade code without a password:
Code: Select all
/usr/local/MariaDB/bin/MariaDB/bin/mysql_upgrade --defaults-file=/usr/local/MariaDB/bin/MariaDB/my.cnf -u root
results in the following error:
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
This means that my nextcloud install also fails
Code: Select all
Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [1045] Access denied for user 'nextcloud'@'127.0.0.1' (using password: YES) in /mnt/md2/application/Nextcloud_okm/bin/nextcloud/lib/private/DB/Connection.php:139
What happened here and any ideas on how to fix it?
Re: [MariaDB] MariaDB+phpMyAdmin MySQL Server Fork
Posted: 22 Feb 2023, 20:57
by sanctimon
Just realised that this happened to me a few releases back; it looks like I managed to fix it back then, but no idea what I did - some of the information given here must have helped.