Re: mysql problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Dave Robbins writes....
> 

*snip snip*

> > netstat -nat should tell you if it is listening 
> > ps aux | grep -i mysql should tell you if the daemon is running
> > 
> > 

*snip snip*

> 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 

That makes sense, since you can
* Connect from localhost
* Telnet from localhost



> shouldn't it be listening on it's external address?

No...the port is the port.
It's the same port regardless of whether you are connecting
from localhost, a machine on your LAN (the 192.168.0.0 network),
or from the outside.

How did you setup your firewall when you installed?
High will certainly NOT let you in.  And I doubt that Medium will
either.  If I remember it correctly, medium just had the basics
in the menu.  Telnet, FTP, POP, and a couple of others.
You should probably focus on the firewall.
Maybe just turn it all off for long enough to see if that's the problem,
then turn it back on.  If that does it, then get one of the many fine
iptables gurus to tell you the exact commands to open up that port.
(Sorry.....I need to read up on iptables myself.)





> 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:*              
                    ^^^^^^^^^^^^^^

That looks fine......


> 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
> 


-- Jay Crews
jpc@jaycrews.com



-- 
Psyche-list mailing list
Psyche-list@redhat.com
https://listman.redhat.com/mailman/listinfo/psyche-list

[Index of Archives]     [Fedora General Discussion]     [Red Hat General Discussion]     [Centos]     [Kernel]     [Red Hat Install]     [Red Hat Watch]     [Red Hat Development]     [Red Hat 9]     [Gimp]     [Yosemite News]

  Powered by Linux