Skip to main content

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?

Comments

6 comments

Date Votes
  • cPanelMichael
    [quote="beddo, post: 1490351"> 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? [quote="beddo, post: 1490351">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.
    0
  • 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!
    0
  • 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.
    0
  • 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.
    0
  • cPanelMichael
    [quote="beddo, post: 1491051">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.
    0
  • 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.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post