#1  
Old 3rd March 2006, 10:52
retran retran is offline
Junior Member
 
Join Date: Mar 2006
Posts: 12
Thanks: 0
Thanked 2 Times in 1 Post
Default Update to 2.2.0 killed my data

I updated to 2.2.0 from 2.1.2 using ./setup from the 2.2.0 tarball per instructions. At least I thought following the instructions. All my websites still work, ftp and email still works, and so does the DNS. I noticed a problem when I tried to log in my ISPConfig panel. The username admin did not exist or work. I checked the mysql database for my ISPConfig installation... and all the tables (except dns_*, doctype, sys_dep, sys_modules, and sys_nodes) had been truncated completely, as in all the rows were erased! All my usernames, isp, reseller account info seems to be completely gone.
Yes I know in hindsight I should have backed this database up completely before the upgrade (my last ISPConfig upgrade went through without a hitch so I was caught off guard).

Constructive questions I have now are..

Does ISPConfig by default leave any backups nightly, etc that I can find to rebuild my ISPConfig database?

What could have gone wrong to cause the ISPConfig set to erase all my tables? (So this doesn't happen to others, or to me again.)

Is there a way to get a default data set of ISPConfig database without having to run the setup fresh, if I cannot find a backup I have performed manually?

Last edited by retran; 3rd March 2006 at 10:58.
Reply With Quote
Sponsored Links
  #2  
Old 3rd March 2006, 11:24
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 34,586
Thanks: 792
Thanked 4,983 Times in 3,903 Posts
Default

Quote:
Originally Posted by retran
I updated to 2.2.0 from 2.1.2 using ./setup from the 2.2.0 tarball per instructions. At least I thought following the instructions. All my websites still work, ftp and email still works, and so does the DNS. I noticed a problem when I tried to log in my ISPConfig panel. The username admin did not exist or work. I checked the mysql database for my ISPConfig installation... and all the tables (except dns_*, doctype, sys_dep, sys_modules, and sys_nodes) had been truncated completely, as in all the rows were erased! All my usernames, isp, reseller account info seems to be completely gone.
Yes I know in hindsight I should have backed this database up completely before the upgrade (my last ISPConfig upgrade went through without a hitch so I was caught off guard).

Constructive questions I have now are..

Does ISPConfig by default leave any backups nightly, etc that I can find to rebuild my ISPConfig database?
Therea re no automatic nightly backups. But ISPConfig stores a backup of you database, and ISPConfig files when you start an update. Please check your /tmp folder, if there are any tar.gz files with the database.

Quote:
What could have gone wrong to cause the ISPConfig set to erase all my tables? (So this doesn't happen to others, or to me again.)
Did you get any errors during installation and run the installer a second time without restoring the backups in /tmp first?

Quote:
Is there a way to get a default data set of ISPConfig database without having to run the setup fresh, if I cannot find a backup I have performed manually?
Please check if you had the backups in your /tmp folder as described above.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 3rd March 2006, 11:36
retran retran is offline
Junior Member
 
Join Date: Mar 2006
Posts: 12
Thanks: 0
Thanked 2 Times in 1 Post
Default

Two things I checked...

I checked the /tmp directory and found no .tar.gz files (just a bunch of files prefixed "sess_"). Are there any other directories I can check for a dump of the database? This system is the latest release of Debian.

I did not get any apparent errors during installation, and only ran it once. I did notice a "mysqldump: Got errno 28 on write". I have not run anything else since. The following is cut & pasted results from the end of the install procedure if they give any clue.

Connected successfully to db ispconfig
mysqldump: Got errno 28 on write
Restarting some services...
Stopping mail transport agent: Postfix.
Starting mail transport agent: Postfix.
Shutting down ISPConfig system...
/root/ispconfig/httpd/bin/apachectl stop: httpd (no pid file) not running
ISPConfig system stopped!
Starting ISPConfig system...
/root/ispconfig/httpd/bin/apachectl startssl: httpd started
No results found!ISPConfig system is now up and running!
Congratulations! Your ISPConfig system is now installed. If you had to install quota, please take the steps described in the installation manual. Otherwise your system is now available without reboot.
Reply With Quote
  #4  
Old 3rd March 2006, 16:46
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
Default

Quote:
Originally Posted by retran
mysqldump: Got errno 28 on write
That's the error - the installer couldn't create the SQL dump of the old ISPConfig database which is later on used to copy the existing values to the new ISPConfig database... Maybe your hard disk is full? Please post the output of
Code:
df -h
__________________
Falko
--
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
  #5  
Old 3rd March 2006, 17:17
Joffar Joffar is offline
Member
 
Join Date: Feb 2006
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by falko
That's the error - the installer couldn't create the SQL dump of the old ISPConfig database which is later on used to copy the existing values to the new ISPConfig database... Maybe your hard disk is full? Please post the output of
Code:
df -h
I think i got the same thing when I upgraded. I didnt notice it rieght away, but when trying to connect to the website I got the same error 28. I am not sure if anything got messed up or not, but a restart fixed the issue with the /root being full... One thing I noticed was that now ISPconfig insist on http://www.blumonkey.org instead of just http://blumonkey.org Any ideas where I can edit so i can get this back to just http://blumonkey.org ?

Last edited by Joffar; 3rd March 2006 at 17:20.
Reply With Quote
  #6  
Old 3rd March 2006, 17:48
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
Default

Quote:
Originally Posted by Joffar
Any ideas where I can edit so i can get this back to just http://blumonkey.org ?
Have a look here: http://www.howtoforge.com/forums/sho...23&postcount=6
__________________
Falko
--
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
  #7  
Old 4th March 2006, 23:29
retran retran is offline
Junior Member
 
Join Date: Mar 2006
Posts: 12
Thanks: 0
Thanked 2 Times in 1 Post
Default

That might have been the problem, my tmpfs being full at the time. What happens now? Is all my ISPConfig database lost forever or is there a way to rebuild it? Some script to make the process easier to glean usernames & such from the httpd.conf file? What's the best way to go about it?
Reply With Quote
  #8  
Old 5th March 2006, 15:08
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
Default

Does your old ISPConfig database still exist? Then make an SQL dump of it (like this: http://www.howtoforge.com/faq/6_3_en.html ).
Then remove /root/ispconfig and /home/admispconfig and the ISPConfig database and make a completely fresh ISPConfig installation. Afterwards you overwrite your new ISPConfig database with the data from the SQL dump ( http://www.howtoforge.com/faq/6_4_en.html ). That's it.
__________________
Falko
--
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
  #9  
Old 6th March 2006, 12:57
retran retran is offline
Junior Member
 
Join Date: Mar 2006
Posts: 12
Thanks: 0
Thanked 2 Times in 1 Post
Default

Actually, from what I can tell my existing old ISPConfig database is of little worth becasue all the tables in it are empty. The old one was wiped out per this Install process because the ISPConfig upgrade did not halt when it encountered the mysqldump error! Instead it continued on with wiping my good database info away without a dump of data to repopulate it.

I guess a fact I want to make clear, is that I could not get the tar.gz file of the database dump made during the upgrade process because it was never created because the /tmp device was full at the time of the upgrade.

With all this in mind, is my only option to rebuild ISPConfig from scratch, and then manually add and configure all my websites manually? Is there nowhere else to look? Is this one of those hard lessons learned that before upgrading ISPConfig I should have made a manual backup as well?

Last edited by retran; 6th March 2006 at 13:06.
Reply With Quote
  #10  
Old 6th March 2006, 19:17
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
 
Default

Quote:
Originally Posted by retran
With all this in mind, is my only option to rebuild ISPConfig from scratch, and then manually add and configure all my websites manually?
Yes, that's the only option. The database is the heart of ISPConfig.
__________________
Falko
--
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
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
Updating ISPConfig via Update Manager viewport Installation/Configuration 3 9th September 2007 22:59
apt-get update command is not functioning. Hans Installation/Configuration 5 31st July 2006 16:18
ISPConfig 2.2.0 released till General 17 7th April 2006 04:39
Update to 2.2.0 question brianetilley Installation/Configuration 10 4th March 2006 17:02
Update from 2.0.7 to 2.0.8 brody Installation/Configuration 7 31st August 2005 16:37


All times are GMT +2. The time now is 07:37.


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