View Single Post
  #5  
Old 21st February 2011, 23: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