From owner-freebsd-questions Sat Mar 8 9:59:53 2003 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 7757037B401 for ; Sat, 8 Mar 2003 09:59:50 -0800 (PST) Received: from lilbuddy.antsclimbtree.com (lilbuddy.antsclimbtree.com [216.27.183.129]) by mx1.FreeBSD.org (Postfix) with ESMTP id B946343F85 for ; Sat, 8 Mar 2003 09:59:49 -0800 (PST) (envelope-from mark@antsclimbtree.com) Received: from amore.antsclimbtree.com ([192.168.1.2] helo=antsclimbtree.com) by lilbuddy.antsclimbtree.com with asmtp (TLSv1:DES-CBC3-SHA:168) (Exim 4.12) id 18ricM-000ARw-00; Sat, 08 Mar 2003 10:00:18 -0800 Date: Sat, 8 Mar 2003 09:59:49 -0800 Subject: Re: mysql323-server -- can't connect remotely Content-Type: text/plain; charset=US-ASCII; format=flowed Mime-Version: 1.0 (Apple Message framework v551) Cc: , , To: massey@rmci.net From: Mark Edwards In-Reply-To: <3462.216.222.104.2.1047079116.squirrel@webmail.velocitus.net> Message-Id: Content-Transfer-Encoding: 7bit X-Mailer: Apple Mail (2.551) 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 Okay, I figured it out. It had absolutely nothing to do with user permissions. It was, amazingly, tcpwrappers that was causing the problem. I discovered a ton of log entries like the following in my Security Output email: Mar 7 00:22:11 lilbuddy inetd[968]: refused connection from 192.168.1.1, service auth (tcp) I edited /etc/hosts.allow and uncommented ALL : ALL : allow from the top of it. Sure enough, mysql connections with a -h specified started working! Now, I couldn't quite figure out why connections where being stopped. The log entries seem to indicate it has something to do with auth, but here's the auth line from my /etc/hosts.allow: auth : ALL : allow I decided to add the following to /etc/hosts.allow: mysqld: ALL : allow That did it. It works fine now. Apparently this is normal, as I've now found some websites that mention needing to tweak /etc/hosts.allow for mysqld. I'm amazed that this isn't in the mysql manual though. Ridiculous. Perhaps this is fairly new? On Friday, March 7, 2003, at 03:18 PM, wrote: > http://www.mysql.com/doc/en/Adding_users.html > > > > > >>> I have /usr/ports/databases/mysql323-server installed, and it is up >>> and running. If I do: >>> >>> >>>> mysql -h localhost >>> Welcome to the MySQL monitor. Commands end with ; or \g. >>> Your MySQL connection id is 1 to server version: 3.23.55 >>> >>> Type 'help;' or '\h' for help. Type '\c' to clear the buffer. >>> >>> mysql> >>> >>> >>> It works fine. However, if I do: >>> >>> >>>> mysql -h lilbuddy.antsclimbtree.com >>> ERROR 2013: Lost connection to MySQL server during query >>> >> Do you have an entry for 'lilbuddy.antsclimbtree.com' in the user and >> db >> tables in your mysql database? >>> >>> That's what I get. lilbuddy.antsclimbtree.com is the hostname of the >>> server machine, and I'm doing this from that machine. >>> >>> Any idea what's wrong? Thanks! >>> >>> -- >>> Mark Edwards >>> San Francisco, CA >> >> >> >> >> To Unsubscribe: send mail to majordomo@FreeBSD.org >> with "unsubscribe freebsd-questions" in the body of the message > > > > -- Mark Edwards San Francisco, CA To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message