Hi, Larry,
Thanks a lot for the reply!
On Mon, Nov 12, 2012 at 1:27 PM, Larry Martell <larry.martell@stripped>wrote:
> On Mon, Nov 12, 2012 at 2:11 PM, Tianyin Xu <tixu@stripped> wrote:
> > Hi, guys,
> >
> > I'm new to MySQL. I installed MySQL step-by-step according to the manual
> > from source code. The version is mysql-5.5.28.
> >
> > When I start the server using:
> > #bin/mysqld_safe --user=mysql
> >
> > The server failed to start with the following message in the log
> (attached
> > below).
> >
> > There're two problems according to the log messages:
> >
> > 1.
> >
> > 121112 13:00:59 [ERROR] Can't read from messagefile
> > '/usr/local/mysql/data/errmsg.sys
> >
> > I'm confused because I do have this file which is owned by user "mysql":
> >
> > #ll /usr/local/mysql/data/errmsg.sys
> > -rw-r--r-- 1 mysql mysql 0 Nov 12 12:35 /usr/local/mysql/data/errmsg.sys
>
> Check the permissions of all the dirs in that path: /usr, /usr/local,
> /usr/local/mysql, /usr/local/mysql/data. The mysql user will need r-x
> access to all of them.
>
>
I already did so. It's weird... From the log, it seems that mysqld
encountered some problem when reading the messagefile. But the file does
exist with permission.
> > 2.
> >
> > 121112 13:00:59 [ERROR] An old style --language value with language
> > specific part detected: /usr/local/mysql/data/
> >
> > I commented the "lc-messages-dir" configuration entry in the my.cnf, but
> > the error still exists...
>
> Don't know what platform you're on, but on my Mac I had this issue,
> and I got around it by starting the server with:
>
> --lc-messages-dir="/usr/local/mysql/share/"
>
I'm working on Ubuntu-12.04. Yes, the configuration parameter is set as
/usr/local/mysql/data/ (see the error message). I tried your setting but
this time mysqld tells me
121112 13:46:28 [ERROR] bin/mysqld: unknown variable
'lc-message-dir=/usr/local/mysql/share/'
121112 13:46:28 [ERROR] Aborting
What a mess...
>
> On CentOS and RHEL I did not have this issue.
>
> HTH-
> larry
>
Probably I shall go to GDB to understand what's happening here...
Great thanks!
T
--
Tianyin XU,
http://cseweb.ucsd.edu/~tixu/
