Moving ISPconfig

[juampi]

Hi All!
I need moving ISPconfig from Server A to Server B.
Server A is a server in production. This must be repaire. I need moving all ispconfig: acounts, emails, passwords, webs...
I have backup of Server A:
/etc
/home/www
/var/lib/mysql

How can i do it?.

I think make:
1- Install software in Server B: postfix, mysql, php, apache, courier, proftpd and others.
2- Install a new ISPconfig
3- Replace the files /etc /home /var/lib/mysql

Is it correct?

I can't install a software for backup. I only can use scp or rsync.

Regards,

[falko]

Make a backup of /etc/passwd, /etc/shadow, /etc/group, Vhosts_ispconfig.conf, /etc/postfix/local-host-names, /etc/postfix/virtusertable, named.conf, all the pri.* zone files, /etc/proftpd*.conf. Also create sql dumps of your MySQL databases (either with phpMyAdmin or on the command line: http://www.howtoforge.com/faq/6_3_en.html ) and make a backup of /home/www on the old server:

cd /home
tar -pczf www.tar.gz www/
Stop Postfix: /etc/init.d/postfix stop
If you use mbox, also make a backup of /var/spool/mail:
cd /var/spool
tar -pczf mail.tar.gz mail/ If you use Maildir, the mailboxes are included in www.tar.gz.

On the new server:
First install ISPConfig.
Create the databases from the sql dumps (either with phpMyAdmin or like this: http://www.howtoforge.com/faq/6_4_en.html ). Also replace the ISPConfig database with the old one.
Regarding the mysql database: have a look at the users and db table and add the user /db lines that don't exist on the new server but on the old server.
Copy local-host-names and virtusertable to /etc/postfix; open local-host-names and replace the old hostname with the new one. Run postmap /etc/postfix/virtusertable and restart Postfix.
Replace Vhosts_ispconfig.conf with the one from the old server; then open it and replace the old IP address with the new one. Transfer www.tar.gz to /home and unpack it:
cd /home
mv www www_orig
tar xvfz www.tar.gz
If you had to make a backup of /var/spool/mail, transfer mail.tar.gz to /tmp and do this: cd /tmp
tar xvfz mail.tar.gz
cd mail
cp -pf web* /var/spool/mail/
Have a look at your backups of /etc/passwd, /etc/shadow and /etc/group and add the lines that don't exist in these files on the new server to /etc/passwd, /etc/shadow and /etc/group on the new server.
Transfer named.conf and all pri.* files to the new server. Also all proftp*.conf files; open them and replace the old IP address with the new one - also do this with the file names of the proftpd*.conf files. Restart ProFTPd: /etc/init.d/proftpd restart
Restart Apache: /etc/init.d/apache restart
Log in to ISPConfig and go to Management -> Server -> Settings and change the IP address(es) there. Then go to the DNS Manager and also changes the IP addresses in the DNS records, if necessary.

On the old server, create a Postfix transport now so that all emails are forwarded to the ne server (for the time until the MX records of your domains have switched to the new server):
echo "* smtp:[<IP address of new server>]" >> /etc/postfix/transport
postmap /etc/postfix/transport
/etc/init.d/postfix restart

On the new server, open /etc/postfix/local-host-names and add the hostname of the old server at the bottom so that the new server accepts the forwarded mails.


Lots of steps to do... (if you want, you can have Till and me do that, but it's not free. Have a look here: http://www.ispconfig.org/support.htm ).

[Ovidiu]

your explanation worked all too beautiful for me, but I have one problem left: now root is the owner of /var/www and thats not ok. whats the easiest way to change back? could I not modify something in the ispconfig panel and click save - would that modify the sites ownership?

I could not get the part with /etc/passwd and /etc/shadow done before unpacking stuff (otherwise the ownership would have been preserved I guess)

whats the quickest way? to unpack again?

[falko]

Did you do this on your old server?
cd /var
tar -pczf www.tar.gz www/
The p keeps the permissions and owners of all included files and directories.

[Ovidiu]

of course not. that was the problem.

ok, now that I don't have the original information I guess I will do the reinstall again, add sites, users and stuff manually and then only copy the really needed material into the subfolders...

thx for the help, your howto move from one server to another is great one juts has to be able to read to get it done ;-)

[mphayesuk]

"Also create sql dumps of your MySQL databases (either with phpMyAdmin or on the command line: http://www.howtoforge.com/faq/6_3_en.html )"

Is there a way to make a backup of the customer sql satabase if they have a password that you dont know from the command line. ie if I have 50 customers all with a sql database I dont want to have to type in the command line 50 times and find out what password they have.

Any thoughts

[Ovidiu]

well I just used root and my rootmysql password, I do not know any clients passwords... if thats what you mean...

[mphayesuk]

No thats fine... it is what I was asking...

[nenad]

If there's two IP where's ISPConfig server, like
LAN:192.168.123.200 and WAN:87.116.136.92
LAN:192.168.123.201 and WAN:87.116.136.92

is it necessery that new production server is at the same LAN IP? Once when it is setup, and when all of the backup data is transfered onto him?

[falko]

You can change the IP address as described here: http://www.howtoforge.com/forums/showthread.php?t=2760

[nenad]

What to do if this is situation:

FedoraCore4 - old server
phpMyAdmin 2.6.4-pl3, MySQL 4.1.16

Debian Sarge - new server
phpMyAdmin 2.6.4-pl3, MySQL 4.0.24_Debian-10sarge1-log

And importing of database backup creates:

MySQL said:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8 AUTO_INCREMENT=3' at line 31

[falko]

You can try to update MySQL to version 4.1 on your Debian system. There are official Sarge packages for MySQL 4.1 :)

apt-get install mysql-server-4.1 mysql-client-4.1 libmysqlclient14-dev

[nenad]

MySQl is resolved using
http://www.dotdeb.org/mirrors

and MySQL 5 I do hope package is stable.
---------------------------------------------------

But, postfix?

OS and ISPConfig re-installed. Question obsolete at this moment.
Websites added manually through ISPConfig. MySQL imported through PHPMyAdmin.

[till]

Please post the output of:

ls -la /var/spool/postfix

[nenad]

If there's two IP where's ISPConfig server, like
LAN:192.168.123.200 and WAN:87.116.136.92
LAN:192.168.123.201 and WAN:87.116.136.92

is it necessery that new production server is at the same LAN IP? Once when it is setup, and when all of the backup data is transfered onto him?

No, I don't have to change LAN IP.

In past few days I am moving websites back and forth between two servers. WAN IP is same for both.

[Ovidiu]

is there an easier, more foolproof way to migrate my server to a new one? I get a new one as I had severall RAM failures on the old machine.

So I will have 2 PCs in parallel.
I would like to "clone" the whole setup to the new machine, can you give me a link to the best suited tutorial? I know there are severall on the howtoforge site maybe you can suggest one?

###edit###
I forgot to mention one additional detail: the new serevr will have 2 harddisks, so I could start using software raid...

[falko]

First I thought you could use Systemimager to move your system to the new server, but if you want to use Software RAID this doesn't work. Then you have to do it manually...

BTW, here's a nice tutorial on how to set up software RAID on a server remotely (in German): www.debiandox.de

[Ovidiu]

wow.

that looks like a very detailed howto, and after a quick glance it looks like I could use it with one of stratos servers too.

U guess after following that tutorial, I can start reading this tutorial about moving ispconfig again :-)

I'll keep you updated on my progress

[Ovidiu]

I found another how-to this time specially for Strato and not 1&1:

http://www.hotzeltopf.de/anleitungen/debian-sarge-auf-strato-mr2-server-mit-raid1-auf-amd-chipsatz

I followed it and everything runs smoothly, now I have to clone my old system. What would be the easiest way? Shall I follow the http://www.howtoforge.com/howto_linux_systemimager howto? Or do you suggest another way? I want to have a clone, then send an email to the site owners I host, to change their IP in the DNS where they manage their sites, so we can just hop onto the new server.

###edit###
please keep in mind, that I want to synchronize a server running on interl to the enw one running on AMD and having setup software raid on the new one also I would like not to have to configure all applications like postfix, apache2 ispconfig again, except for the samll changes in hsotnames and IP - any chance to do that?

[falko]

I found another how-to this time specially for Strato and not 1&1:

http://www.hotzeltopf.de/anleitungen/debian-sarge-auf-strato-mr2-server-mit-raid1-auf-amd-chipsatz
The debiandox tutorial works also for Hetzner, I've tested that. :) I guess it will also do for Strato.

I followed it and everything runs smoothly, now I have to clone my old system. What would be the easiest way? Shall I follow the http://www.howtoforge.com/howto_linux_systemimager howto? Or do you suggest another way? I want to have a clone, then send an email to the site owners I host, to change their IP in the DNS where they manage their sites, so we can just hop onto the new server.

###edit###
please keep in mind, that I want to synchronize a server running on interl to the enw one running on AMD and having setup software raid on the new one also I would like not to have to configure all applications like postfix, apache2 ispconfig again, except for the samll changes in hsotnames and IP - any chance to do that?I guess SystemImager will not work because your device names are now /dev/md0, /dev/md1, etc. on your new server and probably /dev/hda1 or /dev/sda1 or similar on the old one. I recommend to move the data manually. It's a lot of work, but afterwards you can be sure everything works the way you want it.

[Ovidiu]

you are right about those tutorials, the one you gave and the one I found are almost copies of each other.

About manually moving:

can you give me some hints:

- for example how do I get a list of all installed applications? there has to be a dpkg or apt option to get this list, so I could at least duplicate this.
- about duplicating settings as I am not sure I can duplicate everything manually, what needs to be copied over except for the ispconfig stuff (which is already covered further up in this thread) - /etc /usr /var maybe?
- anything which you strongly discourage me copying over?

[falko]

- for example how do I get a list of all installed applications? there has to be a dpkg or apt option to get this list, so I could at least duplicate this.
Run
dpkg -l

- about duplicating settings as I am not sure I can duplicate everything manually, what needs to be copied over except for the ispconfig stuff (which is already covered further up in this thread) - /etc /usr /var maybe?
That depends where your configuration files are. Most of them are in /etc.
The most important parts are covered here: http://www.howtoforge.com/forums/showpost.php?p=16488&postcount=2

[Ovidiu]

concerning /etc/passwd, /etc/shadow and /etc/group

want to have a good laugh?

I copied them over and now I cannot login any longer as I do not remember my root password I was using one of my users which had full acces via sudoers, but when copying those files over to the new system I forgot to copy the sudoers file, now I can login with my user, but no longer do sudo su, no root password, bad thing :-( I guess I'll set it up again, good practice

[till]

If you have direct access to your server, you might use a Live-CD like knoppix to boot your server, mount your HD and edit the password in /etc/shadow.

[Ovidiu]

I already read the : recover lost root password threads around here and I tried the lilo trick, before booting sequence, whatever but I failed yesterday, it booted too fast for me to press any key....

anyway thx for helping :-)

[falko]

Do you have a rescue system on your server? Boot into it, mount your hard disk and give yourself a new root password.

[Ovidiu]

ok, I mounted my /dev/md1 and tried chpasswd as well as passwd but I get this:

passwd: User not known to the underlying authentication module

Do you mean me to manually enter the password into /etc/passwd ? I guess I would have to enter it md5 encrypted there? Or how exactly do I achieve this?

###edit###

I answered my own question:

mount -t ext3 /dev/md1 /mnt/
root@h898552:~# cd /mnt/
root@h898552:/mnt#
root@h898552:/# chroot /mnt
h898552:/#
h898552:/# passwd
Enter new UNIX password:
Retype new UNIX password:
passwd: password updated successfully
h898552:/#

and again I learned something new :-) I REALLY DID IT!!!

[falko]

Yes, you need to chroot. :)

[Ovidiu]

some more problems:

in your post further up you give a link to how to dump and restore mysql database.

you should mention that one needs to create a db by that name before one can import. at least iti did not work for me.

next one ist this, I get an error whe ntrying to import:

