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

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

Post by outkastm »

i will check to add Galera provider library on the next version
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 »

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"
User avatar
astroashton
Posts: 9
Joined: 03 Apr 2022, 10:20

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

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

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

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

Re: [MariaDB] MariaDB+phpMyAdmin MySQL Server Fork

Post by outkastm »

added TOS5 version
User avatar
outkastm
Posts: 1185
Joined: 29 Dec 2020, 23:52

Re: [MariaDB] MariaDB+phpMyAdmin MySQL Server Fork

Post by outkastm »

up to 10.4.28.0
User avatar
sanctimon
Posts: 98
Joined: 14 Nov 2021, 06:57

Re: [MariaDB] MariaDB+phpMyAdmin MySQL Server Fork

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

Re: [MariaDB] MariaDB+phpMyAdmin MySQL Server Fork

Post 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.
Post Reply