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 24th January 2011, 20:42
tucanit tucanit is offline
Junior Member
 
Join Date: Jan 2011
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Default Installation without replicate db servers

Hi. I'm installing a multiserver setup and I would like to know if it's possible to not install a slave mysql server in each server replacing each instance of database server by a ssh tunnel, so that when a php script connects to localhost:3306, is really connecting to the masterserver:3306.
The main reason for this type of installation are avoid clear mysql traffic over Internet.

Do you think this configuration would work? Other alternatives?

Thanks
Reply With Quote
Sponsored Links
  #2  
Old 24th January 2011, 21:00
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,651 Times in 4,461 Posts
Default

This will not work. It is required that every slave has its own mysql instance for ispconfig. But mysql suppports ssl encrypted connections of its own as far as I know.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
tucanit (24th January 2011)
  #3  
Old 25th January 2011, 12:10
tucanit tucanit is offline
Junior Member
 
Join Date: Jan 2011
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Ok. Thanks Till. And last, what are the mininums required privileges that must be set to the 'slaves' users?

The REPLICATION privilege only would work?

GRANT REPLICATION SLAVE ON *.* TO 'user'@'host' IDENTIFIED BY 'password' REQUIRE X509;
Reply With Quote
  #4  
Old 25th January 2011, 13:03
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,651 Times in 4,461 Posts
Default

ISPConfig uses its own replication for its internal databases, so do not activate mysql replication for them or the system will fail as this would cause conflicting records if every record gets replicated in two different ways. There is no mysql replication needed for ispconfig. If you want to install a multiserver system, just follow the multiserver guide:

http://www.howtoforge.com/installing...th-ispconfig-3
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 26th January 2011, 23:06
tucanit tucanit is offline
Junior Member
 
Join Date: Jan 2011
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
 
Default

Quote:
Originally Posted by till View Post
This will not work. It is required that every slave has its own mysql instance for ispconfig. But mysql suppports ssl encrypted connections of its own as far as I know.
Sorry but the installation script does not asks for a port to connect, and so we can not stablish a tunnel using ssh, and I doubt that php code from ispconfig can stsblish a secure connection. How can we achieve a secure connection in that case? Thanks
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
Installation issue adding slave servers kennethlmartin Installation/Configuration 1 11th October 2010 12:54
ISPConfig installation into multiple OpenVZ containers letezo Installation/Configuration 11 3rd March 2009 23:47
Unable send receive emails vassilis3 Installation/Configuration 15 19th May 2007 15:34
No SPF record. beryl Installation/Configuration 6 17th May 2007 20:52
newbie ububtu 6.0.6 error PHP binary line 816 davidsky73 Installation/Configuration 8 17th September 2006 12:51


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


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