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 August 2012, 13:41
tom123 tom123 is offline
Member
 
Join Date: Feb 2012
Posts: 93
Thanks: 0
Thanked 0 Times in 0 Posts
Default multiserver: grant privileges

I was looking at installation code.
In case of multiserver, the client doesn't need full root privileges but only GRANT privilege, right?

As far as I can see, the only queries that are executed by the client to the master server, are GRANTS and INSERS to 'server' table.

A mysql user with INSERT+GRANT only privileges should be enough, right?
Reply With Quote
Sponsored Links
  #2  
Old 1st August 2012, 13:51
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,652 Times in 4,461 Posts
Default

The client has no full root priveliges as the priveliges are set for required tables and table fields, see function grant_master_database_rights in the installer_base.lib.php. If you remove priveliges, then parts of your setup will stop workinga and if you add them will become less secure. Dont mix the priveliges up that ispconfig uses with the priveliges the of root password that you enter during installation is not stored anywere.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 1st August 2012, 15:23
tom123 tom123 is offline
Member
 
Join Date: Feb 2012
Posts: 93
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Actually, none of our mysql server are accessible by root user.
We have created a ispconfigroot user that has grant, create user, and full capability on ispconfig database.

We will use this user instead root for installation and updates.
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
Migration from old multiserver to new multiserver johjoh2k Server Operation 0 11th July 2012 06:48
Multiserver setup with mysql-only server Croydon Developers' Forum 4 21st February 2011 23:04
Adding a new server (multiserver) OscarMas Installation/Configuration 9 14th October 2009 14:56
phpMyAdmin Grant Privilege problem DankSherman Programming/Scripts 7 29th February 2008 15:34
MySQL Privileges mcfly Server Operation 4 26th May 2005 20:00


All times are GMT +2. The time now is 13:05.


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