From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: (qmail 2213 invoked by alias); 8 May 2014 03:04:43 -0000 Mailing-List: contact cygwin-help@cygwin.com; run by ezmlm Precedence: bulk List-Id: List-Subscribe: List-Archive: List-Post: List-Help: , Sender: cygwin-owner@cygwin.com Mail-Followup-To: cygwin@cygwin.com Received: (qmail 2184 invoked by uid 89); 8 May 2014 03:04:41 -0000 Authentication-Results: sourceware.org; auth=none X-Virus-Found: No X-Spam-SWARE-Status: No, score=-1.9 required=5.0 tests=AWL,BAYES_50,RCVD_IN_DNSWL_NONE,SPAM_SUBJECT autolearn=no version=3.3.2 X-HELO: mho-01-ewr.mailhop.org Received: from mho-03-ewr.mailhop.org (HELO mho-01-ewr.mailhop.org) (204.13.248.66) by sourceware.org (qpsmtpd/0.93/v0.84-503-g423c35a) with (AES256-SHA encrypted) ESMTPS; Thu, 08 May 2014 03:04:39 +0000 Received: from pool-98-110-183-166.bstnma.fios.verizon.net ([98.110.183.166] helo=cgf.cx) by mho-01-ewr.mailhop.org with esmtpa (Exim 4.72) (envelope-from ) id 1WiEdR-000Pba-7j for cygwin@cygwin.com; Thu, 08 May 2014 03:04:37 +0000 Received: from ednor (ednor.casa.cgf.cx [192.168.187.5]) by cgf.cx (Postfix) with SMTP id 63C14600D0 for ; Wed, 7 May 2014 23:04:35 -0400 (EDT) Received: by ednor (sSMTP sendmail emulation); Wed, 07 May 2014 23:04:35 -0400 X-Mail-Handler: Dyn Standard SMTP by Dyn X-Report-Abuse-To: abuse@dyndns.com (see http://www.dyndns.com/services/sendlabs/outbound_abuse.html for abuse reporting information) X-MHO-User: U2FsdGVkX19h1zB1X6jtXm9N+1Pmu6xH Date: Thu, 08 May 2014 03:04:00 -0000 From: Christopher Faylor To: cygwin@cygwin.com Subject: Re: mysqld no longer starts Message-ID: <20140508030435.GA663@ednor.casa.cgf.cx> Reply-To: cygwin@cygwin.com Mail-Followup-To: cygwin@cygwin.com References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.20 (2009-06-14) X-SW-Source: 2014-05/txt/msg00152.txt.bz2 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