Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 5th December 2006, 21:43
tomd tomd is offline
Junior Member
 
Join Date: Sep 2006
Location: Dallas, Texas
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
Default Problems Moving an ISPConfig installation

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?
Reply With Quote
Sponsored Links
  #2  
Old 6th December 2006, 11:10
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 34,573
Thanks: 792
Thanked 4,980 Times in 3,901 Posts
Default

Quote:
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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 6th December 2006, 14:34
tomd tomd is offline
Junior Member
 
Join Date: Sep 2006
Location: Dallas, Texas
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #4  
Old 6th December 2006, 14:13
lunardi lunardi is offline
Member
 
Join Date: Dec 2006
Location: Brazil
Posts: 49
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Skype™ to lunardi
Default Problem to transfer domains/users/database ISPconfig

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



Quote:
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?
Reply With Quote
  #5  
Old 6th December 2006, 15:41
lunardi lunardi is offline
Member
 
Join Date: Dec 2006
Location: Brazil
Posts: 49
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Skype™ to lunardi
Default

Quote:
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
Reply With Quote
  #6  
Old 7th December 2006, 00:15
tomd tomd is offline
Junior Member
 
Join Date: Sep 2006
Location: Dallas, Texas
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ISPConfig after installation CoDonCo Installation/Configuration 46 14th July 2010 16:54
newbie ububtu 6.0.6 error PHP binary line 816 davidsky73 Installation/Configuration 8 17th September 2006 11:51
Ispconfig update problems from 2.4 to 2.6 adrenalinic Installation/Configuration 23 7th September 2006 12:58
SP-Server Setup - Ubuntu 5.10 "Breezy Badger" - Page 6 (changes) LuisC-SM HOWTO-Related Questions 0 21st April 2006 15:16
Problems getting through the installation klausagnoletti Installation/Configuration 4 26th September 2005 12:23


All times are GMT +2. The time now is 21:40.


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