Author Topic: MySQL, not quite  (Read 2829 times)

BigO

  • Newbie
  • *
  • Posts: 17
    • View Profile
MySQL, not quite
« 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?
Zaurus 5600 (PXA250)
Standard Sharp ROM, Special Kernel 1.3
Pocketop Keyboard
250M SD Card
Socket CF WLAN Card and Modem Card
Columbia C3602-647 \"Digital Assistant\" Dorky Carry-bag

offroadgeek

  • Administrator
  • Hero Member
  • *****
  • Posts: 1419
    • View Profile
    • https://www.oesf.org
MySQL, not quite
« Reply #1 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.
Search the OESF Wiki
C1000 w/Cacko 1.23 beta (from Streamline) / 760 pdaxrom rc9 / 6000L (thanks Santa's elf!) / 5500 - OZ 3.3.5 / SIMpad SL4
1GB, 256mb SanDisk CF / 2x 1GB, 512mb, 256mb, 128mb SanDisk SD
Ambicom WL100C-CF wifi / Socket 56k CF modem / AmbiCom BT2000-CF (x2)
Pocketop keyboard, Piel Frama case (1000 & 5500), PDAir case (760 & 1000)
sip:536093@fwd.pulver.com
| OESF | ELSI | Zaurus User Group | ZaurusThemes |

iainshaw

  • Newbie
  • *
  • Posts: 2
    • View Profile
    • http://www.nqube.com
MySQL, not quite
« Reply #2 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

BigO

  • Newbie
  • *
  • Posts: 17
    • View Profile
MySQL, not quite
« Reply #3 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.
Zaurus 5600 (PXA250)
Standard Sharp ROM, Special Kernel 1.3
Pocketop Keyboard
250M SD Card
Socket CF WLAN Card and Modem Card
Columbia C3602-647 \"Digital Assistant\" Dorky Carry-bag

wuurp

  • Newbie
  • *
  • Posts: 25
    • View Profile
    • http://
MySQL, not quite
« Reply #4 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.