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

Damian myth at surr.co.uk
Sat Nov 12 00:30:44 UTC 2011

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.

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

More information about the mythtv-users mailing list