Topic: utf8mb4 Mysql Support

[HACKERSOFT2011]

Hi!

Is there any way smeserver can support utf8mb4 as the default character set?

e.g.

The following settings are recommended by moodle 3.2+ in the my.cnf file:

[client]
default-character-set = utf8mb4

[mysqld]
innodb_file_format = Barracuda
innodb_file_per_table = 1
innodb_large_prefix

character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
skip-character-set-client-handshake

[mysql]
default-character-set = utf8mb4

Thank you in advance for your informative reply!

[Stefano]

if the onboard mysql release supports such a configuration, you can achieve it using custom fragments (wiki will tell you more)

[ReetP]

Funnily enough I stumbled on this today.

I believe the sort answer is no, the default install on mysql in CentOS 6 does not support utf8mb4. I think it started around MySQL 5.3.x

A couple of solutions.

1. Use utf8 if you have a simple charset and don't expect anything convoluted

2. Check the wiki on how to install a newer version of MySQL e.g. SCL repos https://wiki.contribs.org/Software_Collections:MySQL

B. Rgds
John

[HACKERSOFT2011]

Thanks all for your reply!

@Stefano
I tried adding it to the my.cnf fragments but it won't work..


@ReetP
I think I have MySQL version 5.5.47 by Remi installed.

We are in Thailand with International students so I think the utf8mb4 is best for us. Also, Moodle might deprecate support for utf8 later so we better do it now than when we have too much data to convert later.

Regarding SCL, I will try that one...

[ReetP]

If you have the REMI version I would think it should work unless it is compiled without ?

Not sure how to test.

[mmccarn]

I have mysql55 installed on my system as described in the "SME Server 9.x 64-bit ONLY" section of this wiki page:
https://wiki.contribs.org/Software_Collections:MySQL55


I did this, which did not generate any error messages

I don't know if you also need to change the setting for 'server character set' manually, or of the moodle install takes care of that for you.

Stop mysql55
sv d mysql55-mysqld

edit /opt/rh/mysql55/root/etc/my.cnf to include the moodle settings
[mysqld]
log-error=/var/log/mysql55-mysqld.log
pid-file=/opt/rh/mysql55/root/var/run/mysqld/mysqld.pid
basedir=/opt/rh/mysql55/root/usr
datadir=/opt/rh/mysql55/root/var/lib/mysql
socket=/var/lib/mysql/mysql55.sock
skip-networking
#no port as skip-networking
innodb_file_format = Barracuda
innodb_file_per_table = 1
innodb_large_prefix

log-error=/var/log/mysql55-mysqld.log
max_allowed_packet=16M
user=mysql

[mysqld_safe]

[client]
default-character-set = utf8mb4

[mysql]
default-character-set = utf8mb4


restart mysql55
sv u mysql55-mysqld

check the server status
# mysql55 -e "status;"

Which now gives this output ('Client' and 'Conn.' characterset have changed from utf8 to utf8mb4)

Code: [Select]

-------------
/opt/rh/mysql55/root/usr/bin/mysql  Ver 14.14 Distrib 5.5.52, for Linux (x86_64) using readline 5.1

Connection id: 3
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.52 MySQL Community Server (GPL)
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db     characterset: latin1
Client characterset: utf8mb4
Conn.  characterset: utf8mb4
UNIX socket: /var/lib/mysql/mysql55.sock
Uptime: 4 min 30 sec

Threads: 2  Questions: 38  Slow queries: 0  Opens: 34  Flush tables: 1  Open tables: 27  Queries per second avg: 0.140
--------------


[EDIT]
/opt/rh/mysql55/root/etc/my.cnf is templated, so ultimately you'll need to effect the above changes using custom template fragments in /etc/e-smith/templates-custom/opt/rh/mysql55/root/etc/my.cnf

[HACKERSOFT2011]

Just got the time to test this again...

Thanks mmccarn!

Your tweak worked!

[Jean-Philippe Pialasse]

have you installed it manually or using the contrib ?

if the latter your changes might be deleted later. You need to template them.

https://wiki.contribs.org/MySQL55

[HACKERSOFT2011]

Thank you! I tested it first by modifying the /etc/my.conf file...

I will set it in the template fragment so it can survive an update...

Thanks again!