From owner-freebsd-questions Fri Aug 30 0:53:25 2002 Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.FreeBSD.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 5197937B401 for ; Fri, 30 Aug 2002 00:53:19 -0700 (PDT) Received: from smtp.infracaninophile.co.uk (happy-idiot-talk.infracaninophile.co.uk [81.2.69.218]) by mx1.FreeBSD.org (Postfix) with ESMTP id 326E143E4A for ; Fri, 30 Aug 2002 00:53:17 -0700 (PDT) (envelope-from m.seaman@infracaninophile.co.uk) Received: from happy-idiot-talk.infracaninophile.co.uk ([IPv6:::1]) by smtp.infracaninophile.co.uk (8.12.5/8.12.5) with ESMTP id g7U7r9mg038230; Fri, 30 Aug 2002 08:53:09 +0100 (BST) (envelope-from matthew@happy-idiot-talk.infracaninophile.co.uk) Received: (from matthew@localhost) by happy-idiot-talk.infracaninophile.co.uk (8.12.5/8.12.5/Submit) id g7U7r3D7038229; Fri, 30 Aug 2002 08:53:03 +0100 (BST) Date: Fri, 30 Aug 2002 08:53:03 +0100 From: Matthew Seaman To: Joe Lewis Cc: freebsd-questions@FreeBSD.ORG Subject: Re: MySQL Remote Connection Failure Message-ID: <20020830075303.GB37771@happy-idiot-talk.infracaninophi> References: <3D6EAF2D.60508@netzero.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3D6EAF2D.60508@netzero.net> User-Agent: Mutt/1.5.1i Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG On Thu, Aug 29, 2002 at 05:33:01PM -0600, Joe Lewis wrote: > Hello; > > I am trying to access a MySQL server remotely (the server is running on > the FreeBSD machine: > FreeBSD key.relia.net 4.6.2-RELEASE FreeBSD 4.6.2-RELEASE #0: Wed Aug > 14 21:23:26 GMT 2002 > murray@builder.freebsdmall.com:/usr/src/sys/compile/GENERIC i386 > > Now, here's the problem. On telnet'ing to localhost using port 3306, > the server responds with the version (3.23.52-log) and some encryption data. > > From a remote machine, I don't even hear back from the MySQL daemon. > Now, that doesn't strike me as a good thing. We do not have the > firewall enabled, so ipfw shouldn't have an effect. > > If we replace the 3306 port number with a perl server, I can hear back > from it all the time. Can someone please extend a pointer on how to set > up the MySQL in BSD so we can see it off-server? Please respond to > makosharktooth@netzero.net as I am not a member of this list. The mysql323-server port is linked against libwrap which sounds like a suitable candidate for causing the effects you're seeing. Check your /etc/hosts.allow file on the server machine --- the hosts_options(5) man page describes the syntax of that file. Cheers, Matthew -- Dr Matthew J Seaman MA, D.Phil. 26 The Paddocks Savill Way Marlow Tel: +44 1628 476614 Bucks., SL7 1TH UK To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message