Crash!!!

[Squirrel]

Another thing, why is the error log shows bdb?  Isn't that Berkerly DB?  I didn't think I was using it.  I went ahead and removed it, but rebooted the server.  Only thing I can think is that I've installed virtualmin few days ago before this problem started.

These are my file premissions:

/home/
drwxrwxrwx  33 mysql           mysql            1024 Mar 18 17:18 mysql
..

/home/mysql/
[root at webserver /home/mysql]# ls -la
total 143848
drwxrwxrwx  33 mysql  mysql       1024 Mar 18 17:18 .
drw-r--r--      71 felix  felix       1536 Mar 18 16:44 ..
drwxrw-rw-   2 mysql  mysql       2560 Nov 21  2007 centexhomes
drwxrw-rw-   2 mysql  mysql       2560 Oct 31  2007 centexrealtors
drwxrw-rw-   2 mysql  mysql      18432 Mar  9 15:08 devildates
drwxrw-rw-   2 mysql  mysql      14848 Feb 10  2008 dolphin
drwxrw-rw-   2 mysql  mysql       2048 Mar  3  2008 drugal2
drwxrw-rw-   2 mysql  mysql      13824 Feb 28  2008 drup
...
drwxrw-rw-   2 mysql  mysql       1024 Oct 31  2007 treasure
-rw-rw----   1 mysql  mysql       3785 Mar 18 17:18 webserver.isot.com.err
-rwxrw-rw-   1 mysql  mysql      83676 Mar 18 16:30 webserver.isot.com.err.bak
-rwxrw-rw-   1 mysql  mysql          5 Mar 17 11:27 webserver.isot.com.pid.bak
drwxrw-rw-   2 mysql  mysql       7168 Jun 11  2008 yourshows
drwxrw-rw-   2 mysql  mysql       2048 Mar 28  2008 yourshows_g2



-----Original message-----
From: Squirrel squirrel at mail.isot.com
Date: Wed, 18 Mar 2009 23:22:50 -0600
To: freebsd-stable freebsd-stable at freebsd.org
Subject: Crash!!!

> 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 denied
> 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
> 090318 17:09:52  mysqld ended
> 
> I tried db_recover, but it's not found.  HELP!!!
> _______________________________________________
> freebsd-stable at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-stable
> To unsubscribe, send any mail to "freebsd-stable-unsubscribe at freebsd.org"
>