define numbers web[nnn]_ for each account

Discussion in 'Installation/Configuration' started by st2xo, Dec 30, 2008.

  1. st2xo

    st2xo New Member

    is it possible to set the web-number while creating a new web-account?
    I want to start e.g. with "web50" instead of "web1" (and would like to define special numbers for each account)?

    (possibility to change "web[WEBID]_" in Admin-Panel is known)

    Thanks and happy 2009!
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    The web numbers are values which are incremented automatically by mysql. You can set the start number in mysql before the first website is created in ISPConfig but you can not use individual numbers.
     
  3. st2xo

    st2xo New Member

    Hi Till, thank you! ... where I can set the start number in mysql?
    Didn´t found anything (obvious) neither in the admin panel nor in the ispconfig tables ...
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    In phpmyadmin, select the table isp_isp_domain, click on operations in the upper menu and change the auto increment value for the table.
     
  5. st2xo

    st2xo New Member

    you mean "isp_isp_web" - don´t you?
     
  6. st2xo

    st2xo New Member

    yes, I defined the web number in isp_isp_web and the next created web got this number.

    Unfortunately it is not possible to set mysql´s AUTO_INCREMENT value to e.g. 3, 4, 6 - and create webs with numbers 3, 4, 6 - and after the set AUTO_INCREMENT value to 5 - the next created web will be web_7
    (the web number is saved in table ´isp_isp_web´, column ´doc_id´)

    So my idea is to update all the reference columns from ´doc_id´ all over the ispconfig database, each time after "inserting" a new web number.
    My issue is to create accounts with web numbers e.g. 7,9,20,30,31,32,40,50 and than be able to insert new web accounts between that numbers (for "transfering" accounts from another server to a new server without changing the users login data)

    Has anybody already done that?
     

Share This Page