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

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 8th September 2008, 13:28
enigma enigma is offline
Junior Member
 
Join Date: Sep 2008
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default ispconfig 3 expert setup

I got version 3 working perfectly on the local server but i like the idea of it being able to use other servers for different services but there's something wrong with the Expert setup script.

When it asks you to input the location of mysql i change localhost to the location of where my mysql server is located. Then i input the username/password/database name. After the database name it does nothing execpt go back to the command line without an error.

Would it be eaiser if i copied the local database to the remote server and then specified the location?

Should the script create the database automatically even if it's not local?
Reply With Quote
Sponsored Links
  #2  
Old 8th September 2008, 13:44
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,395
Thanks: 833
Thanked 5,490 Times in 4,322 Posts
Default

Which version did you install?

Quote:
Would it be eaiser if i copied the local database to the remote server and then specified the location?
No, this wont work as you would have to change many config files manually then.

Quote:
Should the script create the database automatically even if it's not local
That depends on the options you choosed. If you choose to create the datbabase, then yes. If you chosse to create no database, then it wont create the db of course.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 8th September 2008, 13:52
enigma enigma is offline
Junior Member
 
Join Date: Sep 2008
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Is there a way from the terminal to remotely connect to a mysql database and test it as telnet says connection refused.

If my problem is related to something blocking the connection i have no clue what it could be. I've allowed the port 3306 in iptables and i can connect to mysql through phpmyadmin (although that is port 80). Would App armor be blocking it or some hidden service i'm not aware of?
Reply With Quote
  #4  
Old 8th September 2008, 14:33
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,395
Thanks: 833
Thanked 5,490 Times in 4,322 Posts
Default

Quote:
Originally Posted by enigma View Post
Is there a way from the terminal to remotely connect to a mysql database and test it as telnet says connection refused.
Use:

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

The command asks you for the password then. Make sure that you use root as username and that no database with the name that you choose for ispconfig exists on the server.

Quote:
Would App armor be blocking it or some hidden service i'm not aware of?
AppArmor should be disabled, otherweise several functions like logging in pacahe wont work.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 8th September 2008, 15:47
enigma enigma is offline
Junior Member
 
Join Date: Sep 2008
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I got the remote connection working with mysql. The mysql server wasn't setup correctly as i didn't allow host permissions from the other server. Now that i can remotely connect to mysql the ispconfig script still breaks.

Here's a screenshoot, i've taken out the username/password.
isconfig 3 is located on 87.117.197.86
Mysql server is 87.117.197.22

Any suggestions?
Attached Images
 
Reply With Quote
  #6  
Old 8th September 2008, 15:54
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,395
Thanks: 833
Thanked 5,490 Times in 4,322 Posts
Default

Which version did you install?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #7  
Old 8th September 2008, 16:18
enigma enigma is offline
Junior Member
 
Join Date: Sep 2008
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The latest beta - 3.0.0.6
Reply With Quote
  #8  
Old 8th September 2008, 16:34
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,395
Thanks: 833
Thanked 5,490 Times in 4,322 Posts
Default

Please try to install the latest SVN release. The commands to install the svn version are included in the installation guide. If this fails too, I will make a bug report and have a look at the code what may cause it to fail.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #9  
Old 8th September 2008, 16:55
enigma enigma is offline
Junior Member
 
Join Date: Sep 2008
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Tried the SVN and same issue.

If you would like root access or webmin access to the servers it can be arranged.
Reply With Quote
  #10  
Old 9th September 2008, 09:14
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,395
Thanks: 833
Thanked 5,490 Times in 4,322 Posts
 
Default

I added this to the bugtracker for review.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
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
setup a wiki through ISPConfig hvrossum General 5 12th February 2008 09:12
64bit ISPConfig / Perfect Setup CentOS 5 wpwood3 General 5 3rd December 2007 02:11
ISPConfig recommended setup for 2 identical servers clanx Installation/Configuration 4 2nd November 2007 10:11
ISPconfig intial setup pitchinnate Installation/Configuration 1 11th April 2007 09:56
Installing ISPConfig on existing setup xris Installation/Configuration 1 9th September 2006 17:21


All times are GMT +2. The time now is 07:49.


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