[horde] A fatal error has occurred utf8 is not supported by MySQL

[Larry Weldon]

Hi,

This post is to document a problem and its' solution. Some months ago I 
installed Horde Groupware 5.2.22 on two separate Ubuntu 20.04 servers. 
Mysql is the database used. Both installations worked great for about 6 
months.

Both servers began throwing the exception (subject above) at slightly 
different times. The error occurred in the initial access/login to the 
server. I didn't notice whether an update caused it or not.

Sorting through many different clues from Google searches I found the 
following line in conf.php
#$conf['sql']['charset'] = 'utf-8';
$conf['sql']['charset'] = 'utf8mb4';

Both servers are functioning well again.

It would be nice to know if an update of mysql or horde was responsible. 
It happened on May 9th (2022) and took me awhile to fix.

Thanks,

Larry