Problems Moving an ISPConfig installation

[tomd]

I am trying to move my ISPConfig (2.2.6) installation that is on Ubuntu 6.06 to a Debian 3.1 system. I followed the guide in another forum thread ( http://www.howtoforge.com/forums/showthread.php?t=2717 ) and it worked pretty well until I came to moving the database.

Using PHPAdmin I made the SQL file output, but could not get the Debian system to accept the data. I believe the problem was a MySQL 5 (on Ubuntu) versus MySQL 4 (on Debian) problem. I failed with an error pointing to a line of SQL with "collation" in it. I think this is some sort of encoding issue. Once I removed the part of the SQL concerning character encoding the data went into the database fine.

I thought I was OK until I access the ISPConfig management area. It listed my sites, but when I clicked on one I got a error of "The requested document type does not exist." I found a thread that discussed this problem. ( http://www.howtoforge.com/forums/showthread.php?t=4094 ) This thread also talked about encoding issues. I could never resolve the problem and my hacking eventually killed the new system. (But I learn)

My question is this: In setting up the new Debian 3.1 system, should I installed MySQL 5 before installing ISPConfig - or is there other approach I should take?

[till]

Originally Posted by tomd

My question is this: In setting up the new Debian 3.1 system, should I installed MySQL 5 before installing ISPConfig - or is there other approach I should take?

Yes, please setup a mysql5 database on debian from dotdb or backports. The error you get is caused by the diferences in the database dumps between mysql 4 and 5.

[tomd]

I had not heard of these, but this is a good source.

Backports.org has clearer instructions than dotdeb.org so I will try this.

To confirm, I add the backports.org info to the apt sources.list

Then make (or modify) the preferences file with:

Package: mysql-server
Pin: release a=sarge-backports
Pin-Priority: 999

Package: mysql-client
Pin: release a=sarge-backports
Pin-Priority: 999

Package: libmysqlclient12-dev
Pin: release a=sarge-backports
Pin-Priority: 999

Then carry on with the install as instructed in the perfect sarge setup

Tom

[lunardi]

Hy Tomd,

I have same problem !!! Look message to send "support ispconfig":
------------------------------------
Hy

My name is Marco.
I'm brazilian and sorry my BAD english.
Congratulations for good work of ISPConfig !!!

I need help for ISPConfig.

I have:

(Machine 1) - An machine with Ubuntu 6.06 and ISPConfig 2.2.7 running perfect. Hosting
10 domains and 500 users mails (including the messages).

(Machine 2) - New machine with Ubuntu 6.10 and ISPConfig 2.2.8.

Now, my question:
What transfer all "domains and mails" from Machine 1 for Machine 2 ?

Thanks
-----------------------------------------
Tomd,

you to solve your problem ?
Lunardi

Originally Posted by tomd

I am trying to move my ISPConfig (2.2.6) installation that is on Ubuntu 6.06 to a Debian 3.1 system. I followed the guide in another forum thread ( http://www.howtoforge.com/forums/showthread.php?t=2717 ) and it worked pretty well until I came to moving the database.

Using PHPAdmin I made the SQL file output, but could not get the Debian system to accept the data. I believe the problem was a MySQL 5 (on Ubuntu) versus MySQL 4 (on Debian) problem. I failed with an error pointing to a line of SQL with "collation" in it. I think this is some sort of encoding issue. Once I removed the part of the SQL concerning character encoding the data went into the database fine.

I thought I was OK until I access the ISPConfig management area. It listed my sites, but when I clicked on one I got a error of "The requested document type does not exist." I found a thread that discussed this problem. ( http://www.howtoforge.com/forums/showthread.php?t=4094 ) This thread also talked about encoding issues. I could never resolve the problem and my hacking eventually killed the new system. (But I learn)

My question is this: In setting up the new Debian 3.1 system, should I installed MySQL 5 before installing ISPConfig - or is there other approach I should take?

[lunardi]

Originally Posted by tomd

I am trying to move my ISPConfig (2.2.6) installation that is on Ubuntu 6.06 to a Debian 3.1 system. I followed the guide in another forum thread ( http://www.howtoforge.com/forums/showthread.php?t=2717 ) and it worked pretty well until I came to moving the database.

Using PHPAdmin I made the SQL file output, but could not get the Debian system to accept the data. I believe the problem was a MySQL 5 (on Ubuntu) versus MySQL 4 (on Debian) problem. I failed with an error pointing to a line of SQL with "collation" in it. I think this is some sort of encoding issue. Once I removed the part of the SQL concerning character encoding the data went into the database fine.

I thought I was OK until I access the ISPConfig management area. It listed my sites, but when I clicked on one I got a error of "The requested document type does not exist." I found a thread that discussed this problem. ( http://www.howtoforge.com/forums/showthread.php?t=4094 ) This thread also talked about encoding issues. I could never resolve the problem and my hacking eventually killed the new system. (But I learn)

My question is this: In setting up the new Debian 3.1 system, should I installed MySQL 5 before installing ISPConfig - or is there other approach I should take?

Hy Tom,

I have same problem.
You to solve your problem ? If yes, help me.
Thanks
Lunardi

[tomd]

Did you follow the instructions in this forum post?
http://www.howtoforge.com/forums/showthread.php?t=2717

I would think that since you are staying on Ubuntu (just 6.06 to 6.1) you would not have the database problem I am having by moving to Debian.

Tom