I use piwik on Azure, and use MySQL on Azure service with version 5.7
But piwik check the version as MySQL 5.5.
Why and how to fix it ?
Can you issue a
SELECT @<a class='mention' href='https://github.com/version'>@version</a>; query on the MySQL instance and report the result back?
I would not expect it but perhaps they messed with the version string and the current detection cannot cope with that.
Check this MSDN issue, maybe it's because of Azure reporting a 5.5 server_version in handshake (not sure, never use Azure before).
Hello. I'm in the same trouble now. (I also posted this info at #12002 )
Using like most here a Azure SQL Database.
but on system summary on the settings page you see
which is the same database version, which is shown when running the status command after connecting to the database:
MySQL [ * ]> status
mysql Ver 15.1 Distrib 10.0.31-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
Connection id: 65385
Current user: @
SSL: Cipher in use is AES256-SHA
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 126.96.36.199 MySQL Community Server (GPL)
Protocol version: 10
Connection: .mysql.database.azure.com via TCP/IP
Server characterset: latin1
Db characterset: latin1
Client characterset: utf8mb4
Conn. characterset: utf8mb4
-- I changed (for a quick and very dirty check) line 272 in Marketplace/Api/Client.php to this (don't do that - it was just to verify if this is the problem!)
$params['mysql'] = "5.7.18"; // $this->environment->getMySQLVersion();
After that change, I could access the Marketplace.