From: Steffan A. Cline
Date: November 17 2007 7:24pm
Subject: Re: MySQL on Leopard
List-Archive: http://lists.mysql.com/mysql/210101
Message-Id: <C3648DE5.8C5DF%steffan@hldns.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: 7bit

on 11/17/07 12:05 PM, Steffan A. Cline at steffan@stripped wrote:

> on 11/17/07 8:20 AM, William Allaire at maillist2@stripped wrote:
> 
>> 
>> On Nov 17, 2007, at 4:06 AM, Steffan A. Cline wrote:
>> 
>>> Documentation for dscl is somewhat cryptic. When I was finally able
>>> to list
>>> the users I see that the usual uid and gid of 74 belongs to _mysql.
>>> What is
>>> the work around for this to change it to plain ole mysql so I can
>>> get this
>>> puppy working correctly again?
>> 
>> Steffan,
>> Why not just use _mysql where you normally use mysql as the uid/gid?
>> It would probably be easier than changing plist files from _mysql back
>> to mysql.
> 
> Well, I figured it would be prudent to make it mimic the previous method to
> make it all work correctly as it did before. Well, now I have run into a few
> strange things.
> 
> Mimicking the _mysql user works:
> 
> Phat-G5:~ steffan$ sudo su -m _mysql
> sh-3.2$ /usr/local/mysql/bin/mysqld_safe
> Starting mysqld daemon with databases from /usr/local/mysql/var
> 
> 
> Using the tip for launchd does not seem to work.
> 
> <?xml version="1.0" encoding="UTF-8"?>
> <!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN"
> "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
> <plist version="1.0">
> <dict>
>     <key>KeepAlive</key>
>     <true/>
>     <key>Label</key>
>     <string>com.mysql.mysqld</string>
>     <key>Program</key>
>     <string>/usr/local/mysql/bin/mysqld_safe</string>
>     <key>RunAtLoad</key>
>     <true/>
>     <key>UserName</key>
>     <string>_mysql</string>
>     <key>WorkingDirectory</key>
>     <string>/usr/local/mysql</string>
> </dict>
> </plist>
> 
> I get no daemon running under ps -U _mysql when I use
> sudo launchctl load -w /Library/LaunchDaemons/com.mysql.mysqld.plist
> To launch it.
> 
> Anything I am missing here?
> 
> 
> 
> Thanks
> 
> Steffan
> 
Ok,

I added a few keys to the launchd to see what the issue was.

        <key>StandardErrorPath</key>
        <string>/Library/Logs/mysqld.log</string>
        <key>StandardOutPath</key>
        <string>/Library/Logs/mysqld.log</string>


I came across this:

Starting mysqld daemon with databases from /usr/local/mysql/var
/usr/local/mysql/bin/mysqld_safe: line 426: 77090 Segmentation fault
$NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION
--datadir=$DATADIR $USER_OPTION --pid-file=$pid_file >> $err_log 2>&1
STOPPING server from pid file /usr/local/mysql/var/Phat-G5.local.pid
071117 12:21:39  mysqld ended


Is this some kind of shell error?




Thanks

Steffan

---------------------------------------------------------------
T E L  6 0 2 . 7 9 3 . 0 0 1 4 | F A X  6 0 2 . 9 7 1 . 1 6 9 4
Steffan A. Cline 
Steffan@stripped                             Phoenix, Az
http://www.ExecuChoice.net                                  USA
AIM : SteffanC          ICQ : 57234309
YAHOO : Steffan_Cline   MSN : steffan@stripped
GOOGLE: Steffan.Cline             Lasso Partner Alliance Member
---------------------------------------------------------------