Msg#: 3586597 posted 11:27 pm on Feb 27, 2008 (gmt 0)
Here are the details. We are trying to do this the easiest way possible:
Linux server mySQL database box1-Nic1: IP address 10.0.36.xx box1-nic2: 172.16.11.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]
Msg#: 3586597 posted 12:07 am on Feb 29, 2008 (gmt 0)
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. When you have more than one subnet, routing between them requires a good understanding of your entire network.
Msg#: 3586597 posted 11:37 am on Feb 29, 2008 (gmt 0)
The MySQL server is on Box2. Yes, a workstation connected to Box1 wants to access the MySQL server on Box2. Box1 is a webserver and is pulling data from Box2's MySQL, but we just don't know how to get to it from a workstation that only connects to Box1. We are using an Access switchboard to input data to other databases we have in the office, but have not been able to link it to the MySQL database on Box2.