Migrate CPanel to ISPConfig

[dolvito]

I'm new at using ISPConfig, I still have a server running with CPanel.

I was thinking about migrating my CPanel server to a ISPConfig server.
There are 2 things that crossed my mind after testing ISPConfig


If I create a new web account on the CPanel server de document structure is
/home/<username>/public_html/
/home/<username>/public_ftp/
/home/<username>/www ---> public_html

In ISPConfig the document structure is
/var/www/web1/
/var/www/www.domain.com ---> web1


If a client creates a database the naming of the database with CPanel can be done by the client, the user naming as well.

The naming of a database in CPanel is like this.
<username>_<client_db_name>


Is it possible to change these settings in ISPConfig so migrating from CPanel to ISPConfig can be maid possible easier?

Kind Regards

[till]

I'm new at using ISPConfig, I still have a server running with CPanel.

I was thinking about migrating my CPanel server to a ISPConfig server.
There are 2 things that crossed my mind after testing ISPConfig


If I create a new web account on the CPanel server de document structure is
/home/<username>/public_html/
/home/<username>/public_ftp/
/home/<username>/www ---> public_html

In ISPConfig the document structure is
/var/www/web1/
/var/www/www.domain.com ---> web1


This can not be changed in ISPConfig without rewriting large parts of the sourcecode. In ISPConfig every customer can have more then one website, thats why a scheme based on the user wont work.

If a client creates a database the naming of the database with CPanel can be done by the client, the user naming as well.

The naming of a database in CPanel is like this.
<username>_<client_db_name>


Is it possible to change these settings in ISPConfig so migrating from CPanel to ISPConfig can be maid possible easier?

This cant be changed in the interface, but it might be easier to change this in the sources.

[dolvito]

I'm now trying to name the database names.

I've created a site which doc_id = 2;
But how can I select the username of the site from the database?

Do you know the query which selects the username only knowing the site's doc_id?

Thanks in advance

[till]

Please have a look at this thread:

http://www.howtoforge.com/forums/showthread.php?t=3916

But be aware that every user in ISPConfig may have an unlimidet number of websites. If i remember correctly, this is not possible in plesk.

[dolvito]

i've looked into the post you referred to

but with the query in that thread you use isp_isp_user.username

what i need is sys_user.username

[dolvito]

i still haven't found how to get the sys_user.username

anyone?

[falko]

Have a look at isp_isp_kunde.webadmin_user. That's the username that is also in sys_user.