And if it's a file permission problem, why is it able to write *.err file on same directory?
I've set: innodb_force_recovery = 6 And now the PANIC (fatal error) is gone, but still got this permission denied: 090318 19:09:53 mysqld started InnoDB: The user has set SRV_FORCE_NO_LOG_REDO on InnoDB: Skipping log redo 090318 19:09:54 InnoDB: Started; log sequence number 0 0 InnoDB: !!! innodb_force_recovery is set to 6 !!! 090318 19:09:54 [ERROR] /usr/local/libexec/mysqld: Can't create/write to file '/home/mysql/mysqld.pid' (Errcode: 13) 090318 19:09:54 [ERROR] Can't start server: can't create PID file: Permission denied 090318 19:09:54 mysqld ended Please help... -----Original message----- From: Squirrel [email protected] Date: Wed, 18 Mar 2009 23:45:49 -0600 To: freebsd-stable [email protected] Subject: Re: Crash!!! > 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]" > _______________________________________________ [email protected] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-stable To unsubscribe, send any mail to "[email protected]"
