Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 11th October 2006, 21:23
jdell jdell is offline
Junior Member
 
Join Date: Oct 2005
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Unhappy CentOS 4.4 - upgrade 2.2.6 -> 2.2.7 wiped ispconfig db

Hi All,

Word of warning (and glad I did my backups first). I just upgraded from 2.2.6 to 2.2.7, and the entire contents of the ispconfig mysql database (all tables) were deleted.

At the end of the upgrade, I got the message:

All prerequisites are fulfilled.
Here we go...

Connected successfully to db ispconfig

and then a bunch of php mysql_fetch_array(): supplied argument is not a valid MySQL result resource (because the tables were missing).

I restored the mysql ispconfig db, and everything was fine again. Just to be safe, I re-ran the install against the existing 2.2.7 install, and everything went fine.

So, I have no idea why/how that happened, but do your backups.
Reply With Quote
Sponsored Links
  #2  
Old 11th October 2006, 21:49
jdell jdell is offline
Junior Member
 
Join Date: Oct 2005
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default Server setup

Forgot to mention that I'm running MySQL 4.1.21 (using the RHEL4 RPM's from http://dev.mysql.com/downloads/mysql/4.1.html)

Also, I've been running ISPConfig since the 2.0.x days and upgrading the same way each time. This is the first time I've had a problem with the db.
Reply With Quote
  #3  
Old 12th October 2006, 10:20
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,421
Thanks: 812
Thanked 5,205 Times in 4,081 Posts
 
Default

Quote:
Originally Posted by jdell
Hi All,

Word of warning (and glad I did my backups first). I just upgraded from 2.2.6 to 2.2.7, and the entire contents of the ispconfig mysql database (all tables) were deleted.

At the end of the upgrade, I got the message:

All prerequisites are fulfilled.
Here we go...

Connected successfully to db ispconfig

and then a bunch of php mysql_fetch_array(): supplied argument is not a valid MySQL result resource (because the tables were missing).

I restored the mysql ispconfig db, and everything was fine again. Just to be safe, I re-ran the install against the existing 2.2.7 install, and everything went fine.

So, I have no idea why/how that happened, but do your backups.

This happens if the databse username and password in the ISPConfig config.inc.php file are incorrect or if ISPConfig is not able to connect to your mysql database because it is stopped.

ISPConfig is doing a abackup of the database and the directories /root/ispconfig and /home/admispconfig automatically before the update in your /tmp directory. So you will just have to unpack these tar.gz files to their original locations, make sure that the mysql connection is possible and ran the update again.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
CentOS 4.4 mysql5 php5 upgrade hoihtah Installation/Configuration 6 7th November 2006 16:46
Upgrade CentOs 4.3 to 4.4 help? Herbert Installation/Configuration 2 18th September 2006 11:28
ISPConfig on CentOS 4.4 pkardono Installation/Configuration 2 8th September 2006 08:02
Upgrading failed, ispconfig broken and ispconfig won't upgrade again dfriis Installation/Configuration 7 14th June 2006 17:54
Install ISPConfig on CentOS Server, in brief gfts Tips/Tricks/Mods 11 4th April 2006 08:29


All times are GMT +2. The time now is 22:08.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.