h898552:~/exports# mysql -h localhost -u root -p****** web3_db1 <
web3_db1.sql
ERROR 1064 at line 12: You have an error in your SQL syntax. Check the
manual that corresponds to your MySQL server version for the right syntax
to use near 'NOT NULL,
PRIMARY KEY (id),
KEY ip (ip(15))
) TYPE=MyISAM'
h898552:~/exports#

what could this be? this is my most important database...

###edit###

how can I do this: have a look at the users and db table and add the user /db lines that don't exist on the new server but on the old server.

[falko]

next one ist this, I get an error whe ntrying to import:

Do you use the same MySQL version on both systems?

[Ovidiu]

I did not solve the last problem yet, but I have a new one:

I copied over the mysql database and now when I try to restart mysql I get this error:

h898552:/var/www# /etc/init.d/mysql restart
Stopping MySQL database server: mysqld...failed.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'debian-sys-maint@localhost' (Using password: YES)'
Killing MySQL database server by signal: mysqld.
Starting MySQL database server: mysqld.
Checking for crashed MySQL tables in the background.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'debian-sys-maint@localhost' (Using password: YES)'
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'debian-sys-maint@localhost' (Using password: YES)'
h898552:/var/www#


any idea why the debian-sys-maint user cannot login anymore?

###edit###

basically its 2 different problems:

I copied over one site to the new server but the web6_u1 was not inside the mysql db of the new server, so I copied the newest mysql db from the old server to the nwe one. Basically now I cannot restart the mysqld on the new server (see above errors) and I cannot login to the web6_db1 I also copied over although now the web6_u1 user is inside the mysql db.
2nd problem is a working db that I had already created on the new server is not working anymore.


###2nd edit###
1st problem: http://pacura.ru does not react at all, I get a site not found. I redirected this domain to the new server IP more than 24hours ago then went ahead and transfered the account to the new isp cfg server running debian, like described earlier in this thread - so where is the catch? web6_db1 exists, web6_u1 exists, I can login with phpmyadmin with these info.

2nd problem: web8_db1 and web8_u1 work to login using phpmyadmin but if I login as web8_u1 I see no databases, if I login as root I see web8_db1 so how can I repair this so that that user sees that DB? ###solved### I logged in with webmin, went to the mysql module and added the web8_u1 user to the database permissions table

[falko]

1st problem: http://pacura.ru does not react at all, I get a site not found.
It's working for me. I get a white page, but it's working. :)

[Ovidiu]

in between I got a white page too, but no source code???

by now it works, it looks to as if the DNS update took longer than 24 hours ....
I hope zice.ro will work too soon... thats the one where I get the shared IP page.

[todvard]

h898552:/var/www# /etc/init.d/mysql restart
Stopping MySQL database server: mysqld...failed.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'debian-sys-maint@localhost' (Using password: YES)'
Killing MySQL database server by signal: mysqld.
Starting MySQL database server: mysqld.
Checking for crashed MySQL tables in the background.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'debian-sys-maint@localhost' (Using password: YES)'
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'debian-sys-maint@localhost' (Using password: YES)'
h898552:/var/www#

the password for debian-sys-maint user is stored in two places, first encrypted in the mysql database, second in the /etc/mysql/debian.cnf file. I think you overwrote your mysql database with the dump from your old server, which means you will need to copy over the debian.cnf file from the old server as well.

[Ovidiu]

thx.

that worked wonderful and I think it is worht mentioning somewhere, like in the FAQ.

[Ovidiu]

ok, the move went ok, I jsut have one problem left: the stats are no longer compiling on the new server...

any suggestions what could have went wrong during the move or shall I start loking for "stats no longer compiling" posts?

also the problem with one of the databases persists:

h898552:/var/www# mysql -h localhost -u root -p****** web3_db1 < web3_db1.sql
ERROR 1064 at line 12: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL,
PRIMARY KEY (id),
KEY ip (ip(15))
) TYPE=MyISAM'
h898552:/var/www#


any ideas? the mysql version is the same on both systems. I could upgrade wordpress (the application that uses this DB) to the newest version, maybe the error lies within the DB ?

[falko]

ok, the move went ok, I jsut have one problem left: the stats are no longer compiling on the new server...
Run crontab -e and then restart cron: /etc/init.d/cron restart


any ideas? the mysql version is the same on both systems. I could upgrade wordpress (the application that uses this DB) to the newest version, maybe the error lies within the DB ?
What's in line 12 of web3_db1.sql?
Is web3_db1.sql emtpy (no tables in it) when you try to restore it from the dump?

[Ovidiu]

thx for helping, I tried the crontab -e and cron restart solution already, I'll wait and see what the new month brings.

regarding the DB issues, it got solved here: http://www.howtoforge.com/forums/showthread.php?t=5909

there was a problem with some backticks. I just cut out the section with the backticks as it was a plugin for wordpress.

[Ovidiu]

I have no stats showing for august for those sites that I moved from the old server, for the new created sites there is not even a stats folder being created.

I will look out for the thread dealing with this problem, I just wanted to mention that the stats stopped/never worked on this new system...

[till]

Do you have httpd logfiles in /var/log/httpd with the date in the name?

Do you get any errors when you execute:

/root/ispconfig/php/php -q /root/ispconfig/scripts/shell/logs.php

[Ovidiu]

sorry, I crossposted :-(

http://www.howtoforge.com/forums/showpost.php?p=35588&postcount=115

I thought I might continue the discussion in the logs / stats thread, I just mentioned it here because it happened after a move.

[nenad]

1) How to FTP files from one server to another through intermediate PC using root account?

server201 - old files zipped from /var/www directory

has to be transfered to

windows PC

and later uploaded to

server200

If I use WinSCP and root acess, file transfer through SSH, transfer is VERY slow.

2)
How to move files directly between two servers WITHOUTH intermediate PC.

server201 ---> server200
tar archive is in /var directory, therefore inacessible by standard web user account

3)
How to import mysql dump created with phpMyAdmin ?
It looks that import function don't import at all previously exported/dumped set of all databases.

Just to clarify, I don't intend to export one by one database and import them, but to export and import all of them at once (including ispconfig database)

This http://www.howtoforge.com/faq/6_3_en.html is ok for dump (export) of complete mysql, but how later to import that into another servers database using phpmyadmin?

If that can't be done, then this is only solution ? http://www.howtoforge.com/faq/6_4_en.html

[falko]

2)
How to move files directly between two servers WITHOUTH intermediate PC.

server201 ---> server200
tar archive is in /var directory, therefore inacessible by standard web user accountHave a look at the scp command:
man scp

3)
How to import mysql dump created with phpMyAdmin ?
It looks that import function don't import at all previously exported/dumped set of all databases.

Just to clarify, I don't intend to export one by one database and import them, but to export and import all of them at once (including ispconfig database)

This http://www.howtoforge.com/faq/6_3_en.html is ok for dump (export) of complete mysql, but how later to import that into another servers database using phpmyadmin?

If that can't be done, then this is only solution ? http://www.howtoforge.com/faq/6_4_en.htmlEither do it one by one, or create a script: http://www.howtoforge.com/forums/showthread.php?t=5408&highlight=mysqldump
http://www.howtoforge.com/forums/showthread.php?t=5191&highlight=mysqldump

Also have a look at mysqlhotcopy: man mysqlhotcopy

[Ovidiu]

for direct access using ftp:

cd /#ftp:user:pass@serverip

exchange user, pass and serverip with your data if you have an ftp account.

if not simply move the files you want to move to the other server into a web directory and on the target server do a wget urltoyourfile

hope this helps

[sushestvo]

I've followed a tutorial on first page and everything was fine at first.
Then I guess one day my server rebooted itself for some reason, I'm not sure what was the source of reboot, but regardless: after reboot vhosts file from ISPconfig had some IPs replaced, I guess ISPConfig messes it up all the time after each reboot.
Only one shared IP stays after reboot, the other is gone. MOst sites that have primary shared IP - will have main IP from old server, and some sites with dedicated IPs receive main IP of a new server.
WHy ISPConfig keeps messing my stuff up all the time? Where does it take the original from anyway? Everything was set up correct originally just like in tutorial on the first page. What should I do to prevent ISPCOnfig changing my vhosts or is there a way to edit the source that panel uses to restore file?
ANy help would be greatly appreciated.

[falko]

Please make sure that either $go_info["server"]["network_config"] is set to 1 in /home/admispconfig/ispconfig/lib/config.inc.php, or that your additional IP addresses are listed in your distribution's network configuration.

WHy ISPConfig keeps messing my stuff up all the time?ISPConfig is not messing up anything.

[sushestvo]

Then why after a reboot all IPs get messed up? I'm talking about vhosts_ISPConfig file.
If I log on to CP itself and view sites there - IPs are correct. But it won't be in vhosts file if I reboot.

[till]

Did you select the correct IP addresses in ISPConfig for the websites?

[KenKnight]

Hi all,

I'm going through this process now and have run into a few snags.

I followed the instructions from the second post basically using scp to pull everything over.

The old server is running 2.2.2 and the new server is 2.2.6. After copying everything over and restoring the mysql databases from a shell, when I click on a site under the DNS manager etc it comes up with

" The requested document type does not exist. "

Any ideas on what I missed? BTW I went through all the tables in the db_ispconfig and modified the ip address records to reflect the correct ip address for this server.

The old server is a PIII desktop and the new server is a Dual PIII 1U Rackmount with SCSI. If there's a simpler way I'll try it, otherwise I feel like I'm fairly close.

Thanks,
Ken

[till]

Hi Ken,

you can not move from 2.2.2 to 2.2.6 on another server. To move a ISPConfig installation, both servers must have the same ISPConfig version installed.

Update your old server to ISPConfig 2.2.6 and then move the database.

Till

[sajo]

OK it looks like I am the only stupid human in the iternet... however, I still dont know where the Vhosts_ispconfig.conf and named.conf are placed and what and where are this pri.* zone files are.

Thanks for answer

[falko]

Run updatedbAfterwards, you can search for files like this:
locate Vhosts_ispconfig.conf
locate named.conf

[wrender]

I have just moved from using fedora 5, to suse enterprise 10 and I'm trying to recreate everything the same on the new server, so that I can copy over everything from the old server.

Everything in these instructions is really good. Thanks falko, but I was wondering if there is an easier way to do this part of the databases....

"Regarding the mysql database: have a look at the users and db table and add the user /db lines that don't exist on the new server but on the old server."

I've got quite a few databases, and I need to copy all of the users over, with their passwords. I have tried replacing the whole mysql database which I'm guessing holds the users and passwords, but then mysql will not startup on the new server.... Is there something I am missing here?

Also, another question I have is on the old server, i was using Dovecot with Maildir, but on the new server I'm using Courier-Imap with Maildir... when I copy over the email, will this change effect anything?

On my server it seems as though there are two main directories where the ispconfig related data is stored.... /home/adminispconfig and /var/www/ Is this correct?

THanks,
Wes

[till]

I've got quite a few databases, and I need to copy all of the users over, with their passwords. I have tried replacing the whole mysql database which I'm guessing holds the users and passwords, but then mysql will not startup on the new server.... Is there something I am missing here?

Copying the mysql database will only work if the mysql versions on both servers are identical. I recommend to extract the users as SQL-Dump and copy all users except the root and system maintenance user to the new DB.

Also, another question I have is on the old server, i was using Dovecot with Maildir, but on the new server I'm using Courier-Imap with Maildir... when I copy over the email, will this change effect anything?

I think copying the Maildirs will work.

On my server it seems as though there are two main directories where the ispconfig related data is stored.... /home/adminispconfig and /var/www/ Is this correct?

There are three directories:

/root/ispconfig
/home/admispconfig
/var/www

The user and website data is only stored in /var/www and your mysql database directory /var/lib/mysql

[wrender]

There are three directories:

/root/ispconfig
/home/admispconfig
/var/www

The user and website data is only stored in /var/www and your mysql database directory /var/lib/mysql

