homepage Welcome to WebmasterWorld Guest from 107.21.163.227
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Subscribe to WebmasterWorld

Home / Forums Index / WebmasterWorld / The Macintosh Webmaster
Forum Library, Charter, Moderators: travelin cat

The Macintosh Webmaster Forum

    
Installing and Configuring mySQL on OS X 10.2.8
Problems with starting the daemon
one wild baboon




msg:979239
 1:29 pm on Nov 15, 2003 (gmt 0)

Hullo there

I'm a relatively new Mac user but I've dabbled a fair bit with various *NIX systems.

I'm trying to get mySQL to run on Jaguar and its having a bit of a spitting fit at me. I basically managed to find mysql-standard-4.0.16 and installed it through a handy .... erm .... installer. There was also an installer to allow the daemon to start on system boot which I used as well.

I'm now having problems getting the thing to work. Typical errors:


Last login: Sat Nov 15 13:07:43 on console
Welcome to Darwin!
[daybreaker:~] rmc% mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
[daybreaker:~] rmc% ps -a
PID TT STAT TIME COMMAND
411 std Ss 0:00.32 login -pf rmc
412 std S 0:00.02 -tcsh (tcsh)
414 std R+ 0:00.00 ps -a
[daybreaker:~] rmc% mysqld_safe
touch: /usr/local/mysql/data/daybreaker.mshome.net.err: Permission denied
chown: /usr/local/mysql/data/daybreaker.mshome.net.err: Permission denied
Starting mysqld daemon with databases from /usr/local/mysql/data
/usr/local/mysql/bin/mysqld_safe: /usr/local/mysql/data/daybreaker.mshome.net.err: Permission denied
rm: /tmp/mysql.sock: Operation not permitted
rm: /usr/local/mysql/data/daybreaker.mshome.net.pid: Permission denied
/usr/local/mysql/bin/mysqld_safe: /usr/local/mysql/data/daybreaker.mshome.net.err: Permission denied
tee: /usr/local/mysql/data/daybreaker.mshome.net.err: Permission denied
031115 13:22:31 mysqld ended
tee: /usr/local/mysql/data/daybreaker.mshome.net.err: Permission denied

Any one got a clue on what could be causing this?

Failing that has anyone any idea how to clean up any files and stuff mysql has installed so I can rollback and try again?

TIA :-)

 

Yidaki




msg:979240
 1:45 pm on Nov 15, 2003 (gmt 0)

Welcome to WebmasterWorld [webmasterworld.com], one wild baboon!

What bin package did you use to install MySQL - entropy's installer? If so, there's a uninstall script [entropy.ch] to remove old mysql files. Important: if you run the uninstall script DO NOT CANCEL it - be patient, it'll take a while to finish.

If you didn't use the MySQL package at entropy [entropy.ch] i'd suggest giving it a try. I never had any single problem with it.

The best thing is to use the startup script to start MySQL at start up. Since MacOSX 10.2.x has a default user mysql you won't be able to start it as another user. I guess therefor you have the permission trouble. At least i never got it working without the auto start up script. Neither been able to start nor to stop it through terminal commands.

If you use the start up script do you see the mysql server in your process list?

one wild baboon




msg:979241
 2:33 pm on Nov 15, 2003 (gmt 0)

Hi Yidaki - Thanks for the welcome and the quick reply :-)

Yeah I checked my bookmarks and its from entropy. Dunno whats gone wrong with it. The main issue appears to be permissions I think but I really don't want to mess around with them.

I'll give the uninstall script a go and start again. Thanks for pointing it out, I'd not noticed it before :-)

I'll post back and say if it all worked out.

Yidaki




msg:979242
 2:37 pm on Nov 15, 2003 (gmt 0)

Uhm, wait with uninstall for a second ... did ya try the startup script? Do you see mysqld in your process list after a restart?

one wild baboon




msg:979243
 2:42 pm on Nov 15, 2003 (gmt 0)

Yeah I gave it a go, and I've tried restarting. Nothing at all mysqld in the process list. :-/

Yidaki




msg:979244
 2:48 pm on Nov 15, 2003 (gmt 0)

:/ uninstall :)

one wild baboon




msg:979245
 3:10 pm on Nov 15, 2003 (gmt 0)

Ok reinstalled the main package again and rebooted after carrying out the config instructions on Entropy up to:


mysql test

which successfully ran mysql

on reboot i went to command line and checked if mysqld is running:


Last login: Sat Nov 15 14:59:47 on console
Welcome to Darwin!
[daybreaker:~] rmc% ps -a
PID TT STAT TIME COMMAND
436 std Ss 0:00.33 login -pf rmc
437 std S 0:00.03 -tcsh (tcsh)
443 std R+ 0:00.00 ps -a
[daybreaker:~] rmc% mysqladmin version
mysqladmin Ver 8.40 Distrib 4.0.16, for apple-darwin6.6 on powerpc
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version 4.0.16-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 2 min 10 sec

