SQL-Dump during step 24 of install

Discussion in 'Installation/Configuration' started by kda406, Jun 9, 2015.

  1. kda406

    kda406 New Member

    On a CentOS 6.6 install, I get the following error:
    Code:
    ERROR: Unable to load SQL-Dump into database table.
    The MySQL server is separate from the ISPConfig3 server. I am using this Perfect Server tutorial as my guide: https://www.howtoforge.com/perfect-...hp-pureftpd-postfix-dovecot-and-ispconfig3-p6
    The changes are that mysql has not been installed on the ISPConfig3 server, phpMyAdmin as been setup to point to the MySQL server. All steps through 23 (Install SquirrelMail) work.

    I can manage the MySQL server from the ISPConfig3 server's phpMyAdmin page. There are no special characters in the admin account's password.

    When I attempt to install ISPConfig3 these are the results:
    Code:
    [root@mirage3 install]# php -q install.php
    
    
    --------------------------------------------------------------------------------
    _____ ___________ _____ __ _ ____
    |_ _/ ___| ___ \ / __ \ / _(_) /__ \
    | | \ `--.| |_/ / | / \/ ___ _ __ | |_ _ __ _ _/ /
    | | `--. \ __/ | | / _ \| '_ \| _| |/ _` | |_ |
    _| |_/\__/ / | | \__/\ (_) | | | | | | | (_| | ___\ \
    \___/\____/\_| \____/\___/|_| |_|_| |_|\__, | \____/
    __/ |
    |___/
    --------------------------------------------------------------------------------
    
    
    >> Initial configuration
    
    Operating System: Redhat or compatible, unknown version.
    
    Following will be a few questions for primary configuration so be careful.
    Default values are in [brackets] and can be accepted with <ENTER>.
    Tap in "quit" (without the quotes) to stop the installer.
    
    
    Select language (en,de) [en]:
    
    Installation mode (standard,expert) [standard]: expert
    
    Full qualified hostname (FQDN) of the server, eg server1.domain.tld [mirage3.mydomain.com]:
    
    MySQL server hostname [localhost]: mirage5.mydomain.com
    
    MySQL root username [root]: admin
    
    MySQL root password []: XXXXXXXXXX
    
    MySQL database to create [dbispconfig]:
    
    MySQL charset [utf8]:
    
    The next two questions are about the internal ISPConfig database user and password.
    It is recommended to accept the defaults which are 'ispconfig' as username and a random password.
    If you use a different password, use only numbers and chars for the password.
    
    ISPConfig mysql database username [ispconfig]:
    
    ISPConfig mysql database password [aa23d297d8562e151436f8daa42e13b0]:
    
    Shall this server join an existing ISPConfig multiserver setup (y,n) [n]:
    
    ERROR: Unable to load SQL-Dump into database table.
    [root@mirage3 install]#
    Any help would be appreciated.
    Thanks,
    Kyle
     
  2. florian030

    florian030 ISPConfig Developer ISPConfig Developer

    AFAIK the installer does not work with an remote-database-server. The occur occours due to the check if the database was created - the check itself uses no remote-connection.
     
  3. kda406

    kda406 New Member

    If that is the case, why does the installer ask this:
    Code:
    MySQL server hostname [localhost]: mirage5.mydomain.com
    If seems odd to ask for the server hostname if it will only install using the localhost.
    Thanks for the reply,
    Kyle
     
  4. kda406

    kda406 New Member

    Is there a work-around for this deficiency?
    Could we perhaps do this?
    1. install MySQL on the server
    2. Install ISPConfig3
    3. Then point these files to the dedicated, backend MySQL server:
      /usr/local/ispconfig/interface/lib/config.inc.php
      /usr/local/ispconfig/server/lib/config.inc.php
      /usr/local/ispconfig/server/lib/mysql_clientdb.conf
    4. Remove MySQL from the ISPConfig3 server
    Thoughts, ideas, suggestions?
    Thanks,
    Kyle
     
  5. kda406

    kda406 New Member

    I still need to use a remote SQL server with ISPconfig. Have the developers fixed this problem yet, perhaps in 3.1?
    Thanks,
    Kyle
     

Share This Page