[mythtv-users] Upgraded the Ubuntu 11.10 and now Myth can't connect to MySQL

[Damian]

On 10/11/2011 11:04, Damian wrote:
> On 09/11/2011 12:00, mythtv-users-request at mythtv.org wrote:
>> Date: Tue, 08 Nov 2011 14:08:56 -0600
>> From: Bill Meek<keemllib at gmail.com>
>> Subject: Re: [mythtv-users] Upgraded the Ubuntu 11.10 and not Myth,
>>     can't connect to MySQL
>> To:mythtv-users at mythtv.org
>> Message-ID:<4EB98C58.7030603 at gmail.com>
>> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>>
>> On 11/08/2011 07:46 AM, Damian wrote:
>> ...
>>
>> Hi;
>>
>> OK, good news. I've duplicated your problem with the
>> same error messages and no response after sudo start
>> mysql.
>>
>> Go to /etc/apparmor.d and look at the file:
>>
>>    usr.sbin.mysqld
>>
>> I suspect you'll see lines like:
>>
>>     /var/run/mysqld/mysqld.pid w,
>>     /var/run/mysqld/mysqld.sock w,
>>
>> On my 11.10 system, they look like:
>>
>>     /{,var/}run/mysqld/mysqld.pid w,
>>     /{,var/}run/mysqld/mysqld.sock w,
>>
>> Because now /run exists along with /var/run.
>>
>> You may also see the same file name with .dpkg
>> at the end of it (or something like it.)
>>
>> I'm/guessing/  that when you upgraded, you were
>> asked if you wanted to install the new file and
>> you answered no.
>>
>> -- Bill
> It works!!
>
> Bill, you are a genius! Thank you so much. It was clearly only a tiny 
> problem, but you managed to find the needle in the haystack!
>
> You will be correct in how the problem was caused as well. I will have 
> clicked to keep the old file as I have other problems in the past with 
> newer files replacing my previous settings. I'm not sure what the 
> recommended plan would be there (other than /don't upgrade/ ), but 
> here are my lessons learned:
>
> 1) Only upgrade on LTS releases (and some would argue to not even do 
> that)
>
> 2) When there are differences between old and new config files during 
> an upgrade, *cut and paste the diff information* for use if there's a 
> problem at the end!!!
>
> Thanks again Bill, and that comes from all of the family too.
>
> Now I need to track back what I did along the way. I think the only 
> thing that needs 'undoing' is one of the files or folders that I 
> granted universal access to. I'll find that and get it patched back up 
> as it should be.
>
> Thanks to everyone else who helped too. It was a tricky one to find.
>
> Best wishes
> Damian
Hi all,

What is the chmod value of /var/run/mysql supposed to be? It was set to 
'o+w' during the process of getting this thing sorted, but I want 
everything back as it should be now.

Cheers
Damian
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.mythtv.org/pipermail/mythtv-users/attachments/20111112/6167a8cb/attachment.html