Re: MySQL server socket problem

Problem solved!

Once again, thank you NZLUGgers.

As suggested by Robin Sheat I installed mysql-server-5.5. using aptitude
which allowed me to uninstall mysql-server-5.1.

Last week I had a problem with missing mysql.h (in fact an empty
/usr/include/mysql). This was overcome by following Steve Holdaway's
suggestion of installing libmysqlclient-dev using apt-get.

However, I did not upgrade mysql-server as well and so client and server
finished up out-of-step which incurred the present problem.

How do you know whether to use dpkg, apt-get or aptitude? It looks like
aptitude is the most high level, so why not use it all the time?

Which one should I use when doing routine Debian upgrades?

Cheers

John

> John Reid schreef op wo 14-12-2011 om 16:57 [+1100]:
>> This suggests that 'unknown variable
>> 'lc-messages-dir=3D/usr/share/mysql' is
>> the source of the problem.
>>
>> But what can I do about it?
>
> That looks very much like the cause of your problem.
>
> Option the first:
>
> What version of MySQL are you running (and what debian version?)
> lc-messages-dir was added in 5.5, I wonder if you're running an older
> version somehow, but perhaps with a newer config. Hmm, do you maybe hav=
e
> mysql-server-5.1 installed, rather than mysql-server (which, in Debian
> 6, will be 5.5 or thereabouts.)
>
> Perhaps try: sudo aptitude install mysql-server. It should give you the
> option of removing mysql-server-5.1. That should be safe, but I'd take =
a
> backup first if you have data you care about, just to be sure.
>
> Option the second:
>
> Find it and nuke it from orb^W^W^W^W comment it out :)
>
> Try:
>
> sudo grep -r 'lc-messages-dir' /etc/mysql and see if anything comes up.
>
> If it does, edit the file that's in and put a '#' at the start of that
> line.
>
> If it doesn't, it might be coming from somewhere else:
> sudo grep -r 'lc-messages-dir' /etc/
> will hopefully give you something useful.
>
> If you find it and comment it out, try sudo /etc/init.d/mysql restart
> again and hopefully it'll work.
>
>
> Robin.
> _______________________________________________
> NZLUG mailing list [email protected]
> http://www.linux.net.nz/cgi-bin/mailman/listinfo/nzlug
>



_______________________________________________
NZLUG mailing list [email protected]
http://www.linux.net.nz/cgi-bin/mailman/listinfo/nzlug