Threads: 1 Questions: 1 Slow queries: 0 Opens: 5 Flush tables: 1 Open tables: 0 Queries per second avg: 0.008
[daybreaker:~] rmc% ps -al
UID PID PPID CPU PRI NI VSZ RSS WCHAN STAT TT TIME COMMAND
0 436 435 0 31 0 14048 572 - Ss std 0:00.33 login -
501 437 436 0 31 0 5872 788 - S std 0:00.03 -tcsh (
0 446 437 0 31 0 1340 296 - R+ std 0:00.00 ps -al
[daybreaker:~] rmc%

ok, to my eye that is telling me its up and running. however not a sniff of mysqld in the active process list.

what i'm wondering is, since i installed the startup pkg when i first installed did the uninstall script remove this or is it still starting mysqld somehow?

*scratches head*

i'd think the daemon would be visible in the process list.

Yidaki




msg:979246
 3:21 pm on Nov 15, 2003 (gmt 0)

hmm ... you should see mysqld in your process list. You're sure that you didn't apply any filter to the process list?

>did the uninstall script remove this or is it still starting mysqld somehow?

go to > Macintosh HD > Library > Startup Items. See the MySQL folder there? If it's there, mysql starts at start up.

Did ya install phpMyAdmin in your Library > WebServer > Documents directory? With phpMyAdmin you can check if mysql is working as it should.

Another thing: what processes do you see in your terminal for -u mysql? You should see the daemon running under user mysql.

*scratches head too*

Yidaki




msg:979247
 3:31 pm on Nov 15, 2003 (gmt 0)

ok, i just restarted to OSX (10.2.6) to better follow what you do.

I see mysqld in my process list. If you don't ... not good.

In terminal yidaki% ps -U mysql shows that user mysql is running the mysql server. If you don't ... not good.

Please report back - i'm pretty curious. :)

one wild baboon




msg:979248
 3:35 pm on Nov 15, 2003 (gmt 0)

ok i have a folder called mysql in the startup folder so thats cool and groovy.

however (theres always a however):


[daybreaker:~] rmc% ps -ua
USER PID %CPU %MEM VSZ RSS TT STAT STARTED TIME COMMAND
root 436 0.0 0.2 14048 572 std Ss 3:00PM 0:00.33 login -pf rmc
rmc 437 0.0 0.3 5872 800 std S 3:00PM 0:00.09 -tcsh (tcsh)
root 459 0.0 0.1 1340 296 std R+ 3:27PM 0:00.00 ps -ua
[daybreaker:~] rmc% ps -ua mysql
USER PID %CPU %MEM VSZ RSS TT STAT STARTED TIME COMMAND
root 436 0.0 0.2 14048 572 std Ss 3:00PM 0:00.33 login -pf rmc
rmc 437 0.0 0.3 5872 800 std S 3:00PM 0:00.09 -tcsh (tcsh)
root 460 0.0 0.1 1340 296 std R+ 3:27PM 0:00.00 ps -ua mysql
[daybreaker:~] rmc%

that would be my login and the root that would. how odd! no mysql?

*worries about baldness due to amount of head scratching today*

:-)

Yidaki




msg:979249
 3:52 pm on Nov 15, 2003 (gmt 0)

baboon, don't make me wild :)

Would you please type exactly the following line into your terminal:

ps -U mysql

(case sensitive!)

Now, do you see a process like this

344? S 0:00.32 /usr/local/mysql-standard-4.0.13-apple-darwin6.4-powerpc/bin/mysqld

?

>worries about baldness

too late for me. lol.

one wild baboon




msg:979250
 3:55 pm on Nov 15, 2003 (gmt 0)

lolol oops windoze habits. forgot about case!


[daybreaker:~] rmc% ps -U mysql
PID TT STAT TIME COMMAND
348 ? S 0:02.27 /usr/local/mysql/bin/mysqld
[daybreaker:~] rmc%

:-D

one wild baboon




msg:979251
 3:59 pm on Nov 15, 2003 (gmt 0)

much thanks for your help yidaki :-)

(i'm sure i'll be back here soon though!)

Yidaki




msg:979252
 4:02 pm on Nov 15, 2003 (gmt 0)

hehehe, just send a $5 money check, that's fine. :)

Good luck and have fun with your OSXSQL!

>i'm sure i'll be back here soon though

hope so!

Macguru




msg:979253
 4:14 pm on Nov 15, 2003 (gmt 0)

Yidaki,

This one [store6.yimg.com] is for you.

Your not as pretty as mivox, but I am sure glad to have you around.

Thanks

Yidaki




msg:979254
 4:18 pm on Nov 15, 2003 (gmt 0)

>Your not as pretty as mivox

WHO SAYS? ;)

Love ya too MG. Thanks!

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / WebmasterWorld / The Macintosh Webmaster
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About
© Webmaster World 1996-2014 all rights reserved