DomainKey-Signature: a=rsa-sha1; c=nofws; d=sourceware.org; h=list-id
	:list-unsubscribe:list-subscribe:list-archive:list-post
	:list-help:sender:date:from:to:subject:message-id:reply-to
	:references:mime-version:content-type:in-reply-to; q=dns; s=
	default; b=BSvzDMovjVdBx89s0GFEDjEO22gIY/Xt/i/DvJ4HcB7/jBp+vnohK
	+FXF8XLdq/SOInAawQTkSi52/4pdzn+TeF/RXWeGJWRww/v14bS/L2PVcWYpn0wg
	eh5SSOnMkD+L/LeZTtuMviyHzInpb9CLATCaEm4p2aylPA+Ybp24+Q=
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Date: Wed, 7 May 2014 23:04:35 -0400
From: Christopher Faylor <cgf-use-the-mailinglist-please AT cygwin DOT com>
To: cygwin AT cygwin DOT com
Subject: Re: mysqld no longer starts
Message-ID: <20140508030435.GA663@ednor.casa.cgf.cx>
Reply-To: cygwin AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
References: <CAFHxZK+tKTR0b+ov2j_=jC4z9A64zRPQG0gNvNgx7vezqXwX0g AT mail DOT gmail DOT com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <CAFHxZK+tKTR0b+ov2j_=jC4z9A64zRPQG0gNvNgx7vezqXwX0g@mail.gmail.com>
User-Agent: Mutt/1.5.20 (2009-06-14)

On Wed, May 07, 2014 at 10:21:39AM -0500, David Blackstone wrote:
>Since my most recent upgrade, mysqld will not start any more.  I get
>the following errors:
>
>$ /usr/sbin/mysqld
>140507  9:48:28 [ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'
>140507  9:48:28 [Warning] Can't create test file
>/var/lib/mysql/USERNAME.lower-test
>140507  9:48:28 [Warning] Can't create test file
>/var/lib/mysql/USERNAME.lower-test
>/cygdrive/c/cygwin/usr/sbin/mysqld: Can't change dir to
>'/var/lib/mysql/' (Errcode: 2)
>140507  9:48:28 [ERROR] Aborting
>
>140507  9:48:28 [Note]
>
>I have been using mysqld under cygwin pretty heavily for development
>work for the last year, and never encountered this problem before.
>
>I'm not sure why it's reporting that it can't cd to /var/lib/mysql/
>... I can cd to that directory from the bash prompt.  I can also
>create the test files it is complaining it can't create.  I checked
>the mysqld executable to see if it might now be using setuid or
>something, but permissions seem normal:
>$ ls -l /usr/sbin/mysqld.exe
>-rwxr-xr-x 1 username Domain Users 9112605 Dec  6 03:24 /usr/sbin/mysqld.exe
>
>I found some references to the Can't find messagefile
>'/usr/share/mysql/errmsg.sys' error ... supposedly this can be fixed
>with a symbolic link into a /usr/share/mysql subdirectory, or by
>passing a configuration option to mysqld indicating what language to
>use.  I tried all of the suggestions I found, but continued to get the
>same message.  Even when I told mysql to look in a different directory
>besides /usr/share/mysql, it still reported it could not find this
>file in this location, and it reports the same even when this file
>exists as a symbolic link to an existing file.
>
>I did some tinkering with my LANG and LC* environment variables, but I
>don't know a whole lot about these (yet), and none of them made any
>difference.  I did notice that LANG is set to en_US.UTF-8 - I'm not
>sure if that's changed recently or not, but it looks different to me.
>I noticed that the recently upgraded base-files 4.2-2 package might
>have affected this, but I'm not sure if any of this is even related.
>I'd be happy to live without any locale variable features at all -
>tried setting LANG=C but that didn't help.
>
>I ran strace /usr/sbin/mysqld to try to see what it was doing, but
>oddly enough, when I run mysqld under strace, the problem goes away!
>The server comes up and I can connect to it, execute commands, create
>and drop databases.  Unfortunately I can't run this way all the time!

You have two (three?) different versions of cygwin1.dll on your system.

Just use the released cygwin1.dll and get rid of any old versions.

--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple