Multi Server ERROR: Unable to load SQL-Dump into database table

Discussion in 'Installation/Configuration' started by Maxman1850, Dec 28, 2016.

  1. Maxman1850

    Maxman1850 New Member

    Hello,

    I'm trying to setup a second server next to my existing one on Debian 6 with ISPConfig 3. When configurating the second server with ISPConfig, I constantly get the error: 'ERROR: Unable to load SQL-Dump into database table.'

    This occurs when I enter my master server information:
    Code:
    Shall this server join an existing ISPConfig multiserver setup (y,n) [n]: y
    
    MySQL master server hostname []: <hostname> 
    
    MySQL master server port []: 3306
    
    MySQL master server root username [root]:
    
    MySQL master server root password []: <password>
    
    MySQL master server database name [dbispconfig]:
    
    ERROR: Unable to load SQL-Dump into database table.
    I tried it several times and tried removing the database + user from the server, but I keep getting the same error.

    What might be the solution?

    Kind regards
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Debian 6 is really old, it might be that the mysql version is too old for ISPConfig 3.1.
     
  3. Maxman1850

    Maxman1850 New Member

    Is there a way I can check that? I'm running ISPConfig 3.0.5.4p5 on my other server. I want to get the cluster working before update the OS and ISPConfig.

    When I look at the logs, i see this:
    Code:
    [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 254: WARNING: could not read in ispconfig3.sql
    But when I log into ISPConfig on my master server, I can see my slave server already there! Does this mean that it worked..?
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Create an empty database on your server e.g. with phpmyadmin and then try to import the install/sql/ispconfig3.sql file from the ispconfig tar.gz into this empty database.
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    No, what you see there is another part of the install which worked, but the main database install on the new system failed. you will have to remove this record in the dbispconfig db, table "server" with phpmyadmin to clean it up.
     
  6. Maxman1850

    Maxman1850 New Member

    On my slave server? And then run the install.php again?
     
  7. Maxman1850

    Maxman1850 New Member

    When I do so, I get the following error:
    Code:
    ERROR: Stopped: Database already contains some tables.
     
  8. till

    till Super Moderator Staff Member ISPConfig Developer

    Create a new empty database on the server where you want to install ispconfig and then try to load the ispconfig3.sql file into that table to find out why it fails. I'm not talking about running the install script again, please just do what I suggested to get the error message. The error you posted in #7 means that you tried to load the sql dump into a database that contains tables already and not a empty new database like I suggested.
     

Share This Page