OESF Portables Forum

General Forums => General Discussion => Topic started by: BigO on March 22, 2004, 11:20:11 pm

Title: MySQL, not quite
Post by: BigO on March 22, 2004, 11:20:11 pm
I\'ve installed the MySQL package (the same one as in the Zaurus Feed) and there are a few things I can\'t yet work out. I can start the server, but when I try to start mysql, even as su, I get an error that /tmp/mysql.sock has not been found. (Not surprising, as it is not there, and does not seem to be anywhere else). Then I can\'t run the mysqlstop script to stop the server. Can anyone lend a hand?
Title: MySQL, not quite
Post by: offroadgeek on March 23, 2004, 01:26:24 am
what\'s the error in the mysql log?  I remember having to do something after installing mysql for it to work correctly, but I can\'t remember what it was.... I remember figuring it out from the error though.
Title: MySQL, not quite
Post by: iainshaw on March 23, 2004, 02:22:52 am
seem to remember that this was fixed by starting MySQL as user Zaurus.  Sorry, not got my Zaurus in front of me now so could be wrong
Title: MySQL, not quite
Post by: BigO on March 23, 2004, 08:29:47 pm
Hmm. This makes me think that this could be a permissions thing. The server starts up, tries to create the socket file in /tmp, fails to do so, things go blooey. Maybe? I cannot find an error log (which I would expect in the data directory, right?). I\'ll reinstall and try again (but wait first to see if anyone has any more suggestions before I do so).

Thanks for your suggestions, and thanks in general to all for this amazing site. I\'ve had lots of little problems getting this thing going, but I\'ve solved all but this one by rooting around here.

I forgot to say that this is a 5600 with the PXA250 (thank you, Amazon), the Special Kernel v. 1.3, if that makes any difference.
Title: MySQL, not quite
Post by: wuurp on March 23, 2004, 11:49:15 pm
Yes, probably a permission problem. IIRC mysql runs as daemon.  I did a chown -R daemon on mysql\'s data directory, /var/lib/mysql I think.