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.

Horde database deleted by cPanel upgrade!

Discussion in 'Database Discussions' started by Ivalde, Jan 22, 2010.

  1. Ivalde

    Ivalde Registered

    Joined:
    Jan 22, 2010
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    From within WHM this evening I carried out a cPanel upgrade, to receive the latest version cPanel 11.24.5-S38506 - WHM 11.24.2 - X 3.9.

    The upgraded system ends up in the following error message when I log into the Horde webmail:

    A fatal error has occurred
    DB Error: no such database
    Details have been logged for the administrator

    The log file tells me the following:
    HORDE [emergency] [horde] DB Error: no such database: [nativecode=1049 ** Unknown database 'horde'] …

    What did happen with the Horde database during the cPanel upgrade process? Did the upgrade process delete the Horde database? Unbelievable!!! In such case, all the user's preferences are gone!!!

    How to sort it out? How to bring the Horde database back?
     
  2. thewebhosting

    thewebhosting Well-Known Member

    Joined:
    May 9, 2008
    Messages:
    1,201
    Likes Received:
    1
    Trophy Points:
    38
    If you have an database backup then you can restore the Horde database backup from the available backup.
     
  3. Ivalde

    Ivalde Registered

    Joined:
    Jan 22, 2010
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Upgrade scripts bugs bugs

    The horde database has now been regenerated from backup, after the fatal database deletion carried out by the cPanel upgrade process. Without this MySQL database backup system set up some months ago, all the user’s preferences etc. would have been lost forever. How is this possible? I know the horde database has been redesigned over some time, the histories table is not included any longer as an example.

    Was that the original intention of the upgrade script? To drop the histories table? Then the script dropped the complete database instead? Bugs bugs bugs. Can we thrust the upgrade scripts for the future?
     
  4. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,458
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    There was a logic flaw in the Horde update scripts that caused this. The problem is resolved in 11.25.0
     
  5. borki

    borki Member

    Joined:
    Jan 9, 2006
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    We have no Horde-DB backup - or is this done automatically with cpanel-backup? Should we create a new empty db?
     
  6. cPanelJared

    cPanelJared Technical Analyst
    Staff Member

    Joined:
    Feb 25, 2010
    Messages:
    1,842
    Likes Received:
    18
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Check /var/cpanel/horde

    There may be a dump of the Horde database in /var/cpanel/horde. The file format would be horde.backup.sql.XXXXXXXXXX. You can restore the database by first making sure the database exists, creating it if necessary, then importing from the dump using a command like this:

    Code:
    # mysql -uroot -p horde < horde.backup.sql.XXXXXXXXXX
    Replace the X characters with the actual numbers in the filename, and enter the MySQL root password when prompted.

    If there is no good backup in /var/cpanel/horde, you can run /scripts/reinstallhorde to completely reinstall Horde with an initial database.
     
  7. borki

    borki Member

    Joined:
    Jan 9, 2006
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    Hi

    OK, this backups were quite old and there was no data inside.. I restored the DB-Files from our normal backup and I just placed the MyISAM Files there.. seems to work...

    Regards
     
Loading...

Share This Page