on 11/17/07 12:05 PM, Steffan A. Cline at [EMAIL PROTECTED] wrote:
> on 11/17/07 8:20 AM, William Allaire at [EMAIL PROTECTED] 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
[EMAIL PROTECTED] Phoenix, Az
http://www.ExecuChoice.net USA
AIM : SteffanC ICQ : 57234309
YAHOO : Steffan_Cline MSN : [EMAIL PROTECTED]
GOOGLE: Steffan.Cline Lasso Partner Alliance Member
---------------------------------------------------------------
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
