[TriLUG] what could block port=3306?
Tom Roche
Tom_Roche at pobox.com
Sat Jan 19 06:28:46 EST 2008
So I have a testbed for an application which essentially consists of 2
LAMP boxes (call one "lane" and the other "server") behind a
router/firewall. The latter forwards 22 (only) to one of the LAMP
boxes. The 2 MySQLs need to communicate, so each box has 2 MySQL
accounts={is4clane, is4cserver}, one to talk to itself, and the other
for the other.
Simple enough, but right now one box is blocking 3306. From either
inside or outside the private network, I can do
$ ssh user at lane
...
user at lane:~$ telnet server 3306
Trying server...
Connected to server.
...
but when I
$ ssh user at server
...
user at server:~$ telnet lane 3306
Trying lane...
telnet: Unable to connect to remote host: Connection refused
Things I've checked:
* I get the same behavior whether I SSH into the network from outside,
or whether I connect physically inside the firewall.
* both boxes have the same connection to the firewall: both cable into
the same hub, which cables to the firewall.
* there are no uncommented lines in any of
{server,lane}:/etc/hosts.{allow,deny}
* both boxes are running the same 5.0.x version of MySQL installed by
the same vanilla Ubuntu Server Edition.
* both {server,lane}:/etc/mysql/my.cnf have
> # Instead of skip-networking the default is now to listen only on
> # localhost which is more compatible and is not less secure.
> bind-address = <local IP#/>
i.e. the IP# set in the box's /etc/network/interfaces
* {server,lane} can connect to {lane,server} via ssh
* mysqld is running on server and is locally connectable via
{is4cserver, is4clane}
* mysqld is running on lane and is locally connectable via {is4clane,
is4cserver}
+ mysql can connect from lane to server as is4clane
- mysql can't connect from server to lane as anything
- port=3306 appears to be blocked on lane (as noted initially)
How to fix? or what else to check?
TIA, Tom Roche <Tom_Roche at pobox.com>
More information about the TriLUG
mailing list