MySQL questions.

[adamius]

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)...

[till]

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.

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.

[adamius]

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?

[till]

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.

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.