When trying to use “Update from Source” button in Calendar, I get the error:
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
File:/var/www/html/admin/libraries/BMO/DB_Helper.class.php:651
Pretty much the same via cli:
[root@freepbx mariadb]# fwconsole calendar --sync --force
Starting Sync…
Syncing Test…
In DB_Helper.class.php line 651:
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
However, I don’t see anything in /var/log/mariadb/mariadb.log that would indicate that Maria actually terminated or restarted… maybe there’s another log I should be looking at?
After much trial and error, I found that simple (small) ICS files worked. I added max_allowed_packet = 128M to my.cnf and that got rid of the “MySQL server has gone away” message, but then created a new “There was an error fetching the events” message. The browser console showed that it was an index issue with dtend. Eventually, I had to switch the Google Calendar to be Public and to show only Free/Busy (not full details) and it worked. It looks to me like Google is formatting the dtend differently for Full/Busy than full details, but I have no idea why and don’t really care for the purposes of FreePBX. Hopefully, this will be useful to someone in the future.
Hopefully, this will be useful to someone in the future. 