Skip to main content
We are aware of an issue after updating to cPanel versions 11.110.0.65, 11.126.0.21, or 11.128.0.11, some cPanel plugins or features are no longer functioning properly including WP Toolkit. Please see the following article for more information and updates:
Update to latest cPanel 110, 126, or 128 versions removes "addonfeatures" directory.

Roundcube contacts not restored after account transfer

Vijai
Hello, I recently transferred an account using transfer tool from whm and everything works except that I noticed that the roundcube database has not been restored and the log says the database is corrupt? I'm able to browse the database from whm->phpmyadmin fine and can also export it from the old server. Regards, Vijai

Comments

6 comments

Date Votes
  • 24x7server
    Hi, Did you check the restore logs at the time when you restored the account on the new server? How to Rebuild the Roundcube Database - cPanel Knowledge Base - cPanel Documentation Check if above link is of some help.
    0
  • Vijai
    Well, before starting the transfer, I rebuilt the db and then initiated the transfer. It failed despite that. So I just opened phpmyadmin from whm and dumped the roundcube mysql database and have a backup of it now. Will check the logs and post the exact log here once I find something meaningful. Edit: Here is the log.
    RANSFER: 4 completed, 0 had warnings, and 0 failed. RESTORE: 4 completed, 1 had warnings, and 0 failed. RESTORE: Account "user": Warnings Removed empty DB for failed restore of "roundcube". The system has saved the database archive data in the directory "/home/user/cpmove_failed_mysql_dbs.1511537827". You may use this directory"s contents to restore your data manually. This account archive does not contain a domain named "ipv6.domain.com". The system will not add this domain to the restored account"s AutoSSL exclusions. The "Roundcube" restore module failed because of an error: The MySQL server reported an error (Table 'contactgroupmembers' already exists) in response to this request: CREATE TABLE `contactgroupmembers` ( `contactgroup_id` int(10) unsigned NOT NULL, `contact_id` int(10) unsigned NOT NULL, `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', PRIMARY KEY (`contactgroup_id`,`contact_id`), KEY `contactgroupmembers_contact_index` (`contact_id`), CONSTRAINT `contact_id_fk_contacts` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`contact_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `contactgroup_id_fk_contactgroups` FOREIGN KEY (`contactgroup_id`) REFERENCES `contactgroups` (`contactgroup_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1 at /usr/local/cpanel/Whostmgr/Transfers/SystemsBase/MysqlBase.pm line 280, <$_[...]> line 231.
    Surprisingly, I see no database for roundcube in phpmyadmin neither do I see individual user db in
    /home/user/etc/domain
    Could the database be dropped since there was an error?
    0
  • Vijai
    Hello, So I opened a support ticket on 25th November and the support representative was provided access to both old and new server. He told that both the server reflects some error while converting the mysql db to sqlite and he's not able to solve it and is escalating the ticket to a L2 analyst. Since then, I'm not able to use webmail (Roundcube was functioning before with just no user data from previous server like identities, signatures and contacts) and shows error.
    [2017-11-28 10:52:21 +0530] info [webmaild] [fcgi] PHP message: PHP Warning: touch(): Unable to create file /home/admin/etc/domain.com/user.rcube.db because Permission denied in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db_sqlite.php on line 38 PHP message: PHP Warning: file_put_contents(/home/admin/tmp/errors): failed to open stream: Permission denied in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube.php on line 1259 PHP message: PHP Warning: SQLSTATE[HY000] [14] unable to open database file in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube.php on line 1364 PHP message: PHP Warning: file_put_contents(/home/admin/tmp/errors): failed to open stream: Permission denied in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube.php on line 1259 PHP message: PHP Warning: SQLSTATE[HY000] [14] unable to open database file in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube.php on line 1364
    Ticket number is: 9059709 Can somebody help me solve this please? Using squirrel mail seems like using 90's webmail client. Regards, Vijai
    0
  • Infopro
    he's not able to solve it and is escalating the ticket to a L2 analyst.

    That ticket was just closed by you, stating Roundcube was now working. All set?
    0
  • Vijai
    That ticket was just closed by you, stating Roundcube was now working. All set?

    Yes. You were just right on time. I received a complimentary phone support and the person on phone support solved it. The issue was something to do with right permission not being set. He updated the permissions and forced a roundcube database rebuild using the below command which fixed it.
    /scripts/mailperm /usr/local/cpanel/bin/update-roundcube-db --force
    0
  • Infopro
    Happy to hear things are going again for you.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post