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

[Louis-Philippe Allard]

  Quoting Larry Weldon <lweldon at weldoncomputers.com>:

> 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
>
> --
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/To unsubscribe,  
> mail: horde-unsubscribe at lists.horde.org

It would be nice to have the full fatal error stack strace to see the  
actual errors encountered by Horde...  For me, on Centos/RHEL/Rocky  
Linux, I went thru MANY Myql/MariaDB upgrades in the last 10y or so,  
and never had an issue with Mysql connections.

My conf.php shows:

  $conf['sql']['username'] = '************';
  $conf['sql']['password'] = '*************';
  $conf['sql']['hostspec'] = '************';
  $conf['sql']['port'] = 3306;
  $conf['sql']['protocol'] = 'tcp';
  $conf['sql']['database'] = '************';
  $conf['sql']['charset'] = 'utf-8';
  $conf['sql']['ssl'] = false;
  $conf['sql']['splitread'] = false;
  $conf['sql']['logqueries'] = true;
  $conf['sql']['phptype'] = 'mysqli';
  $conf['nosql']['phptype'] = false;
  $conf['auth']['driver'] = 'sql';

I am running 2 Ubuntu based servers (one for a Unifi controller and  
another for xwiki because it was MUCH easier to get it up and running  
on ubuntu than Rocky Linux) and both machines are flaky after  
updates... IMO and experience, the ubuntu ecosystem changes too fast  
and this can create troubles like the one you described....  Food for  
thought.
  Louis-Philippe Allard
lp.allard.1 at gmail.com
Sent using Horde Groupware on GNU/Linux