OK, So to have my new ispconfig server running, i really only need the data from the following directories and files?
/var/www/
/home/admispconfig
/root/ispconfig
MySQL Databases (that relate to ispconfig)
MySQL Users (that relate to ispconfig)
/etc/passwd (lines that relate to ispconfig users)
/etc/shadow (lines that relate to ispconfig users)
/etc/group (lines that relate to ispconfig users)
Vhosts_ispconfig.conf
/etc/postfix/local-host-names
/etc/postfix/virtusertable
named.conf
all the pri.* zone files
/etc/proftpd*.conf

Also, isn't the /etc/shadow file encrypted? Will the user accounts still work if I just cut and paste the lines from here? I think what I will do for the databases, is install the same version of mysql on the new server, and then copy over the sql files from /var/lib/mysql on the old server. Do you think this will work?


Thanks,
Wes

[till]

OK, So to have my new ispconfig server running, i really only need the data from the following directories and files?
/var/www/
/home/admispconfig
/root/ispconfig
MySQL Databases (that relate to ispconfig)
MySQL Users (that relate to ispconfig)
/etc/passwd (lines that relate to ispconfig users)
/etc/shadow (lines that relate to ispconfig users)
/etc/group (lines that relate to ispconfig users)
Vhosts_ispconfig.conf
/etc/postfix/local-host-names
/etc/postfix/virtusertable
named.conf
all the pri.* zone files
/etc/proftpd*.conf

Also, isn't the /etc/shadow file encrypted? Will the user accounts still work if I just cut and paste the lines from here?

Yes, it works because all linux distributions use the same encryption (if you dont switched to MD5 encryption of course).

I think what I will do for the databases, is install the same version of mysql on the new server, and then copy over the sql files from /var/lib/mysql on the old server. Do you think this will work?

Yes, if you use the same MySQL version.

[wrender]

Ok, Thanks Till. I think I spent about 10 hours to figure all this stuff out yesturday. Shoulda paid you guys to help me....:o

[cybere]

Thanks for the support so far people.

I am preparing a backup server for my small ISP, and am just tracking down the specified files at the beginning of this thread.

I have located several copies of named.conf in the following locales:

[root@www backup]# locate named.conf
/etc/named.conf
/etc/named.conf~
/etc/dbus-1/system.d/named.conf
/root/ispconfig/isp/conf/named.conf.master
/usr/share/doc/bind-9.3.2/sample/etc/named.conf
/usr/share/logwatch/default.conf/services/named.conf
/usr/share/man/man5/named.conf.5.gz
/var/named/chroot/etc/named.conf


and of course now im wondering which one it is that you specified.
I believe it to be the one jailed inside chroot(last one), but now im just guessing.

Again, thanks in advance

[till]

It is /var/named/chroot/etc/named.conf, and the symlinked version /etc/named.conf which is identical.

[merlincc]

I built server A to test ispconfig. After using it for a week I decided to rebuild my "good" server so I installed ispconfig on server B.

I followed the instructions from this thread and copied over the directories and files. All went well except when I login to retrieve my email I do not find my email from server A.

I thought the correct Maildir was located in /var/www/www.*****.com/user/{username}/Maildir

Help please!

[till]

The maildir is correct. Do you use dovecot as mailserver on server A and B? Have you enabled Maildir under management > server > settings on server B?

[merlincc]

The maildir is correct. Do you use dovecot as mailserver on server A and B? Have you enabled Maildir under management > server > settings on server B?

I am using dovecot on both servers. I followed the perfect LAMP setup for Fedora core 6 on both servers. I have enabled Maildir on both servers.

Let me give you some history:

I built server A a few weeks back. I was able to get email just fine but have other issues which were pointed out to me in this forum. I reinstalled ispconfig on server A. Things have been great for a week.

Server A is my old secondary sandbox server.

I built my primary server B following the perfect LAMP setup. Found this thread to move files from server A to server B. I moved:
/var/lib/mysql after shutting down mysqld
/var/www after shutting down postfix
/home/admispconfig
/root/ispconfig
/etc/passwd
/etc/shadow
/etc/group
Vhosts_ispconfig.conf
/etc/postfix/local-host-names
/etc/postfix/virtusertable
named.conf
all the pri.* zone files
/etc/proftpd*.conf

I brought up all services on both servers and setup foxfire to connect to each server using IMAP. On server A I still see my email and it is still sending new mail there which is correct.

On server B I don't see the email I expected from server A. I looked in the /var/www/www.****.com/user/Maildir from server A and see old email from 12/7. This is before I reinstalled ispconfig. I look on server B and it is identical.

So...I am thinking that my email is not where I think it is. Thus my question on where it could be.

Here is my directory and the email found there:
[root@kelly cur]# pwd
/var/www/www.4thegreens.com/user/johngreen/Maildir/cur
[root@kelly cur]# ls -ltr
total 60
-rwxrwxr-x 1 10038 web12 12114 Dec 5 18:52 1165366289.2026_2.kelly.4thegreens.com:2,Sc
-rwxrwxr-x 1 10038 web12 15459 Dec 5 19:23 1165367868.2546_2.kelly.4thegreens.com:2,Sc
-rwxrwxr-x 1 10038 web12 4217 Dec 5 19:23 1165367963.2622_2.kelly.4thegreens.com:2,Sc
-rwxrwxr-x 1 10038 web12 14898 Dec 7 13:07 1165518474.16735_2.kelly.4thegreens.com:2,Sb
-rwxrwxr-x 1 10038 web12 4196 Dec 7 13:24 1165519473.30546_2.kelly.4thegreens.com:2,Sb
[root@kelly cur]#

Any suggestions?

[till]

It looks like the group with the groupID 10038 soes not exist on the new server. Please compare the /etc/group files on both servers.

[merlincc]

All files are identical. All directories have been copied over according to my earlier post.

The problem that I am seeing is the old mail in server A that was copied over on server B. These are identical and if you look at the dates of those files they are from 12/06-12/07. I am looking at my email from today on server A. I do not see any mail from 12/06-12/07.

Where is the email stored?

[falko]

Till meant the userid 10038, not the group id. What's the output of grep 10038 /etc/passwd on server A and B?

[Morons]

I need to add that some of the build-in linux tools I used to seak out errors in the passwd/shadow files as well as the group/gshadow files are pwck and grpck these two utils will not only show out mismatchings were you missed or messed up but will also fix some errors.

[guardian]

Hello, I have transfer my ISPconfig from Ubuntu LTS to Debian 4, the problem is that I don't have dump from the databases only the content of /var/lib/mysql
I have copied the files over to Debian and now all tables are read only. Is there anyway to change them?

[Morons]

Have you set the database permissions correctly? google this frum for setting it up or follow instruction in the HOWTO for Perfect Debian.

[till]

Hello, I have transfer my ISPconfig from Ubuntu LTS to Debian 4, the problem is that I don't have dump from the databases only the content of /var/lib/mysql
I have copied the files over to Debian and now all tables are read only. Is there anyway to change them?

please run:

chown -R mysql:mysql /var/lib/mysql/yourdatabase/

where you replace yourdatabase with the name of the database that is not working properly.

[toyito]

Hi there...

Im triying to follow this procedure but:

