[PLUG] Having chroot Problems with MySQL and Locales
Dwight Hubbard
dwight.hubbard at efausol.com
Wed Jun 2 21:10:46 UTC 2010
If you're running a newer kernel you could run it in an lxc container and give it it's own IP address btw.
----- Original Message -----
From: "Mark Phillips" <mark at phillipsmarketing.biz>
To: "General Linux/UNIX discussion and help, civil and on-topic" <plug at lists.pdxlinux.org>
Sent: Wednesday, June 2, 2010 2:05:46 PM
Subject: Re: [PLUG] Having chroot Problems with MySQL and Locales
Problem solved. I installed syslog-ng to get better logging, and found this
once I tried to start mysql in the chroot:
Jun 2 20:58:00 orca mysqld[19435]: 100602 20:58:00 [ERROR] Can't start
server: Bind on TCP/IP port: Address already in use
The doh! moment of the day......mysql was running on the 64 bit squeeze side
of the chroot jail. Once I stopped it, mysql in the chroot had no problem
starting.
Moral of the story.....install syslog-ng to find the doh! moments...;-)
Mark
On Wed, Jun 2, 2010 at 9:05 AM, Mark Phillips <mark at phillipsmarketing.biz>wrote:
>
>
> On Wed, Jun 2, 2010 at 8:50 AM, Carlos Konstanski <
> ckonstanski at pippiandcarlos.com> wrote:
>
>> On 06/02/2010 07:46 AM, Mark Phillips 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
>>
>> In order to help you properly, I would have to try building a 32 bit
>> chroot
>> on a debian box myself.
>
>
> I installed lenny as the chroot.
>
>
>> I won't be able to do that until the weekend. So
>> here's a shot in the dark:
>>
>> First run "locale -a". Do you see en_US.utf8 in the list? Good. If not,
>> try
>> running "locale-gen" and then seeing if "locale -a" returns anything
>> different.
>>
>> Does your 32 bit filesystem contain a file /etc/default/locale? I see that
>> in my Ubuntu VM. It contains this line:
>>
>> LANG="en_US-UTF8"
>>
>> Try making it look like this:
>>
>> LANG=en_US.utf8
>> LC_CTYPE=en_US.utf8
>> LC_MESSAGES=en_US.utf8
>> LC_PAPER=en_US.utf8
>> GDM_LANG=en_US.utf8
>>
>> (Stay away from LC_ALL if possible; it is for clobbering all your LANG
>> settings in one felswoop, useful for scripts and such.)
>>
>> I don't know whether you have to run some command to make changes to this
>> file "stick". In Gentoo the file would be called /etc/env.d/02locale, and
>> you'd have to run "env-update". Try logging out and back in(to your
>> chroot),
>> and see what that does for you. Test the results by running the command
>> "locale", which will show you your current locale settings.
>>
>> But I'm not sure that having your locale set to C is a bad thing for a
>> package installation. Some builds explicitly set the locale with
>> LC_ALL="C"
>> in the makefile so that the output of the build commands will be
>> predictable
>> and parseable. Though locale is a big deal once your database is running.
>>
>
> I got rid of the local problems with some simple setting of evnironment
> variables and then running the package configuration. I posted the details
> in an earlier email. Thanks for the suggestions!
>
>>
>> As for the mysql problem, all I can suggest at the moment is to try
>> starting
>> it manually with the appropriate mysqld command. Maybe use "ps fauxw |grep
>> mysqld" to see the command line that your "good" mysql is using. Starting
>> mysql manually from a shell may cause more useful error messages to be
>> printed to stdout. There may be some debugging options to the mysqld
>> command
>> as well.
>>
>
> Running from the command line just gives the failed message. None of the
> mysql log files have anything written to them, and the users/groups and
> permissions are correct.
>
>>
>> You could locate the mysqld binary and run "file mysqld" to see if it is
>> really a 32 bit ELF executable. Though it could just as easily be a shell
>> script. Somewhere in the mysql installation there ought to be some
>> binaries
>> which would work for this test.
>>
>
> [orca:/]# file /usr/sbin/mysqld
> /usr/sbin/mysqld: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV),
> dynamically linked (uses shared libs), for GNU/Linux 2.6.8, stripped
> [orca:/]#
>
> Thanks!
>
> Mark
>
>>
>> Carlos
>> _______________________________________________
>> PLUG mailing list
>> PLUG at lists.pdxlinux.org
>> http://lists.pdxlinux.org/mailman/listinfo/plug
>>
>
>
_______________________________________________
PLUG mailing list
PLUG at lists.pdxlinux.org
http://lists.pdxlinux.org/mailman/listinfo/plug
--
Dwight Hubbard, RHCE/VCP
Systems Architect, Effective Automation Solutions Inc
Email: dwight.hubbard at efausol.coom
Phone: 503.941.0327
More information about the PLUG
mailing list