Config Multiserver Private IP Remote Access MySQL

Hello,

I am configuring the ISPConfig 3.2.10 application as a multiserver, where the Slave server will only serve MySQL and store the databases there.

I find myself with the problem that when I register the user of the database and MySQL, the remote access is configured with the public IP of the Master server, but I would like it to be configured with the private IP of the Master server.

This is possible?

During the configuration of the ISPConfig Slave I already make the connection and configuration to the Master through the private IP.

 

Have you read on ISPConfig documentation page articles about "ISPConfig 3 in a Multiserver- and Cluster environment"?

 

I think first you have to understand that each ISPConfig server must have its own database (though all is connected to a master ISPConfig server of course). You however should not run ISPConfig server without its own internal database.

Then, understand the database server, which is like when you want to separate websites from using the internal database in a web server, but for each of them to use database in the database server instead.

E.g. php and other files in the web server while its database is on another (database) server.

Is the above what you want to achieve?

 

Yes, that's what I have.

I already have it running, that is, I have a web server with the panel, php and its own database for ISPConfig.

Then I have another server, with an ISPConfig Slave configured and with its own database for the ISPConfig Slave, and this server is where the MySQL databases and users that I generate from the ISPConfig panel of the Master are created.

Everything works correctly, but I find that when registering the database from the ISPConfig panel, remote access is activated (which is normal because the database is generated on another server and not locally), and this remote access is activated for the Public IP of the server where the panel is located and where the web files are stored.

For security, and so as not to have the MySQL ports open to the outside, I would like to try to have this remote access done through a private IP and not a public IP.

Doing tests, I have found that in Systems -> Server configuration, here appears a field that is IP address with the public IP, and if I change it to the private IP, when registering the database again with your MySQL user, this is generated with the private IP in remote access. But I don't know if this change can affect other functions of the panel, so I want to know if this can be done during the ISPConfig configuration or what I have tried is already correct.

Thanks for everything.

 

Hello,

Thanks for your help, yes it was adding the private IPs in the hosts file of the machines.

Now the database user registrations with the private IP work for me.

Thanks again for your help.