From owner-freebsd-questions@FreeBSD.ORG Sun Jan 3 13:44:38 2010 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id D53F21065676 for ; Sun, 3 Jan 2010 13:44:38 +0000 (UTC) (envelope-from m.seaman@infracaninophile.co.uk) Received: from smtp.infracaninophile.co.uk (gate6.infracaninophile.co.uk [IPv6:2001:8b0:151:1::1]) by mx1.freebsd.org (Postfix) with ESMTP id 364E48FC0A for ; Sun, 3 Jan 2010 13:44:38 +0000 (UTC) Received: from happy-idiot-talk.infracaninophile.co.uk (localhost [IPv6:::1]) (authenticated bits=0) by smtp.infracaninophile.co.uk (8.14.3/8.14.3) with ESMTP id o03DiVei038327; Sun, 3 Jan 2010 13:44:32 GMT (envelope-from m.seaman@infracaninophile.co.uk) X-DKIM: Sendmail DKIM Filter v2.8.3 smtp.infracaninophile.co.uk o03DiVei038327 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=infracaninophile.co.uk; s=201001-infracaninophile; t=1262526272; bh=Xv+bB5B+1ae8WK2vulZcsamuKdAsv4gY6oOxeO4Pic0=; h=Message-ID:Date:From:MIME-Version:To:CC:Subject:References: In-Reply-To:Content-Type:Cc:Content-Type:Date:From:In-Reply-To: Message-ID:Mime-Version:References:To; z=Message-ID:=20<4B409F3A.80405@infracaninophile.co.uk>|Date:=20Sun ,=2003=20Jan=202010=2013:44:26=20+0000|From:=20Matthew=20Seaman=20 |Organization:=20Infracaninophile |User-Agent:=20Thunderbird=202.0.0.23=20(X11/20091129)|MIME-Versio n:=201.0|To:=20jaymax=20|CC:=20freebsd-questio ns@freebsd.org|Subject:=20Re:=20Possible=20mysql.sock=20problem=20 |=20ERROR=202002=20(HY000)|References:=20<27001411.post@talk.nabbl e.com>|In-Reply-To:=20<27001411.post@talk.nabble.com>|X-Enigmail-V ersion:=200.95.6|Content-Type:=20multipart/signed=3B=20micalg=3Dpg p-sha256=3B=0D=0A=20protocol=3D"application/pgp-signature"=3B=0D=0 A=20boundary=3D"------------enig872BCB13C8A2DC06DBDB185A"; b=zfc+CMYWtqM/kDJA4JeJkkvL6dYnmOAsDHgrf4a3rNdUkaO8pDpgnqNwkYn+JjvOC IYUgS10hNY12/5asrinwcC2xUZWnimF9cwrhRlhks8au8RYVhfjUjbx7EpyYDxdlmC gjrMvfJ/fGlwkbzuD4mbfEBcR8MAckPkez6waVeI= X-Authentication-Warning: happy-idiot-talk.infracaninophile.co.uk: Host localhost [IPv6:::1] claimed to be happy-idiot-talk.infracaninophile.co.uk Message-ID: <4B409F3A.80405@infracaninophile.co.uk> Date: Sun, 03 Jan 2010 13:44:26 +0000 From: Matthew Seaman Organization: Infracaninophile User-Agent: Thunderbird 2.0.0.23 (X11/20091129) MIME-Version: 1.0 To: jaymax References: <27001411.post@talk.nabble.com> In-Reply-To: <27001411.post@talk.nabble.com> X-Enigmail-Version: 0.95.6 Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------enig872BCB13C8A2DC06DBDB185A" X-Virus-Scanned: clamav-milter 0.95.3 at happy-idiot-talk.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-2.6 required=5.0 tests=BAYES_00,DKIM_SIGNED, DKIM_VERIFIED,NO_RELAYS autolearn=ham version=3.2.5 X-Spam-Checker-Version: SpamAssassin 3.2.5 (2008-06-10) on happy-idiot-talk.infracaninophile.co.uk Cc: freebsd-questions@freebsd.org Subject: Re: Possible mysql.sock problem | ERROR 2002 (HY000) X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 03 Jan 2010 13:44:39 -0000 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig872BCB13C8A2DC06DBDB185A Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable jaymax wrote: > Direct start from script /usr/local/etc/rc.d/mysql-server start fails a= lso >=20 > And running /usr/local/bin/mysql =3D=3D> > ERROR 2002 (HY000): Can't connect to local MySQL server through socket > '/usr/tmp/mysql.sock' (2) >=20 There's a $mysql_socket rc.conf variable you need to set as well. > Settings in rc.conf > mysql_enable=3D"YES" > mysql_limits=3D"YES" > mysql_dbdir=3D"/disk02/db/mysql/DATA" > mysql_args=3D"" mysql_socket=3D"/usr/tmp/mysql.sock" (Although if /usr/tmp is set to mode 1777, what's the benefit of using th= at location rather than the default /tmp/mysql.sock ?) =20 > In my.cnf file > [client]=20 > socket=3D/usr/tmp/mysql.sock > [mysqld]=20 > socket=3D/usr/tmp/mysql.sock Is this the only my.cnf file on the system? There are several places where MySQL will pick up a my.cnf file: directly from the mysql_dbdir or /usr/local/etc/my.cnf [The rc.d/mysql-server script automatically adds ${mysql_dbdir}/my.cnf to the list of locations] Judging by the complaints about 'update log no longer supported' I'm guessing that there is somewhere a my.cnf or a .my.cnf file filled with configuration settings appropriate to a much earlier version of MySQL. A good strategy is to grab one of the sample .cnf files from /usr/local/share/mysql (according to the capabilities of your server) copy that into ${mysql_dbdir}/my.cnf and edit to make any local=20 customizations. Cheers, Matthew=20 --=20 Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard Flat 3 PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate Kent, CT11 9PW --------------enig872BCB13C8A2DC06DBDB185A Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.14 (FreeBSD) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEAREIAAYFAktAnz8ACgkQ8Mjk52CukIy79QCeJpmVVAs2+sW5qZrRZD8vog3i hCkAn00rStLkhiVzZkJQEP6CAosqwwrK =T6a8 -----END PGP SIGNATURE----- --------------enig872BCB13C8A2DC06DBDB185A--