What"s Wrong

Could someone please tell me what the problem is? This is what I'm
getting from the logs:


060119 21:04:43 mysqld started
060119 21:04:43 [ERROR] bdb: /opt/mysql: Permission denied
060119 21:04:43 [ERROR] bdb: /opt/mysql/log.0000000001: Permission denied
060119 21:04:43 [ERROR] bdb: PANIC: Permission denied
060119 21:04:43 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run
database recovery
060119 21:04:43 [ERROR] bdb: fatal region error detected; run recovery
060119 21:04:43 [ERROR] bdb: /opt/mysql: Permission denied
060119 21:04:44 InnoDB: Started; log sequence number 0 46747
060119 21:04:44 [ERROR] Can't init databases
060119 21:04:44 [ERROR] Aborting

060119 21:04:44 InnoDB: Starting shutdown...
060119 21:04:46 InnoDB: Shutdown completed; log sequence number 0 46747
060119 21:04:46 [Note] /usr/libexec/mysqld: Shutdown complete

060119 21:04:46 mysqld ended


It's obviously a permission problem, but opt/mysql is set as user mysql
with group mysql

Re: What"s Wrong

Christopher Smith wrote:
> Could someone please tell me what the problem is? This is what I'm
> getting from the logs:
>
>
> 060119 21:04:43 mysqld started
> 060119 21:04:43 [ERROR] bdb: /opt/mysql: Permission denied
> 060119 21:04:43 [ERROR] bdb: /opt/mysql/log.0000000001: Permission denied
> 060119 21:04:43 [ERROR] bdb: PANIC: Permission denied
> 060119 21:04:43 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run
> database recovery
> 060119 21:04:43 [ERROR] bdb: fatal region error detected; run recovery
> 060119 21:04:43 [ERROR] bdb: /opt/mysql: Permission denied
> 060119 21:04:44 InnoDB: Started; log sequence number 0 46747
> 060119 21:04:44 [ERROR] Can't init databases
> 060119 21:04:44 [ERROR] Aborting
>
> 060119 21:04:44 InnoDB: Starting shutdown...
> 060119 21:04:46 InnoDB: Shutdown completed; log sequence number 0 46747
> 060119 21:04:46 [Note] /usr/libexec/mysqld: Shutdown complete
>
> 060119 21:04:46 mysqld ended
>
>
> It's obviously a permission problem, but opt/mysql is set as user mysql
> with group mysql


I've sort of narrowed it down...mysqld_safe will run as --user=root,
just not as mysql. Please advise.

Re: What"s Wrong

Christopher Smith wrote:
> Christopher Smith wrote:
>> Could someone please tell me what the problem is? This is what I'm
>> getting from the logs:
>>
>>
>> 060119 21:04:43 mysqld started
>> 060119 21:04:43 [ERROR] bdb: /opt/mysql: Permission denied
>> 060119 21:04:43 [ERROR] bdb: /opt/mysql/log.0000000001: Permission
>> denied
>> 060119 21:04:43 [ERROR] bdb: PANIC: Permission denied
>> 060119 21:04:43 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run
>> database recovery
>> 060119 21:04:43 [ERROR] bdb: fatal region error detected; run recovery
>> 060119 21:04:43 [ERROR] bdb: /opt/mysql: Permission denied
>> 060119 21:04:44 InnoDB: Started; log sequence number 0 46747
>> 060119 21:04:44 [ERROR] Can't init databases
>> 060119 21:04:44 [ERROR] Aborting
>>
>> 060119 21:04:44 InnoDB: Starting shutdown...
>> 060119 21:04:46 InnoDB: Shutdown completed; log sequence number 0 46747
>> 060119 21:04:46 [Note] /usr/libexec/mysqld: Shutdown complete
>>
>> 060119 21:04:46 mysqld ended
>>
>>
>> It's obviously a permission problem, but opt/mysql is set as user
>> mysql with group mysql
>
>
> I've sort of narrowed it down...mysqld_safe will run as --user=root,
> just not as mysql. Please advise.


Never mind ... figured it out. I overrode permissions on the datadir.