Does Virtualmin support for MariaDB?

Hi

I started with a clean install of Ubuntu Server 16.04.1. Then installed

  • Apache 2
  • MAriaDB 10.0.28
  • PHP 7.0

Did some test and everything was working fine.

Then started the VirtualMin installation script and saw in the virtualmin-install.log that MariaDB is being installed and instead MySQL 5.7 is automatically installed (by VirtualMin).

Does that mean VirtualMin is not supporting MariaDB?

Rads, FDM

Virtualmin will support native software what it comes with specific OS. Ubuntu default is MySQL so Virtualmin is looking for that instead of MariaDB. You will need to manually make adjustments.

Hi,

I have installed in one of my vps servers latest MariaDB, works perfect.
Steps: - CentOS

nano /etc/yum.repos.d/MariaDB.repo

MariaDB 10.1 CentOS repository list - created 2017-03-25 19:28 UTC

http://downloads.mariadb.org/mariadb/repositories/

[mariadb]

name = MariaDB

baseurl = http://yum.mariadb.org/10.1/centos7-amd64

gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB

gpgcheck=1

Then:

sudo yum install MariaDB-server MariaDB-client

After:

sudo systemctl enable mariadb & sudo systemctl start mariadb

sudo mysql_secure_installation

Set virtualmin with start & stop :

Webmin - Mysql Database server - module configuration : left corner up : )

Command to start MySQL server: /etc/rc.d/init.d/mysql start
Command to stop MySQL server: /etc/rc.d/init.d/mysql stop

All done, & Post-Installation Wizard

Should work PERFECT. … yum upgrade -y & reboot …: )

Virtualmin in my opinion it´s most powerfull & free server pannel.

Best regards.

It’s not a clean install as you already had installed apache2 and PHP etc. Virtualmin installs all these automatically.
Instead you should wipe it, install Virtualmin as the first thing you do (after securing your server of course) and then install MariaDB.
That works perfectly.

Do not need to wipe nothink, just make MariaDB.repo & upgrade.

I got this after upgrade on Centos 7.4

After Virtualmin is installed and upp and runing. Install mariaDB repo do yum update mariaDB are isntaled and working.
Rerun “Post-Installation Wizard”

On DB config. "MySQL could not be started with the new configuration : Redirecting to /bin/systemctl start mariadb.service Job for mariadb.service failed because the control process exited with error code. See “systemctl status mariadb.service” and “journalctl -xe” for details. . The old configuration has been restored.!

Output from “stemctl status mariadb.service”

mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: failed (Result: exit-code) since Fri 2017-10-06 11:44:41 CEST; 1h 56min ago
Process: 16579 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Process: 16521 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=/usr/bin/galera_recovery; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 16519 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 16579 (code=exited, status=1/FAILURE)
Status: “MariaDB server is down”

Oct 06 11:44:41 SERVER mysqld[16579]: 2017-10-06 11:44:41 139919386093696 [Note] InnoDB: Starting shutdown…
Oct 06 11:44:41 SERVER mysqld[16579]: 2017-10-06 11:44:41 139919386093696 [ERROR] Plugin ‘InnoDB’ init function returned error.
Oct 06 11:44:41 SERVER mysqld[16579]: 2017-10-06 11:44:41 139919386093696 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
Oct 06 11:44:41 SERVER mysqld[16579]: 2017-10-06 11:44:41 139919386093696 [Note] Plugin ‘FEEDBACK’ is disabled.
Oct 06 11:44:41 SERVER mysqld[16579]: 2017-10-06 11:44:41 139919386093696 [ERROR] Unknown/unsupported storage engine: InnoDB
Oct 06 11:44:41 SERVER mysqld[16579]: 2017-10-06 11:44:41 139919386093696 [ERROR] Aborting
Oct 06 11:44:41 SERVER systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Oct 06 11:44:41 SERVER systemd[1]: Failed to start MariaDB database server.
Oct 06 11:44:41 SERVER systemd[1]: Unit mariadb.service entered failed state.
Oct 06 11:44:41 SERVER systemd[1]: mariadb.service failed.

MariaDB are runing fine.

Control for Maria DB are not working in webmin.

Not a big isue. Evryting works exept control and wizard.

“Control for Maria DB are not working in webmin.”

What do you mean? MariaDB is fully supported in Webmin’s MySQL module.

If you’ve migrated to a different version of mariadb (I see “galera” mentioned above, which makes me think you have installed a third-party package), you must update Webmin’s MySQL module to know where all the new file and configurations live.

Reson webmin modul mysql was trying to start/stop maridb. Changed to mysql and it works.