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!!!
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@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@mail.isot.com Date: Wed, 18 Mar 2009 23:22:50 -0600 To: freebsd-stable freebsd-stable@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@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-stable > To unsubscribe, send any mail to "freebsd-stable-unsubscribe@freebsd.org" >
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 squirrel@mail.isot.com Date: Wed, 18 Mar 2009 23:45:49 -0600 To: freebsd-stable freebsd-stable@freebsd.org 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/ > [root@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@mail.isot.com > Date: Wed, 18 Mar 2009 23:22:50 -0600 > To: freebsd-stable freebsd-stable@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@freebsd.org mailing list > > http://lists.freebsd.org/mailman/listinfo/freebsd-stable > > To unsubscribe, send any mail to "freebsd-stable-unsubscribe@freebsd.org" > > > _______________________________________________ > freebsd-stable@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-stable > To unsubscribe, send any mail to "freebsd-stable-unsubscribe@freebsd.org" >
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 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!!!There are db_recover tools installed with BDB but they're called db41_recover or db_recover-4.2 etc. The other error is that it doesn't appear to be able to write to /home/mysql but in your next email the perms look OK (well they are bad because 777 is insecure but they won't result in permission denied) -- 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 -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: application/pgp-signature Size: 189 bytes Desc: This is a digitally signed message part. Url : http://lists.freebsd.org/pipermail/freebsd-stable/attachments/20090319/09fec987/attachment.pgp