Welcome to WebmasterWorld Guest from 18.104.22.168
Forum Moderators: bakedjake
Linux server mySQL database
box1-Nic1: IP address 10.0.36.xx
box2 -nic1: 172.16.11.xx.
box1-nic2 is connected to the same switch as box2-nic1. box1-nic1 is connected to network that has a workstation trying to connect to box2.
We are unable to connect to box2. Any ideas? I'm really new to this, and I'm trying to help our IT guys out.
[edited by: engine at 12:34 pm (utc) on Feb. 29, 2008]
[edit reason] specifics obfuscated [/edit]
A machine with an IP of 10.0.36.x won't be able to talk to 172.16.11.x unless routing is set up properly.
That's not the problem here. Box1 has two NICs, one on each network.
It's really not necessary to have physically separate NICs (unless this is a security or capacity issue), but that's neither here nor there for this problem.
You'll need to set-up box1 to route between the subnets. It doesn't do that by default.
You didn't say where the MySQL server is. Box2? So, a workstation connected to Box1 wants to access the MySQL server on Box2?
Since there are some variations between Linux versions, I'd suggest you do a search on "Linux routing".
You might be able to do it with a GUI tool. If not, you will have to use command-line tools.
You can do this on the box but it would be better to connect both networks to a router to do this.
also out of the box mysql only acepts connections localy if you want to access from another host you will need to set up the access controls to allow this.