Managing Roundcube Databases, Webmail Folders, and Email Signatures in cPanel & WHM

1. Convert Roundcube to SQLite

The /usr/local/cpanel/scripts/convert_roundcube_mysql2sqlite script updates Roundcube to use individual SQLite databases instead of a single MySQL® database.

Warning: Once you convert Roundcube to SQLite, you cannot revert back to MySQL.

1.1 Benefits of SQLite

• Each email user receives a separate SQLite database.
• Restoring Roundcube data becomes easier and user-specific.
• Disk usage is tracked accurately within the user’s /home directory.
• Roundcube PHP processes run as the cPanel user, simplifying troubleshooting.
• No single point of failure—corruption affects only one user.

1.2 SQLite Database Path

Roundcube stores SQLite databases at:

/home/username/etc/domain/username.rcube.db

1.3 Convert Entire System

/usr/local/cpanel/scripts/convert_roundcube_mysql2sqlite

1.4 Convert a Single User

/usr/local/cpanel/scripts/convert_roundcube_mysql2sqlite user

1.5 Migrate Roundcube from MySQL to SQLite Between Servers

1. On the source server, dump the Roundcube database:

mysqldump roundcube > roundcube.dump

2. Create a temporary MySQL database on the destination server.
3. Edit the script and comment out the following block:

-->
unless ( defined $opt_dbname ) {
    Cpanel::Email::RoundCube::archive_and_drop_mysql_roundcube($logger);
}
<--

4. Import the dump and convert:

/usr/local/cpanel/scripts/convert_roundcube_mysql2sqlite user exampledatabase

---

2. Manage Webmail Folders in Roundcube

Roundcube allows users to create, delete, subscribe to, and unsubscribe from folders.

2.1 Default Folders

• Inbox
• Drafts
• Sent
• Junk
• Trash
• Archive

Important: Do not subscribe to the Junk folder with the plain folder icon. Roundcube uses the spam directory internally but displays it as Junk with a flame icon.

2.2 Create a Folder (Desktop)

1. Click the Settings icon.
2. Select Folders → Create.
3. Enter a folder name.
4. Select a parent folder or choose ---.
5. Select List or Threads view mode.
6. Click Save.

2.3 Create a Folder (Mobile)

1. Tap the menu icon.
2. Tap Settings → Folders.
3. Tap the plus icon or the three-dot menu → Create.
4. Enter a folder name and parent folder.
5. Select view mode.
6. Tap Save.

2.4 Delete a Folder (Desktop)

1. Go to Settings → Folders.
2. Select the folder.
3. Click Delete.
4. Confirm deletion.

2.5 Delete a Folder (Mobile)

1. Tap menu → Settings → Folders.
2. Select the folder.
3. Tap the three-dot menu → Delete.
4. Confirm deletion.

---

3. Set Up a Signature in Webmail

Webmail does not provide a global signature setting. You must configure signatures inside the Webmail client you use.

3.1 Create a Signature in Roundcube

1. Log in to Roundcube.
2. Click Settings.
3. Select Identities.
4. Select an identity or create a new one.
5. Enter your signature in the Signature box.
6. Click Save.

3.2 Add an Image to Your Signature

1. Open the signature editor.
2. Click the HTML editor icon.
3. Click the Insert/Edit Image icon.
4. Click the folder icon → Add image.
5. Select a JPEG or GIF file within the allowed size.
6. Click Close → select the image → set dimensions.
7. Click OK → Save.

Important: Images only appear if you compose messages in HTML mode.

3.3 Enable HTML Composition

1. Go to Settings → Preferences → Composing Messages.
2. Set Compose HTML messages to always.
3. Click Save.

---

Conclusion

This guide covers essential Roundcube management tasks, including converting databases to SQLite, organizing Webmail folders, and creating professional email signatures. These tools help administrators and users maintain efficient, secure, and personalized email environments.