[mythtv-users] Upgrade (Debian wheezy/sid using KDE) breaks operating Mythtv-backend installation

[Neil Salstrom]

On Mon, Aug 1, 2011 at 9:02 AM, Michael T. Dean <mtdean at thirdcontact.com> wrote:
> On 08/01/2011 11:46 AM, M D wrote:
>> My Mythtv-backend (0.24.1+ ) stopped working after an upgrade this
>> weekend. I have been exploring the issue for a day now, and found the
>> backend will work after a restart of mysql but not knowing mysql and
>> MythTV very well, I am a little tentative on what to do now and wonder
>> if someone else has a more elegant fix than just restarting mysql and
>> then the backend or a suggestion on where to look for one.
>>
>> More of the details are below, but the short version is that I think
>> that something related to an KDE/akonadi installation/upgrade changed
>> the mysql configuration, which now appears to be working for akonadi
>> on startup.  The backend at that point will not start as it does not
>> appear to be able to access its database.    (In that state, however,
>> I can still log into the database as the mythtv user. )
>>
>> I am wondering if there is a script in the mythtv installation that
>> might reset the configuration files or if I have to change something
>> manually.
>>
>> Thank you for any suggestions.

Funny, I also did a update to Wheezy this weekend (Gnome, not KDE).
Through some stupidity of my own I ended up just doing a full
reinstall after a mythconverg back up using the backup / restore
scripts.  Everything went smooth up to the point of using
mythconverge_restore.pl script.  I spent a number of hours trying to
get it working.  With no existing database I used the mc.sql script to
set up the initial database then set up the mysql mythtv user.  For
some reason I could not get the restore script to work.  It kept
throwing an error of not being able to connect to the database.
Finally after messing with the database permissions it started
working.

Maybe try granting permissions to the mythtv user again?

The issue I'm facing now is my init.d/mythtv-backend script does not
work.  I get the error:

mkdir: cannot create directory `/var/run/mythtv': Permission denied

If I make that directory and change the owner to mythtv:mythtv it gets
deleted upon a reboot.

Good luck!