Make a backup of /etc/passwd, /etc/shadow, /etc/group, Vhosts_ispconfig.conf, /etc/postfix/local-host-names, /etc/postfix/virtusertable, named.conf, all the pri.* zone files, /etc/proftpd*.conf. Also create sql dumps of your MySQL databases (either with phpMyAdmin or on the command line: http://www.howtoforge.com/faq/6_3_en.html ) and make a backup of /home/www on the old server:

can u tell me where is Vhosts_ispconfig.conf,named.conf and all the pri.* zone files.

Regards

Hector

[wrender]

Depending on your operating system, it may be located in different spots. To check where they are on your system.

- Login to ispconfig web interface as an admin user
- Go to "Management"
- Go to Server -> Settings
- Click on "Web" tab
- Conf. Dir: should be the location of your Vhosts file
- Click on "DNS" tab
- Zonefiles Dir: should be the location of your dns files

[ACDII]

Hi, will this work moving from Fedora Core 4 to Fedora core 6? The howtos are different between the releases.

[jfruano]

I configuring a second server for security for if the first one doesn't work, to use this.
The system, is the same one Debian etch.

First installed in the new server the ISPConfig. I proved without introducing any data and everything worked well.

I have followed the instructions of the Falko

Make a backup of /etc/passwd, /etc/shadow, /etc/group, Vhosts_ispconfig.conf, /etc/postfix/local-host-names, /etc/postfix/virtusertable, named.conf, all the pri.* zone files, /etc/proftpd*.conf. Also create sql dumps of your MySQL databases (either with phpMyAdmin or on the command line: http://www.howtoforge.com/faq/6_3_en.html ) and make a backup of /home/www on the old server: ......

and the databases mysql, I copy all the folders of databases of the directory / var/lib/mysql and paste in same dir of the new server.

But now when start the new server, appear 2 errors:
Starting domain name service bind. Failure
Starting mysql database.... Failure

When login in the panel of administration of ISPConfig, enter the user and the password, appear the following errors:


error when login in ISPConfig control panel :

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /home/admispconfig/ispconfig/lib/classes/ispconfig_db_mysql.lib.php on line 77

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /home/admispconfig/ispconfig/lib/classes/ispconfig_db_mysql.lib.php on line 77

Warning: Cannot modify header information - headers already sent by (output started at /home/admispconfig/ispconfig/lib/classes/ispconfig_db_mysql.lib.php:77) in /home/admispconfig/ispconfig/web/login/login.php on line 60

Anyone got any ideas where to solve this errors ?

Thanks in advance,

[wrender]

Hello,

When you are backing up your databases, you can't just copy the database files directly... you need to do a mysqldump command to properly dump the database information. You can sometimes get away with copying the database files, but you need to stop the service first, then copy them. Also the server you are copying them to must have the exact same mysql version running. Here are some commands that I normally use.

mysqldump -p --all-databases > all_databases.sql
- this dumps all databases into a file. the -p is to prompt for your mysql password.

mysqldump -p db_name > backup-file.sql
- this dumps a specific database

mysql -p db_name < backup-file.sql
- this imports a database into mysql

mysqlshow -p
- this will show the databases on your mysql server.



Wes

[jfruano]

Thank you for your response.
Hello,

When you are backing up your databases, you can't just copy the database files directly... you need to do a mysqldump command to properly dump the database information. You can sometimes get away with copying the database files, but you need to stop the service first, then copy them. Also the server you are copying them to must have the exact same mysql version running. Here are some commands that I normally use.

mysqldump -p --all-databases > all_databases.sql
- this dumps all databases into a file. the -p is to prompt for your mysql password.

mysqldump -p db_name > backup-file.sql
- this dumps a specific database

mysql -p db_name < backup-file.sql
- this imports a database into mysql

mysqlshow -p
- this will show the databases on your mysql server.

Wes

Now can I solve this problem?

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) :confused:

Thanks again.

[wrender]

Try uninstalling and re-installing the mysql software. Then restart the mysql server services.

Wes

[jfruano]

The error was mine. :o

My server is working in an I.P. of my router and the second server in another different I.P. to use only in local mode and it wanted to have prepared if failed the first server..

I have undone all the changes and has remained as it was.

Already I will try to do it of another form.

Any sugestion for this mode of copy ? :rolleyes:

Thanks Wes, and sorry for the nuisances.

[wrender]

Hmm i'm kinda confused on what you are trying to do. Do you have two servers and are trying to keep them identical in case one fails?

I don't think this is really possible with ISPConfig. What I would recommend, is just setup another server with the same OS as your main server. Then run nightly backups of your main server onto the backup server. If the main one fails, you should be able to recover from the backup data if you are backing up everything that is needed.

I think there are some articles about this from the guys that maintain ispconfig. They are cool dudes.

Wes

[mitho7]

Hi,

I have done all the steps as falko mentioned on http://www.howtoforge.com/forums/showthread.php?t=2717&highlight=moving+ispconfig

Everything working ok, except mail. serer can send email, but i can not login to webmail or using thunderbird.

i have install the ISPConfig first on new server then i just followed the steps as falko said.

Can any one please help on it.

[till]

Which errors do you get in the mail log?

[mitho7]

Which errors do you get in the mail log?

here are is the log from cat /var/log/mail.log
This is just part of the file


Sep 20 19:50:57 server1 courierpop3login: Connection, ip=[::ffff:127.0.0.1]
Sep 20 19:50:57 server1 courierpop3login: Disconnected, ip=[::ffff:127.0.0.1]
Sep 20 19:51:04 server1 postfix/smtpd[3794]: connect from localhost.localdomain[127.0.0.1]
Sep 20 19:51:04 server1 postfix/smtpd[3794]: lost connection after CONNECT from localhost.localdomain[127.0.0.1]
Sep 20 19:51:04 server1 postfix/smtpd[3794]: disconnect from localhost.localdomain[127.0.0.1]
Sep 20 19:51:04 server1 courierpop3login: Connection, ip=[::ffff:127.0.0.1]
Sep 20 19:51:04 server1 courierpop3login: Disconnected, ip=[::ffff:127.0.0.1]
Sep 20 19:51:53 server1 postfix/smtpd[3794]: connect from unknown[192.168.1.10]
Sep 20 19:52:02 server1 postfix/smtpd[3794]: disconnect from unknown[192.168.1.10]
Sep 20 19:55:22 server1 postfix/anvil[3818]: statistics: max connection rate 1/60s for (smtp:192.168.1.10) at Sep 20 19:51:53
Sep 20 19:55:22 server1 postfix/anvil[3818]: statistics: max connection count 1 for (smtp:192.168.1.10) at Sep 20 19:51:53
Sep 20 19:55:22 server1 postfix/anvil[3818]: statistics: max cache size 1 at Sep 20 19:51:53
Sep 20 19:58:23 server1 postfix/smtpd[3905]: connect from unknown[192.168.1.10]
Sep 20 19:58:24 server1 postfix/smtpd[3905]: lost connection after UNKNOWN from unknown[192.168.1.10]
Sep 20 19:58:24 server1 postfix/smtpd[3905]: disconnect from unknown[192.168.1.10]
Sep 20 20:01:44 server1 postfix/anvil[3907]: statistics: max connection rate 1/60s for (smtp:192.168.1.10) at Sep 20 19:58:23
Sep 20 20:01:44 server1 postfix/anvil[3907]: statistics: max connection count 1 for (smtp:192.168.1.10) at Sep 20 19:58:23
Sep 20 20:01:44 server1 postfix/anvil[3907]: statistics: max cache size 1 at Sep 20 19:58:23
Sep 20 20:08:23 server1 postfix/smtpd[4273]: connect from unknown[192.168.1.10]
Sep 20 20:08:23 server1 postfix/smtpd[4273]: lost connection after UNKNOWN from unknown[192.168.1.10]
Sep 20 20:08:23 server1 postfix/smtpd[4273]: disconnect from unknown[192.168.1.10]
Sep 20 20:09:04 server1 postfix/smtpd[4273]: connect from localhost.localdomain[127.0.0.1]
Sep 20 20:09:04 server1 postfix/smtpd[4273]: lost connection after CONNECT from localhost.localdomain[127.0.0.1]
Sep 20 20:09:04 server1 postfix/smtpd[4273]: disconnect from localhost.localdomain[127.0.0.1]
Sep 20 20:09:04 server1 courierpop3login: Connection, ip=[::ffff:127.0.0.1]
Sep 20 20:09:04 server1 courierpop3login: Disconnected, ip=[::ffff:127.0.0.1]
Sep 20 20:12:24 server1 postfix/anvil[4275]: statistics: max connection rate 1/60s for (smtp:192.168.1.10) at Sep 20 20:08:23
Sep 20 20:12:24 server1 postfix/anvil[4275]: statistics: max connection count 1 for (smtp:192.168.1.10) at Sep 20 20:08:23
Sep 20 20:12:24 server1 postfix/anvil[4275]: statistics: max cache size 1 at Sep 20 20:08:23
Sep 20 20:18:23 server1 postfix/smtpd[4654]: connect from unknown[192.168.1.10]
Sep 20 20:18:23 server1 postfix/smtpd[4654]: lost connection after UNKNOWN from unknown[192.168.1.10]
Sep 20 20:18:23 server1 postfix/smtpd[4654]: disconnect from unknown[192.168.1.10]
Sep 20 20:19:18 server1 postfix/smtpd[4654]: connect from localhost.localdomain[127.0.0.1]
Sep 20 20:19:18 server1 postfix/smtpd[4654]: lost connection after CONNECT from localhost.localdomain[127.0.0.1]
Sep 20 20:19:18 server1 postfix/smtpd[4654]: disconnect from localhost.localdomain[127.0.0.1]
Sep 20 20:19:18 server1 courierpop3login: Connection, ip=[::ffff:127.0.0.1]
Sep 20 20:19:18 server1 courierpop3login: Disconnected, ip=[::ffff:127.0.0.1]
Sep 20 20:22:38 server1 postfix/anvil[4656]: statistics: max connection rate 1/60s for (smtp:192.168.1.10) at Sep 20 20:18:23
Sep 20 20:22:38 server1 postfix/anvil[4656]: statistics: max connection count 1 for (smtp:192.168.1.10) at Sep 20 20:18:23
Sep 20 20:22:38 server1 postfix/anvil[4656]: statistics: max cache size 1 at Sep 20 20:18:23

[mitho7]

Just found one more thing on mail log


Sep 21 16:05:22 server1 postfix/qmgr[3048]: E0B9E6F45EC: removed
Sep 21 16:05:22 server1 postfix/smtp[3192]: BCB256F45ED: to=<www-data@sever1.xxxxx.net>, relay=none, delay=0.09, delays=0.01/0.02/0.05/0, dsn=5.4.4, status=bounced (Host or domain name not found. Name service error for name=sever1.xxxxx.net type=AAAA: Host not found)
Sep 21 16:05:22 server1 postfix/qmgr[3048]: BCB256F45ED: removed
Sep 21 16:07:05 server1 postfix/smtpd[3253]: connect from unknown[192.168.1.10]
Sep 21 16:07:07 server1 postfix/smtpd[3253]: lost connection after UNKNOWN from unknown[192.168.1.10]
Sep 21 16:07:07 server1 postfix/smtpd[3253]: disconnect from unknown[192.168.1.10]
Sep 21 16:10:27 server1 postfix/anvil[3255]: statistics: max connection rate 1/60s for (smtp:192.168.1.10) at Sep 21 16:07:05
Sep 21 16:10:27 server1 postfix/anvil[3255]: statistics: max connection count 1 for (smtp:192.168.1.10) at Sep 21 16:07:05
Sep 21 16:10:27 server1 postfix/anvil[3255]: statistics: max cache size 1 at Sep 21 16:07:05
Sep 21 16:15:37 server1 postfix/pickup[3047]: A73386F45EC: uid=33 from=<www-data>


It is coming up sever1.xxxxx.net, when i first installed it on new machine i misspelled it it suppose to be "server1" not "sever1". i have fixed that after i have installed ISPConfig, on /etc/hosts and /etc/postfix/main.cf

Please help

[till]

Please check the files /etc/postfix/main.cf and /etc/mailname if they contain the misspelled hostname.

Check also with the commands:

hostname
hostname -f

if the system returns the correct hostname.

[mitho7]

/etc/mailname
this file had sever1.xxxx.net.. i just changed it server1 and reboot now all good.

Thanks Till

[Bicet]

I was able to restore everything, but now if i try to add a new site... It will not work...

Vhosts_ispconfig.conf is modified in time, but it doesn't contain any new data...

[falko]

Can you go to the directory where Vhosts_ispconfig.conf is saved and post the output of ls -la?

[Bicet]

Sorry for such a dumb question Falko, there was already an answer...

http://www.howtoforge.com/forums/showpost.php?p=76934&postcount=2

Thank you again... Now my ISPconfig is completely moved to a new server.

[mitho7]

Hi All,

After i move my server all the old site is working fine, but got new problem with creating new site. After I create new site it does not work. I have checked the "Vhosts_ispconfig.conf" file that does have new site information. But another file (Vhosts_ispconfig.conf_30-11-07_18-29-24) has the entry of new site.

When I do "ls -la", I get the followings:

“drwxr-xr-x 2 root root 4096 2007-11-30 18:51 .
drwxr-xr-x 8 root root 4096 2007-09-29 21:15 ..
-rw-r--r-- 1 root root 15178 2007-11-30 18:29 Vhosts_ispconfig.conf
-rw-r--r-- 1 root root 12530 2007-10-15 20:56 Vhosts_ispconfig.conf_15-10-07_20-56-40
-rw-r--r-- 1 root root 13865 2007-10-15 20:59 Vhosts_ispconfig.conf_15-10-07_20-59-46
-rw-r--r-- 1 root root 13865 2007-10-15 21:00 Vhosts_ispconfig.conf_15-10-07_21-00-20
-rw-r--r-- 1 root root 13862 2007-10-15 21:01 Vhosts_ispconfig.conf_15-10-07_21-01-04
-rw-r--r-- 1 root root 13862 2007-10-15 21:01 Vhosts_ispconfig.conf_15-10-07_21-01-48
-rw-r--r-- 1 root root 13862 2007-10-15 21:03 Vhosts_ispconfig.conf_15-10-07_21-03-33
-rw-r--r-- 1 root root 13862 2007-10-15 21:03 Vhosts_ispconfig.conf_15-10-07_21-03-49
-rw-r--r-- 1 root root 13863 2007-10-15 21:05 Vhosts_ispconfig.conf_15-10-07_21-05-45
-rw-r--r-- 1 root root 13862 2007-10-15 21:06 Vhosts_ispconfig.conf_15-10-07_21-06-59
-rw-r--r-- 1 root root 13862 2007-10-15 21:11 Vhosts_ispconfig.conf_15-10-07_21-11-13
-rw-r--r-- 1 root root 15182 2007-10-15 21:12 Vhosts_ispconfig.conf_15-10-07_21-12-18
-rw-r--r-- 1 root root 15182 2007-10-15 21:12 Vhosts_ispconfig.conf_15-10-07_21-12-55
-rw-r--r-- 1 root root 15182 2007-10-15 21:55 Vhosts_ispconfig.conf_15-10-07_21-55-15
-rw-r--r-- 1 root root 15182 2007-11-21 15:43 Vhosts_ispconfig.conf_21-11-07_15-43-51
-rw-r--r-- 1 root root 13850 2007-11-27 23:33 Vhosts_ispconfig.conf_27-11-07_23-33-38
-rw-r--r-- 1 root root 13850 2007-11-27 23:33 Vhosts_ispconfig.conf_27-11-07_23-33-52
-rw-r--r-- 1 root root 12530 2007-09-29 20:44 Vhosts_ispconfig.conf_29-09-07_20-44-55
-rw-r--r-- 1 root root 12530 2007-09-29 20:57 Vhosts_ispconfig.conf_29-09-07_20-57-29
-rw-r--r-- 1 root root 16514 2007-11-30 18:29 Vhosts_ispconfig.conf_30-11-07_18-29-24
-rw-r--r-- 1 root root 0 2007-09-08 17:27 Vhosts_ispconfig.conf.back


Thanks in advance.

[till]

Please have a look here:

http://www.howtoforge.com/forums/showthread.php?t=13596

[Rocky]

Guys,

I followed the guide to make a backup of my system for a move to a new server. However, I have a few questions.

Do I need to make a backup of the following mysql databases:
mysql
information_schema

I already have 2 servers running ISPConfig 2.2.11. The main server runs my web/ftp/dns/mysql while the second runs dns as a secondary dns.

The question is that, lets say the main server goes down. Can I use this procedure to restore the backup into the secondary server?

After following the restoring part of the tutorial, would there be any other requirements for me to get the secondary server functioning as if it was the main server?

Please let me know.

Thanks,

Rocky

[till]

Do I need to make a backup of the following mysql databases:
mysql
information_schema

The "mysql" database has to be included in the backup too.

The question is that, lets say the main server goes down. Can I use this procedure to restore the backup into the secondary server?

Yes, this should work. But you should test the procedure for your installation. Instead of moving the data in the tar.gz files, you can sync the data between the servers e.g. every 15 minutes with rsync.

[Rocky]

Till,

You are absolutely correct and I will implement rsync. However, I don't have the time to do this as I'm leaving on my vacation.

So for now, I just have to hope that nothing happens while I'm gone. As for data changing, we pretty much have static data so nothing really changes unless we change it.

Having this backup just makes me feel a bit as ease.

Thanks again,


Rocky

[zeeman]

I've got a little quasion about postfixs transport:

echo "smtp *:[<IP address of new server>]" >> /etc/postfix/transport
postmap /etc/postfix/transport
/etc/init.d/postfix restart


I googled a little bit around to get to know what this line really does.
Everywhere I found the example
domain.tld smtp:[<IP address of new server>]
.domain.tld smtp:[<IP address of new server>]

So I'm a little bit confused which to use.
I want to forward all mails from server A to server B. A and B use the same configuration (same users, uids, guids, webs and so on)

Thanks for the good explanation at the start of this thread!

[falko]

Use the first line if you have email addresses like user@domain.tld; use the second line if your email addresses look like this: user@sub.domain.tld.

[pepo]

Last nigth I used the quick howto of Falco to move my ISPconfig installation to a new server. (Thanks for this free support!)

After I was done I started testing and found something strange. Some PHP pages where blank, others showed parts php-code and there where pages that just worked.

Also a quick phpinfo page turned out blank.

Today I was playing around with one of the pages that didn't work right. After a while I had a bright idea. I changed <? for <?php in my phpinfo page and it worked. A little googleing tought me that in PHP 5.2.? short tags ar discouraged.

Now I was stuck with lots of pages that didn't work. The easy method would be to change httpd.comf settings to allow short tags, but I desided to figure out how to update all php pages with the right opening tag.

Here is a little script that loops through all the php pages in a directory and replaces <? with <?php.

#!/bin/bash
for fl in *.php; do
mv $fl $fl.old
sed 's/<? /<?php /g' $fl.old > $fl
rm -f $fl.old
done

I found a little drawback when you have both <? and <?php openingtags. I should figure out regular expressions to solve this. So I first ran the script twice, first like this:

#!/bin/bash
for fl in *.php; do
mv $fl $fl.old
sed 's/<?/<?php/g' $fl.old > $fl
rm -f $fl.old
done

and than

#!/bin/bash
for fl in *.php; do
mv $fl $fl.old
sed 's/<?phpphp/<?php /g' $fl.old > $fl
rm -f $fl.old
done

Maybe this script can be the start of a script to run through all the directories in /src/www, but that will be one for another time.

Hope this script can help someone.

Greetz,

Pepo

[Leszek]

That's useful pepo.
You can also manipulate php_flag short_open_tag Off|On in a .htaccess file to allow execution of php scripts started with <?php or just <?.

[azidtripz]

Hello everyone,

first i would like to state that ISPConfig is a fantastic bit of software.

though i am having some issues with moving to server B

here is my setup

Server A and B both have the same linux version and all software on both is up to date (same versions of mysql, php, ispconfig and so on)

i move everything other all files and databases and it all seams fine, in myphpadmin i look and all the databases are there, when i log into ISPConfig and goto the database section on my of my websites the database section doesnt show up, and then when i log back into myphpadmin and click on one of the databases from that website it then dissapears :S, i have no idea what could be doing thing but its proberly something easy to fix,

[falko]

How did you copy over the ISPConfig database from server A to B?

[azidtripz]

the first time i i just exported all the databases using phpmyadmin and then imported them on server B, though i couldn't add add the missing info out of database 'mysql' because it wouldn't show up, but existed, so to same me some more trouble, i zipped /var/lib/mysql, and then extracted it on server B, and all databases were showing fine until i went into ispconfig and into option of any sites...

[till]

You can try to download this version of ISPConfig and run a update on your system:

http://www.ispconfig.org/downloads/ISPConfig-svn-stable.tar.gz

[azidtripz]

Thank you very much Till that worked great, now to 2 minor problems (i hope) on bootup it says this mysql user cant log in "debian-sys-maint". and also when i run this command "postmap /etc/postfix/virtusertable" i get the following error

postmap /etc/postfix/virtusertable
postmap: fatal: open /etc/postfix/virtusertable.db: Permission denied

[falko]

Thank you very much Till that worked great, now to 2 minor problems (i hope) on bootup it says this mysql user cant log in "debian-sys-maint".
Please make sure you use the correct password in /etc/mysql/debian.cnf for the debian-sys-maint user.

and also when i run this command "postmap /etc/postfix/virtusertable" i get the following error

postmap /etc/postfix/virtusertable
postmap: fatal: open /etc/postfix/virtusertable.db: Permission deniedWhat's the output of ls -la /etc/postfix?

[azidtripz]

total 104
drwxr-xr-x 4 root root 4096 2008-03-02 16:43 .
drwxr-xr-x 76 root root 4096 2008-03-03 12:45 ..
-rw-r--r-- 1 root root 318 2008-03-02 14:15 dynamicmaps.cf
-rw-r--r-- 1 azidtripz azidtripz 485 2008-03-02 17:01 local-host-names
-rw-r--r-- 1 root root 380 2008-03-02 17:01 local-host-names~
-rw-r--r-- 1 root root 1852 2008-03-02 16:17 main.cf
-rw-r--r-- 1 root root 1756 2008-03-02 16:17 main.cf.orig
-rw-r--r-- 1 root root 4035 2008-03-02 14:15 master.cf
-rw-r--r-- 1 root root 18116 2007-10-06 11:19 postfix-files
-rwxr-xr-x 1 root root 7121 2007-10-06 11:19 postfix-script
-rwxr-xr-x 1 root root 22197 2007-10-06 11:19 post-install
drwxr-xr-x 2 root root 4096 2008-03-02 14:17 sasl
drwxr-xr-x 2 root root 4096 2008-03-02 14:21 ssl
-rw-r--r-- 1 azidtripz azidtripz 939 2008-03-02 17:01 virtusertable
-rw-r--r-- 1 root root 0 2008-03-02 17:01 virtusertable~
-rw-r--r-- 1 root root 12288 2008-03-02 16:17 virtusertable.db

so i assume i have the wrong permissions, what do i need to change them too ?

also fixed mysql problem, didn't know where to look for the password so thankyou

[falko]

Did you run the postmap command as root?

[azidtripz]

yes i most certainly did :/

[falko]

Please try
chown root:root /etc/postfix/virtusertable

[azidtripz]

thankyou falko, i just thought since i was running as root, that it would work, but its all sorted now, thank you guys for all your help :)

