It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Pipelines - Server sent charset unknown to the client Edited

Had some builds passing a few days ago, but today we have been getting this error even when re-running the passing builds:

“SQLSTATE[HY000] [2054] Server sent charset unknown to the client. Please, report to the developers”

Did something change in Pipelines? How can we set the charset of the server? Thanks!

 

2 answers

1 accepted

1 vote
Answer accepted

In the end we fixed this by editing bitbucket-pipelines.yml so that the PHP version we were using was php 7.1.16 and mysql version was 5.7. 

0 votes
edwin Community Leader Apr 23, 2018

Hi Gillian,

If using MySQL, this might help. Set in my.cnf.

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8


[mysqld]
collation-server = utf8_unicode_ci
character-set-server = utf8

 Found in this link with the same error.

Thanks, but how can we edit my.cnf in bitbucket pipelines? 

Don't use utf8 with MySQL, as it's an alias for their broken utf8mb3 encoding. Explicitly use utf8mb4 (and utf8mb4_unicode_ci)

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Bitbucket

Bitbucket Server 7.0 is here!

Hello Community, I’m Anton Genkin, a product manager on the Bitbucket Server and Data Center team and am excited to share that Bitbucket Server 7.0 is now available! It's a platform release, one th...

1,109 views 6 5
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you