[maemo-developers] ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.so

[From: Tony Green]

On Thursday 21 Aug 2008, maemo-developers-request at maemo.org wrote:

> On Wed, 20 Aug 2008, Darius Jack wrote:
> 
> > any solution to a known problem ( a lot of entries in Google)
> > (Linux + mysql + php )
> > mysql worked worked fine, testing mysql commands
> > to create a user with select, usage privileges on a tabase.*
> > and it worked 
> > on shutdown
> > and reboot
> > can't run mysql
> > mysqld starts to run and stops, looking for a socket (none).
> 
> Im guessing the fact the unix socket is in /tmp is a problem because /tmp 
> is probably wiped during the boot process.

I don't think that's going to be the issue, as mysqld_safe (which is normally 
used to start mysqld) deletes the socket before running mysqld.

Darius, Are you trying to port MySQL yourself, or are you using my port? 
(available on the Maemo downloads page)

I have a feeling I may have had a similar problem initially and it was a 
permissions problem, though I can't remember the details (and my development 
machine is off the network at the moment, so I can't look at the build code.)

It might be worth trying my port if it's not what you're using. Failing that, 
the error log (usually /var/lib/mysql/error.log) may help.


One problem I have come across with my port, that may be relevant, is that a 
soft reboot (where you hold down the button until the tablet shuts down, then 
do the same again to bring it up) seems to leave both MySQL and Apache not 
running. My assumption is that it's actually suspending rather than shutting 
down completely and for some reason when it un-suspends it doesn't run the 
init scripts properly (or I haven't set them up right for it.) If that's your 
problem, then you can check by seeing if the mysqld proces is running or not.

I find that running "init 6" from the command line makes sure everything 
starts properly.
-- 
Tony Green
Ipswich, Suffolk, England
http://www.beermad.org.uk
http://no2id-ip.web-brewer.co.uk

** This message is digitally signed. If your email client is unable to read 
digital signatures, you may see an attachment that you cannot open. See 
http://www.gnupg.org/documentation/faqs.en.html for more information.
You can validate my PGP key from my website: http://www.beermad.org.uk/
* No Micro$oft products were used in the generation of this communication
-- 
Tony Green
Ipswich, Suffolk, England
http://www.beermad.org.uk
http://no2id-ip.web-brewer.co.uk