Moving ISPconfig

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

 

Please make sure you use the correct password in /etc/mysql/debian.cnf for the debian-sys-maint user.

What's the output of

Code:

ls -la /etc/postfix

?

 

Code:

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

 

Did you run the postmap command as root?

 

yes i most certainly did :/

 

Please try

Code:

chown root:root /etc/postfix/virtusertable

 

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....

 

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..

 

Yes, but if your files seem to be ok, then it's fine, too.

 

Missing config line

Hi there

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

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

Code:

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

 

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 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.

 

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

 

Problem with isp_isp_domain IP change

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 ?

 

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

 

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

 

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

 

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

 

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.