Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 5th January 2009, 05:48
gkovacs gkovacs is offline
Member
 
Join Date: Jan 2009
Location: Budapest, Hungary
Posts: 47
Thanks: 5
Thanked 0 Times in 0 Posts
Default 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?
Reply With Quote
Sponsored Links
  #2  
Old 5th January 2009, 07:43
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,717
Thanks: 820
Thanked 5,322 Times in 4,175 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 5th January 2009, 17:00
gkovacs gkovacs is offline
Member
 
Join Date: Jan 2009
Location: Budapest, Hungary
Posts: 47
Thanks: 5
Thanked 0 Times in 0 Posts
Default

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?
Reply With Quote
  #4  
Old 5th January 2009, 17:10
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,717
Thanks: 820
Thanked 5,322 Times in 4,175 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 5th January 2009, 17:36
gkovacs gkovacs is offline
Member
 
Join Date: Jan 2009
Location: Budapest, Hungary
Posts: 47
Thanks: 5
Thanked 0 Times in 0 Posts
Default

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)?
Reply With Quote
  #6  
Old 5th January 2009, 17:43
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,717
Thanks: 820
Thanked 5,322 Times in 4,175 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #7  
Old 5th January 2009, 19:29
gkovacs gkovacs is offline
Member
 
Join Date: Jan 2009
Location: Budapest, Hungary
Posts: 47
Thanks: 5
Thanked 0 Times in 0 Posts
 
Default

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.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
fastcgi and php with ispconfig tosser Installation/Configuration 14 18th January 2009 13:41
New ISPConfig Install nubtool Installation/Configuration 15 18th May 2008 16:46
Ispconfig Load System Problem Vakis Installation/Configuration 3 24th April 2008 18:21
httpd broken after ISPConfig install ACDII Installation/Configuration 5 21st September 2006 20:16
fastcgi and php with ispconfig tosser Tips/Tricks/Mods 3 25th June 2006 21:01


All times are GMT +2. The time now is 23:45.


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