Overview
cPanel & WHM’s Horde user data storage uses individual SQLite databases for each cPanel account. Horde webmail and CalDAV/CardDAV services execute as the cPanel account user. This document explains the methods that the system uses to manage Horde data.
New installations
The system stores Horde user data into the new location from the installation.
Horde components and table schemas
Horde user data storage uses many components which include, but are not limited to, the following modules:
- Horde Application Framework
- IMP (Mail)
- Ingo (Mail Filters)
- Kronolith (Calendar)
- Mnemo (Notes and Memos)
- Nag (Task List)
- Trean (Bookmark Manager)
- Turba (Address Book).
Scripts
The update_horde_config script
The /usr/local/cpanel/bin/update_horde_config script:
- Does not add database credentials to
/usr/local/cpanel/base/horde/config/conf.phpfile. The SQLite database uses filesystem permissions for access control. - Handles the initial creation of cPanel account SQLite database for Horde.
- Performs schema checks and upgrade operations with the
--fulloption.
For more information, run the /usr/local/cpanel/bin/update_horde_config --help command.
The SQLite Horde database and the cphorde directory
Each cPanel account possesses its own .cphorde directory under the account’s home directory. The .cphorde directory contains the following items:
horde.sqlite(SQLite database) — This database contains the cPanel account’s Horde data.meta(Directory) — The backup service uses this directory to create the Horde database backups.vfsroot(Directory) — The/usr/local/cpanel/base/horde/config/conf.phpfile uses this directory for thevfsrootsetting.
The conf.php file
cPanel account users must have permissions to this file.
The following applies to the /usr/local/cpanel/base/horde/config/conf.php file:
- This file does not contain Horde database credentials or a server-specific MySQL® password. The
sqlentries in this file only contain the generic SQLite setup configuration. - This file’s permission is world-readable.
Horde database troubleshooting and repair
You can use the following section to troubleshoot problems for each cPanel account’s Horde SQLite database.
If you delete a cPanel account’s Horde SQLite database, you will lose all of that account’s calendar and contact information.
Reset horde database password.
You cannot perform this action. The SQLite database relies on filesystem permissions for access control, not a password.
Create a missing database for cPanel user
Use the following script, where USERNAME is the cPanel account’s username:
/usr/local/cpanel/bin/update_horde_config --user=USERNAMECreate missing databases for all cPanel users on the system
Use the /usr/local/cpanel/bin/update_horde_config script.
Upgrade tables or create missing tables in an existing database for a cPanel user
Use the /usr/local/cpanel/bin/update_horde_config script with the --full option, where USERNAME is the cPanel account’s username:
/usr/local/cpanel/bin/update_horde_config --user=USERNAME --fullThe --full option instructs the script to perform the full table schema check and upgrade/repair instead of only checking whether the database exists.
Upgrade tables or create missing tables in the existing databases for all users on the system
Run the following script:
/usr/local/cpanel/bin/update_horde_config --fullThis script may require significant time to execute on systems with many accounts.
Move and re-create a new horde database for a cPanel user with the default calendars and address books
- Move the user’s file, where
USERNAMEis the cPanel account’s username:mv ~USERNAME/.cphorde/horde.sqlite ~USERNAME/.cphorde/horde.sqlite.bak - Run the following script:
/usr/local/cpanel/bin/update_horde_config --user=USERNAME --create-defaults
