Recent Roundcube issues

Hello everyone!  You'd likely seen or experienced recent issues with updates to the Roundcube package.  Whether it's related to the removal of the Larry theme, part of the CCS changes, or a problem accessing messages, this thread is here to summarize everything I'm seeing at this time so you don't have to search for solutions.

Issue 1: Roundcube MySQL to Sqlite conversion failing on cPanel version 120
Problem: If you updated from 110 to 120, you may have run into a problem with the Sqlite database conversion.  This will look like this in the Roundcube logs:

warn [convert_roundcube_mysql2sqlite] Conversion was not successful for user ‘enduser’.
info [convert_roundcube_mysql2sqlite] Detected database versions:
  none - Inital schema likely not installed
info [convert_roundcube_mysql2sqlite] Applying /usr/local/cpanel/base/3rdparty/roundcube/SQL/sqlite.initial.sql...
info [convert_roundcube_mysql2sqlite] Applying /usr/local/cpanel/base/3rdparty/roundcube/plugins/libkolab/SQL/sqlite.initial.sql...
info [convert_roundcube_mysql2sqlite] Applying /usr/local/cpanel/base/3rdparty/roundcube/plugins/calendar/drivers/caldav/SQL/sqlite.initial.sql...
info [convert_roundcube_mysql2sqlite] Applying /usr/local/cpanel/base/3rdparty/roundcube/plugins/calendar/drivers/database/SQL/sqlite.initial.sql...
[2024-04-18 19:10:21 -0400] warn [convert_roundcube_mysql2sqlite] ERROR: missing caldav_calendars table
warn [convert_roundcube_mysql2sqlite] ERROR: missing caldav_calendars table
[2024-04-18 19:10:21 -0400] warn [convert_roundcube_mysql2sqlite] Conversion was not successful for user 'enduser'.
warn [convert_roundcube_mysql2sqlite] Conversion was not successful for user 'enduser'.
info [convert_roundcube_mysql2sqlite] Detected database versions:
  none - Inital schema likely not installed

Is it fixed? Yes, in all versions of 122 when that is released, and 120.0.6, which will be released soon.

Issue 2: Roundcube not opening when using webmail URL under client domain name. 
Problem: The title on this one is self-explanatory - Roundcube doesn't work when using webmail.domain.com, but works with direct access to port 2096.
Is it fixed? No, but we are having good success with the following workaround:

iptables -t nat -A OUTPUT -d $PUBLIC-IP -p tcp -m tcp --dport 2080 -j DNAT --to-destination $INTERNAL-IP:2080

Issue 3: Updating Roundcube from 1.4 to 1.6 fails to update schema on old MySQL versions
Problem: If you have Maria 10.0.3 or older, the Roundcube updates don't properly handle the database.  You'll see something like this in the cPanel update logs:

[2023-04-20 05:02:01 +1000] info [update-roundcube-db] Removing old backup: roundcube.backup.sql.1657825308
Use of uninitialized value in warn at /usr/local/cpanel/bin/update-roundcube-db line 230.
Warning: something's wrong at /usr/local/cpanel/bin/update-roundcube-db line 230.
[2023-04-20 05:02:02 +1000] info [update-roundcube-db] Error occurred during upgrade
Cpanel::Exception::Database::Error/(XID 4frhz4) The system received an error from the “MySQL” database “roundcube”: 1071 (Specified key was too long; max key length is 767 bytes)
 at /usr/local/cpanel/Cpanel/DBI.pm line 200.

Is it fixed? No, but you can convert to SQLite to get things working:

/scripts/convert_roundcube_mysql2sqlite 

Issue 4: RoundCube Internal error on first login attempt for end user after update to cPanel v120
Problem: When you first login to Roundcube after the update to cPanel 120, you get and internal server error.
Is it fixed? A new RPM is being released May 10.

Issue 5: Unable to view emails in Roundcube after updates to 120
Problem: Accessing emails in Roundcube in version 120 results in the following error:

[18-Apr-2024 15:32:56 America/Chicago] PHP Fatal error:  Uncaught Error: Class "Sabre\VObject\Property\Text" not found in /usr/local/cpanel/base/3rdparty/roundcube/plugins/libcalendaring/lib/libcalendaring_vcalendar.php:1572

Is it fixed? Almost - we are testing a new cpanel-roundcube package that has this fix applied.

Issue 6: Larry theme is removed
Problem: The developers of the Larry theme haven't been keeping up with it, so this was removed from the product.
Is it fixed?  Yes, as there is nothing that needs to be done, you just no longer have access to this theme.

=================================================================

I don't want this to turn into an epic thread so I'll be locking comments so we can just use this for a reference.  I'll also try and update this page as I get new information.