Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Developers' Forum

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 1st June 2009, 13:01
Croydon Croydon is offline
ISPConfig Developer
 
Join Date: Jul 2007
Location: Koblenz, Germany
Posts: 932
Thanks: 16
Thanked 262 Times in 208 Posts
Default Multiserver setup with mysql-only server

I just tried out a multiserver setup where the main host serves all the available things and a second host that is client database-only.
With this setup I recognized a problem.

If you set up a database on a database-only server you always have to enable remote access for the database as you would not be able to use it otherwise.
And as the database is not linked to a website (like it was in ispc2) you cannot automatically determine the "local" ip that is probably used to access the database.

Do you see any possibility to automatically allow access of needed ips to the database without having the client to enable remot access?

The only solution I see is to get all the ip addresses of all website-servers the client has in use and to grant access to those ips even on disabled remote access.
Reply With Quote
Sponsored Links
  #2  
Old 2nd June 2009, 10:51
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,396
Thanks: 833
Thanked 5,492 Times in 4,323 Posts
Default

Quote:
The only solution I see is to get all the ip addresses of all website-servers the client has in use and to grant access to those ips even on disabled remote access.
Yes, either that or add a website select field in the database form that makes it possible to assign a database to a specific site. Then we will have to rewrite the grant mechanism a bit as it will be better to have a (hidden) field in the database table which lists all granted IP's for each DB record as comma separated value because the database server is not able to determine the IP of a website as the website records do not get replicated to him.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 3rd June 2009, 08:28
Croydon Croydon is offline
ISPConfig Developer
 
Join Date: Jul 2007
Location: Koblenz, Germany
Posts: 932
Thanks: 16
Thanked 262 Times in 208 Posts
Default

Quote:
Originally Posted by till View Post
Yes, either that or add a website select field in the database form that makes it possible to assign a database to a specific site. Then we will have to rewrite the grant mechanism a bit as it will be better to have a (hidden) field in the database table which lists all granted IP's for each DB record as comma separated value because the database server is not able to determine the IP of a website as the website records do not get replicated to him.
Well yes, but there is one issue I see with this:
multiserver-setup, 1 mainserver, 1 webserver, 1 db server

If a client has 2 websites on 2 different servers (mainserver and db server) and just wants to use one database (on db server) it would be a problem assigning the database to only one website.
And it would be somehow complicated for the client to determine the ip addresses to enter into the remote access field (remote access limitation patch).
Reply With Quote
  #4  
Old 3rd June 2009, 09:04
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,396
Thanks: 833
Thanked 5,492 Times in 4,323 Posts
Default

Not sure if we should make it that complicated. If he wants to access the database from more then one server he can still enable external access.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 21st February 2011, 22:04
dvancamp dvancamp is offline
Junior Member
 
Join Date: Mar 2008
Location: Delray Beach, FL
Posts: 7
Thanks: 0
Thanked 1 Time in 1 Post
 
Default

I hope it's not in bad form to revive a old thread but, it's exactly the issue myself and others are grappling with this week. http://www.howtoforge.com/forums/showthread.php?t=51518

Would a dedicated MySQL server have access to a clients default_webserver as defined in the clients limits page? I noticed the default grants were all to localhost and looping through the remote IPs in:
/usr/local/ispconfig/server/plugins-available/mysql_clientdb_plugin.inc.php

In the above file on my dedicated database server I duplicated the localhost inserts, updates, etc. and added my webserver hostname. So, every time localhost gets a grant, update, delete, etc. so does the webserver. Seems to work fine in my one web server, one database server environment.

Anyway to determine the client's default_webserver and give it the grant automatically?
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
postfix problems with smtp linkdeb Server Operation 13 15th March 2014 17:58
Ubuntu Server, postfix, gmail relay sjau Server Operation 3 14th December 2010 18:20
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
LAMP System Fedora Core 6 MySQL start error gavino HOWTO-Related Questions 13 21st November 2007 19:13
Rejecting outbound mail tristanlee85 General 11 20th May 2007 17:04


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


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