Crash!!! -- Permission Error
squirrel at mail.isot.com
Wed Mar 18 18:06:28 PDT 2009
I'm currently re-installing db41 port. Earlier using 'innodb_force_recovery = 6' seemed to fix that PANIC error. But I don't understand this permission error. I've tried various permissions as well 777, 766, 666, 760, etc etc. I've also ran mysqld_safe as root user, but with same permission error. Also tried different directories without luck.
When I log in to the server shell, it won't chroot me to my home directory. Instead it puts me in '/' with error message "no .bash_login. And when I log out I get message "no .bash_logout". I've never had these files in any of my users' directories. Another strange thing just discovered is IE or FireFox display "Forbidden - You don't have permission to access / on this server", on all web sites.
So it seems that I have permission problem globally not just within MySQL. What can possibly cause this permission problem? Hard drive corruption?
From: "Daniel O'Connor" doconnor at gsoft.com.au
Date: Thu, 19 Mar 2009 01:39:30 -0600
To: freebsd-stable at freebsd.org
Subject: Re: Crash!!!
> 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
More information about the freebsd-stable