On 5/18/05, Christian Hammers <[EMAIL PROTECTED]> wrote:
> Hi
>
> > > On 2005-05-13 schnitzel meister wrote:
> > > > # netstat -tpln|grep mysql
> > > > tcp 0 0 1.2.3.4:3306 0.0.0.0:* LISTEN 24002/mysqld
> > > > (1.2.3.4 is my public ip)
> ...
> > $ telnet localhost 3306
> > Trying 127.0.0.1...
> > Connected to localhost.
> > Escape character is '^]'.
> > A
> > 4.1.11-Debian_3-logUR{53?%:,5;fs.)#r8^Q\
>
> Er, wait a minute, either you forgot to cut&paste some lines from the
> netstat output or this looks self-contradicting to me. If netstat
> show mysqld as only listening on 1.2.3.4 how can you then be able
> to telnet to it on 127.0.0.1?
> Maybe you've got a stalled mysqld daemon listening there and netstat
> showed you another line where mysql is listening on 127.0.0.1:3306?
> Check the process number 24002 with "ps faxu". Or better, reboot :-)
>
> bye,
>
> -christian-
>
The problem is that the linux virtual server mysqld is running on
cheats with the loopback address so that everything really the public
ip address, which is pretty poor really.
So it's a LVS bug more than anything. Grrr!
