ERROR: Stopped: Database already contains some tables.

Discussion in 'Installation/Configuration' started by Taleman, Oct 13, 2017.

  1. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    I'm setting up a multiserver setup, master with everything and two name servers. The master and primary name server are OK.
    I was installing ispconfig on the second name server, but had to press control-C in the middle of the installation, after "Configuring BIND" and Configure Web Server (which I answered yes and wanted to correct).
    Now second try for the ispconfig install fails, with
    I tried running ispconfig update.php, but that can not run since the files are not yet installed.
    How to solve this?
     
  2. ztk.me

    ztk.me ISPConfig Developer ISPConfig Developer

    if there's nothing in these tables nor the server is registered yet with the master, drop da base ;)
    Code:
    mysqldump dbispconfig > always_good_to_have_backup_dbispconfig.sql
    mysql> drop database dbispconfig;
    
    you might aswell check wether the ispconfig user has been added already, you could ( aswell as dropping the database ) do that in phpmyadmins users tab and rename them first, after all's good remove them )
     
  3. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Sadly the second name server is already part of the multiserver setup. And ISPConfig monitor show it.
    And ISPConfig master already has ispsrv3 user for this host.
    I guess I can not do ispconfig uninstall since it is not completely installed on this host? Would the easy way out be to start from blank Debian 9 and do the perfect server setup again?
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    1) Do what ztk.me mentioned.
    2) Remove or rename /usr/local/ispconfig folder on the partially installed slave server.
    3) remove the record of the partially installed server from dbispconfig database (table: server) on the master.
    4) run ispconfig installer on the new slave server again.
     
    ztk.me likes this.
  5. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Thans for the good advice. Now the second name server is installed and part of the multiserver setup. :)
     
  6. AlexOn

    AlexOn New Member

  7. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Hijacking 2 year old threads, eh? This is about a multiserver install, you seem to have only one host.
    If you are installing a new ISPConfig system, I would start again from the beginning. Pay close attention to the starting conditions of the install, namely that the Ubuntu should not have anything installed or configured before ISPConfig installation.
    A good way is to install Ubuntu from scratch, following the installation instructions in the beginning of the Guide.
     
  8. AlexOn

    AlexOn New Member

    Yes, I see it too, that's the way.
     
  9. till

    till Super Moderator Staff Member ISPConfig Developer

    The error means that the database that you have chosen to install ISPConfig into exists and is not empty, but the database shall not exist before you install ISPConfig or at least if it exists, it must be empty. Either you created a database with the name dbispconfig before and inserted some tables or you ran the installer a second time on the system.
     
  10. AlexOn

    AlexOn New Member

    Yes, with a fresh server it's wor fine. Thank you.
     

Share This Page