i have just moved my server from a dell poweredge 1650 to a 701 eeePc, because i couldn't afford my power bill and the eee consumes 14watts of power and seems to handle it all quiet well....

[radim_h]

Hello Falko,
quick question to first page of this thread:


Do i have to transfer /etc/passwd, /etc/shadow, /etc/group, /etc/postfix/local-host-names, /etc/postfix/virtusertable before i restore the old database?
those files seems to be correctly created after IPSC is restarted after restoring database..

[falko]

Hello Falko,
quick question to first page of this thread:


Do i have to transfer /etc/passwd, /etc/shadow, /etc/group, /etc/postfix/local-host-names, /etc/postfix/virtusertable before i restore the old database?
Yes, but if your files seem to be ok, then it's fine, too. :)

[titanium]

Hi there

Thanks for the excellent tips for moving ISPConfig between servers. However, with regards to the following step:

echo "* smtp:[<IP address of new server>]" >> /etc/postfix/transport
postmap /etc/postfix/transport
/etc/init.d/postfix restart

This won't work until you add the following line to /etc/postfix/main.cf :

transport_maps = hash:/etc/postfix/transport

and restart Postfix.

Mails on my old server weren't being relayed to the new server until I inserted this line!

Regards

[aqua]

Hello:

I am following this guide to moving ISPconfig. I got to this part:

Regarding the mysql database: have a look at the users and db table and add the user /db lines that don't exist on the new server but on the old server.

But I am not sure what it means.

I dumped all my databases using:

mysqldump -h localhost -u root -psecret -c --add-drop-table --add-locks --all --quick --lock-tables --all-databases > sqldump.sql

and then restored using:

mysql -u root -psecret < backup.sql

So why would I need to add lines to the new server that are in the old server?

The users cannot accesses their databases either.

Any help is appreciated.

Aqua

[createch]

I tried the move steps. With slight modification it works perfectly. Thanks!

Concerning the "adding of user/db" in the mysql table, actually I've found that we can also use the sqldump step, and then I no longer need to manually key in the user/db data

I just cannot export/import the information_schema database. (it always prompts no-permission for root). However it appears that the moved ispconfig still works correctly.

I managed to write a cron job to perform the backup steps. Personally I don't think it is a good trick to always run 2 servers simultaneously. Instead I will perform a daily backup, and then in case of a server hardware failure, I can quickly switch to the backup server. It is enough for my case....

Lastly I have to say "Great tutorial" ! The only 2 things I've found which are not applicable to my case:

a) I have to move the data from var/www instead of home/www (may be this is the characteristics of a FC 5 installation ?)

b) I have to add the "--default-character-set=utf8" tag in the mysql import command. Otherwise the resulting ISPConfig will fail saying "The requested document type does not exist. " when I click on a site on the ISPconfig panel.

[falko]

I just cannot export/import the information_schema database. (it always prompts no-permission for root). However it appears that the moved ispconfig still works correctly.

You don't have to move this one to the new server. :)

[radim_h]

I have transferred whole server according this HOWTO without problems,
there was only one problem, but really anoying

after i chaged IP adresses for domains in "isp_isp_domain" table
then
update isp_isp_domain set status ='u';
then
touch /home/admispconfig/ispconfig/.run

then tried restartISPC and also whole computer,
but ISPC was still creating /etc/apache2/vhosts/Vhosts_ispconfig.conf with old IP adresses, i had to click in ISP manager=>sites onto each site setting and then SAVE.

I did it on 100+ sites, but this could be real nightmare with arround 1000 sites for example

Is there other way hot to deal with changing IP adresses for domains ?

[till]

Is there other way hot to deal with changing IP adresses for domains ?

Yes. You missed to change the IP in the table isp_isp_web and then set the table status to 'u'.

[edwintenhaaf]

Hello,

I'm moving to a new server and I want to know if the ispconfig version on both servers need to be the same for using the tutorial ?
How can I find out wich version I'm using ?

Thanks in advance

Edwin

[radim_h]

It definitelly has to be the same version, as update is modyfying the database sometimes.

So - upgrade first, or upgrade moved ISPC, but use same version when migrating server
Version of your ISPC could be find in ISPC menu TOOLS=>Software Version

Older versions to download are here
http://sourceforge.net/project/showfiles.php?group_id=140327

[edwintenhaaf]

Thanks for the advice I have moved all website's to the new server and upgraded ispconfig from 2.2.19 to 2.2.23.

There one problem left concerning suphp. Looks like ispconfig is using it's own suphp and this is giving me some problems using a gallery2 multisite install. the open_basedir in the users php.ini is not recognized with the new suphp.conf create by ispconfig. When I put back the original suphp.conf it's working again.

How can I use the suphp from ispconfig and still use the users php.ini (/var/www/web12/etc/php.ini) with the open_basedir setting pointing to the multisite gallery2 path

Edwin

[falko]

You can use your old suphp.conf, no problem.

[Turbanator]

I think I read through all of this, and if I missed something please forgive me.

I'm on ISPC 2.2.23 (latest stable) centos5.1 32bit and migrating over to FC9 x86_64 (perfect server howto) <--yeah not exactly stable but for server only and command line only I think I should be okay.

Will the instructions on page 1 of this thread from Falko still apply or will there be any changes? I'm guessing that instead of /home/www it would be /var/www correct?


BTW, thank you for a great product and awesome support.

[Feanwulf]

right - it is /var/www

i changed everything yesterday and it works fine (only some problems with suphp)

[crayz1]

I have read through this entire thread and have a question.

I am replacing my server with another. The hardware is different, but the OS and ispconfig are the exact same. Root and admin have the same password as the old server. The new server will use the same IP as the old as well. This is a complete physical replacement.

