Welcome to WebmasterWorld Guest from 54.167.177.207

Forum Moderators: travelin cat

Installing and Configuring mySQL on OS X 10.2.8

Problems with starting the daemon

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

10+ Year Member



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 :-)

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

WebmasterWorld Senior Member 10+ Year Member



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?

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

10+ Year Member



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.

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

WebmasterWorld Senior Member 10+ Year Member



Uhm, wait with uninstall for a second ... did ya try the startup script? Do you see mysqld in your process list after a restart?
2:42 pm on Nov 15, 2003 (gmt 0)

10+ Year Member



Yeah I gave it a go, and I've tried restarting. Nothing at all mysqld in the process list. :-/
2:48 pm on Nov 15, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



:/ uninstall :)
3:10 pm on Nov 15, 2003 (gmt 0)

10+ Year Member



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.

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

WebmasterWorld Senior Member 10+ Year Member



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*

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

WebmasterWorld Senior Member 10+ Year Member



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. :)

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

10+ Year Member



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*

:-)

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

WebmasterWorld Senior Member 10+ Year Member



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.

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

10+ Year Member



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

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

10+ Year Member



much thanks for your help yidaki :-)

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

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

WebmasterWorld Senior Member 10+ Year Member



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!

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

WebmasterWorld Senior Member macguru is a WebmasterWorld Top Contributor of All Time 10+ Year Member



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

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

WebmasterWorld Senior Member 10+ Year Member



>Your not as pretty as mivox

WHO SAYS? ;)

Love ya too MG. Thanks!

 

Featured Threads

My Threads

Hot Threads This Week

Hot Threads This Month