Having chroot Problems with MySQL

[Mark Phillips]

On Wed, Jun 2, 2010 at 6:45 AM, Mark Phillips <mark at phillipsmarketing.biz>wrote:

> I have created a 32 bit chroot (Debian Lenny) on my 64 bit Debian Squeeze
> machine. I am having a problem installing mysql into this chroot, as well as
> a problem with locales.
>
> 1. I have run dpk-reconfigure locales, answered all the questions but I
> still get locale warnings:
> perl: warning: Falling back to the standard locale ("C").
> perl: warning: Setting locale failed.
> perl: warning: Please check that your locale settings:
>     LANGUAGE = (unset),
>     LC_ALL = (unset),
>     LANG = "en_US.UTF-8"
>     are supported and installed on your system.
>
> 2. MySQL fails the configuration, but there are no error messages to say
> what is failing:
> 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
> dpkg: dependency problems prevent configuration of mysql-server:
>  mysql-server depends on mysql-server-5.0; however:
>   Package mysql-server-5.0 is not configured yet.
> dpkg: error processing mysql-server (--configure):
>  dependency problems - leaving unconfigured
> Errors were encountered while processing:
>  mysql-server-5.0
>  mysql-server
>
> I have mounted /proc and /dev/pts to the chroot. Am I missing anything
> else? I can't seem to find a good mysql chroot example on the web - many of
> them work by installing mysql and then moving it to the chroot (won't for
> for me as I have a 64 bit system) or compiling from source. i could do that,
> but I was hoping not to have to.
>
> Thanks!
>
> Mark
>

I fixed the locale problem
Within the chroot, I did this:
[orca:/]#  export LC_CTYPE=C
[orca:/]#  export LC_MESSAGES=C
[orca:/]#  export LC_ALL=C
[orca:/]#  dpkg-reconfigure locales  (for the 5th time!)
Generating locales (this might take a while)...
  en_US.ISO-8859-1... done
  en_US.ISO-8859-15... done
  en_US.UTF-8... done
Generation complete.

No more locale error messages.

I tried a purge of mysql and then a clean install, and it still fails in the
configuration process and won't start.
[orca:/]#  apt-get purge mysql-server
[orca:/]#  apt-get purge mysql-server-5.0

[orca:/]#  apt-get install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
  mysql-server-5.0
Suggested packages:
  tinyca
The following NEW packages will be installed:
  mysql-server mysql-server-5.0
0 upgraded, 2 newly installed, 0 to remove and 0 not upgraded.
Need to get 26.7MB of archives.
After this operation, 84.2MB of additional disk space will be used.
Do you want to continue [Y/n]? Y
WARNING: The following packages cannot be authenticated!
  mysql-server-5.0 mysql-server
Install these packages without verification [y/N]? y
Get:1 http://ftp.us.debian.org lenny/main mysql-server-5.0
5.0.51a-24+lenny2+spu1 [26.7MB]
Get:2 http://ftp.us.debian.org lenny/main mysql-server
5.0.51a-24+lenny2+spu1
[55.3kB]

Fetched 26.7MB in 1min16s
(349kB/s)

Preconfiguring packages ...
Selecting previously deselected package mysql-server-5.0.
(Reading database ... 12541 files and directories currently installed.)
Unpacking mysql-server-5.0 (from
.../mysql-server-5.0_5.0.51a-24+lenny2+spu1_i386.deb) ...
Selecting previously deselected package mysql-server.
Unpacking mysql-server (from
.../mysql-server_5.0.51a-24+lenny2+spu1_all.deb) ...
Processing triggers for man-db ...
Setting up mysql-server-5.0 (5.0.51a-24+lenny2+spu1) ...
Stopping MySQL database server: mysqld.
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
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-5.0; however:
  Package mysql-server-5.0 is not configured yet.
dpkg: error processing mysql-server (--configure):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 mysql-server-5.0
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

I am trying to do a clean install of 32 bit mysql inside my 32 bit lenny
chroot. There are no log messages for why this is failing, it just does!

Thanks!

Mark
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.PLUG.phoenix.az.us/pipermail/plug-discuss/attachments/20100602/dab2ab3e/attachment.htm>