Moving ISPconfig

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?

 

Run

Code:

dpkg -l

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

 

concerning

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

 

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

 

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

 

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

 

Yes, you need to chroot.

 

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:

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

###edit###

how can I do this:

 

Do you use the same MySQL version on both systems?

 

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:

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

 

It's working for me. I get a white page, but it's working.

 

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.

 

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.

 

thx.

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

 

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:

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 ?

 

Run

Code:

crontab -e

and then restart cron:

Code:

/etc/init.d/cron restart

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?

 

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.

 

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