Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Piwik check mysql 5.7 as mysql 5.5 #12030

Closed
sprhawk opened this issue Sep 12, 2017 · 5 comments
Closed

Piwik check mysql 5.7 as mysql 5.5 #12030

sprhawk opened this issue Sep 12, 2017 · 5 comments
Labels
worksforme The issue cannot be reproduced and things work as intended.

Comments

@sprhawk
Copy link

sprhawk commented Sep 12, 2017

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 ?

@mneudert
Copy link
Member

Can you issue a SELECT @@version; 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.

@mattab mattab added the Waiting for user feedback Indicates the Matomo team is waiting for feedback from the author or other users. label Sep 18, 2017
@mattab
Copy link
Member

mattab commented Sep 18, 2017

see also #12002

@fengkaijia
Copy link
Contributor

Check this MSDN issue, maybe it's because of Azure reporting a 5.5 server_version in handshake (not sure, never use Azure before).

@kiwi-x
Copy link

kiwi-x commented Nov 13, 2017

Hello. I'm in the same trouble now. (I also posted this info at #12002 )
Using like most here a Azure SQL Database.

MySQL [* * *]> select @@Version;
+-----------+
| @@Version |
+-----------+
| 5.7.18 |
+-----------+

but on system summary on the settings page you see

Piwik-Version: 3.2.0
MySQL-Version: 5.6.26.0
PHP-Version: 7.0.22-0ubuntu0.16.04.1

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 database: * * *
Current user: * * @ * *
SSL: Cipher in use is AES256-SHA
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server: MySQL
Server version: 5.6.26.0 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.

robocoder added a commit to robocoder/matomo that referenced this issue Feb 12, 2018
robocoder added a commit to robocoder/matomo that referenced this issue Mar 24, 2018
robocoder added a commit to robocoder/matomo that referenced this issue Apr 4, 2018
mattab pushed a commit that referenced this issue Apr 23, 2018
* Fixes #12002 and #12030 - azure fallback to "select @@Version"

* Add comment for why @@Version is used instead of going through the connection object.
InfinityVoid pushed a commit to InfinityVoid/matomo that referenced this issue Oct 11, 2018
…ct @@Version" (matomo-org#12551)

* Fixes matomo-org#12002 and matomo-org#12030 - azure fallback to "select @@Version"

* Add comment for why @@Version is used instead of going through the connection object.
@sgiehl
Copy link
Member

sgiehl commented Aug 24, 2023

Closing this one as there hadn't been any further reports in the last years. If anyone experiences a similar problem, feel free to create a new issue.

@sgiehl sgiehl closed this as not planned Won't fix, can't repro, duplicate, stale Aug 24, 2023
@sgiehl sgiehl added worksforme The issue cannot be reproduced and things work as intended. and removed Waiting for user feedback Indicates the Matomo team is waiting for feedback from the author or other users. labels Aug 24, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
worksforme The issue cannot be reproduced and things work as intended.
Projects
None yet
Development

No branches or pull requests

6 participants