Roundcube Address Book not in backups.

[beddo]

Howdy folks,

We had some users with Roundcube issues after updating to 11.40. I researched the error and saw that people fixed it by recreating the Roundcube databases.

So I did this and the errors went away. Unfortunately I then discovered that the Roundcube Address Books and autocompletes are stored in the central Roundcube database and had been erased.

I expected that user data would be stored with the account rather than in a central location as this means that the account backups will not include Address Books etc.

I have a the cPanel backup of the mysql directory for the roundcube table but so far I have been unable to restore it and have mysql load the data.

Anyone know how to get the data back and how to have cPanel back up the data associated with the accounts properly?

 

[cPanelMichael]

We had some users with Roundcube issues after updating to 11.40. I researched the error and saw that people fixed it by recreating the Roundcube databases.

Could you elaborate on the specific issue you encountered with Roundcube after updating to cPanel version 11.40? Did you receive any specific error messages? Do you have the specific threads where this was discussed?

I have a the cPanel backup of the mysql directory for the roundcube table but so far I have been unable to restore it and have mysql load the data.

What method are you using to restore this database? Is it generating an error when you attempt to restore the data?

Note: You can convert Roundcube to SQLite to ensure all Roundcube data is stored within the individual account going forward. The script to use for this is:

/usr/local/cpanel/scripts/convert_roundcube_mysql2sqlite

Thank you.

 

[beddo]

The error was "service currently not available 500"

I googled and came up with a number of people discussing it. The only backup of the roundcube database that cPanel generates is when it backs up the /var/lib/mysql folder so I extracted that and tried to start mysql with the files swapped out. It didn't complain about anything but the users tell me their address books are still emtpy.

Once it is restored I will convert to sqlite but not before!

 

[cPanelMichael]

Feel free to open a support ticket so we can take a closer look:

Submit A Ticket

You can post the ticket number here so we can update this thread with the outcome.

Thank you.

 

[beddo]

I already have a ticket (4378671) and the outcome so far is not good. Apparently what I have already done should have restored the database but it hasn't :/

Edit: Thankfully cPanel takes backups of Roundcube at /var/cpanel/roundcube. Having been made aware of this by support I have restored it. When my clients confirm their data is present I will convert to SQLite unless there are any serious disadvantages to doing so.

 

[cPanelMichael]

IEdit: Thankfully cPanel takes backups of Roundcube at /var/cpanel/roundcube. Having been made aware of this by support I have restored it. When my clients confirm their data is present I will convert to SQLite unless there are any serious disadvantages to doing so.

I am happy to hear you were able to restore the data from the backup databases in /var/cpanel/roundcube.

Thank you.

 

[nootkan]

Note: You can convert Roundcube to SQLite to ensure all Roundcube data is stored within the individual account going forward. The script to use for this is:

/usr/local/cpanel/scripts/convert_roundcube_mysql2sqlite

I tried to run this script and received the following errors:

Successful creation of roundcube cp_schema_version table
DBD::SQLite::st execute failed: column name is not unique at /usr/local/cpanel/scripts/convert_roundcube_mysql2sqlite line 410.
Conversion was not successful: column name is not unique
Conversion of roundcube XML dump to sqlite database failed
warn [convert_roundcube_mysql2sqlite] Conversion was not successful for user 'domain'.
Successful creation of roundcube cp_schema_version table
DBD::SQLite::st execute failed: column name is not unique at /usr/local/cpanel/scripts/convert_roundcube_mysql2sqlite line 410.
Conversion was not successful: column name is not unique
Conversion of roundcube XML dump to sqlite database failed
warn [convert_roundcube_mysql2sqlite] Conversion was not successful for user 'domain'.
Successful creation of roundcube cp_schema_version table
DBD::SQLite::st execute failed: column name is not unique at /usr/local/cpanel/scripts/convert_roundcube_mysql2sqlite line 410.
Conversion was not successful: column name is not unique
Conversion of roundcube XML dump to sqlite database failed
warn [convert_roundcube_mysql2sqlite] Conversion was not successful for user 'domain'.
Successful creation of roundcube cp_schema_version table
DBD::SQLite::st execute failed: column name is not unique at /usr/local/cpanel/scripts/convert_roundcube_mysql2sqlite line 410.
Conversion was not successful: column name is not unique
Conversion of roundcube XML dump to sqlite database failed
warn [convert_roundcube_mysql2sqlite] Conversion was not successful for user 'domain'.
Successful creation of roundcube cp_schema_version table
DBD::SQLite::st execute failed: column name is not unique at /usr/local/cpanel/scripts/convert_roundcube_mysql2sqlite line 410.
Conversion was not successful: column name is not unique
Conversion of roundcube XML dump to sqlite database failed
warn [convert_roundcube_mysql2sqlite] Conversion was not successful for user 'domain'.
warn [convert_roundcube_mysql2sqlite] Roundcube Mysql to sqlite conversion was not completely successful. Please check /usr/local/cpanel/logs/roundcube_sqlite_convert_log for details.

How do I revert back to the mysql database? Now my roundcube email won't work. The login icon still shows under webmail but I get a "database error" message when I click on it. It is shown as disabled under tweak settings.

 

[beddo]

I don't think you need to convert back. The script tries to convert the data and only changes roundcube over if the conversion is successful. I had the same problem and never actually got it converted.

 

[nootkan]

Unfortunately for me it screwed up my roundcube installation as it won't work anymore. I just get a database error message

DATABASE ERROR: CONNECTION FAILED! Unable to connect to the database! Please contact your server-administrator.

when I try to open roundcube. Wish I hadn't done it as I am having issues with squirrel mail and horde mail. Roundcube was the only webmail program working until I decided to make it better.

 

[nootkan]

I opened a ticket and one of the cPanel support staff updated roundcube for me which fixed my problems. Whew!! Thanks to the support staff much appreciated. :D