Having chroot Problems with MySQL

[Mark Phillips]

On Wed, Jun 2, 2010 at 8:29 AM, Alex Dean <alex at crackpot.org> wrote:

>
> On Jun 2, 2010, at 10:12 AM, Mark Phillips wrote:
>
>
>>
>> On Wed, Jun 2, 2010 at 8:02 AM, Alex Dean <alex at crackpot.org> wrote:
>>
>> On Jun 2, 2010, at 9:35 AM, Mark Phillips wrote:
>>
>> Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
>> invoke-rc.d: initscript mysql, action "start" failed.
>> dpkg: error processing mysql-server-5.0 (--configure):
>>  subprocess post-installation script returned error exit status 1
>>
>> Check the mysql error log & syslog in your chroot to see if you can figure
>> out why MySQL failed to start.  Could be as simple as file
>> ownership/permissions.
>>
>> Looking in my chroot, there is nothing in /var/log/mysql.err,
>> /var/log/mysql.log, or /var/log/mysql. I mean no entries. I don't have a
>> syslog in the chroot /var/log area.
>>
>
> You mean the files exist, but are 0 length?

yes

> I wonder what created them.  Maybe the debian post-install scripts.

my guess, too

> Would the mysql user be able to write to those files & directories, or are
> they owned by root or some other user?
>
[orca:/]#  ls -alh /var/log
total 208K
drwxr-xr-x  6 root        root 4.0K Jun  2 14:10 .
drwxr-xr-x 13 root        root 4.0K Jun  2 00:32 ..
drwxr-xr-x  2 root        root 4.0K Jun  2 00:48 apt
-rw-r--r--  1 root        root 4.4K Jun  2 13:58 aptitude
-rw-r-----  1 root        adm    31 Jun  2 00:33 boot
-rw-r--r--  1 root        root  28K Jun  2 00:33 bootstrap.log
-rw-rw-r--  1 root        utmp    0 Jun  2 00:32 btmp
-rw-r-----  1 root        adm    31 Jun  2 00:33 dmesg
-rw-r-----  1 root        adm  116K Jun  2 15:09 dpkg.log
drwxr-s---  2 Debian-exim adm  4.0K Jun  2 04:17 exim4
-rw-r--r--  1 root        root  24K Jun  2 14:09 faillog
drwxr-xr-x  2 root        root 4.0K Jun  2 00:33 fsck
-rw-rw-r--  1 root        utmp 286K Jun  2 14:09 lastlog
drwxr-s---  2 mysql       adm  4.0K Jun  2 14:10 mysql
-rw-r-----  1 mysql       adm     0 Jun  2 15:08 mysql.err
-rw-r-----  1 mysql       adm     0 Jun  2 15:08 mysql.log
-rw-rw-r--  1 root        utmp    0 Jun  2 00:32 wtmp
[orca:/]#


>
> It looks like you have all binaries & libraries installed, but some
> post-installation tasks have failed to complete.


I agree


> You might try starting mysql yourself, and see if that gives you any more
> clues about what's wrong.


Just the same message that it failed
[orca:/]#  /etc/init.d/mysql start
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
[orca:/]#


>
>
> alex
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss at lists.plug.phoenix.az.us
> To subscribe, unsubscribe, or to change your mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.PLUG.phoenix.az.us/pipermail/plug-discuss/attachments/20100602/a9bd29da/attachment.htm>