SQL-Dump during step 24 of install

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

 

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.

 

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

 

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

 

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