{"id":683,"date":"2021-07-23T12:35:34","date_gmt":"2021-07-23T12:35:34","guid":{"rendered":"https:\/\/ssdsunucum.com\/blog\/guide-to-horde-data-behavior\/"},"modified":"2021-07-23T12:35:34","modified_gmt":"2021-07-23T12:35:34","slug":"guide-to-horde-data-behavior","status":"publish","type":"post","link":"https:\/\/ssdsunucum.com\/blog\/guide-to-horde-data-behavior\/","title":{"rendered":"Guide to Horde Data Behavior"},"content":{"rendered":"<\/p>\n
\n
<\/div>\n
\n

Overview<\/h2>\n

cPanel & WHM\u2019s 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.<\/p>\n

New installations<\/h3>\n

The system stores Horde user data into the new location from the installation.<\/p>\n

Horde components and table schemas<\/h2>\n

Horde user data storage uses many components which include, but are not limited to, the following modules:<\/p>\n

    \n
  • Horde Application Framework<\/li>\n
  • IMP (Mail)<\/li>\n
  • Ingo (Mail Filters)<\/li>\n
  • Kronolith (Calendar)<\/li>\n
  • Mnemo (Notes and Memos)<\/li>\n
  • Nag (Task List)<\/li>\n
  • Trean (Bookmark Manager)<\/li>\n
  • Turba (Address Book).<\/li>\n<\/ul>\n

    Scripts<\/h2>\n

    The update_horde_config script<\/h3>\n

    The \/usr\/local\/cpanel\/bin\/update_horde_config<\/code> script:<\/p>\n

      \n
    • Does not<\/strong> add database credentials to \/usr\/local\/cpanel\/base\/horde\/config\/conf.php<\/code> file. The SQLite database uses filesystem permissions for access control.<\/li>\n
    • Handles the initial creation of cPanel account SQLite database for Horde.<\/li>\n
    • Performs schema checks and upgrade operations with the --full<\/code> option.<\/li>\n<\/ul>\n

      For more information, run the \/usr\/local\/cpanel\/bin\/update_horde_config --help<\/code> command.<\/p>\n

      The SQLite Horde database and the cphorde directory<\/h2>\n

      Each cPanel account possesses its own .cphorde<\/code> directory under the account\u2019s home directory. The .cphorde<\/code> directory contains the following items:<\/p>\n

        \n
      • horde.sqlite<\/code> (SQLite database) \u2014 This database contains the cPanel account\u2019s Horde data.<\/li>\n
      • meta<\/code> (Directory) \u2014 The backup service uses this directory to create the Horde database backups.<\/li>\n
      • vfsroot<\/code> (Directory) \u2014 The \/usr\/local\/cpanel\/base\/horde\/config\/conf.php<\/code> file uses this directory for the vfsroot<\/code> setting.<\/li>\n<\/ul>\n

        The conf.php file<\/h2>\n
        \n
        Important:<\/div>\n
        \n

        cPanel account users must<\/strong> have permissions to this file.<\/p>\n<\/p><\/div>\n<\/div>\n

        The following applies to the \/usr\/local\/cpanel\/base\/horde\/config\/conf.php<\/code> file:<\/p>\n

          \n
        • This file does not<\/strong> contain Horde database credentials or a server-specific MySQL\u00ae password. The sql<\/code> entries in this file only contain the generic SQLite setup configuration.<\/li>\n
        • This file\u2019s permission is world-readable.<\/li>\n<\/ul>\n

          Horde database troubleshooting and repair<\/h2>\n

          You can use the following section to troubleshoot problems for each cPanel account\u2019s Horde SQLite database.<\/p>\n

          \n
          Warning:<\/div>\n
          \n

          If you delete a cPanel account\u2019s Horde SQLite database, you will lose all<\/strong> of that account\u2019s calendar and contact information.<\/p>\n<\/p><\/div>\n<\/div>\n

          Reset horde database password.<\/h4>\n

          You cannot perform this action. The SQLite database relies on filesystem permissions for access control, not a password.<\/p>\n

          Create a missing database for cPanel user<\/h4>\n

          Use the following script, where USERNAME<\/code> is the cPanel account\u2019s username:<\/p>\n

          \n
          \/usr\/local\/cpanel\/bin\/update_horde_config --user=<\/span>USERNAME<\/code><\/pre>\n<\/div>\n
          Create missing databases for all cPanel users on the system<\/h4>\n
          Use the \/usr\/local\/cpanel\/bin\/update_horde_config<\/code> script.<\/p>\n
          Upgrade tables or create missing tables in an existing database for a cPanel user<\/h4>\n
          Use the \/usr\/local\/cpanel\/bin\/update_horde_config<\/code> script with the --full<\/code> option, where USERNAME<\/code> is the cPanel account\u2019s username:<\/p>\n
          \n
          \/usr\/local\/cpanel\/bin\/update_horde_config --user=<\/span>USERNAME --full<\/code><\/pre>\n<\/div>\n
          \n
          Note:<\/div>\n
          \n
          The --full<\/code> option instructs the script to perform the full table schema check and upgrade\/repair instead of only<\/strong> checking whether the database exists.<\/p>\n<\/p><\/div>\n<\/div>\n
          Upgrade tables or create missing tables in the existing databases for all users on the system<\/h4>\n
          Run the following script:<\/p>\n
          \n
          \/usr\/local\/cpanel\/bin\/update_horde_config --full<\/code><\/pre>\n<\/div>\n
          \n
          Warning:<\/div>\n
          \n
          This script may require significant time to execute on systems with many accounts.<\/p>\n<\/p><\/div>\n<\/div>\n
          Move and re-create a new horde database for a cPanel user with the default calendars and address books<\/h4>\n
            \n
          1. Move the user\u2019s file, where USERNAME<\/code> is the cPanel account\u2019s username:\n
            \n
            mv ~USERNAME\/.cphorde\/horde.sqlite ~USERNAME\/.cphorde\/horde.sqlite.bak<\/code><\/pre>\n<\/div>\n<\/li>\n
          2. Run the following script:\n
            \n
            \/usr\/local\/cpanel\/bin\/update_horde_config --user=<\/span>USERNAME --create-defaults<\/code><\/pre>\n<\/div>\n<\/li>\n<\/ol><\/div>\n","protected":false},"excerpt":{"rendered":"
            Overview cPanel & WHM\u2019s 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. …<\/p>\n","protected":false},"author":1,"featured_media":684,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts\/683"}],"collection":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/comments?post=683"}],"version-history":[{"count":0,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts\/683\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/media\/684"}],"wp:attachment":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/media?parent=683"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/categories?post=683"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/tags?post=683"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}