how delete an domain and all its things

Discussion in 'Installation/Configuration' started by rutame, Jul 7, 2008.

  1. rutame

    rutame New Member

    Can i delete a domain from admin account, i mean domain, folders, etc. phisically.

    Thanks
     
  2. rutame

    rutame New Member

    I asking to myself jejeje, yes .
     
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    Empty the recycle bin.
     
  4. bolero

    bolero New Member

    I notice that when I delete a web the webid will not get reused even after emptying the recycle bin. Is there a single value in the ispconfig database where I can set this down? (I ask because we are going to transfer several servers from confixx and we want to keep the numbering scheme. Once in a while it may happen that we need to start over with a web because of wrong information typed in - in that case I would like to remove it and then reset the webid as well.)
     
  5. falko

    falko Super Moderator ISPConfig Developer

    This happens because the database tables use AUTO_INCREMENT for the doc_id column. You cannot change this.
     
  6. bolero

    bolero New Member

    Ah, right, thanks. I actually think you *can* change that. You can reset the auto_increment value in isp_isp_web and be done. I'll try that, thanks for the hint!
     
  7. falko

    falko Super Moderator ISPConfig Developer

    Yes, but you might mess up the database...
     
  8. bolero

    bolero New Member

    I might, yes.
     
  9. biobrew

    biobrew New Member

    What you should do is run a bunch of queries to see what depends on that auto_increment column first before resetting it. That way you can fix any constraints while resetting. I'm not sure how mysql does it but postgresql stores all of its dependencies | foreign | primary keys in system tables which you can query.
     
  10. bolero

    bolero New Member

    Well, the point is that I want to remove a web in ISPConfig and decrement the auto_increment, so that the next web created gets the same web_id as the deleted web, so that the paths and users don't get out of sync with the old server. Once you remove a web within ISPConfig there should be *no* reference to it anywhere in the database. So it should be safe to set the auto_increment to the desired value. I just tested this. I removed alle customers and all webs and then reset the auto_increment value in each of the isp_isp_* tables either to 1 or to a value that made sense (if there was still a record in the table). I then tested by adding a few customers and domains. Works just fine and web started again from no. 1. So, if you know what you do it just works. Just in case one needs it ...
    (falko, this is *not* the test setup where I have this bogus domain appearing - just in case you think I messed that with some kind of testing like this. ;-) That one is another testing setup and got only managed by adding and removing domains in ISPConfig and emptying the trash!)
     

Share This Page