Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Thread Tools Display Modes
Old 13th November 2010, 09:39
Devan879 Devan879 is offline
Junior Member
Join Date: Nov 2010
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Bug? in how Ispconfig 3 does upgrade installs.

Default Bug? in how Ispconfig 3 does upgrade installs.
Not going to go hunting the bug tracker, at least right now. Still trying to rebuild information from backups and accessory files.

When Ispconfig does an upgrade, it apparently performs an SQL dump, then wipes the database, and restores the dump. However, there is _no_ error checking during the dump process. IF an error occurs, such as a 'crashed table' (which wasn't a crashed table. Repair tools found nothing wrong, but the system kept reporting it anyway), then the tables below that don't get backed up (in this case, the sys_user, web_database, web_domain, and web_traffic tables - VERY IMPORTANT ONES) get wiped clean during the reload.

The upgrade process SHOULD error out and _stop_ if the database backup fails for any reason. It should never decide that bad data is adequate data.


End result? A number of web sites that are functioning, with working ftp users and databases, but that don't actually exist in ispconfig. (neither sites, nor databases). So, I get to recreate them in the correct order on another machine, export the tables, then import them back in, and hope that everything goes back to normal. (it's too bad you can't tell ispconfig to work backwards from the actual files on the server to rebuild what should be in the database)
Thanks Reply With Quote Multi-Quote This Message Quick reply to this message
Reply With Quote
Sponsored Links
Old 14th November 2010, 20:34
falko falko is offline
Super Moderator
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,751 Times in 2,581 Posts

I've added this to our bugtracker.
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Old 21st November 2010, 10:52
till till is offline
Super Moderator
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,652 Times in 4,461 Posts

1) ISPConfig checks for errors in the dump process. If your table was crashed and even mysql reported is as not broken, how shall ispconfig know that it is broken.
2) The whole topic applies only to versions < ispconfig 3.0.3 as ispconfig 3.0.3 and do incremental database updates and not dumps anymore.
Till Brehm
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote


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
Upgrade Ubuntu 9.04 with ISPConfig 3 to 9.10 sheshes Installation/Configuration 3 5th November 2009 15:44
If I upgrade ISPConfig do I will lose the master-master replication? voltron81 General 2 13th October 2009 14:49
ispconfig dir deleted during upgrade oriongr Installation/Configuration 2 7th May 2008 13:01
ISPConfig 2.3.3-dev released till General 10 12th March 2008 22:08
Upgrade FC4 to FC5 in ISPConfig cybereatl Installation/Configuration 2 23rd March 2006 00:04

All times are GMT +2. The time now is 17:36.

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