MariaDB 10.0.x Support

[starnetwork]

Hi,
I try to Install magento 2 with MariaDB 10.0.22 DB
and I got the following error: Sorry, but we support MySQL version 5.6.0 or later.

Please add MariaDB support in next fix release

Regards,

[markshust]

MariaDB should just really work out of the box (see my ticket #1906). Just use a standard mysql connection string/data when connecting to the mariadb instance and all should be ok.

[starnetwork]

Hi, it's should but it's not working and give this message using "web interface" for installation and regular connection string values
the message: Sorry, but we support MySQL version 5.6.0 or later.

[alankent]

There were lots of obtuse error messages when people used the wrong version of MySQL. It may be this was just improved to be more informative, but as a result more restrictive as well. Is there a good way to work out if a system is MySQL 5.6 compatible?

[BlackIkeEagle]

@starnetwork I assume this is a web install, since bin/magento does not complain when installing using mariadb and runs just fine with mariadb

[starnetwork]

Hi,
yes, this is web install
@alankent, I don't know why you say that MariaDB 10.0 is not MySQL compatible, it its!
just using another version numbering
why to use MariaDB? please read https://seravo.fi/2015/10-reasons-to-migrate-to-mariadb-if-still-using-mysql
compatibility: https://blog.mariadb.org/mariadb-10-0-and-mysql-5-6/

[markshust]

Note that if you install with mariadb and command line, no error is returned. Everything installs and works just fine. So there is a check in web installer that isn't in CLI installer.

[markshust]

@starnetwork fyi they do plan on supporting mariadb, just not 'officially' #1906

[asrob]

I use Fedora 23 with MariaDB and everything works fine and I used web installer.

$ mysql --version
mysql Ver 15.1 Distrib 10.0.21-MariaDB, for Linux (x86_64) using readline 5.1

Installed Packages
Name : mariadb-server
Arch : x86_64
Epoch : 1
Version : 10.0.21
Release : 1.fc23
Size : 86 M
Repo : @System
From repo : updates
Summary : The MariaDB server and related files
URL : http://mariadb.org
License : GPLv2 with exceptions and LGPLv2 and BSD
Description : MariaDB is a multi-user, multi-threaded SQL database server. It is a
client/server implementation consisting of a server daemon (mysqld)
and many different client programs and libraries. This package contains
the MariaDB server and some accompanying files and directories.
MariaDB is a community developed branch of MySQL.

[hgpit]

I have installed M2CE three times and M2EE once, all on systems running MariaDB 10.0.23 and experienced zero issues regarding the DB engine version.

I should add that these were clean CentOS installed though with no old MySQL files floating around.

Sorry I can't be more helpful!

[mazhalai]

@starnetwork were you able to try installing via CLI?

[starnetwork]

Hi @mazhalai
I already change the environment to MySQL 5.6 and can't touch it now :(
anyway, next time I will have same environment, I will check it again...

[alankent]

If I understand correctly from this page (https://mariadb.com/kb/en/mariadb/what-is-mariadb-100/), MariaDB is close to MySQL 5.6. It is not exactly the same - it is 5.5 with some 5.6 features back-ported. So they don't claim 100% compatibility. That means to more officially support MariaDB we may need to add it to all our test plans. At present we only test against the official MySQL 5.6 release. (If I recall, MySQL 5.7 changed something so Magento does not work with MySQL 5.7 out of the box.) A painful area.

[markshust]

I think this is something specific to the user's environment. I've run both
10.0 and 10.1 on m 2.0.0 with zero issues. Installed, configured, ran fine
out of the box.
On Mon, Jan 11, 2016 at 7:29 PM Alan Kent [email protected] wrote:

If I understand correctly from this page (
https://mariadb.com/kb/en/mariadb/what-is-mariadb-100/), MariaDB is close
to MySQL 5.6. It is not exactly the same - it is 5.5 with some 5.6
features back-ported. So they don't claim 100% compatibility. That means to
more officially support MariaDB we may need to add it to all our test
plans. At present we only test against the official MySQL 5.6 release. (If
I recall, MySQL 5.7 changed something so Magento does not work with MySQL
5.7 out of the box.) A painful area.

—
Reply to this email directly or view it on GitHub
#2470 (comment).

[asrob]

I agree with @markoshust. I installed Magento 2.1.0 via cli and everything was fine, using MariaDB 10.1.14.

[markshust]

this ticket should be closed as a dupe of #1906

[zgggzrzx]

Hi,i got the same issue for web installation.
Finally i modified this php file ( i use community edition and directory structure like this)
Magento\setup\src\Magento\Setup\Model\Installer.php
There is a const variable here :const MYSQL_VERSION_REQUIRED = '5.6.0';
You can set it =''; Then the installation will igonre the mysql version check.

[markshust]

It appears you are using a web installer? I've been installing from CLI.

[zgggzrzx]

Ye, web installer maybe not support marian, so need to modify something.

On Jul 28, 2016 6:25 PM, "Mark Shust" [email protected] wrote:

It appears you are using a web installer? I've been installing from CLI.

—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
#2470 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/ATwPyx8-Hqu1CF-Qk9MiM7r97m_EXN-9ks5qaVaYgaJpZM4GnGmt
.

[markshust]

Ok, this should in fact be a bug then. I would expect the web interface should work exactly like the CLI. Whatever is happening in CLI should be the correct/default method, looks like web interface is doing some additional MySQL checks it shouldn't be doing.

[zgggzrzx]

Hi,yes,just I continue installing magneto, it reported some error when
creating database tables.

On Jul 28, 2016 8:42 PM, "Mark Shust" [email protected] wrote:

Ok, this should in fact be a bug then. I would expect the web interface
should work exactly like the CLI. Whatever is happening in CLI should be
the correct/default method, looks like web interface is doing some
additional MySQL checks it shouldn't be doing.

—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
#2470 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/ATwPy7SLjC_9hjBF7RNs5aqUS_22vPNsks5qaXaRgaJpZM4GnGmt
.

[veloraven]

@zgggzrzx please create a new issue if you still have this problem.
Please use our issue reporting template to describe the issue. The template specifies the version and configuration information we need to assess your issue. See the Issue reporting guidelines for more information.
Please specify exact errors you see and their places.

I'm going to close this one as it does not follow required format and as it is not actual for the author anymore there is no sense to ask to update it.