Will I be able to skip transfer steps? I know I will have to transfer the mysql database and www files.

[falko]

Since this is a replacement, you can skip the Postfix transport part.

[Turbanator]

ok I moved successfully (partially) from centos5.1 x86 to fc9 x86_64.

Here's my problem:
I followd the perfect server setup for fc9 and after ISPC I performed the proftpd customized setup.
#1: My emails are working find so I''m thinking it's NOT a password issue..but my FTP access isn't working. I cannot access the server using any login that was working previously on the old server for ftp.

#2: In the Site Management, if I UNCheck the FTP Access for this domain and save.....the checkmark doesn't go away. It stays regardless. (I was hoping to uncheck then recheck to reconfigure conf files).

I have also deleted users and added new and still doesn't work.

I'm sure it's user error (me), but I'm finally coming here for help.

[createch]

You may wish to check:

Under ISP config panel
management > server > services
is the FTP server "On" ?

management > server > settings > ftp
is the FTP program you choose is ProFTP ?
is the conf. File set as /etc/proftpd.conf ?

[Turbanator]

yep. ftp server is proftp, .conf is correct and on. I can connect to it, just won't accept any logins. I double checked my proftp* files were the same on the old server and new, and they are. BTW, the only files were proftpd.conf proftpd_ispconfig.conf
proftpd.conf.orig proftpd_ispconfig.conf~

And I just noticed that Web-ftp also isn't letting me in...(before
someone asks)
Error from web-ftp:
Could not connect as user web2_admin

Another Edit:
ssh for the above user is fine as well, so it's just an ftp thing.

Again, I'm on FC9 x86_64 .

[Turbanator]

Got it fixed thanx to Falko in
http://www.howtoforge.com/forums/showthread.php?t=196&page=2&highlight=ftp+login+failed

This was for fc6 but I still did the same for fc9...hopefully it's ok.

so maybe it was due to yum update jacking things up???

[kameleon25]

Hello:

I am following this guide to moving ISPconfig. I got to this part:



But I am not sure what it means.

I dumped all my databases using:



and then restored using:



So why would I need to add lines to the new server that are in the old server?

The users cannot accesses their databases either.

Any help is appreciated.

Aqua

I too am wondering about this. I did a complete dump as root and was hoping I got all the files. I am unable to get at the old install as there was hardware failure. But I do have the entire filesystem backup along with an entire sql dump and the other backups as described in post #2.

[till]

So why would I need to add lines to the new server that are in the old server?

The permissions to access the databases are stored in the user and db table of the mysql database, thats why you will have to move all records (users and database lines) created by ISPConfig in these tables to the new mysql installation.

[kameleon25]

So if I backed up the db with the following command I should be ok right?

mysqldump -u root -ppassword --lock-all-tables --all-databases > /root/mysql-backup/all-db.sql Just want to verify before I proceede.

[Feanwulf]

That is almost correct BUT

the "old" database mysql in that dump should not be inserted total just the lines ISPConfig added.

In my case i removed these INSERTs for root user and mysql database

[SupuS]

Hi all

I have to move live ispconfig installation with a lot of users to another server .. is there an easy way to prevent users changes in databases, ftp etc.? I suppose some kind of changes in Vhosts_ispconfig.conf for routing all hosted webs to "we are sorry" page, but I am not sure how to do it. Have anybody experience with moving live ispconfig installation and creating apologize page?

Thanks for replay
SupuS

[falko]

I'd simply switch off ISPConfig during the move. :)

[radim_h]

and
1. stop the FTP daemon
2 copy /var/www
3. stop apache
4. dump and import the database and shutdown mysql..
i'd prefer short services outage over inconsistent databases

[SupuS]

Thanks for replays

I would like to have some information page for customers about server moving .. but hopefully services outage will be only for a few time :)

[pendexgabo]

hi guys!

I'm just installing my new ISPConfig 2.2.25 in a new machine and my idea is move my old ISPConfig installation to this new one.

so I'd like to know if I could have some problem moving from 2.2.7 to 2.2.25, I mean, moving sites wont be a problem but I don't know if the ispconfig database of the 2.2.7 is compatible with the 2.2.25 schema, so can I do the move or should I move site per site?

thank you!

[till]

The database scheme is not 100% compatible. You will have to upgrade your old server to 2.2.25 before you move the database.

[pendexgabo]

The database scheme is not 100% compatible. You will have to upgrade your old server to 2.2.25 before you move the database.

thanks for your reply

Can I do it in one move? or need do it trough an earlier version before update to the 2.2.25?

tty!

[falko]

You can update directly to 2.2.25.

[na0lb]

maybe I am over looking it but where is the file (Vhosts_ispconfig.conf)

Lee

[till]

maybe I am over looking it but where is the file (Vhosts_ispconfig.conf)

Lee

That depends on the linux distribution. If you dont know the location of a file, use this command to find it:

locate Vhosts_ispconfig.conf

[pendexgabo]

We did the upgrade and went successfully.. from .14 to .25

thanks a lot for your help!

[na0lb]

Sorry I found the (locate Vhosts_ispconfig.conf) command one page 6 of this thread and found the file.

I am running ubuntu 8.04 & ISPConfig-2.2.25

Thank you for the reply

Lee

[na0lb]

My /www is /var/www should I just back up /www or also backup /var/

Lee

[falko]

/var/www should be enough. If you're using mbox instead of Maildir you should also back up /var/mail.

[na0lb]

Thank you Falko

