I have:
- A Linux Mint 18.3 host machine (192.168.1.19)
- A VirtualBox Windows Server 2012 guest machine with a Joomla installation on IIS8.5+PHP7 (192.168.1.8)
- A VirtualBox Windows Server 2012 guest machine with a MySql Server 5.7 installation (192.168.1.12)
Both virtual machines have a bridge connection. How communications work:
- Linux can ping Joomla and MySql virtual machines
- Both virtual machines can ping Linux
- The virtual machines cannot ping each other (I don't know why)
- From Linux I can use a MySql client to connect to the MySql Server inside the Windows virtual machine
What I need:
- I need that Joomla (installed in the first virtual machine) uses the database installed in the second virtual machine
Any help? :)
Because the two virtual machines cannot communicate directly (why?), I thought that in the Joomla configuration.php
I could set 192.168.1.19 as the database host, and in the Linux machine I could forward all MySql connections from 192.168.1.8 to 192.168.1.12, however I don't know how to achieve it, because I've done some trials with iptables but I don't really know how to use it to realize the forwarding.