Email accounts connect to source server's CardDav port after being transferred

Symptoms

After migrating accounts, email addresses may continue to connect to the source server's CardDav port. If the source server is offline, Roundcube is unable to load when logging into an email address.

Description

After an account is transferred, its Roundcube databases will still reference the source server in the carddav_addressbooks table. However, once the old server is taken offline, email accounts will no longer be able to log into Roundcube.

We've opened an internal case for our development team to investigate this further. For reference, the case number is CPANEL-48012. Follow this article to receive an email notification when a solution is published in the product. 

Workaround

Manually update the 'url' row in the email account's Roundcube SQLite database:

1. Grab the current URL in the SQLite database (where "CPUSER" is the cPanel username, "DOMAIN.TLD" is the domain, and "EMAIL" is the email account's username [without the domain]).

   [root@server ~]cP# sqlite3 /home/CPUSER/etc/DOMAIN.TLD/EMAIL.rcube.db "SELECT url FROM carddav_addressbooks"
   https://server.old-hostname.tld:2080/addressbooks/__uids__/12345-1234-1234-123456-12345/addressbook/

2. Update the 'url' so it references the new server's hostname (or use mail.domain.tld if it resolves to the new server).

   sqlite3 /home/CPUSER/etc/DOMAIN.TLD/EMAIL.rcube.db "UPDATE carddav_addressbooks SET url = 'https://server.new-hostname.tld:2080/addressbooks/__uids__/12345-1234-1234-123456-12345/addressbook/'"

3. Repeat the process for any other affected email account.