Re: Having chroot Problems with MySQL

Top Page
Attachments:
Message as email
+ (text/plain)
+ (text/html)
+ (text/plain)
Delete this message
Reply to this message
Author: Mark Phillips
Date:  
To: Main PLUG discussion list
Subject: Re: Having chroot Problems with MySQL
On Wed, Jun 2, 2010 at 8:29 AM, Alex Dean <> wrote:

>
> On Jun 2, 2010, at 10:12 AM, Mark Phillips wrote:
>
>
>>
>> On Wed, Jun 2, 2010 at 8:02 AM, Alex Dean <> 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 -
> To subscribe, unsubscribe, or to change your mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>

---------------------------------------------------
PLUG-discuss mailing list -
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss