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/ [r...@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 [email protected] Date: Wed, 18 Mar 2009 23:22:50 -0600 To: freebsd-stable [email protected] 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!!! > _______________________________________________ > [email protected] mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-stable > To unsubscribe, send any mail to "[email protected]" > _______________________________________________ [email protected] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-stable To unsubscribe, send any mail to "[email protected]"