The move worked great.
However I did run into one issue.
I followed the (http://www.howtoforge.com/perfect-server-ubuntu8.04-lts) how to with Ispconfig.
When I moved everything over Ispconfig would not connect to mysql.

I installed the backup with a different host name test-server1.example.com so it would not get confused with the main server1.example.com that was still online.
I went through and chaged host, hostname, and changed host in mysql but Ispconfig was still looking for test-server1.example.com what did I miss or should I have told mysql and Ispconfig to use localhost when I installed them.

Lee

[falko]

Thank you Falko

The move worked great.
However I did run into one issue.
I followed the (http://www.howtoforge.com/perfect-server-ubuntu8.04-lts) how to with Ispconfig.
When I moved everything over Ispconfig would not connect to mysql. Do you get any errors when you restart MySQL?

I installed the backup with a different host name test-server1.example.com so it would not get confused with the main server1.example.com that was still online.
I went through and chaged host, hostname, and changed host in mysql but Ispconfig was still looking for test-server1.example.com what did I miss or should I have told mysql and Ispconfig to use localhost when I installed them.
Please check that you've changed the hostnames in /root/ispconfig/httpd/conf/httpd.conf and /home/admispconfig/ispconfig/lib/config.inc.php.

[stanman]

Hi,
On my openvz server with ubuntu-minimal i'm planning to migrate the physical ispconfig server. Could i do this using this post? Or are there any known differences?

Great tutorial

[falko]

No, there are no differences.

[gili]

Hello Falko!

I have a question, I make a mistake :(. The ispconfig working since 1 year. I tried upgrade but that not work, and I forgot make a backup from ISPConfig :(.
I have another server, where I install the new ISPConfig, and I see the db_ispconfig database has 54 table, but I have only 52. That will be a problem when I import the dump from the dead server?

What do you think?
Bye
Gili

[gili]

db_ispconfig has 52 table on dead server

[falko]

I have another server, where I install the new ISPConfig, and I see the db_ispconfig database has 54 table, but I have only 52. That will be a problem when I import the dump from the dead server?

What do you think?
Bye
Gili
Yes, that doesn't work.
Please check your /tmp folder on the dead server, you should find backups of /root/ispconfig, /home/admispconfig, and your ISPConfig database there.

[DaFux]

Thank you - that has helped me a lot!
http://www.hoppenrath.com/isp/avatar_e.jpg

[oriongr]

I made this script according to Falko's post



#!/bin/bash
#Backup tool for ISPconfig v. 0.11
today=`date +%d-%m-%y`
cp /etc/passwd /root/backups
cp /etc/shadow /root/backups
cp /etc/group /root/backups
cp /etc/apache2/vhosts/Vhosts_ispconfig.conf /root/backups
cp /etc/postfix/local-host-names /root/backups
cp /etc/postfix/virtusertable /root/backups
cp /var/lib/named/etc/bind/named.conf /root/backups
cp /etc/proftpd*.conf /root/backups
cp /var/lib/named/etc/bind/pri.* /root/backups
cd /root/backups
mysqldump -h localhost -u root -pTYPEYOURPASS -c --add-drop-table --add-locks --all --quick --lock-tables -all-databases > sqldump_$today
cd /root
tar pczf backup_$today.tar.gz backups
mutt -s "Daily Backup for $today" -a /root/backup_$today.tar.gz YOUR@MAIL.HERE < The backup created!
mv backup_$today.tar.gz /root/backups/
rm /root/backups/*


I call it backup.sh and I run it from /root
Before you run it create a directory backups inside root
It keeps a copy in your root dir and also sends a copy by email if you want..
I moved the ISPconfig from one server to another with almost no problem
the only problems I had ws with db users and the passwords...

Thanks

[brainz]

Or if i can make a suggestion...

I recently moved from one server to another with my ispconfig i used....

Clonevilla which worked magically.... all i had to do after creating the clone was this...

change or delete /etc/udev/rules.d/z25_persistent-net.rules (will
be regenerate on boot) to the new NIC is eth0

Offcourse the above to items are for Debian Etch or Debian based distributions.

and rebooted the server and the clone was now the live server and i havent had a problem with the clone since.

It seems as well it will allow for large drives as well, i went from a 80 gig drive to a 400 gig drive with ease.


regards
brainz :D

[oriongr]

Do you have physical access to the server?

[brainz]

Do you have physical access to the server?

Yes i do... Physical access to but original server and clone server however i cloned the image using clonevilla to a ftp server which happens to be a NAS.

Then from the image on the NAS i cloned the new or soon to be live server.


regards
brainz :D

[shawnbishop]

I had a ISPConfig failure on Friday, I then reinstalled a new server with updated packages and then using my backup from ISPConfig from last week, go to find the restore button, cant find it...search through the forums and see I had to backup all the /etc/* files for the backup...

really silly as my backup is then useless!!!, the HDD failed on the old machine...whats the poitn of a backup if you need files form another system that werent in the backup..rather call it a partial backup..really peeved now...:mad:

[wr19026]

Do i have to transfer /etc/passwd, /etc/shadow, /etc/group, /etc/postfix/local-host-names, /etc/postfix/virtusertable before i restore the old database?
those files seems to be correctly created after IPSC is restarted after restoring database..

Just so that I understand correctly; after I have done the original server setup, install ISPConfig and then restore the ISPConfig database - /etc/passwd/etc/shadow and /etc/group will be updated by the restore process to add my ISPConfig users? The recommendation to compare those files is purely to catch any possible problems?

[till]

The recommendation to compare those files is purely to catch any possible problems?

No. You have to copy all relevant lines from the old to the new server manually in these files.

[wr19026]

Ok thanks. Not what I had hoped for but you can't have everything I guess :)

[esezako]

hi, the numbers of groups and users not match in my olds and news files passwd , shadow and group. What numbers should I keep?

[Ovidiu]

trying to export from MySQL version 5.0.51 via h1550830:~/.ftplicity# mysql -h localhost -u root -pmyPass -c --add-drop-table --add-locks --all --quick --lock-tables web6db5 > /root/web6db5.sql
mysql: unknown option '-c' as shown here: http://www.howtoforge.com/faq/6_3_en.html

can someone please explain what to use instead of this -c switch?

ok, seems the -c switch is obsolete, so I tried the replacement --skip-auto-rehash:

h1550830:~/.ftplicity# mysql -h localhost -u root -pmyPass --skip-auto-rehash --add-drop-table --add-locks --all --quick --lock-tables web6db5 > /root/web6db5.sql
mysql: unknown option '--add-drop-table'
h1550830:~/.ftplicity#


stil no go?

[Ovidiu]

I tried exporting/importing via phpmyadmin as its a small DB but then I get this type of errors in every table: The following indexes appear to be equal and one of them should be removed: comment_author_url, comment_author_url_2
The following indexes appear to be equal and one of them should be removed: PRIMARY, comment_ID_2
The following indexes appear to be equal and one of them should be removed: comment_post_ID, comment_post_ID_2
The following indexes appear to be equal and one of them should be removed: comment_date_gmt, comment_date_gmt_2
The following indexes appear to be equal and one of them should be removed: comment_approved, comment_approved_2
The following indexes appear to be equal and one of them should be removed: PRIMARY, comment_ID

[falko]

trying to export from MySQL version 5.0.51 via as shown here: http://www.howtoforge.com/faq/6_3_en.html

can someone please explain what to use instead of this -c switch?

ok, seems the -c switch is obsolete, so I tried the replacement --skip-auto-rehash:



stil no go?
You might want to try the --opt switch.

[Ovidiu]

as in replacing the -c with --opt? don't have ssh access right now so I can't consult the man pages right now...

[falko]

The --opt switch replaces multiple other switches. Please take a look at the man page.

[Ovidiu]

tried man mysql and gogling but nowhere is there an --opt switch mentioned...

seee here too: http://dev.mysql.com/doc/refman/5.0/en/mysql-command-options.html

[falko]

Oh, sorry. The mysqldump command has an --opt switch...

[kextra1]

I really screwed up guys

I messed up all my permissions from /

I am trying to move all ISPConfig data over to a new server

I followed the steps however the MySQL server does not start after following the moving ispconfig steps

Also, before the permissions got all screwed up on this server I backed up all the databases to 'Localhost.sql'

My new server does not have a graphics card....

How can I import all my databases from 'localhost.sql' into the new mysql server from the command line?

I'm not talking about one at a time...i backed them ALL up, ALL DB's to one sql dump

[reason8]

Make a backup of /etc/passwd, /etc/shadow, /etc/group, Vhosts_ispconfig.conf, /etc/postfix/local-host-names, /etc/postfix/virtusertable, named.conf, all the pri.* zone files, /etc/proftpd*.conf. Also create sql dumps of your MySQL databases (either with phpMyAdmin or on the command line: http://www.howtoforge.com/faq/6_3_en.html ) and make a backup of /home/www on the old server:

cd /home
tar -pczf www.tar.gz www/
Stop Postfix: /etc/init.d/postfix stop
If you use mbox, also make a backup of /var/spool/mail:
cd /var/spool
tar -pczf mail.tar.gz mail/ If you use Maildir, the mailboxes are included in www.tar.gz.

On the new server:
First install ISPConfig.
Create the databases from the sql dumps (either with phpMyAdmin or like this: http://www.howtoforge.com/faq/6_4_en.html ). Also replace the ISPConfig database with the old one.
Regarding the mysql database: have a look at the users and db table and add the user /db lines that don't exist on the new server but on the old server.
Copy local-host-names and virtusertable to /etc/postfix; open local-host-names and replace the old hostname with the new one. Run postmap /etc/postfix/virtusertable and restart Postfix.
Replace Vhosts_ispconfig.conf with the one from the old server; then open it and replace the old IP address with the new one. Transfer www.tar.gz to /home and unpack it:
cd /home
mv www www_orig
tar xvfz www.tar.gz
If you had to make a backup of /var/spool/mail, transfer mail.tar.gz to /tmp and do this: cd /tmp
tar xvfz mail.tar.gz
cd mail
cp -pf web* /var/spool/mail/
Have a look at your backups of /etc/passwd, /etc/shadow and /etc/group and add the lines that don't exist in these files on the new server to /etc/passwd, /etc/shadow and /etc/group on the new server.
Transfer named.conf and all pri.* files to the new server. Also all proftp*.conf files; open them and replace the old IP address with the new one - also do this with the file names of the proftpd*.conf files. Restart ProFTPd: /etc/init.d/proftpd restart
Restart Apache: /etc/init.d/apache restart
Log in to ISPConfig and go to Management -> Server -> Settings and change the IP address(es) there. Then go to the DNS Manager and also changes the IP addresses in the DNS records, if necessary.

On the old server, create a Postfix transport now so that all emails are forwarded to the ne server (for the time until the MX records of your domains have switched to the new server):
echo "* smtp:[<IP address of new server>]" >> /etc/postfix/transport
postmap /etc/postfix/transport
/etc/init.d/postfix restart

On the new server, open /etc/postfix/local-host-names and add the hostname of the old server at the bottom so that the new server accepts the forwarded mails.


Lots of steps to do... (if you want, you can have Till and me do that, but it's not free. Have a look here: http://www.ispconfig.org/support.htm ).

What if you dont have a Vhosts_ispconfig.conf? I have /etc/apache2/sites-available/ispconfig.conf and /etc/apache2/sites-enabled/000-ispconfig.conf
Also, I dont know what I named the MySQL DB (not exactly atleast). Where would I find this in the config files? I did a updatebd and locate but nothing is coming up.

Thanks!

[till]

This thread is about ISPConfig 2 and not ISPConfig 3! ISPConfig 2 is a completely different software and everything posted about ISPConfig 2 does not apply to ISPConfig 3.

[thetekgeek]

I followed this tutorial (in post #2) to move my ispconfig to a new server.

Everything went well, until I went to log into ISPConfig on port 81.

This is what I get


Warning: session_start() [function.session-start]: open(/tmp/sess_48970c3d56568db252bbc22664b59850, O_RDWR) failed: Permission denied (13) in /home/admispconfig/ispconfig/web/login.php on line 29

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/admispconfig/ispconfig/web/login.php:29) in /home/admispconfig/ispconfig/web/login.php on line 29

Warning: include(../lib/config.inc.php) [function.include]: failed to open stream: Permission denied in /home/admispconfig/ispconfig/web/login.php on line 30

Warning: include() [function.include]: Failed opening '../lib/config.inc.php' for inclusion (include_path='.:') in /home/admispconfig/ispconfig/web/login.php on line 30

Warning: require_once(login/lib/lang/.lng) [function.require-once]: failed to open stream: No such file or directory in /home/admispconfig/ispconfig/web/login.php on line 31

Fatal error: require_once() [function.require]: Failed opening required 'login/lib/lang/.lng' (include_path='.:') in /home/admispconfig/ispconfig/web/login.php on line 31

Warning: Unknown: open(/tmp/sess_48970c3d56568db252bbc22664b59850, O_RDWR) failed: Permission denied (13) in Unknown on line 0

Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/tmp) in Unknown on line 0


I am not sure why. I am sure that I replaced something in a config file that I should not have, but not sure where to look.

Any ideas?

[brainz]

From what i can tell it seems to be a permissions problem...

also there is a file missing...

No such file or directory in /home/admispconfig/ispconfig/web/login.php on line 31

But ill let the experts... Take over from here..

regards
brainz

[falko]

What are the outputs of ls -la /tmp/ and df -h?

[thetekgeek]

output of: ls -la /tmp/

total 36
drwxrwxrwt 4 root root 4096 2009-07-19 04:29 .
drwxr-xr-x 23 root root 4096 2009-07-17 08:46 ..
drwxrwxrwt 2 root root 4096 2009-07-17 08:46 .ICE-unix
drwxrwxr-x 2 root mail 4096 2009-07-17 08:10 mail
-rw------- 1 root root 1024 2009-07-16 08:50 .rnd
-rw------- 1 root root 0 2009-07-18 00:30 sess_09456af3aa07623da0c27305b3776 ef2
-rw------- 1 root root 0 2009-07-18 23:59 sess_0e5d16e22cbe637203dfc933e4b32 594
-rw------- 1 root root 0 2009-07-16 17:51 sess_197d9fe80c038b86dd6d20e60a6a0 b4a
-rw------- 1 root root 0 2009-07-19 00:40 sess_27effcddfec1b66c7dd0793f2944f b71
-rw------- 1 root root 0 2009-07-17 00:30 sess_2f8c5c03eac50a665320fb04f3e24 fb5
-rw------- 1 root root 0 2009-07-19 04:00 sess_36c5a559dde3fce5d9b8dcf4eb52d 24d
-rw------- 1 root root 0 2009-07-16 23:59 sess_383de5cc11b0a41e93aee51995b7f e83
-rw------- 1 500 500 25 2009-07-16 17:35 sess_48970c3d56568db252bbc22664b59 850
-rw------- 1 root root 0 2009-07-18 15:15 sess_4e998de5a51d85170a34f826c626f 88c
-rw------- 1 root root 0 2009-07-18 03:15 sess_6277ac4e00b8b84ef957fe3984522 8d1
-rw------- 1 root root 0 2009-07-17 09:01 sess_73afb68c505ec1acb6ed75b07b2fb fd1
-rw------- 1 root root 0 2009-07-17 00:40 sess_7c35e40e27fa2e512d570eb7180e3 920
-rw------- 1 root root 0 2009-07-17 23:59 sess_8584b5cd41843f1cf645c6cec0846 221
-rw------- 1 root root 0 2009-07-18 00:40 sess_898608bde95fd078b527c371dd0d9 537
-rw------- 1 root root 0 2009-07-18 02:05 sess_8b9fef10d5acb7afb087413d136f0 215
-rw------- 1 root root 0 2009-07-19 00:30 sess_8d4d91f857576a47691a62e5bc78c 8d5
-rw------- 1 root root 0 2009-07-17 23:59 sess_8e6abc0c723111ca98c7315f0888f 6dc
-rw------- 1 root root 0 2009-07-18 23:59 sess_9253f347cb3d71f38dcf282dab6b2 4d4
-rw------- 1 root root 0 2009-07-19 02:05 sess_95cd348c2299dc14455cb5a6fe8b2 4b0
-rw------- 1 root root 0 2009-07-16 16:12 sess_9d80cce08844c89cdf2aebcbc1535 4bb
-rw------- 1 root root 0 2009-07-17 08:46 sess_a9574237f32f72f848371da909f72 c17
-rw------- 1 root root 0 2009-07-16 23:59 sess_a9e291a5a434a5c693c8b382ae6a4 47e
-rw------- 1 root root 0 2009-07-17 04:00 sess_aa3fd84cecc49628808c9cc2e8baa fd1
-rw------- 1 root root 0 2009-07-17 02:05 sess_ad753448694ad6135361296418ef0 3f5
-rw------- 1 root root 0 2009-07-19 03:15 sess_af6bf170da870e1858b2d104c18c1 35f
-rw------- 1 root root 0 2009-07-17 03:15 sess_bbf72f00947cdd7167e21ad0c1db4 472
-rw------- 1 root root 0 2009-07-16 23:59 sess_c5ceeb930311ccf2c64e11bc25717 e9d
-rw------- 1 root root 0 2009-07-18 04:00 sess_cb039e684d40073795a7db035df21 07c
-rw------- 1 root root 0 2009-07-17 23:59 sess_d671c468c24da27a8ccdcdadf2411 94e
-rw------- 1 root root 0 2009-07-17 15:15 sess_decf60161fde62e1fa7cecc57093c bdd
-rw------- 1 root root 0 2009-07-18 23:59 sess_f33260b4147009c6b17ded9a7ce0d 400
-rw------- 1 root root 0 2009-07-16 16:12 sess_fb7fdfcb8566c0fad14e94bb6d3e0 b1c


output of: df -h

Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
72G 3.0G 65G 5% /
/dev/sda1 190M 13M 169M 7% /boot
tmpfs 220M 0 220M 0% /dev/shm

[falko]

Can you run
rm -f /tmp/sess_*
and try again?

[thetekgeek]

After running

rm -f /tmp/sess_*

I get this when I try to log into the admin console



Warning: include(../lib/config.inc.php) [function.include]: failed to open stream: Permission denied in /home/admispconfig/ispconfig/web/login.php on line 30

Warning: include() [function.include]: Failed opening '../lib/config.inc.php' for inclusion (include_path='.:') in /home/admispconfig/ispconfig/web/login.php on line 30

Warning: require_once(login/lib/lang/.lng) [function.require-once]: failed to open stream: No such file or directory in /home/admispconfig/ispconfig/web/login.php on line 31

Fatal error: require_once() [function.require]: Failed opening required 'login/lib/lang/.lng' (include_path='.:') in /home/admispconfig/ispconfig/web/login.php on line 31


Seems better than before.

[thetekgeek]

I did a reinstall of ISPConfig by downloading the install package again, it went through the install and everything seems to work now.

[pbrille]

I'm moving from an old Suse 10.1 Server with ISPConfig 2.2.16 to a new Debian Lenny with ISPConfig 2.2.25.
What do I need to know in this special scenario when moving all my files?
Can I just do a full "mysqldump --all-databases" on the old server and then fully restore on the new server?

Thanks a lot!

[kameleon25]

In my experiences it would be best to go ahead and update the old box to the new version of ISPConfig or install the old version on the new box. Same version transfers are usually less trouble. Beyond that, just dump your entire database, move the files, restore database, and you are basically done.

[pbrille]

I read in another post that mysql version need to be identical for transfer. In my enviroment both servers use different versions of mysql.
So will I get problems when doing a dump and restore or when just copying what's within /var/lib/mysql...

THX!

[klaus++]

Apparently I just finished soemthing impossible: I moved from an "old server" running ISPConfig 2.2.29 to a "new server" running 2.2.37.

I had to do an emergency recovery of a crashed server. I was able to backup all SQL databases in a dump and to perform an backup as described here http://www.howtoforge.com/forums/showthread.php?t=2717
Afterwards I installed ISPConfig 2.2.37 following http://www.howtoforge.com/perfect-server-opensuse-11.3-x86_64-ispconfig-2
Having done this I restored all data an got an error message "The requested document type does not exist." each time I tried to change any user or website settings inside ISPConfig. So I reinstalled ISPConfig 2.2.37 and the problem was solved.

Sometimes one has to post a success story just to say thank you to the developers and all forum contributors!

[klaus++]

Using mysqldump and mysql on the command line or phpmyadmin there shouldn't occur any problems. You will have to take care not to mix up codepages. If you get scrambled special caracters you will find additional informations in in these forums and in the Mysql doc.

[gauthier]

Hi,

Yesterday I migrate to a new server using information I get in this post. All is running fine now, so this is another success story.

I am not an expert at all, but I would like to share this little "how to" have made using contributions I have read here and on others places. I have no doubt the migration can be done better but at least this way worked fine for me.

I have ISPconfig 2.2.37 running on debian 5.

I did not created the Postfix transport to forward emails to the new server (should be added to this howto).

Of course I am not sure there is no error, you do this howto at your own risk.

If you see something have to be added or corrected, please let us know.

I hope this will help some of you.



// OLD SERVER

//if not done, update ispconfig2 to the latest version
// I assume you have created the cpdb.bash file and make it runnable by: "chmod a+x cpdb.bash" the containing of the cpdb.bash file is at the end of this text.

// create your backups folder if you do not already have one:
cd /root
mkdir backups

// create a "today" directory
today=`date +%d-%m-%y`
cd /root/backups
mkdir $today
cd $today

// I will create 3 compressed files that are "data.tar.gz", "www.tar.gz" and "tarsql"

mkdir data

/etc/init.d/postfix stop

//if one of the following lines fails, use "locate" to find where are the needed files on your server:
//example: locate pri.*
//before using locate, it is good to run updatedb
//if locate is not installed on your server, run "apt-get install locate" and then run "updatedb"

cp /etc/passwd /root/backups/$today/data
cp /etc/shadow /root/backups/$today/data
cp /etc/group /root/backups/$today/data
cp /etc/apache2/vhosts/Vhosts_ispconfig.conf /root/backups/$today/data
cp /etc/postfix/local-host-names /root/backups/$today/data
cp /etc/postfix/virtusertable /root/backups/$today/data
cp /var/lib/named/etc/bind/named.conf /root/backups/$today/data
cp /etc/proftpd*.conf /root/backups/$today/data
cp /var/lib/named/etc/bind/pri.* /root/backups/$today/data

/etc/init.d/postfix start

// emails received from now will not be included in the backup.

tar -pczf data.tar.gz data/
rm -r data


./cpdb.bash
tar -pczf tarsql *.sql
rm *.sql

// changes in your databases from now will not be included in the backup

tar -pczf www.tar.gz /var/www/
// (or replace by the folder containing your webs)


// NEW SERVER

//Do the corresponding perfect setup as shown at "http://www.ispconfig.org/ispconfig-2/installation-instructions-for-ispconfig-2/"

// if you are using the remote framework (like me) do not forget:
apt-get install libxml2-dev

// I am supposing you only have remote access to your server, for in case your PC looses conexion to internet I would suggest this:
apt-get install screen
screen
//If you loose access to your server, you can reload the current shell using: "screen -rd"


// INSTALL ISPCONFIG
cd /root
mkdir ispconfig_temp
cd ispconfig_temp
wget -c http://sourceforge.net/projects/ispconfig/files/ISPConfig%202/ISPConfig-2.x.xx/ISPConfig-2.x.x.tar.gz/download
// (replace with the current link for last ispconfig version dowload)

tar xvfz ISPConfig-2.x.xx.tar.gz
cd install_ispconfig

//If you use remote framework:
vi compile_aps/compile
add the folowing line:
WITH_XML=""
just after the WITH_XML variable is beeing set, so that php will compile with XML in all cases.

//if you have already ran the ispconfig instalation and it failed, run:
mkdir /root/ispconfig

./setup

//check you have access to the control panel : "https://yourip:81"

cd /root
mkdir backups
cd backups
today=`date +%d-%m-%y`
mkdir $today
cd $today
apt-get install sftp
sftp ip_old_server
root
your_root_pass_on_old_server
get /root/backups/19-09-10/data.tar.gz (replace the date)
get /root/backups/19-09-10/www.tar.gz
get /root/backups/19-09-10/tarsql
exit


// MYSQL
mkdir db
mv tarsql db/
cd db
tar xvfz tarsql
rm tarsql
// this will make a good job I think:
perl -pi -e 's/old_ip/new_ip/g' db_ispconfig.sql
perl -pi -e 's/old_host/new_host/g' db_ispconfig.sql
perl -pi -e 's/old_domain/new_domain/g' db_ispconfig.sql

// if (like me) you have undreeds of databases, you can:
ls > list.txt
// download list.txt with filezilla on your pc and using a advanced text editor, you replace the "new line" character and make the file look like:
#!/bin/bash
#recovering dbs
mysql < database_1.sql -h localhost -u root -pyour_mysql_root_pass
mysql < database_2.sql -h localhost -u root -pyour_mysql_root_pass
mysql < database_3.sql -h localhost -u root -pyour_mysql_root_pass
mysql < database_4.sql -h localhost -u root -pyour_mysql_root_pass
mysql < database_5.sql -h localhost -u root -pyour_mysql_root_pass
.....
// relaod the list.txt
chmod a+x list.txt
./list.txt

// WWW
// (supposing your web files are in the /var/www/ file)
mv www.tar.gz /var/
cd /var
mv www www_delete_me_if_all_ok
tar xvfz www.tar.gz

// DATA
cd /root/backups/18-09-10
tar xvfz data.tar.gz

// have a look at passwd, shadow, group files and if necesary update them with files from old server changing ip, host and domain.
// use the perl command:
perl -pi -e 's/old_string/new_string/' file

// you will have to do it at least with the pri.*, proftpd* and Vhosts_ispconfig.conf files:

perl -pi -e 's/old_ip/new_ip/g' pri.*

perl -pi -e 's/old_ip/new_ip/g' proftpd*
perl -pi -e 's/old_host/new_host/g' proftpd*
perl -pi -e 's/old_domain/new_domain/g' proftpd*

perl -pi -e 's/old_ip/new_ip/g' Vhosts_ispconfig.conf
perl -pi -e 's/old_host/new_host/g' Vhosts_ispconfig.conf
perl -pi -e 's/old_domain/new_domain/g' Vhosts_ispconfig.conf

cd /var/lib/named/etc/bind/
mkdir bind_delete_me_if_all_ok
cp * bind_delete_me_if_all_ok/
cp /root/backups/18-09-10/data/pri.* /var/lib/named/etc/bind/

cd /etc

mkdir proftpd_delete_me_if_all_ok
mv proftpd.conf proftpd_delete_me_if_all_ok/
mv proftpd_ispconfig.conf proftpd_delete_me_if_all_ok/
cp /root/backups/18-09-10/data/etc/proftpd.conf /etc/
cp /root/backups/18-09-10/data/etc/proftpd_ispconfig.conf /etc/


//check files in /etc/apache2/vhosts and /etc/postfix and replace them if necesary

/etc/init.d/proftpd restart
/etc/init.d/apache2 restart


https://yourip:81
enable Maildir under Management -> Server -> Settings -> EMail in the ISPConfig web interface

Change nameserver ns1 and ns2 to the new server ip.

If all ok, "locate delete_me_if_all_ok" and remove.




///// CONTAINING OF cpdb.bash FILE ////////
CMD_MYSQL="/usr/bin/mysql"
CMD_MYSQLDUMP="/usr/bin/mysqldump"
# login credentials of the submitting side
DB_USER_FROM="root"
DB_PASS_FROM="your_root_pass_for_mysql"
DB_HOST_FROM="localhost"
# index all databases on the local (submitting) side
echo "database sync"
DATABASES=`echo "SHOW DATABASES;" | ${CMD_MYSQL} -p${DB_PASS_FROM} -u ${DB_USER_FROM} -h ${DB_HOST_FROM}`
for DATABASE in $DATABASES; do
# skip non-databases
if [ "${DATABASE}" != "Database" ] && [ "${DATABASE}" != "information_schema" ]; then
${CMD_MYSQLDUMP} -Q -B --create-options --delayed-insert --complete-insert --quote-names --add-drop-table -p${DB_PASS_FROM} -u${DB_USER_FROM} -h${DB_HOST_FROM} ${DATABASE} > ${DATABASE}.sql
fi
done

[TomC]

Hi Falko,

a huge thank you for this fantastice howto that helped me loads.

On the old server, create a Postfix transport now so that all emails are forwarded to the ne server (for the time until the MX records of your domains have switched to the new server):
echo "* smtp:[<IP address of new server>]" >> /etc/postfix/transport
postmap /etc/postfix/transport
/etc/init.d/postfix restart

On the new server, open /etc/postfix/local-host-names and add the hostname of the old server at the bottom so that the new server accepts the forwarded mails.


Being in the process of moving my ISPConfig 2 installation to another server (which is going to have the same hostname.domainname, just another IP address), I was wondering if there is a way to create a transport that

...sends every mail to the IP address of the new server (as described)
...plus delivers the mail locally, as Postfix always used to.

By this means it wouldn't be an issue how long the DNS transition of the domainnames would take. Mail-wise, the two machines would always be in sync.

Could you give me a pointer on how to confure a postfix transport that would do exactly this?!

Thanks and regards,
Tom

[Ovidiu]

Can this advice be used to migrate from Debian Lenny ISPCFG3 to Debian Squeeze ISPCFG3?

What is the easiest way to sync emails? I mean keep them in sync for a few days until the MX-records become active?

and btw. if I am using the method described here to import: http://www.howtoforge.com/faq/6_4_en.html I get an error. Right now trying to find a way to import the dump.


h1870666:~/old-stuff-import# mysql -h localhost -u root -pmysecret c1zice < c1zice.sql
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Warning: The option '--all' is deprecated and will be removed in a future releas' at line 1
h1870666:~/old-stuff-import#

[falko]

Can this advice be used to migrate from Debian Lenny ISPCFG3 to Debian Squeeze ISPCFG3?No, this is for ISPConfig 2, not 3.

What is the easiest way to sync emails? I mean keep them in sync for a few days until the MX-records become active?I'd use imapsync: http://www.howtoforge.com/how-to-migrate-mailboxes-between-imap-servers-with-imapsync

and btw. if I am using the method described here to import: http://www.howtoforge.com/faq/6_4_en.html I get an error. Right now trying to find a way to import the dump.

Please open c1zice.sql. There seems to be non-SQL syntax in it, like
Warning: The option '--all' is deprecated and will be removed in a future releas