homepage Welcome to WebmasterWorld Guest from 54.225.24.227
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Hardware and OS Related Technologies / Linux, Unix, and *nix like Operating Systems
Forum Library, Charter, Moderators: bakedjake

Linux, Unix, and *nix like Operating Systems Forum

    
Connect to mySQL on second box through switch
Connect to mySQL on second box through switch
xstreamva




msg:3586599
 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.

X

[edited by: engine at 12:34 pm (utc) on Feb. 29, 2008]
[edit reason] specifics obfuscated [/edit]

 

mcavic




msg:3587624
 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.

jtara




msg:3587634
 12:28 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.

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?

xstreamva




msg:3587907
 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.

jtara




msg:3588261
 6:55 pm on Feb 29, 2008 (gmt 0)

OK, as I stated previously, you will need to set-up box1 to route between the networks. It doesn't automatically do that, just because it has two NICs.

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.

xstreamva




msg:3588267
 7:04 pm on Feb 29, 2008 (gmt 0)

Sorry about that. I was just answering the questions that were posted. I'll google Linux routing.

mjwalshe




msg:3589854
 1:34 pm on Mar 3, 2008 (gmt 0)

as some some has has you need to route between the private class A to the 172.16.11.xx adresses.

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.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Hardware and OS Related Technologies / Linux, Unix, and *nix like Operating Systems
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved