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

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 1st February 2012, 21:11
snowfly snowfly is offline
Member
 
Join Date: Jul 2006
Posts: 91
Thanks: 0
Thanked 4 Times in 3 Posts
Default Moving sites/databases between multi-server setup?

Is it possible to move sites/databases/ftp-users between servers that are part of a multi-server ISPConfig 3.0.4.2 setup?

We want to move selected sites/database/ftp-users from serverX (debian 6.0 ISPConfig 3.0.4.2) to serverY (debian 6.0 ISPConfig 3.0.4.2), and preserve all site settings, & database/ftp passwords.

Both servers are setup exactly the same, but have different resources (e.g. more ram/disk/cpu)

The Server dropdown box in the ISPConfig control panel is disabled for existing sites/databases.

I would presume something like this, but not sure correct methods:
- copy site/database/ftp config to new server
- mirror data across to new server (rsync/ftp)
- delete site/database/ftp config from old server

Anyone else done this?
Reply With Quote
Sponsored Links
  #2  
Old 7th February 2012, 18:05
patrick3853 patrick3853 is offline
Member
 
Join Date: Dec 2008
Posts: 30
Thanks: 3
Thanked 7 Times in 3 Posts
Default

I did this several times in ISPConfig2 but haven't in version 3. You are on the right track, but I'm assuming serverY has a different IP address. After you have migrated the databases and files, you will have to do a find/replace on all the config files and replace the serverX's IP with serverY's IP. If you are running bind9 or another DNS be sure to update the IP in all the zone files. I will try to dig up the post I made on this with version 2 but it's been a few years. Hopefully that will get you started in the right direction.
Reply With Quote
  #3  
Old 7th February 2012, 18:15
patrick3853 patrick3853 is offline
Member
 
Join Date: Dec 2008
Posts: 30
Thanks: 3
Thanked 7 Times in 3 Posts
Default

http://www.howtoforge.com/forums/sho...?t=2760&page=2

Check out my post towards the bottom of this page. It is regarding ISPConfig2 but should give you an idea of what you need to do for the IP address.

Also read the last post directly below mine. Instead of running the sql queries I would recommend using mysqldump to generate a backup of the ISPConfig database, then do the perl on-liner on the sql backup file, and import it back into the database. This way you won't miss any occurrences of the old IP address

Last edited by patrick3853; 7th February 2012 at 18:19.
Reply With Quote
  #4  
Old 7th February 2012, 22:58
zbuzanic zbuzanic is offline
Member
 
Join Date: Sep 2011
Location: Zagreb
Posts: 79
Thanks: 43
Thanked 20 Times in 13 Posts
Default

I've migrated few sites recently:

- first backup site & db
- delete site / db
- change DNS (A record and everything else you need)
- create site & db & ftp on new server with same username/password
- extract site content to appropriate dir (be careful with stats dir and with permissions)
- import db

That should do it, I didn't had any problems after migration except with stats folder but fixed it with right permissions
__________________
ISPConfig -> the best open source control panel
Reply With Quote
  #5  
Old 22nd February 2012, 11:16
snowfly snowfly is offline
Member
 
Join Date: Jul 2006
Posts: 91
Thanks: 0
Thanked 4 Times in 3 Posts
Default

Quote:
Originally Posted by zbuzanic View Post
I've migrated few sites recently:

- first backup site & db
- delete site / db
- change DNS (A record and everything else you need)
- create site & db & ftp on new server with same username/password
- extract site content to appropriate dir (be careful with stats dir and with permissions)
- import db

That should do it, I didn't had any problems after migration except with stats folder but fixed it with right permissions
Thanks, that looks fairly straight forward.

The main concern I had about deleting the current site (on serverX) and creating a new site (on serverY) would create a new domain/web ID, and new owner, and whether that caused any issues.

I'll try and setup a dev server and do a dummy run first.
Reply With Quote
  #6  
Old 22nd February 2012, 11:18
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,169
Thanks: 829
Thanked 5,412 Times in 4,255 Posts
Default

It creates a new webID user, but this should not matter when you chown the files to the new username after you uploaded them to the other server.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #7  
Old 28th February 2012, 10:00
snowfly snowfly is offline
Member
 
Join Date: Jul 2006
Posts: 91
Thanks: 0
Thanked 4 Times in 3 Posts
Default

I've got a bunch of sites to move (30+), but need to have the same ftp user/passwd settings and same database user/passwd on the new server.

It appears these passwords are encrypted in the dbispconfig database, so how do I re-create these sites/ftp/database on the new server using the same passwords?

Is that possible?
I do not know the passwords, this is on behalf of a client.
Reply With Quote
  #8  
Old 29th February 2012, 12:33
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

FTP users authenticate directly against the ISPConfig database, so you can simply copy the encrypted passwords.
__________________
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 29th February 2012, 12:36
snowfly snowfly is offline
Member
 
Join Date: Jul 2006
Posts: 91
Thanks: 0
Thanked 4 Times in 3 Posts
Default

Quote:
Originally Posted by falko View Post
FTP users authenticate directly against the ISPConfig database, so you can simply copy the encrypted passwords.
Thanks, that will work.

Doesn't help the mysql database passwords though.
I may have to write a script which trawls through any website files and looks for php mysql_connect password settings, and use those to move the database across to the new server.
Reply With Quote
  #10  
Old 29th February 2012, 12:57
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,169
Thanks: 829
Thanked 5,412 Times in 4,255 Posts
 
Default

Quote:
Doesn't help the mysql database passwords though.
I may have to write a script which trawls through any website files and looks for php mysql_connect password settings, and use those to move the database across to the new server.
This works for the mysql database passwords as well. You dont have to reset any passwords in your site scripts as you can copy over the mysql permission records from the old to the new mysql database.
__________________
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
ISPConfig 3.0.3.3 fresh instalation - email tab is empty artur_gib Installation/Configuration 14 28th January 2014 19:02
local ip:8080 just downloads a file called download or index.php dr_patso Installation/Configuration 5 20th September 2011 20:54
Virtual Users+Postfix+Courier+CentOS problem telnet localhost 25 stinson HOWTO-Related Questions 11 5th February 2011 13:57
FTP cannot open remote folder!?! andysm849 Server Operation 23 16th October 2008 23:34
The Perfect Setup - Debian Etch (Debian 4.0) some trouble daniel80 HOWTO-Related Questions 26 1st February 2008 16:30


All times are GMT +2. The time now is 11:49.


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