On Tue, 2003-01-28 at 15:40, Mike Vanecek wrote: > ---------- Original Message ----------- > From: Dave Robbins <drobbins@drobbins.net> > To: psyche-list@redhat.com > Sent: 28 Jan 2003 15:00:25 -0500 > Subject: mysql problem > > > hello all, > > > > my setup is a pentium III 800 MHz 375 MB ram > > Redhat 8.0 with everything installed > > my little home network has several machine on the 192.168.0 subnet all > > behind a linksys router with dsl to the net > > > > I've been playing with apache/php/mysql and everything is working great > > I recently came across a need to connect to mysql from a different > > machine. when I do this the connection fails. I've poored over > > documentation. I feel good that I have the permissions setup right (for > > mysql at least). After reading thru lots of list archive and trying > > lots of different things, I've boiled it down to the fact that from the > > local machine, if I "telnet 192.168.0.1 3306", mysql responds with it's > > version number, > > netstat -nat should tell you if it is listening > ps aux | grep -i mysql should tell you if the daemon is running > > > but if I do that from the remote machine, telnet exits > > immediately. this approach is ment to get around any kind of access > > issues. > > By remote machine, does this mean outside the net. If so, have you enabled dmz > or portforwarding on the linksys router? If not, the packets from the outside > will never get to the server. > > You can use iptables to monitor packets to the mysql port, something like: > > iptables -I INPUT -p tcp --dport 3306 -j LOG (you may have to check the syntax) > > will record incoming packets for that port. > > > I don't think mysql is listening on port 3306, or my networking > > setup isn't letting my machine pay attention to it. I ran mysqladmin > > variables and it looks like networking is enabled. I looked at > > /var/log/mysqld.log and all I saw was some startup information, are some > > connection logs kept someplace else? I can connect from the remote > > machine using ssh or ftp, but those are controlled by xinetd, mysqld > > runs as a standalone daemon. > ------- End of Original Message ------- > > > > > > -- > Psyche-list mailing list > Psyche-list@redhat.com > https://listman.redhat.com/mailman/listinfo/psyche-list both machines are on my local network so the router isn't the issue netstat appears to indicate mysql is listening to 0.0.0.0:3306 shouldn't it be listening on it's external address? here's the output Thanx [root@tomcat root]# netstat -nat Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address State tcp 0 0 127.0.0.1:32768 0.0.0.0:* LISTEN tcp 0 0 0.0.0.0:514 0.0.0.0:* LISTEN tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN tcp 0 0 0.0.0.0:110 0.0.0.0:* LISTEN tcp 0 0 127.0.0.1:783 0.0.0.0:* LISTEN tcp 0 0 0.0.0.0:143 0.0.0.0:* LISTEN tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN tcp 0 0 0.0.0.0:6000 0.0.0.0:* LISTEN tcp 0 0 0.0.0.0:10000 0.0.0.0:* LISTEN tcp 0 0 0.0.0.0:80 0.0.0.0:* LISTEN tcp 0 0 0.0.0.0:21 0.0.0.0:* LISTEN tcp 0 0 192.168.10.20:53 0.0.0.0:* LISTEN tcp 0 0 127.0.0.1:53 0.0.0.0:* LISTEN tcp 0 0 127.0.0.1:8118 0.0.0.0:* LISTEN tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN tcp 0 0 0.0.0.0:25 0.0.0.0:* LISTEN tcp 0 0 127.0.0.1:953 0.0.0.0:* LISTEN tcp 0 0 192.168.10.20:32867 209.228.16.158:110 TIME_WAIT tcp 0 0 192.168.10.20:110 192.168.10.20:32866 TIME_WAIT tcp 0 0 192.168.10.20:32868 192.168.10.20:110 TIME_WAIT -- Psyche-list mailing list Psyche-list@redhat.com https://listman.redhat.com/mailman/listinfo/psyche-list
