From owner-freebsd-stable@FreeBSD.ORG Thu Mar 19 00:38:55 2009 Return-Path: Delivered-To: freebsd-stable@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 607F6106564A for ; Thu, 19 Mar 2009 00:38:55 +0000 (UTC) (envelope-from doconnor@gsoft.com.au) Received: from cain.gsoft.com.au (cain.gsoft.com.au [203.31.81.10]) by mx1.freebsd.org (Postfix) with ESMTP id AC9DA8FC15 for ; Thu, 19 Mar 2009 00:38:54 +0000 (UTC) (envelope-from doconnor@gsoft.com.au) Received: from inchoate.localnet (Inchoate.gsoft.com.au [203.31.81.30]) (authenticated bits=0) by cain.gsoft.com.au (8.13.8/8.13.8) with ESMTP id n2J0cqG4032992 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Thu, 19 Mar 2009 11:08:52 +1030 (CST) (envelope-from doconnor@gsoft.com.au) From: "Daniel O'Connor" To: freebsd-stable@freebsd.org Date: Thu, 19 Mar 2009 11:08:49 +1030 User-Agent: KMail/1.10.4 (Linux/2.6.27-11-generic; KDE/4.1.4; i686; ; ) References: <6a6f24080afb0b1cc84cc145b674c58c@mail.isot.com> In-Reply-To: <6a6f24080afb0b1cc84cc145b674c58c@mail.isot.com> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart10325136.byAQq9G4t3"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <200903191108.50507.doconnor@gsoft.com.au> X-Spam-Score: -3.977 () ALL_TRUSTED,BAYES_00 X-Scanned-By: MIMEDefang 2.63 on 203.31.81.10 Cc: Squirrel Subject: Re: Crash!!! X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 19 Mar 2009 00:38:55 -0000 --nextPart10325136.byAQq9G4t3 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On Thursday 19 March 2009 08:52:18 Squirrel wrote: > My webserver was working just fine on FreeBSD 6.2 Apache 2.2.11, MySQL > 5.0.27. All of sudden MySQL quit and won't start. At the same time when > logged in using SSH, it's looking for .bash_login and .bash_logout which = it > never did before, and will not chroot to user's home. > > Trying to manual start mysql causes: > > 090318 17:09:52 mysqld started > 090318 17:09:52 InnoDB: Started; log sequence number 2 2195718579 > 090318 17:09:52 [ERROR] bdb: /home/mysql: Permission denied > 090318 17:09:52 [ERROR] bdb: /home/mysql/log.0000000001: Permission deni= ed > 090318 17:09:52 [ERROR] bdb: PANIC: Permission denied > 090318 17:09:52 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run > database recovery 090318 17:09:52 [ERROR] bdb: fatal region error > detected; run recovery 090318 17:09:52 [ERROR] bdb: /home/mysql: > Permission denied > 090318 17:09:52 [ERROR] /usr/local/libexec/mysqld: Can't create/write to > file '/home/mysql/webserver.isot.com.pid' (Errcode: 13) 090318 17:09:52 > [ERROR] Can't start server: can't create PID file: Permission denied 0903= 18 > 17:09:52 mysqld ended > > I tried db_recover, but it's not found. HELP!!! There are db_recover tools installed with BDB but they're called db41_recov= er=20 or db_recover-4.2 etc. The other error is that it doesn't appear to be able to write to /home/mysq= l=20 but in your next email the perms look OK (well they are bad because 777 is= =20 insecure but they won't result in permission denied) =2D-=20 Daniel O'Connor software and network engineer for Genesis Software - http://www.gsoft.com.au "The nice thing about standards is that there are so many of them to choose from." -- Andrew Tanenbaum GPG Fingerprint - 5596 B766 97C0 0E94 4347 295E E593 DC20 7B3F CE8C --nextPart10325136.byAQq9G4t3 Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iD8DBQBJwZQa5ZPcIHs/zowRApbsAKCopGPBUpJDy8ZeHtXU4Z8oElOgOACdHRut UzmYE/Zj95BrBWlUd25sW7o= =qjTG -----END PGP SIGNATURE----- --nextPart10325136.byAQq9G4t3--