Horde database deleted by cPanel upgrade!

Ivalde

Registered
Jan 22, 2010
2
0
51
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?
 

thewebhosting

Well-Known Member
May 9, 2008
1,199
1
68
If you have an database backup then you can restore the Horde database backup from the available backup.
 

Ivalde

Registered
Jan 22, 2010
2
0
51
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?
 

cPanelKenneth

cPanel Development
Staff member
Apr 7, 2006
4,607
79
458
cPanel Access Level
Root Administrator
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?
There was a logic flaw in the Horde update scripts that caused this. The problem is resolved in 11.25.0
 

borki

Member
Jan 9, 2006
17
0
151
We have no Horde-DB backup - or is this done automatically with cpanel-backup? Should we create a new empty db?
 

JaredR.

Well-Known Member
Feb 25, 2010
1,834
24
143
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.
 

borki

Member
Jan 9, 2006
17
0
151
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