Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 19 Mar 2009 11:08:49 +1030
From:      "Daniel O'Connor" <doconnor@gsoft.com.au>
To:        freebsd-stable@freebsd.org
Cc:        Squirrel <squirrel@mail.isot.com>
Subject:   Re: Crash!!!
Message-ID:  <200903191108.50507.doconnor@gsoft.com.au>
In-Reply-To: <6a6f24080afb0b1cc84cc145b674c58c@mail.isot.com>
References:  <6a6f24080afb0b1cc84cc145b674c58c@mail.isot.com>

next in thread | previous in thread | raw e-mail | index | archive | help
--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--



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200903191108.50507.doconnor>