HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=27)
-   -   ISPConfig 3 install problem - Unable to load sql-dump (http://www.howtoforge.com/forums/showthread.php?t=30009)

gkovacs 5th January 2009 06:48

ISPConfig 3 install problem - Unable to load sql-dump
 
I am trying to install ISPConfig 3 RC onto an Ubuntu system, following the install guide. After entering the MySQL credentials (our MySQL is on a different server) the following error happens:

Code:

ERROR: Unable to load SQL-Dump into database table.
The MySQL user does have access, as there is a successfully created database.

What might have gone wrong, and how can I solve this problem?

till 5th January 2009 08:43

Please make sure that you used the mysql root user to install ISPConfig and make sure that the database name you entered in the installer not exist already as ispconfig creates the database itself.

gkovacs 5th January 2009 18:00

Actually, I have tried it several times, with several users:

1. First time, I've created a MySQL user named "ispconfig" with all root privileges. SQL dump error.

2. Second time, I've copied the "root" user via PHPMyAdmin, with the host modified from "localhost" to the IP address of the ISPConfig host, so I have two root accounts (one is the original, new is for ISPConfig). Same error.

None of these approaches worked beyond correctly logging in and creating the "dbispconfig" database. They all stop with the SQL dump error. I've always deleted the database and flushed privileges before trying again.

I'm out of options. Any suggestions?

till 5th January 2009 18:10

1 and 2 are wrong. Delete both.

Do not create any user or database. Just start the ispconfig installer, enter the mysql root user and password and a name for the database, thats all.

gkovacs 5th January 2009 18:36

I HAVE TO create a user, since the current MySQL root user DOES NOT HAVE privileges from a remote host, only localhost.

Since our ISPConfig installation is on a different physical server, I have to arrange the privileges for it's IP address.

I DID NOT manually create any database, the installer did. However, it was unable to go any further, for a reason unknown.

Has anyone succeeded installing ISPConfig with MySQL on a different server (not localhost)?

till 5th January 2009 18:43

The mysql database should be located on the local server for performance reasons as postfix etc. is using it directly. ISPConfig cares itself on database replication if used on multiserver setups.

But in general there is no problem to use a remote host as long as you enter valid database credentials for the remote server for a suer that has root priveliges. You should test the database connection from the remote host with the mysql command:

mysql -h remote.host.tld -u root -p

if you are able to login then, it should work for ISPConfig as well.

gkovacs 5th January 2009 20:29

Turns out the problem was that I havent installed MySQL (neither server nor client) on the ISPConfig host. Installing the mysql-client package solved the issue, authentication works flawlessly.

Thanks for your help Till.


All times are GMT +2. The time now is 14:43.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.