The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Roundcube Address Book not in backups.

Discussion in 'E-mail Discussions' started by beddo, Oct 25, 2013.

  1. beddo

    beddo Well-Known Member

    Joined:
    Jan 19, 2007
    Messages:
    157
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    England
    cPanel Access Level:
    DataCenter Provider
    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?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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?

    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:

    Code:
    /usr/local/cpanel/scripts/convert_roundcube_mysql2sqlite 
    Thank you.
     
  3. beddo

    beddo Well-Known Member

    Joined:
    Jan 19, 2007
    Messages:
    157
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    England
    cPanel Access Level:
    DataCenter Provider
    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!
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  5. beddo

    beddo Well-Known Member

    Joined:
    Jan 19, 2007
    Messages:
    157
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    England
    cPanel Access Level:
    DataCenter Provider
    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.
     
    #5 beddo, Oct 26, 2013
    Last edited: Oct 26, 2013
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    I am happy to hear you were able to restore the data from the backup databases in /var/cpanel/roundcube.

    Thank you.
     
  7. nootkan

    nootkan Well-Known Member

    Joined:
    Oct 25, 2006
    Messages:
    129
    Likes Received:
    2
    Trophy Points:
    18
    I tried to run this script and received the following errors:

    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.
     
    #7 nootkan, Dec 11, 2013
    Last edited: Dec 11, 2013
  8. beddo

    beddo Well-Known Member

    Joined:
    Jan 19, 2007
    Messages:
    157
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    England
    cPanel Access Level:
    DataCenter Provider
    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.
     
  9. nootkan

    nootkan Well-Known Member

    Joined:
    Oct 25, 2006
    Messages:
    129
    Likes Received:
    2
    Trophy Points:
    18
    Unfortunately for me it screwed up my roundcube installation as it won't work anymore. I just get a database error message
    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. :mad:
     
    #9 nootkan, Dec 11, 2013
    Last edited: Dec 11, 2013
  10. nootkan

    nootkan Well-Known Member

    Joined:
    Oct 25, 2006
    Messages:
    129
    Likes Received:
    2
    Trophy Points:
    18
    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
     
Loading...

Share This Page