#1  
Old 31st October 2006, 14:21
eldaria eldaria is offline
Junior Member
 
Join Date: Apr 2006
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Arrow Recovering a server. (Ubuntu)

I have been running my server with the ISPConfig perfect setup for Ubuntu 6.06 64bit since July.
And well, I did the fatal mistake of dist-upgrade my server, which resulted in server stopped working, I found out it is related to me running 64bit on Intel and not AMD.

I gave up trying to fix it and decided to reinstall running 32bit instead, so I followed the Ubuntu 6.10 Perfect setup, and installed latest version of ISPConfig
I have mysql dumps of my databases, and a backup copy of /var/www and /home
The server only had 1 site with 4 mail users.

What is the easiest or quickest aproach to restore the site, mail and user details?

Should I just import the db_ispconfig sql dump, and then restore the files in /var/www?

Or is there more to it?
Reply With Quote
Sponsored Links
  #2  
Old 31st October 2006, 15:05
pillul pillul is offline
Junior Member
 
Join Date: Aug 2006
Posts: 23
Thanks: 2
Thanked 0 Times in 0 Posts
Default

Hello,
i had the same Problem yesterday i fixed it that way:

put your /srv/var/ files where they belong (the files of your homepage).
And create a databse named ispconfig, in which you dump your backup of the old isp tables.
Then install ispconfig, and give him this database information. Isp regcognizes that there are webs customers etc and you can use thema as before .

Plz keep your backups i can give you no garrantie

In my Case it worked perfect
Reply With Quote
  #3  
Old 31st October 2006, 15:50
eldaria eldaria is offline
Junior Member
 
Join Date: Apr 2006
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hmm, I already installed Ispconfig.

Did your method create the nessesary DNS entries, user accounts etc?
Reply With Quote
  #4  
Old 31st October 2006, 15:57
pillul pillul is offline
Junior Member
 
Join Date: Aug 2006
Posts: 23
Thanks: 2
Thanked 0 Times in 0 Posts
Default

yes because this information is stored in the database !

in my case isp was installed but i lost the "home" directory, so i uninstalled, kept the database and the files stored in /var/www/webxxx/ and reinstalled.

I gave the ISP Installer, the existing domain and it runs as before =)
Reply With Quote
  #5  
Old 31st October 2006, 16:33
eldaria eldaria is offline
Junior Member
 
Join Date: Apr 2006
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Interesting, the reason I wonder is that I know ISPConfig created entries in /etc/passwd

But of course I forgot to backup that part before reinstalling.

Did you wipe the drive before installing again? or how did you "Uninstall"?

I had a complete Wipe, so only thing I still have are the SQL dumps, the Home directory(Not used by ISPConfig) and the /var/www (Containing webs, and user Maildir)
Reply With Quote
  #6  
Old 31st October 2006, 20:38
eldaria eldaria is offline
Junior Member
 
Join Date: Apr 2006
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Question

Is there perhaps a developer here who knows how ISP config behaves when importing an existing database into a clean system?

Does it create all the nessesary directories and entries in files?

Regards.
Brian.
Reply With Quote
  #7  
Old 1st November 2006, 13:11
pillul pillul is offline
Junior Member
 
Join Date: Aug 2006
Posts: 23
Thanks: 2
Thanked 0 Times in 0 Posts
Default

With the installation Package comes an uninstaller, i used this. here you can say keep data.

How many webs and customer did you have in your ISP ?
Reply With Quote
  #8  
Old 1st November 2006, 13:20
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,022
Thanks: 840
Thanked 5,655 Times in 4,464 Posts
Default

Quote:
Originally Posted by eldaria
Is there perhaps a developer here who knows how ISP config behaves when importing an existing database into a clean system?

Does it create all the nessesary directories and entries in files?
ISPConfig does not recreate the items when you import a existing database, but you can manipulate the ISPConfig database to let ISPConfig behave like the webs where newly added and it will make the directories and users for you.

1) Install the same ISPConfig version then on your old system.
2) Make a backup of the new database, then replace everything in your new database with the data from your old database exxept of the tables isp_server, doctype and isp_server_ip.
3) Use e.g. phpmyadmin to set the field "status" to the value "n" (n = new) in the tables:

isp_isp_web
isp_isp_user
dns_isp_dns
isp_isp_domain
isp_isp_datenbank

4) Change one value in one website, e.g. the quota value in the ISPConfig interface and ISPConfig will start to write all websites and users to disk again.

The only thing ISPConfig is not able to restore are the passwords for the users as they are not stored in the ISPConfig database, they are only stored in /etc/shadow and if I read the thread correctly you have lost this file?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #9  
Old 1st November 2006, 14:42
eldaria eldaria is offline
Junior Member
 
Join Date: Apr 2006
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes I don't have the files from /etc anymore.

I was able to recreate everything by setting up the web with the same settings as it was except the users, after that I restored /var/www.

Now the website worked, but none of the mail or sql dependant pages.

So I restored the mysql databases, including the db_ispconfig and mysql database and ISPConfig actually did recreate all users in /etc/passwd but not in /etc/shadow.

So this is lost and I will have to ask all users so I can set up their passwords again manually.

For the future, what is a good backup plan for ISPconfig? to be able to recover quickly?
I'm thinking in the terms of rsync to a second drive or file server.
Reply With Quote
  #10  
Old 1st November 2006, 18:08
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,752 Times in 2,582 Posts
 
Default

Quote:
Originally Posted by eldaria
For the future, what is a good backup plan for ISPconfig? to be able to recover quickly?
I'm thinking in the terms of rsync to a second drive or file server.
Have a look here: http://www.howtoforge.com/taxonomy_menu/1/34
__________________
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
php Apps email not going through palkat General 8 21st September 2011 06:35
Statistic not working mzo Installation/Configuration 49 20th April 2011 13:19
Setting up a backup mail server setup with two installations of ISPConfig zitch Tips/Tricks/Mods 7 30th December 2006 11:07
Email - Ueb-Miau mazhar Installation/Configuration 5 21st December 2005 11:01
The Perfect Setup Suse 9.3 - Postfix problems new_bee05 HOWTO-Related Questions 20 25th November 2005 03:30


All times are GMT +2. The time now is 01:51.


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