2 messages in com.mysql.lists.javaRe: Communication link failure, Debia...
FromSent OnAttachments
Søren Neigaard05 Aug 2004 01:37 
Rikard Froberg13 Aug 2004 01:18 
Subject:Re: Communication link failure, Debian and portmap?
From:Rikard Froberg (rika@bonetmail.com)
Date:08/13/2004 01:18:54 AM
List:com.mysql.lists.java

Sören,

Søren Neigaard wrote:

Hi all

Ive found this link: http://lists.mysql.com/java/7148

It seems I have the same problem, but im not sure what to do. You see the
servers communicatyion with my MySQL is not on the same server as MySQL, so I
guess the "mysqld: localhost" is not what I need, or? And is it on the MySQL
machine I should do this, or on the clients?

Also is it possible to disable this portmap thing totally, because my machines
are behind a firewall, and how do i do it?

Just for the sake of correctness, as Jeff Newmiller pointed out, it was not related to portmap. It's a UNIX/Linux thing called tcp_wrappers which is built in to the debian mysql binary. It needs to be controlled through /etc/hosts.allow on the MySQL server machine.

Something like this:

mysqld: yourClientMachineOrIP

(as an entry to the file /etc/hosts.allow )

Another possibility for you is to create an SSH tunel from the client machine to the MySQL machine. In this tunnel, port 3306 is forwarded together with the host name that is allowed in mysql.

Google for "mysql ssh tunnel port forward" or something like that to find out more on ssh and tunnelling.

Hope this helps

Rikard