@sthopd opened this Issue on November 23rd 2018

Hello,
I have updated the live-site to v3.6.0 and still get the same error when I ‘Setup a Website’.
Error:
Cannot connect to the database:
Server sent charset unknown to the client. Please, report to the developers

How do I solve the problem of “Server sent charset unknown to the client.”?!
I have newly installed the Matomo analytics site on my Production server.
On my production server, I get an error when creating the first site-to-be-analyzed by Matomo.
Error:
“SQLSTATE[HY000] [2054] Server sent charset unknown to the client. Please, report to the developers”
I see that within many PHP-code pages of Matomo, the character set for database handling is set -hard coded- to UTF8 !
Please developer, change this -hard coded- setting into a flexible variable that every webmaster can maintain in the config-file (…\config\config.ini.php).
or change the -hard coded- content to the a modern character set variant, such as: utf8mb4 .
Any help would be appreciated.
Friendly regards,
Simon
Environment:
Matomo 3.5.1
MySQL 8.0.12 (different port)
PHP 7.2.7
IIS 10 webserver on Windows 10 pro OS

Have a look at: https://bugs.php.net/bug.php?id=74461 .
and: MySQL Bugs: #85946: MySQL 8.0.1 breaks php compatibilty .
Where should I change the CharSet setting: in Matomo? in MySQL? in PHP?

20181001 matomo live - set up first website

20180927 mysql8012 character set in live site

@tsteur commented on November 23rd 2018 Member

see https://github.com/matomo-org/matomo/issues/9785

if possible change it to utf8

@sthopd commented on November 23rd 2018

Hello Thomas,

Thank you for your advice.
I set the Collation for the Matomo database in MySQL 8.0.13 to utf8_bin (there is no collation utf8) but the error message does not go away.
(PHP: version 5.6.31)

Friendly regards,
Simon

Sent from Mailhttps://go.microsoft.com/fwlink/?LinkId=550986 for Windows 10


From: Thomas Steur <notifications@github.com>
Sent: Friday, November 23, 2018 6:51:57 PM
To: matomo-org/matomo
Cc: sthopd; Author
Subject: Re: [matomo-org/matomo] MySQL 8.0.1 error “Server sent charset unknown to the client.” (#13756)

see #9785https://github.com/matomo-org/matomo/issues/9785

if possible change it to utf8


You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHubhttps://github.com/matomo-org/matomo/issues/13756#issuecomment-441295026, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AZYydl6pwAn60S33pIt-DyKYwbdhrua9ks5uyDW9gaJpZM4YwpPd.

Powered by GitHub Issue Mirror