#1  
Old 9th March 2010, 23:02
zetnsh zetnsh is offline
Senior Member
 
Join Date: Aug 2007
Posts: 111
Thanks: 8
Thanked 5 Times in 5 Posts
Default ISPConfig 2 or 3?

Hi there,

I am about to do a major server upgrade, involving 2 separate ISPConfig 2 installations. Each server is going to gain its own database server, and it would be nice if I could control both sets of servers from one control panel. I realise I'll probably have to recreate all the users and what have you, but is ISPConfig 3 my best bet for this?

Is there anything ISPConfig 3 can't do that v2 could?

Thanks in advance!

Neil

Neil S Hamilton
WebOutreach
Reply With Quote
Sponsored Links
  #2  
Old 10th March 2010, 08:49
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,981
Thanks: 825
Thanked 5,371 Times in 4,218 Posts
Default

Quote:
Is there anything ISPConfig 3 can't do that v2 could?
ISPConfig 3 is different from ispconfig 2. ISPConfig 3 has much more features but not nescessarily all are the same then in ispconfig 2. The only thing that comes to my mind that ispconfig 3 does not has yet is a function for users to protect folders with .htaccess trough the controlpanel.

Quote:
I realise I'll probably have to recreate all the users
If you switch to ispconfig 3, then yes. If you just migrate a ispconfig 2 install to a new server, then no.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 10th March 2010, 17:27
zetnsh zetnsh is offline
Senior Member
 
Join Date: Aug 2007
Posts: 111
Thanks: 8
Thanked 5 Times in 5 Posts
Default

I don't use the .htaccess via control panel feature so that's good! But what are it's features regarding multiple servers? Could it for example manage 2 different servers also with different database servers?

Thanks! Neil
Reply With Quote
  #4  
Old 10th March 2010, 19:48
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,981
Thanks: 825
Thanked 5,371 Times in 4,218 Posts
Default

You can manage as many servers as you want in ispconfig 3. It is required that every server runs its own mysql daemon as this is required for ispconfig itself, but you can have dedicated server mysql servers for the client databases.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 24th March 2010, 09:57
zetnsh zetnsh is offline
Senior Member
 
Join Date: Aug 2007
Posts: 111
Thanks: 8
Thanked 5 Times in 5 Posts
Default

Till, thanks for the help, but on trying it, I'm coming unstuck somewhere. I'm trying a test install on an Ubuntu 9.10 virtual machine. The problem is the server in question will have to connect to MySQL on a different machine, due to that machine's main database being a replicated copy of another one, hence I tried the install specifying a server other than localhost as the database server.

Once I'd granted privileges on that server using "WITH GRANT OPTION", the setup ran fine, but then when trying to log in to the control panel, I now get

Code:
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ispconfig'@'10.43.0.70' (using password: YES) in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 73
Now, I don't know how ISPConfig3 works internally, but I am getting, in the MySQL server's error log, an access denied message every second, whilst HTTPD is running on the ISPConfig server.

Any idea where I go from here? Do I just need to start the install again? Is there an apache module that is somehow talking directly to MySQL?

Thanks, any help appreciated!

Neil

p.s. Forgot to mention, actually subscribed to HowtoForge, for anyone who is questioning it, it's worth it just to get rid of the site adverts, and the tutorials as PDFs are really useful. Haven't tried the VMWare images yet, but will soon!

Last edited by zetnsh; 24th March 2010 at 09:59. Reason: Added information
Reply With Quote
  #6  
Old 24th March 2010, 10:16
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,981
Thanks: 825
Thanked 5,371 Times in 4,218 Posts
Default

Your type of setup is not supported, so it is possible that it will not work at all. ispconfig requires to have a mysql server on localhost for performance reasons on every node of a multiserver setup and ispconfg takes care about replicating its own databases internally.

As you installed ispconfig, did you enter the IP or the hostname of the mysql server?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #7  
Old 24th March 2010, 10:27
zetnsh zetnsh is offline
Senior Member
 
Join Date: Aug 2007
Posts: 111
Thanks: 8
Thanked 5 Times in 5 Posts
Default

Hi Till, thanks for replying.

I entered the hostname actually.

I'm wondering whether localhost would actually work. The reason I was trying to avoid running MySQL for ISPConfig on localhost was that that server when in production environment will itself needs to be a replication slave, and I wasn't sure whether creating standalone databases on a replication slave is a good idea or not.

I might well try this configuration and see if it works!

Thanks, Neil
Reply With Quote
  #8  
Old 24th March 2010, 10:30
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,981
Thanks: 825
Thanked 5,371 Times in 4,218 Posts
Default

Quote:
I'm wondering whether localhost would actually work. The reason I was trying to avoid running MySQL for ISPConfig on localhost was that that server when in production environment will itself needs to be a replication slave, and I wasn't sure whether creating standalone databases on a replication slave is a good idea or not.
As far as I know, mysql trats every database independantly, so this should not cause any problems.

ISPConfig requires that you run the database of an instance on localhost, so if you select localhost when you reinstall ispconfig, then it should work. If you use a multiserver setup, ispconfig will take care on replicating its database automatically.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #9  
Old 24th March 2010, 10:33
zetnsh zetnsh is offline
Senior Member
 
Join Date: Aug 2007
Posts: 111
Thanks: 8
Thanked 5 Times in 5 Posts
 
Default

Thanks Till, I will let you know how it goes. I think you're right about the replication actually, just need to actually *test* it!
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
ISPconfig setup - DNS, router and general access problems ingvar Installation/Configuration 6 31st July 2010 13:13
Install a Comodo InstantSSL Certificate for ISPconfig Apache, Postfix, Imap & Pop gwa7 Tips/Tricks/Mods 1 30th September 2009 18:08
Install a Comodo InstantSSL Certificate for ISPconfig Apache, Postfix, Imap & Pop gwa7 Installation/Configuration 0 10th April 2009 04:54
ISPConfig 2.3.1-dev released till General 0 8th May 2006 22:18
SP-Server Setup - Ubuntu 5.10 "Breezy Badger" - Page 6 (changes) LuisC-SM HOWTO-Related Questions 0 21st April 2006 15:16


All times are GMT +2. The time now is 11:41.


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