On Wed, Jun 2, 2010 at 6:45 AM, Mark Phillips <mark@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