#1  
Old 25th November 2010, 15:07
adamius adamius is offline
Junior Member
 
Join Date: Nov 2010
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default MySQL questions.

Hello!
I have a multiserver setup for ispconfig. With 2 http, 1 sql, 1 mail and a standalone panel server.

my question is why I have to have root access from all hosts to every host on the SQL part? I'm thinking (or guessing from how the install look) that you can have a different user and userpass for every "root" user on each server? so the pass won't eff everything up?

*Edit*
Also a side question what does the firewall in ISPConfig do? It seems that only a handfull of my hosts acc have it :S is it just to install what ever the standard firewall was named (omg getting senile)...

Last edited by adamius; 25th November 2010 at 15:10.
Reply With Quote
Sponsored Links
  #2  
Old 25th November 2010, 15:22
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

Quote:
my question is why I have to have root access from all hosts to every host on the SQL part? I'm thinking (or guessing from how the install look) that you can have a different user and userpass for every "root" user on each server? so the pass won't eff everything up?
That is needed for installation as only the mysql root user is able to create the new mysql users used by ispconfig. The root password for the master is not used to run ispconfig and not stored anywhere on the slaves.

Quote:
Also a side question what does the firewall in ISPConfig do? It seems that only a handfull of my hosts acc have it :S is it just to install what ever the standard firewall was named (omg getting senile)...
It does what every iprtables firewall is doing. It filters the network traffic and allows you to open / close ports.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 25th November 2010, 17:00
adamius adamius is offline
Junior Member
 
Join Date: Nov 2010
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Well I do know what the firewall *is* and does, but why does it seem like there is only one of 4installed hosts that have that, shouldnt that be apart of the guide? (regarding the multiserver setup guide on this site).

*EDIT*
And for the Mysql Question, then I can just remove the account when I feel done with the setup?

Last edited by adamius; 25th November 2010 at 17:19.
Reply With Quote
  #4  
Old 25th November 2010, 19:56
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

Quote:
Well I do know what the firewall *is* and does, but why does it seem like there is only one of 4installed hosts that have that, shouldnt that be apart of the guide? (regarding the multiserver setup guide on this site).
The firewall is enabled on that servers where you added it in ispconfig for.

Quote:
And for the Mysql Question, then I can just remove the account when I feel done with the setup?
Yes. But you will have to add it again every time when you want to install a update. So I wont remove them.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
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
CPU load locks up box. Apache or MYSQL related. crypted General 61 29th October 2010 23:16
Squirrelmail login failure Cracklefish Installation/Configuration 9 30th June 2010 21:38
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 14:58
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 10:11
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 17:04


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


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