#1  
Old 18th May 2006, 11:19
dolvito dolvito is offline
Junior Member
 
Join Date: May 2006
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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
Reply With Quote
Sponsored Links
  #2  
Old 18th May 2006, 12:16
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,486
Thanks: 813
Thanked 5,256 Times in 4,121 Posts
Default

Quote:
Originally Posted by 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
  • 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.

    Quote:
  • 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>
Quote:
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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 19th May 2006, 19:27
dolvito dolvito is offline
Junior Member
 
Join Date: May 2006
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #4  
Old 20th May 2006, 11:29
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,486
Thanks: 813
Thanked 5,256 Times in 4,121 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 22nd May 2006, 13:58
dolvito dolvito is offline
Junior Member
 
Join Date: May 2006
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #6  
Old 22nd May 2006, 16:45
dolvito dolvito is offline
Junior Member
 
Join Date: May 2006
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

anyone?
Reply With Quote
  #7  
Old 22nd May 2006, 23:24
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
 
Default

Have a look at isp_isp_kunde.webadmin_user. That's the username that is also in sys_user.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
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
cannot access ispconfig site Nu2Linux Installation/Configuration 13 3rd January 2009 15:29
ISPConfig 2.3.1-dev released till General 0 8th May 2006 22:18
SP-Server Setup - Ubuntu 5.10 "Breezy Badger" - Page 6 (changes) LuisC-SM HOWTO-Related Questions 0 21st April 2006 15:16
Users and websites aren't created Glorfindel Installation/Configuration 9 23rd February 2006 04:20
42goISP vs. ISPConfig nveid General 1 16th January 2006 09:07


All times are GMT +2. The time now is 03:32.


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