42go to ISPconfig

[Jorem]

Is there a way to go from 42go to ISPconfig?

I have a new server and would like to install 42go on it. But then I can only install CentOS 4.2 on it. ISPconfig also works with 4.4. The support on the forum is better. More updates with extra features. That are the main reasons why I became a member here.

Now ISPconfig also has the remoting function, so I don't see why I have to stay with 42go. Now is my question: How can I go from 42go to ISPconfig?

Thanks for your help.

[Hans]

Performing an update from 42go to ISPConfig is not possible.

[Jorem]

I know that an update is not possible.

But when I install ISPconfig on the new server. Is there a way to update the database with the data from my 42go database?

If I can do that I am halfway there I think. I maybe have to change some setting in the database to the new install (42go path to ispconfig path)?

[till]

You can try the following solution:

1) Install ISPConfig on the new server.
2) Export the data from your 42go installation, except of the tables isp_server, isp_server_ip and doctype. The exported data must consis of full insert staements.
3) Make a backup of your ISPConfig database, then empty all tables except of the tables isp_server, isp_server_ip and doctype.
4) Import the data from (2) into the almost empty ISPConfig database.
5) Move the data from your document root, and the system users to the new server as described in several posts that you will find when you search for "move ispconfig" in the forum.

I've not tested it, but I guess it will work.

[Jorem]

Thanks Till. I will give it a try tomorrow.

[Jorem]

I did the steps you discribed but i have an error now.

When I look at an account eveything looks OK. But when I click on one of the tabs like users and email or options I get an error. It sais: missing web_traffic_ueberschreitung

I looked it up in de sql file and found that it is missing in 42go when i compare it to the sql from ispconfig. it is a row in isp_isp_web. When I add this line I get a error when I try to load the sql into the database in phpmyadmin.

This are the lines that are missing in the 42go sql compared to the ispconfig:
`web_traffic_ueberschreitung` varchar(255) default NULL,
`web_traffic_status` varchar(255) default NULL,
`webalizer_stats` char(1) default '1',

What do have to change to make it work properly. I think I am almost there : ).

Thanks for your help.

[till]

It looks like you used the database layout from 42go instead the layout from ISPConfig. You must import the data from your old database ad not the table definitions.

3) Make a backup of your ISPConfig database, then empty all tables except of the tables isp_server, isp_server_ip and doctype.

The tables must be emptied and not deleted. Please follow exactly the steps I outlined above. and do not delete any database table in the ISPConfig database, delete only the data in the tables.

[Jorem]

When I do the steps I get this error now:

INSERT INTO isp_isp_reseller
VALUES ( 1, 1022 therestofthedata

Error:
#1136 - Column count doesn't match value count at row 1

What does this mean?

[till]

Thats why you must use full insert statements that contain the field names too and not only the data, as I posted above.

The exported data must consis of full insert staements.

[Jorem]

Sorry Till, I don't understand what you mean with full insert statement. I have the data exported and it looks like this in the sql file.

INSERT INTO `dns_a` VALUES (176, 1018, 'localhost', '127.0.0.1');

In phpMyAdmin I have it exported as INSERT. Without the structure.

Is there an export setting that I missed? Can I select Full insert statement somewhere?