Does Virtualmin support for MariaDB?

8 posts / 0 new
Last post
#1 Mon, 12/19/2016 - 07:51
flaviod

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

Mon, 12/19/2016 - 12:44
Diabolico
Diabolico's picture

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.

- I often come to the conclusion that my brain has too many tabs open. -
Failing at desktop publishing & graphic design since 1994.

Sat, 03/25/2017 - 14:29
hollyboom

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.

Thu, 03/30/2017 - 01:34
toreskev

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.

Thu, 03/30/2017 - 05:46
hollyboom

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

Mon, 10/09/2017 - 07:22
Eskes

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.

Mon, 10/09/2017 - 18:56 (Reply to #6)
Joe
Joe's picture

"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.

--

Check out the forum guidelines!

Tue, 10/10/2017 - 09:45 (Reply to #7)
Eskes

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

Topic locked