Migrate CPanel to ISPConfig

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

 

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

 

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

 

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

anyone?

 

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

 

This is my first post on howtoforge! Love you guys!! Anyway, thought I would contribute since I have benefited a lot from ISP config. If you want to convert to ISPconfig from cPanel here are a few steps to keep in mind. Here are the steps.

• SSH Into Terminal
• Access public_html
• Get Database Password and User-name From Config File
  • Export Database to public_html Folder
• Zip All Your Files At One Time
• ISP Config Client Tab
• Add Website in ISP Config
• Set Up Shell User in ISP Config
• SSH into New Server
• Transfer Files to New Server And Unzip Them
• Create and Import the Database
• Edit the Config File
• Point Website To New Server

This is based upon WordPress sites but the work is all the same. I wrote a complete step by step tutorial here.
How To Go From cPanel to ISPConfig
a1websitepro.com/go-cpanel-ispconfig/
I also have video instructions in there.
I hope this helps someone.