[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.
Cheers
Damian
-------------- 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