From owner-freebsd-questions@FreeBSD.ORG Sat Apr 15 12:33:02 2006 Return-Path: X-Original-To: freebsd-questions@freebsd.org 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 A000216A403 for ; Sat, 15 Apr 2006 12:33:02 +0000 (UTC) (envelope-from m.seaman@infracaninophile.co.uk) Received: from smtp.infracaninophile.co.uk (ns0.infracaninophile.co.uk [81.187.76.162]) by mx1.FreeBSD.org (Postfix) with ESMTP id B6EEF43D46 for ; Sat, 15 Apr 2006 12:33:00 +0000 (GMT) (envelope-from m.seaman@infracaninophile.co.uk) Received: from [IPv6:::1] (localhost [IPv6:::1]) by smtp.infracaninophile.co.uk (8.13.6/8.13.6) with ESMTP id k3FCWoU7098491; Sat, 15 Apr 2006 13:32:50 +0100 (BST) (envelope-from m.seaman@infracaninophile.co.uk) Message-ID: <4440E7EC.6010205@infracaninophile.co.uk> Date: Sat, 15 Apr 2006 13:32:44 +0100 From: Matthew Seaman Organization: Infracaninophile User-Agent: Thunderbird 1.5 (X11/20060401) MIME-Version: 1.0 To: Kris Anderson References: <20060415031037.88827.qmail@web52712.mail.yahoo.com> In-Reply-To: <20060415031037.88827.qmail@web52712.mail.yahoo.com> X-Enigmail-Version: 0.94.0.0 Content-Type: multipart/signed; micalg=pgp-ripemd160; protocol="application/pgp-signature"; boundary="------------enig54FDF243C0F93E9FECB54ABB" X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-2.0.2 (smtp.infracaninophile.co.uk [IPv6:::1]); Sat, 15 Apr 2006 13:32:51 +0100 (BST) X-Spam-Status: No, score=-2.6 required=5.0 tests=BAYES_00,NO_RELAYS autolearn=ham version=3.1.1 X-Spam-Checker-Version: SpamAssassin 3.1.1 (2006-03-10) on happy-idiot-talk.infracaninophile.co.uk Cc: jekillen , freebsd-questions Subject: Re: quick solution? 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: Sat, 15 Apr 2006 12:33:02 -0000 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig54FDF243C0F93E9FECB54ABB Content-Type: text/plain; charset=ISO-8859-15 Content-Transfer-Encoding: quoted-printable Kris Anderson wrote: > --- jekillen wrote: >=20 >> Hi all; >> I had a blackout occur and the server I'm running >> overran the ups=20 >> support before I could get to it to shut it down >> cleanly. >> It has been restarted but now my MySQL server >> complains that it can't=20 >> connect through mysql.sock. Being impatient >> and lazy, I'm wondering if there is a quick >> solution. Or should I grit=20 >> my teeth and RTFM? >> I'm running FreeBSD v6.0 (as to why I'm querying >> this list). >> Is there a utility for a general inspection of the >> system and software? >> Thanks for any helpful replies. >> JK > RTFM, but... > Occasionally I get odd things happening, things not > starting up even though rc.conf has the right > information. Try starting by hand using the script in > /usr/local/etc/rc.d > If it doesn't start that way, then run the command > that actually starts mysql and see if it complains > about something missing. Before doing anything else, first read the MySQL error log -- usually in /var/db/mysql. I suspect that you need to run a repair job on some of your databases -- mysqlcheck is your friend. Once you've done that, mysql should come up smoothly. Cheers, Matthew --=20 Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard Flat 3 PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate Kent, CT11 9PW --------------enig54FDF243C0F93E9FECB54ABB Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.3 (FreeBSD) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFEQOfy8Mjk52CukIwRA1f7AJ9EfvJY+UtN23lMjA9d8mKx+ALlXgCfeg9d Gtf4KuNXWSJuGvqWNReFwE4= =dZ13 -----END PGP SIGNATURE----- --------------enig54FDF243C0F93E9FECB54ABB--